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.000567
| 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.000146
| 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.000170
| 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.000130
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: d17d394a285cd86618b1c0d261d00919, 1716032139
Run Time: 0.000150
| 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.000143
| 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: 577473
Run Time: 0.000399
| 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.000378
| 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 ASCParams: 577473
Run Time: 0.002293
| 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: 577473
Run Time: 0.000087
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'd17d394a285cd86618b1c0d261d00919')
Params: 1716035739
Run Time: 0.000778
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=577473, 1716032139,
Run Time: 0.000111
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, 584432, a:19:{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:80:"https://pic1.zhimg.com/v2-6ebc2bd6b0d5d7c4bb2b3c81652989a7_l.jpg?source=8673f162";}}i:1;s:47:" 杨溢，爱好发明创造的宝石猎人。 ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:58:"https://www.zhihu.com/question/491110077/answer/2159940121";s:8:"original";a:2:{i:0;s:66:"[URL='https://www.zhihu.com/question/491110077/answer/2159940121']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}i:3;s:1257:"
这刚好是与中科院地化所近几年的研究成果相关的，以下内容部分摘自地化所官网新闻报道。
至少在 6.3 亿年前，陆生真菌就已经在地球上出现，可以检索“瓮安生物群”“孢子化石”“菌丝化石”“陆生真菌”等关键词，获取更多信息与相关新闻报道。
一、迄今世界上发现的最早陆生真菌类化石
中国科学院南京地质古生物研究所、中国科学院地球化学研究所等单位牵头的国际团队通过高分辨率显微 CT 等现代化技术，最终破解了其身世之谜。相关研究成果于 6 月 13 日在线发表于美国《科学》杂志子刊《科学进展》（Science Advances）上，为理解动物起源提供了重要线索。
二、见证真菌登陆陆地。
在 6 亿多年前，蘑菇、酵母、青霉等真菌生物的祖先已经从海洋“爬”上了陆地。此前，最早的陆生真菌的化石发现于苏格兰，距今约 4.1 亿年历史。新发现的化石将陆生真菌的化石记录前推了 2 亿多年。生物从海洋登上陆地是生命演化史上的一次重要转折。而真菌被称为‘拓荒先锋’，在陆地从一片荒芜到生机勃勃的过程中扮演重要角色。
";i:4;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:83:"https://pica.zhimg.com/v2-d524ba361d2f5f09ec70691c8a383a05_720w.jpg?source=8673f162";}}i:5;s:655:"
瓮安生物群化石采集剖面。
三、研究陆地早期环境和生命起源
此次发现的 6.3 亿年前陆生真菌化石，比最早的陆生高等植物化石还早 1 亿多年。这对我们研究陆地早期环境和生命演化，也具有重要意义。
四、远古真菌类化石
6.3 亿年前的这种远古真菌类化石主要由两部分构成。一部分是长度数百微米的空心细丝，另一部分是连接在细丝之间、直径 10 至 26 微米的空心小球。科研人员通过与现代类似真菌的比对推测，细丝可能是真菌类生物的菌丝，而空心小球可能是用于繁殖的无性孢子。
";i:6;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:83:"https://pic1.zhimg.com/v2-060de3a43aab32e9527fb146b3bafe8a_720w.jpg?source=8673f162";}}i:7;s:62:"
孢子化石？电镜照片。（一说旋孔虫化石。）
";i:8;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:83:"https://pic1.zhimg.com/v2-099b0f5692487a60b3831af8c9a89a9e_720w.jpg?source=8673f162";}}i:9;s:206:"
保存于燧石中的菌丝化石（黑色）单偏光显微照片。
狭义的蘑菇多指具有菌盖、菌柄结构的大型真菌，其中缅甸琥珀与热河生物群赋存有直接化石证据。
";i:10;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:83:"https://pic2.zhimg.com/v2-07ce858688ba9ebf1cf56c34f24a2799_720w.jpg?source=8673f162";}}i:11;s:2:"
";i:12;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:49:"Palaeoagaracites antiquus Poinar & Buckley, 2007 ";}}i:13;s:755:"是曾经已知最早的蘑菇化石，发现于缅甸琥珀，伞菌目，科位置不定，伞盖直径 2.2 mm。现代所有的巨须隐翅虫（约 100 种）都是严格以蘑菇为食的昆虫，并且不同的甲虫类型取食不同种类的蘑菇。
新的研究成果是在缅甸琥珀与热河生物群发现 9000 万到 1.25 亿年前的完整蘑菇化石，并发现了以蘑菇为食的巨须隐翅虫。成果已经于 2017 年 3 月 16 日发表在了《自然—通讯》（Nature Communications）上。以下介绍该论文成果：
这次与蘑菇琥珀同时发现的巨须隐翅虫的体型，与现生类型极其相似，同时，它们拥有高度特化的口器，其下唇须末端膨大，呈斧状；下唇末端密布多种";i:14;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:212:"https://www.zhihu.com/search?q=%E5%97%85%E8%A7%89%E6%84%9F%E5%8F%97%E5%99%A8&search_source=Entity&hybrid_search_source=Entity&hybrid_search_extra=%7B%22sourceType%22%3A%22article%22%2C%22sourceId%22%3A35775887%7D";s:8:"original";a:2:{i:0;s:220:"[URL='https://www.zhihu.com/search?q=%E5%97%85%E8%A7%89%E6%84%9F%E5%8F%97%E5%99%A8&search_source=Entity&hybrid_search_source=Entity&hybrid_search_extra=%7B%22sourceType%22%3A%22article%22%2C%22sourceId%22%3A35775887%7D']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:15:"嗅觉感受器";}}i:15;s:271:"，很有可能是用于探寻蘑菇和感知蘑菇的新鲜程度；此外，它们的上颚内缘呈锯齿状，可以用来切割取食蘑菇。
这不但说明 1.25 亿年前就有蘑菇了，而且还说明缅甸与热河生物群都包含多种不同的蘑菇。
";i:16;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:83:"https://pic2.zhimg.com/v2-4a252808cfd7b1ec4f70adaabd7ebd2b_720w.jpg?source=8673f162";}}i:17;s:103:"
该项研究由中国科学院，国家科技部和国家自然科学基金委员会联合资助。
";i:18;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:40:"https://www.zhihu.com/question/491110077";s:8:"original";a:2:{i:0;s:48:"[URL='https://www.zhihu.com/question/491110077']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1716032139
Run Time: 0.001102