SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | ALL | PRIMARY | 44 | 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 `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.* FROM `xf_thread` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` = '27') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_session_activity_Activity_5`.* FROM `xf_post` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, '')) WHERE (`xf_post`.`thread_id` = 27) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 380) AND (`xf_post`.`position` < 400) ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | 20 | Using index condition; Using where; Using filesort | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | iptvforu_forumtr112.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | iptvforu_forumtr112.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | iptvforu_forumtr112.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | iptvforu_forumtr112.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | iptvforu_forumtr112.xf_user_User_1.user_id,func | 1 | Using where |
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.* FROM `xf_attachment` LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`) WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (7182)) ORDER BY `xf_attachment`.`attach_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | iptvforu_forumtr112.xf_attachment.data_id | 1 |
SELECT `xf_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`result_id` IN (10934, 10935, 10936, 10937, 10938, 10939, 10940, 10941, 10942, 10943, 10944, 10945, 7345, 10947, 10948, 10949, 10683, 10951, 10952, 10953, 10954, 10955, 10956, 10957, 10958, 10959, 10960, 10961, 10962, 10963, 10964, 10965, 10966, 10967, 8644, 10969, 7255, 8641, 10904, 10974, 10975, 10901, 7274, 7306, 7309, 7317, 7310, 7340, 9046, 10986, 10987, 10988, 10989, 10990, 10991, 10992, 10993, 10994, 10995, 10996, 10997, 10998, 10999, 11000, 11001, 11002, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011, 11012, 11013, 11014, 11015, 11016, 11017, 11018, 11019, 10763, 10664, 10665, 10666, 10667, 10668, 10671, 7349, 8646, 7620, 7341, 11032, 10677, 10678, 10679, 10680, 10682, 7355, 10686, 10688, 10689, 10690, 10691, 10692, 10693, 10694, 10695, 10696, 10697, 10698, 10699, 10700, 10701, 10702, 10703, 10704, 10705, 10708, 10709, 10710, 10711, 10712, 10714, 10715, 10716, 10823, 10825, 7233, 8826, 7242, 7243, 7232, 7245, 7246, 7247, 7249, 7250, 7251, 7252, 7253, 7254, 7256, 7220, 7258, 7259, 7260, 7261, 7262, 7263, 7264, 7265, 7266, 7267, 7268, 7270, 7271, 7272, 7214, 7215, 7276, 7277, 7278, 7279, 7281, 7282, 7283, 7284, 7285, 7286, 7287, 7288, 7289, 7290, 7291, 7292, 7293, 7294, 7295, 7225, 7297, 7298, 7227, 7300, 7302, 7304, 7307, 7308, 7311, 7312, 7313, 7314, 7315, 7316, 7319, 7320, 7321, 7322, 7323, 7325, 7326, 7327, 7328, 7329, 7331, 7332, 7333, 7334, 7339, 7342, 7343, 7344, 7346, 11269, 11270, 11271, 11272, 11273, 11274, 11275, 11276, 11277, 11278, 11279, 11280, 11281, 11282, 11283, 11284, 11285, 11286, 11287, 11288, 11349, 11351, 11295, 11358, 11296, 11364, 11308, 11432, 11433, 11434, 11435, 11437, 11454, 10522, 11486, 11491, 11492, 10933, 10905, 9664, 9669, 8639, 9399, 7586, 11521, 8577, 11526, 11527))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | range | PRIMARY | PRIMARY | 4 | 263 | Using where |
INSERT INTO xf_thread_view (thread_id, total) VALUES (? , 1) ON DUPLICATE KEY UPDATE total = total + 1
-- XFDB=noForceAllWrite 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 `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`user_id` = 1) AND (`xf_session_activity`.`unique_key` = '1') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`url_hash` = '83db6f928383458e6d023a9469c26bba') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | const | url_hash | url_hash | 34 | const | 1 |
SELECT `xf_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`url_hash` = 'a31d4332c246370f02bb4690b241c3a5') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | const | url_hash | url_hash | 34 | const | 1 |