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 cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.* FROM `xf_forum` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | 240 | |||||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_forum.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,megasliv.xf_node_Node_1.node_id | 1 | Using where |
SELECT `xf_forum_prefix`.* FROM `xf_forum_prefix`
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum_prefix | index | prefix_id | 4 | 482 | Using index |
SELECT `xf_thread_prefix`.* FROM `xf_thread_prefix` ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix | ALL | 266 | Using filesort |
SELECT `xf_thread_prefix_group`.* FROM `xf_thread_prefix_group` ORDER BY `xf_thread_prefix_group`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_group | ALL | 27 | Using filesort |
SELECT `xf_node`.* FROM `xf_node` WHERE (`xf_node`.`display_in_list` = 1) ORDER BY `xf_node`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | ALL | display_in_list | 226 | Using where; Using filesort |
SELECT `xf_category`.*, `xf_node_Node_1`.* FROM `xf_category` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`) WHERE (`xf_category`.`node_id` IN (60, 105, 1, 17, 18, 165, 49, 147, 53, 264, 181, 280))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_category | ALL | 17 | Using where | ||||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_category.node_id | 1 |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*, `xf_user_LastPoster_4`.* FROM `xf_forum` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`) LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_forum`.`last_post_user_id`) WHERE (`xf_forum`.`node_id` IN (61, 62, 54, 109, 108, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 277, 156, 69, 3, 154, 4, 5, 7, 8, 9, 10, 12, 13, 58, 70, 73, 71, 104, 107, 80, 14, 78, 86, 87, 81, 75, 77, 11, 266, 15, 16, 57, 59, 74, 120, 20, 121, 122, 123, 124, 125, 126, 127, 128, 83, 84, 85, 82, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 28, 139, 141, 142, 143, 144, 140, 21, 22, 23, 24, 25, 26, 27, 29, 30, 31, 32, 33, 34, 35, 36, 37, 40, 46, 241, 247, 242, 246, 243, 244, 245, 47, 48, 43, 106, 38, 146, 41, 42, 145, 168, 173, 174, 167, 166, 169, 170, 171, 175, 176, 177, 178, 179, 180, 172, 50, 51, 52, 157, 153, 148, 149, 150, 151, 152, 155, 159, 160, 161, 158, 163, 162, 164, 55, 56, 63, 265, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 278, 279, 228, 229, 230, 206, 207, 208, 209, 210, 211, 216, 213, 214, 215, 234, 226, 197, 198, 199, 200, 201, 227, 238, 204, 236, 205, 183, 184, 185, 186, 235, 190, 191, 192, 193, 194, 202, 217, 218, 219, 220, 221, 222, 223, 224, 225, 188, 189, 248, 249, 250, 196, 237, 182, 203, 233, 254, 255, 256, 257, 260, 261, 258, 262, 259, 231, 253, 252, 263, 281, 39, 90, 91, 99, 45, 100, 101, 103))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | PRIMARY | 240 | Using where | |||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_forum.last_thread_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_forum.last_post_user_id | 1 |
SELECT content_id, cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 604 | Using where |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 |
-- XFDB=noForceAllWrite INSERT IGNORE INTO xf_session_activity ( ip, controller_name, controller_action, view_state, params, view_date, robot_key, user_id, unique_key ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 |
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 | 102 | const | 2 | Using where; Using temporary; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | ALL | PRIMARY | 1 | Using where; Using join buffer (hash join) | |||
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('nf_tickets_search_kb_articles', 'nf_tickets_search_tickets', 'search_threads')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | 3 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('mh_strip_visited_thread')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('xc_hide_bbcode_hidden_content')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('admin_navigation', 'admin_templates', 'attachments', 'bb_code_media_sites', 'captcha_questions', 'connected_account_providers', 'contacts', 'conversation_messages', 'cron_entries', 'dbtech_user_upgrade_coupons_long', 'email_templates', 'rss_feed_importers', 'graphs', 'lfs_sticked_link_purchases', 'liamw_macros_globalmacros', 'login_as_users', 'member_stats', 'navigation', 'nf_tickets_categories', 'nf_tickets_kb_articles', 'nf_tickets_messages', 'nf_tickets_tickets', 'nodes', 'notices', 'options', 'pages', 'payment_profiles', 'phrases', 'posts', 'profile_posts', 'profile_post_comments', 'public_templates', 'reports', 'siropu_ads_manager_ads', 'siropu_ads_manager_invs', 'style_properties', 'tags', 'thdonate_campaigns', 'thdonate_comments', 'thdonate_donations', 'threads', 'custom_thread_fields', 'thread_prefixes', 'thread_prompts', 'ticket_messages', 'trophies', 'users', 'custom_user_fields', 'user_groups', 'user_upgrades', 'username_changes', 'warnings', 'widgets', 'xfmg_albums', 'xfmg_comments', 'xfmg_medias')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | 56 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('contacts')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('graphs')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('lfs_sticked_link_purchases')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('login_as_users')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('siropu_ads_manager_invs')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('ticket_messages')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('xfmg_albums')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('xfmg_comments')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('xfmg_medias')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
bytes_sent | 19384 |
bytes_received | 2938654 |
packets_sent | 322 |
packets_received | 3374 |
protocol_overhead_in | 13496 |
protocol_overhead_out | 1288 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1017 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 293 |
bytes_received_prepare_response_packet | 87619 |
bytes_received_change_user_packet | 2848511 |
packets_sent_command | 160 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 113 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 55 |
packets_received_prepare_response | 1193 |
packets_received_change_user | 1958 |
result_set_queries | 52 |
non_result_set_queries | 3 |
no_index_used | 14 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 52 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 52 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 1906 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 1906 |
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 | 1906 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
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 | 2951 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 8767 |
proto_binary_fetched_int24 | 3250 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 29158 |
proto_binary_fetched_decimal | 61 |
proto_binary_fetched_float | 231 |
proto_binary_fetched_double | 1374 |
proto_binary_fetched_date | 26 |
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 | 14885 |
proto_binary_fetched_blob | 7939 |
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 | 53 |
com_stmt_execute | 53 |
com_stmt_send_long_data | 0 |
com_stmt_close | 52 |
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 | 2802032 |