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.002004
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.000155
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.000143
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.000115
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000146
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: 389604
Run Time: 0.000441
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.000936
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: 389604
Run Time: 0.017323
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: 389604
Run Time: 0.000089
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ece4a8b0da8398d3ee1a8eb24ab4df63, a:8:{s:12:"sessionStart";i:1715068812;s:2:"ip";s:4:"
;d*";s:11:"sessionCsrf";s:16:"t73l67oXum4Auz6I";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1621687349;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1484570488;}}, 1715072412
Run Time: 0.015323
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,
;d*,
;d*, XenForo_ControllerPublic_Thread, Index, valid, thread_id=389604, 1715068812,
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, 396413, a:53:{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://pic4.zhimg.com/da8e974dc_l.jpg?source=8673f162";}}i:1;s:53:" 知乎用户,公众号:文艺圈八卦(wenyqbg) ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:56:"https://www.zhihu.com/question/28850652/answer/979114191";s:8:"original";a:2:{i:0;s:64:"[URL='https://www.zhihu.com/question/28850652/answer/979114191']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}i:3;s:162:"
这个问题要回到莫泊桑那个年代看,小说出版于 1883 年,处于法兰西第三共和国时期(1871-1940)。
吃牡蛎之所以优雅高贵,";i:4;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:18:"首先牡蛎得贵";}}i:5;s:44:",不然吃田螺能吃出那种感觉?
";i:6;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:87:"1、3 只牡蛎=60 条法棍面包=10 条羊排=缝纫工 5 天工资=3 天日常开销";}}i:7;s:211:"
从原文看,应该是 3 人(父亲、两个姐姐)各吃了 1 只牡蛎,总价 2.5 法郎。——但我怀疑女婿也吃了一只,根据是父亲“瞪着眼看着挤在卖牡蛎的身边的女儿";i:8;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:9:"女婿”";}}i:9;s:5:"。
";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-e8dc53ba532eb71294d84d8c7653c89a_720w.jpg?source=8673f162";}}i:11;s:28:"
2 法郎 1895 (1870-1895)
";i:12;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:47:"当时货币,1 法郎=20 苏=100 个生丁。";}}i:13;s:122:"
《悲惨世界》写于 1862 年,早于《我的叔叔于勒》约 20 年,可以参考其中记载的物价[1]。
";i:14;a:4:{s:3:"tag";s:6:"indent";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[INDENT]";i:1;s:9:"[/INDENT]";}s:8:"children";a:1:{i:0;s:158:"1 条法棍面包=1 苏=0.05 法郎;
1 条羊排 = 6~7 苏=0.3~0.35 法郎
17 小时缝纫工薪水 =12 苏=0.6 法郎
每日饮食 = 18~20 苏=0.9~1 法郎";}}i:15;s:225:"
《我的叔叔于勒》第三段提到,“姐姐们自己做衣服,买十五个铜子一米的花边时还常常要在价钱上争论半天”,十五个铜子英文版是“fifteen centimes”,即 15 个生丁。
";i:16;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:253:"15 个生丁尚且要讨价还价,吃 2.5 法郎(250 生丁)牡蛎,还给 0.5 法郎(50 生丁)小费,这 3 只牡蛎实际花去 3 法郎,相当于吃掉 60 条法棍面包或 10 条羊排或缝纫工 5 天工资或 3 天日常开销。";}}i:17;s:123:"
可见,勒阿弗尔一家确实没什么钱,而且吃牡蛎非常奢侈。
吃牡蛎奢侈有两个现实原因。
";i:18;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:27:"一是当时经济不好。";}}i:19;s:156:"
1883~1896 年,法国经济几乎停止增长,并且《我的叔叔于勒》发表前一年还发生一次经济危机,7000 多家企业倒闭。
";i:20;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:33:"二是当时牡蛎产量并不高";}}i:21;s:3:"[2]";i:22;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:3:"。";}}i:23;s:536:"
1836~1847 年,法国渔港和牡蛎中心康卡勒每年捕捞约 5000 万 -7000 万只欧洲牡蛎。到 1856 年,年平均产量下降到 1800 万,最终在 1860 年代初达到每年约 100 万 -200 万只的谷底。直到 1868 年,一艘船将约 60 万只变质的葡萄牙牡蛎倒海里,一些小牡蛎繁衍下来,产量才开始恢复。
牡蛎贵使得吃它成为上流社会风俗,对于穷惯了的勒阿弗尔一家来说,看别人吃自己没有吃过的贵东西,怎么吃法都觉得新鲜吧。
";i:24;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:34:"2、怎么吃牡蛎才算优雅?";}}i:25;s:254:"
我们先不妨回忆下,怎么吃西餐高贵优雅?
餐厅档次得够,气氛得有感觉,侍者服务要好,刀叉有不同用途,菜品精美份量小,爵士放着,就餐者妆容精致……
《我的叔叔于勒》怎么写?
";i:26;a:4:{s:3:"tag";s:6:"indent";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[INDENT]";i:1;s:9:"[/INDENT]";}s:8:"children";a:1:{i:0;s:396:"我的父亲忽然看见两位先生在请两位打扮很漂亮的太太吃牡蛎。一个衣服褴褛的年老水手拿小刀撬开牡蛎,递给了两位先生,再由他们传给两位太太。他们的吃法也很文雅,一方精致的手帕托着蛎壳,把嘴稍稍向前伸着,免得弄脏了衣服;然后嘴很快地微微一动就把汁水喝了进去,蛎壳就扔在海里。";}}i:27;s:432:"
妆容、菜品、服务都有了,然而环境、气氛什么的差太多。
实际上,太太的吃法也不算“文雅”,嘴向前伸,微微一动,让我想象到青蛙捕食, 这样做主要避免弄脏衣服,而非真的文雅。再说把蛎壳丢到海里,有何文雅可言?
那为什么这种吃法,还是使“我的父亲”觉得好?
首先是太太打扮得很漂亮,漂亮的人吃什么都";i:28;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:12:"赏心悦目";}}i:29;s:5:"。
";i:30;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:31;s:323:"勒阿弗尔一家怎么吃?饿惯了,大概食物一上桌,大家就抢,吃得狼吞虎咽,还发出声音。相比之下,太太这种品尝美食的吃法无疑是“更优雅”的。
再就是,蛎壳是从衣服褴褛的年老水手,经由先生传给太太,用手帕托着,很绅士,很讲究。";i:32;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:90:"这背后代表的是上流社会派头,这才是最吸引勒阿弗尔一家的地方。";}}i:33;s:237:"
那《我的叔叔于勒》那个年代,真正优雅高贵的吃法应该是怎么样呢?
从 BelleÉpoque 时期[3]的明信片可以看到,应该坐在餐厅里,牡蛎配 Demi-Sec 香槟,并且使用专门的牡蛎叉。
";i:34;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-5c2404cd0d89742133999b582cc5ff5d_720w.jpg?source=8673f162";}}i:35;s:112:"
闲来无事找到了一点牡蛎叉的资料[4],图形蛮好看的,放在这里算是一个补充吧。
";i:36;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-5a03df4499081466bee72c5dcfd9663a_720w.jpg?source=8673f162";}}i:37;s:32:"
叉头有锚和绳索的设计
";i:38;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-dc7b3621c5c0f3c089c4013190a8f8cf_720w.jpg?source=8673f162";}}i:39;s:113:"
雏菊花型
下面几张出自罗杰斯兄弟(Rogers & Brother,国际银饰公司)1882 年的目录。
";i:40;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-a3c7f9391e689110487923702ad18926_720w.jpg?source=8673f162";}}i:41;s:1:"
";i:42;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-931f369bc85355e4bb9e89bc47a91a70_720w.jpg?source=8673f162";}}i:43;s:1:"
";i:44;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-b81bc819df92e7606d95393b72f4367c_720w.jpg?source=8673f162";}}i:45;s:1:"
";i:46;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-aeca4fa40ebcba461fbdd8e76312ee9a_720w.jpg?source=8673f162";}}i:47;s:128:"
然后,这个是牡蛎盘,由牡蛎化用而来,1874 年 6 月 16 日授予美国华盛顿特区的 John W. Boteler。
";i:48;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-f5efc6d62042c7f341fa240e469a6162_720w.jpg?source=8673f162";}}i:49;s:38:"
最后,来张胃口大开的图~
";i:50;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-de6348a118563df6c69311f827e06433_720w.jpg?source=8673f162";}}i:51;s:1:"
";i:52;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:39:"https://www.zhihu.com/question/28850652";s:8:"original";a:2:{i:0;s:47:"[URL='https://www.zhihu.com/question/28850652']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1715068812
Run Time: 0.030300