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_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 | 58 | 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 (44, 1, 52, 11, 29, 17, 48))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | 7 | Using where; Using index | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_category.node_id | 1 |
SELECT `xf_page`.*, `xf_node_Node_1`.* FROM `xf_page` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_page`.`node_id`) WHERE (`xf_page`.`node_id` IN (45, 51))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_page | range | PRIMARY | PRIMARY | 4 | 2 | Using where | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_page.node_id | 1 |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.* 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`) WHERE (`xf_forum`.`node_id` IN (46, 2, 3, 4, 5, 6, 7, 8, 21, 25, 26, 27, 28, 33, 10, 37, 83, 69, 70, 71, 72, 80, 73, 74, 75, 76, 66, 67, 68, 77, 56, 57, 58, 78, 79, 12, 13, 14, 15, 16, 31, 32, 30, 18, 19, 20, 49))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | PRIMARY | 47 | Using where | |||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_forum.last_thread_id | 1 |
SELECT `xf_link_forum`.*, `xf_node_Node_1`.* FROM `xf_link_forum` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_link_forum`.`node_id`) WHERE (`xf_link_forum`.`node_id` IN (84))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_link_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 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 | 58 | 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 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 |
SELECT `xf_mg_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_mg_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_mg_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') ORDER BY `xf_mg_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_category | ALL | 1 | Using filesort | ||||
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,cj67783_ertos.xf_mg_category.category_id | 1 | Using where |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (IF(`xf_mg_media_item`.`album_id` > 0, `xf_mg_album_Album_1`.`album_state` = 'visible', 1=1)) AND ((`xf_mg_media_item`.`category_id` = 0 AND `xf_mg_album_Album_1`.`view_privacy` = 'public')) AND (`xf_mg_media_item`.`media_state` = 'visible') AND (`xf_mg_media_item`.`media_id` IN (557, 958, 603, 602, 592, 467, 648, 416, 526, 559, 833, 434, 761, 834, 703, 719, 638, 622, 917, 24, 959, 503, 942, 748, 501, 707, 593, 893, 780, 803, 499, 892, 364, 705, 621, 827, 448, 756, 701, 1034, 991, 596, 941, 563, 766, 824, 561, 619, 380, 646, 718, 963, 804, 1017, 449, 464, 378, 560, 744, 366, 784, 463, 401, 867, 466, 558, 504, 1014, 944, 687, 806, 568, 890, 450, 694, 1035, 623, 469, 429, 417, 793, 1033, 471, 437, 1037, 555, 597, 792, 430, 1016, 502, 1046, 714, 992, 706, 465, 379, 762, 702, 801, 402, 764, 995, 894, 905, 781, 475, 435, 785, 912, 519, 874, 1025, 872, 692, 1044, 633, 565, 400, 474, 746, 647, 528, 821, 462, 745, 566, 376, 398, 869, 996, 631, 754, 426, 529, 715, 1043, 962, 747, 420, 960, 709, 720, 704, 1026, 914, 527, 695, 757, 590, 1038, 713, 377, 940, 595, 1045, 556, 1013, 630, 717, 472, 907, 624, 690, 835, 517, 953, 957, 865, 447, 562, 904, 1024, 1023, 916, 828, 1036, 716, 591, 567, 712, 1042, 955, 710, 688, 428, 822, 399, 765, 820, 961, 363, 866, 906, 418, 760, 836, 805, 691, 564, 634, 419, 427, 1040, 782, 755, 956, 436, 618, 829, 913, 594, 826, 468, 943, 868, 525, 915, 823, 819, 767, 871, 954, 786, 939, 446, 520, 1027, 645, 365, 825, 1039, 473, 620, 873, 994, 708, 554, 693, 802, 433, 870, 367, 686, 891, 516, 470, 721, 911, 518, 763, 500, 689, 908, 711, 831, 1015, 783)) LIMIT 1000
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_album_Album_1 | ALL | PRIMARY | 30 | Using where | |||
SIMPLE | xf_mg_media_item | ref | PRIMARY,album_id_media_date,category_id_media_date | album_id_media_date | 4 | cj67783_ertos.xf_mg_album_Album_1.album_id | 17 | Using index condition; Using where |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,cj67783_ertos.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_attachment_Attachment_4.data_id | 1 |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('brmsModernStatistics')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT * FROM xf_brms_modern_cache WHERE modern_statistic_id = ? AND user_id = ? ORDER BY last_update DESC LIMIT 0,1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_forum`.*, `xf_node_Node_1`.* FROM `xf_forum` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | 47 | |||||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_forum.node_id | 1 |
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_user_LastPoster_4`.* FROM `xf_thread` LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_thread`.`last_post_user_id`) WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (1) AND (`xf_thread`.`node_id` IN (2, 3, 4, 5, 6, 7, 8, 10, 12, 13, 14, 15, 16, 18, 19, 20, 21, 25, 26, 27, 28, 30, 31, 32, 33, 37, 46, 49, 56, 57, 58, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 83)) ORDER BY `xf_thread`.`last_post_date` DESC LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | index | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | last_post_date | 4 | 20 | Using where | |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_thread.last_post_user_id | 1 |
SELECT display_style_group_id FROM xf_user WHERE user_id=?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_style_group_id FROM xf_user WHERE user_id=?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_style_group_id FROM xf_user WHERE user_id=?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_style_group_id FROM xf_user WHERE user_id=?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_style_group_id FROM xf_user WHERE user_id=?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT display_style_group_id FROM xf_user WHERE user_id=?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
bytes_sent | 18146 |
bytes_received | 4342928 |
packets_sent | 274 |
packets_received | 2332 |
protocol_overhead_in | 9328 |
protocol_overhead_out | 1096 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 783 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 294 |
bytes_received_prepare_response_packet | 121855 |
bytes_received_change_user_packet | 4218964 |
packets_sent_command | 136 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 87 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 47 |
packets_received_prepare_response | 1549 |
packets_received_change_user | 602 |
result_set_queries | 44 |
non_result_set_queries | 3 |
no_index_used | 10 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 44 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 44 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 558 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 558 |
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 | 558 |
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 | 6062 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 3833 |
proto_binary_fetched_int24 | 1758 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 23927 |
proto_binary_fetched_decimal | 308 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 928 |
proto_binary_fetched_date | 38 |
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 | 9297 |
proto_binary_fetched_blob | 4570 |
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 | 45 |
com_stmt_execute | 45 |
com_stmt_send_long_data | 0 |
com_stmt_close | 44 |
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 | 4194748 |