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.000487
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.000160
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.000337
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.000556
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000145
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: 286803
Run Time: 0.011935
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.000396
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: 286803
Run Time: 0.007007
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: 286803
Run Time: 0.000087
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 0010e2d2292c54212a004856b4e4a398, , 1715075891
Run Time: 0.000652
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=286803, 1715072291,
Run Time: 0.000107
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, 293209, a:30:{i:0;s:92:"日报标题:左右不分、真假难查......今年学术界真是发生了各种乌龙
";i:1;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:61:"http://pic4.zhimg.com/c1b4a75b500a354b1b6dfa2b7ddfefaf_is.jpg";}}i:2;s:122:" 中国科普博览,我们科学家有话说
我们找了这样五件事,可能比题目所说的范围要更广。
";i:3;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:16:"1)左右不分";}}i:4;s:2:"
";i:5;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:69:"匈牙利的一个科研团队企图搞清楚狗能否听懂人话。";}}i:6;s:354:"
科学家通过给狗做功能性磁共振成像(fMRI)来查看它们大脑的激活状况,研究最终发现:狗和大多数人一样用左脑处理词语含义。
然而,他们在著名期刊《科学》上发表论文后却发现,搞反了狗的左右脑。
因为人在做磁共振的时候是躺着进去的,而狗是趴着的。
";i:7;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:114:"团队称,可能有人在一开始就注意到这点并做了更正,另一个人不知情,又翻了回来。";}}i:8;s:199:"
所幸主要结论没出错,狗能听懂部分人话,并且,狗在理解人的指令时,用右脑分析语义,左脑分析语调,而顺畅的沟通过程需要左右脑共同参与。
";i:9;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:25:"2)不见了的金属氢";}}i:10;s:2:"
";i:11;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:93:"哈佛大学物理学家于今年 1 月宣布,他们制造出了地球上首块金属氢!";}}i:12;s:739:"
根据理论,金属氢可能是一种超导体,能显著提升电子设备性能,与此同时,还有可能为能源、医疗、交通运输等行业带来巨大变革。然而不久之后,哈佛大学再次发布声明,由于操作失误,这块金属氢样本消失了……消失了……
当时,他们正在用激光测量这块唯一的金属氢样本,用来制造样本的金刚石由于巨大压力突然粉碎,导致金属氢掉落消失。
根据推测,金属氢可能是化作气态升华,也有可能掉落和其他东西混在一起,也有人怀疑,该团队从未制作出金属氢,而样本的消失导致“死无对证”……
打破疑虑的方法只有一个,再造一块金属氢。
";i:13;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:28:"3)世界首例换头手术";}}i:14;s:18:"
11 月 17 日,";i:15;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:110:"意大利神经外科医生塞尔吉·卡纳瓦罗宣布世界首例人类头部移植手术已成功实施。";}}i:16;s:80:"手术地点在中国,由哈尔滨医科大学任晓平教授带领完成。
";i:17;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:99:"让人尴尬的是,本次换头是在遗体上进行的,称之为“解剖”或许更加准确";}}i:18;s:327:",即使气管、脊柱、主要静脉和动脉能连上,神经的连接仍是巨大难题
而医学界在神经修复上尚未有突破性进展,这意味着换头后,患者很有可能无法自主移动甚至呼吸。
此外,人们还关心一点:换头以后,你还是你自己吗?这知否有违伦理?
";i:19;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:16:"4)滴血验癌";}}i:20;s:746:"
“一滴血筛查 12 种癌症,检测过程仅需 5 至 10 分钟费用不到 100 元”!
今年 10 月,大量媒体报道了“90 后博士常宁带队实现了滴血验癌”的消息,常宁团队利用光子晶体微球技术检测肿瘤标志物的方法,对癌症进行早期初筛。有多名专家对报道表示了质疑,认为该方法临床意义相当有限。
目前,团队已不再接受采访,校方表示网上现有报道并不完全准确。
近年来“滴血验癌”消息层出不穷,原理无非是检验血液中的“肿瘤标志物”,然而权威的医学指南并不用肿瘤标志物来筛查癌症。
事实是,滴血验癌不能代替病理学诊断,相关报道夸大了研究成果
";i:21;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:25:"5)华人论文遭撤稿";}}i:22;s:1167:"
撤稿,对很多科研人员来说是非常尴尬的一件事情。这不仅意味着对其学术水平的否定,还意味着学术生涯上的不良记录。
今年有两起华人论文撤稿事件受到了整个学界的关注:
一是韩春雨团队历经 15 个月,终于撤回稿件。
早些时候,韩春雨等人在权威期刊上发表论文并因此获得大量喝彩,但重复实验均无法得到相同结果,人们开始质疑韩春雨论文的可信度,事情最终以撤稿收尾,但对华人学术界的影响却久久无法平息。
另一个重大撤稿事件利用了“同行评审制度”中的技术漏洞,使用假邮箱,冒充评审人对论文给出评审意见,是一种虚假的同行评审。
因为这个原因,著名学术出版商施普林格,在今年一次性撤稿了 107 篇论文!而这被撤的 107 篇论文全部来自中国,也有涉事国内研究人员声称,是委托代理机构在投稿时弄虚作假。对此,施普林格表示会开发相关工具,防范类似情况再次发生。
这两起撤稿事件,不免让人为华人学界的科研诚信打上了一个问号。
";i:23;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:9:"制作:";}}i:24;s:42:"中国科普博览 胡桃夹子工作室
";i:25;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:9:"出品:";}}i:26;s:14:"科普中国
";i:27;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:9:"监制:";}}i:28;s:44:"中国科学院计算机网络信息中心
";i:29;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:39:"http://www.zhihu.com/question/263626745";s:8:"original";a:2:{i:0;s:47:"[URL='http://www.zhihu.com/question/263626745']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1715072291
Run Time: 0.000827