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 |
SHOW FULL COLUMNS FROM `xf_user`
SHOW FULL COLUMNS FROM `xf_user`
SHOW FULL COLUMNS FROM `xf_user_profile`
SHOW FULL COLUMNS FROM `xf_user_profile`
SHOW FULL COLUMNS FROM `xf_user_profile`
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('tran_board_title')
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 ('tran_board_description')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
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 |
SHOW FULL COLUMNS FROM `xf_node`
SHOW FULL COLUMNS FROM `xf_node`
SHOW FULL COLUMNS FROM `xf_node`
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 | 397 | |||||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,iapd-2021.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 | PRIMARY | 8 | 1 | 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 | 1 | 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 | 1 | 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 | 354 | Using where; Using filesort |
SHOW FULL COLUMNS FROM `xf_thread`
SHOW FULL COLUMNS FROM `xf_thread`
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 (560, 55, 443, 551, 522, 524, 552, 553, 559, 317, 349, 558, 538, 526, 531, 544, 548, 547, 355, 360, 361, 362, 364, 395, 549, 350, 403, 351, 402, 352, 404, 353, 405, 376, 388, 386, 387, 399, 401, 442, 455, 456, 454, 468, 517, 515, 518, 519, 521, 523, 554, 555, 557, 359, 363, 356, 319, 382, 13, 469, 238, 239, 22, 34, 206, 215, 208, 210, 213, 214, 278, 207, 314, 313, 330, 240, 209, 211, 212, 315, 205, 340, 14, 258, 334, 223, 241, 242, 257, 228, 21, 225, 17, 43, 175, 78, 247, 71, 226, 97, 72, 74, 84, 73, 76, 77, 75, 98, 227, 164, 99, 106, 168, 107, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 125, 126, 123, 188, 165, 166, 167, 101, 174, 104, 105, 169, 100, 85, 171, 170, 86, 87, 176, 185, 186, 187, 177, 88, 172, 179, 180, 178, 173, 181, 182, 248, 20, 19, 44, 183, 184, 216, 217, 218, 328, 30, 200, 23, 50, 159, 336, 309, 27, 68, 306, 57, 81, 298, 301, 302, 299, 300, 66, 303, 297, 79, 307, 82, 89, 93, 128, 312, 250, 65, 58, 83, 59, 60, 61, 62, 63, 64, 108, 94, 520, 463, 464, 109, 152, 154, 129, 156, 157, 131, 132, 139, 143, 147, 148, 150, 155, 151, 195, 196, 197, 331, 332, 338, 127, 341, 344, 345, 346, 347, 348, 458, 459, 460, 461, 471, 475, 476, 477, 478, 472, 479, 480, 481, 482, 483, 484, 473, 485, 486, 487, 488, 489, 490, 474, 492, 493, 494, 230, 231, 232, 233, 234, 235, 236, 237, 198, 435, 189, 465, 470, 499, 512, 406, 418, 427, 432, 433, 412, 413, 424, 419, 421, 422, 423, 416, 438, 440, 441, 415, 436, 437, 417, 425, 192, 244, 245, 191, 219, 220, 221, 194, 190, 193, 202, 203, 201, 243, 305, 310, 260, 329, 366, 367, 371, 372, 396, 397, 369, 373, 370, 374, 368, 377, 383, 18, 280, 264, 326, 324, 325, 339, 390, 262, 265, 266, 273, 199, 496, 510, 509, 274, 308, 161, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 261, 284, 285, 282, 316, 29, 222, 52, 53, 162, 54, 158, 500, 502, 503, 504, 501, 505, 511, 3, 5, 6, 15, 11, 506, 7, 8, 9, 10, 16, 507, 24, 462))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | PRIMARY | 397 | Using where | |||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.last_thread_id | 1 |
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 (28, 457, 467, 491, 229, 224, 256, 259, 4, 12))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | 10 | Using where; Using index | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_category.node_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 | 818 | 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 = ?
DELETE FROM `xf_data_registry` WHERE data_key IN ('userBanners')
SHOW FULL COLUMNS FROM `xf_user_group`
SHOW FULL COLUMNS FROM `xf_user_group`
SHOW FULL COLUMNS FROM `xf_user_group`
SELECT `xf_user_group`.* FROM `xf_user_group` WHERE (`xf_user_group`.`banner_text` <> '') ORDER BY `xf_user_group`.`display_style_priority` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_group | ALL | 26 | Using where; Using filesort |
INSERT INTO xf_data_registry (data_key, data_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('search_threads', 'search_profile_posts', 'xfmg_search_albums', 'xfmg_search_media_comments', 'xfmg_search_media')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | 5 | Using where |
SELECT `xf_andy_countdown`.* FROM `xf_andy_countdown` LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_andy_countdown | ALL | 1 |
SELECT `xf_andy_banner`.* FROM `xf_andy_banner` WHERE (`xf_andy_banner`.`header` = 1) AND (`xf_andy_banner`.`active` = 1) ORDER BY RAND() ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_andy_banner | ALL | 1 | Using where; Using temporary; Using filesort |
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 |
bytes_sent | 16743 |
bytes_received | 3175059 |
packets_sent | 316 |
packets_received | 3995 |
protocol_overhead_in | 15980 |
protocol_overhead_out | 1264 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1026 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 341 |
bytes_received_prepare_response_packet | 98957 |
bytes_received_change_user_packet | 3073554 |
packets_sent_command | 157 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 114 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 54 |
packets_received_prepare_response | 1457 |
packets_received_change_user | 2316 |
result_set_queries | 49 |
non_result_set_queries | 5 |
no_index_used | 23 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 49 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 51 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 2267 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 2267 |
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 | 2267 |
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 | 8450 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 13265 |
proto_binary_fetched_int24 | 3678 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 35101 |
proto_binary_fetched_decimal | 24 |
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 | 335 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 41353 |
proto_binary_fetched_blob | 20618 |
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 | 52 |
com_stmt_execute | 52 |
com_stmt_send_long_data | 0 |
com_stmt_close | 51 |
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 | 2983237 |