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.000377
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 62 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000093
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 3846
Run Time: 0.000626
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date
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: 54
Run Time: 0.000237
| 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 | |
| SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id)
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 20)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 3846
Run Time: 0.002715
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | webtn.post.user_id | 1 | |
| SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | webtn.post.user_id | 1 | |
| SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | webtn.post.user_id | 1 | |
| SIMPLE | session_activity | ref | PRIMARY | PRIMARY | 4 | webtn.post.user_id | 11 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 3846
Run Time: 0.000164
SELECT *
FROM xf_brivium_metadata
WHERE content_type = ? AND content_id = ?
Params: thread, 3846
Run Time: 0.004724
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_brivium_metadata | ALL | | | | | 7657 | Using where |
SELECT *
FROM xf_brivium_extra_thread_item
WHERE thread_id = ? AND user_id = ?
Params: 3846, 0
Run Time: 0.041626
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_brivium_extra_thread_item | ALL | | | | | 7592 | Using where |
SELECT thread.*
FROM xf_thread AS thread
WHERE ((thread.node_id = 54) AND (thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible') AND (thread.post_date < 1532267312)) AND (thread.thread_id <> 3846)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000601
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 3827 | Using where |
SELECT thread.*
FROM xf_thread AS thread
WHERE ((thread.node_id = 54) AND (thread.discussion_type <> 'redirect') AND (thread.discussion_state = 'visible') AND (thread.post_date > 1532267312)) AND (thread.thread_id <> 3846)
ORDER BY thread.post_date ASC
LIMIT 5
Run Time: 0.008618
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 3759 | Using where |
UPDATE `xf_brivium_extra_thread_item` SET `date_update` = ?, `extra_cache` = ? WHERE (thread_id = 3846 AND user_id = 0)
Params: 1610906886, a:3:{s:12:"olderThreads";a:5:{i:3845;a:21:{s:9:"thread_id";i:3845;s:7:"node_id";i:54;s:5:"title";s:49:"Rurouni Kenshin - Lãng khách Kenshin (Chap 252)";s:11:"reply_count";i:0;s:10:"view_count";i:390;s:7:"user_id";i:1;s:8:"username";s:3:"Fox";s:9:"post_date";i:1532267284;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3859;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1532267284;s:12:"last_post_id";i:3859;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:3:"Fox";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;}i:3844;a:21:{s:9:"thread_id";i:3844;s:7:"node_id";i:54;s:5:"title";s:49:"Rurouni Kenshin - Lãng khách Kenshin (Chap 251)";s:11:"reply_count";i:0;s:10:"view_count";i:413;s:7:"user_id";i:1;s:8:"username";s:3:"Fox";s:9:"post_date";i:1532267262;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3858;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1532267262;s:12:"last_post_id";i:3858;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:3:"Fox";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;}i:3843;a:21:{s:9:"thread_id";i:3843;s:7:"node_id";i:54;s:5:"title";s:49:"Rurouni Kenshin - Lãng khách Kenshin (Chap 250)";s:11:"reply_count";i:0;s:10:"view_count";i:346;s:7:"user_id";i:1;s:8:"username";s:3:"Fox";s:9:"post_date";i:1532267243;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3857;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1532267243;s:12:"last_post_id";i:3857;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:3:"Fox";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;}i:3842;a:21:{s:9:"thread_id";i:3842;s:7:"node_id";i:54;s:5:"title";s:49:"Rurouni Kenshin - Lãng khách Kenshin (Chap 249)";s:11:"reply_count";i:0;s:10:"view_count";i:368;s:7:"user_id";i:1;s:8:"username";s:3:"Fox";s:9:"post_date";i:1532267210;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3856;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1532267210;s:12:"last_post_id";i:3856;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:3:"Fox";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;}i:3841;a:21:{s:9:"thread_id";i:3841;s:7:"node_id";i:54;s:5:"title";s:49:"Rurouni Kenshin - Lãng khách Kenshin (Chap 248)";s:11:"reply_count";i:0;s:10:"view_count";i:377;s:7:"user_id";i:1;s:8:"username";s:3:"Fox";s:9:"post_date";i:1532267059;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3855;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1532267059;s:12:"last_post_id";i:3855;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:3:"Fox";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;}}s:12:"newerThreads";a:2:{i:3847;a:21:{s:9:"thread_id";i:3847;s:7:"node_id";i:54;s:5:"title";s:49:"Rurouni Kenshin - Lãng khách Kenshin (Chap 254)";s:11:"reply_count";i:0;s:10:"view_count";i:372;s:7:"user_id";i:1;s:8:"username";s:3:"Fox";s:9:"post_date";i:1532267329;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3861;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1532267329;s:12:"last_post_id";i:3861;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:3:"Fox";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;}i:3848;a:21:{s:9:"thread_id";i:3848;s:7:"node_id";i:54;s:5:"title";s:59:"Rurouni Kenshin - Lãng khách Kenshin (Chap 255 - The End)";s:11:"reply_count";i:0;s:10:"view_count";i:489;s:7:"user_id";i:1;s:8:"username";s:3:"Fox";s:9:"post_date";i:1532267354;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3862;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1532267354;s:12:"last_post_id";i:3862;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:3:"Fox";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:13:"titleCensored";b:1;}}s:13:"latestThreads";a:0:{}}
Run Time: 0.060460
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: b1eea6def15b7339f64e91baffe64471, , 1610910486
Run Time: 0.000168
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_Thread, Index, valid, thread_id=3846, 1610906886,
Run Time: 0.000295
select value, hits
from dark_azucloud_terms_pages pages
left join dark_azucloud_terms terms on pages.term_id = terms.id
where route = ? and terms.block = 0 and terms.value is not null and last_clicked > ?
order by hits desc, last_clicked desc
limit ?
Params: threads/rurouni-kenshin-lang-khach-kenshin-chap-253.3846/, 1608314886, 10
Run Time: 0.000509
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | pages | ref | term_id_route,route,route_hits_last_clicked | route_hits_last_clicked | 452 | const | 1 | Using where |
| SIMPLE | terms | eq_ref | PRIMARY,value,block | PRIMARY | 4 | webtn.pages.term_id | 1 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'BRME_page_container_head', 'BRETI_message_below', 'wf_widget_wrapper', 'wf_widget_share_page', 'thread_view', 'EWRporta_Navtabs', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?Params: 1, 1
Run Time: 0.000390
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 16 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('home')Params: 1
Run Time: 0.000063
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('dark_azucloud')
AND style_id = ?
AND language_id = ?Params: 1, 1
Run Time: 0.000100
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |