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.000738
| 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.000143
| 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.000138
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: b933a6c24bb0098d804f6b6424e0e783, 1716171061
Run Time: 0.000164
| 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.000138
| 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: 269103
Run Time: 0.000452
| 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.000385
| 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: 269103
Run Time: 0.002527
| 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: 269103
Run Time: 0.000087
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'b933a6c24bb0098d804f6b6424e0e783')
Params: 1716174661
Run Time: 0.011826
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=269103, 1716171061,
Run Time: 0.000112
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, 275113, a:39:{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:61:"http://pic2.zhimg.com/fecf1c1ac2d6b732803e7d6cb3c734dd_is.jpg";}}i:1;s:423:" 章伟忠，22年眼镜从业者。有问题可直接询问微信公众号：启明的伙伴们
镜架是装饰性为主的产品，美又是很感性的东西没有标准，所以，分享一下除了好看之外我们还需要注意的问题：
一、影响舒适性的几个重要尺寸：
1、镜脚开放尺寸：要确认镜脚开放尺寸是否太小？以免压迫太阳穴，或将框面往前顶等问题。
";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:64:"https://pic4.zhimg.com/v2-fb1d6e496d7544c17ffb47e52ccdad57_b.jpg";}}i:3;s:2:"
";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:64:"https://pic4.zhimg.com/v2-82182580c7d51c87bfbbdc6ca1fce667_b.jpg";}}i:5;s:107:"
2、镜脚脚尾尺寸：需要参考一下您自己的镜架，略比旧镜小 10mm 左右比较好。
";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:64:"https://pic2.zhimg.com/v2-ea8005313a6b026f8d3657a13c5d4665_b.jpg";}}i:7;s:190:"
3、镜脚打弯处尺寸：打弯处太短，会使框面前倾，实际增大了倾角的角度；如果太长了，分配前端的重量较少，又容易下滑。
太长的效果：
";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:64:"https://pic4.zhimg.com/v2-98d1285de2c93a4f4a500f04760af163_b.jpg";}}i:9;s:25:"
太短了的效果：
";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:64:"https://pic2.zhimg.com/v2-7db6d8be37d8464f1cbc9bf67abbfb45_b.jpg";}}i:11;s:127:"
4、倾角的度数：倾角过大，框面下沿甚至可能搭在脸上；倾角过小，框面外翻。
倾角过小：
";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:64:"https://pic1.zhimg.com/v2-3efa2e2bb006b463f56812eb3da15c7c_b.jpg";}}i:13;s:19:"
倾角过大：
";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:64:"https://pic1.zhimg.com/v2-e322e4c1e5772ba059f333acd2908638_b.jpg";}}i:15;s:2:"
";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:64:"https://pic1.zhimg.com/v2-b5f120091d9e699b82738c8ae027a98c_b.jpg";}}i:17;s:326:"
5、鼻托的贴合度：鼻托贴合鼻翼的面积越大，舒适性越好。反之越差。还要注意鼻托与睫毛的距离，尤其是女士，以免睫毛碰到镜片内表面。
6、瞳高位置：需要考虑装入镜片后，正常佩戴情况下是否瞳高过低，以致于不得不频繁地上推镜架。
";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:64:"https://pic2.zhimg.com/v2-27ac32dc91c10042f1b22350ba5d8429_b.jpg";}}i:19;s:110:"
7、镜脚装饰件太长：装饰件太长，影响镜脚必要的柔韧性，舒适度就会受影响。
";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:64:"https://pic2.zhimg.com/v2-91d4a5e8732f257486170c60154e889d_b.jpg";}}i:21;s:178:"
二、不同的验光处方对镜架材质、结构的限制：
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:64:"https://pic3.zhimg.com/v2-00de16e55481c92c400336d5759422d6_b.jpg";}}i:23;s:408:"
2、左右眼度数差异较大的，镜架选择不当很容易戴着慢慢歪斜。建议选择可调整范围大的材质和结构的镜架。
3、联合度数高于 600°的，前端重量较大，谨慎选用弹性较好的镜脚材质，如：TR、塑钢（PEI）、不锈钢、β钛等。
4、联合度数高于 600°的，前端重量较大，慎选镜脚脚套部分平直或弯度很小的。
";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:64:"https://pic2.zhimg.com/v2-425072e723208c48c34662dfa8e0c5ed_b.jpg";}}i:25;s:140:"
5、度数较高的（大于 600°），慎选镜脚弹弓铰链的，因弹弓过夹影响舒适度，过松框面容易频繁下滑。
";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:64:"https://pic4.zhimg.com/v2-e096b269a149dcde7d35ac622e1b874f_b.jpg";}}i:27;s:199:"
6、脸部比较不对称、耳朵高低的，不建议选用宽脚板（无法调整倾角）、弹性较强的镜脚材质（TR、塑钢 PEI、不锈钢、β钛等）、一体鼻托等镜架。
";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:64:"https://pic3.zhimg.com/v2-abb7a3159d140bfd4c3960442fa1197a_b.jpg";}}i:29;s:148:"
7、鼻梁略歪、鼻翼较不对称的，不建议选用一体鼻托，或者可调整范围很小的鼻托。
调整范围不大的鼻托：
";i:30;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:64:"https://pic1.zhimg.com/v2-844839991d714b280b55980c2d57f1ec_b.jpg";}}i:31;s:522:"
三、如何保障较长时间内质感不会大幅度降低？
1、慎选 TR、塑钢（PEI）材质表面做喷漆处理的镜架，如果出自低端工厂，3-6 个月就可能漆层剥落。
2、慎选产地或品牌语焉不详的镜片，可能半年就开始发黄老化。
3、慎选亚光（砂面）喷漆处理的 TR 镜架，漆面很容易划伤，亚光表面因脸部汗液、油脂沁润有的发亮有的发暗，很难看。
4、慎选镶嵌水晶装饰的，一旦脱落，显得陈旧突兀。
";i:32;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:64:"https://pic2.zhimg.com/v2-ae08a2994e90f3024e1bed453f7dd3b9_b.jpg";}}i:33;s:143:"
5、慎选镜脚繁复镂空的设计，一旦积垢，显得很脏很旧。
6、慎选镜脚过于纤细的设计，显得头重脚轻。
";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:64:"https://pic3.zhimg.com/v2-c27dae1740f9d90a48f823c80599624a_b.jpg";}}i:35;s:158:"
7、慎选框面过于纤细的设计，显得镜片较厚，影响美观。
四、预先考虑到日常佩戴的场景便利和耐用：非常感谢知友";i:36;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"https://www.zhihu.com/people/96b4692d75bf3af3774a7326c241054d";s:8:"original";a:2:{i:0;s:69:"[URL='https://www.zhihu.com/people/96b4692d75bf3af3774a7326c241054d']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:7:"@吕晨";}}i:37;s:458:"的补充和提示！
1、喜欢看电影的人群。无论用 3D 夹片或者影院的 3D 眼镜，尺寸都会比较小，选择镜架的尺寸上需要考虑能覆盖。
2、在风沙或灰层较大的环境。不要选择不易清洗的结构和款式，如：镂空、镶嵌水晶等易积垢结构，喷漆易磨损表面等等。
3、易出汗的人群。不建议选择喷漆、非 IP 电镀（尤其是镀金色）的镜架表面处理工艺。
";i:38;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:36:"http://zhuanlan.zhihu.com/p/23626916";s:8:"original";a:2:{i:0;s:44:"[URL='http://zhuanlan.zhihu.com/p/23626916']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1716171061
Run Time: 0.001322