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.000715
| 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.000335
| 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.000126
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 1382f2fdb79d1e58b3c6f45768742f5f, 1716152648
Run Time: 0.000337
| 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.000139
| 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: 294821
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: 25
Run Time: 0.000599
| 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: 294821
Run Time: 0.004587
| 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: 294821
Run Time: 0.000086
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '1382f2fdb79d1e58b3c6f45768742f5f')
Params: 1716156248
Run Time: 0.001559
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=294821, 1716152648,
Run Time: 0.000109
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, 301441, a:13:{i:0;s:254:"最近很多网友都反映，就在不经意之间手机彩信报又回来了，即便没有订购也可以收到。虽然内容都是以“抗疫”为主，显然是在普及信息，但是很多网友都有疑问手机彩信报能借此复兴吗？
";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:91:"https://rdimg.com/proxy/https://static.cnbetacdn.com/article/2020/0222/85725ff1e599c74.jpeg";}}i:2;s:2:"
";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:51:"一、手机彩信报在特殊时期的特殊作用";}}i:4;s:900:"
大家都有深刻的感受，那就是在新冠疫情期间，各种谣言四起，混搅着大家敏感而脆弱的神经。手机彩信报虽然实效性没有各种即时APP的更新迅速，但是这种以官方口径为内容的手机报可以最大范围内覆盖手机用户受众，起到了非常好的稳定社会舆论作用。当然很多网友会说根本就没有看过收到的疫情手机彩信报。其实这些手机彩信报更多是给不方便上网或者不会上网的用户看的。
另外还有值得大家注意的是，疫情期间突然出现的手机彩信报具有非常大的公益性，也就是无论用户是否订购都可以免费收到。从这一点可以明显地看出，此次疫情期间运营商发出的手机报并不是以营利为目的，更多的还是社会公益性质，帮助宣传“抗疫”的各种官方声音和防疫的有效措施。
";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:51:"二、手机彩信报能否借势“抗疫”复兴";}}i:6;s:109:"
在移动互联网不发达的2G时代，特别是智能手机尚未普及的时代，信息的传播除了";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:195:"https://c.duomai.com/track.php?site_id=242986&euid=&t=https%3A%2F%2Flist.jd.com%2Flist.html%3Fcat%3D737%2C794%2C798%26ev%3D4155_76344%26sort%3Dsort_rank_asc%26trans%3D1%26JL%3D2_1_0%23J_crumbsBar";s:8:"original";a:2:{i:0;s:203:"[URL='https://c.duomai.com/track.php?site_id=242986&euid=&t=https%3A%2F%2Flist.jd.com%2Flist.html%3Fcat%3D737%2C794%2C798%26ev%3D4155_76344%26sort%3Dsort_rank_asc%26trans%3D1%26JL%3D2_1_0%23J_crumbsBar']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:6:"电视";}}i:8;s:698:"、电台、纸媒之外，手机彩信报的随时随地性具有较大的便利性。因此在2G时代，手机彩信报作为比较有利可图的增值业务备受运营商和SP重视，而且也是各种常规业务中利润比较丰厚的。
虽然移动通信技术的飞速发展，以短信、语音和彩信为代表的常规业务在异常火爆之后，已经随着职能手机的普及而时过境迁，步入了无法逆转的黄昏通道。即便运营商还在极力挽救，仍然无法阻止技术潮流的滚滚向前而不断放大的替代作用。因此，从这个角度看，即便手机彩信报尚有可用之处，但是借此而谈论复兴则有点过高期待了。
";i:9;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:91:"https://rdimg.com/proxy/https://static.cnbetacdn.com/article/2020/0222/6fb594b11d1e09a.jpeg";}}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:54:"三、“抗疫”手机彩信报推送有待更精准";}}i:12;s:1032:"
很显然“抗疫”手机彩信报是在无差别地投放，不管是否智能手机都可以收到。其实对广大上网触手可及的用户来说，意义是非常有限的，毕竟大家早已是机不离手，各种信息可以随时随地获取，包括各类官方信息。
把最有用的信息推送给最需要的人才能体现手机彩信报的“抗疫”作用。运营商完全可以通过业务支撑平台调出真正的非智能机用户（主要是2G为代表的功能机用户）并向其定向发送，一方面提供手机报的点阅率，另外一方面也能真正发挥“抗疫”手机彩信报的作用。
手机彩信报在特殊时期发挥了特殊作用，但是这命运正向广大网友所言“即便免费也不看”，毕竟这早已是过时的业务，其存在价值被已被类似今天头条之后的实效性更强自媒体综合平台替代。当然免费的手机彩信报可以成为运营商阻碍用户自由携号转网的便利操作。（张运来为C114特约作者）";}, 1621686945, 1716152648
Run Time: 0.005944