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.001403
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.000147
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.000213
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.000148
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000267
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: 289396
Run Time: 0.000551
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.000593
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: 289396
Run Time: 0.002115
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: 289396
Run Time: 0.000088
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 4d22409caa378b2aa70b21f89d098ef0, , 1714334779
Run Time: 0.000991
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=289396, 1714331179,
Run Time: 0.000116
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, 296013, a:5:{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:64:"http://pic3.zhimg.com/v2-c9df8ce90f8fdd4b402c22cb041e0cce_is.jpg";}}i:1;s:12:" Justin Lee ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"https://www.zhihu.com/question/348003746/answer/856266031";s:8:"original";a:2:{i:0;s:65:"[URL='https://www.zhihu.com/question/348003746/answer/856266031']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}i:3;s:3478:"
以前我们老师讲个人行为和社会规则的关系时,举了一个案例:
酗完酒在外面砸路灯等公共财物,这个不用说,国家肯定得列为违法行为。
如果你个人只是在家里酗酒砸自己家东西,除非上升为家暴,要不然酗酒本身法律这种社会规则是不会管你的。
但是,如果整个国家有四分之一的人,当然也可以是五分之一或者其他比例,但总之是不少人,在家酗酒砸自家财物,这就成了社会问题了,国家肯定会通过法律法规来规范。
啃老这事比较类似,1999 年媒体统计中国有 15.6 万啃老族,那时候的啃老,主要是指大学毕业之后不愿意去工作,闲在家里吃父母的喝父母的——注意,1999 年全国普通高校毕业生 84.76 万。
当年对于啃老族,媒体和社会的口径高度一致——指责、批判,让他们抬不起头。
可后来呢?越来越多的年轻人买房靠掏空“六个钱包”。
2018 年的调查显示,90%的年轻人表示在买房的的时候父母给垫付了一部分首付,有的是父母是全款给买的,在这其中有 80%的人非常感谢自己的父母,知道父母的辛苦;但是 10%的人认为父母有钱,就应该给自己买房子。
因为靠父母的人多了,社会舆论也就变了,几乎所有人都异口同声地说“现在这房价,年轻人不靠父母哪里买得起”“父母的钱自己放着肯定会贬值,凑给我买房,则可以升值”——大家自己屁股沟里有屎,也就不好再指责别人了。
因为一个买房,媒体对啃老闭嘴了,社会大众对啃老的态度,不仅仅是宽容,甚至成了鼓励——靠父母买了房虽然依然是啃老的一种,甚至比那些闲在家里吃喝的人啃得更狠,但因为房价上升了,原先受到指责的事情,现在变成一件让人自豪的事情。
身边偶尔有宁愿错过房价浪潮,也不愿意用父母的钱付首付的,大家都毫不避讳地说他是傻子,会活成笑话。
以上说的是媒体和社会对啃老这件事态度前后矛盾的一面。
再从国家的角度来看,当年批判在家啃老不去工作的人,是因为这些人闲在家里,让年轻的社会劳动力减少了,对社会是有害的,所以不管通过舆论还是法律把他们赶到社会上都是好事。
而最近几年呢,房地产发展需要资金支撑,社会流动资金不够,那就得想办法让大家把藏在家里的钱掏出来,不管通过舆论,还是形势逼人,让年轻人把“用父母的钱买房”这一行为合理化,都是对房地产发展有利的。
这样来看,当年指责啃老,和现在默认买房啃老,又有高度的连贯性。
因为如此,2015 年的时候,山东、吉林、江苏、湖南出台或者修改《老年人权益保障条例》时,都规定,“有独立生活能力的成年子女要求老年人经济资助的,老年人有权拒绝。成年子女或者其他亲属不得以无业或者其他理由索取老年人的财物。”——从法律层面赋予了父母拒绝被啃老的权力。
但同时,又把“老年人与子女或者其他亲属共同出资购买、建造的住房,按照出资比例或者约定,依法享有相应份额的所有权和使用权”写进了条例——把买房啃老排除在了啃老行为之外。
与社会现实发展保持了一致。
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:39:"http://www.zhihu.com/question/348003746";s:8:"original";a:2:{i:0;s:47:"[URL='http://www.zhihu.com/question/348003746']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"阅读原文";}}}, 1621686945, 1714331179
Run Time: 0.002426