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', '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 | 38 | 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_thread`.*, `xf_user_User_1`.*, `xf_es_thread_similar_XFES_SimilarThreads_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_thread` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_es_thread_similar` AS `xf_es_thread_similar_XFES_SimilarThreads_2` ON (`xf_es_thread_similar_XFES_SimilarThreads_2`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` = '202274') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_es_thread_similar_XFES_SimilarThreads_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_post`.*, `xf_content_cache_ContentCache_1`.*, `xf_user_User_2`.*, `xf_user_option_Option_3`.*, `xf_user_profile_Profile_4`.*, `xf_user_privacy_Privacy_5`.*, `xf_permission_combination_PermissionCombination_6`.*, `xf_session_activity_Activity_7`.* FROM `xf_post` LEFT JOIN `xf_content_cache` AS `xf_content_cache_ContentCache_1` ON (`xf_content_cache_ContentCache_1`.`content_type` = 'post' AND `xf_content_cache_ContentCache_1`.`content_id` = `xf_post`.`post_id`) LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_post`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_2`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_4` ON (`xf_user_profile_Profile_4`.`user_id` = `xf_user_User_2`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_5` ON (`xf_user_privacy_Privacy_5`.`user_id` = `xf_user_User_2`.`user_id`) LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_6` ON (`xf_permission_combination_PermissionCombination_6`.`permission_combination_id` = `xf_user_User_2`.`permission_combination_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_7` ON (`xf_session_activity_Activity_7`.`user_id` = `xf_user_User_2`.`user_id` AND `xf_session_activity_Activity_7`.`unique_key` = CONCAT(`xf_user_User_2`.`user_id`, '')) WHERE (`xf_post`.`thread_id` = 202274) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 20) AND (`xf_post`.`position` < 40) ORDER BY `xf_post`.`sticky` DESC, `xf_post`.`position` ASC, `xf_post`.`post_date` ASC, `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | range | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_position | 8 | 18 | Using index condition; Using where; Using filesort | |
SIMPLE | xf_content_cache_ContentCache_1 | eq_ref | PRIMARY | PRIMARY | 31 | takerim_forum.xf_post.post_id,const | 1 | Using where |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_4 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_5 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.user_id | 1 | |
SIMPLE | xf_permission_combination_PermissionCombination_6 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.permission_combination_id | 1 | |
SIMPLE | xf_session_activity_Activity_7 | eq_ref | PRIMARY | PRIMARY | 22 | takerim_forum.xf_user_User_2.user_id,func | 1 | Using where |
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.* FROM `xf_attachment` LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`) WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (3415890)) 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 | takerim_forum.xf_attachment.data_id | 1 |
SELECT `xf_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`result_id` IN (18436207))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | const | PRIMARY | PRIMARY | 4 | const | 1 |
INSERT INTO xf_thread_view (thread_id, total) VALUES (? , 1) ON DUPLICATE KEY UPDATE total = total + 1
SELECT `xf_post`.*, `xf_content_cache_ContentCache_1`.*, `xf_user_User_2`.*, `xf_user_option_Option_3`.*, `xf_user_profile_Profile_4`.*, `xf_user_privacy_Privacy_5`.*, `xf_permission_combination_PermissionCombination_6`.*, `xf_session_activity_Activity_7`.* FROM `xf_post` LEFT JOIN `xf_content_cache` AS `xf_content_cache_ContentCache_1` ON (`xf_content_cache_ContentCache_1`.`content_type` = 'post' AND `xf_content_cache_ContentCache_1`.`content_id` = `xf_post`.`post_id`) LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_post`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_2`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_4` ON (`xf_user_profile_Profile_4`.`user_id` = `xf_user_User_2`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_5` ON (`xf_user_privacy_Privacy_5`.`user_id` = `xf_user_User_2`.`user_id`) LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_6` ON (`xf_permission_combination_PermissionCombination_6`.`permission_combination_id` = `xf_user_User_2`.`permission_combination_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_7` ON (`xf_session_activity_Activity_7`.`user_id` = `xf_user_User_2`.`user_id` AND `xf_session_activity_Activity_7`.`unique_key` = CONCAT(`xf_user_User_2`.`user_id`, '')) WHERE (`xf_post`.`thread_id` = 202274) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20) ORDER BY `xf_post`.`sticky` DESC, `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | range | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_position | 8 | 20 | Using index condition; Using where; Using filesort | |
SIMPLE | xf_content_cache_ContentCache_1 | eq_ref | PRIMARY | PRIMARY | 31 | takerim_forum.xf_post.post_id,const | 1 | Using where |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_4 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_5 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.user_id | 1 | |
SIMPLE | xf_permission_combination_PermissionCombination_6 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_user_User_2.permission_combination_id | 1 | |
SIMPLE | xf_session_activity_Activity_7 | eq_ref | PRIMARY | PRIMARY | 22 | takerim_forum.xf_user_User_2.user_id,func | 1 | Using where |
SELECT `xf_thread_prefix`.* FROM `xf_thread_prefix` WHERE (`xf_thread_prefix`.`prefix_id` IN (1, 7, 9, 5, 3, 4, 2)) ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix | range | PRIMARY | PRIMARY | 4 | 7 | Using where; Using filesort |
-- XFDB=noForceAllWrite INSERT INTO xf_session_activity (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date), robot_key = VALUES(robot_key)
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 | 77 | const | 1 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.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_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.* 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`) WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active') ORDER BY RAND() 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 | 77 | const | 1 | Using where; Using temporary; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | takerim_forum.xf_siropu_ads_manager_ad.package_id | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('seo_title_page_x')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`user_id` = 458327) AND (`xf_session_activity`.`unique_key` = '458327') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`url_hash` = 'c7929a3c3a6457c977a6caa2f7ff0854') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | const | url_hash | url_hash | 34 | const | 1 |
SELECT `xf_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`url_hash` = 'c7929a3c3a6457c977a6caa2f7ff0854') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | const | url_hash | url_hash | 34 | const | 1 |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('view_attachment_x')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT user.user_id, user.username, IF(user.username LIKE 'Hyperion6%', 1, 0) AS match_0, IF(user.username LIKE 'AMG65chats%', 1, 0) AS match_1, IF(user.username LIKE 'BETTINGMARKEET%', 1, 0) AS match_2, IF(user.username LIKE 'BesTIRCCHECKER%', 1, 0) AS match_3, IF(user.username LIKE 'BotSafeChat%', 1, 0) AS match_4, IF(user.username LIKE 'ChatDeepWeb%', 1, 0) AS match_5, IF(user.username LIKE 'KX\\_GOSTI%', 1, 0) AS match_6, IF(user.username LIKE 'Mom\\_CRD%', 1, 0) AS match_7, IF(user.username LIKE 'MoulinRougeChat%', 1, 0) AS match_8, IF(user.username LIKE 'NewEraWork%', 1, 0) AS match_9, IF(user.username LIKE 'OnionsChat%', 1, 0) AS match_10, IF(user.username LIKE 'PROGRESSOR\\_BA%', 1, 0) AS match_11, IF(user.username LIKE 'Prdx\\_yslugi%', 1, 0) AS match_12, IF(user.username LIKE 'Progressor\\_ba%', 1, 0) AS match_13, IF(user.username LIKE 'Refus\\_Cl%', 1, 0) AS match_14, IF(user.username LIKE 'StoreCRD%', 1, 0) AS match_15, IF(user.username LIKE 'TenevoiChatUslug%', 1, 0) AS match_16, IF(user.username LIKE 'Transitpage2%', 1, 0) AS match_17, IF(user.username LIKE 'UndetectableChat%', 1, 0) AS match_18, IF(user.username LIKE 'adskiy\\_facebook%', 1, 0) AS match_19, IF(user.username LIKE 'airbnbxflightservice%', 1, 0) AS match_20, IF(user.username LIKE 'atmenemychat%', 1, 0) AS match_21, IF(user.username LIKE 'banan\\_traff%', 1, 0) AS match_22, IF(user.username LIKE 'botlaunch\\_chat%', 1, 0) AS match_23, IF(user.username LIKE 'bytes\\_hub%', 1, 0) AS match_24, IF(user.username LIKE 'capri\\_cashout\\_chat%', 1, 0) AS match_25, IF(user.username LIKE 'chat\\_337%', 1, 0) AS match_26, IF(user.username LIKE 'chat\\_dubai%', 1, 0) AS match_27, IF(user.username LIKE 'chenxiq%', 1, 0) AS match_28, IF(user.username LIKE 'codeby\\_one%', 1, 0) AS match_29, IF(user.username LIKE 'crypto\\_proxy%', 1, 0) AS match_30, IF(user.username LIKE 'cvv22cc%', 1, 0) AS match_31, IF(user.username LIKE 'cvv99C%', 1, 0) AS match_32, IF(user.username LIKE 'cyprus\\_f0rum%', 1, 0) AS match_33, IF(user.username LIKE 'deenfx12%', 1, 0) AS match_34, IF(user.username LIKE 'devilplacenet\\_chat%', 1, 0) AS match_35, IF(user.username LIKE 'diplomat\\_obnal\\_ua%', 1, 0) AS match_36, IF(user.username LIKE 'el\\_dorado\\_team%', 1, 0) AS match_37, IF(user.username LIKE 'facebook\\_mobile%', 1, 0) AS match_38, IF(user.username LIKE 'freelogs2%', 1, 0) AS match_39, IF(user.username LIKE 'fwmoneyman\\_work%', 1, 0) AS match_40, IF(user.username LIKE 'galaxy\\_platforms%', 1, 0) AS match_41, IF(user.username LIKE 'godelesscloudlogs%', 1, 0) AS match_42, IF(user.username LIKE 'google\\_ads\\_pb%', 1, 0) AS match_43, IF(user.username LIKE 'googlepbgold%', 1, 0) AS match_44, IF(user.username LIKE 'gummybearsnumberone%', 1, 0) AS match_45, IF(user.username LIKE 'invest\\_lid%', 1, 0) AS match_46, IF(user.username LIKE 'irsbadpanda%', 1, 0) AS match_47, IF(user.username LIKE 'j1ked%', 1, 0) AS match_48, IF(user.username LIKE 'j\\_comm%', 1, 0) AS match_49, IF(user.username LIKE 'kaitelintop2%', 1, 0) AS match_50, IF(user.username LIKE 'kaloyru%', 1, 0) AS match_51, IF(user.username LIKE 'luxury\\_public\\_group%', 1, 0) AS match_52, IF(user.username LIKE 'mobile\\_proxy\\_private%', 1, 0) AS match_53, IF(user.username LIKE 'morrischatgroup%', 1, 0) AS match_54, IF(user.username LIKE 'moshushiq%', 1, 0) AS match_55, IF(user.username LIKE 'mostwantedchats%', 1, 0) AS match_56, IF(user.username LIKE 'neglupov\\_chat%', 1, 0) AS match_57, IF(user.username LIKE 'netwoyneukrruss%', 1, 0) AS match_58, IF(user.username LIKE 'ppteamof%', 1, 0) AS match_59, IF(user.username LIKE 'radiogubiteli%', 1, 0) AS match_60, IF(user.username LIKE 'ru\\_hackrf%', 1, 0) AS match_61, IF(user.username LIKE 'shared\\_proxy%', 1, 0) AS match_62, IF(user.username LIKE 'sharkchat1%', 1, 0) AS match_63, IF(user.username LIKE 'skamilmamonta%', 1, 0) AS match_64, IF(user.username LIKE 'sofawinschat%', 1, 0) AS match_65, IF(user.username LIKE 'uaproxy4g%', 1, 0) AS match_66, IF(user.username LIKE 'ukrmobproxy%', 1, 0) AS match_67, IF(user.username LIKE 'vegatele777%', 1, 0) AS match_68, IF(user.username LIKE 'willyw\\_chat%', 1, 0) AS match_69, IF(user.username LIKE 'zapabotok12%', 1, 0) AS match_70, IF(user.username LIKE 'AMG65chats%', 1, 0) AS match_71, IF(user.username LIKE 'BETTINGMARKEET%', 1, 0) AS match_72, IF(user.username LIKE 'BesTIRCCHECKER%', 1, 0) AS match_73, IF(user.username LIKE 'BotSafeChat%', 1, 0) AS match_74, IF(user.username LIKE 'ChatDeepWeb%', 1, 0) AS match_75, IF(user.username LIKE 'KX\\_GOSTI%', 1, 0) AS match_76, IF(user.username LIKE 'Mom\\_CRD%', 1, 0) AS match_77, IF(user.username LIKE 'MoulinRougeChat%', 1, 0) AS match_78, IF(user.username LIKE 'NewEraWork%', 1, 0) AS match_79, IF(user.username LIKE 'OnionsChat%', 1, 0) AS match_80, IF(user.username LIKE 'PROGRESSOR\\_BA%', 1, 0) AS match_81, IF(user.username LIKE 'Prdx\\_yslugi%', 1, 0) AS match_82, IF(user.username LIKE 'Progressor\\_ba%', 1, 0) AS match_83, IF(user.username LIKE 'Refus\\_Cl%', 1, 0) AS match_84, IF(user.username LIKE 'StoreCRD%', 1, 0) AS match_85, IF(user.username LIKE 'TenevoiChatUslug%', 1, 0) AS match_86, IF(user.username LIKE 'Transitpage2%', 1, 0) AS match_87, IF(user.username LIKE 'UndetectableChat%', 1, 0) AS match_88, IF(user.username LIKE 'adskiy\\_facebook%', 1, 0) AS match_89, IF(user.username LIKE 'airbnbxflightservice%', 1, 0) AS match_90, IF(user.username LIKE 'atmenemychat%', 1, 0) AS match_91, IF(user.username LIKE 'banan\\_traff%', 1, 0) AS match_92, IF(user.username LIKE 'botlaunch\\_chat%', 1, 0) AS match_93, IF(user.username LIKE 'bytes\\_hub%', 1, 0) AS match_94, IF(user.username LIKE 'capri\\_cashout\\_chat%', 1, 0) AS match_95, IF(user.username LIKE 'chat\\_337%', 1, 0) AS match_96, IF(user.username LIKE 'chat\\_dubai%', 1, 0) AS match_97, IF(user.username LIKE 'chenxiq%', 1, 0) AS match_98, IF(user.username LIKE 'codeby\\_one%', 1, 0) AS match_99, IF(user.username LIKE 'crypto\\_proxy%', 1, 0) AS match_100, IF(user.username LIKE 'cvv22cc%', 1, 0) AS match_101, IF(user.username LIKE 'cvv99C%', 1, 0) AS match_102, IF(user.username LIKE 'cyprus\\_f0rum%', 1, 0) AS match_103, IF(user.username LIKE 'deenfx12%', 1, 0) AS match_104, IF(user.username LIKE 'devilplacenet\\_chat%', 1, 0) AS match_105, IF(user.username LIKE 'diplomat\\_obnal\\_ua%', 1, 0) AS match_106, IF(user.username LIKE 'el\\_dorado\\_team%', 1, 0) AS match_107, IF(user.username LIKE 'facebook\\_mobile%', 1, 0) AS match_108, IF(user.username LIKE 'freelogs2%', 1, 0) AS match_109, IF(user.username LIKE 'fwmoneyman\\_work%', 1, 0) AS match_110, IF(user.username LIKE 'galaxy\\_platforms%', 1, 0) AS match_111, IF(user.username LIKE 'godelesscloudlogs%', 1, 0) AS match_112, IF(user.username LIKE 'google\\_ads\\_pb%', 1, 0) AS match_113, IF(user.username LIKE 'googlepbgold%', 1, 0) AS match_114, IF(user.username LIKE 'gummybearsnumberone%', 1, 0) AS match_115, IF(user.username LIKE 'invest\\_lid%', 1, 0) AS match_116, IF(user.username LIKE 'irsbadpanda%', 1, 0) AS match_117, IF(user.username LIKE 'j1ked%', 1, 0) AS match_118, IF(user.username LIKE 'j\\_comm%', 1, 0) AS match_119, IF(user.username LIKE 'kaitelintop2%', 1, 0) AS match_120, IF(user.username LIKE 'kaloyru%', 1, 0) AS match_121, IF(user.username LIKE 'luxury\\_public\\_group%', 1, 0) AS match_122, IF(user.username LIKE 'mobile\\_proxy\\_private%', 1, 0) AS match_123, IF(user.username LIKE 'morrischatgroup%', 1, 0) AS match_124, IF(user.username LIKE 'moshushiq%', 1, 0) AS match_125, IF(user.username LIKE 'mostwantedchats%', 1, 0) AS match_126, IF(user.username LIKE 'neglupov\\_chat%', 1, 0) AS match_127, IF(user.username LIKE 'netwoyneukrruss%', 1, 0) AS match_128, IF(user.username LIKE 'ppteamof%', 1, 0) AS match_129, IF(user.username LIKE 'radiogubiteli%', 1, 0) AS match_130, IF(user.username LIKE 'ru\\_hackrf%', 1, 0) AS match_131, IF(user.username LIKE 'shared\\_proxy%', 1, 0) AS match_132, IF(user.username LIKE 'sharkchat1%', 1, 0) AS match_133, IF(user.username LIKE 'skamilmamonta%', 1, 0) AS match_134, IF(user.username LIKE 'sofawinschat%', 1, 0) AS match_135, IF(user.username LIKE 'uaproxy4g%', 1, 0) AS match_136, IF(user.username LIKE 'ukrmobproxy%', 1, 0) AS match_137, IF(user.username LIKE 'vegatele777%', 1, 0) AS match_138, IF(user.username LIKE 'willyw\\_chat%', 1, 0) AS match_139, IF(user.username LIKE 'zapabotok12%', 1, 0) AS match_140, IF(user.username LIKE 'TreasureHunter108%', 1, 0) AS match_141, IF(user.username LIKE 'AnyDataBase%', 1, 0) AS match_142, IF(user.username LIKE 'BesTIRCCHECKER%', 1, 0) AS match_143, IF(user.username LIKE 'Business\\_Facebook%', 1, 0) AS match_144, IF(user.username LIKE 'Mom\\_CRD%', 1, 0) AS match_145, IF(user.username LIKE 'ToxicKings\\_chat%', 1, 0) AS match_146, IF(user.username LIKE 'adskiy\\_arbitraj%', 1, 0) AS match_147, IF(user.username LIKE 'billi\\_willy%', 1, 0) AS match_148, IF(user.username LIKE 'cpa\\_podslushano%', 1, 0) AS match_149, IF(user.username LIKE 'djonytop%', 1, 0) AS match_150, IF(user.username LIKE 'eztraffic1%', 1, 0) AS match_151, IF(user.username LIKE 'fabrikafirm000%', 1, 0) AS match_152, IF(user.username LIKE 'fathers\\_of\\_traffic%', 1, 0) AS match_153, IF(user.username LIKE 'forex\\_affiIiat%', 1, 0) AS match_154, IF(user.username LIKE 'gamblingbychuck%', 1, 0) AS match_155, IF(user.username LIKE 'google\\_fb\\_arbitash%', 1, 0) AS match_156, IF(user.username LIKE 'googleloxyandextoje%', 1, 0) AS match_157, IF(user.username LIKE 'googlepbgold%', 1, 0) AS match_158, IF(user.username LIKE 'monday\\_chat%', 1, 0) AS match_159, IF(user.username LIKE 'monday\\_fb\\_chat%', 1, 0) AS match_160, IF(user.username LIKE 'monday\\_uslugi%', 1, 0) AS match_161, IF(user.username LIKE 'myadnote%', 1, 0) AS match_162, IF(user.username LIKE 'neglupov\\_chat%', 1, 0) AS match_163, IF(user.username LIKE 'octobrowser\\_chat%', 1, 0) AS match_164, IF(user.username LIKE 'pirate\\_cpa%', 1, 0) AS match_165, IF(user.username LIKE 'real\\_traffic%', 1, 0) AS match_166, IF(user.username LIKE 'ru\\_hackrf%', 1, 0) AS match_167, IF(user.username LIKE 'tgconversionru%', 1, 0) AS match_168 FROM xf_user AS user WHERE (user.username LIKE 'Hyperion6%' OR user.username LIKE 'AMG65chats%' OR user.username LIKE 'BETTINGMARKEET%' OR user.username LIKE 'BesTIRCCHECKER%' OR user.username LIKE 'BotSafeChat%' OR user.username LIKE 'ChatDeepWeb%' OR user.username LIKE 'KX\\_GOSTI%' OR user.username LIKE 'Mom\\_CRD%' OR user.username LIKE 'MoulinRougeChat%' OR user.username LIKE 'NewEraWork%' OR user.username LIKE 'OnionsChat%' OR user.username LIKE 'PROGRESSOR\\_BA%' OR user.username LIKE 'Prdx\\_yslugi%' OR user.username LIKE 'Progressor\\_ba%' OR user.username LIKE 'Refus\\_Cl%' OR user.username LIKE 'StoreCRD%' OR user.username LIKE 'TenevoiChatUslug%' OR user.username LIKE 'Transitpage2%' OR user.username LIKE 'UndetectableChat%' OR user.username LIKE 'adskiy\\_facebook%' OR user.username LIKE 'airbnbxflightservice%' OR user.username LIKE 'atmenemychat%' OR user.username LIKE 'banan\\_traff%' OR user.username LIKE 'botlaunch\\_chat%' OR user.username LIKE 'bytes\\_hub%' OR user.username LIKE 'capri\\_cashout\\_chat%' OR user.username LIKE 'chat\\_337%' OR user.username LIKE 'chat\\_dubai%' OR user.username LIKE 'chenxiq%' OR user.username LIKE 'codeby\\_one%' OR user.username LIKE 'crypto\\_proxy%' OR user.username LIKE 'cvv22cc%' OR user.username LIKE 'cvv99C%' OR user.username LIKE 'cyprus\\_f0rum%' OR user.username LIKE 'deenfx12%' OR user.username LIKE 'devilplacenet\\_chat%' OR user.username LIKE 'diplomat\\_obnal\\_ua%' OR user.username LIKE 'el\\_dorado\\_team%' OR user.username LIKE 'facebook\\_mobile%' OR user.username LIKE 'freelogs2%' OR user.username LIKE 'fwmoneyman\\_work%' OR user.username LIKE 'galaxy\\_platforms%' OR user.username LIKE 'godelesscloudlogs%' OR user.username LIKE 'google\\_ads\\_pb%' OR user.username LIKE 'googlepbgold%' OR user.username LIKE 'gummybearsnumberone%' OR user.username LIKE 'invest\\_lid%' OR user.username LIKE 'irsbadpanda%' OR user.username LIKE 'j1ked%' OR user.username LIKE 'j\\_comm%' OR user.username LIKE 'kaitelintop2%' OR user.username LIKE 'kaloyru%' OR user.username LIKE 'luxury\\_public\\_group%' OR user.username LIKE 'mobile\\_proxy\\_private%' OR user.username LIKE 'morrischatgroup%' OR user.username LIKE 'moshushiq%' OR user.username LIKE 'mostwantedchats%' OR user.username LIKE 'neglupov\\_chat%' OR user.username LIKE 'netwoyneukrruss%' OR user.username LIKE 'ppteamof%' OR user.username LIKE 'radiogubiteli%' OR user.username LIKE 'ru\\_hackrf%' OR user.username LIKE 'shared\\_proxy%' OR user.username LIKE 'sharkchat1%' OR user.username LIKE 'skamilmamonta%' OR user.username LIKE 'sofawinschat%' OR user.username LIKE 'uaproxy4g%' OR user.username LIKE 'ukrmobproxy%' OR user.username LIKE 'vegatele777%' OR user.username LIKE 'willyw\\_chat%' OR user.username LIKE 'zapabotok12%' OR user.username LIKE 'AMG65chats%' OR user.username LIKE 'BETTINGMARKEET%' OR user.username LIKE 'BesTIRCCHECKER%' OR user.username LIKE 'BotSafeChat%' OR user.username LIKE 'ChatDeepWeb%' OR user.username LIKE 'KX\\_GOSTI%' OR user.username LIKE 'Mom\\_CRD%' OR user.username LIKE 'MoulinRougeChat%' OR user.username LIKE 'NewEraWork%' OR user.username LIKE 'OnionsChat%' OR user.username LIKE 'PROGRESSOR\\_BA%' OR user.username LIKE 'Prdx\\_yslugi%' OR user.username LIKE 'Progressor\\_ba%' OR user.username LIKE 'Refus\\_Cl%' OR user.username LIKE 'StoreCRD%' OR user.username LIKE 'TenevoiChatUslug%' OR user.username LIKE 'Transitpage2%' OR user.username LIKE 'UndetectableChat%' OR user.username LIKE 'adskiy\\_facebook%' OR user.username LIKE 'airbnbxflightservice%' OR user.username LIKE 'atmenemychat%' OR user.username LIKE 'banan\\_traff%' OR user.username LIKE 'botlaunch\\_chat%' OR user.username LIKE 'bytes\\_hub%' OR user.username LIKE 'capri\\_cashout\\_chat%' OR user.username LIKE 'chat\\_337%' OR user.username LIKE 'chat\\_dubai%' OR user.username LIKE 'chenxiq%' OR user.username LIKE 'codeby\\_one%' OR user.username LIKE 'crypto\\_proxy%' OR user.username LIKE 'cvv22cc%' OR user.username LIKE 'cvv99C%' OR user.username LIKE 'cyprus\\_f0rum%' OR user.username LIKE 'deenfx12%' OR user.username LIKE 'devilplacenet\\_chat%' OR user.username LIKE 'diplomat\\_obnal\\_ua%' OR user.username LIKE 'el\\_dorado\\_team%' OR user.username LIKE 'facebook\\_mobile%' OR user.username LIKE 'freelogs2%' OR user.username LIKE 'fwmoneyman\\_work%' OR user.username LIKE 'galaxy\\_platforms%' OR user.username LIKE 'godelesscloudlogs%' OR user.username LIKE 'google\\_ads\\_pb%' OR user.username LIKE 'googlepbgold%' OR user.username LIKE 'gummybearsnumberone%' OR user.username LIKE 'invest\\_lid%' OR user.username LIKE 'irsbadpanda%' OR user.username LIKE 'j1ked%' OR user.username LIKE 'j\\_comm%' OR user.username LIKE 'kaitelintop2%' OR user.username LIKE 'kaloyru%' OR user.username LIKE 'luxury\\_public\\_group%' OR user.username LIKE 'mobile\\_proxy\\_private%' OR user.username LIKE 'morrischatgroup%' OR user.username LIKE 'moshushiq%' OR user.username LIKE 'mostwantedchats%' OR user.username LIKE 'neglupov\\_chat%' OR user.username LIKE 'netwoyneukrruss%' OR user.username LIKE 'ppteamof%' OR user.username LIKE 'radiogubiteli%' OR user.username LIKE 'ru\\_hackrf%' OR user.username LIKE 'shared\\_proxy%' OR user.username LIKE 'sharkchat1%' OR user.username LIKE 'skamilmamonta%' OR user.username LIKE 'sofawinschat%' OR user.username LIKE 'uaproxy4g%' OR user.username LIKE 'ukrmobproxy%' OR user.username LIKE 'vegatele777%' OR user.username LIKE 'willyw\\_chat%' OR user.username LIKE 'zapabotok12%' OR user.username LIKE 'TreasureHunter108%' OR user.username LIKE 'AnyDataBase%' OR user.username LIKE 'BesTIRCCHECKER%' OR user.username LIKE 'Business\\_Facebook%' OR user.username LIKE 'Mom\\_CRD%' OR user.username LIKE 'ToxicKings\\_chat%' OR user.username LIKE 'adskiy\\_arbitraj%' OR user.username LIKE 'billi\\_willy%' OR user.username LIKE 'cpa\\_podslushano%' OR user.username LIKE 'djonytop%' OR user.username LIKE 'eztraffic1%' OR user.username LIKE 'fabrikafirm000%' OR user.username LIKE 'fathers\\_of\\_traffic%' OR user.username LIKE 'forex\\_affiIiat%' OR user.username LIKE 'gamblingbychuck%' OR user.username LIKE 'google\\_fb\\_arbitash%' OR user.username LIKE 'googleloxyandextoje%' OR user.username LIKE 'googlepbgold%' OR user.username LIKE 'monday\\_chat%' OR user.username LIKE 'monday\\_fb\\_chat%' OR user.username LIKE 'monday\\_uslugi%' OR user.username LIKE 'myadnote%' OR user.username LIKE 'neglupov\\_chat%' OR user.username LIKE 'octobrowser\\_chat%' OR user.username LIKE 'pirate\\_cpa%' OR user.username LIKE 'real\\_traffic%' OR user.username LIKE 'ru\\_hackrf%' OR user.username LIKE 'tgconversionru%') ORDER BY LENGTH(user.username) DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | range | username | username | 152 | 93 | Using where; Using index; Using filesort |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT `xf_bb_code_media_site`.* FROM `xf_bb_code_media_site` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code_media_site`.`addon_id`) WHERE (`xf_bb_code_media_site`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code_media_site`.`addon_id` = '')) ORDER BY `xf_bb_code_media_site`.`media_site_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bb_code_media_site | index | PRIMARY | 27 | 18 | Using where | ||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | takerim_forum.xf_bb_code_media_site.addon_id | 1 | Using where |
SELECT user.user_id, user.username, IF(user.username LIKE 'pavel\\_msk777%', 1, 0) AS match_0 FROM xf_user AS user WHERE (user.username LIKE 'pavel\\_msk777%') ORDER BY LENGTH(user.username) DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | range | username,staff_username | username | 152 | 1 | Using where; Using index; Using filesort |
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.* FROM `xf_thread` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`) WHERE (`xf_thread`.`thread_id` IN (155263)) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') ORDER BY `xf_thread`.`thread_id` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | xf_user_LastPoster_5 | const | PRIMARY | PRIMARY | 4 | const | 1 |
bytes_sent | 71492 |
bytes_received | 975991 |
packets_sent | 450 |
packets_received | 3601 |
protocol_overhead_in | 14404 |
protocol_overhead_out | 1800 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1044 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 404 |
bytes_received_prepare_response_packet | 245630 |
bytes_received_change_user_packet | 727223 |
packets_sent_command | 223 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 116 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 76 |
packets_received_prepare_response | 2976 |
packets_received_change_user | 355 |
result_set_queries | 72 |
non_result_set_queries | 4 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 72 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 73 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 283 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 283 |
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 | 283 |
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 | 607 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1347 |
proto_binary_fetched_int24 | 285 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2235 |
proto_binary_fetched_decimal | 164 |
proto_binary_fetched_float | 1 |
proto_binary_fetched_double | 2 |
proto_binary_fetched_date | 81 |
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 | 2612 |
proto_binary_fetched_blob | 861 |
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 | 74 |
com_stmt_execute | 74 |
com_stmt_send_long_data | 0 |
com_stmt_close | 73 |
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 | 720482 |