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.000835
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 33 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000401
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user_point.*
FROM xf_user_point AS user_point
WHERE 1=1
Run Time: 0.000720
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_point | ALL | | | | | 67 | |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000407
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 79 | 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.000362
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 79 | Using where |
SELECT thread.*
,
NULL AS thread_read_date,
node.node_id AS forum_id, node.title AS forum_title
FROM xf_thread AS thread
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
WHERE (1=1) AND (thread.node_id IN (35, 6, 8, 9, 10, 11, 12, 59, 70, 77, 79, 84, 85, 86, 87, 13, 14, 49, 15, 16, 62, 17, 18, 44, 50, 66, 81, 82, 5, 38, 52, 53, 64, 67, 39, 40, 43, 51, 80, 89, 41, 76, 19, 45, 46, 47, 54, 55, 58, 65, 88, 20, 21, 22, 60, 23, 71, 72, 73, 75, 24, 25, 63, 26, 27, 28, 37, 42, 48, 57, 61, 68, 69, 74, 78, 83, 56, 36)) AND (thread.post_date > 1710910164) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated'))
ORDER BY thread.view_count DESC
LIMIT 10
Run Time: 0.006626
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 | | 97 | Using index condition; Using where; Using filesort |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendan_sach.thread.node_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 85
Run Time: 0.000574
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 22
Run Time: 0.000351
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 45
Run Time: 0.001204
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 88
Run Time: 0.000414
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 40
Run Time: 0.000413
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d333ef4dc18b9b12dc81339af1b1372e, , 1713505764
Run Time: 0.000698
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, , , VietXfAdvStats_ControllerPublic_AdvStats, ThreadsHot, valid, , 1713502164,
Run Time: 0.000475
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'VietxfAdvStats_threads_hot', 'VietXfAdvStats_threads', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000661
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 4 | Using where |
SELECT adv.*
FROM xf_advertisement AS adv
WHERE (adv.active = 1) AND (adv.positive = 1)
Run Time: 0.000198
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | adv | ALL | | | | | 1 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('tailieu_advertisement_top')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000199
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT adv.*
FROM xf_advertisement AS adv
WHERE (adv.active = 1) AND (adv.positive = 3)
Run Time: 0.000193
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | adv | ALL | | | | | 1 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('tailieu_advertisement_bottom')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000156
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |