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.000610
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.000147
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.000142
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.000133
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000165
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: 288926
Run Time: 0.000455
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.000534
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: 288926
Run Time: 0.002613
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: 288926
Run Time: 0.000085
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 80734b89aa6f8c6d2d27ac5d1404fc30, , 1714734657
Run Time: 0.000746
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=288926, 1714731057,
Run Time: 0.000103
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, 295427, a:36:{i:0;s:565:"美国商务部16日晚发布公告称,美国政府在未来7年内禁止中国中兴通讯向美国企业购买任何产品,禁令即时生效。令近期已然非常紧张的中美经贸关系再添变数。代表中兴通讯供应商的出口管制专家,美国Jacobson Burton Kelley PLLC律师事务所的道格拉斯·雅各布森(Douglas Jacobson)18日在接受澎湃新闻采访时认为,此次美国商务部对中兴的最新制裁决定肯定会对中兴在全球的销售产生影响,中兴也很难扭转美国商务部的这一决定。
";i:1;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:102:"(原标题:中兴或失去安卓系统使用权,美国代理律师:美方禁令难以扭转)";}}i:2;s:2:"
";i:3;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:25:"澎湃新闻记者 刘栋";}}i:4;s:2:"
";i:5;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:66:"https://static.cnbetacdn.com/article/2018/0418/70e8b1483b614ee.jpg";s:8:"original";a:2:{i:0;s:74:"[URL='https://static.cnbetacdn.com/article/2018/0418/70e8b1483b614ee.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:96:"https://rdimg.com/proxy/https://static.cnbetacdn.com/thumb/article/2018/0418/70e8b1483b614ee.jpg";}}}}}}i:6;s:2:"
";i:7;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:1:{i:0;s:9:"资料图";}}i:8;s:2:"
";i:9;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;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:36:"中兴与谷歌磋商安卓使用权";}}}}i:10;s:2:"
";i:11;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:284:"美国商务部制裁中兴的消息震动全球电信通讯行业,更对中兴和相关企业造成巨大冲击。路透社的报道,中兴或从美国公司购买25%到30%的组件和硬件,而供应链的任何一项中断都会影响中兴在中国生产产品的能力。";}}i:12;s:2:"
";i:13;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:323:"路透社17日报道称,在美国禁止国内企业向中兴出售元器件后,中兴的移动设备可能无法再使用谷歌的安卓(Android)操作系统。失去对安卓的使用权对中兴将是巨大打击,由于中兴通讯并没有自己的操作系统,将面临几乎没有其他替代选择的窘境。";}}i:14;s:2:"
";i:15;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:229:"报道援引消息人士的话称,中兴和谷歌母公司Alphabet旗下部门在彻夜讨论美国政府禁令的影响,不过直到当地时间的17日早晨,两公司仍未就中兴能否使用安卓系统作出决定。";}}i:16;s:2:"
";i:17;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:3:{i:0;s:6:"谷歌";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:86:"https://cloud.tencent.com/developer/labs/gallery?fromSource=gwzcw.908633.908633.908633";s:8:"original";a:2:{i:0;s:94:"[URL='https://cloud.tencent.com/developer/labs/gallery?fromSource=gwzcw.908633.908633.908633']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:6:"开发";}}i:2;s:201:"的安卓(Android)操作系统是中兴智能手机的核心,提供面向用户的各类功能、应用程序和其他服务。这意味着该软件可能也在周一美国政府的封杀令之列。";}}i:18;s:2:"
";i:19;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:291:"中兴每年在全球销售约4500万部智能手机,其中将近一半使用高通芯片。在美国,中兴通讯是第四大智能手机供应商,排名位于苹果、三星电子和LG电子之后。据咨询机构Canalys数据,去年中兴通讯在美国的市场份额为11.2%。";}}i:20;s:2:"
";i:21;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;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:42:"美国强调封杀是因中兴“犯规”";}}}}i:22;s:2:"
";i:23;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:156:"美国商务部强调,此次最新宣布的处罚是两年前美商务部对中兴违反美国限制向伊朗出售美国技术的制裁条款的延续。";}}i:24;s:2:"
";i:25;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:482:"2016年3月8日,美国商务部指控中兴通讯涉嫌违反美国对伊朗的出口管制政策,对中兴实行禁运,随后中兴通讯被美方列入“特别审查名单”。经过多方博弈和谈判,2017年3月,中兴通讯认罚。根据双方当时签署的协议,中兴通讯要向美国政府共支付11.92亿美元罚金,其中3亿美元缓期执行。除了罚金,中兴通讯还进行了内控整改,解雇了公司CEO在内的多位公司高层。";}}i:26;s:2:"
";i:27;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:464:"美国商务部部长罗斯16日在宣布新的制裁时称,中兴通讯违背了前述的和解协议的部分条款:中兴曾于2016年11月、2017年7月向美国政府提交的两封信中称,公司对此前认定违规的39名员工进行了处分。但在美国商务部工业和安全局2018年2月要求其提供具体报告时,没能拿出证据。随后中兴通讯承认其没有按照信中所说,对相应员工减少奖金或做出处分。";}}i:28;s:2:"
";i:29;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:233:"“中兴很难扭转美国商务部的这一决定。此前他们在2016年3月被制裁时已经获得了‘缓刑’。按照当时的协议,他们应该对一些员工采取一些措施。”雅各布森对澎湃新闻表示。";}}i:30;s:2:"
";i:31;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:96:"截止到发稿前,中兴方面尚未就澎湃新闻针对上述问题的询问给予答复。";}}i:32;s:2:"
";i:33;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:157:"17日,在A股和H股上市的中兴同时发布停牌公告。受这一消息影响,中兴通讯在美国的主要供应商股价也出现大幅下跌。";}}i:34;s:2:"
";i:35;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:398:"在17日上午发布的一则声明中,中兴方面称,公司正在全面评估此事件对公司可能产生的影响,与各方面积极沟通及应对。中兴董事长殷一民在昨天发送的一份内部信中写道:“在这样艰难的时刻,希望大家坚定信心。团队一直在攻克难关,公司也在积极沟通,并做出最大努力,来促进危机的解决。”";}}}, 1621686945, 1714731057
Run Time: 0.000614