SELECT parent_id, content_type, COUNT(*) AS total FROM `xf_xc_ua_node_session_activity` WHERE `view_date` >= 1711660782 AND `content_type` in ('node', 'thread') GROUP BY parent_id
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xc_ua_node_session_activity | range | view_date | view_date | 4 | 2 | Using where; Using temporary; Using filesort |
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_forum`.*, `xf_node_Node_1`.*, `xf_thread_LastThreadPrivate_2`.*, `xf_snog_private_thread_PrivateThread_3`.*, `xf_snog_private_thread_HasPrivate_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_forum` INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThreadPrivate_2` ON (`xf_thread_LastThreadPrivate_2`.`node_id` = `xf_forum`.`node_id` AND `xf_thread_LastThreadPrivate_2`.`thread_id` = `xf_forum`.`last_thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_3` ON (`xf_snog_private_thread_PrivateThread_3`.`thread_id` = `xf_thread_LastThreadPrivate_2`.`thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_HasPrivate_4` ON (`xf_snog_private_thread_HasPrivate_4`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_forum`.`node_id` = '27') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThreadPrivate_2 | const | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_private_thread_PrivateThread_3 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_snog_private_thread_HasPrivate_4 | ref | node_id | node_id | 4 | const | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,const | 1 | Using where |
SELECT `xf_siropu_easy_user_ban_forum`.*, `xf_forum_Forum_1`.*, `xf_user_User_2`.*, `xf_user_BanUser_3`.* FROM `xf_siropu_easy_user_ban_forum` LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_siropu_easy_user_ban_forum`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_siropu_easy_user_ban_forum`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_BanUser_3` ON (`xf_user_BanUser_3`.`user_id` = `xf_siropu_easy_user_ban_forum`.`ban_user_id`) WHERE (`xf_siropu_easy_user_ban_forum`.`user_id` = 0) AND (`xf_siropu_easy_user_ban_forum`.`node_id` = 27) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_fc_user_devices`.* FROM `xf_fc_user_devices` WHERE (`xf_fc_user_devices`.`user_id` = 0) AND (`xf_fc_user_devices`.`status` != '1') AND (`xf_fc_user_devices`.`browser_token` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fc_user_devices | ref | user_id | user_id | 4 | const | 1 | Using where |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_thread_LastThreadPrivate_2`.*, `xf_snog_private_thread_PrivateThread_3`.*, `xf_snog_private_thread_HasPrivate_4`.*, `xf_forum_ChaptersForum_5`.*, `xf_forum_ParentChaptersForum_6`.*, `xf_permission_cache_content_Permissions_7`.* FROM `xf_forum` INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThreadPrivate_2` ON (`xf_thread_LastThreadPrivate_2`.`node_id` = `xf_forum`.`node_id` AND `xf_thread_LastThreadPrivate_2`.`thread_id` = `xf_forum`.`last_thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_3` ON (`xf_snog_private_thread_PrivateThread_3`.`thread_id` = `xf_thread_LastThreadPrivate_2`.`thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_HasPrivate_4` ON (`xf_snog_private_thread_HasPrivate_4`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_5` ON (`xf_forum_ChaptersForum_5`.`node_id` = `xf_forum`.`ozzmodz_tct_node_id`) LEFT JOIN `xf_forum` AS `xf_forum_ParentChaptersForum_6` ON (`xf_forum_ParentChaptersForum_6`.`ozzmodz_tct_node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_7` ON (`xf_permission_cache_content_Permissions_7`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_7`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_7`.`permission_combination_id` = '1') WHERE (`xf_forum`.`node_id` = '27') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThreadPrivate_2 | const | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_private_thread_PrivateThread_3 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_snog_private_thread_HasPrivate_4 | ref | node_id | node_id | 4 | const | 1 | Using where |
SIMPLE | xf_forum_ChaptersForum_5 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_ParentChaptersForum_6 | ALL | 67 | Using where; Using join buffer (flat, BNL join) | ||||
SIMPLE | xf_permission_cache_content_Permissions_7 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,const | 1 | Using where |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_thread_LastThreadPrivate_2`.*, `xf_snog_private_thread_PrivateThread_3`.*, `xf_snog_private_thread_HasPrivate_4`.*, `xf_forum_ChaptersForum_5`.*, `xf_forum_ParentChaptersForum_6`.*, `xf_permission_cache_content_Permissions_7`.* FROM `xf_forum` INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThreadPrivate_2` ON (`xf_thread_LastThreadPrivate_2`.`node_id` = `xf_forum`.`node_id` AND `xf_thread_LastThreadPrivate_2`.`thread_id` = `xf_forum`.`last_thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_3` ON (`xf_snog_private_thread_PrivateThread_3`.`thread_id` = `xf_thread_LastThreadPrivate_2`.`thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_HasPrivate_4` ON (`xf_snog_private_thread_HasPrivate_4`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_5` ON (`xf_forum_ChaptersForum_5`.`node_id` = `xf_forum`.`ozzmodz_tct_node_id`) LEFT JOIN `xf_forum` AS `xf_forum_ParentChaptersForum_6` ON (`xf_forum_ParentChaptersForum_6`.`ozzmodz_tct_node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_7` ON (`xf_permission_cache_content_Permissions_7`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_7`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_7`.`permission_combination_id` = '1') WHERE (`xf_forum`.`node_id` = '27') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThreadPrivate_2 | const | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_private_thread_PrivateThread_3 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_snog_private_thread_HasPrivate_4 | ref | node_id | node_id | 4 | const | 1 | Using where |
SIMPLE | xf_forum_ChaptersForum_5 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_ParentChaptersForum_6 | ALL | 67 | Using where; Using join buffer (flat, BNL join) | ||||
SIMPLE | xf_permission_cache_content_Permissions_7 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,const | 1 | Using where |
SELECT `xf_thread`.*, `xf_snog_private_thread_PrivateThread_1`.*, `xf_seo_thread_meta_Meta_2`.*, `xf_user_User_3`.*, `xf_user_LastPoster_4`.*, `xf_tl_schedule_content_TSC_Schedule_5`.*, `xf_altt_thread_thumbnail_ThreadThumbnail_6`.*, `xf_attachment_Attachment_7`.*, `xf_attachment_data_Data_8`.*, `xf_post_FirstPost_9`.*, `xf_user_User_10`.*, `xf_user_option_Option_11`.*, `xf_user_profile_Profile_12`.*, `xf_user_privacy_Privacy_13`.*, `xf_permission_combination_PermissionCombination_14`.*, `xf_session_activity_Activity_15`.*, `xf_tl_schedule_content_TSC_Schedule_16`.* FROM `xf_thread` LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_1` ON (`xf_snog_private_thread_PrivateThread_1`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_2` ON (`xf_seo_thread_meta_Meta_2`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_thread`.`last_post_user_id`) LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_5` ON (`xf_tl_schedule_content_TSC_Schedule_5`.`content_id` = `xf_thread`.`thread_id` AND `xf_tl_schedule_content_TSC_Schedule_5`.`content_type` = 'thread') LEFT JOIN `xf_altt_thread_thumbnail` AS `xf_altt_thread_thumbnail_ThreadThumbnail_6` ON (`xf_altt_thread_thumbnail_ThreadThumbnail_6`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_7` ON (`xf_attachment_Attachment_7`.`attachment_id` = `xf_altt_thread_thumbnail_ThreadThumbnail_6`.`attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_8` ON (`xf_attachment_data_Data_8`.`data_id` = `xf_attachment_Attachment_7`.`data_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_9` ON (`xf_post_FirstPost_9`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_user` AS `xf_user_User_10` ON (`xf_user_User_10`.`user_id` = `xf_post_FirstPost_9`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_11` ON (`xf_user_option_Option_11`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_12` ON (`xf_user_profile_Profile_12`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_13` ON (`xf_user_privacy_Privacy_13`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_14` ON (`xf_permission_combination_PermissionCombination_14`.`permission_combination_id` = `xf_user_User_10`.`permission_combination_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_15` ON (`xf_session_activity_Activity_15`.`user_id` = `xf_user_User_10`.`user_id` AND `xf_session_activity_Activity_15`.`unique_key` = CONCAT(`xf_user_User_10`.`user_id`, '')) LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_16` ON (`xf_tl_schedule_content_TSC_Schedule_16`.`content_id` = `xf_post_FirstPost_9`.`post_id` AND `xf_tl_schedule_content_TSC_Schedule_16`.`content_type` = 'post') WHERE (`xf_thread`.`node_id` = 27) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`ozzmodz_sc_is_scheduled` = 0) AND ((`xf_snog_private_thread_PrivateThread_1`.`snog_canview` IS NULL) OR (`xf_snog_private_thread_PrivateThread_1`.`snog_canview` LIKE '%\"0\"%')) AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`sticky` = 1) ORDER BY `xf_thread`.`post_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_sticky_state_last_post | 6 | const,const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_snog_private_thread_PrivateThread_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_seo_thread_meta_Meta_2 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.last_post_user_id | 1 | |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_5 | ALL | content_id_content_type | 1 | Using where; Using join buffer (flat, BNL join) | |||
SIMPLE | xf_altt_thread_thumbnail_ThreadThumbnail_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | |
SIMPLE | xf_attachment_Attachment_7 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_altt_thread_thumbnail_ThreadThumbnail_6.attachment_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_8 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_Attachment_7.data_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_9 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_10 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_post_FirstPost_9.user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_11 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_12 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_13 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_14 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_15 | eq_ref | PRIMARY | PRIMARY | 22 | edewan_db.xf_user_User_10.user_id,func | 1 | Using where |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_16 | ALL | content_id_content_type | 1 | Using where; Using join buffer (flat, BNL join) |
SELECT `xf_thread`.`thread_id` FROM `xf_thread` LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_1` ON (`xf_snog_private_thread_PrivateThread_1`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_2` ON (`xf_seo_thread_meta_Meta_2`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_thread`.`last_post_user_id`) LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_5` ON (`xf_tl_schedule_content_TSC_Schedule_5`.`content_id` = `xf_thread`.`thread_id` AND `xf_tl_schedule_content_TSC_Schedule_5`.`content_type` = 'thread') LEFT JOIN `xf_altt_thread_thumbnail` AS `xf_altt_thread_thumbnail_ThreadThumbnail_6` ON (`xf_altt_thread_thumbnail_ThreadThumbnail_6`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_7` ON (`xf_attachment_Attachment_7`.`attachment_id` = `xf_altt_thread_thumbnail_ThreadThumbnail_6`.`attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_8` ON (`xf_attachment_data_Data_8`.`data_id` = `xf_attachment_Attachment_7`.`data_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_9` ON (`xf_post_FirstPost_9`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_user` AS `xf_user_User_10` ON (`xf_user_User_10`.`user_id` = `xf_post_FirstPost_9`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_11` ON (`xf_user_option_Option_11`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_12` ON (`xf_user_profile_Profile_12`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_13` ON (`xf_user_privacy_Privacy_13`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_14` ON (`xf_permission_combination_PermissionCombination_14`.`permission_combination_id` = `xf_user_User_10`.`permission_combination_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_15` ON (`xf_session_activity_Activity_15`.`user_id` = `xf_user_User_10`.`user_id` AND `xf_session_activity_Activity_15`.`unique_key` = CONCAT(`xf_user_User_10`.`user_id`, '')) LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_16` ON (`xf_tl_schedule_content_TSC_Schedule_16`.`content_id` = `xf_post_FirstPost_9`.`post_id` AND `xf_tl_schedule_content_TSC_Schedule_16`.`content_type` = 'post') WHERE (`xf_thread`.`node_id` = 27) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`ozzmodz_sc_is_scheduled` = 0) AND ((`xf_snog_private_thread_PrivateThread_1`.`snog_canview` IS NULL) OR (`xf_snog_private_thread_PrivateThread_1`.`snog_canview` LIKE '%\"0\"%')) AND (`xf_thread`.`discussion_type` <> 'redirect') ORDER BY `xf_thread`.`post_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_last_post_date | 4 | const | 1993 | Using where; Using filesort |
SIMPLE | xf_snog_private_thread_PrivateThread_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_5 | ref | content_id_content_type | content_id_content_type | 31 | edewan_db.xf_thread.thread_id,const | 1 | Using where; Using index |
SIMPLE | xf_altt_thread_thumbnail_ThreadThumbnail_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | |
SIMPLE | xf_attachment_Attachment_7 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_altt_thread_thumbnail_ThreadThumbnail_6.attachment_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_9 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_10 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_post_FirstPost_9.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_15 | eq_ref | PRIMARY | PRIMARY | 22 | edewan_db.xf_user_User_10.user_id,func | 1 | Using where |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_16 | ref | content_id_content_type | content_id_content_type | 31 | edewan_db.xf_post_FirstPost_9.post_id,const | 1 | Using where; Using index |
SELECT content_id, field_id, field_value, field_location_country_code, field_location_state_id, field_location_city_id FROM xf_alff_field_index WHERE content_type=? AND content_id IN(17161, 17160, 17159, 17158, 17157, 17156, 17155, 17154, 17152, 17151, 17149, 17148, 17147, 17146, 17144, 17143, 17142, 17141, 17140, 17139, 17138, 17136, 17134, 17133, 17132, 17131, 17130, 17129, 17128, 17127, 17126, 17125, 17124, 17123, 17122, 17121, 17120, 17119, 17118, 17117, 17116, 17115, 17112, 17111, 17110, 17109, 17108, 17107, 17106, 17105, 17104, 17103, 17102, 17100, 17099, 17098, 17096, 17095, 17094, 17093, 17091, 17090, 17089, 17088, 17087, 17086, 17085, 17084, 17083, 17081, 17080, 17079, 17078, 17077, 17076, 17075, 17073, 17072, 17070, 17069, 17068, 17067, 17066, 17065, 17064, 17063, 17062, 17061, 17060, 17059, 17058, 17057, 17056, 17055, 17054, 17053, 17052, 17051, 17048, 17047, 17046, 17045, 17044, 17043, 17042, 17041, 17040, 17039, 17037, 17036, 17035, 17034, 17033, 17032, 17031, 17030, 17029, 17028, 17026, 17025, 17023, 17022, 17021, 17020, 17019, 17018, 17017, 17016, 17015, 17014, 17012, 17011, 17010, 17009, 17008, 17007, 17005, 17004, 17003, 17002, 17001, 17000, 16999, 16998, 16997, 16996, 16995, 16994, 16993, 16992, 16991, 16990, 16989, 16988, 16987, 16986, 16985, 16984, 16983, 16981, 16979, 16978, 16977, 16976, 16975, 16974, 16973, 16972, 16971, 16970, 16969, 16968, 16967, 16966, 16964, 16962, 16961, 16959, 16958, 16955, 16953, 16952, 16951, 16950, 16949, 16948, 16947, 16945, 16944, 16943, 16940, 16939, 16938, 16937, 16934, 16933, 16930, 16929, 16928, 16927, 16925, 16924, 16923, 16922, 16921, 16920, 16919, 16918, 16914, 16912, 16911, 16910, 16909, 16908, 16907, 16903, 16902, 16901, 16900, 16898, 16897, 16896, 16895, 16894, 16893, 16892, 16891, 16890, 16889, 16888, 16887, 16886, 16884, 16883, 16882, 16881, 16880, 16878, 16876, 16873, 16872, 16871, 16868, 16866, 16863, 16862, 16861, 16860, 16859, 16858, 16857, 16856, 16854, 16853, 16852, 16851, 16849, 16848, 16846, 16845, 16843, 16842, 16841, 16840, 16835, 16834, 16833, 16832, 16831, 16829, 16827, 16825, 16824, 16823, 16817, 16816, 16815, 16811, 16810, 16809, 16806, 16804, 16803, 16802, 16801, 16800, 16799, 16798, 16797, 16795, 16794, 16793, 16791, 16790, 16789, 16788, 16787, 16786, 16777, 16772, 16771, 16770, 16769, 16768, 16766, 16763, 16762, 16761, 16760, 16759, 16758, 16756, 16755, 16754, 16753, 16752, 16751, 16750, 16749, 16748, 16747, 16746, 16745, 16744, 16743, 16742, 16741, 16740, 16739, 16732, 16731, 16730, 16729, 16728, 16726, 16721, 16720, 16719, 16718, 16717, 16713, 16712, 16707, 16706, 16704, 16702, 16701, 16700, 16699, 16698, 16696, 16695, 16694, 16689, 16685, 16684, 16683, 16682, 16681, 16676, 16674, 16673, 16671, 16670, 16669, 16668, 16667, 16666, 16665, 16664, 16662, 16660, 16659, 16658, 16657, 16656, 16655, 16652, 16651, 16650, 16649, 16648, 16647, 16641, 16640, 16638, 16637, 16636, 16630, 16629, 16628, 16627, 16626, 16625, 16624, 16623, 16620, 16619, 16618, 16617, 16616, 16610, 16609, 16608, 16607, 16606, 16605, 16602, 16601, 16600, 16598, 16597, 16596, 16595, 16592, 16591, 16589, 16587, 16586, 16584, 16583, 16582, 16581, 16580, 16579, 16578, 16576, 16575, 16574, 16573, 16572, 16569, 16566, 16565, 16563, 16561, 16560, 16559, 16558, 16552, 16551, 16550, 16549, 16548, 16544, 16542, 16538, 16537, 16536, 16535, 16534, 16532, 16527, 16526, 16525, 16523, 16522, 16521, 16520, 16519, 16518, 16517, 16516, 16515, 16514, 16513, 16512, 16511, 16510, 16509, 16507, 16506, 16505, 16504, 16503, 16502, 16501, 16500, 16499, 16498, 16497, 16495, 16487, 16485, 16484, 16483, 16482, 16481, 16480, 16479, 16478, 16475, 16474, 16472, 16471, 16470, 16469, 16468, 16467, 16466, 16464, 16463, 16456, 16455, 16454, 16453, 16452, 16451, 16448, 16447, 16446, 16445, 16444, 16442, 16440, 16438, 16437, 16436, 16435, 16434, 16433, 16428, 16427, 16426, 16425, 16424, 16423, 16422, 16421, 16420, 16419, 16414, 16409, 16408, 16402, 16401, 16400, 16399, 16397, 16396, 16394, 16392, 16391, 16390, 16389, 16388, 16386, 16385, 16382, 16381, 16380, 16379, 16378, 16377, 16376, 16374, 16372, 16369, 16368, 16367, 16365, 16364, 16362, 16361, 16360, 16359, 16358, 16353, 16352, 16351, 16350, 16349, 16348, 16347, 16346, 16345, 16343, 16342, 16340, 16339, 16338, 16332, 16329, 16328, 16326, 16325, 16324, 16323, 16322, 16318, 16317, 16316, 16315, 16313, 16312, 16311, 16310, 16309, 16308, 16306, 16305, 16304, 16303, 16302, 16301, 16300, 16299, 16298, 16297, 16295, 16294, 16289, 16288, 16287, 16286, 16285, 16278, 16272, 16269, 16253, 16252, 16251, 16250, 16249, 16248, 16247, 16246, 16245, 16244, 16243, 16242, 16241, 16240, 16239, 16238, 16236, 16235, 16234, 16233, 16232, 16231, 16230, 16225, 16224, 16223, 16222, 16221, 16220, 16215, 16214, 16213, 16212, 16210, 16209, 16201, 16200, 16199, 16197, 16195, 16194, 16188, 16187, 16186, 16185, 16184, 16179, 16177, 16176, 16175, 16174, 16173, 16166, 16164, 16163, 16162, 16161, 16160, 16159, 16158, 16153, 16152, 16151, 16150, 16148, 16147, 16146, 16145, 16144, 16139, 16138, 16137, 16136, 16135, 16134, 16133, 16132, 16131, 16130, 16129, 16128, 16127, 16126, 16124, 16123, 16122, 16121, 16120, 16119, 16118, 16113, 16112, 16111, 16110, 16109, 16108, 16101, 16100, 16097, 16096, 16095, 16094, 16093, 16092, 16091, 16090, 16089, 16086, 16085, 16084, 16082, 16081, 16080, 16077, 16074, 16073, 16072, 16071, 16070, 16069, 16068, 16067, 16066, 16065, 16064, 16063, 16062, 16061, 16060, 16057, 16056, 16055, 16054, 16053, 16050, 16049, 16048, 16047, 16046, 16044, 16043, 16042, 16041, 16036, 16035, 16033, 16032, 16031, 16030, 16027, 16026, 16025, 16024, 16023, 16022, 16020, 16019, 16018, 16017, 16016, 16015, 16006, 16005, 16004, 16003, 16002, 16001, 16000, 15999, 15996, 15995, 15994, 15993, 15991, 15990, 15989, 15988, 15987, 15986, 15985, 15984, 15983, 15982, 15981, 15980, 15979, 15978, 15977, 15976, 15972, 15961, 15960, 15959, 15958, 15956, 15955, 15954, 15952, 15948, 15945, 15942, 15941, 15938, 15937, 15936, 15935, 15934, 15933, 15931, 15930, 15927, 15924, 15923, 15922, 15921, 15920, 15919, 15914, 15908, 15907, 15906, 15905, 15904, 15903, 15902, 15901, 15900, 15899, 15898, 15896, 15892, 15891, 15890, 15888, 15887, 15886, 15885, 15882, 15881, 15880, 15878, 15877, 15875, 15874, 15873, 15872, 15871, 15870, 15867, 15866, 15865, 15860, 15858, 15857, 15856, 15855, 15854, 15849, 15848, 15845, 15844, 15843, 15842, 15841, 15840, 15839, 15838, 15836, 15831, 15826, 15823, 15822, 15821, 15820, 15819, 15817, 15816, 15815, 15813, 15812, 15811, 15809, 15804, 15803, 15802, 15801, 15800, 15799, 15797, 15793, 15791, 15788, 15787, 15786, 15785, 15784, 15783, 15780, 15779, 15778, 15777, 15776, 15775, 15774, 15773, 15772, 15771, 15770, 15769, 15768, 15766, 15764, 15763, 15759, 15758, 15757, 15755, 15754, 15748, 15747, 15746, 15744, 15743, 15741, 15740, 15739, 15738, 15733, 15732, 15730, 15729, 15728, 15727, 15726, 15725, 15722, 15721, 15720, 15718, 15717, 15716, 15714, 15712, 15710, 15709, 15708, 15703, 15701, 15700, 15699, 15698, 15697, 15696, 15695, 15692, 15691, 15689, 15687, 15682, 15681, 15678, 15677, 15676, 15675, 15667, 15666, 15661, 15660, 15659, 15651, 15650, 15528, 15525, 15523, 15522, 15521, 15520, 15399, 15375, 15374, 15373, 15372, 15370, 15367, 15366, 15365, 15364, 15362, 15361, 15356, 15355, 15339, 15338, 15332, 15331, 15330, 15328, 15323, 15322, 15321, 15318, 15317, 15316, 15315, 15302, 15296, 15294, 15292, 15289, 15284, 15280, 15278, 15277, 15257, 15227, 15226, 15224, 15222, 15221, 15220, 15215, 15214, 15212, 15211, 15210, 15203, 15198, 15194, 15193, 15192, 15191, 15187, 15186, 15183, 15182, 15181, 15180, 15176, 15175, 15174, 15173, 15171, 15166, 15165, 15163, 15161, 15155, 15152, 15150, 15142, 15132, 15130, 15123, 15118, 15117, 15116, 15115, 15114, 15112, 15111, 15110, 15109, 15108, 15107, 15106, 15104, 15103, 15102, 15101, 15100, 15095, 15093, 15087, 15084, 15078, 15077, 15076, 15075, 15073, 15072, 15071, 15070, 15069, 15068, 15067, 15060, 15059, 15057, 15051, 15050, 15049, 15048, 15047, 15045, 15044, 15043, 15042, 15041, 15040, 15032, 15026, 15024, 15023, 15021, 15019, 15018, 15011, 15009, 15008, 15006, 15005, 14986, 14972, 14970, 14961, 14960, 14958, 14956, 14954, 14953, 14951, 14950, 14949, 14948, 14947, 14946, 14944, 14936, 14932, 14929, 14926, 14924, 14923, 14921, 14916, 14913, 14906, 14904, 14903, 14891, 14886, 14885, 14884, 14883, 14882, 14881, 14880, 14875, 14869, 14863, 14860, 14858, 14853, 14852, 14851, 14849, 14847, 14846, 14845, 14840, 14833, 14832, 14830, 14829, 14827, 14826, 14824, 14819, 14806, 14805, 14791, 14789, 14788, 14784, 14783, 14782, 14781, 14780, 14776, 14775, 14771, 14758, 14753, 14752, 14751, 14746, 14745, 14744, 14743, 14742, 14734, 14732, 14730, 14729, 14727, 14715, 14709, 14708, 14706, 14705, 14702, 14697, 14695, 14694, 14693, 14685, 14682, 14676, 14674, 14669, 14666, 14665, 14664, 14663, 14662, 14661, 14660, 14659, 14658, 14654, 14648, 14646, 14637, 14636, 14635, 14634, 14625, 14623, 14622, 14621, 14618, 14617, 14614, 14611, 14608, 14602, 14594, 14592, 14591, 14590, 14584, 14579, 14574, 14567, 14566, 14564, 14562, 14559, 14555, 14549, 14544, 14543, 14542, 14541, 14527, 14526, 14525, 14523, 14515, 14514, 14507, 14505, 14500, 14494, 14491, 14489, 14488, 14483, 14482, 14480, 14476, 14475, 14474, 14473, 14472, 14471, 14470, 14469, 14468, 14467, 14465, 14464, 14457, 14456, 14455, 14454, 14453, 14449, 14445, 14444, 14438, 14437, 14426, 14422, 14419, 14411, 14406, 14405, 14402, 14401, 14397, 14396, 14392, 14389, 14386, 14378, 14374, 14373, 14364, 14359, 14355, 14351, 14348, 14340, 14338, 14337, 14332, 14331, 14330, 14328, 14327, 14326, 14325, 14319, 14315, 14312, 14308, 14305, 14304, 14294, 14292, 14291, 14290, 14289, 14279, 14277, 14276, 14269, 14268, 14266, 14262, 14260, 14253, 14252, 14249, 14246, 14245, 14244, 14243, 14237, 14232, 14228, 14220, 14219, 14211, 14205, 14204, 14203, 14202, 14201, 14200, 14199, 14197, 14196, 14184, 14182, 14180, 14179, 14177, 14172, 14171, 14164, 14160, 14159, 14158, 14157, 14154, 14150, 14146, 14140, 14139, 14134, 14127, 14126, 14121, 14120, 14119, 14112, 14103, 14083, 14079, 14070, 14069, 14057, 14053, 14050, 14043, 14029, 14006, 14002, 13994, 13993, 13973, 13966, 13960, 13955, 13954, 13934, 13932, 13918, 13909, 13906, 13905, 13904, 13903, 13901, 13892, 13885, 13876, 13875, 13857, 13855, 13854, 13825, 13822, 13821, 13819, 13818, 13817, 13809, 13808, 13788, 13784, 13751, 13741, 13740, 13737, 13736, 13735, 13734, 13731, 13722, 13718, 13717, 13716, 13715, 13714, 13713, 13712, 13707, 13703, 13696, 13695, 13687, 13684, 13677, 13676, 13675, 13674, 13673, 13672, 13662, 13655, 13653, 13646, 13645, 13640, 13639, 13638, 13637, 13636, 13635, 13634, 13633, 13631, 13627, 13621, 13620, 13619, 13615, 13612, 13608, 13601, 13599, 13595, 13587, 13580, 13579, 13570, 13566, 13565, 13562, 13561, 13559, 13554, 13553, 13551, 13546, 13545, 13543, 13542, 13541, 13540, 13533, 13532, 13531, 13530, 13529, 13528, 13527, 13517, 13516, 13515, 13509, 13504, 13503, 13502, 13501, 13500, 13499, 13494, 13493, 13492, 13481, 13479, 13475, 13471, 13470, 13469, 13468, 13467, 13466, 13465, 13464, 13463, 13462, 13460, 13458, 13449, 13443, 13442, 13441, 13439, 13437, 13436, 13432, 13431, 13430, 13429, 13428, 13426, 13425, 13423, 13422, 13418, 13417, 13416, 13415, 13410, 13409, 13408, 13402, 13401, 13398, 13397, 13391, 13390, 13387, 13385, 13382, 13380, 13379, 13378, 13377, 13376, 13375, 13366, 13359, 13355, 13354, 13353, 13352, 13344, 13335, 13325, 13315, 13308, 13306, 13299, 13297, 13292, 13290, 13289, 13283, 13282, 13273, 13268, 13267, 13266, 13265, 13264, 13262, 13261, 13260, 13259, 13255, 13254, 13248, 13247, 13242, 13229, 13228, 13221, 13220, 13209, 13202, 13200, 13193, 13189, 13179, 13177, 13171, 13170, 13160, 13159, 13158, 13157, 13154, 13153, 13147, 13145, 13139, 13136, 13134, 13132, 13125, 13119, 13117, 13114, 13110, 13109, 13108, 13106, 13103, 13102, 13098, 13095, 13093, 13089, 13088, 13075, 13074, 13073, 13072, 13070, 13065, 13060, 13059, 13045, 13044, 13041, 13037, 13035, 13034, 13029, 13028, 13024, 13023, 13019, 13015, 13009, 13008, 13007, 13006, 12999, 12998, 12994, 12993, 12992, 12989, 12988, 12987, 12983, 12976, 12974, 12972, 12967, 12962, 12961, 12955, 12954, 12953, 12945, 12939, 12935, 12933, 12930, 12925, 12924, 12923, 12922, 12913, 12906, 12901, 12899, 12894, 12893, 12887, 12885, 12883, 12879, 12877, 12876, 12875, 12874, 12869, 12863, 12860, 12859, 12858, 12856, 12855, 12843, 12840, 12838, 12834, 12833, 12830, 12828, 12822, 12819, 12817, 12816, 12811, 12810, 12809, 12802, 12793, 12792, 12791, 12781, 12778, 12772, 12771, 12770, 12759, 12752, 12751, 12750, 12748, 12747, 12746, 12737, 12736, 12724, 12722, 12718, 12717, 12716, 12705, 12702, 12700, 12699, 12698, 12697, 12695, 12694, 12693, 12692, 12691, 12690, 12688, 12684, 12682, 12670, 12664, 12662, 12661, 12660, 12659, 12658, 12655, 12653, 12648, 12641, 12639, 12627, 12625, 12624, 12619, 12617, 12615, 12613, 12612, 12610, 12609, 12607, 12604, 12439, 12436, 12435, 12434, 12431, 12427, 12421, 12420, 12417, 12412, 12410, 12407, 12405, 12404, 12401, 12398, 12392, 12391, 12389, 12382, 12379, 12373, 12371, 12368, 12367, 12362, 12343, 12336, 12334, 12326, 12311, 12288, 12280, 12258, 12257, 12256, 12248, 12221, 12219, 12217, 12200, 12185, 12170, 12124, 12122, 12121, 12107, 12081, 12077, 12075, 12067, 12058, 12057, 12044, 12036, 12023, 12022, 12021, 12011, 12003, 11991, 11989, 11987, 11986, 11984, 11974, 11968, 11967, 11966, 11965, 11963, 11933, 11931, 11920, 11919, 11915, 11899, 11851, 11849, 11812, 11799, 11774, 11741, 11739, 11734, 11707, 11695, 11694, 11663, 11659, 11637, 11624, 11621, 11594, 11590, 11574, 11565, 11554, 11529, 11522, 11625, 11511, 11488, 11480, 11478, 11450, 11431, 11405, 11391, 11386, 11380, 11376, 11341, 11487, 11299, 11293, 11292, 11285, 298) AND field_id IN('closed_thread') LIMIT 50000
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
PRIMARY | <subquery2> | ALL | distinct_key | 1936 | ||||
PRIMARY | xf_alff_field_index | eq_ref | content_field,content_id_content_type | content_field | 58 | tvc_0._col_1,const,const | 1 | Using index condition |
MATERIALIZED | <derived3> | ALL | 1936 | |||||
DERIVED | No tables used |
SELECT `xf_thread`.*, `xf_snog_private_thread_PrivateThread_1`.*, `xf_seo_thread_meta_Meta_2`.*, `xf_user_User_3`.*, `xf_user_LastPoster_4`.*, `xf_tl_schedule_content_TSC_Schedule_5`.*, `xf_altt_thread_thumbnail_ThreadThumbnail_6`.*, `xf_attachment_Attachment_7`.*, `xf_attachment_data_Data_8`.*, `xf_post_FirstPost_9`.*, `xf_user_User_10`.*, `xf_user_option_Option_11`.*, `xf_user_profile_Profile_12`.*, `xf_user_privacy_Privacy_13`.*, `xf_permission_combination_PermissionCombination_14`.*, `xf_session_activity_Activity_15`.*, `xf_tl_schedule_content_TSC_Schedule_16`.* FROM `xf_thread` LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_1` ON (`xf_snog_private_thread_PrivateThread_1`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_2` ON (`xf_seo_thread_meta_Meta_2`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_thread`.`last_post_user_id`) LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_5` ON (`xf_tl_schedule_content_TSC_Schedule_5`.`content_id` = `xf_thread`.`thread_id` AND `xf_tl_schedule_content_TSC_Schedule_5`.`content_type` = 'thread') LEFT JOIN `xf_altt_thread_thumbnail` AS `xf_altt_thread_thumbnail_ThreadThumbnail_6` ON (`xf_altt_thread_thumbnail_ThreadThumbnail_6`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_7` ON (`xf_attachment_Attachment_7`.`attachment_id` = `xf_altt_thread_thumbnail_ThreadThumbnail_6`.`attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_8` ON (`xf_attachment_data_Data_8`.`data_id` = `xf_attachment_Attachment_7`.`data_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_9` ON (`xf_post_FirstPost_9`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_user` AS `xf_user_User_10` ON (`xf_user_User_10`.`user_id` = `xf_post_FirstPost_9`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_11` ON (`xf_user_option_Option_11`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_12` ON (`xf_user_profile_Profile_12`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_13` ON (`xf_user_privacy_Privacy_13`.`user_id` = `xf_user_User_10`.`user_id`) LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_14` ON (`xf_permission_combination_PermissionCombination_14`.`permission_combination_id` = `xf_user_User_10`.`permission_combination_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_15` ON (`xf_session_activity_Activity_15`.`user_id` = `xf_user_User_10`.`user_id` AND `xf_session_activity_Activity_15`.`unique_key` = CONCAT(`xf_user_User_10`.`user_id`, '')) LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_16` ON (`xf_tl_schedule_content_TSC_Schedule_16`.`content_id` = `xf_post_FirstPost_9`.`post_id` AND `xf_tl_schedule_content_TSC_Schedule_16`.`content_type` = 'post') WHERE (`xf_thread`.`node_id` = 27) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`ozzmodz_sc_is_scheduled` = 0) AND ((`xf_snog_private_thread_PrivateThread_1`.`snog_canview` IS NULL) OR (`xf_snog_private_thread_PrivateThread_1`.`snog_canview` LIKE '%\"0\"%')) AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`sticky` = 0) ORDER BY `xf_thread`.`post_date` DESC LIMIT 25
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_sticky_state_last_post | 6 | const,const,const | 1935 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_snog_private_thread_PrivateThread_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_seo_thread_meta_Meta_2 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.last_post_user_id | 1 | |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_5 | ALL | content_id_content_type | 1 | Using where; Using join buffer (flat, BNL join) | |||
SIMPLE | xf_altt_thread_thumbnail_ThreadThumbnail_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | |
SIMPLE | xf_attachment_Attachment_7 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_altt_thread_thumbnail_ThreadThumbnail_6.attachment_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_8 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_Attachment_7.data_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_9 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_10 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_post_FirstPost_9.user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_11 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_12 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_13 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_14 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_10.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_15 | eq_ref | PRIMARY | PRIMARY | 22 | edewan_db.xf_user_User_10.user_id,func | 1 | Using where |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_16 | ALL | content_id_content_type | 1 | Using where; Using join buffer (flat, BNL join) |
SELECT COUNT(*) FROM `xf_thread` LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_1` ON (`xf_snog_private_thread_PrivateThread_1`.`thread_id` = `xf_thread`.`thread_id`) WHERE (`xf_thread`.`node_id` = 27) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`ozzmodz_sc_is_scheduled` = 0) AND ((`xf_snog_private_thread_PrivateThread_1`.`snog_canview` IS NULL) OR (`xf_snog_private_thread_PrivateThread_1`.`snog_canview` LIKE '%\"0\"%')) AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`sticky` = 0)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_sticky_state_last_post | 6 | const,const,const | 1935 | Using index condition; Using where |
SIMPLE | xf_snog_private_thread_PrivateThread_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | Using where |
SELECT `xf_thread_prefix`.* FROM `xf_thread_prefix` WHERE (`xf_thread_prefix`.`prefix_id` IN (1, 2, 22, 3, 41)) ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix | range | PRIMARY | PRIMARY | 4 | 5 | Using where; Using filesort |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_thread_LastThreadPrivate_2`.*, `xf_snog_private_thread_PrivateThread_3`.*, `xf_snog_private_thread_HasPrivate_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_forum` INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThreadPrivate_2` ON (`xf_thread_LastThreadPrivate_2`.`node_id` = `xf_forum`.`node_id` AND `xf_thread_LastThreadPrivate_2`.`thread_id` = `xf_forum`.`last_thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_3` ON (`xf_snog_private_thread_PrivateThread_3`.`thread_id` = `xf_thread_LastThreadPrivate_2`.`thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_HasPrivate_4` ON (`xf_snog_private_thread_HasPrivate_4`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_forum`.`node_id` = '27') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThreadPrivate_2 | const | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_private_thread_PrivateThread_3 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_snog_private_thread_HasPrivate_4 | ref | node_id | node_id | 4 | const | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,const | 1 | Using where |
SELECT `xf_node`.* FROM `xf_node` WHERE (`xf_node`.`node_id` = '27')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_moderator_content`.*, `xf_user_User_1`.* FROM `xf_moderator_content` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_moderator_content`.`user_id`) WHERE (`xf_moderator_content`.`content_type` = 'node') AND ((`xf_moderator_content`.`content_id` = 3)) ORDER BY `xf_user_User_1`.`username` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_moderator_content | ref | content_user_id | content_user_id | 31 | const,const | 1 | Using where; Using index; Using temporary; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_moderator_content.user_id | 1 |
SELECT `xf_moderator_content`.*, `xf_user_User_1`.* FROM `xf_moderator_content` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_moderator_content`.`user_id`) WHERE (`xf_moderator_content`.`content_type` = 'node') AND (`xf_moderator_content`.`content_id` = '27') ORDER BY `xf_user_User_1`.`username` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_moderator_content | ref | content_user_id | content_user_id | 31 | const,const | 1 | Using where; Using index; Using temporary; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_moderator_content.user_id | 1 |
SELECT `xf_moderator`.*, `xf_user_User_1`.* FROM `xf_moderator` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_moderator`.`user_id`) WHERE (`xf_moderator`.`is_super_moderator` = 1) ORDER BY `xf_user_User_1`.`username` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_moderator | ALL | 7 | Using where; Using temporary; Using filesort | ||||
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_moderator.user_id | 1 |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_thread_LastThreadPrivate_2`.*, `xf_snog_private_thread_PrivateThread_3`.*, `xf_snog_private_thread_HasPrivate_4`.*, `xf_forum_ChaptersForum_5`.*, `xf_forum_ParentChaptersForum_6`.*, `xf_permission_cache_content_Permissions_7`.* FROM `xf_forum` INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThreadPrivate_2` ON (`xf_thread_LastThreadPrivate_2`.`node_id` = `xf_forum`.`node_id` AND `xf_thread_LastThreadPrivate_2`.`thread_id` = `xf_forum`.`last_thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_3` ON (`xf_snog_private_thread_PrivateThread_3`.`thread_id` = `xf_thread_LastThreadPrivate_2`.`thread_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_HasPrivate_4` ON (`xf_snog_private_thread_HasPrivate_4`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_5` ON (`xf_forum_ChaptersForum_5`.`node_id` = `xf_forum`.`ozzmodz_tct_node_id`) LEFT JOIN `xf_forum` AS `xf_forum_ParentChaptersForum_6` ON (`xf_forum_ParentChaptersForum_6`.`ozzmodz_tct_node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_7` ON (`xf_permission_cache_content_Permissions_7`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_7`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_7`.`permission_combination_id` = '1') WHERE (`xf_forum`.`node_id` = '27') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThreadPrivate_2 | const | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_private_thread_PrivateThread_3 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_snog_private_thread_HasPrivate_4 | ref | node_id | node_id | 4 | const | 1 | Using where |
SIMPLE | xf_forum_ChaptersForum_5 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_ParentChaptersForum_6 | ALL | 67 | Using where; Using join buffer (flat, BNL join) | ||||
SIMPLE | xf_permission_cache_content_Permissions_7 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,const | 1 | Using where |
SELECT `xf_thread`.*, `xf_snog_private_thread_PrivateThread_1`.*, `xf_seo_thread_meta_Meta_2`.*, `xf_user_User_3`.*, `xf_user_LastPoster_4`.*, `xf_tl_schedule_content_TSC_Schedule_5`.*, `xf_altt_thread_thumbnail_ThreadThumbnail_6`.*, `xf_attachment_Attachment_7`.*, `xf_attachment_data_Data_8`.* FROM `xf_thread` LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_1` ON (`xf_snog_private_thread_PrivateThread_1`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_2` ON (`xf_seo_thread_meta_Meta_2`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_thread`.`last_post_user_id`) LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_5` ON (`xf_tl_schedule_content_TSC_Schedule_5`.`content_id` = `xf_thread`.`thread_id` AND `xf_tl_schedule_content_TSC_Schedule_5`.`content_type` = 'thread') LEFT JOIN `xf_altt_thread_thumbnail` AS `xf_altt_thread_thumbnail_ThreadThumbnail_6` ON (`xf_altt_thread_thumbnail_ThreadThumbnail_6`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_7` ON (`xf_attachment_Attachment_7`.`attachment_id` = `xf_altt_thread_thumbnail_ThreadThumbnail_6`.`attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_8` ON (`xf_attachment_data_Data_8`.`data_id` = `xf_attachment_Attachment_7`.`data_id`) WHERE (`xf_thread`.`node_id` = 27) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`ozzmodz_sc_is_scheduled` = 0) AND ((`xf_snog_private_thread_PrivateThread_1`.`snog_canview` IS NULL) OR (`xf_snog_private_thread_PrivateThread_1`.`snog_canview` LIKE '%\"0\"%')) AND (`xf_thread`.`sticky` = 1) ORDER BY `xf_thread`.`post_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_sticky_state_last_post | 6 | const,const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_snog_private_thread_PrivateThread_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_seo_thread_meta_Meta_2 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.last_post_user_id | 1 | |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_5 | ALL | content_id_content_type | 1 | Using where; Using join buffer (flat, BNL join) | |||
SIMPLE | xf_altt_thread_thumbnail_ThreadThumbnail_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread.thread_id | 1 | |
SIMPLE | xf_attachment_Attachment_7 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_altt_thread_thumbnail_ThreadThumbnail_6.attachment_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_8 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_Attachment_7.data_id | 1 | Using where |
SELECT `xf_bespoke_sequential_stickies`.* FROM `xf_bespoke_sequential_stickies` WHERE (`xf_bespoke_sequential_stickies`.`thread_id` IN (298))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
-- 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)
-- XFDB=noForceAllWrite INSERT INTO xf_xc_ua_node_session_activity (`user_id`, `unique_key`, `ip`, `content_type`, `parent_id`, `content_id`, `view_state`, `view_date`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), content_type = VALUES(content_type), parent_id = VALUES(parent_id), content_id = VALUES(content_id), view_state = VALUES(view_state), view_date = VALUES(view_date)
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.* FROM `xf_siropu_ads_manager_ad` LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`) LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`)) WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active') ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 102 | const | 10 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
SELECT `xf_smilie`.* FROM `xf_smilie` WHERE (`xf_smilie`.`display_in_editor` = 1) AND (`xf_smilie`.`ozzmodz_sct_active` = 1) ORDER BY `xf_smilie`.`display_order` ASC, `xf_smilie`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_smilie | ALL | 91 | Using where; Using filesort |
SELECT `xf_xentr_randomTips`.* FROM `xf_xentr_randomTips` ORDER BY `xf_xentr_randomTips`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xentr_randomTips | ALL | 6 | Using filesort |
SELECT `xf_xentr_randomTips`.* FROM `xf_xentr_randomTips` ORDER BY `xf_xentr_randomTips`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xentr_randomTips | ALL | 6 | Using filesort |
SELECT `xf_cv6_dice`.* FROM `xf_cv6_dice` WHERE (`xf_cv6_dice`.`active` = '1') ORDER BY `xf_cv6_dice`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_cv6_dice | ALL | active | 4 | Using where; Using filesort |
SELECT `xf_th_node_styling`.* FROM `xf_th_node_styling` WHERE (`xf_th_node_styling`.`node_id` = 27) AND (`xf_th_node_styling`.`style_id` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_th_node_styling | ALL | 38 | Using where |
SELECT `xf_seo_node_meta`.* FROM `xf_seo_node_meta` WHERE (`xf_seo_node_meta`.`node_id` = 27) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_seo_node_meta | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('mh_strip_visited_thread')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT `xf_dbtech_shop_item`.*, `xf_user_User_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_dbtech_shop_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.* FROM `xf_dbtech_shop_item` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_dbtech_shop_item`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'dbtech_shop_item' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_dbtech_shop_item`.`item_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1') LEFT JOIN `xf_dbtech_shop_category` AS `xf_dbtech_shop_category_Category_3` ON (`xf_dbtech_shop_category_Category_3`.`category_id` = `xf_dbtech_shop_item`.`category_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'dbtech_shop_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_dbtech_shop_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dbtech_shop_item | ALL | 20 | |||||
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_dbtech_shop_item.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_dbtech_shop_item.item_id | 1 | Using where |
SIMPLE | xf_dbtech_shop_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_dbtech_shop_item.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_dbtech_shop_category_Category_3.category_id | 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` = 890) 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; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment.data_id | 1 |
SELECT `xf_connected_account_provider`.* FROM `xf_connected_account_provider` ORDER BY `xf_connected_account_provider`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_connected_account_provider | ALL | 26 | Using filesort |
SELECT `xf_xp_fm`.* FROM `xf_xp_fm` ORDER BY `xf_xp_fm`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xp_fm | ALL | 3 | Using filesort |
SELECT `xf_bm_ehdaa`.* FROM `xf_bm_ehdaa` ORDER BY `xf_bm_ehdaa`.`ehdaa_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bm_ehdaa | ALL | 1 | Using filesort |
SELECT `xf_bm_ehdaa`.* FROM `xf_bm_ehdaa` ORDER BY `xf_bm_ehdaa`.`ehdaa_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bm_ehdaa | ALL | 1 | Using filesort |
SELECT `xf_user`.*, `xf_style_StyleStats_1`.*, `xf_style_DefaultStyleStats_2`.*, `xf_user_privacy_Privacy_3`.* FROM `xf_user` LEFT JOIN `xf_style` AS `xf_style_StyleStats_1` ON (`xf_style_StyleStats_1`.`style_id` = `xf_user`.`style_id`) LEFT JOIN `xf_style` AS `xf_style_DefaultStyleStats_2` ON (`xf_style_DefaultStyleStats_2`.`style_id` = '1') LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user`.`user_id` = 916) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_style_StyleStats_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_style_DefaultStyleStats_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xfa_xcountdown`.*, `xfa_xcountdown_Parent_1`.* FROM `xfa_xcountdown` LEFT JOIN `xfa_xcountdown` AS `xfa_xcountdown_Parent_1` ON (`xfa_xcountdown_Parent_1`.`parent_id` = `xfa_xcountdown`.`parent_id`) WHERE (`xfa_xcountdown`.`start_date` < 1711661682) AND (`xfa_xcountdown`.`end_date` > 1711661682) AND (`xfa_xcountdown`.`location` LIKE '%header%') ORDER BY `xfa_xcountdown`.`end_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xfa_xcountdown | ALL | 11 | Using where; Using temporary; Using filesort | ||||
SIMPLE | xfa_xcountdown_Parent_1 | ALL | 11 | Using where; Using join buffer (flat, BNL join) |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('ozzmodz_wau_forum_statistics_users')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('ozzmodz_wau_forum_statistics_messages')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('ozzmodz_wau_forum_statistics_threads')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
bytes_sent | 89987 |
bytes_received | 2108006 |
packets_sent | 496 |
packets_received | 11266 |
protocol_overhead_in | 45064 |
protocol_overhead_out | 1984 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1566 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 458 |
bytes_received_prepare_response_packet | 767293 |
bytes_received_change_user_packet | 1336873 |
packets_sent_command | 247 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 174 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 84 |
packets_received_prepare_response | 8551 |
packets_received_change_user | 2373 |
result_set_queries | 80 |
non_result_set_queries | 4 |
no_index_used | 19 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 80 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 81 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 2293 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 2293 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 2293 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 2 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 3298 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 4015 |
proto_binary_fetched_int24 | 651 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 10944 |
proto_binary_fetched_decimal | 243 |
proto_binary_fetched_float | 576 |
proto_binary_fetched_double | 98 |
proto_binary_fetched_date | 484 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 4146 |
proto_binary_fetched_blob | 2286 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 82 |
com_stmt_execute | 82 |
com_stmt_send_long_data | 0 |
com_stmt_close | 81 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 1312446 |