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.000541
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.000159
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.000128
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 503959a1993069fbad36296f05f9f475, 1716650016
Run Time: 0.000154
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.000144
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: 577493
Run Time: 0.000421
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.000422
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: 577493
Run Time: 0.001826
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: 577493
Run Time: 0.000088
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '503959a1993069fbad36296f05f9f475')
Params: 1716653616
Run Time: 0.000887
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=577493, 1716650016,
Run Time: 0.000108
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, 584452, a:31:{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:80:"https://pic1.zhimg.com/v2-c38131d617d4f87acffc6289d5698410_l.jpg?source=8673f162";}}i:1;s:29:" 柴斯卡,人间观察家 ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:58:"https://www.zhihu.com/question/417151787/answer/2178311070";s:8:"original";a:2:{i:0;s:66:"[URL='https://www.zhihu.com/question/417151787/answer/2178311070']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}i:3;s:784:"
香港已经上映一个多月了,才找到时间去看。我对这部电影感情复杂,推荐去看,但也有不喜欢的层面。先分析几点推荐的。首先,顾名思义,《沙丘》要看沙丘。宏大的沙丘场景就值回票价了,非常非常养眼。
其次,在这个漫威时代,导演能拉来这些投资,让电影院从主题公园时代,变回古典大片时代——是特别大的本领,维伦纽瓦好莱坞第一融资大师诚不我欺。能够在电影院里看到任何情感细腻,主题恢弘,美学统一的大制作,都值得我们去贡献票房,因为在互联网与饭圈文化盛行的今天,这种属于电影、尊重电影的大制作电影,越来越难以得见了。(和它形成鲜明对比的电影:";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[URL]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:58:"https://www.zhihu.com/question/392098990/answer/2142981333";}}i:5;s:5:")
";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://pica.zhimg.com/v2-e5071ad8a49a66042067e730134cbe7c_720w.jpg?source=8673f162";}}i:7;s:1431:"
第三,《沙丘》有足够严肃的内核。《沙丘》原著的小说,有很强的二十世纪几次世界大战与冷战背景,其内核是英美法苏帝国对中东地区的虎视眈眈,与当地原住民深不可测的神秘力量——丰富的资源,恶劣的环境。
理解《沙丘》,就要理解《阿拉伯的劳伦斯》。二十世纪初,英国人劳伦斯进入沙漠,以高超的政治眼光和如簧巧舌,团结起了当时一盘散沙的阿拉伯部落,推翻了奥斯曼帝国。他的历程被记者写成传记后,成了传奇的“阿拉伯的劳伦斯”。
1962 年,大卫·里恩拍摄了四个多小时的史诗巨作《阿拉伯的劳伦斯》,再现了劳伦斯的阿拉伯旅程。《阿拉伯的劳伦斯》的主体,是英国 - 奥斯曼围绕苏伊士运河展开的利益冲突。其中很多对话,是英国人和阿拉伯部落之间发生的。英国人说:“我们大英帝国面积小却强盛,是因为有 discipline。”
但是阿拉伯人说:“不,是因为你们有枪炮和海军。”寥寥几句,点明了二者观念上的巨大差异。
《阿拉伯的劳伦斯》中蔓延着对阿拉伯部落能否现代化的担忧,与现代中东比对十分唏嘘。影片最后,劳伦斯终于抵达了大马士革,但他闷闷不乐;这部电影上映时,英国终究丢掉了苏伊士运河。再也没有那个大英帝国。
";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://pic2.zhimg.com/v2-2801b3a28e63ce824be0b92b2d9ea962_720w.jpg?source=8673f162";}}i:9;s:715:"
《阿拉伯的劳伦斯》
《第一滴血》是后越战电影,《阿拉伯的劳伦斯》则是后苏伊士运河危机电影。以苏伊士运河危机为转折点,大英帝国落幕,美苏争霸开启。大卫里恩历时五年的打造,贯穿全片的落寞气质,其实是站在那个特殊时刻,在世界大战元气大伤后,对大英帝国怅惘的追忆。劳伦斯在当时已经知道,穆斯林部落是很难现代化的。
看过了《阿拉伯的劳伦斯》,再回看《沙丘》,电影中看似纷乱反复的派别也就十分好理解了;甚至连影片中的机械设定,也充满苏联式重工的气息。2021 年的《沙丘》,似乎可以被理解为是一部";i:10;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:11;s:5:"。
";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://pic1.zhimg.com/v2-90e340d6dd27d35d0bda0e6034b9e1f6_720w.jpg?source=8673f162";}}i:13;s:690:"
《沙丘》
最后,若说电影有什么让我受不了的,就是它作为视觉大制作,卡头怼脸景别、仪式感走位、POV 镜头多到有点离奇了。维伦纽瓦通过辽阔的景色与人的大头混合剪辑,在大头和 POV 之间不断切换,辅以迷离的独白,营造一种内心呓语的感觉。
但是这么多大头在大银幕上,尤其是讲求视觉效果的大制作大银幕上,看着有点难受。而且《沙丘》的剧情架构是“王子复仇记”,说直白点就是“狮子王”,和维伦纽瓦此前的《银翼杀手 2049》还不太一样,主角呓语的目的是劝自己直面恐惧,文学性还是不够深入。
";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://pic1.zhimg.com/v2-ac1523555c9aa8520b30d4e70b14a0ec_720w.jpg?source=8673f162";}}i:15;s:731:"
但是,这是一部在电影院变成主题公园的时代,仍然是真正的电影的大制作电影;是一部剧情巨婴化的时代,仍然很有武德的电影。
那么就值得去电影院贡献票房。
维伦纽瓦真是令人羡慕,试问口味 classical 的影迷谁没梦想过拍一部史诗气氛浓郁,背景宏大,每个出场人物都能因耳熟能详的故事等等让人尖叫的作品呢?《银河英雄传说》也是这方面气氛太正了。
宏大的沙丘,浩瀚的太空,苏联式的重工,配上电影庄严的节奏,仪式感之强,令人叹为观止。我觉得就算啥也不演我也能盯着看好几个小时,imax 上动起来的效果绝对是妙不可言——
";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-47a1475c31b530320d4bc020c5aaeeda_720w.jpg?source=8673f162";}}i:17;s:1:"
";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://pic3.zhimg.com/v2-88349b4b5be920a2a9d78634be9a48f0_720w.jpg?source=8673f162";}}i:19;s:1:"
";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://pic2.zhimg.com/v2-ca5c1ee4988913b7677685985c6a3119_720w.jpg?source=8673f162";}}i:21;s:1:"
";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://pic1.zhimg.com/v2-9d36a21e6588afb3f7bc99d9b5e679e6_720w.jpg?source=8673f162";}}i:23;s:1:"
";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://pic2.zhimg.com/v2-b6540e33c2dc810fdd33f28d01ed8b61_720w.jpg?source=8673f162";}}i:25;s:1:"
";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://pic2.zhimg.com/v2-dfcf0b49ab98281ec0e37a0665db15ef_720w.jpg?source=8673f162";}}i:27;s:1:"
";i:28;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-19779a0515768f659dc5d76f72316a8d_720w.jpg?source=8673f162";}}i:29;s:1:"
";i:30;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:40:"https://www.zhihu.com/question/417151787";s:8:"original";a:2:{i:0;s:48:"[URL='https://www.zhihu.com/question/417151787']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1716650016
Run Time: 0.000653