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')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | ALL | PRIMARY | 34 | Using where |
SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
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
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_point | ALL | 10610 |
SELECT * FROM xf_node ORDER BY lft ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | ALL | 372 | Using filesort |
SELECT content_id, cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = 'node'
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 780 | Using where |
SELECT thread.* , NULL AS thread_read_date, node.node_id AS forum_id, node.title AS forum_title, user.* FROM xf_thread AS thread INNER JOIN xf_node AS node ON (node.node_id = thread.node_id) INNER JOIN xf_forum AS forum ON (forum.node_id = thread.node_id) LEFT JOIN xf_user AS user ON (user.user_id = thread.user_id) WHERE (1=1) AND (thread.node_id IN (263, 12, 18, 296, 56, 293, 299, 300, 362, 129, 186, 187, 58, 244, 59, 277, 225, 235, 226, 227, 228, 229, 60, 371, 61, 62, 259, 260, 268, 285, 301, 326, 339, 358, 359, 360, 367, 181, 185, 202, 205, 203, 204, 81, 175, 208, 237, 85, 239, 165, 280, 352, 182, 199, 232, 236, 171, 247, 179, 272, 273, 274, 7, 76, 240, 156, 213, 214, 241, 215, 216, 261, 295, 332, 217, 218, 298, 318, 224, 253, 266, 288, 289, 297, 310, 311, 312, 328, 329, 333, 335, 340, 343, 344, 345, 347, 372, 373, 374, 375, 378, 379, 254, 255, 262, 43, 281, 282, 290, 291, 292, 294, 304, 315, 316, 334, 336, 337, 346, 350, 351, 353, 355, 376, 251, 80, 256, 287, 183, 234, 91, 201, 348, 188, 195, 377, 189, 190, 191, 192, 193, 194, 230, 231, 243, 46, 302, 57, 317, 220, 77, 51, 64, 207, 211, 212, 138, 160, 163, 309, 219, 169, 286, 222, 15, 206, 16, 331, 87, 132, 233, 133, 148, 149, 150, 151, 153, 197, 134, 283, 144, 145, 146, 147, 196, 209, 135, 284, 349, 152, 154, 155, 136, 303, 307, 314, 321, 322, 338, 341, 166, 170, 276, 305, 306, 313, 361, 363, 364, 365, 366, 172, 25, 63, 74, 75, 48, 19, 71, 125, 126, 267, 270, 242, 275, 20, 21, 55, 79, 23, 27, 96, 200, 28, 308, 140, 54, 49, 176, 178, 180, 210, 252, 89, 320, 249, 131, 162, 250, 168, 198, 245, 248, 22, 94, 167, 30, 29, 86, 159, 142, 161, 90, 17, 323, 324, 327, 127, 128, 130, 141, 157, 158, 26, 119, 137, 221, 38, 39, 279, 82, 111, 42, 44, 45, 238, 50, 139, 278, 53, 66, 67, 68, 69, 177, 5, 6, 24, 36, 47, 84, 97, 98, 65, 99, 100, 101, 102, 103, 104, 105, 106, 107, 109, 110, 112, 114, 31, 32, 33, 34, 41, 35, 1, 2, 258, 319, 174, 93, 3, 4, 10, 11, 37)) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated')) ORDER BY RAND() LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | forum | index | PRIMARY | PRIMARY | 4 | 362 | Using index; Using temporary; Using filesort | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.forum.node_id | 1 | |
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | dien7104_tailieu.forum.node_id | 32 | Using index condition; Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.thread.user_id | 1 |
SELECT cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ? AND content_id = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 (?, ?, ?)
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)
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('page_nav', 'VietxfAdvStats_threads_random', 'VietXfAdvStats_threads', 'PAGE_CONTAINER') AND style_id = ? AND language_id = ?
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)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | adv | ALL | 5 | Using where |
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('tailieu_advertisement_top') AND style_id = ? AND language_id = ?
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)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | adv | ALL | 5 | Using where |
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('tailieu_advertisement_bottom') AND style_id = ? AND language_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 |