SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 39 | Using where |
SELECT `xf_dbtech_credits_currency`.* FROM `xf_dbtech_credits_currency` WHERE (`xf_dbtech_credits_currency`.`currency_id` = '1') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dbtech_credits_currency | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('dbtCreditsCurrencies')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
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_dbtech_credits_event`.* FROM `xf_dbtech_credits_event` WHERE (`xf_dbtech_credits_event`.`currency_id` = 1) AND (`xf_dbtech_credits_event`.`event_trigger_id` = 'donate')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dbtech_credits_event | ALL | 3 | Using where |
SELECT `xf_navigation`.* FROM `xf_navigation` WHERE (`xf_navigation`.`is_mobile` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_navigation | ALL | 175 | Using where |
SELECT `xf_navigation`.* FROM `xf_navigation` WHERE (`xf_navigation`.`is_mobile` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_navigation | ALL | 175 | Using where |
SELECT `xf_navigation`.* FROM `xf_navigation` WHERE (`xf_navigation`.`is_mobile` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_navigation | ALL | 175 | Using where |
SELECT `xf_navigation`.* FROM `xf_navigation` WHERE (`xf_navigation`.`is_mobile` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_navigation | ALL | 175 | Using where |
SELECT `xf_dcMultisite_domain`.* FROM `xf_dcMultisite_domain` WHERE (`xf_dcMultisite_domain`.`is_active` = 1) ORDER BY `xf_dcMultisite_domain`.`domain_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcMultisite_domain | index | PRIMARY | 4 | 6 | Using where |
SELECT `xf_dcMultisite_domain`.* FROM `xf_dcMultisite_domain` WHERE (`xf_dcMultisite_domain`.`is_active` = 1) ORDER BY `xf_dcMultisite_domain`.`domain_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcMultisite_domain | index | PRIMARY | 4 | 6 | Using where |
SELECT `xf_dcMultisite_slugs`.* FROM `xf_dcMultisite_slugs`
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcMultisite_slugs | ALL | 13 |
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 COUNT(thread_id) FROM xf_thread
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | index | last_post_date | 4 | 483 | Using index |
SELECT COUNT(thread_id) FROM xf_thread_read WHERE user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_read | ref | user_id_thread_id | user_id_thread_id | 4 | const | 1 | Using index |
SELECT COUNT(article_id) FROM xf_xa_ams_article
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_article | index | publish_date | 4 | 26 | Using index |
SELECT COUNT(article_id) FROM xf_xa_ams_article_read WHERE user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_article_read | ref | user_id_article_id | user_id_article_id | 4 | const | 1 | Using index |
SELECT COUNT(blog_entry_id) FROM xf_xa_ubs_blog_entry
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ubs_blog_entry | index | publish_date | 4 | 781 | Using index |
SELECT COUNT(blog_entry_id) FROM xf_xa_ubs_blog_entry_read WHERE user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ubs_blog_entry_read | ref | user_id_blog_entry_id | user_id_blog_entry_id | 4 | const | 1 | Using index |
SELECT `xf_tl_group`.*, `xf_tl_group_category_Category_1`.*, `xf_tl_group_feature_Feature_2`.*, `xf_attachment_AvatarAttachment_3`.*, `xf_attachment_data_Data_4`.*, `xf_attachment_CoverAttachment_5`.*, `xf_attachment_data_Data_6`.* FROM `xf_tl_group` LEFT JOIN `xf_tl_group_category` AS `xf_tl_group_category_Category_1` ON (`xf_tl_group_category_Category_1`.`category_id` = `xf_tl_group`.`category_id`) LEFT JOIN `xf_tl_group_feature` AS `xf_tl_group_feature_Feature_2` ON (`xf_tl_group_feature_Feature_2`.`group_id` = `xf_tl_group`.`group_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_AvatarAttachment_3` ON (`xf_attachment_AvatarAttachment_3`.`attachment_id` = `xf_tl_group`.`avatar_attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_4` ON (`xf_attachment_data_Data_4`.`data_id` = `xf_attachment_AvatarAttachment_3`.`data_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_CoverAttachment_5` ON (`xf_attachment_CoverAttachment_5`.`attachment_id` = `xf_tl_group`.`cover_attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_6` ON (`xf_attachment_data_Data_6`.`data_id` = `xf_attachment_CoverAttachment_5`.`data_id`) WHERE (`xf_tl_group`.`group_id` = '4') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tl_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_tl_group_category_Category_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_tl_group_feature_Feature_2 | const | PRIMARY,group_id | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_attachment_AvatarAttachment_3 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_attachment_data_Data_4 | const | PRIMARY | 1 | Impossible ON condition | |||
SIMPLE | xf_attachment_CoverAttachment_5 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_attachment_data_Data_6 | const | PRIMARY | 1 | Impossible ON condition |
SELECT `xf_dcMultisite_domain`.* FROM `xf_dcMultisite_domain` WHERE (`xf_dcMultisite_domain`.`is_active` = 1) ORDER BY `xf_dcMultisite_domain`.`domain_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcMultisite_domain | index | PRIMARY | 4 | 6 | Using where |
SELECT frtThread.* FROM xf_xenmade_frt_thread as frtThread LEFT JOIN xf_xenmade_frt_read as frtRead ON (frtRead.frt_id = frtThread.frt_id AND frtRead.user_id = ?) WHERE ((FIND_IN_SET(1, frtThread.user_groups)) OR frtThread.user_groups = '' ) AND frtRead.read_date IS NULL AND (min_post = 0 OR min_post > 0) AND (frtThread.expire_date > 1715586661 OR frtThread.expire_date = 0) AND view_global = 1 AND active = 1 ORDER BY frtThread.order
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | frtThread | ALL | user_groups | 1 | Using where; Using filesort | |||
SIMPLE | frtRead | ref | frt_id_user_id,frt_id,user_id | frt_id_user_id | 8 | kairete_kairete.frtThread.frt_id,const | 1 | Using where; Not exists |
SELECT `xf_dcMultisite_domain`.* FROM `xf_dcMultisite_domain` WHERE (`xf_dcMultisite_domain`.`is_active` = 1) ORDER BY `xf_dcMultisite_domain`.`domain_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcMultisite_domain | index | PRIMARY | 4 | 6 | Using where |
SELECT frtThread.* FROM xf_xenmade_frt_thread as frtThread LEFT JOIN xf_xenmade_frt_read as frtRead ON (frtRead.frt_id = frtThread.frt_id AND frtRead.user_id = ?) WHERE ((FIND_IN_SET(1, frtThread.user_groups)) OR frtThread.user_groups = '' ) AND frtRead.read_date IS NULL AND (min_post = 0 OR min_post > 0) AND (frtThread.expire_date > 1715586661 OR frtThread.expire_date = 0) AND view_global = 1 AND active = 1 ORDER BY frtThread.order
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | frtThread | ALL | user_groups | 1 | Using where; Using filesort | |||
SIMPLE | frtRead | ref | frt_id_user_id,frt_id,user_id | frt_id_user_id | 8 | kairete_kairete.frtThread.frt_id,const | 1 | Using where; Not exists |
SELECT `xf_dcNewsGroup_newsfeed_group`.* FROM `xf_dcNewsGroup_newsfeed_group` WHERE (`xf_dcNewsGroup_newsfeed_group`.`group_id` = 4) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcNewsGroup_newsfeed_group | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` LEFT JOIN `xf_tl_group_post` AS `xf_tl_group_post_GroupPost_1` ON (`xf_tl_group_post_GroupPost_1`.`post_id` = `xf_dcContentShare_newsfeed_item`.`content_id` AND `xf_dcContentShare_newsfeed_item`.`content_type` = 'tl_group_post') WHERE (`xf_dcContentShare_newsfeed_item`.`content_type` = 'tl_group_post') AND (`xf_tl_group_post_GroupPost_1`.`group_id` = 4) ORDER BY `xf_dcContentShare_newsfeed_item`.`item_reaction_score` ASC, `xf_dcContentShare_newsfeed_item`.`item_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3151 | Using where; Using filesort | ||||
SIMPLE | xf_tl_group_post_GroupPost_1 | eq_ref | PRIMARY,group_sticky_last_comment_date | PRIMARY | 4 | kairete_kairete.xf_dcContentShare_newsfeed_item.content_id | 1 | Using where |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` LEFT JOIN `xf_xa_ams_article` AS `xf_xa_ams_article_ArticleItem_1` ON (`xf_xa_ams_article_ArticleItem_1`.`article_id` = `xf_dcContentShare_newsfeed_item`.`content_id` AND `xf_dcContentShare_newsfeed_item`.`content_type` = 'ams_article') WHERE (`xf_dcContentShare_newsfeed_item`.`content_type` = 'ams_article') AND (`xf_xa_ams_article_ArticleItem_1`.`category_id` IN ('7', '8', '9', '10')) ORDER BY `xf_dcContentShare_newsfeed_item`.`item_reaction_score` ASC, `xf_dcContentShare_newsfeed_item`.`item_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3151 | Using where; Using filesort | ||||
SIMPLE | xf_xa_ams_article_ArticleItem_1 | eq_ref | PRIMARY,category_publish_date,category_last_update,category_rating_weighted | PRIMARY | 4 | kairete_kairete.xf_dcContentShare_newsfeed_item.content_id | 1 | Using where |
SELECT `xf_thread`.* FROM `xf_thread` WHERE (`xf_thread`.`node_id` IN ('21', '23', '24', '25', '26')) AND (`xf_thread`.`discussion_state` = 'visible') 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 | range | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | node_id_last_post_date | 4 | 5 | Using index condition; Using where; Using filesort |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` WHERE (`xf_dcContentShare_newsfeed_item`.`content_type` = 'xfmg_album') AND (`xf_dcContentShare_newsfeed_item`.`content_id` IN ('11')) ORDER BY `xf_dcContentShare_newsfeed_item`.`item_reaction_score` ASC, `xf_dcContentShare_newsfeed_item`.`item_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3151 | Using where; Using filesort |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_MediaItem_1` ON (`xf_mg_media_item_MediaItem_1`.`media_id` = `xf_dcContentShare_newsfeed_item`.`content_id` AND `xf_dcContentShare_newsfeed_item`.`content_type` = 'xfmg_media') WHERE (`xf_dcContentShare_newsfeed_item`.`content_type` = 'xfmg_media') AND (`xf_mg_media_item_MediaItem_1`.`album_id` IN ('11')) ORDER BY `xf_dcContentShare_newsfeed_item`.`item_reaction_score` ASC, `xf_dcContentShare_newsfeed_item`.`item_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item_MediaItem_1 | ref | PRIMARY,album_id_media_date | album_id_media_date | 4 | const | 1 | Using index; Using temporary; Using filesort |
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3151 | Using where; Using join buffer (hash join) |
SELECT `xf_xa_ubs_blog`.*, `xf_user_User_1`.*, `xf_attachment_CoverImage_2`.*, `xf_attachment_data_Data_3`.* FROM `xf_xa_ubs_blog` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_ubs_blog`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_CoverImage_2` ON (`xf_attachment_CoverImage_2`.`content_type` = 'ubs_blog' AND `xf_attachment_CoverImage_2`.`content_id` = `xf_xa_ubs_blog`.`blog_id` AND `xf_attachment_CoverImage_2`.`attachment_id` = `xf_xa_ubs_blog`.`cover_image_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_3` ON (`xf_attachment_data_Data_3`.`data_id` = `xf_attachment_CoverImage_2`.`data_id`) WHERE (`xf_xa_ubs_blog`.`user_id` = 0) ORDER BY `xf_xa_ubs_blog`.`last_blog_entry_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ubs_blog | ref | user_id_last_update,user_id_create_date,user_id | user_id_last_update | 4 | const | 1 | Using filesort |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_CoverImage_2 | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | kairete_kairete.xf_xa_ubs_blog.cover_image_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_CoverImage_2.data_id | 1 |
SELECT `xf_xa_ubs_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_xa_ubs_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'ubs_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_ubs_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') ORDER BY `xf_xa_ubs_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ubs_category | ALL | 20 | Using filesort | ||||
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_xa_ubs_category.category_id | 1 | Using where |
SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT COUNT(*) FROM `xf_dcContentShare_newsfeed_item` WHERE (`xf_dcContentShare_newsfeed_item`.`item_id` IN (701, 703, 704, 705))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | range | PRIMARY | PRIMARY | 4 | 4 | Using where; Using index |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` WHERE (`xf_dcContentShare_newsfeed_item`.`item_id` IN (701, 703, 704, 705)) ORDER BY `xf_dcContentShare_newsfeed_item`.`item_date` DESC, `xf_dcContentShare_newsfeed_item`.`item_id` DESC LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | range | PRIMARY | PRIMARY | 4 | 4 | Using where; Using filesort |
SELECT `xf_tl_group_post`.*, `xf_user_User_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_privacy_Privacy_3`.*, `xf_tl_group_Group_4`.*, `xf_tl_group_category_Category_5`.*, `xf_tl_group_feature_Feature_6`.*, `xf_attachment_AvatarAttachment_7`.*, `xf_attachment_data_Data_8`.*, `xf_attachment_CoverAttachment_9`.*, `xf_attachment_data_Data_10`.*, `xf_tl_group_member_MemberPoster_11`.*, `xf_tl_group_member_role_MemberRole_12`.* FROM `xf_tl_group_post` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_tl_group_post`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_tl_group` AS `xf_tl_group_Group_4` ON (`xf_tl_group_Group_4`.`group_id` = `xf_tl_group_post`.`group_id`) LEFT JOIN `xf_tl_group_category` AS `xf_tl_group_category_Category_5` ON (`xf_tl_group_category_Category_5`.`category_id` = `xf_tl_group_Group_4`.`category_id`) LEFT JOIN `xf_tl_group_feature` AS `xf_tl_group_feature_Feature_6` ON (`xf_tl_group_feature_Feature_6`.`group_id` = `xf_tl_group_Group_4`.`group_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_AvatarAttachment_7` ON (`xf_attachment_AvatarAttachment_7`.`attachment_id` = `xf_tl_group_Group_4`.`avatar_attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_8` ON (`xf_attachment_data_Data_8`.`data_id` = `xf_attachment_AvatarAttachment_7`.`data_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_CoverAttachment_9` ON (`xf_attachment_CoverAttachment_9`.`attachment_id` = `xf_tl_group_Group_4`.`cover_attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_10` ON (`xf_attachment_data_Data_10`.`data_id` = `xf_attachment_CoverAttachment_9`.`data_id`) LEFT JOIN `xf_tl_group_member` AS `xf_tl_group_member_MemberPoster_11` ON (`xf_tl_group_member_MemberPoster_11`.`user_id` = `xf_tl_group_post`.`user_id` AND `xf_tl_group_member_MemberPoster_11`.`group_id` = `xf_tl_group_post`.`group_id`) LEFT JOIN `xf_tl_group_member_role` AS `xf_tl_group_member_role_MemberRole_12` ON (`xf_tl_group_member_role_MemberRole_12`.`member_role_id` = `xf_tl_group_member_MemberPoster_11`.`member_role_id`) WHERE ((`xf_tl_group_post`.`post_id` = 250) OR (`xf_tl_group_post`.`post_id` = 249) OR (`xf_tl_group_post`.`post_id` = 248)) ORDER BY `xf_tl_group_post`.`last_comment_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tl_group_post | range | PRIMARY | PRIMARY | 4 | 3 | Using where; Using temporary; Using filesort | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_tl_group_post.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_tl_group_Group_4 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_tl_group_post.group_id | 1 | |
SIMPLE | xf_tl_group_category_Category_5 | ALL | PRIMARY | 1 | Using where; Using join buffer (hash join) | |||
SIMPLE | xf_tl_group_feature_Feature_6 | ALL | PRIMARY,group_id | 1 | Using where; Using join buffer (hash join) | |||
SIMPLE | xf_attachment_AvatarAttachment_7 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_tl_group_Group_4.avatar_attachment_id | 1 | |
SIMPLE | xf_attachment_data_Data_8 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_AvatarAttachment_7.data_id | 1 | |
SIMPLE | xf_attachment_CoverAttachment_9 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_tl_group_Group_4.cover_attachment_id | 1 | |
SIMPLE | xf_attachment_data_Data_10 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_CoverAttachment_9.data_id | 1 | |
SIMPLE | xf_tl_group_member_MemberPoster_11 | eq_ref | user_id_group_id,group_id_member_state_joined_date | user_id_group_id | 8 | kairete_kairete.xf_tl_group_post.user_id,kairete_kairete.xf_tl_group_post.group_id | 1 | |
SIMPLE | xf_tl_group_member_role_MemberRole_12 | eq_ref | PRIMARY,member_role_id | PRIMARY | 52 | kairete_kairete.xf_tl_group_member_MemberPoster_11.member_role_id | 1 |
SELECT `xf_tl_group_comment`.*, `xf_user_User_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_privacy_Privacy_3`.*, `xf_session_activity_Activity_4`.* FROM `xf_tl_group_comment` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_tl_group_comment`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_4` ON (`xf_session_activity_Activity_4`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_4`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, '')) WHERE (`xf_tl_group_comment`.`comment_id` IN (677, 385, 384, 383))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tl_group_comment | range | PRIMARY | PRIMARY | 4 | 4 | Using where | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_tl_group_comment.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_session_activity_Activity_4 | eq_ref | PRIMARY | PRIMARY | 22 | kairete_kairete.xf_user_User_1.user_id,func | 1 | Using where |
SELECT `xf_dcSCGroup_sidebar`.* FROM `xf_dcSCGroup_sidebar` WHERE (`xf_dcSCGroup_sidebar`.`group_id` = 4) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcSCGroup_sidebar | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_widget`.* FROM `xf_widget` WHERE ((FIND_IN_SET('sidebar', `xf_widget`.`standard_group`))) ORDER BY `xf_widget`.`standardPos_group` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | ALL | 124 | Using where; Using filesort |
SELECT `xf_widget`.* FROM `xf_widget` WHERE ((FIND_IN_SET('sidenav', `xf_widget`.`standard_group`))) ORDER BY `xf_widget`.`standardPos_group` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | ALL | 124 | Using where; Using filesort |
SELECT `xf_widget`.* FROM `xf_widget` WHERE ((FIND_IN_SET('above_content', `xf_widget`.`standard_group`))) ORDER BY `xf_widget`.`standardPos_group` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | ALL | 124 | Using where; Using filesort |
SELECT `xf_dcSCGroup_widget_position`.* FROM `xf_dcSCGroup_widget_position` WHERE (`xf_dcSCGroup_widget_position`.`group_id` = 4) AND (`xf_dcSCGroup_widget_position`.`position` = 'sidebar') ORDER BY `xf_dcSCGroup_widget_position`.`order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcSCGroup_widget_position | ALL | 1 | Using where; Using filesort |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (1 = 0)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE |
SELECT `xf_dcSCGroup_widget_position`.* FROM `xf_dcSCGroup_widget_position` WHERE (`xf_dcSCGroup_widget_position`.`group_id` = 4) AND (`xf_dcSCGroup_widget_position`.`position` = 'sidenav') ORDER BY `xf_dcSCGroup_widget_position`.`order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcSCGroup_widget_position | ALL | 1 | Using where; Using filesort |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (1 = 0)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE |
SELECT `xf_dcSCGroup_widget_position`.* FROM `xf_dcSCGroup_widget_position` WHERE (`xf_dcSCGroup_widget_position`.`group_id` = 4) AND (`xf_dcSCGroup_widget_position`.`position` = 'above_content') ORDER BY `xf_dcSCGroup_widget_position`.`order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcSCGroup_widget_position | ALL | 1 | Using where; Using filesort |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (1 = 0)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE |
-- XFDB=noForceAllWrite INSERT INTO xf_session_activity (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`, `domain_id`) 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), domain_id = VALUES(domain_id)
-- XFDB=noForceAllWrite INSERT INTO xf_session_activity (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`, `domain_id`) 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), domain_id = VALUES(domain_id)
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 | 1 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.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_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (`xf_widget`.`widget_id` = 128) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`media_id` = 136) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_Attachment_4.data_id | 1 |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` WHERE (`xf_dcContentShare_newsfeed_item`.`content_id` = 136) AND (`xf_dcContentShare_newsfeed_item`.`content_type` = 'xfmg_media') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3151 | Using where |
SELECT `xf_mg_album`.* FROM `xf_mg_album` WHERE (`xf_mg_album`.`album_id` = 11) AND (`xf_mg_album`.`url` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_album | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`media_id` = 136) AND (`xf_mg_media_item`.`url` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_Attachment_4.data_id | 1 |
SELECT `xf_tl_group_mg_album`.* FROM `xf_tl_group_mg_album` WHERE (`xf_tl_group_mg_album`.`album_id` = 11) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xc_friend`.* FROM `xc_friend` WHERE (`xc_friend`.`user_id` = 0 AND `xc_friend`.`friend_user_id` = 1 AND `xc_friend`.`friend_state` = 'pending') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`media_id` = 136) AND (`xf_mg_media_item`.`url` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_Attachment_4.data_id | 1 |
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_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`media_id` = 136) AND (`xf_mg_media_item`.`url` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_Attachment_4.data_id | 1 |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`media_id` = 136) AND (`xf_mg_media_item`.`url` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_Attachment_4.data_id | 1 |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'xfmg_media' AND `xf_dcFakeReaction_content`.`content_id` = 136) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'xfmg_media' AND `xf_dcFakeReaction_content`.`content_id` = 136) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_mg_comment`.*, `xf_mg_album_Album_1`.*, `xf_mg_media_item_Media_2`.*, `xf_user_User_3`.*, `xf_user_profile_Profile_4`.*, `xf_session_activity_Activity_5`.*, `xf_mg_rating_Rating_6`.* FROM `xf_mg_comment` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_comment`.`content_type` = 'xfmg_album' AND `xf_mg_album_Album_1`.`album_id` = `xf_mg_comment`.`content_id`) LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_Media_2` ON (`xf_mg_comment`.`content_type` = 'xfmg_media' AND `xf_mg_media_item_Media_2`.`media_id` = `xf_mg_comment`.`content_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_comment`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_4` ON (`xf_user_profile_Profile_4`.`user_id` = `xf_user_User_3`.`user_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_3`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_3`.`user_id`, '')) LEFT JOIN `xf_mg_rating` AS `xf_mg_rating_Rating_6` ON (`xf_mg_rating_Rating_6`.`rating_id` = `xf_mg_comment`.`rating_id`) WHERE (`xf_mg_comment`.`content_type` = 'xfmg_media') AND (`xf_mg_comment`.`content_id` = 136) AND (`xf_mg_comment`.`parent_id` = 0) AND ((`xf_mg_comment`.`comment_state` IN ('visible'))) ORDER BY `xf_mg_comment`.`comment_date` DESC, `xf_mg_comment`.`comment_id` DESC LIMIT 5
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_comment | ref | content_type_content_id_comment_date | content_type_content_id_comment_date | 31 | const,const | 1 | Using where; Backward index scan |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
SIMPLE | xf_mg_media_item_Media_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_mg_comment.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_4 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_user_User_3.user_id | 1 | |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | kairete_kairete.xf_user_User_3.user_id,func | 1 | Using where |
SIMPLE | xf_mg_rating_Rating_6 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_mg_comment.rating_id | 1 |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (`xf_widget`.`widget_id` = 132) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xc_friend`.* FROM `xc_friend` WHERE (`xc_friend`.`user_id` = 0 AND `xc_friend`.`friend_user_id` = 1 AND `xc_friend`.`friend_state` = 'pending') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 385) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 385) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 677) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 677) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xc_friend`.* FROM `xc_friend` WHERE (`xc_friend`.`user_id` = 0 AND `xc_friend`.`friend_user_id` = 1 AND `xc_friend`.`friend_state` = 'pending') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 384) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 384) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xc_friend`.* FROM `xc_friend` WHERE (`xc_friend`.`user_id` = 0 AND `xc_friend`.`friend_user_id` = 1 AND `xc_friend`.`friend_state` = 'pending') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 383) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcFakeReaction_content`.* FROM `xf_dcFakeReaction_content` WHERE (`xf_dcFakeReaction_content`.`content_type` = 'tl_group_comment' AND `xf_dcFakeReaction_content`.`content_id` = 383) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcFakeReaction_content | ALL | 2037 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('tlg_resources')
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 ('xfmg_media')
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_dcGroupFriend_friend`.* FROM `xf_dcGroupFriend_friend` WHERE ((FIND_IN_SET(4, `xf_dcGroupFriend_friend`.`group_ids`)))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcGroupFriend_friend | ALL | 1 | Using where |
SELECT `xf_dcGroupFriend_friend`.* FROM `xf_dcGroupFriend_friend` WHERE ((FIND_IN_SET(4, `xf_dcGroupFriend_friend`.`group_ids`)))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcGroupFriend_friend | ALL | 1 | Using where |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`album_id` IN (10))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | ref | album_id_media_date | album_id_media_date | 4 | const | 837 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_category_Category_2 | ALL | PRIMARY | 1 | Using where; Using join buffer (hash join) | |||
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,kairete_kairete.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_Attachment_4.data_id | 1 |
SELECT `xf_tl_group_mg_album`.* FROM `xf_tl_group_mg_album` WHERE (`xf_tl_group_mg_album`.`album_id` = 10) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`media_id` IN (5, 60, 61, 63, 69, 79, 84, 104, 105, 106, 107, 110, 117, 122, 124, 125, 132, 133, 134, 142, 143, 150, 153, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 168, 169, 170, 171, 172, 173, 177, 178, 186, 187, 191, 192, 193, 194, 195, 197, 199, 201, 203, 204, 209, 214, 215, 216, 217, 218, 219, 220, 222, 223, 224, 225, 231, 233, 234, 236, 237, 238, 240, 242, 243, 245, 247, 248, 250, 251, 252, 253, 254, 257, 258, 259, 260, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 275, 276, 277, 278, 279, 280, 281, 285, 286, 287, 289, 290, 291, 293, 294, 295, 296, 297, 298, 299, 300, 303, 304, 305, 307, 308, 311, 312, 316, 317, 318, 319, 321, 322, 323, 324, 331, 332, 333, 335, 337, 338, 339, 340, 342, 343, 346, 347, 348, 349, 352, 353, 354, 357, 358, 359, 360, 361, 362, 364, 366, 367, 368, 369, 370, 372, 374, 375, 376, 377, 378, 379, 380, 381, 382, 384, 386, 387, 388, 389, 390, 391, 393, 394, 396, 397, 398, 399, 400, 401, 404, 405, 406, 407, 408, 410, 411, 413, 416, 417, 418, 419, 420, 421, 424, 425, 426, 427, 429, 430, 431, 432, 433, 434, 436, 437, 439, 440, 442, 443, 446, 449, 450, 454, 455, 456, 457, 459, 460, 463, 464, 467, 468, 469, 473, 474, 477, 479, 481, 482, 483, 486, 489, 491, 492, 493, 494, 496, 497, 500, 501, 502, 503, 504, 505, 506, 508, 509, 511, 512, 513, 515, 517, 519, 520, 521, 522, 523, 525, 527, 528, 529, 530, 532, 533, 534, 535, 536, 538, 540, 541, 544, 546, 547, 548, 552, 553, 554, 557, 560, 562, 563, 566, 567, 568, 570, 571, 573, 574, 575, 576, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 593, 594, 595, 596, 597, 598, 599, 600, 601, 603, 604, 605, 606, 607, 608, 609, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 633, 634, 635, 636, 637, 638, 639, 640, 641, 643, 645, 647, 649, 650, 651, 652, 653, 656, 657, 659, 660, 661, 662, 664, 665, 667, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 683, 684, 685, 686, 687, 688, 690, 693, 694, 695, 697, 699, 700, 701, 702, 703, 704, 705, 707, 708, 709, 710, 711, 713, 714, 715, 716, 717, 718, 719, 720, 721, 723, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 762, 763, 764, 765, 766, 767, 768, 769, 771, 772, 773, 774, 775, 776, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 790, 791, 792, 794, 795, 796, 797, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 834, 835, 836, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 984, 985, 986, 987, 988, 989, 990, 991, 992, 994, 995, 996, 997, 998, 999, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1021, 1022, 1023, 1024, 1025, 1026, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1039, 1040, 1041, 1042, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1079, 1080, 1081, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1092, 1093, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1114, 1115, 1116, 1117, 1118, 1120, 1121, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1145, 1146, 1147, 1148, 1152, 1153, 1154, 1155, 1157, 1158, 1159, 1160, 1161, 1163, 1164, 1165, 1166, 1167, 1168, 1173, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185)) AND (`xf_mg_media_item`.`media_type` IN ('audio', 'embed', 'image', 'video')) ORDER BY `xf_mg_media_item`.`media_date` DESC LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | ALL | PRIMARY | 1010 | Using where; Using temporary; Using filesort | |||
SIMPLE | xf_mg_album_Album_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_mg_media_item.album_id | 1 | |
SIMPLE | xf_mg_category_Category_2 | ALL | PRIMARY | 1 | Using where; Using join buffer (hash join) | |||
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,kairete_kairete.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_Attachment_4.data_id | 1 |
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcUserName_user_name | ALL | 45 | Using where |
SELECT `xf_tl_group_post`.* FROM `xf_tl_group_post` WHERE (`xf_tl_group_post`.`group_id` IN (2))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tl_group_post | ALL | group_sticky_last_comment_date | 1984 | Using where |
SELECT `xf_tl_group`.* FROM `xf_tl_group` WHERE (`xf_tl_group`.`group_id` = 2) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tl_group | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 599) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 584) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 556) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 559) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 449) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 872) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 555) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 866) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 558) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 460) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 590) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 503) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1008) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1027) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 963) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1059) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 876) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1037) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1051) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 588) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1081) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1031) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1044) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1009) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1053) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1085) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 516) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1134) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1124) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1123) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1175) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1205) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1308) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1524) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1638) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1640) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1637) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1641) LIMIT 1
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1645) LIMIT 1
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1967) LIMIT 1
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 1993) LIMIT 1
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 531) LIMIT 1
SELECT `xf_tl_group_post`.* FROM `xf_tl_group_post` WHERE (`xf_tl_group_post`.`post_id` IN (52, 53, 65, 68, 70, 71, 72, 78, 87, 90, 91, 92, 93, 94, 95, 96, 97, 98, 100, 101, 104, 106, 107, 108, 114, 115, 116, 117, 118, 119, 120, 121, 123, 124, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 196, 197, 198, 199, 200, 201, 202, 203, 204, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 239, 240, 241, 242, 243, 244, 245, 246, 247, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 331, 332, 333, 336, 337, 338, 339, 340, 341, 342, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 387, 388, 389, 390, 391, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 414, 415, 416, 417, 418, 419, 420, 424, 425, 426, 428, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 467, 468, 469, 470, 471, 472, 473, 474, 475, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 632, 633, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 649, 650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674, 675, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721, 722, 723, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 782, 783, 785, 786, 787, 788, 789, 790, 791, 792, 793, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 834, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 880, 881, 882, 883, 884, 885, 886, 887, 888, 890, 891, 892, 894, 896, 897, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 947, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 960, 961, 962, 963, 964, 965, 966, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 985, 986, 987, 988, 989, 990, 991, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1076, 1077, 1078, 1080, 1081, 1082, 1083, 1084, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1120, 1121, 1122, 1125, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1155, 1156, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1226, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1265, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1290, 1292, 1293, 1294, 1295, 1296, 1298, 1299, 1300, 1301, 1302, 1303, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1336, 1337, 1338, 1339, 1340, 1341, 1342, 1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364, 1365, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1405, 1406, 1407, 1408, 1409, 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1427, 1428, 1429, 1430, 1431, 1432, 1433, 1434, 1435, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1445, 1446, 1447, 1448, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1484, 1485, 1486, 1487, 1488, 1489, 1490, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1558, 1559, 1560, 1562, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1585, 1586, 1587, 1588, 1589, 1590, 1591, 1592, 1593, 1594, 1595, 1596, 1597, 1598, 1599, 1600, 1601, 1602, 1603, 1604, 1605, 1606, 1607, 1608, 1609, 1610, 1611, 1612, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1621, 1622, 1623, 1624, 1625, 1626, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1636, 1637, 1638, 1639, 1640, 1641, 1642, 1643, 1644, 1645, 1646, 1647, 1648, 1650, 1651, 1652, 1653, 1654, 1655, 1656, 1657, 1658, 1659, 1660, 1661, 1662, 1663, 1664, 1665, 1666, 1667, 1668, 1669, 1670, 1671, 1672, 1673, 1674, 1675, 1676, 1677, 1678, 1679, 1680, 1681, 1682, 1684, 1685, 1686, 1687, 1688, 1689, 1690, 1691, 1692, 1693, 1694, 1695, 1696, 1697, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1706, 1707, 1708, 1709, 1710, 1711, 1712, 1713, 1714, 1715, 1716, 1718, 1719, 1720, 1721, 1722, 1723, 1724, 1725, 1726, 1727, 1728, 1729, 1730, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1745, 1746, 1747, 1748, 1749, 1750, 1751, 1752, 1753, 1754, 1755, 1756, 1757, 1758, 1759, 1760, 1761, 1762, 1763, 1764, 1765, 1766, 1767, 1768, 1769, 1770, 1771, 1772, 1775, 1776, 1777, 1778, 1779, 1780, 1781, 1782, 1783, 1784, 1785, 1786, 1787, 1788, 1789, 1790, 1791, 1792, 1793, 1794, 1795, 1796, 1797, 1798, 1799, 1800, 1801, 1802, 1803, 1804, 1805, 1806, 1807, 1808, 1809, 1810, 1811, 1812, 1813, 1814, 1815, 1816, 1817, 1818, 1819, 1820, 1821, 1822, 1823, 1824, 1825, 1826, 1827, 1828, 1829, 1830, 1831, 1832, 1833, 1834, 1835, 1836, 1837, 1838, 1839, 1840, 1841, 1842, 1843, 1844, 1845, 1846, 1847, 1848, 1849, 1851, 1852, 1853, 1854, 1855, 1856, 1857, 1858, 1859, 1860, 1861, 1862, 1863, 1864, 1865, 1866, 1867, 1868, 1869, 1870, 1871, 1872, 1873, 1874, 1875, 1876, 1877, 1878, 1879, 1880, 1881, 1882, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1891, 1892, 1893, 1894, 1895, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1910, 1911, 1912, 1913, 1914, 1915, 1916, 1917, 1918, 1919, 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1944, 1945, 1946, 1947, 1948, 1949, 1950, 1951, 1952, 1953, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1961, 1962, 1963, 1964, 1965, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2017, 2018, 2019, 2021, 2022, 2024, 2025, 2026, 2027, 2028, 2029, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2037, 2038, 2039, 2040, 2041, 2042, 2043, 2044, 2046, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2068, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2080, 2081, 2082, 2083, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2148, 2149, 2150, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2199, 2200, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2264, 2265, 2266, 2267, 2268, 2269, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2281, 2282, 2283, 2284, 2286, 2287, 2288, 2289, 2290, 2291, 2292, 2293, 2294, 2295, 2296, 2297)) ORDER BY `xf_tl_group_post`.`post_date` DESC LIMIT 10
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`album_id` IN (11))
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.* FROM `xf_profile_post` USE INDEX (`post_date`) LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`) WHERE (`xf_profile_post`.`message_state` = 'visible') ORDER BY `xf_profile_post`.`post_date` DESC LIMIT 10
SELECT display_mode FROM xf_widget WHERE widget_id = ?
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` = 'profile_post') AND (`xf_attachment`.`content_id` = 649) ORDER BY `xf_attachment`.`attach_date` ASC
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 649) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
SELECT `xf_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 649) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
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` = 'profile_post') AND (`xf_attachment`.`content_id` = 646) ORDER BY `xf_attachment`.`attach_date` ASC
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 646) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
SELECT `xf_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 646) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.* FROM `xf_profile_post` USE INDEX (`post_date`) LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`) WHERE (`xf_profile_post`.`message_state` = 'visible') ORDER BY `xf_profile_post`.`post_date` DESC LIMIT 10
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dbtech_donate_drive`.*, `xf_dbtech_donate_currency_PrimaryCurrency_1`.*, `xf_dbtech_donate_donation_LastDonation_2`.*, `xf_permission_cache_content_Permissions_3`.* FROM `xf_dbtech_donate_drive` LEFT JOIN `xf_dbtech_donate_currency` AS `xf_dbtech_donate_currency_PrimaryCurrency_1` ON (`xf_dbtech_donate_currency_PrimaryCurrency_1`.`primary_currency` = 1) LEFT JOIN `xf_dbtech_donate_donation` AS `xf_dbtech_donate_donation_LastDonation_2` ON (`xf_dbtech_donate_donation_LastDonation_2`.`donation_id` = `xf_dbtech_donate_drive`.`last_donation_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'dbtech_donate_drive' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_dbtech_donate_drive`.`drive_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcGuestReact_reaction`.* FROM `xf_dcGuestReact_reaction` WHERE (`xf_dcGuestReact_reaction`.`user_id` = 0) LIMIT 1
SELECT `xf_dcMultisite_logout`.* FROM `xf_dcMultisite_logout` WHERE (`xf_dcMultisite_logout`.`user_id` = 0) LIMIT 1
SELECT `xf_dcSocialEncourage_encourage`.* FROM `xf_dcSocialEncourage_encourage` WHERE (`xf_dcSocialEncourage_encourage`.`url` = 'juvesocial.com/groups/4') LIMIT 1
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
SELECT `xf_dcUserName_user_name`.* FROM `xf_dcUserName_user_name` WHERE (`xf_dcUserName_user_name`.`is_active` = 1)
-- XFDB=noForceAllWrite INSERT INTO xf_session (session_id, session_data, expiry_date) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE session_data = VALUES(session_data), expiry_date = VALUES(expiry_date)
SELECT `xf_dcAutoFollow_auto_follow`.* FROM `xf_dcAutoFollow_auto_follow` WHERE (`xf_dcAutoFollow_auto_follow`.`url` = 'www.juvesocial.com/groups/4?_debug=1/') LIMIT 1
bytes_sent | 124682 |
bytes_received | 4779465 |
packets_sent | 2056 |
packets_received | 27450 |
protocol_overhead_in | 109800 |
protocol_overhead_out | 8224 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 5004 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 1756 |
bytes_received_prepare_response_packet | 1817614 |
bytes_received_change_user_packet | 2947835 |
packets_sent_command | 1027 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 556 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 344 |
packets_received_prepare_response | 20190 |
packets_received_change_user | 6016 |
result_set_queries | 339 |
non_result_set_queries | 5 |
no_index_used | 154 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 339 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 341 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 5677 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 5677 |
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 | 5677 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 3 |
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 | 20143 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 23806 |
proto_binary_fetched_int24 | 4805 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 119687 |
proto_binary_fetched_decimal | 1289 |
proto_binary_fetched_float | 2826 |
proto_binary_fetched_double | 3414 |
proto_binary_fetched_date | 3048 |
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 | 39437 |
proto_binary_fetched_blob | 30104 |
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 | 342 |
com_stmt_execute | 342 |
com_stmt_send_long_data | 0 |
com_stmt_close | 341 |
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 | 2811608 |