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.005711
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.000331
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.000362
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.000329
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: b4a39ca3f4a211061b628467994b5a55, 1716011021
Run Time: 0.000201
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000151
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: 368826
Run Time: 0.001098
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.000596
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: 368826
Run Time: 0.008198
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: 368826
Run Time: 0.000085
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'b4a39ca3f4a211061b628467994b5a55')
Params: 1716014621
Run Time: 0.005261
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=368826, 1716011021,
Run Time: 0.003159
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, 375462, a:25:{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:183:"Moderna首席执行官Stephan Bancel在本周早些时候的一次小组讨论中表示,新冠病毒永远不会消失。“我们认为,我们将永远与这种病毒共存,”";}}i:1;s:190:"他说。另外,一项模拟COVID-19大流行演化的新研究表示,这种疾病确实会成为地方性疾病,但这种病毒未来“可能不会比普通感冒更具毒性”。
";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:"url";s:6:"option";s:77:"https://n.sinaimg.cn/tech/crawl/88/w1080h608/20201222/e452-kfnaptu9024468.jpg";s:8:"original";a:2:{i:0;s:85:"[URL='https://n.sinaimg.cn/tech/crawl/88/w1080h608/20201222/e452-kfnaptu9024468.jpg']";i:1;s:6:"[/URL]";}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:77:"https://n.sinaimg.cn/tech/crawl/88/w1080h608/20201222/e452-kfnaptu9024468.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:233:"研究人员表示,COVID-19感染将主要发生在儿童时期,这可能会导致成年后长期免受严重病例的侵袭,即使再次感染仍将有可能。唯一的警告是,最初的儿童版疾病必须是轻微的。";}}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:439:"我们在大流行早期就听到了世卫组织研究人员和安东尼-福奇博士的这一预测:新冠病毒不可能被根除,无论疫苗多么有效。相反,我们将不得不学会与这种疾病共存,因为它从大流行过渡到地方病阶段。同样的事情也发生在流感和其他传染病上,它们会循环并导致疾病爆发。但疫苗和改进的疗法已经大大降低了这些疾病的死亡率。";}}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:231:"Moderna首席执行官Stephan Bancel本周早些时候重复了同样的预测,他认为世界将不得不 “永远”与COVID-19共存。一项研究提出,新冠病毒有一天可能会像其一些普通感冒一样无害。";}}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:163:"“SARS-CoV-2不会消失,”Bancel在周三的摩根大通医疗保健会议上说。“我们认为,我们将永远与这种病毒共存。”他补充道。";}}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:382:"Moderna新冠疫苗已经成为成功通过3期临床试验的领先候选疫苗之一。该药物的有效性很高,就像辉瑞/BioNTech疫苗一样,并已获得美国和欧盟的紧急使用授权。Moderna公司已经预计该药物至少可以提供一年的免疫力,甚至更长的时间。Moderna将继续研究该药物,以制定未来几轮疫苗接种的方案。";}}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:284:"另外,来自埃默里大学和宾夕法尼亚州立大学的研究人员已经撰写了一份研究报告,解释了COVID-19的严重性将如何在几年内改变。他们预计该病毒最终会变得不比普通感冒更具毒性,人们很可能在童年时期感染该病。";}}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:471:"“我们对地方性人类冠状病毒(HCoVs)的免疫学和流行病学数据的分析表明,阻断感染的免疫力会迅速减弱,但减少疾病的免疫力是长期存在的,”研究人员写道。“我们的模型,结合了免疫的这些成分,既重现了(SARS-CoV-2)目前的严重性,也重现了HCoVs的良性,表明一旦达到流行阶段,且主要暴露于儿童时期,(SARS-CoV-2)的毒性可能不比普通感冒大。”";}}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:143:"研究人员解释说,这一切都取决于儿童时期COVID-19的性质。儿童时期的疾病越不严重,成年后就越容易应对。";}}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:372:"“该模型预测的感染死亡率(IFR)随时间的变化对针对当前和未来新兴HCoVs的疫苗接种策略有影响,”研究人员写道。“保持社交距离和有效的疫苗对于在疫情初期间和脱离疫情初期的过渡期的控制至关重要,但一旦我们进入地方性流行阶段,大规模的疫苗接种可能不再是必要的。”";}}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:314:"“是否有必要继续接种疫苗,将取决于IFR的年龄依赖性。如果儿童的原发感染是轻微的。随着原发病例消退到轻微的儿童流鼻涕,可能不需要继续接种。另一方面,如果儿童的原发感染很严重(如MERS),那么就需要继续为儿童接种疫苗。"";}}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;s:511:"然而,这些研究无法预测COVID-19何时会从大流行转变为地方性疾病。像辉瑞/BioNTech和Moderna等已经在使用的疫苗,以及其他仍在测试中的候选疫苗,可以帮助各国达到群体免疫。福奇博士等专家预测,只要有大量的人接受免疫接种,能够获得疫苗的国家已经可能在秋季或2021年底结束COVID-19的爆发。目前,SARS-CoV-2在一些国家的发病率正在激增,美国的感染率和死亡率统计仍处于领先地位。";}}}, 1621686945, 1716011021
Run Time: 0.005990