SELECT parent_id, content_type, COUNT(*) AS total FROM `xf_xc_ua_node_session_activity` WHERE `view_date` >= 1711659601 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 | 3 | 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` = '45') 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` = 45) 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` = '45') 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` = '45') 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` = 45) 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 | 11 | 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_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`) WHERE (`xf_thread`.`node_id` = 45) 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\"%')) 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 | 722 | 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 |
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(15368, 15253, 15216, 14980, 14058, 14054, 14049, 14048, 14047, 14046, 14045, 14042, 14041, 14040, 14039, 14038, 14037, 14036, 14035, 14034, 14033, 14031, 14030, 14027, 14026, 14025, 14024, 14023, 14022, 14019, 14018, 14017, 14016, 14015, 14014, 14012, 14011, 14009, 14007, 14005, 14004, 14001, 14000, 13999, 13998, 13997, 13995, 13992, 13991, 13989, 13986, 13984, 13983, 13979, 13978, 13977, 13976, 13975, 13974, 13972, 13971, 13970, 13969, 13968, 13967, 13963, 13962, 13959, 13958, 13957, 13956, 13953, 13952, 13951, 13950, 13948, 13947, 13946, 13945, 13943, 13942, 13941, 13940, 13939, 13938, 13937, 13936, 13935, 13933, 13931, 13930, 13929, 13928, 13927, 13923, 13916, 13914, 13912, 13911, 13910, 13908, 13902, 13900, 13899, 13898, 13897, 13896, 13894, 13893, 13890, 13889, 13887, 13886, 13884, 13883, 13881, 13880, 13879, 13878, 13874, 13873, 13870, 13869, 13868, 13867, 13863, 13862, 13860, 13859, 13858, 13856, 13851, 13850, 13849, 13848, 13847, 13846, 13841, 13840, 13839, 13838, 13837, 13836, 13834, 13833, 13832, 13831, 13828, 13826, 13815, 13814, 13813, 13812, 13811, 13810, 13806, 13805, 13804, 13803, 13800, 13798, 13794, 13793, 13792, 13791, 13790, 13787, 13785, 13783, 13782, 13781, 13779, 13778, 13777, 13776, 13775, 13774, 13771, 13769, 13768, 13767, 13763, 13762, 13756, 13754, 13752, 13745, 12968, 12211, 12208, 12207, 12048, 12041, 12040, 12027, 12026, 11977, 11973, 11972, 11971, 11970, 11969, 11945, 11944, 11943, 11942, 11940, 11939, 11938, 11937, 11936, 11934, 11924, 11923, 11922, 11911, 11904, 11903, 11891, 11890, 11880, 11879, 11848, 11847, 11831, 11830, 11816, 11815, 11801, 11787, 11784, 11777, 11776, 11754, 11691, 11573, 11545, 11536, 11518, 11517, 11516, 11507, 11504, 11503, 11502, 11499, 11498, 11481, 11465, 11439, 11428, 11416, 11403, 11387, 11362, 11346, 11321, 11305, 11287, 11270, 11261, 11255, 11231, 11221, 11206, 11186, 11167, 11152, 11131, 11107, 11093, 11080, 11064, 11063, 11039, 11007, 10980, 10973, 10944, 10921, 10244, 10229, 10194, 10193, 10192, 9130, 8769, 8757, 8716, 8715, 8687, 8674, 8672, 8670, 8669, 8661, 8660, 8659, 8636, 8616, 8615, 8609, 8604, 8556, 8541, 8518, 8517, 8451, 8190, 8160, 8138, 8135, 7956, 7926, 7906, 7887, 7866, 7834, 7781, 7747, 7733, 7706, 7688, 7679, 7659, 7643, 7621, 7617, 7607, 7601, 7597, 7581, 7577, 7555, 7552, 7534, 7533, 7514, 7511, 7494, 7462, 7453, 7446, 7428, 7425, 7420, 7409, 7407, 7405, 7385, 7382, 7368, 7363, 7349, 7319, 7313, 7306, 7304, 7301, 7283, 7280, 7278, 7275, 7260, 7259, 7258, 7255, 7245, 7239, 7234, 7222, 7220, 7218, 7216, 7199, 7197, 7194, 7193, 7184, 7163, 7162, 7155, 7154, 7153, 7150, 7138, 7130, 7129, 7124, 7120, 7117, 7099, 7098, 7097, 7096, 7094, 7043, 7042, 7039, 7034, 7023, 7022, 7017, 7016, 6996, 6994, 6992, 6979, 6968, 6964, 6958, 6956, 6954, 6951, 6937, 6932, 6929, 6921, 6920, 6917, 6916, 6914, 6912, 6910, 6908, 6894, 6888, 6886, 6882, 6880, 6869, 6867, 6863, 6860, 6857, 6844, 6843, 6840, 6828, 6827, 6826, 6823, 6811, 6810, 6809, 6807, 6802, 6800, 6797, 6795, 6793, 6790, 6785, 6784, 6780, 6777, 6775, 6770, 6764, 6761, 6758, 6756, 6755, 6753, 6752, 6751, 6750, 6747, 6744, 6737, 6732, 6731, 6729, 6727, 6724, 6721, 6712, 6710, 6707, 6706, 6705, 6702, 6697, 6694, 6689, 6682, 6676, 6675, 6674, 6672, 6667, 6664, 6662, 6661, 6658, 6653, 6652, 6650, 6649, 6647, 6645, 6639, 6634, 6631, 6630, 6629, 6626, 6624, 6622, 6620, 6613, 6611, 6609, 6608, 6607, 6605, 6603, 6602, 6596, 6595, 6594, 6593, 6592, 6590, 6587, 6585, 6584, 6583, 6582, 6579, 6577, 6576, 6556, 6575, 6574, 6571, 6568, 6566, 6564, 6561, 6557, 6554, 6550, 6542, 6525, 6522, 6512, 6511, 6510, 6508, 6499, 6500, 6498, 6497, 6494, 6493, 6481, 6480, 6474, 6473, 6472, 6464, 6444, 6443, 6440, 6439, 6430, 6425, 6421, 6415, 6414, 6409, 6393, 6391, 6390, 6384, 6379, 6375, 6369, 6368, 6367, 6365, 6356, 6352, 6347, 6328, 6324, 6322, 6313, 6312, 6307, 6304, 6296, 6292, 6285, 6284, 6281, 6276, 6263, 6262, 6259, 6252, 6246, 6235, 6232, 6224, 6219, 6218, 6202, 6183, 6165, 6160, 6154, 6151, 6150, 6145, 6140, 6134, 6132, 6127, 6118, 6117, 6112, 6100, 6092, 6086, 6081, 6074, 6065, 6062, 6051, 6042, 6038, 6031, 6008, 6004, 5985, 5969, 5953, 5936, 5908, 5882, 5858, 5857, 5855, 5835, 5822, 5804, 5783, 5765, 5728, 5709, 5685, 5663, 5646, 5642, 5629, 5611, 5277, 5581, 5228, 5241, 5567, 5541, 5518, 5474, 5498, 5494, 5485, 5480, 5465, 5463, 5456, 5446, 5438, 5434, 5424, 5408, 5398, 5376, 5357, 5333, 5288, 4988, 4967, 4772, 4621, 4601, 4600, 4517, 4425, 4317, 4224, 4172, 4166, 4081, 3807, 3768, 3583, 3534, 3188, 3026, 3001, 2710, 2670, 2634, 2233, 2046, 1931, 1930, 1922, 1868, 1859, 1708, 1621, 1614, 1562, 1536, 1476, 1452, 1447, 1109) AND field_id IN('media_type', 'Media_Genres', 'underage', 'closed_thread') LIMIT 50000
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_alff_field_index | range | content_field,content_id_content_type | content_id_content_type | 31 | 722 | Using index condition; 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` = 45) 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` = 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 | 711 | 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 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` = 45) 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` = 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 | 711 | 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_node`.*, `xf_category_complex_join_0_1`.*, `xf_forum_complex_join_1_2`.*, `xf_user_LastPostUser_3`.*, `xf_thread_LastThread_4`.*, `xf_post_LastPostItem_5`.*, `xf_thread_Thread_6`.*, `xf_forum_Forum_7`.*, `xf_node_Node_8`.*, `xf_altt_thread_thumbnail_ThreadThumbnail_9`.*, `xf_attachment_Attachment_10`.*, `xf_attachment_data_Data_11`.*, `xf_snog_private_thread_HasPrivate_12`.*, `xf_forum_watch_Watch_13`.*, `xf_user_LastPoster_14`.*, `xf_link_forum_complex_join_2_15`.*, `xf_node_ProxiedNode_16`.*, `xf_forum_ProxiedForum_17`.*, `xf_user_LastPostUser_18`.*, `xf_thread_LastThread_19`.*, `xf_category_ProxiedCategory_20`.* FROM `xf_node` LEFT JOIN `xf_category` AS `xf_category_complex_join_0_1` ON (`xf_category_complex_join_0_1`.`node_id` = `xf_node`.`node_id`) LEFT JOIN `xf_forum` AS `xf_forum_complex_join_1_2` ON (`xf_forum_complex_join_1_2`.`node_id` = `xf_node`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_LastPostUser_3` ON (`xf_user_LastPostUser_3`.`user_id` = `xf_forum_complex_join_1_2`.`last_post_user_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThread_4` ON (`xf_thread_LastThread_4`.`thread_id` = `xf_forum_complex_join_1_2`.`last_thread_id`) LEFT JOIN `xf_post` AS `xf_post_LastPostItem_5` ON (`xf_post_LastPostItem_5`.`post_id` = `xf_forum_complex_join_1_2`.`last_post_id`) LEFT JOIN `xf_thread` AS `xf_thread_Thread_6` ON (`xf_thread_Thread_6`.`thread_id` = `xf_post_LastPostItem_5`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_7` ON (`xf_forum_Forum_7`.`node_id` = `xf_thread_Thread_6`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_8` ON (`xf_node_Node_8`.`node_id` = `xf_forum_Forum_7`.`node_id`) LEFT JOIN `xf_altt_thread_thumbnail` AS `xf_altt_thread_thumbnail_ThreadThumbnail_9` ON (`xf_altt_thread_thumbnail_ThreadThumbnail_9`.`thread_id` = `xf_thread_Thread_6`.`thread_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_10` ON (`xf_attachment_Attachment_10`.`attachment_id` = `xf_altt_thread_thumbnail_ThreadThumbnail_9`.`attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_11` ON (`xf_attachment_data_Data_11`.`data_id` = `xf_attachment_Attachment_10`.`data_id`) LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_HasPrivate_12` ON (`xf_snog_private_thread_HasPrivate_12`.`node_id` = `xf_forum_complex_join_1_2`.`node_id`) LEFT JOIN `xf_forum_watch` AS `xf_forum_watch_Watch_13` ON (`xf_forum_watch_Watch_13`.`node_id` = `xf_forum_complex_join_1_2`.`node_id` AND `xf_forum_watch_Watch_13`.`user_id` = '0') LEFT JOIN `xf_user` AS `xf_user_LastPoster_14` ON (`xf_user_LastPoster_14`.`user_id` = `xf_forum_complex_join_1_2`.`last_post_user_id`) LEFT JOIN `xf_link_forum` AS `xf_link_forum_complex_join_2_15` ON (`xf_link_forum_complex_join_2_15`.`node_id` = `xf_node`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_ProxiedNode_16` ON (`xf_node_ProxiedNode_16`.`node_id` = `xf_link_forum_complex_join_2_15`.`sv_proxy_node_id`) LEFT JOIN `xf_forum` AS `xf_forum_ProxiedForum_17` ON (`xf_forum_ProxiedForum_17`.`node_id` = `xf_link_forum_complex_join_2_15`.`sv_proxy_node_id`) LEFT JOIN `xf_user` AS `xf_user_LastPostUser_18` ON (`xf_user_LastPostUser_18`.`user_id` = `xf_forum_ProxiedForum_17`.`last_post_user_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThread_19` ON (`xf_thread_LastThread_19`.`thread_id` = `xf_forum_ProxiedForum_17`.`last_thread_id`) LEFT JOIN `xf_category` AS `xf_category_ProxiedCategory_20` ON (`xf_category_ProxiedCategory_20`.`node_id` = `xf_link_forum_complex_join_2_15`.`sv_proxy_node_id`) WHERE (`xf_node`.`lft` > 70) AND (`xf_node`.`rgt` < 73) AND (`xf_node`.`display_in_list` = '1') AND ((`xf_node`.`jum_language_id` = 0) OR (`xf_node`.`jum_language_id` = '2')) ORDER BY `xf_node`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | ref | display_in_list,lft | display_in_list | 1 | const | 30 | Using index condition; Using where |
SIMPLE | xf_category_complex_join_0_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_node.node_id | 1 | |
SIMPLE | xf_forum_complex_join_1_2 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_node.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_complex_join_1_2.last_post_user_id | 1 | Using where |
SIMPLE | xf_thread_LastThread_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_complex_join_1_2.last_thread_id | 1 | Using where |
SIMPLE | xf_post_LastPostItem_5 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_complex_join_1_2.last_post_id | 1 | Using where |
SIMPLE | xf_thread_Thread_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_post_LastPostItem_5.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_7 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_Thread_6.node_id | 1 | Using where |
SIMPLE | xf_node_Node_8 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_7.node_id | 1 | Using where |
SIMPLE | xf_altt_thread_thumbnail_ThreadThumbnail_9 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_Thread_6.thread_id | 1 | Using where |
SIMPLE | xf_attachment_Attachment_10 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_altt_thread_thumbnail_ThreadThumbnail_9.attachment_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_11 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_Attachment_10.data_id | 1 | Using where |
SIMPLE | xf_snog_private_thread_HasPrivate_12 | ref | node_id | node_id | 4 | edewan_db.xf_forum_complex_join_1_2.node_id | 2 | Using where |
SIMPLE | xf_forum_watch_Watch_13 | eq_ref | PRIMARY,node_id_notify_on | PRIMARY | 8 | const,edewan_db.xf_forum_complex_join_1_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_14 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_complex_join_1_2.last_post_user_id | 1 | Using where |
SIMPLE | xf_link_forum_complex_join_2_15 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_node.node_id | 1 | |
SIMPLE | xf_node_ProxiedNode_16 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_link_forum_complex_join_2_15.sv_proxy_node_id | 1 | Using where |
SIMPLE | xf_forum_ProxiedForum_17 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_link_forum_complex_join_2_15.sv_proxy_node_id | 1 | Using where |
SIMPLE | xf_user_LastPostUser_18 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_ProxiedForum_17.last_post_user_id | 1 | Using where |
SIMPLE | xf_thread_LastThread_19 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_ProxiedForum_17.last_thread_id | 1 | Using where |
SIMPLE | xf_category_ProxiedCategory_20 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_link_forum_complex_join_2_15.sv_proxy_node_id | 1 | Using where |
SELECT `xf_thread_prefix`.* FROM `xf_thread_prefix` WHERE (`xf_thread_prefix`.`prefix_id` IN (22, 3, 4, 24, 13, 41, 25)) 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 | 7 | 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` = '45') 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 1 FROM xf_xcpm_category WHERE thread_node_id = ? LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xcpm_category | ALL | 3 | Using where |
SELECT 1 FROM xfa_tourn_category WHERE thread_node_id = ? LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xfa_tourn_category | ALL | 4 | Using where |
SELECT 1 FROM xf_rm_category WHERE thread_node_id = ? LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_rm_category | ALL | 6 | Using where |
SELECT `xf_node`.* FROM `xf_node` WHERE (`xf_node`.`node_id` = '45')
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` = 44)) 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` = '45') 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` = '45') 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` = 45) 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 | 11 | 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 (10229, 10193, 10192, 9130, 8138, 8135, 7193, 6584, 6499, 5857, 5567))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bespoke_sequential_stickies | ALL | PRIMARY | 28 | Using where |
-- 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` = 45) 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` = 45) 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 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 | Impossible WHERE noticed after reading const tables |
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_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 28138) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 29790) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 29732) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 29731) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 25670) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 25664) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 23414) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 22304) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 22149) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 21011) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 20394) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.*, `xf_thread_Thread_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) LEFT JOIN `xf_thread` AS `xf_thread_Thread_2` ON (`xf_thread_Thread_2`.`thread_id` = `xf_post`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_2`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`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_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_post`.`post_id` = 43401) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 | |
SIMPLE | xf_thread_Thread_2 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_Thread_2.node_id | 1 | Using where |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_node_Node_4.node_id | 1 | Using where |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.*, `xf_thread_Thread_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) LEFT JOIN `xf_thread` AS `xf_thread_Thread_2` ON (`xf_thread_Thread_2`.`thread_id` = `xf_post`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_2`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`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_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_post`.`post_id` = 43100) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 | |
SIMPLE | xf_thread_Thread_2 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_Thread_2.node_id | 1 | Using where |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_node_Node_4.node_id | 1 | Using where |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.*, `xf_thread_Thread_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) LEFT JOIN `xf_thread` AS `xf_thread_Thread_2` ON (`xf_thread_Thread_2`.`thread_id` = `xf_post`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_2`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`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_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_post`.`post_id` = 43026) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 | |
SIMPLE | xf_thread_Thread_2 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_Thread_2.node_id | 1 | Using where |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_node_Node_4.node_id | 1 | Using where |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.*, `xf_thread_Thread_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) LEFT JOIN `xf_thread` AS `xf_thread_Thread_2` ON (`xf_thread_Thread_2`.`thread_id` = `xf_post`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_2`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`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_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_post`.`post_id` = 42126) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 | |
SIMPLE | xf_thread_Thread_2 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_Thread_2.node_id | 1 | Using where |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_node_Node_4.node_id | 1 | Using where |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39137) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39123) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39101) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39098) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39097) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39096) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39095) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39092) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39091) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39090) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39089) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39088) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39085) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39074) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39073) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39072) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39070) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39068) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39067) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39051) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 |
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.* FROM `xf_post` LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`post_id` = 39050) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 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 title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('altf_choice_label')
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_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` < 1711660501) AND (`xfa_xcountdown`.`end_date` > 1711660501) 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 | 100987 |
bytes_received | 5840658 |
packets_sent | 988 |
packets_received | 18551 |
protocol_overhead_in | 74204 |
protocol_overhead_out | 3952 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 3132 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 870 |
bytes_received_prepare_response_packet | 1224283 |
bytes_received_change_user_packet | 4608835 |
packets_sent_command | 493 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 348 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 166 |
packets_received_prepare_response | 14395 |
packets_received_change_user | 3476 |
result_set_queries | 162 |
non_result_set_queries | 4 |
no_index_used | 22 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 162 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 163 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 3314 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 3314 |
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 | 3314 |
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 | 3578 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 3682 |
proto_binary_fetched_int24 | 713 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 15766 |
proto_binary_fetched_decimal | 369 |
proto_binary_fetched_float | 786 |
proto_binary_fetched_double | 132 |
proto_binary_fetched_date | 474 |
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 | 11505 |
proto_binary_fetched_blob | 4232 |
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 | 164 |
com_stmt_execute | 164 |
com_stmt_send_long_data | 0 |
com_stmt_close | 163 |
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 | 4567909 |