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.000405
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.000135
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000186
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*
, permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
WHERE node.node_id = ?
Params: 17
Run Time: 0.000257
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT *
FROM xf_node
WHERE lft > ? AND rgt < ?
AND display_in_list = 1
ORDER BY lft ASC
Params: 17, 76
Run Time: 0.000436
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list,lft | | | | 133 | Using where; Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000319
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 133 | Using where |
SELECT forum.*
,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE forum.node_id IN (16, 18, 20, 21, 19, 22, 23, 54, 55, 56, 24, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 25, 67, 68, 69, 26, 27, 70, 28)
Run Time: 0.000500
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 29 | Using where; Using index |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.node.node_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: f5e2ed51fbb45e0dafa3ad11b2c47fe7, a:8:{s:12:"sessionStart";i:1714082262;s:2:"ip";s:4:"-\";s:11:"sessionCsrf";s:16:"aBHQ5-AJl67DKM7u";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1487748357;}s:11:"sedoQuattro";a:1:{s:18:"noJsonRequestPaths";a:6:{s:8:"basePath";s:1:"/";s:4:"host";s:22:"diendanthammyvien.info";s:8:"protocol";s:4:"http";s:12:"fullBasePath";s:30:"http://diendanthammyvien.info/";s:10:"requestUri";s:44:"/categories/kinh-nghiem-tham-my.17/?_debug=1";s:7:"fullUri";s:73:"http://diendanthammyvien.info/categories/kinh-nghiem-tham-my.17/?_debug=1";}}}, 1714085862
Run Time: 0.000165
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_Category, Index, valid, node_id=17, 1714082262,
Run Time: 0.000083
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'node_forum_level_n', 'node_forum_level_2', 'wf_widget_wrapper', 'wf_widget_threads', 'waindigo_library_list_thumbnail_thumbnails', 'waindigo_library_list_replace_thumbnails', 'waindigo_forum_list_thumbnail_thumbnails', 'waindigo_forum_list_replace_thumbnails', 'category_view', 'wf_hook_moderator_bar', 'wf_revealer', 'tinhte_xentag_bb_code_tag_tag', 'tinhte_xentag_hook_message_below', 'tinhte_xentag_hook_message_content', 'tinhte_xentag_hook_message_notices', 'tinhte_xentag_hook_navigation_tabs_forums', 'tinhte_xentag_hook_post_private_controls', 'tinhte_xentag_hook_post_public_controls', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000318
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 20 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_category_view')
Run Time: 0.000314
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_category_view_lock')
Run Time: 0.000095
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_category_view_lock, a:2:{s:21:"category_view_lock_17";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1714082262;}s:21:"category_view_lock_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714055328;}}
Run Time: 0.000313
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (thread.node_id IN ('36')) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC
LIMIT 15
Run Time: 0.000705
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | const | 47 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.thread.user_id | 1 | |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000295
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 133 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id IN (36, 36, 36, 36, 36, 36, 36, 36, 36, 36, 36, 36, 36, 36, 36)
Run Time: 0.000325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | range | PRIMARY | PRIMARY | 4 | | 1 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.forum.node_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (4990, 4967, 4876, 4711, 4684)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000346
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 8 | Using index condition; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | Using where |
SELECT
post.*
FROM xf_post AS post
WHERE post.post_id IN (4990, 4967, 4876, 4711, 4684)
Run Time: 0.000219
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 36
Run Time: 0.000324
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 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (4990, 4967, 4876, 4711, 4684)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000307
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 8 | Using index condition; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | Using where |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_category_view, a:2:{s:16:"category_view_17";a:2:{s:4:"html";s:2104:"<div class="avatarList sublink box">
<ul>
<li class="thread-2685 thread-node-36 sublinkLi first">
<h6>
<a
href="t/ai-co-nguy-co-mac-cholesterol-cao.2685/">
Ai có nguy cơ mắc cholesterol cao?
</a>
</h6>
<div class="article_SK last article_SK_big">
<div style="height:90px; width:120px; overflow:hidden; float: left; margin-right: 8px;">
<a href="t/ai-co-nguy-co-mac-cholesterol-cao.2685/">
<img class="img_90_120" src="https://suckhoedoisong.qltns.mediacdn.vn/324455921873985536/2023/9/9/edit-giam-cholesterol3-16409393266701785838554-1694268540590750662914.jpeg"/>
</a>
</div>
</div>
</li>
<li class="thread-2662 thread-node-36 sublinkLi ">
<a title="Tại sao vết thÆ°Æ¡ng lâu là nh? DÆ°á»›i đây là những Ä‘iá»u bạn cần cân nhắc." class="Tooltip"
href="t/tai-sao-vet-thuong-lau-lanh-duoi-day-la-nhung-dieu-ban-can-can-nhac.2662/">
Tại sao vết thương lâu là nh? Dưới đây...
</a>
</li>
<li class="thread-2572 thread-node-36 sublinkLi ">
<a title="Sau khi phun môi nên sỠdụng son dưỡng nà o?" class="Tooltip"
href="t/sau-khi-phun-moi-nen-su-dung-son-duong-nao.2572/">
Sau khi phun môi nên sỠdụng son dưỡng...
</a>
</li>
<li class="thread-2410 thread-node-36 sublinkLi ">
<a title="Miếng dán vết thương thay chỉ khâu 3M Steri Strip: Hướng dẫn sỠdụng" class="Tooltip"
href="t/mieng-dan-vet-thuong-thay-chi-khau-3m-steri-strip-huong-dan-su-dung.2410/">
Miếng dán vết thương thay chỉ khâu 3M...
</a>
</li>
<li class="thread-2387 thread-node-36 sublinkLi ">
<a
href="t/nen-tay-not-ruoi-nao-cho-hop-phong-thuy.2387/">
Nên tẩy nốt ruồi nà o cho hợp phong thủy?
</a>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Äang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1714082262;}s:16:"category_view_16";a:2:{s:4:"html";s:2752:"<div class="avatarList sublink box">
<ul>
<li class="thread-2875 thread-node-16 sublinkLi first">
<h6>
<a title="Giải đáp: Cho con bú ngực có bị chảy xệ không" class="Tooltip"
href="t/giai-dap-cho-con-bu-nguc-co-bi-chay-xe-khong.2875/">
Giải đáp: Cho con bú ngực có bị chảy...
</a>
</h6>
<div class="article_SK last article_SK_big">
<div style="height:90px; width:120px; overflow:hidden; float: left; margin-right: 8px;">
<a href="t/giai-dap-cho-con-bu-nguc-co-bi-chay-xe-khong.2875/">
<img class="img_90_120" src="https://thammyngomonghung.vn/wp-content/uploads/2019/07/hinh-nguc-nho-4.jpg"/>
</a>
</div>
</div>
</li>
<li class="thread-2764 thread-node-16 sublinkLi ">
<a
href="t/dai-quan-nong-giam-mo-bung-cua-nhat.2764/">
Äai quấn nóng giảm mỡ bụng của Nháºt
</a>
</li>
<li class="thread-2849 thread-node-16 sublinkLi ">
<a
href="t/dai-giam-mo-bung-cua-nhat-ban.2849/">
Äai giảm mỡ bụng của Nháºt Bản
</a>
</li>
<li class="thread-2868 thread-node-16 sublinkLi ">
<a title="Cách chăm sóc ngá»±c chảy xệ sau sinh khoa há»c" class="Tooltip"
href="t/cach-cham-soc-nguc-chay-xe-sau-sinh-khoa-hoc.2868/">
Cách chăm sóc ngực chảy xệ sau sinh...
</a>
</li>
<li class="thread-2845 thread-node-16 sublinkLi ">
<a
href="t/thu-gon-nguc-chay-xe-co-dau-khong-chi-em.2845/">
Thu gá»n ngá»±c chảy xệ có Ä‘au không chị em?
</a>
</li>
<li class="thread-2873 thread-node-16 sublinkLi ">
<a
href="t/3-bai-cardio-giam-mo-bung-cho-nu.2873/">
3 bà i cardio giảm mỡ bụng cho nữ
</a>
</li>
<li class="thread-2877 thread-node-16 sublinkLi ">
<a
href="t/chia-se-cach-chong-nguc-chay-xe-sau-sinh.2877/">
Chia sẻ cách chống ngực chảy xệ sau sinh
</a>
</li>
<li class="thread-2811 thread-node-16 sublinkLi ">
<a
href="t/giai-dap-co-nen-nang-nguc-chay-xe-khong.2811/">
Giải đáp: Có nên nâng ngực chảy xệ không
</a>
</li>
<li class="thread-2771 thread-node-16 sublinkLi last">
<a title="Phương pháp chiếu đèn hồng ngoại giảm mỡ bụng" class="Tooltip"
href="t/phuong-phap-chieu-den-hong-ngoai-giam-mo-bung.2771/">
Phương pháp chiếu đèn hồng ngoại giảm...
</a>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Äang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1714055328;}}
Run Time: 0.000291
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_category_view_lock, a:2:{s:21:"category_view_lock_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714082262;}s:21:"category_view_lock_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714055328;}}
Run Time: 0.000207
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
post.message, post.attach_count,
NULL AS thread_read_date
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
WHERE (thread.node_id IN ('28')) AND (thread.discussion_open = 1) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.last_post_date DESC
LIMIT 27
Run Time: 0.000452
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | const | 78 | Using where; Backward index scan |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.thread.user_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.thread.first_post_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (1297, 1181, 13, 994, 1177, 1314, 1233, 1156, 1219, 1229, 1184, 1159, 1154, 1462)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000402
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 15 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id IN (28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28)
Run Time: 0.000348
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | range | PRIMARY | PRIMARY | 4 | | 1 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.forum.node_id | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (4823, 4670, 1297, 1181, 30, 41, 43, 994)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000349
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 8 | Using index condition; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | Using where |
SELECT
post.*
FROM xf_post AS post
WHERE post.post_id IN (4823, 4670, 1297, 1181, 13, 30, 41, 43, 994)
Run Time: 0.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 9 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 28
Run Time: 0.000289
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 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (4823, 4670, 1297, 1181, 30, 41, 43, 994)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000306
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 8 | Using index condition; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | Using where |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_category_view_lock, a:2:{s:21:"category_view_lock_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714082262;}s:21:"category_view_lock_16";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1714082262;}}
Run Time: 0.000305
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id IN ('2', '3', '4', '5', '6', '12', '13', '16', '18', '20', '21', '19', '22', '23', '24', '25', '26', '27', '28', '30', '31', '32', '34', '35', '36', '37', '38', '45', '46', '39', '41', '42', '43', '44', '8', '9', '14', '10', '15', '11')) AND (thread.discussion_state IN ('visible'))) AND (thread.post_date > 1711058262)
ORDER BY thread.view_count DESC
LIMIT 27
Run Time: 0.001177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 169 | Using index condition; Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.thread.user_id | 1 | |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id IN (16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 11, 16, 16, 16)
Run Time: 0.000328
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.forum.node_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (5181, 5070, 5155, 5174, 5151, 5179, 5183, 5117, 5077)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000301
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 9 | Using index condition; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | Using where |
SELECT
post.*
FROM xf_post AS post
WHERE post.post_id IN (5181, 5070, 5155, 5174, 5151, 5179, 5183, 5117, 5077)
Run Time: 0.000222
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 9 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 16
Run Time: 0.000292
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 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (5181, 5070, 5155, 5174, 5151, 5179, 5183, 5117, 5077)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000287
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 9 | Using index condition; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | ddtm.attachment.data_id | 1 | Using where |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_category_view, a:2:{s:16:"category_view_17";a:2:{s:4:"html";s:2104:"<div class="avatarList sublink box">
<ul>
<li class="thread-2685 thread-node-36 sublinkLi first">
<h6>
<a
href="t/ai-co-nguy-co-mac-cholesterol-cao.2685/">
Ai có nguy cơ mắc cholesterol cao?
</a>
</h6>
<div class="article_SK last article_SK_big">
<div style="height:90px; width:120px; overflow:hidden; float: left; margin-right: 8px;">
<a href="t/ai-co-nguy-co-mac-cholesterol-cao.2685/">
<img class="img_90_120" src="https://suckhoedoisong.qltns.mediacdn.vn/324455921873985536/2023/9/9/edit-giam-cholesterol3-16409393266701785838554-1694268540590750662914.jpeg"/>
</a>
</div>
</div>
</li>
<li class="thread-2662 thread-node-36 sublinkLi ">
<a title="Tại sao vết thÆ°Æ¡ng lâu là nh? DÆ°á»›i đây là những Ä‘iá»u bạn cần cân nhắc." class="Tooltip"
href="t/tai-sao-vet-thuong-lau-lanh-duoi-day-la-nhung-dieu-ban-can-can-nhac.2662/">
Tại sao vết thương lâu là nh? Dưới đây...
</a>
</li>
<li class="thread-2572 thread-node-36 sublinkLi ">
<a title="Sau khi phun môi nên sỠdụng son dưỡng nà o?" class="Tooltip"
href="t/sau-khi-phun-moi-nen-su-dung-son-duong-nao.2572/">
Sau khi phun môi nên sỠdụng son dưỡng...
</a>
</li>
<li class="thread-2410 thread-node-36 sublinkLi ">
<a title="Miếng dán vết thương thay chỉ khâu 3M Steri Strip: Hướng dẫn sỠdụng" class="Tooltip"
href="t/mieng-dan-vet-thuong-thay-chi-khau-3m-steri-strip-huong-dan-su-dung.2410/">
Miếng dán vết thương thay chỉ khâu 3M...
</a>
</li>
<li class="thread-2387 thread-node-36 sublinkLi ">
<a
href="t/nen-tay-not-ruoi-nao-cho-hop-phong-thuy.2387/">
Nên tẩy nốt ruồi nà o cho hợp phong thủy?
</a>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Äang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1714082262;}s:16:"category_view_16";a:2:{s:4:"html";s:2752:"<div class="avatarList sublink box">
<ul>
<li class="thread-2875 thread-node-16 sublinkLi first">
<h6>
<a title="Giải đáp: Cho con bú ngực có bị chảy xệ không" class="Tooltip"
href="t/giai-dap-cho-con-bu-nguc-co-bi-chay-xe-khong.2875/">
Giải đáp: Cho con bú ngực có bị chảy...
</a>
</h6>
<div class="article_SK last article_SK_big">
<div style="height:90px; width:120px; overflow:hidden; float: left; margin-right: 8px;">
<a href="t/giai-dap-cho-con-bu-nguc-co-bi-chay-xe-khong.2875/">
<img class="img_90_120" src="https://thammyngomonghung.vn/wp-content/uploads/2019/07/hinh-nguc-nho-4.jpg"/>
</a>
</div>
</div>
</li>
<li class="thread-2764 thread-node-16 sublinkLi ">
<a
href="t/dai-quan-nong-giam-mo-bung-cua-nhat.2764/">
Äai quấn nóng giảm mỡ bụng của Nháºt
</a>
</li>
<li class="thread-2849 thread-node-16 sublinkLi ">
<a
href="t/dai-giam-mo-bung-cua-nhat-ban.2849/">
Äai giảm mỡ bụng của Nháºt Bản
</a>
</li>
<li class="thread-2868 thread-node-16 sublinkLi ">
<a title="Cách chăm sóc ngá»±c chảy xệ sau sinh khoa há»c" class="Tooltip"
href="t/cach-cham-soc-nguc-chay-xe-sau-sinh-khoa-hoc.2868/">
Cách chăm sóc ngực chảy xệ sau sinh...
</a>
</li>
<li class="thread-2845 thread-node-16 sublinkLi ">
<a
href="t/thu-gon-nguc-chay-xe-co-dau-khong-chi-em.2845/">
Thu gá»n ngá»±c chảy xệ có Ä‘au không chị em?
</a>
</li>
<li class="thread-2873 thread-node-16 sublinkLi ">
<a
href="t/3-bai-cardio-giam-mo-bung-cho-nu.2873/">
3 bà i cardio giảm mỡ bụng cho nữ
</a>
</li>
<li class="thread-2877 thread-node-16 sublinkLi ">
<a
href="t/chia-se-cach-chong-nguc-chay-xe-sau-sinh.2877/">
Chia sẻ cách chống ngực chảy xệ sau sinh
</a>
</li>
<li class="thread-2811 thread-node-16 sublinkLi ">
<a
href="t/giai-dap-co-nen-nang-nguc-chay-xe-khong.2811/">
Giải đáp: Có nên nâng ngực chảy xệ không
</a>
</li>
<li class="thread-2771 thread-node-16 sublinkLi last">
<a title="Phương pháp chiếu đèn hồng ngoại giảm mỡ bụng" class="Tooltip"
href="t/phuong-phap-chieu-den-hong-ngoai-giam-mo-bung.2771/">
Phương pháp chiếu đèn hồng ngoại giảm...
</a>
</li>
</ul>
</div>
<div id="PreviewTooltip">
<span class="arrow"><span></span></span>
<div class="section">
<div class="primaryContent previewContent">
<span class="PreviewContents">Äang tải...</span>
</div>
</div>
</div>";s:4:"time";i:1714082262;}}
Run Time: 0.000458
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_category_view_lock, a:2:{s:21:"category_view_lock_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714082262;}s:21:"category_view_lock_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714082262;}}
Run Time: 0.000155
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('tinhte_xentag_bb_code_tag_hashtag', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'nat_bodyjs')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000207
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 8 | Using where |