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 `ewr_medio_keywords`.* FROM `ewr_medio_keywords` WHERE ((`ewr_medio_keywords`.`keyword_id` IN ('39', '294')) OR (`ewr_medio_keywords`.`keyword_name` IN (''))) ORDER BY `ewr_medio_keywords`.`keyword_name` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_keywords | ALL | PRIMARY | 1467 | Using where; Using filesort |
SELECT COUNT(*) FROM `ewr_medio_media` LEFT JOIN `ewr_medio_categories` AS `ewr_medio_categories_Category_3` ON (`ewr_medio_categories_Category_3`.`category_id` = `ewr_medio_media`.`category_id`) WHERE ((`ewr_medio_categories_Category_3`.`category_groups` = '') OR (FIND_IN_SET(1, `ewr_medio_categories_Category_3`.`category_groups`))) AND (`ewr_medio_media`.`media_state` = 'visible') AND (ewr_medio_media.media_id IN ( SELECT media_id FROM ewr_medio_keylinks WHERE keyword_id = 39 )) AND (ewr_medio_media.media_id IN ( SELECT media_id FROM ewr_medio_keylinks WHERE keyword_id = 294 ))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_categories_Category_3 | ALL | PRIMARY | 3 | Using where | |||
SIMPLE | ewr_medio_media | ref | PRIMARY,category_id | category_id | 4 | rwm2_skyrimfo_xfro.ewr_medio_categories_Category_3.category_id | 183 | Using where |
SIMPLE | ewr_medio_keylinks | eq_ref | PRIMARY | PRIMARY | 8 | rwm2_skyrimfo_xfro.ewr_medio_media.media_id,const | 1 | Using index |
SIMPLE | ewr_medio_keylinks | eq_ref | PRIMARY | PRIMARY | 8 | rwm2_skyrimfo_xfro.ewr_medio_media.media_id,const | 1 | Using index |
SELECT `ewr_medio_media`.*, `xf_user_User_1`.*, `ewr_medio_services_Service_2`.* FROM `ewr_medio_media` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `ewr_medio_media`.`user_id`) LEFT JOIN `ewr_medio_services` AS `ewr_medio_services_Service_2` ON (`ewr_medio_services_Service_2`.`service_id` = `ewr_medio_media`.`service_id`) LEFT JOIN `ewr_medio_categories` AS `ewr_medio_categories_Category_3` ON (`ewr_medio_categories_Category_3`.`category_id` = `ewr_medio_media`.`category_id`) WHERE ((`ewr_medio_categories_Category_3`.`category_groups` = '') OR (FIND_IN_SET(1, `ewr_medio_categories_Category_3`.`category_groups`))) AND (`ewr_medio_media`.`media_state` = 'visible') AND (ewr_medio_media.media_id IN ( SELECT media_id FROM ewr_medio_keylinks WHERE keyword_id = 39 )) AND (ewr_medio_media.media_id IN ( SELECT media_id FROM ewr_medio_keylinks WHERE keyword_id = 294 )) ORDER BY `ewr_medio_media`.`media_views` DESC, `ewr_medio_media`.`media_date` DESC, `ewr_medio_media`.`media_id` DESC LIMIT 32
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_media | ALL | PRIMARY,category_id | 551 | Using where; Using temporary; Using filesort | |||
SIMPLE | ewr_medio_categories_Category_3 | ALL | PRIMARY | 3 | Using where; Using join buffer (hash join) | |||
SIMPLE | ewr_medio_keylinks | eq_ref | PRIMARY | PRIMARY | 8 | rwm2_skyrimfo_xfro.ewr_medio_media.media_id,const | 1 | Using index |
SIMPLE | ewr_medio_keylinks | eq_ref | PRIMARY | PRIMARY | 8 | rwm2_skyrimfo_xfro.ewr_medio_media.media_id,const | 1 | Using index |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | rwm2_skyrimfo_xfro.ewr_medio_media.user_id | 1 | |
SIMPLE | ewr_medio_services_Service_2 | eq_ref | PRIMARY | PRIMARY | 4 | rwm2_skyrimfo_xfro.ewr_medio_media.service_id | 1 |
SELECT `ewr_medio_categories`.* FROM `ewr_medio_categories` WHERE ((`ewr_medio_categories`.`category_groups` = '') OR (FIND_IN_SET(1, `ewr_medio_categories`.`category_groups`))) ORDER BY `ewr_medio_categories`.`category_left` ASC, `ewr_medio_categories`.`category_name` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_categories | ALL | 3 | Using where; Using filesort |
SELECT `ewr_medio_media`.*, `xf_user_User_1`.*, `ewr_medio_services_Service_2`.* FROM `ewr_medio_media` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `ewr_medio_media`.`user_id`) LEFT JOIN `ewr_medio_services` AS `ewr_medio_services_Service_2` ON (`ewr_medio_services_Service_2`.`service_id` = `ewr_medio_media`.`service_id`) LEFT JOIN `ewr_medio_categories` AS `ewr_medio_categories_Category_3` ON (`ewr_medio_categories_Category_3`.`category_id` = `ewr_medio_media`.`category_id`) WHERE ((`ewr_medio_categories_Category_3`.`category_groups` = '') OR (FIND_IN_SET(1, `ewr_medio_categories_Category_3`.`category_groups`))) AND (`ewr_medio_media`.`media_state` = 'visible') AND (ewr_medio_media.media_id IN ( SELECT media_id FROM ewr_medio_keylinks WHERE keyword_id = 39 )) AND (ewr_medio_media.media_id IN ( SELECT media_id FROM ewr_medio_keylinks WHERE keyword_id = 294 )) ORDER BY `ewr_medio_media`.`media_views` DESC, `ewr_medio_media`.`media_date` DESC, `ewr_medio_media`.`media_id` DESC LIMIT 32
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_media | ALL | PRIMARY,category_id | 551 | Using where; Using temporary; Using filesort | |||
SIMPLE | ewr_medio_categories_Category_3 | ALL | PRIMARY | 3 | Using where; Using join buffer (hash join) | |||
SIMPLE | ewr_medio_keylinks | eq_ref | PRIMARY | PRIMARY | 8 | rwm2_skyrimfo_xfro.ewr_medio_media.media_id,const | 1 | Using index |
SIMPLE | ewr_medio_keylinks | eq_ref | PRIMARY | PRIMARY | 8 | rwm2_skyrimfo_xfro.ewr_medio_media.media_id,const | 1 | Using index |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | rwm2_skyrimfo_xfro.ewr_medio_media.user_id | 1 | |
SIMPLE | ewr_medio_services_Service_2 | eq_ref | PRIMARY | PRIMARY | 4 | rwm2_skyrimfo_xfro.ewr_medio_media.service_id | 1 |
SELECT `ewr_medio_keylinks`.* FROM `ewr_medio_keylinks` WHERE (`ewr_medio_keylinks`.`media_id` IN (152, 64, 136, 146, 87, 130, 131, 124, 138, 114, 137, 128, 116, 117, 125, 127, 118))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_keylinks | range | PRIMARY | PRIMARY | 4 | 396 | Using where |
SELECT * FROM ( SELECT ewr_medio_keywords.*, COUNT(ewr_medio_keylinks.keyword_id) AS count FROM ewr_medio_keywords LEFT JOIN ewr_medio_keylinks ON (ewr_medio_keylinks.keyword_id = ewr_medio_keywords.keyword_id) WHERE ewr_medio_keywords.keyword_id IN (10, 11, 12, 26, 31, 39, 40, 47, 48, 69, 195, 272, 294, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 26, 39, 40, 48, 49, 83, 86, 103, 144, 173, 174, 195, 197, 230, 294, 495, 528, 529, 595, 601, 602, 603, 604, 605, 606, 607, 608, 609, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 9, 10, 11, 12, 26, 31, 38, 39, 40, 48, 69, 86, 92, 144, 160, 195, 237, 272, 294, 348, 406, 407, 480, 578, 594, 605, 663, 780, 838, 839, 840, 841, 842, 843, 844, 845, 846, 26, 38, 39, 40, 48, 69, 86, 119, 294, 348, 508, 663, 853, 854, 855, 26, 38, 39, 40, 48, 86, 119, 286, 294, 508, 749, 838, 853, 854, 856, 26, 38, 39, 40, 48, 69, 86, 119, 294, 508, 838, 853, 854, 857, 26, 38, 39, 40, 48, 58, 69, 86, 119, 144, 294, 348, 508, 663, 853, 854, 855, 26, 38, 39, 40, 48, 69, 74, 86, 119, 294, 508, 663, 838, 853, 854, 855, 26, 38, 39, 40, 48, 69, 86, 119, 294, 508, 663, 832, 838, 853, 854, 855, 26, 38, 39, 40, 48, 69, 86, 119, 294, 508, 663, 832, 838, 853, 854, 855, 871, 872, 26, 38, 39, 40, 48, 69, 86, 119, 294, 348, 508, 577, 663, 838, 853, 854, 855, 871, 880, 881, 9, 26, 38, 39, 40, 48, 69, 86, 119, 197, 294, 348, 508, 577, 663, 814, 838, 853, 854, 855, 882, 883, 884, 885, 886, 887, 888, 889, 9, 26, 38, 39, 40, 48, 69, 86, 119, 197, 294, 348, 508, 577, 663, 814, 838, 853, 854, 855, 885, 886, 948, 949, 950, 9, 26, 38, 39, 40, 48, 69, 119, 120, 132, 166, 197, 294, 348, 508, 577, 801, 814, 838, 853, 854, 855, 880, 882, 884, 885, 886, 951, 952, 9, 26, 38, 39, 40, 48, 69, 119, 120, 132, 166, 197, 294, 348, 508, 577, 801, 814, 838, 853, 854, 855, 880, 882, 884, 885, 886, 951, 952, 9, 26, 38, 39, 40, 48, 69, 119, 120, 132, 197, 294, 348, 508, 577, 801, 814, 838, 853, 854, 855, 880, 882, 884, 885, 886, 952, 1018, 26, 31, 38, 39, 40, 148, 237, 241, 263, 294, 410, 475, 507, 821, 823, 998, 1019, 1030, 1037, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049) GROUP BY ewr_medio_keywords.keyword_id ORDER BY count DESC LIMIT ? ) t ORDER BY keyword_name ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
PRIMARY | <derived2> | ALL | 20 | Using filesort | ||||
DERIVED | ewr_medio_keywords | range | PRIMARY | PRIMARY | 4 | 131 | Using where; Using temporary; Using filesort | |
DERIVED | ewr_medio_keylinks | index | PRIMARY | 8 | 3430 | Using where; Using index; Using join buffer (hash join) |
SELECT `ewr_medio_userlinks`.* FROM `ewr_medio_userlinks` WHERE (`ewr_medio_userlinks`.`media_id` IN (152, 64, 136, 146, 87, 130, 131, 124, 138, 114, 137, 128, 116, 117, 125, 127, 118))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_userlinks | ALL | 100 | 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 UPDATE xf_session_activity SET ip = ?, controller_name = ?, controller_action = ?, view_state = ?, params = ?, view_date = ?, robot_key = ? WHERE user_id = ? AND unique_key = ?
SELECT `xf_andy_chat`.* FROM `xf_andy_chat` WHERE (`xf_andy_chat`.`message_date` > 1716017692)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_andy_chat | ALL | 1 | Using where |
SELECT `xf_andy_chat`.* FROM `xf_andy_chat` WHERE (`xf_andy_chat`.`message_date` > 1716017692)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_andy_chat | ALL | 1 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('chat_chat')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT `ewr_medio_media`.*, `xf_user_User_1`.*, `ewr_medio_services_Service_2`.* FROM `ewr_medio_media` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `ewr_medio_media`.`user_id`) LEFT JOIN `ewr_medio_services` AS `ewr_medio_services_Service_2` ON (`ewr_medio_services_Service_2`.`service_id` = `ewr_medio_media`.`service_id`) LEFT JOIN `ewr_medio_categories` AS `ewr_medio_categories_Category_3` ON (`ewr_medio_categories_Category_3`.`category_id` = `ewr_medio_media`.`category_id`) WHERE ((`ewr_medio_categories_Category_3`.`category_groups` = '') OR (FIND_IN_SET(1, `ewr_medio_categories_Category_3`.`category_groups`))) ORDER BY `ewr_medio_media`.`media_date` DESC LIMIT 4
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_media | ALL | category_id | 551 | Using temporary; Using filesort | |||
SIMPLE | ewr_medio_categories_Category_3 | ALL | PRIMARY | 3 | Using where; Using join buffer (hash join) | |||
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | rwm2_skyrimfo_xfro.ewr_medio_media.user_id | 1 | |
SIMPLE | ewr_medio_services_Service_2 | eq_ref | PRIMARY | PRIMARY | 4 | rwm2_skyrimfo_xfro.ewr_medio_media.service_id | 1 |
bytes_sent | 18404 |
bytes_received | 766754 |
packets_sent | 190 |
packets_received | 1450 |
protocol_overhead_in | 5800 |
protocol_overhead_out | 760 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 486 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 224 |
bytes_received_prepare_response_packet | 61324 |
bytes_received_change_user_packet | 703968 |
packets_sent_command | 94 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 54 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 33 |
packets_received_prepare_response | 765 |
packets_received_change_user | 565 |
result_set_queries | 30 |
non_result_set_queries | 3 |
no_index_used | 20 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 30 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 30 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 535 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 535 |
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 | 535 |
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 | 159 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 266 |
proto_binary_fetched_int24 | 190 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2955 |
proto_binary_fetched_decimal | 87 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 33 |
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 | 1338 |
proto_binary_fetched_blob | 242 |
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 | 31 |
com_stmt_execute | 31 |
com_stmt_send_long_data | 0 |
com_stmt_close | 30 |
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 | 698462 |