SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000449
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.029329
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_addon | index | | PRIMARY | 77 | | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: brBriviumAddOns, a:0:{}
Run Time: 0.000287
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 316260
Run Time: 0.024257
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 25
Run Time: 0.000866
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE (
(post.thread_id = ? AND (post.position >= 0 AND post.position < 10) )
)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 316260
Run Time: 0.023860
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 1 | Using index condition; Using where |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,xenforo.cc.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.cc.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.cc.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.cc.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,xenforo.cc.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | xenforo.cc.post.user_id,func | 1 | Using where |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 316260
Run Time: 0.000093
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ed408152ff6a5b2f6ed33860af52ae55, , 1714778891
Run Time: 0.004026
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=316260, 1714775291,
Run Time: 0.000112
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 322888, a:65:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:133:"根据一项由伦敦大学学院领导的研究,目前在SARS-CoV-2病毒中记录的突变似乎都没有增加其传播能力。";}}i:1;s:137:"来自75个国家的1.5万多名新冠肺炎患者的病毒基因组分析已发表在预印本bioRxiv上,尚未经过同行评审。
";i:2;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:90:"https://rdimg.com/proxy/https://static.cnbetacdn.com/article/2020/0526/60143dc298b92b0.jpg";}}}}i:3;s:2:"
";i:4;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:260:"这一发现基于本月早些时候发表在《感染、遗传学与进化》杂志上的一项经过同行评议的研究,该研究描述了SARS-CoV-2基因组中出现的多样性模式。SARS-CoV-2是导致新冠肺炎疾病持续流行的冠状病毒。";}}i:5;s:2:"
";i:6;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:304:"该研究的第一作者、伦敦大学学院遗传学研究所的弗朗索瓦•巴洛克斯教授说:“随着越来越多的突变被记录在案,科学家们正迅速试图找出其中任何一种突变是否会使病毒更具传染性或更致命,因为尽早了解这些变化至关重要。”";}}i:7;s:2:"
";i:8;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:180:"“我们采用了一种新技术,来确定带有新突变的病毒是否真的以更高的速率传播,结果发现,所有的候选突变似乎都没有对病毒有利。”";}}i:9;s:2:"
";i:10;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:330:"新冠病毒与其它RNA病毒一样,可以通过三种不同的方式产生突变:错误复制病毒复制过程中的错误,通过与感染同一细胞的其他病毒相互作用(重组或重配),或者它们可以被当做宿主免疫一部分的宿主RNA修饰系统诱导(例如,人自身的免疫系统)。";}}i:11;s:2:"
";i:12;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:153:"大多数突变是中性的,而其它突变则对病毒有利或有害。中性突变和有利突变在传给后代病毒时都可能变得更常见。";}}i:13;s:2:"
";i:14;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:356:"来自伦敦大学学院、Cirad和留尼旺大学以及牛津大学的研究团队,迄今为止已经在全球数据集中识别出了6822个SARS-CoV-2突变。对于其中273个突变,强有力的证据表明它们是重复独立发生的。在这些突变中,研究人员仔细研究了31个在大流行过程中至少独立发生10次的突变。";}}i:15;s:2:"
";i:16;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:321:"为了测试突变是否增加了携带突变的病毒的传播能力,研究人员对病毒的进化树进行了建模,并分析了特定突变在进化树的给定分支内是否变得越来越普遍,即测试突变后是否首先是在病毒中发展,该病毒的后代胜过不携带它的密切相关个体。";}}i:17;s:2:"
";i:18;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:204:"研究人员发现,没有任何证据表明,任何常见的突变都增加了病毒的传播能力。相反,他们发现一些常见的突变是中性的,但大多数对病毒是轻度有害的。";}}i:19;s:2:"
";i:20;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:141:"研究人员发现,大多数常见的突变似乎是由人类免疫系统引起的,而不是病毒适应其新的人类宿主的结果。";}}i:21;s:2:"
";i:22;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:266:"第一作者Lucy van Dorp博士 (伦敦大学学院的遗传学研究所)说:“只能预料,随着病毒在人类中越来越普遍,病毒会发生变异并最终分化为不同的谱系,但这并不一定意味着会出现更易传播或有害的谱系。”";}}i:23;s:2:"
";i:24;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:38:"D614G突变使新冠更具传染性?";}}}}i:25;s:2:"
";i:26;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:224:"研究人员分析的突变包括一种名为D614G的病毒突刺蛋白,它被广泛报道为一种常见的突变,可能使病毒更具传染性。新的证据发现,这种突变实际上与病毒传播增加无关。";}}i:27;s:2:"
";i:28;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:205:"来自新墨西哥州洛斯阿拉莫斯国家实验室的一项未经同行评议的初步研究表明,一种包含特定突变(位于S蛋白D614G上)的COVID-19链正在成为该病毒的主要形式。";}}i:29;s:2:"
";i:30;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:126:"美国团队的研究分析了来自英国冠状病毒患者的数据,也表明这种变异可能使病毒更具传染性。";}}i:31;s:2:"
";i:32;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:66:"但专家们说,问题是这项研究没有揭示任何证据。";}}i:33;s:2:"
";i:34;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:247:"多伦多总医院的传染病专家、多伦多大学的教员艾萨克·博格赫(Isaac Bogoch)博士说,“从科学研究中确实没有证据表明,这种特定的突变导致这种病毒比其他病毒的遗传变异更具传染性。”";}}i:35;s:2:"
";i:36;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:69:"“会发生突变吗?会的。它会带来什么?谁知道。”";}}i:37;s:2:"
";i:38;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:144:"突变在自然界中很常见,无论是病毒还是其他生物体内,当细胞在复制阶段出现“错误”时,突变就会发生。";}}i:39;s:2:"
";i:40;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:111:"虽然一些突变可以使病毒更强,但另一些突变可能使病毒更弱。大多数什么都不做。";}}i:41;s:2:"
";i:42;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:228:"哥伦比亚儿童医院临床研究员斯里尼瓦斯·穆尔蒂博士说:“病毒会变异,这就是它们的作用,它们只是随着时间的推移而变化。”他补充说,并不关心美国的这一研究结果。";}}i:43;s:2:"
";i:44;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:189:"“说实话,我没有从中学到什么……我们从这项研究中没有数据表明病毒的传染性是不同的,我们也没有数据表明病毒的严重性有任何不同。”";}}i:45;s:2:"
";i:46;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:197:"Art Poon是位于安大略省伦敦的西方大学的健康科学副教授和病毒进化专家。他说,人们通常害怕突变,因为他们认为这个词的意思是一种奇怪的缺陷。";}}i:47;s:2:"
";i:48;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:161:"“当人们听到变异时,第一反应会想到X战警,是不是?”Poon表示,“但重要的是要记住,大多数突变不会起任何作用。”";}}i:49;s:2:"
";i:50;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:104:"Poon说,D614G之所以受到如此多的关注,是因为它在COVID-19基因组中的流行程度。";}}i:51;s:2:"
";i:52;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:191:"科学家们认为,这种突变是在2月初引入欧洲的,Poon补充说,它可能“从一个祖先那里遗传而来,而这个祖先恰好是最早离开中国的血统之一。”";}}i:53;s:2:"
";i:54;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:131:"这就意味着D614G的突变在技术上并不是新的,因为在美国和加拿大的大多数病例都可能来自这条链。";}}i:55;s:2:"
";i:56;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:197:"即使加拿大的第一例COVID-19病例来自没有携带D614G突变的原始病毒,Poon说,一旦病毒从欧洲流传进来,北美很快就会有携带这种突变病毒的病例流入。";}}i:57;s:2:"
";i:58;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:175:"他说:“但这并不是因为选择了人传人,而是由于我们所说的‘始祖效应’——在欧洲发现这种流行病的谱系碰巧携带了这种突变。”";}}i:59;s:2:"
";i:60;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:93:"博格赫说,突变实际上可以帮助我们更好地了解病毒,找到它的起源。";}}i:61;s:2:"
";i:62;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:111:"“它们就像病毒的指纹。”他说,“这些突变有很多有用的信息可以帮助科学家。”";}}i:63;s:2:"
";i:64;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:155:"虽然基因突变可能会给疫苗开发带来问题,但专家表示,没有证据表明D614G会导致研究人员放弃任何已经完成的工作。";}}}, 1621686945, 1714775291
Run Time: 0.005253