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.000584
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.000420
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.000832
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.000372
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 36613d14ecbb57fc647d2b0498431f79, 1716155606
Run Time: 0.000590
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.000162
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: 577408
Run Time: 0.000561
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: 38
Run Time: 0.000396
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: 577408
Run Time: 0.017866
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: 577408
Run Time: 0.000090
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '36613d14ecbb57fc647d2b0498431f79')
Params: 1716159206
Run Time: 0.006947
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=577408, 1716155606,
Run Time: 0.000117
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, 584367, a:29:{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:54:"https://pic3.zhimg.com/da8e974dc_l.jpg?source=8673f162";}}i:1;s:59:" 知乎用户,公号<食津录> 记录美食人生 ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:58:"https://www.zhihu.com/question/491182130/answer/2160542729";s:8:"original";a:2:{i:0;s:66:"[URL='https://www.zhihu.com/question/491182130/answer/2160542729']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}i:3;s:403:"
三分钟的短片,却满满都是彩蛋,什么贾巴尔教诺维斯基勾手啦,韦德大喊“这是我的马”啦,詹姆斯撒镁粉之类的 NBA 专属梗,都囊括其中。那么这部片子究竟有哪些你没发现的彩蛋,不妨一起来看看吧。
首先我们来看看整部片子有多少人参演吧,给出的演职人员表是 NBA 球员 14 人,NBA 名宿 20 人。
";i:4;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:83:"https://pic3.zhimg.com/v2-17ac0558a18eae0b28617b915d098351_720w.jpg?source=8673f162";}}i:5;s:1255:"
其中,NBA 球员分别有詹姆斯、杜兰特、安东尼、保罗、威少、安东尼 - 戴维斯、拉梅洛 - 鲍尔、布克、拉文、莱昂纳德、米切尔、塔图姆、锡安以及特雷 - 杨。
而 NBA 名宿则是贾巴尔、韦德、拉里 - 伯德、迪瓦茨、朱利叶斯 - 欧文、阿蒂斯 - 吉尔摩、吉诺比利、理查德 - 汉密尔顿、格兰特 - 希尔、雷 - 阿伦、罗伯特 - 霍里、魔术师约翰逊、穆托姆博、诺维茨基、加里 - 佩顿、奥斯卡 - 罗伯特森、比尔 - 拉塞尔、伊赛亚 - 托马斯、比尔 - 沃顿以及杰里 - 韦斯特。
当然,NBA 还有一个很重要的组成部分,就是吉祥物。这部片子里共有 7 个球队吉祥物参加了表演,分别是公牛队、步行者队、热火队、快船队、奇才队、黄蜂队和猛龙队。
演职人员名单 30 多位 NBA 球星,但整部片子里出现的球星元素可就不止于此了,比如科比的墙画、约基奇的涂鸦以及姚明的火箭球衣。
看完这部片子之后,很多人可能会好奇,NBA75 周年纪念,为什么没有出现迈克尔 - 乔丹。整个片子,只有在后半段当中,才有迈克尔 - 乔丹扣篮的画面在电视机上一扫而过。
";i:6;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:83:"https://pic2.zhimg.com/v2-6308247585d2c01ad067f6e2d346e625_720w.jpg?source=8673f162";}}i:7;s:549:"
但实际上,这部《NBA 小巷》没有乔丹,却满屏乔丹。因为这部剧的演员兼制片人叫迈克尔 -B- 乔丹,他在剧里饰演巴士司机还兼职旁白。
事实上,黑豹堂兄弟已经不是第一次玩这个梗了,今年詹姆斯主演的《超级大灌篮 2》中的一个桥段,众人要去寻找乔丹,结果就叫来了他。
甚至当初在片场,迈克尔 -B- 乔丹来探班时詹姆斯就调侃说:“今天在片场有个叫迈克尔 - 乔丹的家伙来找我。你们有人认识他吗?”
";i:8;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:83:"https://pic3.zhimg.com/v2-a4899142c991eb54b4b95be82f514815_720w.jpg?source=8673f162";}}i:9;s:285:"
可以说,黑豹堂兄“霹雳火”,算是乔丹的官方平替了,用他来做整个故事的讲述人再合适不过。
除此之外,魔术师约翰逊和拉里 - 伯德之间的细节也颇有意思。两人都穿着睡衣,但身处环境的颜色却值得玩味。
";i:10;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:83:"https://pic1.zhimg.com/v2-0972d2c65cde099926f78c4b0afdb65e_720w.jpg?source=8673f162";}}i:11;s:300:"
魔术师穿着一身金色的睡衣,椅子、水管和花盆都有金色元素,花盆里种植的却是紫罗兰。紫金配色,不言而喻。
另一边的伯德则都用了大片绿色调,门口左下角则有着一个“爱尔兰精灵”,这不就是波士顿的队徽标志嘛。
";i:12;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:83:"https://pic2.zhimg.com/v2-52ae5772619ce8c9434f591c1a1e10ba_720w.jpg?source=8673f162";}}i:13;s:425:"
作为 70 年代 NBA 最主要的两支球队,是魔术师和伯德的“湖凯对决”将 NBA 逐步带入鼎盛。当初“你死我活”的恩怨对决,如今已经成为人们口中的“兄弟情谊”了。
至于韦德说“这是我的马”,或是詹姆斯撒镁粉这样的动作,大家应该都熟悉,这里不再赘述。但是这部片子的镜头语言颇有意思,你看出来端倪了吗?
";i:14;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:83:"https://pic3.zhimg.com/v2-489fe5cf37996963127261a68ad6259b_720w.jpg?source=8673f162";}}i:15;s:721:"
比如,前一个画面是奥斯卡 - 罗伯特森手持报纸出镜,下一个画面就切换到了威少那里,而罗伯特森报纸上,报道的正是威少成为新三双王的新闻。背后的意思不难理解吧。
之后,旁白说的是:“在这里,学习新技巧永远都不会太晚。”随后便是“天钩”贾巴尔教诺维斯基勾手,而诺维斯基的勾手则传给了吉诺比利,后者扔了一个空接给拉文,说话的却是吹杨。
勾手、金鸡独立、欧洲步,这都是 NBA 曾经最具代表性的个人技术动作,而拉文的暴扣,以及特雷 - 杨的一手抛投,也都是各自的招牌。整段镜头语言说的就是一个词——传承。
";i:16;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:83:"https://pic1.zhimg.com/v2-788cecfc9f7d4cd34e5367beadd3f073_720w.jpg?source=8673f162";}}i:17;s:401:"
除此之外,小细节也算是花了不少心思。比如浓眉晃开快船队吉祥物投篮的画面,就有些玩梗的意思了。
而社区当中的壁画涂鸦,则象征着世界。壁画上的人分别是姚明、纳什、恩比德、东契奇、奥拉朱旺、约基奇、戈贝尔与彼得洛维奇,这些来自不同国家的国际球员,却让 NBA 联盟变得更加多彩。
";i:18;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:83:"https://pic1.zhimg.com/v2-efbb81db9f9f5e7881533ece230d74ca_720w.jpg?source=8673f162";}}i:19;s:262:"
除此之外,在之前巴士转弯的过程当中,墙边挂着一排球衣,当中就有大姚的。值得一提的是,大姚的球衣是刚到火箭时期的复古球衣,而这一排球衣几乎都有各队的复古元素,说的同样是传承。
";i:20;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:83:"https://pica.zhimg.com/v2-a46283df82156bbe38c7edbb2f3547ae_720w.jpg?source=8673f162";}}i:21;s:296:"
当然,说到 NBA 自然还有经典手势和绰号,比如佩顿在片子中就非常抢戏,单手一伸就是“手套”。而穆大叔摇手指的姿势也是深入人心,不过大家在球场上不要轻易尝试,不然有可能被吹 T,毕竟这是穆大叔的专属特权。
";i:22;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:83:"https://pica.zhimg.com/v2-b4c3a5176a33f1a5c3defde278ad2a57_720w.jpg?source=8673f162";}}i:23;s:393:"
最温情的地方自然是布克出场那段,他驾驶着老爷车停在科比的壁画前,而壁画上写着“成为传奇(be legendary)”。
这是当初科比给布克在鞋上写下的祝福,自此这两个词也成为了布克的座右铭,他会在自己的每一双球鞋上都写上“be legendary”这两个单词,甚至还将这两个单词纹在了手臂上。
";i:24;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:83:"https://pic3.zhimg.com/v2-89aaa5a41180e07e03cfad145b5ee58f_720w.gif?source=8673f162";}}i:25;s:272:"
随着布克致敬科比,随后缓缓启动车子继续前行,背后依然意味着传承。
当然,最后重量级的结尾是“指环王”比尔 - 拉塞尔那句话:“比赛越来越有意思了。”而你注意到他帽子上的缩写“KB”了吗?
";i:26;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:83:"https://pica.zhimg.com/v2-3f76788f783ff2cabe11c96e13e3b1e3_720w.jpg?source=8673f162";}}i:27;s:1:"
";i:28;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:40:"https://www.zhihu.com/question/491182130";s:8:"original";a:2:{i:0;s:48:"[URL='https://www.zhihu.com/question/491182130']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1716155606
Run Time: 0.046442