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.001559
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.000145
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.000212
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.000135
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000215
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: 289283
Run Time: 0.000497
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: 38
Run Time: 0.000490
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: 289283
Run Time: 0.003899
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: 289283
Run Time: 0.000088
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: e7dc20ebfce3378eee173fdf162d3241, , 1714339221
Run Time: 0.000663
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=289283, 1714335621,
Run Time: 0.000122
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, 295900, a:67:{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:64:"http://pic1.zhimg.com/v2-a2afd999712762d9c146a525489d48dc_is.jpg";}}i:1;s:47:" 知乎科学,来知乎,看科学多热闹 ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"https://www.zhihu.com/question/367368391/answer/985092921";s:8:"original";a:2:{i:0;s:65:"[URL='https://www.zhihu.com/question/367368391/answer/985092921']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}i:3;s:132:"
关于防治新型冠状病毒肺炎,@知乎科学 科科整理了大家最关心的几个问题,希望可以帮到大家:
";i:4;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:45:"普通民众如何防护新冠肺炎疫情?";}}i:5;s:32:"
国家卫健委 @健康中国 ";i:6;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"https://zhuanlan.zhihu.com/p/103856742";s:8:"original";a:2:{i:0;s:46:"[URL='https://zhuanlan.zhihu.com/p/103856742']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:39:"医政医管局负责人焦雅辉介绍";}}i:7;s:5:":
";i:8;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:293:"
[*]尽量减少去人员密集区。
[*]无论居家还是工作,定期室内通风。
[*]出现发热或咳嗽症状时,一定要戴口罩。
[*]勤洗手,如果不小心用手捂住自己口鼻一定要先洗手。打完喷嚏后不要揉眼睛,做好个人防护和个人卫生。
";}}i:9;s:23:"
同时,普通民众";i:10;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:2:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"https://www.zhihu.com/question/367532730/answer/983201855";s:8:"original";a:2:{i:0;s:65:"[URL='https://www.zhihu.com/question/367532730/answer/983201855']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:21:"暂不需要护目镜";}}i:1;s:24:",口罩即可防护。";}}i:11;s:50:" @菲利普医生、@李可乐、@返朴 等知友";i:12;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:40:"https://www.zhihu.com/question/367137019";s:8:"original";a:2:{i:0;s:48:"[URL='https://www.zhihu.com/question/367137019']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:54:"在这个问题里为大家科普了如何选用口罩";}}i:13;s:5:"。
";i:14;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:39:"民间流传的预防手段有效吗?";}}i:15;s:56:"
@果壳、 @丁香医生、 @腾讯医典 等整理了";i:16;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:40:"https://www.zhihu.com/question/367288223";s:8:"original";a:2:{i:0;s:48:"[URL='https://www.zhihu.com/question/367288223']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:33:"关于新型冠状病毒的谣言";}}i:17;s:15:",下列办法";i:18;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:6:"不能";}}i:19;s:175:"预防新冠肺炎:
❌ 吸烟、喝酒
❌ 室内蒸醋
❌ 吃板蓝根、益生菌、维生素 C、抗生素、抗流感药物
❌ 盐水漱口
❌ 开空调暖气
";i:20;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;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:36:"感染新冠肺炎有什么症状?";}}}}i:21;s:48:"
根据国家卫健委 @健康中国 印发的 ";i:22;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"https://zhuanlan.zhihu.com/p/103862245";s:8:"original";a:2:{i:0;s:46:"[URL='https://zhuanlan.zhihu.com/p/103862245']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:67:"新型冠状病毒感染的肺炎诊疗方案 (试行第三版)";}}i:23;s:5:":
";i:24;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:351:"
[*]以发热、乏力、干咳为主要表现。
[*]鼻塞、流涕等上呼吸道症状少见。
[*]约半数患者多在一周后出现呼吸困难,严重者快速进展。
[*]值得注意的是重症、危重症患者病程中可为中低热,甚至无明显发热。
[*]部分患者起病症状轻微,可无发热,多在 1 周后恢复。
";}}i:25;s:2:"
";i:26;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:48:"怀疑自己得了新冠肺炎,该怎么办?";}}i:27;s:67:"
感到不舒服,担心得了新冠肺炎?@人民网 转发了";i:28;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"https://www.zhihu.com/question/367698536/answer/984132131";s:8:"original";a:2:{i:0;s:65:"[URL='https://www.zhihu.com/question/367698536/answer/984132131']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:36:"北京卫健委的自我评估方法";}}i:29;s:17:",如果你:
";i:30;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:136:"
[*]体温不超过 38℃
[*]没有明显的气短、憋喘
[*]年龄在 5 - 60 岁之间
[*]不是孕妇,没有慢性病,不肥胖
";}}i:31;s:62:"
那先不要着急,你有可能只是患了普通感冒,";i:32;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:90:"建议先在家休息和观察(自我隔离),盲目去医院反而容易交叉感染";}}i:33;s:5:"。
";i:34;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:30:"哪些人需要自我隔离?";}}i:35;s:98:"
综合 @生命时报 报道,如果你符合下列任一条件,建议自我隔离 14 天:
";i:36;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:118:"
[*]症状轻微,符合上一节所述情况
[*]跟疑似感染者可能有接触
[*]14 天内去过武汉等疫区
";}}i:37;s:59:"
北京协和重症主任医师 @王郝 为知友分享了";i:38;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"https://zhuanlan.zhihu.com/p/103892879";s:8:"original";a:2:{i:0;s:46:"[URL='https://zhuanlan.zhihu.com/p/103892879']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:33:"世卫组织的自我隔离指南";}}i:39;s:20:",可供参考。
";i:40;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:66:"http://pic3.zhimg.com/70/v2-f63e56761ee7c92217334615a76d63fa_b.jpg";}}i:41;s:2:"
";i:42;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:33:"什么时候应该及时就诊?";}}i:43;s:16:"
如果你:
";i:44;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:328:"
[*]在家观察休息后 1 - 2 天病情无好转
[*]近期近距离接触过有发热、咳嗽症状的患者
[*]去过农贸市场等人群密集的场所
[*]最近接触过野生动物
[*]老年人,孕妇,肥胖以及有慢性肺部疾病、心血管疾病、肝、肾脏等基础性疾病和免疫功能低下的人员
";}}i:45;s:37:"
建议及时前往医院就诊。
";i:46;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:81:"如果症状轻微,你也可以先选择线上就诊,避免医院交叉感染";}}i:47;s:27:"。知友 @差不多同学 ";i:48;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"https://www.zhihu.com/question/367818539/answer/985018446";s:8:"original";a:2:{i:0;s:65:"[URL='https://www.zhihu.com/question/367818539/answer/985018446']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:72:"整理了各在线问诊平台,目前多平台均开设了在线义诊";}}i:49;s:5:"。
";i:50;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:24:"怎么去医院就诊?";}}i:51;s:2:"
";i:52;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:5:{i:0;s:4:"
[*]";i:1;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:63:"就近选择发热门诊重点医院或定点收治医院就诊";}}i:2;s:42:", @知乎日报 小李已为大家整理";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"https://www.zhihu.com/question/367578372/answer/983354330";s:8:"original";a:2:{i:0;s:65:"[URL='https://www.zhihu.com/question/367578372/answer/983354330']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:45:"全国各地定点医院、发热门诊名单";}}i:4;s:93:"。
[*]前往医院途中,应配戴口罩。
[*]尽量避免搭乘拥挤的公共交通。
";}}i:53;s:2:"
";i:54;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:24:"医院会如何治疗?";}}i:55;s:42:"
国家卫健委 @健康中国 已印发 ";i:56;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"https://zhuanlan.zhihu.com/p/103862245";s:8:"original";a:2:{i:0;s:46:"[URL='https://zhuanlan.zhihu.com/p/103862245']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:67:"新型冠状病毒感染的肺炎诊疗方案 (试行第三版)";}}i:57;s:3:",";i:58;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:40:"https://www.zhihu.com/question/367736770";s:8:"original";a:2:{i:0;s:48:"[URL='https://www.zhihu.com/question/367736770']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:48:"武汉协和医院也发布了最新治疗方案";}}i:59;s:119:",主要包括支持治疗、抗病毒治疗、抗菌药物治疗等手段,但目前尚无特效抗病毒药物。
";i:60;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;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:27:"新冠肺炎是绝症吗?";}}}}i:61;s:193:"
不必过度恐慌,多数患者预后良好,只有少数患者病情危重或死亡。
请相信我们的医务和科研工作者,我们一定会夺取这场战役的最终胜利。
";i:62;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:102:"关注 @知乎科学 与肺炎疫情专题,获取「新型冠状病毒肺炎」最新实时信息:";}}i:63;s:2:"
";i:64;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"https://www.zhihu.com/special/19681091";s:8:"original";a:2:{i:0;s:46:"[URL='https://www.zhihu.com/special/19681091']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:60:"知乎实时:关于新型肺炎你需要知道的 - 知乎";}}i:65;s:2:"
";i:66;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:39:"http://www.zhihu.com/question/367368391";s:8:"original";a:2:{i:0;s:47:"[URL='http://www.zhihu.com/question/367368391']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1714335621
Run Time: 0.001076