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.000846
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.000158
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.000178
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.000134
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: c8f11abcd66753321673510a8ae10985, 1716686191
Run Time: 0.000165
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.000476
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: 378465
Run Time: 0.014723
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.000373
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: 378465
Run Time: 0.019972
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: 378465
Run Time: 0.000097
UPDATE `xf_session` SET `expiry_date` = ?, `session_data` = ? WHERE (session_id = 'c8f11abcd66753321673510a8ae10985')
Params: 1716689791,
Run Time: 0.010986
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=378465, 1716686191,
Run Time: 0.000106
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, 385101, a:44:{i:0;s:243:"据外媒报道,导致Stadia游戏和娱乐部门早期关闭的部分原因是,自2019年11月以来,该平台设法获得的用户数量不尽如人意。虽然谷歌没有公布官方数据,但彭博社援引内部人士的话称,";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:213:"Stadia未能实现控制器销售和月活跃用户数目标,“差了几十万”。低采用率可能归因于该平台的营销和发布方式。这可以说是谷歌历史上最大的资金和资源浪费。";}}i:2;s:2:"
";i:3;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:72:"https://static.cnbetacdn.com/thumb/article/2021/0218/97e822e91b205d4.jpg";s:8:"original";a:2:{i:0;s:80:"[URL='https://static.cnbetacdn.com/thumb/article/2021/0218/97e822e91b205d4.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/2021/0218/97e822e91b205d4.jpg";}}}}}}i:4;s:2:"
";i:5;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:445:"Stadia打破了谷歌典型的 “从小处做起,从小处建设 ”的产品开发理念。与Gmail等谷歌其他测试周期较长的产品不同,它被营销和宣传为准备对标游戏机的完整服务。Stadia负责人菲尔-哈里森(Phil Harrison)表示,这是“游戏的未来”。彭博社和Wired与匿名消息来源,包括现在已经解散的开发公司的前员工,揭开了一些围绕着导致关闭的细节。";}}i:6;s:2:"
";i:7;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:71:"哈里森是游戏机游戏领域的资深人士,曾在PlayStation和";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:32:"https://microsoft.pvxt.net/e4yLO";s:8:"original";a:2:{i:0;s:40:"[URL='https://microsoft.pvxt.net/e4yLO']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:4:"Xbox";}}i:2;s:222:"担任过高管。虽然Stadia团队中的很多人都知道这个平台还没有做好迎接主机游戏的准备,但哈里森并没有被劝退,“将Stadia定位为一个充满花哨噱头的传统游戏平台”。";}}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;s:262:"Take-Two首席执行官Strauss Zelnick表示,谷歌在Stadia上“过度承诺”。“Stadia的推出速度很慢,”Zelnick在去年6月表示。“我认为,在技术所能提供的东西上有一些过高的承诺,消费者因此而感到失望。”";}}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:440:"哈里森类似控制台的方法影响了整个Stadia的商业模式。例如,它要求130美元的Founder's Edition控制器捆绑包必须有某种方式提供预购。游戏机制造商通常利用预购销售来润滑装配线的齿轮,并使初始产品出货。在Stadia的案例中,这并不是必要的,因为几乎所有的控制器都可以与该服务配合使用,而且Chromecast dongles已经进入了生产周期。";}}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:449:"订阅模式也让很多人早早就相信,该服务的运作方式很像Netflix,只需支付一笔月费,就能享受到所有的游戏体验。事实证明,该订阅服务只覆盖了少数游戏。每款游戏高达60美元,Stadia的其他产品并不比在其他地方购买游戏便宜。因此,潜在用户不认为在订阅之上付费有什么意义,特别是当他们已经在游戏机或PC上拥有一些相同的标题时。";}}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:431:"然而,缺乏用户兴趣并不是唯一困扰SG&E的事情。Stadia的前任和现任员工在接受Wired采访时表示,谷歌可能在领导力和资源方面都不具备运营游戏工作室的能力。“在向两个游戏工作室投入了数千万美元之后,谷歌无法忍受打造高水准视频游戏所需的昂贵而复杂的创意过程--尤其是考虑到Stadia的订阅量并不突出。”匿名员工说。";}}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:1:{i:0;s:344:"谷歌已经花费了数百万美元吸引第三方开发商在Stadia上发布游戏,但它知道自己需要独家内容来吸引用户进入该平台。据内部人士透露,这种为了系统而创造游戏的动力是问题的关键。员工表示,"谷歌不是为了卖游戏而资助游戏,而是为了卖Stadia而资助游戏"。";}}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:383:"为此,它开设了Stadia游戏和娱乐公司,雇佣了数十名员工,并收购了Typhoon Games公司。谷歌以一个更轻松的工作环境的承诺来吸引资深设计师,没有“紧缩 ”和裁员的烦恼。它还聘请了业内资深人士、育碧多伦多创始人Jade Raymond来领导这个部门,那么,是什么出错了呢?显然,有很多原因。";}}i:20;s:2:"
";i:21;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/2021/0301/ebc9e61301918ad.png";s:8:"original";a:2:{i:0;s:74:"[URL='https://static.cnbetacdn.com/article/2021/0301/ebc9e61301918ad.png']";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/2021/0301/ebc9e61301918ad.png";}}}}}}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:123:"首先,谷歌的野心是推出AAA级的Stadia独占游戏,但并没有现有的人才来及时创造这样的内容。";}}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:491:"“谷歌其实是一家工程和技术企业,”一位有幸仍受雇于Stadia的消息人士说。“制作内容--它需要的角色类型,在谷歌通常不存在。”于是,该公司疯狂招聘,但其选拔过程非常繁琐,审批一个新员工需要长达9个月的时间。消息人士称,它希望在5年内至少招聘2000名员工。在简化其招聘流程,使之更多的结构化为游戏设计师而非软件工程师之后,这一目标变得可以实现。";}}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:287:"然而,在加入这一行列后,开发者们遇到了不利于制作游戏的工作环境。例如,Wired的三位消息人士证实,谷歌因为“安全”原因不允许使用关键的游戏开发工具。另一个障碍是谷歌坚持将Stadia功能置于游戏功能之上。";}}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:466:"“长期以来,对游戏的授权包括要求拥护Stadia特有的心态,所以,比如,利用专门为Stadia而设的功能。”一位内部人士说。尽管谷歌希望以第一方独占的方式推出Stadia,但由于姗姗来迟、开发障碍,以及对开发时间的不切实际的期望,谷歌不得不面对一个残酷的事实,那就是在该平台首次亮相时,除了独立游戏的标题Gylt之外,它不会有任何新的产品。";}}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:395:"这种不足似乎并没有影响谷歌开发内部独家内容的决心。它继续招聘,实际上已经积累了一批不错的稳定人才。然而,2020年初,新冠大流行来袭,到了4月,Stadia宣布结束招聘。随着新冠大流行继续蔓延,该公司敏锐地意识到AAA开发成本会如何激增,突然间,内部独占的前景变得不那么有吸引力了。";}}i:32;s:2:"
";i:33;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/2021/0301/522fa06076b91b5.png";s:8:"original";a:2:{i:0;s:74:"[URL='https://static.cnbetacdn.com/article/2021/0301/522fa06076b91b5.png']";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/2021/0301/522fa06076b91b5.png";}}}}}}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:323:"“我认为这是缺乏对流程的理解,”一位内部人士说。“似乎有一些行政级别的人没有完全掌握如何在一个高度创造性(和)跨学科的空间中航行。” 尽管上层管理人员得出了这个结论,但他们让开发人员相信,就SG&E而言,一切都还处于现状。";}}i:36;s:2:"
";i:37;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:346:"1月27日,菲尔-哈里森发布了一封邮件,其中包含了2021年的“高级别平台预算和投资信封”。他在邮件中还提到,SG&E “在打造多元化的优秀团队和建立强大的Stadia专属游戏阵容方面取得了巨大的进展”,并指出该部门的预算即将出台。不过,他显然只是在吹牛。";}}i:38;s:2:"
";i:39;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:30:"谷歌无意放弃Stadia平台";}}i:40;s:2:"
";i:41;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:444:"就在几天后,恰逢SG&E唯一完成的项目《蛮荒星球之旅》推出,谷歌宣布关闭工作室。它承诺拥有相关技能的员工将被安排到公司的其他地方,但150名游戏设计师中的大部分都被解雇了。Wired的消息人士表示,考虑到内部的动荡,工作室的关闭并不那么令人惊讶,但在哈里森对该部门的赞誉和唯一一款游戏的推出之际,却让人有些震惊。";}}i:42;s:2:"
";i:43;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:84:"目前,谷歌并没有放弃Stadia平台的打算。有来自英伟达、索尼、";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:88:"https://c.duomai.com/track.php?site_id=242986&euid=&t=https://www.microsoftstore.com.cn/";s:8:"original";a:2:{i:0;s:96:"[URL='https://c.duomai.com/track.php?site_id=242986&euid=&t=https://www.microsoftstore.com.cn/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:6:"微软";}}i:2;s:317:"等公司的几款竞争服务,他们都想在云游戏领域占有一席之地。因此,这么早退出还为时过早--毕竟索尼已经尝试完善PlayStation Now六年多了。不过,如果Stadia泄密者所言属实,谷歌可能要重新评估它如何营销和运营一项仍未证明自己的服务。";}}}, 1621686945, 1716686191
Run Time: 0.022058