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.000443
| 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.000101
| 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.000615
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node_id
FROM xf_node
WHERE node_name = ?
Params: phuong-phap-smart-money-concept
Run Time: 0.000396
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ref | node_name_unique | node_name_unique | 153 | const | 1 | Using where; Using index |
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_name = ?
AND node.node_type_id = 'Forum'
Params: phuong-phap-smart-money-concept
Run Time: 0.001505
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY,node_name_unique | node_name_unique | 180 | const,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 = 111) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))) AND (thread.schedule_thread_date = 0)Run Time: 0.002907
| 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 | 11 | 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 = 111) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))) AND (thread.schedule_thread_date = 0)
ORDER BY thread.last_post_date DESC
LIMIT 20Run Time: 0.000926
| 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 | 11 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.user_id | 1 | |
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 = 111) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible'))) AND (thread.schedule_thread_date = 0)
ORDER BY thread.last_post_date DESCRun Time: 0.000379
| 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 | 1 | 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: 87bddf83d720aabb1a0c70019a985033, , 1770841585
Run Time: 0.000137
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_name=phuong-phap-smart-money-concept, 1770837985,
Run Time: 0.000078
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.005154
| 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 > 1770837085)
ORDER BY session_activity.view_date DESC
Run Time: 0.001118
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 109 | 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_f111')Run Time: 0.001519
| 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_2540b876fb3f7b2b08ec2')Run Time: 0.000300
| 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_2540b876fb3f7b2b08ec2, a:2:{s:23:"forum_view_lock_f111_17";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1770837985;}s:23:"forum_view_lock_f111_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1770805710;}}
Run Time: 0.000276
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000532
| 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.000788
| 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', 111, 17, 105, 104, 102, 103)) 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.047307
| 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 | | 17 | 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 (40, 10, 105, 105, 4, 13, 14, 51, 12, 10, 10, 41, 5, 10, 10)
Run Time: 0.000389
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 10 | 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_f111, a:2:{s:18:"forum_view_f111_17";a:2:{s:4:"html";s:3348:"<div class="avatarList">
<ul>
<li class="thread-2623 thread-node-40">
<a href="members/hungphong12.13616/" class="avatar Av13616s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_female_s.png" width="48" height="48" alt="hungphong12" /></a>
<a title="Liệu VSA có phải là phiên bản nâng cấp của phương pháp Wyckoff" class="Tooltip"
href="posts/29625/">
Liệu VSA có phải là phiên bản...
</a>
<div class="userTitle">
<a href="members/hungphong12.13616/" class="username">hungphong12</a> replied <span class="DateTime" title="9/1/26 lúc 19:24">9/1/26</span>
</div>
</li>
<li class="thread-5111 thread-node-10">
<a href="members/beginner2020.13055/" class="avatar Av13055s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_s.png" width="48" height="48" alt="beginner2020" /></a>
<a title="Phần mềm tradeguider phái wycoff chính thống nhất (vsa)" class="Tooltip"
href="posts/28965/">
Phần mềm tradeguider phái...
</a>
<div class="userTitle">
<a href="members/beginner2020.13055/" class="username">beginner2020</a> replied <span class="DateTime" title="31/10/25 lúc 16:51">31/10/25</span>
</div>
</li>
<li class="thread-3985 thread-node-105">
<a href="members/blackbearvn.32964/" class="avatar Av32964s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Blackbearvn" /></a>
<a title="Toàn bộ lý thuyết về Wyckoff - VSA - VPA được tổng hợp ở bộ tài liệu này." class="Tooltip"
href="posts/26915/">
Toàn bộ lý thuyết về...
</a>
<div class="userTitle">
<a href="members/blackbearvn.32964/" class="username">Blackbearvn</a> replied <span class="DateTime" title="24/8/25 lúc 09:27">24/8/25</span>
</div>
</li>
<li class="thread-15314 thread-node-105">
<a href="members/c-luan.26571/" class="avatar Av26571s" data-avatarhtml="true"><img src="data/avatars/s/26/26571.jpg?1715248266" width="48" height="48" alt="C.Luận" /></a>
<a title="Phương pháp Wyckoff là gì? Hướng dẫn giao dịch đơn giản và hiệu quả" class="Tooltip"
href="posts/26516/">
Phương pháp Wyckoff là gì?...
</a>
<div class="userTitle">
<a href="members/c-luan.26571/" class="username">C.Luận</a> replied <span class="DateTime" title="15/7/25 lúc 15:31">15/7/25</span>
</div>
</li>
<li class="thread-14748 thread-node-4">
<a href="members/tuan-thanh.16960/" class="avatar Av16960s" data-avatarhtml="true"><img src="data/avatars/s/16/16960.jpg?1759944288" width="48" height="48" alt="Tuấn Thành" /></a>
<a
href="posts/25729/">
Dữ liệu cổ phiếu 68
</a>
<div class="userTitle">
<a href="members/tuan-thanh.16960/" class="username">Tuấn Thành</a> replied <span class="DateTime" title="4/6/25 lúc 22:55">4/6/25</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:1770837985;}s:18:"forum_view_f111_16";a:2:{s:4:"html";s:0:"";s:4:"time";i:1770805710;}}
Run Time: 0.000427
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_2540b876fb3f7b2b08ec2, a:2:{s:23:"forum_view_lock_f111_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1770837985;}s:23:"forum_view_lock_f111_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1770805710;}}
Run Time: 0.000186
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_2540b876fb3f7b2b08ec2, a:2:{s:23:"forum_view_lock_f111_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1770837985;}s:23:"forum_view_lock_f111_16";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1770837985;}}
Run Time: 0.000176
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', 111, 17, 105, 104, 102, 103)) AND (thread.discussion_state IN ('visible'))) AND (thread.post_date > 1770405985)) AND (thread.schedule_thread_date = 0)
ORDER BY thread.view_count DESC
LIMIT 15Run Time: 0.001514
| 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 | | 11 | Using index condition; Using where; Using filesort |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.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 (13)
Run Time: 0.000214
| 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 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_forum_view_f111, a:2:{s:18:"forum_view_f111_17";a:2:{s:4:"html";s:3348:"<div class="avatarList">
<ul>
<li class="thread-2623 thread-node-40">
<a href="members/hungphong12.13616/" class="avatar Av13616s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_female_s.png" width="48" height="48" alt="hungphong12" /></a>
<a title="Liệu VSA có phải là phiên bản nâng cấp của phương pháp Wyckoff" class="Tooltip"
href="posts/29625/">
Liệu VSA có phải là phiên bản...
</a>
<div class="userTitle">
<a href="members/hungphong12.13616/" class="username">hungphong12</a> replied <span class="DateTime" title="9/1/26 lúc 19:24">9/1/26</span>
</div>
</li>
<li class="thread-5111 thread-node-10">
<a href="members/beginner2020.13055/" class="avatar Av13055s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_s.png" width="48" height="48" alt="beginner2020" /></a>
<a title="Phần mềm tradeguider phái wycoff chính thống nhất (vsa)" class="Tooltip"
href="posts/28965/">
Phần mềm tradeguider phái...
</a>
<div class="userTitle">
<a href="members/beginner2020.13055/" class="username">beginner2020</a> replied <span class="DateTime" title="31/10/25 lúc 16:51">31/10/25</span>
</div>
</li>
<li class="thread-3985 thread-node-105">
<a href="members/blackbearvn.32964/" class="avatar Av32964s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Blackbearvn" /></a>
<a title="Toàn bộ lý thuyết về Wyckoff - VSA - VPA được tổng hợp ở bộ tài liệu này." class="Tooltip"
href="posts/26915/">
Toàn bộ lý thuyết về...
</a>
<div class="userTitle">
<a href="members/blackbearvn.32964/" class="username">Blackbearvn</a> replied <span class="DateTime" title="24/8/25 lúc 09:27">24/8/25</span>
</div>
</li>
<li class="thread-15314 thread-node-105">
<a href="members/c-luan.26571/" class="avatar Av26571s" data-avatarhtml="true"><img src="data/avatars/s/26/26571.jpg?1715248266" width="48" height="48" alt="C.Luận" /></a>
<a title="Phương pháp Wyckoff là gì? Hướng dẫn giao dịch đơn giản và hiệu quả" class="Tooltip"
href="posts/26516/">
Phương pháp Wyckoff là gì?...
</a>
<div class="userTitle">
<a href="members/c-luan.26571/" class="username">C.Luận</a> replied <span class="DateTime" title="15/7/25 lúc 15:31">15/7/25</span>
</div>
</li>
<li class="thread-14748 thread-node-4">
<a href="members/tuan-thanh.16960/" class="avatar Av16960s" data-avatarhtml="true"><img src="data/avatars/s/16/16960.jpg?1759944288" width="48" height="48" alt="Tuấn Thành" /></a>
<a
href="posts/25729/">
Dữ liệu cổ phiếu 68
</a>
<div class="userTitle">
<a href="members/tuan-thanh.16960/" class="username">Tuấn Thành</a> replied <span class="DateTime" title="4/6/25 lúc 22:55">4/6/25</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:1770837985;}s:18:"forum_view_f111_16";a:2:{s:4:"html";s:1165:"<div class="avatarList">
<ul>
<li class="thread-19057 thread-node-13">
<a href="members/phongtranxuthanh.32428/" class="avatar Av32428s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="phongtranxuthanh" /></a>
<a title="Giao Dịch Như Một Chủ Sòng: Tại Sao Trader Lão Luyện Lại Chọn 'Thu Thuế' Ngược Lại Sàn?" class="Tooltip"
href="giao-dich-nhu-mot-chu-song-tai-sao-trader-lao-luyen-lai-chon-thu-thue-nguoc-lai-san.t19057.html">
Giao Dịch Như Một Chủ Sòng: Tại...
</a>
<div class="userTitle">
<a href="members/phongtranxuthanh.32428/" class="username">phongtranxuthanh</a> posted <abbr class="DateTime" data-time="1770826990" data-diff="10995" data-datestring="11/2/26" data-timestring="23:23">11/2/26 lúc 23:23</abbr>
</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:1770837985;}}
Run Time: 0.000394
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_2540b876fb3f7b2b08ec2, a:2:{s:23:"forum_view_lock_f111_17";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1770837985;}s:23:"forum_view_lock_f111_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1770837985;}}
Run Time: 0.000182
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000112
| 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 > 1770837085)
ORDER BY session_activity.view_date DESC
Run Time: 0.000742
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 109 | 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.000237
| 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.000415
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |