SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routesPublic', 'routeFiltersIn', 'routeFiltersOut', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000217
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.000058
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_addon | index | | PRIMARY | 77 | | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: brBriviumAddOns, a:0:{}
Run Time: 0.000126
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000094
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000053
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category_map | index | | PRIMARY | 8 | | 59 | 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_id = ?
Params: 8
Run Time: 0.000626
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 = 8) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))
Run Time: 0.000309
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; Using index |
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 = 8) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.view_count DESC
LIMIT 20
Run Time: 0.000707
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 index condition; Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.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 = 8) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.view_count DESC
Run Time: 0.000610
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 | 2 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.thread.user_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 (126, 125)
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.000394
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 2 | Using index condition; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.attachment.data_id | 1 | Using where |
SELECT
post.*
FROM xf_post AS post
WHERE post.post_id IN (126, 125)
Run Time: 0.000342
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
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: 8
Run Time: 0.000253
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 data_value
FROM xf_data_registry
WHERE data_key = ?
Params: PrefixesThreadsCount8
Run Time: 0.000209
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT prefix.*
FROM xf_thread_prefix AS prefix
WHERE (prefix.prefix_id IN(19))
ORDER BY prefix.materialized_order
Run Time: 0.000217
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | prefix | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 11c3e7bdf0a2e523e603f274ca3401b9, a:8:{s:12:"sessionStart";i:1711711635;s:2:"ip";i:752821348;s:9:"userAgent";s:9:"claudebot";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";b:0;s:13:"isDiscouraged";b:0;s:13:"mediaUnviewed";a:2:{s:8:"unviewed";a:0:{}s:14:"lastUpdateDate";i:1711711635;}}, 1711715235
Run Time: 0.000185
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, 752821348, 752821348, XenForo_ControllerPublic_Forum, Forum, valid, node_id=8, 1711711635,
Run Time: 0.000092
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_wrapper', 'wf_widget_threads', 'wf_widget_online_users', 'wf_widget_stats', 'tinhte_xentag_forum_view', 'BRQCT_forum_list_nodes', 'BRQCT_ad_sidebar_top', 'BRQCT_button_top_ctrl', 'thread_list_item', 'hex_forum_list_thumbnail_thumbnails', 'hex_thread_list_avatar_replace_thumbnails', 'hex_thread_list_thumbnail_thumbnails', 'hex_thread_list_avatar_last_post_avatar', 'forum_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', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.001072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 26 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRQCT_button_top_ctrl', 'pfl_prefixes_list')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000206
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_forum_view')
Run Time: 0.000200
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_forum_view_lock')
Run Time: 0.000138
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_forum_view_lock, a:1:{s:18:"forum_view_lock_94";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1711711635;}}
Run Time: 0.000783
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 ('64')) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC
LIMIT 15
Run Time: 0.000966
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 | 18 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.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.000349
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 109 | 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 (64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64)
Run Time: 0.000439
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 1 | Using where |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.node.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 (79357, 76835, 35205, 34941, 31094)
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.000613
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 | hjxjubkmhosting_tayninh24h.attachment.data_id | 1 | Using where |
SELECT
post.*
FROM xf_post AS post
WHERE post.post_id IN (79357, 76835, 35205, 34941, 31094)
Run Time: 0.000427
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: 64
Run Time: 0.000395
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 | |
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 (79357, 76835, 35205, 34941, 31094)
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.000119
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 | hjxjubkmhosting_tayninh24h.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_forum_view, a:1:{s:13:"forum_view_94";a:3:{s:4:"html";s:5682:"<div class="avatarList">
<ul>
<li class="thread-62717 thread-node-64">
<div class="listBlock posterAvatar">
<span class="thumbContainer">
<a href="threads/cty-tnhh-tan-hoa-tuyen-nam-ke-toan.62717/" data-thumbnailurl="styles/default/xenforo/avatars/avatar_l.png" class="thumb Thumbnail" style="width:92.666666666667px;"><span class="img" style="width:86.666666666667px; height:66.666666666667px;"><span style="width:86.666666666667px; height:66.666666666667px; overflow: hidden;"><img src="styles/default/xenforo/avatars/avatar_l.png" style="margin-left:0px; margin-top:-10px; width:86.666666666667px; height:86.666666666667px;" /></span></span></a>
</span>
</div>
<a
href="threads/cty-tnhh-tan-hoa-tuyen-nam-ke-toan.62717/">
CTY TNHH TÂN HÒA tuyển Nam kế toán
</a>
<div class="userTitle">
<a href="members/tay-ninh-24h.7792/" class="username">Tây Ninh 24h</a> posted <span class="DateTime" title="20/3/24 lúc 22:25">20/3/24</span>
</div>
</li>
<li class="thread-60273 thread-node-64">
<div class="listBlock posterAvatar">
<span class="thumbContainer">
<a href="threads/tuyen-ke-toan-lam-viec-tai-tay-ninh.60273/" data-thumbnailurl="data/attachments/3/3082-9d5be4b5061f660e28f1e229efa96f9c.jpg" class="thumb Thumbnail" style="width:92.666666666667px;"><span class="img" style="width:86.666666666667px; height:66.666666666667px;"><span style="width:86.666666666667px; height:66.666666666667px; overflow: hidden;"><img src="data/attachments/3/3082-9d5be4b5061f660e28f1e229efa96f9c.jpg" style="margin-left:-16px; margin-top:0px; width:118.66666666667px; height:66.666666666667px;" /></span></span></a>
</span>
</div>
<a
href="threads/tuyen-ke-toan-lam-viec-tai-tay-ninh.60273/">
TUYỂN KẾ TOÁN LÀM VIỆC TẠI TÂY NINH
</a>
<div class="userTitle">
<a href="members/luu-dinh-giap.2/" class="username">Lưu Đình Giáp</a> posted <span class="DateTime" title="2/2/23 lúc 08:24">2/2/23</span>
</div>
</li>
<li class="thread-23020 thread-node-64">
<div class="listBlock posterAvatar">
<span class="thumbContainer">
<a href="threads/ca-n-tuye-n-ky-thua-t-vien-camera-tay-ninh-24h.23020/" data-thumbnailurl="data/attachments/2/2813-643e98262418387452cd8e9fd5378dc4.jpg" class="thumb Thumbnail" style="width:92.666666666667px;"><span class="img" style="width:86.666666666667px; height:66.666666666667px;"><span style="width:86.666666666667px; height:66.666666666667px; overflow: hidden;"><img src="data/attachments/2/2813-643e98262418387452cd8e9fd5378dc4.jpg" style="margin-left:-0.66666666666667px; margin-top:0px; width:88px; height:66.666666666667px;" /></span></span></a>
</span>
</div>
<a title="Cần Tuyển Kỹ Thuật Viên Camera Tây Ninh 24h" class="Tooltip"
href="threads/ca-n-tuye-n-ky-thua-t-vien-camera-tay-ninh-24h.23020/">
Cần Tuyển Kỹ Thuật Viên Camera...
</a>
<div class="userTitle">
<a href="members/kieuoanh281.7/" class="username">kieuoanh281</a> posted <span class="DateTime" title="13/10/17 lúc 14:40">13/10/17</span>
</div>
</li>
<li class="thread-22838 thread-node-64">
<div class="listBlock posterAvatar">
<span class="thumbContainer">
<a href="threads/trung-tam-anh-ngu-ik-tay-ninh-tuye-n-du-ng.22838/" data-thumbnailurl="data/attachments/2/2807-7e1a2cdcb4d663d0506e16b6d2a73646.jpg" class="thumb Thumbnail" style="width:92.666666666667px;"><span class="img" style="width:86.666666666667px; height:66.666666666667px;"><span style="width:86.666666666667px; height:66.666666666667px; overflow: hidden;"><img src="data/attachments/2/2807-7e1a2cdcb4d663d0506e16b6d2a73646.jpg" style="margin-left:-6.6666666666667px; margin-top:0px; width:100px; height:66.666666666667px;" /></span></span></a>
</span>
</div>
<a title="TRUNG TÂM ANH NGỮ IK TÂY NINH TUYỂN DỤNG" class="Tooltip"
href="threads/trung-tam-anh-ngu-ik-tay-ninh-tuye-n-du-ng.22838/">
TRUNG TÂM ANH NGỮ IK TÂY NINH...
</a>
<div class="userTitle">
<a href="members/kieuoanh281.7/" class="username">kieuoanh281</a> posted <span class="DateTime" title="3/10/17 lúc 10:19">3/10/17</span>
</div>
</li>
<li class="thread-19812 thread-node-64">
<div class="listBlock posterAvatar">
<span class="thumbContainer">
<a href="threads/nha-hang-cherry-anh-dao-tuyen-dung-le-tan.19812/" data-thumbnailurl="http://i.imgur.com/RoExpk1.jpg" class="thumb Thumbnail" style="width:92.666666666667px;"><span class="img" style="width:86.666666666667px; height:66.666666666667px;"><span style="width:86.666666666667px; height:66.666666666667px; overflow: hidden;"><img src="http://i.imgur.com/RoExpk1.jpg" style="margin-left:0px; margin-top:0px; width:86.666666666667px; height:66.666666666667px;" /></span></span></a>
</span>
</div>
<a title="Nhà Hàng Cherry Anh Đào - Tuyển dụng Lễ Tân" class="Tooltip"
href="threads/nha-hang-cherry-anh-dao-tuyen-dung-le-tan.19812/">
Nhà Hàng Cherry Anh Đào - Tuyển...
</a>
<div class="userTitle">
<a href="members/luu-dinh-giap.2/" class="username">Lưu Đình Giáp</a> posted <span class="DateTime" title="21/5/17 lúc 22:15">21/5/17</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:1711711635;s:9:"extraData";a:1:{s:17:"requiredExternals";a:1:{s:3:"css";a:5:{i:0;s:26:"hex_thread_list_thumbnails";i:1;s:26:"hex_thread_list_thumbnails";i:2;s:26:"hex_thread_list_thumbnails";i:3;s:26:"hex_thread_list_thumbnails";i:4;s:26:"hex_thread_list_thumbnails";}}}}}
Run Time: 0.000585
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_forum_view_lock, a:1:{s:18:"forum_view_lock_94";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1711711635;}}
Run Time: 0.000248
SELECT session_activity.*
,
user.*,
user_profile.*,
user_option.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE (session_activity.view_date > 1711625235)
ORDER BY session_activity.view_date DESC
Run Time: 0.028950
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 5319 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.session_activity.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.user.user_id | 1 | Using where |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | hjxjubkmhosting_tayninh24h.user.user_id | 1 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000267
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 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.000088
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |