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.000385
| 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.000144
| 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.000097
| 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.000141
| 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.000409
| 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.005192
| 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 | 137 | 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 60Run Time: 0.001864
| 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 | 137 | 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: e182a74622ed7d77995b7eceb88c2a12, , 1763211313
Run Time: 0.000134
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=4, 1763207713,
Run Time: 0.000098
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.001185
| 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 > 1763206813)
ORDER BY session_activity.view_date DESC
Run Time: 0.000613
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 30 | 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.001087
| 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.000345
| 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:1763207713;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1763205247;}}
Run Time: 0.000292
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000321
| 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.000178
| 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.010558
| 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 | | 16 | 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, 10, 80, 87, 80, 40, 80, 80, 80, 80, 78, 80, 80)
Run Time: 0.000296
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 5 | 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:3303:"<div class="avatarList">
<ul>
<li class="thread-12770 thread-node-80">
<a href="members/taubien2000.18826/" class="avatar Av18826s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_s.png" width="48" height="48" alt="taubien2000" /></a>
<a
href="posts/29039/">
Chuyển code từ Pine sang Amibroker
</a>
<div class="userTitle">
<a href="members/taubien2000.18826/" class="username">taubien2000</a> replied <span class="DateTime" title="7/11/25 lúc 08:54">7/11/25</span>
</div>
</li>
<li class="thread-7317 thread-node-80">
<a href="members/phuongpro98.33022/" class="avatar Av33022s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="PHƯƠNGPRO98" /></a>
<a title="Chia sẻ code amibroker báo điểm mua và bán" class="Tooltip"
href="posts/28972/">
Chia sẻ code amibroker báo điểm...
</a>
<div class="userTitle">
<a href="members/phuongpro98.33022/" class="username">PHƯƠNGPRO98</a> replied <span class="DateTime" title="3/11/25 lúc 08:17">3/11/25</span>
</div>
</li>
<li class="thread-15747 thread-node-80">
<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="Help - Cần lấy dữ liệu Crypto cho amibroker" class="Tooltip"
href="posts/28971/">
Help - Cần lấy dữ liệu Crypto...
</a>
<div class="userTitle">
<a href="members/hungphong12.13616/" class="username">hungphong12</a> replied <span class="DateTime" title="2/11/25 lúc 16:28">2/11/25</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-11718 thread-node-80">
<a href="members/vantienart.19354/" class="avatar Av19354s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="vantienart" /></a>
<a title="Bác nào có thể cho e xin code lọc như này được ko ạ hihi!!" class="Tooltip"
href="posts/28955/">
Bác nào có thể cho e xin code...
</a>
<div class="userTitle">
<a href="members/vantienart.19354/" class="username">vantienart</a> replied <span class="DateTime" title="31/10/25 lúc 13:50">31/10/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:1763207713;}s:17:"forum_view_f87_16";a:2:{s:4:"html";s:1079:"<div class="avatarList">
<ul>
<li class="thread-18067 thread-node-13">
<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 title="VN-Index thủng 1.600, danh mục bay 40%: Thoát chạy hay chuẩn bị săn đáy?" class="Tooltip"
href="vn-index-thung-1-600-danh-muc-bay-40-thoat-chay-hay-chuan-bi-san-day.t18067.html">
VN-Index thủng 1.600, danh mục...
</a>
<div class="userTitle">
<a href="members/tuan-thanh.16960/" class="username">Tuấn Thành</a> posted <abbr class="DateTime" data-time="1762787947" data-diff="417300" data-datestring="10/11/25" data-timestring="22:19">10/11/25 lúc 22:19</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:1763205247;}}
Run Time: 0.000311
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:1763207713;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1763205247;}}
Run Time: 0.000182
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:1763207713;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1763207713;}}
Run Time: 0.000191
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 > 1762775713)) AND (thread.schedule_thread_date = 0)
ORDER BY thread.view_count DESC
LIMIT 15Run Time: 0.000845
| 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 | | 16 | 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.000212
| 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_f87, a:2:{s:17:"forum_view_f87_17";a:2:{s:4:"html";s:3303:"<div class="avatarList">
<ul>
<li class="thread-12770 thread-node-80">
<a href="members/taubien2000.18826/" class="avatar Av18826s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_s.png" width="48" height="48" alt="taubien2000" /></a>
<a
href="posts/29039/">
Chuyển code từ Pine sang Amibroker
</a>
<div class="userTitle">
<a href="members/taubien2000.18826/" class="username">taubien2000</a> replied <span class="DateTime" title="7/11/25 lúc 08:54">7/11/25</span>
</div>
</li>
<li class="thread-7317 thread-node-80">
<a href="members/phuongpro98.33022/" class="avatar Av33022s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="PHƯƠNGPRO98" /></a>
<a title="Chia sẻ code amibroker báo điểm mua và bán" class="Tooltip"
href="posts/28972/">
Chia sẻ code amibroker báo điểm...
</a>
<div class="userTitle">
<a href="members/phuongpro98.33022/" class="username">PHƯƠNGPRO98</a> replied <span class="DateTime" title="3/11/25 lúc 08:17">3/11/25</span>
</div>
</li>
<li class="thread-15747 thread-node-80">
<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="Help - Cần lấy dữ liệu Crypto cho amibroker" class="Tooltip"
href="posts/28971/">
Help - Cần lấy dữ liệu Crypto...
</a>
<div class="userTitle">
<a href="members/hungphong12.13616/" class="username">hungphong12</a> replied <span class="DateTime" title="2/11/25 lúc 16:28">2/11/25</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-11718 thread-node-80">
<a href="members/vantienart.19354/" class="avatar Av19354s" data-avatarhtml="true"><img src="styles/otovungtau/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="vantienart" /></a>
<a title="Bác nào có thể cho e xin code lọc như này được ko ạ hihi!!" class="Tooltip"
href="posts/28955/">
Bác nào có thể cho e xin code...
</a>
<div class="userTitle">
<a href="members/vantienart.19354/" class="username">vantienart</a> replied <span class="DateTime" title="31/10/25 lúc 13:50">31/10/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:1763207713;}s:17:"forum_view_f87_16";a:2:{s:4:"html";s:1079:"<div class="avatarList">
<ul>
<li class="thread-18067 thread-node-13">
<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 title="VN-Index thủng 1.600, danh mục bay 40%: Thoát chạy hay chuẩn bị săn đáy?" class="Tooltip"
href="vn-index-thung-1-600-danh-muc-bay-40-thoat-chay-hay-chuan-bi-san-day.t18067.html">
VN-Index thủng 1.600, danh mục...
</a>
<div class="userTitle">
<a href="members/tuan-thanh.16960/" class="username">Tuấn Thành</a> posted <abbr class="DateTime" data-time="1762787947" data-diff="419766" data-datestring="10/11/25" data-timestring="22:19">10/11/25 lúc 22:19</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:1763207713;}}
Run Time: 0.000257
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:1763207713;}s:22:"forum_view_lock_f87_16";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1763207713;}}
Run Time: 0.000178
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000093
| 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 > 1763206813)
ORDER BY session_activity.view_date DESC
Run Time: 0.000580
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 30 | 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.000181
| 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.000177
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |