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_user`.* FROM `xf_user` WHERE ((`xf_user`.`user_id` = 209101) OR (`xf_user`.`username` = '')) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | index_merge | PRIMARY,username | PRIMARY,username | 4,152 | 2 | Using union(PRIMARY,username); Using where |
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`.`user_id` = 209101)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_categories_Category_3 | ALL | PRIMARY | 5 | Using where | |||
SIMPLE | ewr_medio_media | ref|filter | category_id,user_id | category_id|user_id | 4|4 | animesuperhero_xenforo.ewr_medio_categories_Category_3.category_id | 287 (2%) | Using where; Using rowid filter |
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`.`user_id` = 209101) ORDER BY `ewr_medio_media`.`reaction_score` 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_categories_Category_3 | ALL | PRIMARY | 5 | Using where; Using temporary; Using filesort | |||
SIMPLE | ewr_medio_media | ref|filter | category_id,user_id | category_id|user_id | 4|4 | animesuperhero_xenforo.ewr_medio_categories_Category_3.category_id | 287 (2%) | Using where; Using rowid filter |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | ewr_medio_services_Service_2 | eq_ref | PRIMARY | PRIMARY | 4 | animesuperhero_xenforo.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 | 5 | 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`.`user_id` = 209101) ORDER BY `ewr_medio_media`.`reaction_score` 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_categories_Category_3 | ALL | PRIMARY | 5 | Using where; Using temporary; Using filesort | |||
SIMPLE | ewr_medio_media | ref|filter | category_id,user_id | category_id|user_id | 4|4 | animesuperhero_xenforo.ewr_medio_categories_Category_3.category_id | 287 (2%) | Using where; Using rowid filter |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | ewr_medio_services_Service_2 | eq_ref | PRIMARY | PRIMARY | 4 | animesuperhero_xenforo.ewr_medio_media.service_id | 1 |
SELECT `ewr_medio_keylinks`.* FROM `ewr_medio_keylinks` WHERE (`ewr_medio_keylinks`.`media_id` IN (16011, 16001, 15991, 15912, 15802, 15671, 15661, 15651, 15412, 15351, 15222, 15212, 15202, 15061, 15051, 14981, 14971, 14931, 14862, 12232, 12222, 12212, 11902, 11892, 11741, 11731, 11491, 11442, 11432, 11422, 11382, 11312))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_keylinks | range | PRIMARY | PRIMARY | 4 | 486 | 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 (131, 5021, 671, 11512, 621, 11542, 131, 391, 11552, 11562, 481, 8382, 8392, 11572, 5161, 5241, 1111, 7242, 11861, 11871, 621, 1501, 11881, 481, 391, 2802, 2832, 5021, 6102, 7591, 9032, 11962, 11972, 11982, 11992, 12002, 12012, 12022, 12032, 12042, 12052, 12062, 12072, 2802, 2842, 6102, 12082, 12092, 12102, 12112, 12122, 12132, 1111, 5291, 12142, 12152, 12162, 12172, 12182, 12192, 12202, 12212, 12222, 12232, 111, 1111, 12202, 12572, 19282, 19292, 19302, 19312, 19322, 19332, 111, 1111, 2802, 2962, 12202, 12572, 12962, 13822, 19282, 19721, 19731, 19741, 19751, 19761, 19771, 19781, 19791, 1251, 12802, 12852, 13151, 19831, 19841, 19851, 19861, 19871, 19881, 19891, 19901, 19911, 19921, 19931, 19941, 19951, 19961, 19971, 19981, 19991, 20001, 20011, 20021, 20031, 20041, 201, 1141, 2491, 2802, 2991, 9731, 13822, 15862, 17292, 17681, 18061, 20051, 20061, 20071, 20081, 20091, 20101, 20111, 20121, 20131, 20141, 20151, 20161, 20171, 20181, 20191, 20201, 20211, 20221, 20231, 20241, 1111, 12202, 20341, 20351, 20361, 20371, 20381, 20391, 20401, 20411, 20421, 20431, 20441, 20451, 20461, 20471, 20481, 2802, 9821, 13822, 18082, 20491, 20501, 20511, 20521, 20531, 20541, 20551, 20561, 20571, 20581, 20591, 20601, 20611, 20621, 20631, 20641, 20651, 20661, 20671, 20681, 20691, 20701, 20711, 20721, 20731, 20741, 20751, 481, 1071, 14331, 20611, 22432, 22442, 22452, 22462, 22472, 22482, 22492, 22502, 22512, 22522, 22532, 22542, 22552, 22562, 22572, 22582, 22592, 22602, 481, 4872, 14331, 22612, 22622, 151, 1621, 2141, 2471, 2852, 3792, 6962, 12992, 13002, 13012, 13032, 13201, 13691, 14501, 15992, 19192, 19202, 19512, 20322, 22632, 22642, 22652, 22662, 22672, 22682, 22692, 22702, 22712, 22722, 22732, 22742, 22752, 22762, 1111, 7431, 10191, 12202, 18002, 22851, 22861, 22871, 22881, 22891, 22901, 22911, 5141, 23102, 23112, 23122, 23132, 23142, 23152, 23162, 23172, 23182, 23192, 23202, 23212, 23222, 23232, 23242, 23252, 23262, 23272, 23282, 23292, 23302, 23312, 23322, 23332, 23342, 2852, 13032, 20011, 20031, 23791, 23801, 23811, 23821, 23831, 23841, 23851, 23861, 23871, 23881, 23891, 23901, 23911, 23921, 23931, 23941, 23951, 23961, 23971, 23981, 391, 12632, 13022, 13191, 15862, 15902, 19581, 19611, 23991, 24001, 24011, 24021, 24031, 24041, 24051, 24061, 24071, 24081, 24091, 24101, 24111, 24121, 24131, 24141, 24151, 24161, 24171, 24181, 24191, 1111, 12202, 24201, 24211, 24221, 24231, 24241, 24251, 24261, 24271, 24281, 24291, 24301, 24311, 24321, 24331, 24341, 24351, 24361, 24371, 24381, 24391, 24401, 24411, 24421, 24431, 111, 131, 4581, 5691, 9432, 12572, 13201, 13691, 14661, 19282, 19432, 19671, 22732, 22792, 23051, 24812, 24822, 24832, 24842, 24852, 24862, 24872, 24882, 24892, 24902, 2802, 3221, 4082, 4471, 5252, 5461, 8592, 9182, 12902, 13691, 13822, 20611, 21362, 25162, 25172, 25182, 25192, 25202, 25212, 25222, 25232, 25242, 25252, 25262, 25272, 25282, 25292, 25302, 25312, 25322, 25332, 25342, 25352, 25362, 25372, 25382, 25392, 481, 491, 6872, 14331, 24962, 25441, 1111, 8652, 12202, 17112, 17152, 131, 391, 2952, 6272, 9801, 12632, 13022, 13191, 13201, 14661, 15832, 15842, 15852, 15862, 15872, 18331, 22782, 24031, 24191, 25451, 25461, 25471, 25481, 25491, 25501, 25511, 25521, 25531, 25541, 25551, 25561, 25571, 25581, 25591, 25601, 25611, 25621, 25631, 25641, 25651) 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 | 425 | Using where; Using temporary; Using filesort | |
DERIVED | ewr_medio_keylinks | index | PRIMARY | 8 | 22734 | Using where; Using index; Using join buffer (flat, BNL join) |
SELECT `ewr_medio_userlinks`.* FROM `ewr_medio_userlinks` WHERE (`ewr_medio_userlinks`.`media_id` IN (16011, 16001, 15991, 15912, 15802, 15671, 15661, 15651, 15412, 15351, 15222, 15212, 15202, 15061, 15051, 14981, 14971, 14931, 14862, 12232, 12222, 12212, 11902, 11892, 11741, 11731, 11491, 11442, 11432, 11422, 11382, 11312))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | ewr_medio_userlinks | ALL | 927 | 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_th_xlink_platform_link`.* FROM `xf_th_xlink_platform_link` WHERE (`xf_th_xlink_platform_link`.`platform_id` IN (2))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_th_xlink_platform_link | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_addon`.* FROM `xf_addon` WHERE (`xf_addon`.`addon_id` = 'Tapatalk') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | const | 1 |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('forumStatistics')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
bytes_sent | 18942 |
bytes_received | 592724 |
packets_sent | 178 |
packets_received | 1601 |
protocol_overhead_in | 6404 |
protocol_overhead_out | 712 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 567 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 214 |
bytes_received_prepare_response_packet | 60005 |
bytes_received_change_user_packet | 531230 |
packets_sent_command | 88 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 63 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 31 |
packets_received_prepare_response | 805 |
packets_received_change_user | 671 |
result_set_queries | 28 |
non_result_set_queries | 3 |
no_index_used | 6 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 28 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 28 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 643 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 643 |
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 | 643 |
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 | 28 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 590 |
proto_binary_fetched_int24 | 325 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 4003 |
proto_binary_fetched_decimal | 44 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 0 |
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 | 2056 |
proto_binary_fetched_blob | 563 |
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 | 29 |
com_stmt_execute | 29 |
com_stmt_send_long_data | 0 |
com_stmt_close | 28 |
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 | 523678 |