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` >= 340) AND (`xf_post`.`position` < 360) 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_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`result_id` IN (7350, 7352, 7622, 7623, 7355, 7625, 7349, 7351, 7356, 7357, 7631, 7358, 7359, 7274, 7321, 7365, 7255, 7641, 7226, 7278, 7370, 7371, 7372, 7373, 7374, 7376, 7377, 7346, 7379, 7341, 7381, 7382, 7385, 7333, 7388, 7389, 7390, 7391, 7392, 7393, 7300, 7395, 7289, 7256, 7398, 7399, 7401, 7402, 7403, 7404, 7405, 7406, 7407, 7408, 7409, 7410, 7411, 7339, 7413, 7340, 7415, 7416, 7417, 7342, 7420, 7343, 7422, 7423, 7344, 7425, 7345, 7427, 7428, 8547, 8548, 8549, 8550, 8551, 8552, 8553, 8554, 8555, 8556, 8557, 8558, 8559, 8560, 8562, 7573, 8565, 8566, 8567, 8568, 8569, 8570, 8571, 8572, 8573, 7331, 8575, 8576, 8577, 8578, 8579, 8104, 8103, 7891, 7892, 7708, 7959, 7960, 7961, 7962, 7574, 7577, 7233, 7239, 7583, 7584, 7585, 7586, 7587, 7246, 7247, 7252, 7253, 7254, 7220, 7258, 7266, 7276, 7279, 7294, 7302, 7306, 7308, 7309, 7310, 7311, 7317, 7319, 7320, 7322, 7332, 8637, 8638, 8639, 8641, 8642, 8643, 8644, 8645, 8646, 8647, 8649, 8733, 8734, 8735, 8736, 8737, 8738, 8826, 7242, 7243, 7232, 7245, 7249, 7250, 7251, 7259, 7260, 7261, 7262, 7263, 7264, 7265, 7267, 7268, 7270, 7271, 7272, 7214, 7215, 7277, 7281, 7282, 7283, 7284, 7285, 7286, 7287, 7288, 7290, 7291, 7292, 7293, 7295, 7225, 7297, 7298, 7227, 7304, 7307, 7312, 7313, 7314, 7315, 7316, 7323, 7325, 7326, 7327, 7328, 7329, 7334, 8932, 8933, 8934, 8935, 8936, 8937, 8938, 8939, 8940, 8941, 8942, 8943, 8944, 8946, 9034, 9035, 9038, 9039, 9040, 9041, 9042, 9043, 9044, 9045, 9046, 9047, 9048, 9049, 9156, 9157, 9273, 9274, 9275, 9276, 9277, 9278, 9279, 9280, 9281, 9282, 9283, 9393, 9394, 9395, 9397, 9399, 9400, 9401, 9402, 9403, 9404, 9405, 9528, 9529, 9530))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | range | PRIMARY | PRIMARY | 4 | 270 | 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` = 'aa915cc66d4b3a6cdb05c474545b7f52') 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` = 'aa915cc66d4b3a6cdb05c474545b7f52') 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 |