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.000721
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.000202
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.000467
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.000322
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.000346
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 > 1710964419) 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.006138
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.000735
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.000517
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.000429
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.000407
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.000268
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: b2e79287b05a20efa523adfdb3a8f6b5, , 1713560019
Run Time: 0.000336
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, , 1713556419,
Run Time: 0.000158
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.000688
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.000190
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.000134
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.000191
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.000130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |