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.000560
| 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.000148
| 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: 8818abcd1f1a5dbb01cdc02a701a97c5, 1716135156
Run Time: 0.000206
| 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.001251
| 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: 305810
Run Time: 0.007460
| 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.000413
| 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: 305810
Run Time: 0.002373
| 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: 305810
Run Time: 0.000101
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '8818abcd1f1a5dbb01cdc02a701a97c5')
Params: 1716138756
Run Time: 0.000608
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=305810, 1716135156,
Run Time: 0.000110
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, 312435, a:25:{i:0;s:111:"4月8日凌晨，2020年的第二次超级月亮将如期登场。相比于3月10日的第一次超级月亮，";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:81:"这次的超级月亮更加名副其实，这是年度最大的“超级月亮”";}}i:2;s:35:"。相关的新闻报道很多：
";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:90:"https://rdimg.com/proxy/https://static.cnbetacdn.com/article/2020/0407/50d1cc62de72be7.png";}}i:4;s:40:"
微博的相关话题也很火爆：
";i:5;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:90:"https://rdimg.com/proxy/https://static.cnbetacdn.com/article/2020/0407/0bd2370727f0a9a.png";}}i:6;s:28:"
电视上也有报道：
";i:7;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:90:"https://rdimg.com/proxy/https://static.cnbetacdn.com/article/2020/0407/28e9f0c63073221.jpg";}}i:8;s:285:"
到这里很多人可能就有疑问了：这月亮还分普通月亮和超级月亮？超级月亮是月亮“变身”了吗？它是个高深的天文学术语吗？
事实上这超级月亮远没有那么复杂，但其科学道理还是有一点的。下面就一起来看。
";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:24:"什么是超级月亮？";}}i:10;s:842:"
大家往往时不时会在电视新闻里、网上或是朋友圈看到听到超级月亮这个词，但具体它是个啥，很多人可能并不清楚。而在天文学文献中，这个词不太容易见到。
所谓的超级月亮，严格来说并不是一个天文学名词，而是一位美国的占星师于1979年提出来的新词，它指的是满月或新月的时候，月亮正好位于近地点的现象。
随着传媒一次次的报道和传播，超级月亮（supermoon）这个人造的词汇也逐渐为大众所接受。
但是，我们在新闻媒体中泛指的超级月亮，若无特殊说明，一般仅仅指的是近地点的满月，而不包括近地点的新月。这是由于新月（农历的朔月）时，月亮几乎看不见，即使离地球比平时近，存在感也很差，不适合赏月。
";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:30:"为什么会有超级月亮？";}}i:12;s:956:"
我们知道，月亮绕地球公转，是地球的唯一天然卫星，如果月亮绕地球公转的轨道是一个不偏不倚的正圆的话，那么月亮离地球的距离就应该是不变的，这样人们从地球看上去，月亮在天空中的大小就该是一成不变的，不会有大有小。
但事实上，月球绕地球旋转的轨道跟行星绕太阳旋转的轨道类似，不是正圆轨道，而是椭圆轨道，这样就使得月亮有时离地球近，有时离地球远，离地球最近时是近地点，离地球最远时是远地点。月球分别位于近地点和远地点时，距离地球能差出几万千米。(最近时~35万千米，最远时~40万千米)
不要小看这几万千米的差距，相对于地月平均距离38.4万千米，这个差别完全能体现在视觉上，近地点的满月就能比远地点的满月大~14%。
所以超级月亮比普通的满月更大更亮，是赏月的良机。
";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:39:"这次超级月亮“超级”在哪？";}}i:14;s:216:"
4月8日的超级月亮是今年最大最亮的满月，具体来说，就是当天是距离地球最近的满月，根据近大远小的透视原理，所以当晚的月亮就是全年最大的。
具体来说，";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:203:"是8日2时9分时，月球恰好运行到它的近地点，这个近地点也是全年月球离地球最近的时刻，只有35.7万公里，其视直径也达到了全年的最大值，约33.5角分。";}}i:16;s:219:"
而在8日10时35分，月相将达到满月，即月亮此时最圆，太阳、地球、月亮排成一条直线上。月亮位于近地点和月相为望月时相差的时间并不算大，有利于大家观赏。
";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:33:"为什么超级月亮值得看？";}}i:18;s:505:"
因为超级月亮是月球位于近地点的满月（农历上把这种月相叫望，农历十五左右），所以若想看到超级月亮，必须满足既是满月又是近地点。
8日凌晨的这次超级月亮，还是全年月亮离地球最近的时候，所以会比平时更大更亮，是今年最佳的赏月机会，比传统赏月节日中秋节的月亮都大！
如果错过了这次超级月亮，下次的超级月亮，将是在2021年的5月26日，一年后才能看得到。
";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:27:"如何观看超级月亮？";}}i:20;s:198:"
简单地说，若是天气晴好的话，全国各地均可直接肉眼观看。
有条件的同学，还可以用相机、天文望远镜等设备拍摄这次的超级月亮。
具体来说，";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:185:"因为这次超级月亮的近地点时刻是8日的凌晨2时左右，所以适宜观看的时间是7日晚上太阳落下月亮升起以后，8日凌晨月落之前，以及8日晚上";}}i:22;s:147:"。
月升月落的时间和各地的经纬度有关，以4月7日为例，以下是一些城市的月升月落时刻，供大家赏月参考。
";i:23;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:90:"https://rdimg.com/proxy/https://static.cnbetacdn.com/article/2020/0407/d8f959818097be6.png";}}i:24;s:122:"
在这里还要提醒一下大家，晚上如果在户外赏月，一定要注意保暖，而且口罩不要忘了戴！";}, 1621686945, 1716135156
Run Time: 0.000922