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.000572
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.000155
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.000145
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.000127
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 890005608b808d695c33fcdd9a8b8ba6, 1715921696
Run Time: 0.000156
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.000155
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: 187870
Run Time: 0.000443
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.000401
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: 187870
Run Time: 0.002426
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: 187870
Run Time: 0.000089
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '890005608b808d695c33fcdd9a8b8ba6')
Params: 1715925296
Run Time: 0.000649
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=187870, 1715921696,
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, 192870, a:9:{i:0;s:346:"美国当地时间28日上午,美国航空航天局(NASA)宣布,在火星表面发现了有液态水活动的“强有力”证据,而液态水是生命存在的必要条件。NASA官网 上的消息显示,有5名科学家出席此次新闻发布会,其中3位都拥有首席科学家的头衔、在火星研究领域颇为资深。";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:284:"他们分别是NASA行星科学部主任吉姆·格林 (JimGreen)、火星探测项目首席科学家迈克尔·迈耶(MichaelMeyer)、亚利桑那大学火星勘测轨道器高分辨率成像科学实验相机首席科学 家阿尔弗雷德·迈克欧文(AlfredMcEwen)。";}}i:2;s:3:"
";i:3;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:65:"http://static.cnbetacdn.com/article/2015/0930/ce7ff0df9bf5403.jpg";}}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:265:"另两个人的身份并没有那么显赫:一个是刚从康奈尔大学博士毕业、目前正在NASA做博士后的玛丽·贝斯·维尔海姆(MaryBethWilhelm),还有一个则是佐治亚理工学院的博士生卢金德拉·欧嘉(LujendraOjha)。";}}i:6;s:14:"
可别小看";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:6:"欧嘉";}}i:8;s:2661:"这个小伙,正是他在此前的研究中发现了火星上存在所谓的季节性坡纹,表明火星上可能存在液态水流。
早在2011年在亚利桑那大学读地质学本科时,欧嘉通过分析卫星照片,发现火星表面遍布一些细如铅笔的条纹,而这些条纹会随着季节的变化而变化。欧嘉当时就推测,这可能是盐水流过后留下的盐的痕迹。而他的这一假设最终得到了火星轨道探测器上图像光谱仪所提供数据的支持。
难怪欧嘉此次会成为NASA新闻发布会的座上宾。欧嘉关于这一发现的论文《火星斜坡上存在盐水的光谱证据》(SpectralevidenceforhydratedsaltsinrecurringslopelineaeonMars)已在《自然》杂志的子期刊《自然地球科学》(NatureGeoscience)上发表。他还将在今年的欧洲行星科学大会上宣读这篇带来激动人心结果的论文。
尽管欧嘉在照片上的模样是蓄着大胡子,但其实,他仅是个尼泊尔裔的“90后”小伙。当4年前提出火星存在液态水的设想时,欧嘉还只是个本科生,如今,他已成为佐治亚理工学院的地质科学博士生,明年就要期满拿到博士学位。
在他个人主页的“研究”项目一栏中,欧嘉写道,他的研究兴趣是类地行星的演进过程,以及当前太阳系中行星的特点。目前,他已研究了地球、火星、月球等。对于自己的研究,欧嘉谦虚地写道,他并不认为他正在做的是“科学研究”,而只是尝试去了解自己所在星球的起源,并将这些结论分享给大家。
欧嘉的个人简介中还罗列着从2011年至2015年求学阶段所获的奖项以及参与的一些交流活动。比如,他曾在2011年获得亚利桑那大学的荣誉主席奖以及该大学学生物理科学研究展示的一等奖。在2013年和2015年,他两次获得过美国国家科学基金会(NFL)颁发的奖学金。
在研究地质学之余,欧嘉还是个狂热的摇滚乐爱好者。其个人主页的背景照片就是他拿着吉他、深情放歌时的场景。
除了爱好摇滚,欧嘉还是个摄影高手。他的个人主页还集中展示了他拍摄的照片。由于出生在尼泊尔,欧嘉特别钟情雪山、牦牛和土生土长的尼泊尔人。或许正是尼泊尔的山川河流,激发了欧嘉日后对地质学、物理学的兴趣。
也有欧嘉儿时的玩伴透露,欧嘉从小就对周遭世界充满好奇,尤其痴迷科幻小说。他在高中时就对多重宇宙等物理学理论颇为感兴趣,还曾幻想着打造一台时间机器,穿越时空。";}, 1621686945, 1715921696
Run Time: 0.001786