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.000587
| 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.000146
| 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.000159
| 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.000116
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 73519f89969515e83ed95d9b80642b63, 1715999902
Run Time: 0.000230
| 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.000137
| 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: 68690
Run Time: 0.000386
| 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: 25
Run Time: 0.004910
| 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: 68690
Run Time: 0.006163
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 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: 68690
Run Time: 0.000082
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '73519f89969515e83ed95d9b80642b63')
Params: 1716003502
Run Time: 0.028081
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=68690, 1715999902,
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, 70688, a:20:{i:0;s:1496:"这是煮机社区的一篇文章。文章文笔细腻，评测客观，让人感觉藿香正气呼吸顺畅。作者身在日本求学，对web OS机器一直有深厚的感情，因为在新iPhone身上也看到了简洁、人性化、高质量应用这些web os的优点和特制，因而抽空草成此篇。
“webOS活着的时候只需适当优化，并加入对几个常用软件的支持，一样具备拿来奔跑歌颂的潜质，至少现在不会为换手机发愁。手上这台iPhone4已经服役了两年有余，算是仅次于Centro生命周期最长的手机，保护壳都用褪色了。不换不是因为不舍，而是早已迷失在千篇一律的茫茫机海中，却始终找不到归宿。”
两周前，我还在为换机而伤神，至于最终为何会选择iOS，我想或许这是早已注定的事情了。——Android太像Windows Mobile了，比Windows Phone更像。机海战术下再经典的机器也会沦为快餐，rom自定义热潮就像一个怪圈，而系统流畅度问题始终让人揪心。反观iOS，偶尔能映射出palm时代的身影：人性化的静音开关键，卡片式后台管理，简洁的操作，流畅的速度，高质量的应用程序，更重要的是每一个型号都会让人印象深刻。唯一感到遗憾的是被大尺寸触摸屏的浮躁年代所摒弃的实体全键盘了。信息时代，大屏幕确实能带来更好的视觉体验，但是并非所有用户都希望身边的利器是拿来娱乐的。
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/01379854739.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/01379854739.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/01379854739.jpg_w600.jpg";}}}}i:2;s:2236:"
在遇到合适的机型前，我本打算继续使用iPhone4的，无奈系统升级到6.1后运行速度已经不堪重负，home键经过两年的重度使用也变得不灵敏了。之前吐槽过一点，就是关于苹果系统升级不可逆的问题。如果不通过shsh备份，常规方式下无法降级系统，这点一直挺让我反感的，当然苹果就是这样一家让人矛盾的公司，有的时候，他能让你体会到无微不至的人性化，有的时候却严重的侵害了用户的使用选择权利。但也正是因为这样，对苹果爱恨交织竟成了一种常态。
首发日当天，在就近的Softbank授权店问了一下，剩下最后一台太空灰的，琢磨着要不要直奔京都站的BIC CAMERA或Yodobashi这样的大卖场的，后来一想要么可能遇到排队长龙要么机器可能被卖光了，而颜色方面银白色确实一眼看上去跟5没啥区别，加上之前的白色iPhone4用得有点腻，至于土豪金（以下文字省略）。。。所以这台灰色似乎是特意为我保留的，猿粪。
其实换手机还有一个比较大的原因，日本手机签约期基本都是两年的，不论机器价格是买断还是分期付款，这两年得继续用这个运营商，中途更换机器没问题，但是想换运营商就必须缴纳违约金了。可能正是因为这样的条约限制，所以两年内话费是有折扣的，但是超过两年话费就开始上涨了。比如我使用的iPhone4虽然机器头两年每个月4k日元左右，超过两年了就会涨到5k日元。另外由于之前买iPhone4的时候错过了“学割”（日本的学生折扣价），这次当然不会再错过了。iPhone5选择了两年分期付款，每个月机器分期付款的价格，加上4G无限流量上网套餐，然后减去学割所减免的基本使用料（相当于月租），算下了每月只需要缴纳6k日元左右，但是如果不换机器，我得继续拿着iPhone4用着3G然后每个月还得支付5k。
包装一如既往，配件则是沿用了5的，之前没用过5的耳机，这次使用起来确实觉得佩戴比较舒服。音乐简单试听了Jing上面的流行歌曲，对比旧款有明显提升。
";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/11379854739.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/11379854739.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/11379854739.jpg_w600.jpg";}}}}i:4;s:212:"
背面金属面板和mbp类似的材质，上下则采用了和前镜面一样的玻璃。其实一直不太喜欢上下栏这样突兀的设计，感觉破坏了整体感，更喜欢4/4s的后背多一些。
";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/21379854739.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/21379854739.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/21379854739.jpg_w600.jpg";}}}}i:6;s:289:"
背面的苹果logo不再是小镜子了，不知道是不是从5开始的。用4的时候那面小镜子挺有用，比如骑车的时候眼睛里进了灰尘或者掉了睫毛，拿来救急很管用。毕竟前置摄像头凑近了存在视线角度问题，清晰度也不可靠。
";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/31379854741.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/31379854741.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/31379854741.jpg_w600.jpg";}}}}i:8;s:479:"
摄像头在我看来只能算是堪用，当然对比4质量有提升那是毋庸置疑的，毕竟已经隔了两代了。另外日版机器有个显著的特点就是摄像头拍照的时候无法设置静音，可能是考虑到个人隐私问题防止别人偷拍，当然越狱后就另当别论了。值得一提的是，iOS7的UI，从屏幕底部向上滑动调出的快捷面板里包含了手电筒功能，这样可以和那些启用手电筒的app说再见了。
";i:9;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/41379854741.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/41379854741.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/41379854741.jpg_w600.jpg";}}}}i:10;s:2:"
";i:11;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/51379854741.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/51379854741.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/51379854741.jpg_w600.jpg";}}}}i:12;s:215:"
从工艺上来看，这次应该是吸取了iPhone5的教训，之所以没有采用全黑的涂层也许是考虑到掉漆的问题。至于机体摩擦后是否会露白，也只能有待时间的考验了。
";i:13;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/61379854742.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/61379854742.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/61379854742.jpg_w600.jpg";}}}}i:14;s:344:"
对比iPhone4，摄像头和光敏电阻的位置调换了，摄像头被移到了听筒上方，而光敏电阻则移到了听筒左侧。这样确实要比4合理一些。潜质摄像头有人脸识别功能，可以点触测光，但没有自动对焦功能，画质只能放在手机上看看，无法替代女生的CASIO自拍神器。
";i:15;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/71379854742.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/71379854742.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/71379854742.jpg_w600.jpg";}}}}i:16;s:691:"
可能是看习惯了传统的home键设计，圆形的凹弧，以及按钮上的正方形logo。这次的home键并没有使用早前传言的电容触摸式，常规使用依然是按下去执行操作的。在启用新加入的指纹识别功能前，必须对机身设置密码，可能是防止指纹识别错误导致无法进入系统等意外发生。指纹识别除了正常解锁，还能用来替代iTunes以及App Store的密码，这点算是比较实用的功能了。个人比较希望看到的是指纹功能用于独立管理每个应用程序，比如什么软件比较重要涉及隐私的话可以单独设置指纹识别开关，这样开机就不那么麻烦了。
";i:17;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/81379854742.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/81379854742.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/81379854742.jpg_w600.jpg";}}}}i:18;s:301:"
黑色的本体依然是指纹收集器。但之所以换黑色是因为白色面板有一个更大的问题，在金属边框与镜面的夹缝之间容易藏污纳垢，且在白色的衬托下更加明显，即便是使用了保护套包裹起来，我还是要定期清洁机身。（待续）
";i:19;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:61:"http://static.cnbetacdn.com/newsimg/2013/0922/91379854748.jpg";s:8:"original";a:2:{i:0;s:69:"[URL='http://static.cnbetacdn.com/newsimg/2013/0922/91379854748.jpg']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{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:70:"http://static.cnbetacdn.com/newsimg/2013/0922/91379854748.jpg_w600.jpg";}}}}}, 1621686945, 1715999902
Run Time: 0.007108
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, 70707, a:1:{i:0;s:77:"[FONT=楷体]美！
换新主题了呀！ 这个让我想起了IPB:D[/FONT]";}, 1621686945, 1715999902
Run Time: 0.017171