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 `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 | 216 | 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 (3, 182, 155, 72, 156, 71, 73, 80, 279, 11, 25, 241, 285))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | 14 | Using where; Using index | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.xf_category.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 (4, 5, 6, 10, 8, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 184, 183, 92, 185, 186, 201, 272, 275, 7, 198, 88, 90, 22, 77, 187, 200, 239, 260, 278, 75, 181, 189, 230, 74, 231, 232, 234, 235, 76, 256, 259, 261, 271, 24, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 221, 223, 224, 226, 227, 228, 229, 240, 219, 220, 222, 225, 199, 254, 237, 257, 78, 274, 276, 277, 81, 262, 263, 191, 264, 265, 266, 267, 268, 269, 82, 192, 238, 23, 280, 281, 282, 283, 180, 12, 288, 26, 27, 28, 29, 30, 31, 64, 69, 97, 195, 194, 13, 33, 35, 188, 36, 37, 38, 39, 40, 41, 43, 45, 65, 66, 67, 70, 14, 46, 47, 171, 15, 48, 177, 16, 49, 236, 17, 50, 51, 53, 54, 55, 63, 116, 258, 197, 193, 18, 57, 59, 60, 139, 142, 20, 284, 61, 146, 173, 174, 175, 19, 62, 178, 179, 273, 9, 32, 34, 42, 44, 52, 56, 58, 68, 124, 135, 169, 170, 172, 176, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 286, 287))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | PRIMARY | 202 | Using where | |||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.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 | 396 | 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 INSERT IGNORE INTO xf_session_activity ( ip, controller_name, controller_action, view_state, params, view_date, robot_key, user_id, unique_key ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total, SUM(IF(user_id > 0, 1, 0)) AS members, SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests FROM xf_session_activity WHERE view_date >= ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | 47 | Using where |
SELECT `xf_session_activity`.*, `xf_user_User_1`.* FROM `xf_session_activity` INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`) WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1714416269) ORDER BY `xf_session_activity`.`view_date` DESC LIMIT 50
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | PRIMARY | 4 | 4 | Using where; Using filesort | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | vihc_cungvuikp2z.xf_session_activity.user_id | 1 | Using where |
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_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.* FROM `xf_profile_post` USE INDEX (`post_date`) LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`) WHERE (`xf_profile_post`.`message_state` = 'visible') ORDER BY `xf_profile_post`.`post_date` DESC LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | index | post_date | 4 | 10 | Using where | ||
SIMPLE | xf_user_ProfileUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.xf_profile_post.profile_user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.xf_user_ProfileUser_1.user_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.xf_profile_post.user_id | 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 |
SELECT `xf_siropu_chat_room`.* FROM `xf_siropu_chat_room` WHERE (`xf_siropu_chat_room`.`room_id` IN (1)) AND (`xf_siropu_chat_room`.`room_state` = 'visible')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_siropu_chat_room | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_siropu_chat_message`.*, `xf_user_User_1`.* FROM `xf_siropu_chat_message` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_siropu_chat_message`.`message_user_id`) WHERE (`xf_siropu_chat_message`.`message_room_id` = 1) AND (`xf_siropu_chat_message`.`message_is_ignored` IN (0, 0)) ORDER BY `xf_siropu_chat_message`.`message_id` DESC LIMIT 50
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_siropu_chat_message | ref | message_room_id,message_is_ignored | message_room_id | 4 | const | 1 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | vihc_cungvuikp2z.xf_siropu_chat_message.message_user_id | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`siropu_chat_last_activity` >= 1714415370) AND (`xf_user`.`siropu_chat_room_id` IN (1)) ORDER BY `xf_user`.`siropu_chat_last_activity` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | range | siropu_chat_room_id,siropu_chat_last_activity | siropu_chat_last_activity | 4 | 1 | Using where |
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 | Impossible WHERE noticed after reading const tables |
SELECT SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total, SUM(IF(user_id > 0, 1, 0)) AS members, SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests FROM xf_session_activity WHERE view_date >= ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | 47 | Using where |
bytes_sent | 14567 |
bytes_received | 992613 |
packets_sent | 226 |
packets_received | 2386 |
protocol_overhead_in | 9544 |
protocol_overhead_out | 904 |
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 | 213 |
bytes_received_prepare_response_packet | 112975 |
bytes_received_change_user_packet | 877744 |
packets_sent_command | 112 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 87 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 39 |
packets_received_prepare_response | 1455 |
packets_received_change_user | 766 |
result_set_queries | 36 |
non_result_set_queries | 3 |
no_index_used | 4 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 36 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 36 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 730 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 730 |
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 | 730 |
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 | 8394 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 2857 |
proto_binary_fetched_int24 | 999 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 11065 |
proto_binary_fetched_decimal | 27 |
proto_binary_fetched_float | 6 |
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 | 5774 |
proto_binary_fetched_blob | 3453 |
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 | 37 |
com_stmt_execute | 37 |
com_stmt_send_long_data | 0 |
com_stmt_close | 36 |
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 | 859019 |