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', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 36 | 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 | 384 | |||||
| SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2020.xf_forum.node_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,iapd-2020.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 | 394 | 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 (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-2020.xf_category.node_id | 1 |
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 (521, 523, 522, 524, 317, 349, 350, 403, 351, 402, 352, 404, 353, 405, 376, 388, 386, 387, 399, 401, 442, 455, 456, 454, 468, 517, 515, 518, 519, 359, 395, 363, 354, 355, 360, 361, 362, 364, 356, 319, 382, 13, 469, 238, 239, 22, 497, 498, 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, 513, 514, 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, 55, 443, 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 | 384 | Using where | |||
| SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2020.xf_forum.node_id | 1 | |
| SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2020.xf_forum.last_post_user_id | 1 | |
| SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2020.xf_forum.last_thread_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 | 776 | Using where |
-- XFDB=noForceAllWrite INSERT INTO xf_session_activity (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date), robot_key = VALUES(robot_key)
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)
DELETE FROM `xf_data_registry` WHERE data_key IN ('userBanners')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 | 17662 |
| bytes_received | 3093416 |
| packets_sent | 322 |
| packets_received | 3645 |
| protocol_overhead_in | 14580 |
| 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 | 311 |
| bytes_received_prepare_response_packet | 88287 |
| bytes_received_change_user_packet | 3002605 |
| 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 | 1319 |
| packets_received_change_user | 2103 |
| result_set_queries | 49 |
| non_result_set_queries | 6 |
| no_index_used | 24 |
| 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 | 52 |
| rows_fetched_from_server_normal | 0 |
| rows_fetched_from_server_ps | 2054 |
| rows_buffered_from_client_normal | 0 |
| rows_buffered_from_client_ps | 2054 |
| 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 | 2054 |
| 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 | 6402 |
| proto_binary_fetched_tinyint | 0 |
| proto_binary_fetched_short | 13658 |
| proto_binary_fetched_int24 | 3236 |
| proto_binary_fetched_int | 0 |
| proto_binary_fetched_bigint | 33110 |
| proto_binary_fetched_decimal | 24 |
| proto_binary_fetched_float | 0 |
| proto_binary_fetched_double | 341 |
| proto_binary_fetched_date | 0 |
| proto_binary_fetched_year | 0 |
| proto_binary_fetched_time | 0 |
| proto_binary_fetched_datetime | 0 |
| proto_binary_fetched_timestamp | 339 |
| proto_binary_fetched_string | 0 |
| proto_binary_fetched_json | 26326 |
| proto_binary_fetched_blob | 12025 |
| 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 | 2941505 |