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.000487
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.000151
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.000151
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.000668
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 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.000337
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 |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: c9f37198b5770d432074296090f90354, a:8:{s:12:"sessionStart";i:1714029441;s:2:"ip";s:4:"w{ ";s:11:"sessionCsrf";s:16:"fFya4lXQcNPc6DHn";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:5:"https";s:12:"fullBasePath";s:31:"https://diendanthammyvien.info/";s:10:"requestUri";s:36:"/misc/quick-navigation-menu?_debug=1";s:7:"fullUri";s:66:"https://diendanthammyvien.info/misc/quick-navigation-menu?_debug=1";}}}, 1714033041
Run Time: 0.000274
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, w{ , w{ , XenForo_ControllerPublic_Misc, QuickNavigationMenu, valid, , 1714029441,
Run Time: 0.000105
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_wrapper', 'wf_widget_threads', 'quick_navigation_menu', '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.000396
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 14 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc_99c9ea3b1c3aad5b0f757')
Run Time: 0.000186
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_26abf335742fb8e90c1e1')
Run Time: 0.000109
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_26abf335742fb8e90c1e1, a:2:{s:29:"quick_navigation_menu_lock_17";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1714029441;}s:29:"quick_navigation_menu_lock_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714025834;}}
Run Time: 0.000309
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.000894
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.000327
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.000459
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.000457
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.000308
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.000372
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.000342
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_99c9ea3b1c3aad5b0f757, a:2:{s:24:"quick_navigation_menu_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:1714029441;}s:24:"quick_navigation_menu_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:1714025834;}}
Run Time: 0.000467
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_26abf335742fb8e90c1e1, a:2:{s:29:"quick_navigation_menu_lock_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714029441;}s:29:"quick_navigation_menu_lock_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714025834;}}
Run Time: 0.000168
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.000529
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.000459
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.000366
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.000111
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.000377
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.000216
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.000332
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.000320
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_26abf335742fb8e90c1e1, a:2:{s:29:"quick_navigation_menu_lock_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714029441;}s:29:"quick_navigation_menu_lock_16";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1714029441;}}
Run Time: 0.000315
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 > 1711005441)
ORDER BY thread.view_count DESC
LIMIT 27
Run Time: 0.001215
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, 11, 16, 16)
Run Time: 0.000350
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, 5151, 5174, 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.000323
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, 5151, 5174, 5179, 5183, 5117, 5077)
Run Time: 0.000219
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.000299
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, 5151, 5174, 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.000289
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_99c9ea3b1c3aad5b0f757, a:2:{s:24:"quick_navigation_menu_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:1714029441;}s:24:"quick_navigation_menu_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-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-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-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:1714029441;}}
Run Time: 0.000442
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_26abf335742fb8e90c1e1, a:2:{s:29:"quick_navigation_menu_lock_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714029441;}s:29:"quick_navigation_menu_lock_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714029441;}}
Run Time: 0.000176
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.000229
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 8 | Using where |