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.001468
| 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.000154
| 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.000219
| 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.000125
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000266
| 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: 146410
Run Time: 0.000480
| 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.000460
| 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 ASCParams: 146410
Run Time: 0.002765
| 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: 146410
Run Time: 0.000088
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 220bb76afe787babc66272cbab955c72, , 1714804060
Run Time: 0.000804
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=146410, 1714800460,
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, 150510, a:23:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"5";s:8:"original";a:2:{i:0;s:8:"[SIZE=5]";i:1;s:7:"[/SIZE]";}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:33:"清朝婚礼服饰是怎样的？";}}}}i:1;s:2:"
";i:2;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:38:"http://pic4.zhimg.com/da8e974dc_is.jpg";}}i:3;s:393:" 匿名用户
原回复时未来得及整理图片配入，已补充图片，并对文字略作修改
===============
古装电影的服饰自然不能当真，《末代皇帝》中文秀在溥仪婚礼身着蒙古式样服装迎接“皇后”的场景纯属臆想。
清代皇帝大婚的相关服饰，可以从光绪《大婚典礼红档》中得知：
... ...俟届二十七日子时，";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:171:"派出福晋等四人恭侍皇后冠服，戴东珠朝冠，御珠宝朝服，珊瑚朝珠二盘，东珠朝珠一盘，金镶珊瑚项圈，拴辫手巾，正珠排环坠";}}i:5;s:555:"，在内堂少坐。正使在前堂请节授于总管太监，副使在前堂请册宝授于总管太监，由中门入。赞引女官二人恭导皇后出迎于内堂阶下道右，跪候过，随入。总管太监陈节于中案，陈册宝于东案，退。赞引女官二人，侍仪女官四人恭请皇后受册、受宝，太监宣读册文、宝文，礼毕。总管太监捧节出，转授正使。礼成后，皇后在内堂少坐。
... ...（皇后进宫，无更换服饰记载，删节）
恭侍福晋等请皇后降孔雀顶轿，少坐。";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:135:"午时，恭侍皇后净面，戴凤钿，穿明黄五彩龙袍，八团五彩有水龙褂，带项圈，拴辫手巾，正珠朝珠。";}}i:7;s:84:"酉时，请皇后乘八人孔雀顶轿，至坤宁宫降舆，至东暖阁恭候。";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:24:"皇帝吉服御坤宁宫";}}i:9;s:672:"，升宝座床居左，皇后升宝座床居右，相向坐。设合卺宴。福晋等四人恭侍，内务府女官等恭进宴桌。宴毕，内务府女官撤宴桌，合卺宴礼成。
... ...（第二日各处拈香、寿皇殿行礼等场合同上文皇后午时所穿服饰，删节）
从这段记载来看，皇后在大婚典礼当日行册封礼的时候身穿礼服（朝服），这是清代后妃命妇最隆重的服饰，构成复杂，穿用频率很低，宫中一般用于由后妃参加或主持的内廷最重大典礼和祭祀活动。
图为清代皇太后、皇后一套完整礼服（朝袍、朝褂等有多种式样，只选取其中一种）
";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:60:"http://pic3.zhimg.com/02c077691cbb55ac8b31400262307b01_b.jpg";}}i:11;s:40:"
图为身着清代皇后礼服的婉容";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:60:"http://pic1.zhimg.com/6caecfc9a58421f7f506ee6b55a502a5_b.jpg";}}i:13;s:1083:"
皇后入宫后于午时更换全套吉服，吉服在清代是性质比较复杂的一套服饰系统，其最重要的使用场合包含各类重大喜庆吉日。这里有几个名词略作解释：所谓“凤钿”是一种装饰有凤形首饰的钿子（钿子系清代旗人女性戴于头部的一种具有一定礼仪属性的筐状类冠编织物）；“八团五彩有水龙褂”是一种吉服外褂，石青色（色泽效果类似深蓝黑色）、对襟，上面装饰有八枚圆形云龙纹，袖端和下摆处装饰有云水纹，罩在大襟右衽“明黄五彩龙袍”之外；“项圈”在典章条文中称为“领约”，是一种装饰有珠宝和绦子的金质圈状物；“栓辫手巾”是一条栓系有各种小型坠饰的丝织垂带，系从手巾演化而来，典章条文中称为“彩帨”，挂在袍褂扣子上。《红档》未记载行合卺宴时是否更换其他服饰。
左起：凤钿、明黄色龙袍、石青色八团有水龙褂、项圈、手巾、正珠朝珠（仅为示意，未必是皇后大婚时所使用）
";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:60:"http://pic3.zhimg.com/0ffccff2fb7348da040cd3e6dc75f8c7_b.jpg";}}i:15;s:188:"
皇帝在合卺宴上穿吉服，由“珠顶冠”、“金龙袍褂”、朝珠、吉服带等构成。
图为冬季着清代皇帝吉服的溥仪，身穿金龙袍褂，项挂朝珠。";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:60:"http://pic4.zhimg.com/11fd48b0ab67587cd834a26f35017ef1_b.jpg";}}i:17;s:262:"皇帝吉服，左起：珠顶冠（实际中称谓，典章条文中称为“吉服冠”）、金龙袍（实际中称谓，典章条文中称为“龙袍”）、金龙褂（实际中称谓，典章条文中称为“衮服”），腰带与朝珠未列入。
";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:60:"http://pic4.zhimg.com/0c9ac0a5b150bb6396add102eb29dfd7_b.jpg";}}i:19;s:602:"目前也有一些疑惑处，比如这段记载中皇后册封礼之后到进宫再到午时更换吉服之前，是否另外换过其他服饰？午时更换的那套吉服在合卺宴时是否再更换过另外服饰？再如故宫博物院藏用于大婚典礼的光绪皇后“龙凤同合袍褂”（一套装饰有八团龙凤双喜字纹的婚期女吉服袍褂，见下图）究竟穿于何时？有文章中称为皇后行合卺宴时更换，但不知依据。这些问题有待相关文献的进一步发表、发现。
故宫博物院藏光绪大婚时皇后吉服“龙凤同合袍褂”
";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:60:"http://pic3.zhimg.com/ff5db3ab7cca408632a611568236105c_b.jpg";}}i:21;s:1:"
";i:22;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"http://www.zhihu.com/question/28138466";s:8:"original";a:2:{i:0;s:46:"[URL='http://www.zhihu.com/question/28138466']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:18:"查看知乎原文";}}}, 1621686945, 1714800460
Run Time: 0.000888