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.000498
| 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.000181
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: brmsModernStatisticCache
Run Time: 0.000116
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000167
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
0 AS forum_is_watched
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: 87
Run Time: 0.001569
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT COUNT(*)
FROM xf_thread AS thread
WHERE ((thread.node_id = 87) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))) AND (thread.schedule_thread_date = 0)Run Time: 0.026002
| 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_sticky_state_last_post | 6 | const,const,const | 136 | Using index condition; Using where |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id = 87) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))) AND (thread.schedule_thread_date = 0)
ORDER BY thread.last_post_date DESC
LIMIT 20 OFFSET 80Run Time: 0.003572
| 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_sticky_state_last_post | 6 | const,const,const | 136 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 13baf0ef2aeff59b51da52db6db783ac, , 1781141276
Run Time: 0.000153
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_Forum, Forum, valid, node_id=87&page=5, 1781137676,
Run Time: 0.000080
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'BRQCT_forum_list_nodes', 'BRQCT_ad_sidebar_top', 'BRQCT_button_top_ctrl', 'wf_widget_wrapper', 'wf_widget_online_staff', 'wf_widget_threads', 'wf_widget_stats', 'wf_widget_online_users', 'BRMS_ModernStatistic', 'BRMS_modern_statistic_header', 'forum_view', 'xenCODE_Meta_Keywords', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?Params: 2, 2
Run Time: 0.007754
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 16 | Using where |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1781136776)
ORDER BY session_activity.view_date DESC
Run Time: 0.000599
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 39 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.session_activity.user_id | 1 | |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_forum_view', 'wfc__1_forum_view_f87')Run Time: 0.001124
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc_fbe8df12a2dd7d995b4be')Run Time: 0.000558
| 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_fbe8df12a2dd7d995b4be, a:2:{s:22:"forum_view_lock_f87_17";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1781137676;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1781129096;}}
Run Time: 0.000303
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000588
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | | | | | 62 | 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.000810
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 62 | Using where |
SELECT thread.*
,
1 AS fetched_last_post_user, user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.last_post_user_id)
WHERE ((thread.node_id IN ('37', '2', '3', '4', '5', '7', '8', '9', '10', '12', '13', '14', '15', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '34', '35', '38', '39', '42', '43', '44', '45', '46', '47', '48', '49', '50', '40', '41', '51', '54', '55', '56', '57', '58', '59', '60', '52', '53', '61', '62', '63', '72', '75', '16', '18', '21', '64', '65', '66', '19', '20', '68', '69', '70', '76', 87, 6, 110, 77, 78, 79, 80, 81)) AND (thread.discussion_state IN ('visible')) AND (thread.reply_count > 0)) AND (thread.schedule_thread_date = 0)
ORDER BY thread.last_post_date DESC
LIMIT 15Run Time: 0.031852
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | index | node_id_last_post_date,node_id_sticky_state_last_post | last_post_date | 4 | | 15 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.last_post_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 (80, 80, 80, 80, 80, 80, 80, 12, 80, 80, 40, 80, 80, 80, 80)
Run Time: 0.000342
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 3 | Using where |
| SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.node.node_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_forum_view_f87, a:2:{s:17:"forum_view_f87_17";a:2:{s:4:"html";s:3493:"<div class="avatarList">
<ul>
<li class="thread-20371 thread-node-80">
<a href="members/ngxlamdntd.18359/" class="avatar Av18359s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ngxlamdntd" /></a>
<a title="1 link robot mua bán do tự tay mình làm" class="Tooltip"
href="posts/31656/">
1 link robot mua bán do tự tay...
</a>
<div class="userTitle">
<a href="members/ngxlamdntd.18359/" class="username">ngxlamdntd</a> replied <abbr class="DateTime" data-time="1780991171" data-diff="146505" data-datestring="9/6/26" data-timestring="14:46">9/6/26 lúc 14:46</abbr>
</div>
</li>
<li class="thread-7317 thread-node-80">
<a href="members/phong-lam.32796/" class="avatar Av32796s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Phong Lâm" /></a>
<a title="Chia sẻ code amibroker báo điểm mua và bán" class="Tooltip"
href="posts/31610/">
Chia sẻ code amibroker báo điểm...
</a>
<div class="userTitle">
<a href="members/phong-lam.32796/" class="username">Phong Lâm</a> replied <span class="DateTime" title="15/5/26 lúc 08:54">15/5/26</span>
</div>
</li>
<li class="thread-9493 thread-node-80">
<a href="members/shenlong.33831/" class="avatar Av33831s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_s.png" width="48" height="48" alt="shenlong" /></a>
<a title="CHIA SẺ BẢNG VOLUME THEO DÕI MUA/BÁN CHỦ ĐỘNG, KÈM BỘ LỌC BIẾN ĐỘNG GIÁ, KHỐI LƯỢNG BÙNG NỔ" class="Tooltip"
href="posts/31609/">
CHIA SẺ BẢNG VOLUME THEO DÕI...
</a>
<div class="userTitle">
<a href="members/shenlong.33831/" class="username">shenlong</a> replied <span class="DateTime" title="14/5/26 lúc 17:04">14/5/26</span>
</div>
</li>
<li class="thread-18734 thread-node-80">
<a href="members/ngxlamdntd.18359/" class="avatar Av18359s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ngxlamdntd" /></a>
<a title="Xin code xuất dữ liệu chứng khoán ra file excel: Giá cp theo ngày" class="Tooltip"
href="posts/31447/">
Xin code xuất dữ liệu chứng...
</a>
<div class="userTitle">
<a href="members/ngxlamdntd.18359/" class="username">ngxlamdntd</a> replied <span class="DateTime" title="5/5/26 lúc 08:22">5/5/26</span>
</div>
</li>
<li class="thread-9565 thread-node-80">
<a href="members/vu-trung-an.25447/" class="avatar Av25447s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="vũ trung an" /></a>
<a title="Bộ code giao thoa các đường EMA 3,5,10,15,20 của Vol và Giá." class="Tooltip"
href="posts/31422/">
Bộ code giao thoa các đường EMA...
</a>
<div class="userTitle">
<a href="members/vu-trung-an.25447/" class="username">vũ trung an</a> replied <span class="DateTime" title="3/5/26 lúc 23:05">3/5/26</span>
</div>
</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:1781137676;}s:17:"forum_view_f87_16";a:2:{s:4:"html";s:0:"";s:4:"time";i:1781129096;}}
Run Time: 0.001552
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_fbe8df12a2dd7d995b4be, a:2:{s:22:"forum_view_lock_f87_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1781137676;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1781129096;}}
Run Time: 0.000305
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_fbe8df12a2dd7d995b4be, a:2:{s:22:"forum_view_lock_f87_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1781137676;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1781137676;}}
Run Time: 0.000333
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 ('37', '2', '3', '4', '5', '7', '8', '9', '10', '12', '13', '14', '15', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '34', '35', '38', '39', '42', '43', '44', '45', '46', '47', '48', '49', '50', '40', '41', '51', '54', '55', '56', '57', '58', '59', '60', '52', '53', '61', '62', '63', '72', '75', '16', '18', '21', '64', '65', '66', '19', '20', '68', '69', '70', '76', 87, 6, 110, 77, 78, 79, 80, 81)) AND (thread.discussion_state IN ('visible'))) AND (thread.post_date > 1780705676)) AND (thread.schedule_thread_date = 0)
ORDER BY thread.view_count DESC
LIMIT 15Run Time: 0.001386
| 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 | | 1 | Using index condition; Using where; Using filesort |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.user_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_forum_view_f87, a:2:{s:17:"forum_view_f87_17";a:2:{s:4:"html";s:3493:"<div class="avatarList">
<ul>
<li class="thread-20371 thread-node-80">
<a href="members/ngxlamdntd.18359/" class="avatar Av18359s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ngxlamdntd" /></a>
<a title="1 link robot mua bán do tự tay mình làm" class="Tooltip"
href="posts/31656/">
1 link robot mua bán do tự tay...
</a>
<div class="userTitle">
<a href="members/ngxlamdntd.18359/" class="username">ngxlamdntd</a> replied <abbr class="DateTime" data-time="1780991171" data-diff="146505" data-datestring="9/6/26" data-timestring="14:46">9/6/26 lúc 14:46</abbr>
</div>
</li>
<li class="thread-7317 thread-node-80">
<a href="members/phong-lam.32796/" class="avatar Av32796s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Phong Lâm" /></a>
<a title="Chia sẻ code amibroker báo điểm mua và bán" class="Tooltip"
href="posts/31610/">
Chia sẻ code amibroker báo điểm...
</a>
<div class="userTitle">
<a href="members/phong-lam.32796/" class="username">Phong Lâm</a> replied <span class="DateTime" title="15/5/26 lúc 08:54">15/5/26</span>
</div>
</li>
<li class="thread-9493 thread-node-80">
<a href="members/shenlong.33831/" class="avatar Av33831s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_s.png" width="48" height="48" alt="shenlong" /></a>
<a title="CHIA SẺ BẢNG VOLUME THEO DÕI MUA/BÁN CHỦ ĐỘNG, KÈM BỘ LỌC BIẾN ĐỘNG GIÁ, KHỐI LƯỢNG BÙNG NỔ" class="Tooltip"
href="posts/31609/">
CHIA SẺ BẢNG VOLUME THEO DÕI...
</a>
<div class="userTitle">
<a href="members/shenlong.33831/" class="username">shenlong</a> replied <span class="DateTime" title="14/5/26 lúc 17:04">14/5/26</span>
</div>
</li>
<li class="thread-18734 thread-node-80">
<a href="members/ngxlamdntd.18359/" class="avatar Av18359s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ngxlamdntd" /></a>
<a title="Xin code xuất dữ liệu chứng khoán ra file excel: Giá cp theo ngày" class="Tooltip"
href="posts/31447/">
Xin code xuất dữ liệu chứng...
</a>
<div class="userTitle">
<a href="members/ngxlamdntd.18359/" class="username">ngxlamdntd</a> replied <span class="DateTime" title="5/5/26 lúc 08:22">5/5/26</span>
</div>
</li>
<li class="thread-9565 thread-node-80">
<a href="members/vu-trung-an.25447/" class="avatar Av25447s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="vũ trung an" /></a>
<a title="Bộ code giao thoa các đường EMA 3,5,10,15,20 của Vol và Giá." class="Tooltip"
href="posts/31422/">
Bộ code giao thoa các đường EMA...
</a>
<div class="userTitle">
<a href="members/vu-trung-an.25447/" class="username">vũ trung an</a> replied <span class="DateTime" title="3/5/26 lúc 23:05">3/5/26</span>
</div>
</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:1781137676;}s:17:"forum_view_f87_16";a:2:{s:4:"html";s:0:"";s:4:"time";i:1781137676;}}
Run Time: 0.000251
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_fbe8df12a2dd7d995b4be, a:2:{s:22:"forum_view_lock_f87_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1781137676;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1781137676;}}
Run Time: 0.001167
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000155
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1781136776)
ORDER BY session_activity.view_date DESC
Run Time: 0.000506
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 39 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.session_activity.user_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRQCT_button_top_ctrl', 'BRQCT_navigation_tabs_forums')
AND style_id = ?
AND language_id = ?Params: 2, 2
Run Time: 0.000198
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRQCT_button_top_ctrl', 'nat_bodyjs')
AND style_id = ?
AND language_id = ?Params: 2, 2
Run Time: 0.000349
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |