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_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 | 479 | 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 | 793 | 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 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 > 1713485175 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 ('7', '8', '9', '10'))
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 | 4 | 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 (7, 8, 9, 10)) 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_feature_Featured_2 | index | PRIMARY | feature_date | 4 | 1 | Using index; Using temporary; Using filesort | |
| SIMPLE | xf_xa_ams_article | eq_ref | PRIMARY,category_publish_date,category_last_update,category_rating_weighted | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article_feature_Featured_2.article_id | 1 | Using where |
| 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 (7, 8, 9, 10)) AND ((`xf_xa_ams_article`.`article_state` IN ('visible'))) AND (`xf_xa_ams_article`.`category_id` IN ('7', '8', '9', '10'))
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 | range | category_publish_date,category_last_update,category_rating_weighted | category_publish_date | 4 | 4 | Using index condition; Using where; Using filesort | |
| 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 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article.category_id | 1 |
SELECT COUNT(*)
FROM `xf_xa_ams_article`
WHERE (`xf_xa_ams_article`.`category_id` IN (7, 8, 9, 10)) AND ((`xf_xa_ams_article`.`article_state` IN ('visible'))) AND (`xf_xa_ams_article`.`category_id` IN ('7', '8', '9', '10'))| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_article | range | category_publish_date,category_last_update,category_rating_weighted | category_publish_date | 4 | 4 | Using index condition; Using where |
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`, `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_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 | 46 | Using where |
SELECT `xf_xa_ams_comment`.*, `xf_xa_ams_article_Article_1`.*, `xf_user_User_2`.*, `xf_xa_ams_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.* FROM `xf_xa_ams_comment` LEFT JOIN `xf_xa_ams_article` AS `xf_xa_ams_article_Article_1` ON (`xf_xa_ams_article_Article_1`.`article_id` = `xf_xa_ams_comment`.`article_id`) LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_xa_ams_comment`.`user_id`) LEFT JOIN `xf_xa_ams_category` AS `xf_xa_ams_category_Category_3` ON (`xf_xa_ams_category_Category_3`.`category_id` = `xf_xa_ams_article_Article_1`.`category_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_xa_ams_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') WHERE (`xf_xa_ams_comment`.`comment_state` = 'visible') ORDER BY `xf_xa_ams_comment`.`comment_date` DESC, `xf_xa_ams_comment`.`comment_id` DESC LIMIT 50
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_comment | ALL | 9 | Using where; Using filesort | ||||
| SIMPLE | xf_xa_ams_article_Article_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_comment.article_id | 1 | |
| SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_comment.user_id | 1 | |
| SIMPLE | xf_xa_ams_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article_Article_1.category_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_xa_ams_category_Category_3.category_id | 1 | Using where |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 600) 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_widget`.* FROM `xf_widget` WHERE (`xf_widget`.`widget_id` = 24) 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_xa_ams_article`.*, `xf_user_User_1`.* 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`) WHERE (`xf_xa_ams_article`.`article_id` = 27) AND (`xf_xa_ams_article`.`url_final` <> '') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.* 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`) WHERE (`xf_xa_ams_article`.`article_id` = 24) AND (`xf_xa_ams_article`.`url_final` <> '') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.* 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`) WHERE (`xf_xa_ams_article`.`article_id` = 27) AND (`xf_xa_ams_article`.`url_final` <> '') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.* 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`) WHERE (`xf_xa_ams_article`.`article_id` = 28) AND (`xf_xa_ams_article`.`url_final` <> '') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.* 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`) WHERE (`xf_xa_ams_article`.`article_id` = 28) AND (`xf_xa_ams_article`.`url_final` <> '') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | 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 | 46 | Using where |
SELECT `xf_xa_ams_article_rating`.*, `xf_xa_ams_article_Article_1`.*, `xf_xa_ams_category_Category_2`.*, `xf_user_User_3`.*, `xf_user_AuthorResponseContributorUser_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_xa_ams_article_rating` INNER JOIN `xf_xa_ams_article` AS `xf_xa_ams_article_Article_1` ON (`xf_xa_ams_article_Article_1`.`article_id` = `xf_xa_ams_article_rating`.`article_id`) LEFT JOIN `xf_xa_ams_category` AS `xf_xa_ams_category_Category_2` ON (`xf_xa_ams_category_Category_2`.`category_id` = `xf_xa_ams_article_Article_1`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_xa_ams_article_rating`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_AuthorResponseContributorUser_4` ON (`xf_user_AuthorResponseContributorUser_4`.`user_id` = `xf_xa_ams_article_rating`.`author_response_contributor_user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_xa_ams_category_Category_2`.`category_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_xa_ams_article_Article_1`.`article_state` = 'visible' AND `xf_xa_ams_article_rating`.`rating_state` = 'visible' AND `xf_xa_ams_article_rating`.`is_review` = 1) AND (`xf_xa_ams_article_rating`.`rating_date` > 1705709175) ORDER BY `xf_xa_ams_article_rating`.`rating_date` DESC LIMIT 10
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_xa_ams_article_rating | range | article_id_rating_date,rating_date | rating_date | 4 | 1 | Using index condition; Using where; Backward index scan | |
| SIMPLE | xf_xa_ams_article_Article_1 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article_rating.article_id | 1 | Using where |
| SIMPLE | xf_xa_ams_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article_Article_1.category_id | 1 | |
| SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article_rating.user_id | 1 | |
| SIMPLE | xf_user_AuthorResponseContributorUser_4 | eq_ref | PRIMARY | PRIMARY | 4 | kairete_kairete.xf_xa_ams_article_rating.author_response_contributor_user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kairete_kairete.xf_xa_ams_category_Category_2.category_id | 1 | Using where |
SELECT `xf_widget`.* FROM `xf_widget` WHERE (`xf_widget`.`widget_id` = 25) 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 | 46 | 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 | 786 | |
| 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)) 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 | 1021 | 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 `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 | 46 | Using where |
SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_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 | 46 | 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_dcSocialEncourage_encourage`.* FROM `xf_dcSocialEncourage_encourage` WHERE (`xf_dcSocialEncourage_encourage`.`url` = 'juvesocial.com/ams') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_dcSocialEncourage_encourage | ALL | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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 | 46 | 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.juvesocial.com/ams/?_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 | 57540 |
| bytes_received | 3091424 |
| packets_sent | 826 |
| packets_received | 9926 |
| protocol_overhead_in | 39704 |
| protocol_overhead_out | 3304 |
| bytes_received_ok_packet | 0 |
| bytes_received_eof_packet | 0 |
| bytes_received_rset_header_packet | 2016 |
| bytes_received_rset_field_meta_packet | 0 |
| bytes_received_rset_row_packet | 731 |
| bytes_received_prepare_response_packet | 711522 |
| bytes_received_change_user_packet | 2374204 |
| packets_sent_command | 412 |
| packets_received_ok | 0 |
| packets_received_eof | 0 |
| packets_received_rset_header | 224 |
| packets_received_rset_field_meta | 0 |
| packets_received_rset_row | 139 |
| packets_received_prepare_response | 7527 |
| packets_received_change_user | 1897 |
| result_set_queries | 134 |
| non_result_set_queries | 5 |
| no_index_used | 58 |
| bad_index_used | 0 |
| slow_queries | 0 |
| buffered_sets | 0 |
| unbuffered_sets | 0 |
| ps_buffered_sets | 134 |
| ps_unbuffered_sets | 0 |
| flushed_normal_sets | 0 |
| flushed_ps_sets | 0 |
| ps_prepared_never_executed | 0 |
| ps_prepared_once_executed | 136 |
| rows_fetched_from_server_normal | 0 |
| rows_fetched_from_server_ps | 1763 |
| rows_buffered_from_client_normal | 0 |
| rows_buffered_from_client_ps | 1763 |
| 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 | 1763 |
| 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 | 17897 |
| proto_binary_fetched_tinyint | 0 |
| proto_binary_fetched_short | 15866 |
| proto_binary_fetched_int24 | 4108 |
| proto_binary_fetched_int | 0 |
| proto_binary_fetched_bigint | 90717 |
| proto_binary_fetched_decimal | 1020 |
| proto_binary_fetched_float | 2433 |
| proto_binary_fetched_double | 3240 |
| proto_binary_fetched_date | 2550 |
| 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 | 30283 |
| proto_binary_fetched_blob | 23255 |
| 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 | 137 |
| com_stmt_execute | 137 |
| com_stmt_send_long_data | 0 |
| com_stmt_close | 136 |
| 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 | 2283993 |