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 | 783 | 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_xa_ams_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_xa_ams_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_ams_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') WHERE (`xf_xa_ams_category`.`category_id` = '12') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
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 > 1715730168 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_xa_ams_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_xa_ams_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_ams_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') WHERE (`xf_xa_ams_category`.`category_id` IN ('2', '6', '11', '12', '3', '14', '13', '4', '5')) ORDER BY `xf_xa_ams_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_category | range | PRIMARY | PRIMARY | 4 | 9 | Using where; Using filesort | |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_xa_ams_category.category_id | 1 | Using where |
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.*, `xf_xa_ams_article_feature_Featured_2`.*, `xf_attachment_CoverImage_3`.*, `xf_attachment_data_Data_4`.* FROM `xf_xa_ams_article` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_ams_article`.`user_id`) INNER JOIN `xf_xa_ams_article_feature` AS `xf_xa_ams_article_feature_Featured_2` ON (`xf_xa_ams_article_feature_Featured_2`.`article_id` = `xf_xa_ams_article`.`article_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_CoverImage_3` ON (`xf_attachment_CoverImage_3`.`content_type` = 'ams_article' AND `xf_attachment_CoverImage_3`.`content_id` = `xf_xa_ams_article`.`article_id` AND `xf_attachment_CoverImage_3`.`attachment_id` = `xf_xa_ams_article`.`cover_image_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_4` ON (`xf_attachment_data_Data_4`.`data_id` = `xf_attachment_CoverImage_3`.`data_id`) WHERE (`xf_xa_ams_article`.`category_id` IN (12)) AND (`xf_xa_ams_article`.`article_state` = 'visible') ORDER BY RAND() ASC LIMIT 5
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_article | ref | PRIMARY,category_publish_date,category_last_update,category_rating_weighted | category_publish_date | 4 | const | 1 | Using where; Using temporary; Using filesort |
SIMPLE | xf_xa_ams_article_feature_Featured_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.article_id | 1 | |
SIMPLE | xf_attachment_CoverImage_3 | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.cover_image_id | 1 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.user_id | 1 | |
SIMPLE | xf_attachment_data_Data_4 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_CoverImage_3.data_id | 1 |
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.*, `xf_xa_ams_article_feature_Featured_2`.*, `xf_attachment_CoverImage_3`.*, `xf_attachment_data_Data_4`.*, `xf_xa_ams_category_Category_5`.* FROM `xf_xa_ams_article` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_ams_article`.`user_id`) LEFT JOIN `xf_xa_ams_article_feature` AS `xf_xa_ams_article_feature_Featured_2` ON (`xf_xa_ams_article_feature_Featured_2`.`article_id` = `xf_xa_ams_article`.`article_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_CoverImage_3` ON (`xf_attachment_CoverImage_3`.`content_type` = 'ams_article' AND `xf_attachment_CoverImage_3`.`content_id` = `xf_xa_ams_article`.`article_id` AND `xf_attachment_CoverImage_3`.`attachment_id` = `xf_xa_ams_article`.`cover_image_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_4` ON (`xf_attachment_data_Data_4`.`data_id` = `xf_attachment_CoverImage_3`.`data_id`) LEFT JOIN `xf_xa_ams_category` AS `xf_xa_ams_category_Category_5` ON (`xf_xa_ams_category_Category_5`.`category_id` = `xf_xa_ams_article`.`category_id`) WHERE (`xf_xa_ams_article`.`category_id` IN (12)) AND ((`xf_xa_ams_article`.`article_state` IN ('visible'))) AND (`xf_xa_ams_article`.`category_id` IN ('2', '6', '11', '12', '3', '14', '13', '4', '5')) AND (`xf_xa_ams_article`.`sticky` = 1) AND (`xf_xa_ams_article`.`category_id` = 12) ORDER BY `xf_xa_ams_article`.`publish_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_article | ref | category_publish_date,category_last_update,category_rating_weighted | category_publish_date | 4 | const | 1 | Using where; Backward index scan |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.user_id | 1 | |
SIMPLE | xf_xa_ams_article_feature_Featured_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.article_id | 1 | |
SIMPLE | xf_attachment_CoverImage_3 | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.cover_image_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_4 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_CoverImage_3.data_id | 1 | |
SIMPLE | xf_xa_ams_category_Category_5 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.*, `xf_xa_ams_article_feature_Featured_2`.*, `xf_attachment_CoverImage_3`.*, `xf_attachment_data_Data_4`.*, `xf_xa_ams_category_Category_5`.* FROM `xf_xa_ams_article` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_ams_article`.`user_id`) LEFT JOIN `xf_xa_ams_article_feature` AS `xf_xa_ams_article_feature_Featured_2` ON (`xf_xa_ams_article_feature_Featured_2`.`article_id` = `xf_xa_ams_article`.`article_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_CoverImage_3` ON (`xf_attachment_CoverImage_3`.`content_type` = 'ams_article' AND `xf_attachment_CoverImage_3`.`content_id` = `xf_xa_ams_article`.`article_id` AND `xf_attachment_CoverImage_3`.`attachment_id` = `xf_xa_ams_article`.`cover_image_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_4` ON (`xf_attachment_data_Data_4`.`data_id` = `xf_attachment_CoverImage_3`.`data_id`) LEFT JOIN `xf_xa_ams_category` AS `xf_xa_ams_category_Category_5` ON (`xf_xa_ams_category_Category_5`.`category_id` = `xf_xa_ams_article`.`category_id`) WHERE (`xf_xa_ams_article`.`category_id` IN (12)) AND ((`xf_xa_ams_article`.`article_state` IN ('visible'))) AND (`xf_xa_ams_article`.`category_id` IN ('2', '6', '11', '12', '3', '14', '13', '4', '5')) AND (1) ORDER BY `xf_xa_ams_article`.`publish_date` DESC LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_article | ref | category_publish_date,category_last_update,category_rating_weighted | category_publish_date | 4 | const | 1 | Using where; Backward index scan |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.user_id | 1 | |
SIMPLE | xf_xa_ams_article_feature_Featured_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.article_id | 1 | |
SIMPLE | xf_attachment_CoverImage_3 | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.cover_image_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_4 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment_CoverImage_3.data_id | 1 | |
SIMPLE | xf_xa_ams_category_Category_5 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT COUNT(*) FROM `xf_xa_ams_article` WHERE (`xf_xa_ams_article`.`category_id` IN (12)) AND ((`xf_xa_ams_article`.`article_state` IN ('visible'))) AND (`xf_xa_ams_article`.`category_id` IN ('2', '6', '11', '12', '3', '14', '13', '4', '5')) AND (1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_article | ref | category_publish_date,category_last_update,category_rating_weighted | category_publish_date | 4 | const | 1 | Using where |
SELECT `xf_dcNewsAMSCategory_newsfeed_category`.* FROM `xf_dcNewsAMSCategory_newsfeed_category` WHERE (`xf_dcNewsAMSCategory_newsfeed_category`.`category_id` = 12) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcNewsAMSCategory_newsfeed_category | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_xa_ams_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_xa_ams_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_ams_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') WHERE (`xf_xa_ams_category`.`category_id` IN ('2', '6', '11', '12', '3', '14', '13', '4', '5')) ORDER BY `xf_xa_ams_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_category | range | PRIMARY | PRIMARY | 4 | 9 | Using where; Using filesort | |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_xa_ams_category.category_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_xa_ams_article_ArticleItem_1`.`category_id` IN (12))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_article_ArticleItem_1 | ref | PRIMARY,category_publish_date,category_last_update,category_rating_weighted | category_publish_date | 4 | const | 1 | Using index |
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3166 | Using where; Using join buffer (hash join) |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_MediaAlbum_1` ON (`xf_mg_album_MediaAlbum_1`.`album_id` = `xf_dcContentShare_newsfeed_item`.`content_id` AND `xf_dcContentShare_newsfeed_item`.`content_type` = 'xfmg_album') WHERE (`xf_mg_album_MediaAlbum_1`.`album_id` IN (10))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_album_MediaAlbum_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3166 | Using where |
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_mg_media_item_MediaItem_1`.`album_id` IN (10))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | ALL | 3166 | Using where | ||||
SIMPLE | xf_mg_media_item_MediaItem_1 | eq_ref | PRIMARY,album_id_media_date | PRIMARY | 4 | kairete_kairete.xf_dcContentShare_newsfeed_item.content_id | 1 | Using where |
SELECT `xf_xa_ams_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_xa_ams_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_ams_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') WHERE (`xf_xa_ams_category`.`category_id` IN ('2', '6', '11', '12', '3', '14', '13', '4', '5')) ORDER BY `xf_xa_ams_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ams_category | range | PRIMARY | PRIMARY | 4 | 9 | Using where; Using filesort | |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_xa_ams_category.category_id | 1 | Using where |
SELECT COUNT(*) FROM `xf_dcContentShare_newsfeed_item` WHERE (`xf_dcContentShare_newsfeed_item`.`item_id` IN (3042))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
SELECT `xf_dcContentShare_newsfeed_item`.* FROM `xf_dcContentShare_newsfeed_item` WHERE (`xf_dcContentShare_newsfeed_item`.`item_id` IN (3042)) ORDER BY `xf_dcContentShare_newsfeed_item`.`item_last_comment_date` DESC LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcContentShare_newsfeed_item | const | PRIMARY | PRIMARY | 4 | const | 1 |
-- 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_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` = 567) AND ('xfmg_media' = 'xfmg_media') 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` = 567) 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` = 567) 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` = 567) 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_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_xa_ubs_blog_entry`.*, `xf_user_User_1`.*, `xf_xa_ubs_category_Category_2`.*, `xf_permission_cache_content_Permissions_3`.* FROM `xf_xa_ubs_blog_entry` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_ubs_blog_entry`.`user_id`) LEFT JOIN `xf_xa_ubs_category` AS `xf_xa_ubs_category_Category_2` ON (`xf_xa_ubs_category_Category_2`.`category_id` = `xf_xa_ubs_blog_entry`.`category_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'ubs_category' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_xa_ubs_category_Category_2`.`category_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1') WHERE (`xf_xa_ubs_blog_entry`.`blog_entry_state` = 'visible') AND (`xf_xa_ubs_blog_entry`.`blog_id` IN (3)) ORDER BY `xf_xa_ubs_blog_entry`.`publish_date` DESC LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xa_ubs_blog_entry | index | publish_date | 4 | 10 | Using where; Backward index scan | ||
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ubs_blog_entry.user_id | 1 | |
SIMPLE | xf_xa_ubs_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ubs_blog_entry.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_xa_ubs_category_Category_2.category_id | 1 | Using where |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (`xf_widget`.`widget_id` = 100) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_mode FROM xf_widget WHERE widget_id = ?
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 `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 | 846 | |
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, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194)) 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 | 1019 | 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_widget`.* FROM `xf_widget` WHERE (`xf_widget`.`widget_id` = 84) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_mode FROM xf_widget WHERE widget_id = ?
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` = 1194) 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` = 1194) 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` = 1193) 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` = 1193) 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` = 1192) 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` = 1192) 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` = 1191) 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` = 1191) 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` = 1190) 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` = 1190) 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_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 Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | index | post_date | 4 | 10 | Using where; Backward index scan | ||
SIMPLE | xf_user_ProfileUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_profile_post.profile_user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_user_ProfileUser_1.user_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_profile_post.user_id | 1 |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (`xf_widget`.`widget_id` = 85) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_mode FROM xf_widget WHERE widget_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | const | PRIMARY | PRIMARY | 4 | 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_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 658) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 658) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 657) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 657) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 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` = 649) ORDER BY `xf_attachment`.`attach_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment.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_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 649) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 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 Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 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 Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_attachment.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_profile_post`.* FROM `xf_profile_post` WHERE (`xf_profile_post`.`profile_post_id` = 646) AND (`xf_profile_post`.`url_final` <> '') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 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 Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | 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 `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_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 Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dbtech_donate_drive | ALL | 1 | |||||
SIMPLE | xf_dbtech_donate_currency_PrimaryCurrency_1 | ALL | 5 | Using where; Using join buffer (hash join) | ||||
SIMPLE | xf_dbtech_donate_donation_LastDonation_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_dbtech_donate_drive.last_donation_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_dbtech_donate_drive.drive_id | 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_dcGuestReact_reaction`.* FROM `xf_dcGuestReact_reaction` WHERE (`xf_dcGuestReact_reaction`.`user_id` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcGuestReact_reaction | ref | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_dcMultisite_logout`.* FROM `xf_dcMultisite_logout` WHERE (`xf_dcMultisite_logout`.`user_id` = 0) 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_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_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 |
-- 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.lagrandeitalia.net/ams/categories/media.12/?_debug=1/') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dcAutoFollow_auto_follow | ALL | 6 | Using where |
bytes_sent | 97552 |
bytes_received | 3806942 |
packets_sent | 1174 |
packets_received | 16190 |
protocol_overhead_in | 64760 |
protocol_overhead_out | 4696 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 2799 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 1021 |
bytes_received_prepare_response_packet | 1233121 |
bytes_received_change_user_packet | 2565832 |
packets_sent_command | 586 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 311 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 197 |
packets_received_prepare_response | 13127 |
packets_received_change_user | 2358 |
result_set_queries | 192 |
non_result_set_queries | 5 |
no_index_used | 68 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 192 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 194 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 2166 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 2166 |
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 | 2166 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 2 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 19831 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 17745 |
proto_binary_fetched_int24 | 4552 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 99260 |
proto_binary_fetched_decimal | 1294 |
proto_binary_fetched_float | 2670 |
proto_binary_fetched_double | 3480 |
proto_binary_fetched_date | 2888 |
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 | 34111 |
proto_binary_fetched_blob | 25544 |
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 | 195 |
com_stmt_execute | 195 |
com_stmt_send_long_data | 0 |
com_stmt_close | 194 |
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 | 2464242 |