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.000464
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.000162
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.000348
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: 287999
Run Time: 0.000950
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.009573
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: 287999
Run Time: 0.017589
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: 287999
Run Time: 0.000262
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: a04f5e926ceded5b6cd5b3e0a3629d84, , 1714887057
Run Time: 0.023065
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=287999, 1714883457,
Run Time: 0.000103
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, 294424, a:21:{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:38:"http://pic1.zhimg.com/266ab8f14_is.jpg";}}i:1;s:443:" 暗涌,The Follower of Psychology
最近答题类 APP 大火,从疯狂撒币的《冲顶大会》《百万英雄》到知乎的《知识之王》都火爆得不行,朋友圈和群聊里到处都有人分享自己的战绩。
为什么同样面临知识,哪怕父母承诺几百几千的奖金我们都无动于衷,却为了知识竞答平分的那一块钱拼了老命?
这是因为,游戏有天生领先学习的部分。
";i:2;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:3;s:293:"在游戏中,你要通过自己的操作,或冲刺,或躲闪,或拼杀,或创造,最后达到目的。在这个过程中能体验到高度的控制感和自我效能感。当你在《我的世界》里建起第一栋属于自己的房子,你会觉得自己像一个创世神。
";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:39:"而学习更多地是输入的过程。";}}i:5;s:1254:"学习新知识时你需要去记住一些东西,跟着前人的思路,思考为什么结果是这样的,而当你的思考稍微偏离,就可能出错。你像一头牛,被老师和书本牵着走,步调要是没跟上,鼻环马上就能感受到牵引力,很难体会到控制感和自我效能感。
而在学习中,做题的输出过程是最丰富的。因此你可以观察到,学霸们更多地喜欢做题而不是看书,就是因为攻克难题的过程更能带来控制感和自我效能感。五年高考三年模拟就是他们的贪玩蓝月,遇到没有刷过的船新题集,学霸挤需体验三番钟,就会爱象刷题游戏。
而且一个有趣的现象是,即使是游戏,输入的过程也往往是体验最糟糕的部分。比如王者荣耀新手教程中喋喋不休、令人生厌的妲己。一看「移动摇杆前进」,游戏老鸟白眼一翻:这还用你教?恨不得一键跳过,马上开始征战峡谷。不过,游戏中的输入过程往往十分简单,虽然乏味无趣,但对游戏体验影响甚微。这也是为什么往往越火的游戏越追求简单的操作,这样可以降低输入过程的乏味,而提升输出过程的控制感和自我效能感。
";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:321:"相比学习,游戏带来了更多的控制感和自我效能感,同时,好的游戏往往是及时反馈的,我们随时知道上一次的操作带来了好的还是坏的结果,各种奖励的强化使我们的动机更加强烈,因此即使遭遇了挫折,克服挫折的过程反而会让人更畅快。";}}i:7;s:773:"
但这只是一方面的原因。同样是输入,看故事书就比学高数开心多了;而同样是输出,打游戏就比做题更爽。有的人说这是内容的原因,这么有趣的东西,怎么能不多尝试几次?
的确,有趣的内容会让人想要尝试,但是它不能持久。
我至今仍然记得有一个下午,我外婆教我用算盘。我本来以为自己不会感兴趣,但那一个下午,我沉迷于珠算的世界,觉得这个东西从没有那么有趣过,但好像我对它的兴趣也只持续了一个下午。我也记得 2048 火的时候,我不睡觉都要玩,但是我现在玩腻了。它没有做错什么,游戏机制还是像以前一样引人入胜,但是我玩腻了,它就不再有趣了。
";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:36:"比内容更重要的因素是难度";}}i:9;s:91:"。
要是说游戏没打通关,大家就会一直玩,《掘地求升》就笑了。
";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:66:"http://pic2.zhimg.com/70/v2-eac1b6ef4a5631d924a8751b65736be1_b.jpg";}}i:11;s:205:"
一些游戏之所以能让你一直玩下去,是因为难度设置恰到好处,当你过不了关时,会产生运气不好或者一时失误的错觉。比如当年火爆一时的 flappy bird。
";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:66:"http://pic3.zhimg.com/70/v2-1ee83fb7686db8704f6b7eb1b9df51de_b.jpg";}}i:13;s:494:"
你认为自己玩这个游戏会很轻松,但现实是你卡关了。这两种矛盾的认知会让你陷入认知失调的状态。为了协调自己的认知,你要么承认自己水平很差,要么承认游戏本身很难,或者认为自己是运气不好。
当你认为刚刚的失利可能只是时运不济,那么再玩一次就是顺理成章的选项了。
而学习的难度总是设置于我们当前水平之上的。大部分课本会给人一种这样的感觉:
";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:66:"http://pic1.zhimg.com/70/v2-a441ef727c03c8a483636abe15c83ed0_b.jpg";}}i:15;s:76:"
而且,一款游戏的流行,社交元素也是一个重要因素。
";i:16;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:9:{i:0;s:7:"
[*]「";i:1;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:15:"大家都在玩";}}i:2;s:3:"」";i:3;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:4;s:160:"当周围人都在中路推塔,群体的无形压力会让我们倾向于表现出从众行为,结果就是我们也跑到了王者峡谷清理兵线。
[*]";i:5;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:6;s:265:"社会比较时时刻刻存在于我们的生活当中,但游戏提供了一个更激烈的角斗场。游戏中的各种天梯分、段位、好友排名都在提醒着你的江湖地位如何。就连微信跳一跳,都要提示你超越了多少好友。
[*]";i:7;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:39:"一起玩游戏产生群体归属感。";}}i:8;s:286:"人是很喜欢抱团的动物。一起玩游戏的同好很容易形成亲友团、工会之类的小群体,游戏是小群体内的话题,也是成员互动的方式。当你感受到亲友团的温暖,群体归属感便油然而生,而这是超越了游戏本身的东西。
";}}i:17;s:94:"
学习好枯燥,游戏好好玩,可是高考只考学习,不考游戏,怎么办?
";i:18;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:9:{i:0;s:4:"
[*]";i:1;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:2;s:54:"与其一味地死读书、读死书,不如用它去";i:3;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:30:"解决我们感兴趣的问题";}}i:4;s:275:"。这样不仅能在实践中加深对知识的理解,也能从中收获控制感和自我效能感。比如沉迷吃鸡的同学可以用学到的物理知识计算一下,绝地求生中,用 4 倍镜 98k 瞄准 400 米外的敌人时该把枪口抬升多高呢?
[*]";i:5;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:30:"解决难度合理的问题。";}}i:6;s:274:"如果缺少解决问题的背景知识,或者问题难度超出了我们的能力,我们体验到的将会是挫败感而不是控制感。因此,不要一味挑战自己无法解决的问题,解决难度合理的问题,保持我们一定水平的控制感。
[*]";i:7;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:39:"增加社交元素,如合作学习。";}}i:8;s:166:"跟有自己学习水平相当的同学合作学习,例如一起制定学习进度或目标,良性竞争,提高学习动力。让社会比较为我们服务。
";}}i:19;s:1:"
";i:20;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"http://www.zhihu.com/question/34567239";s:8:"original";a:2:{i:0;s:46:"[URL='http://www.zhihu.com/question/34567239']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:18:"查看知乎讨论";}}}, 1621686945, 1714883457
Run Time: 0.002360