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.000521
| 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.000145
| 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.000144
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000142
| 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: 285065
Run Time: 0.000424
| 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.000375
| 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: 285065
Run Time: 0.002229
| 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: 285065
Run Time: 0.000085
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: eeef0909bdb891b78d99eb5f0b15a957, , 1714357385
Run Time: 0.000750
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=285065, 1714353785,
Run Time: 0.000120
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, 291379, a:40:{i:0;s:85:"日报标题：- 他都被锤成这样了你还信他？ - 我爱他，我相信他
";i:1;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:2;s:174:" 暗涌，The Follower of Psychology
前两天鹿晗关晓彤那事儿听说了吧？
事儿倒没什么稀奇，可粉丝们的反应……可以说是非常豹笑了。
";i:3;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-726c5da9bed0b06153d89e0d715e9104_b.jpg";}}i:4;s:94:"
正好在知乎上看到这个问题，那今天我们就来说一说脑残粉的事儿。
";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:37:"1、这个世上其实只有三种粉";}}i:6;s:85:"
现在饭圈里那些黑话，五花八门。乍一听还真不知道是什么。
";i:7;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-704f4441772ae9ac14d827fb002beb35_b.jpg";}}i:8;s:234:"
什么圈粉脱粉私生粉，唯粉团粉家族粉，音粉颜粉性格粉，路粉妈粉 CP 粉。
别说了，我整个人都粉了。
但不管饭圈发明再多的黑话，在心理学家眼里，只有三种粉。
首先是";i:9;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:10;s:30:"。对偶像的崇拜仅限于";i:11;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:12;s:188:"，差不多就是偶像出的作品感兴趣会看看，消息动态也会附带关注一下，把偶像的动向当做朋友间的谈资，这样就已经很开心了。
再进一步是";i:13;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:14;s:33:"。这样的粉丝具有更多的";i:15;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:16;s:290:"的情感，比如“我感觉偶像就是我的精神伴侣”、“粉我偶像的时候，能暂时地让我从生活中解脱出来”、“坏事发生在偶像身上，就像发生在我身上一样”，并且这种强烈、强迫的感受难以摆脱。
“爱”到深处，就是";i:17;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:18;s:69:"了。说脑残粉还真不过分，因为这类粉丝往往表现出";i:19;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:20;s:394:"，比如常常会有“我感觉和偶像之间的联系无法言传”、“如果我足够幸运能见偶像一面，即使偶像让我帮忙干违法的事，我都很可能去做”、“为了拯救偶像，我宁愿献出生命”之类的想法。
所谓的真爱粉啊，私生粉啊，亲妈粉后妈粉啊，都只是行为上的不同。说到心理状态上出不了这个圈。
";i:21;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:49:"2、一入饭圈深似海：追星的心路历程";}}i:22;s:280:"
咱们也都不是没追过星的人。我记得我喜欢周杰伦那会儿，大晚上钻被窝里抱着手机，一边听他的歌一边看网上的评价，要是有人夸周董人又低调歌又写得好，我都会替他高兴。
我这种状态呢，心理学术语叫做";i:23;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:6:"吸收";}}i:24;s:1086:"，指的是注意力完全专注的状态，将所有可以利用的知觉、生理、想象、观念的资源都投入到对所专注的这一事物整合的表征上。这一过程无需努力，而通过对偶像的心理吸收，试图建立一种身份感、充实感和满足感。
与此同时，对偶像的心理吸收也给人一种与偶像有现实关系的错觉，反过来强化了心理吸收的过程，想更进一步地知道有关偶像的一切；而知道得越多，卷入得越深，就越觉得自己和偶像之间有特殊的关联。这样就形成了一个循环。现在媒体又这么发达，电视电影歌曲写真微博饭圈，总有你看不完的动态，在一定程度上加速了这个过程。
这还没完。心理学家还发现，对偶像的心理吸收似乎会发展出“耐药性”。比如有的人粉鹿晗，原来只是听听歌看看新闻就比较开心了，渐渐地要想达到原来的开心程度，可能就需要去听演唱会、追鹿晗的剧，再到后来，可能就得当私生粉跟踪偶像才行了。
这跟";i:25;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:6:"成瘾";}}i:26;s:60:"的心理机制非常相似。学者将上述过程概括为";i:27;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:28;s:5:"。
";i:29;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:31:"3、脑残粉真的脑残吗？";}}i:30;s:148:"
前段时间薛之谦被李雨桐锤成什么样了，拆谦队快把薛之谦底裤都扒下来了，还有粉丝等着他们的王凯旋呢。
";i:31;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-0728e475e22d78ef4c1ff0bfd5ce2f0c_b.jpg";}}i:32;s:1610:"
所以说，有时候粉丝干的那些事儿，真让人感叹脑残粉不是白叫的。
不光我们这么认为。在一项心理学实验中，美国和英国参与者更多地用“傻”这个词来描述疯狂追星的粉丝们；而针对偶像崇拜的研究显示，粉丝群体的心理健康程度也要更低。
另一项研究也的确发现，粉丝群体的认知水平相对要差一些。不过黑子们也别急着高潮，研究同时也说明，认知水平的差异不足以解释粉丝的狂热行为。
认知灵活性是最与“脑残粉”行为相关联的认知因素。认知灵活性比较高、“有灵性”的人，也许会发现偶像其实就是娱乐行业的骗局，或者发现追星对自己并没有什么改善。有的人甚至会想，既然总有人要成为偶像，那为什么不能是我呢？这样的人要成为脑残粉就比较难。
而认知灵活性较低的人思维会比较僵化，“灵性不足”，更难从对偶像的心理吸收当中挣脱出来，并且难以寻找一个相对健康的自我认同的手段，比如交朋友啊，努力做好一件事之类的。因此容易陷得更深，从而做出一些极端的事情。
所以说到底，脑残粉的确认知水平更差一些，“灵性不足”，拯救身边的脑残粉可以从提高他的“灵性”入手。当然，还需要更多深入的研究才能更加全面的解释狂热追星的现象。
参考文献：
Maltby, J., Day, L., Mccutcheon, L. E., Martin, M. M., & Cayanus, J. L. (2004). Celebrity worship, cognitive flexibility, and social complexity. ";i:33;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:38:"Personality and Individual Differences";}}i:34;s:154:", 37(7), 1475-1482.
Mccutcheon, L. E., Ashe, D. D., Houran, J., & Maltby, J. (2003). A Cognitive Profile of Individuals Who Tend to Worship Celebrities. ";i:35;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:25:"The Journal of Psychology";}}i:36;s:127:", 137(4), 309-322.
Mccutcheon, L. E., Lange, R., & Houran, J. (2002). Conceptualization and measurement of celebrity worship. ";i:37;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:29:"British Journal of Psychology";}}i:38;s:17:", 93(1), 67-87.
";i:39;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:38:"http://www.zhihu.com/question/20590363";s:8:"original";a:2:{i:0;s:46:"[URL='http://www.zhihu.com/question/20590363']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1714353785
Run Time: 0.001151