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.000470
| 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.000175
| 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.000143
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: aa80c7d9662266ba297220dfe95108f5, 1716124597
Run Time: 0.000171
| 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.000182
| 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: 183155
Run Time: 0.000522
| 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.000484
| 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: 183155
Run Time: 0.004105
| 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: 183155
Run Time: 0.000102
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'aa80c7d9662266ba297220dfe95108f5')
Params: 1716128197
Run Time: 0.000766
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=183155, 1716124597,
Run Time: 0.000135
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, 188066, a:38:{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:58:"http://pic4.zhimg.com/cddada1c56eab384ed81e44fa337438f.jpg";}}i:1;s:1:"
";i:2;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"5";s:8:"original";a:2:{i:0;s:8:"[SIZE=5]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;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:57:"怎样看待 “80% 的儿童都自慰过” 的现象？";}}}}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:38:"http://pic1.zhimg.com/da8e974dc_is.jpg";}}i:5;s:181:" 威廉·西尔斯，「丁香医生」作者
不是只有成人才会自慰，三四岁的孩子也会。但儿童自慰的形式不同于成人。儿童自慰的常见形式：
";i:6;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:114:"
[*]用手触摸、抚弄外生殖器；
[*]倚靠在桌子、椅子边缘或骑跨在凳子上摩擦阴部等。
";}}i:7;s:213:"
成人自慰可能是为获得快感，但对于学龄前儿童，这种行为与其说是「自慰」，更准确地讲，倒不如说是「发现生殖器」。
孩子这么小就自慰，真的正常吗？
";i:8;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:34:"http://dxy.com/column/2770?from=zh";s:8:"original";a:2:{i:0;s:42:"[URL='http://dxy.com/column/2770?from=zh']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:168:"其实，根据调查，7 岁以下的儿童 10% 都有过自慰行为，随着年龄的增长，这个比例迅速升高。13 岁以下自慰过的儿童高达 80% 。";}}i:9;s:35:"你还记得自己的经历吗？
";i:10;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:24:"孩子为什么自慰？";}}i:11;s:368:"
在儿童探索身体各器官及快感的阶段，抚弄自己的生殖器很正常。这一行为可能在婴儿期就开始了。
生殖器有很多敏感的神经，爱抚生殖器产生的感觉很容易让孩子「神魂颠倒」。
如果孩子感到无聊，或是拿走了能抚慰他的东西（例如安抚奶嘴），可能就会转而开始自慰。
";i:12;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:260:"
[*]儿童自慰一般是正常的，但也可能是其他原因引起的：
[*]阴部疾病或刺激，如湿疹、包皮炎、内裤大小不合适；
[*]被忽视或精神压力大，如缺乏家长关注、常被指责；
[*]遭到性侵犯、性虐待。
";}}i:13;s:2:"
";i:14;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:15;s:392:"
当你推开 4 岁孩子的卧室门，发现他正在「和自己玩」，千万别忙着下结论，更不能指责孩子。
因为你并不清楚，孩子是在探索身体，还是真的患上了什么疾病。
你的过度反应可能让孩子觉得，身体某些部位是「肮脏的」或者触碰某些部位是「不对的」；更严重的可能会使孩子产生负罪感。
";i:16;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:21:"应该如何应对？";}}i:17;s:2:"
";i:18;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:"1. 寻找诱因";}}i:19;s:2:"
";i:20;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:205:"
[*]检查孩子的内裤是否合身，是否存在太紧的情况；
[*]洗澡时，注意查看孩子的阴部是否存在湿疹或红肿的情况；
[*]孩子是否遭遇了性侵害等暴力事件。
";}}i:21;s:73:"
如果不存在以上情况，那你就可以继续观察、疏导。
";i:22;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:"2. 注意观察";}}i:23;s:173:"
孩子什么情况下会玩弄生殖器？是因为他无聊了、累了、孤单、紧张？自慰的次数有没有变多？ 如果可能，把这些内容记下来。
";i:24;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:"3. 转移注意力";}}i:25;s:324:"
转移注意力能解决大部分孩子的问题。如果你看到两岁的女儿「骑在摇摆的玩具上不肯下来」时，试着转移她的注意力，比如带她去游乐园。
如果你觉得孩子靠按摩生殖器来舒缓紧张，那就为她提供其他放松方案，例如帮她挠挠背作为代替。
";i:26;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:"4. 监管";}}i:27;s:175:"
如果孩子正处于探索自我的阶段，至少要确保不能让他玩弄别人的生殖器。孩子们一起在房间里玩的时候，规定他们必须打开门。
";i:28;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:"5. 教育孩子隐私观念";}}i:29;s:261:"
对大多数孩子而言，刺激生殖器是正常的行为。你没法彻底阻止孩子自慰的行为，但是可以控制孩子自慰的地点。
你可以这样告诉孩子：「摸自己的小鸡鸡没关系，但是一定不能让别人看见」。
";i:30;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:31;s:58:"
如果出现下列情况，及时带孩子去医院：
";i:32;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:321:"
[*]阴部湿疹、炎症；
[*]抚弄生殖器变得更加激烈、频繁；
[*]过度摩擦外阴，尤其是女孩，虽然这种情况十分罕见，但有可能导致局部感染；
[*]孩子为了自慰取消社交活动；
[*]抚弄生殖器的行为变得更加公众化；
[*]5 岁后仍在公共场合自慰。
";}}i:33;s:228:"
儿童自慰，通常只是一种探索形式。随着孩子长大，其行为会更加符合他的年龄。
作为父母，最好的应对方式应该是视而不见、给予更多爱，而非促膝长谈、拳脚相加。
";i:34;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:118:"该文章由作者授权丁香医生转载， 并授权知乎、知乎日报发布，拒绝其它任何形式的转载";}}i:35;s:122:"
推荐关注微信公众账号： Dingxiangmami
———————————————
发自知乎专栏「";i:36;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:51:"http://zhuanlan.zhihu.com/dingxiangyisheng/20192584";s:8:"original";a:2:{i:0;s:59:"[URL='http://zhuanlan.zhihu.com/dingxiangyisheng/20192584']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:12:"丁香医生";}}i:37;s:3:"」";}, 1621686945, 1716124597
Run Time: 0.000786