SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'iconSprite', '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 | 40 | 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_member_stat`.* FROM `xf_member_stat` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_member_stat`.`addon_id`) WHERE (`xf_member_stat`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_member_stat`.`addon_id` = '')) ORDER BY `xf_member_stat`.`display_order` ASC
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_member_stat | ALL | 9 | Using where; Using filesort | ||||
| SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | carder_admin_bd.xf_member_stat.addon_id | 1 | Using where |
SELECT user_id FROM xf_user WHERE question_solution_count > 0 LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | question_solution_count | question_solution_count | 4 | 1 | Using where; Using index |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`message_count` > 0) OR (`xf_user`.`message_count` < 0)) ORDER BY `xf_user`.`message_count` DESC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | user_state,message_count | message_count | 4 | 46404 | Using index condition; Using where; Backward index scan |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`reaction_score` > 0) OR (`xf_user`.`reaction_score` < 0)) ORDER BY `xf_user`.`reaction_score` DESC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | user_state,reaction_score | reaction_score | 4 | 7235 | Using index condition; Using where; Backward index scan |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`trophy_points` > 0) OR (`xf_user`.`trophy_points` < 0)) ORDER BY `xf_user`.`trophy_points` DESC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | user_state,trophy_points | trophy_points | 4 | 79024 | Using index condition; Using where; Backward index scan |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`xfrm_resource_count` > 0) OR (`xf_user`.`xfrm_resource_count` < 0)) ORDER BY `xf_user`.`xfrm_resource_count` DESC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | user_state,resource_count | resource_count | 4 | 25 | Using index condition; Using where; Backward index scan |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`xfmg_media_count` > 0) OR (`xf_user`.`xfmg_media_count` < 0)) ORDER BY `xf_user`.`xfmg_media_count` DESC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | user_state,xengallery_media_count | xengallery_media_count | 4 | 34 | Using index condition; Using where; Backward index scan |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`xfmg_album_count` > 0) OR (`xf_user`.`xfmg_album_count` < 0)) ORDER BY `xf_user`.`xfmg_album_count` DESC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | user_state,xengallery_album_count | xengallery_album_count | 4 | 1 | Using index condition; Using where; Backward index scan |
SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.* FROM `xf_user` INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`) INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user_profile_Profile_1`.`dob_day` = 12) AND (`xf_user_profile_Profile_1`.`dob_month` = 2) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1739386335) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') ORDER BY `xf_user`.`username` ASC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user_profile_Profile_1 | ref | PRIMARY,dob | dob | 2 | const,const | 42 | Using temporary; Using filesort |
| SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_user_profile_Profile_1.user_id | 1 | Using where |
| SIMPLE | xf_user | eq_ref | PRIMARY,user_state,last_activity | PRIMARY | 4 | carder_admin_bd.xf_user_profile_Profile_1.user_id | 1 | Using where |
SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.* FROM `xf_user` INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`) INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user_profile_Profile_1`.`dob_day` = 12) AND (`xf_user_profile_Profile_1`.`dob_month` = 2) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1739386335) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') ORDER BY `xf_user`.`username` ASC LIMIT 60
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user_profile_Profile_1 | ref | PRIMARY,dob | dob | 2 | const,const | 42 | Using temporary; Using filesort |
| SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_user_profile_Profile_1.user_id | 1 | Using where |
| SIMPLE | xf_user | eq_ref | PRIMARY,user_state,last_activity | PRIMARY | 4 | carder_admin_bd.xf_user_profile_Profile_1.user_id | 1 | Using where |
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.* FROM `xf_user` INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`) INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user`.`user_id` IN (1, 138300, 68811, 43475, 12345, 35, 138126, 132891, 125495, 127546, 77242, 167917, 23888, 126030, 128221, 126841, 159454, 156331, 152958, 139548, 121577, 59967, 149796, 147760, 136191, 134235, 130857, 123775, 2930, 167831, 156777, 131479, 124648, 124071, 155722, 150278, 150131, 162882, 125594, 18201, 11627, 11261, 5481, 4788, 2770, 2447, 934, 7, 51014, 8318, 7808, 6318, 45283, 186821, 173536, 168979, 165354, 163595, 162940, 125900, 124639, 124477, 58131, 47545, 44188, 43678, 43329, 40899, 28581, 28169, 27950, 27884, 27754, 22383, 15810, 15618, 37, 9568, 663, 3638, 7047, 6132, 5295, 153680, 8232, 6940, 4465, 2358, 148102, 148164, 5850, 170, 169452, 28418, 151979, 18626, 11811, 152955, 61813, 28556, 7311, 5958)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | PRIMARY,user_state | PRIMARY | 4 | 102 | Using where | |
| SIMPLE | xf_user_option_Option_1 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_user.user_id | 1 | |
| SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_user.user_id | 1 |
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 |
SELECT `xf_user`.* FROM `xf_user` USE INDEX (`register_date`) WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') ORDER BY `xf_user`.`register_date` DESC LIMIT 12
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | index | register_date | 4 | 12 | Using where; Backward index scan |
| bytes_sent | 13404 |
| bytes_received | 668105 |
| packets_sent | 184 |
| packets_received | 1941 |
| protocol_overhead_in | 7764 |
| protocol_overhead_out | 736 |
| bytes_received_ok_packet | 0 |
| bytes_received_eof_packet | 0 |
| bytes_received_rset_header_packet | 441 |
| bytes_received_rset_field_meta_packet | 0 |
| bytes_received_rset_row_packet | 172 |
| bytes_received_prepare_response_packet | 108931 |
| bytes_received_change_user_packet | 557825 |
| packets_sent_command | 91 |
| packets_received_ok | 0 |
| packets_received_eof | 0 |
| packets_received_rset_header | 49 |
| packets_received_rset_field_meta | 0 |
| packets_received_rset_row | 32 |
| packets_received_prepare_response | 1380 |
| packets_received_change_user | 448 |
| result_set_queries | 30 |
| non_result_set_queries | 2 |
| no_index_used | 2 |
| bad_index_used | 0 |
| slow_queries | 0 |
| buffered_sets | 0 |
| unbuffered_sets | 0 |
| ps_buffered_sets | 30 |
| ps_unbuffered_sets | 0 |
| flushed_normal_sets | 0 |
| flushed_ps_sets | 0 |
| ps_prepared_never_executed | 0 |
| ps_prepared_once_executed | 29 |
| rows_fetched_from_server_normal | 0 |
| rows_fetched_from_server_ps | 418 |
| rows_buffered_from_client_normal | 0 |
| rows_buffered_from_client_ps | 418 |
| 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 | 0 |
| 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 | 29 |
| 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 | 486 |
| proto_binary_fetched_tinyint | 0 |
| proto_binary_fetched_short | 3917 |
| proto_binary_fetched_int24 | 1827 |
| proto_binary_fetched_int | 0 |
| proto_binary_fetched_bigint | 8940 |
| proto_binary_fetched_decimal | 44 |
| proto_binary_fetched_float | 0 |
| proto_binary_fetched_double | 0 |
| proto_binary_fetched_date | 22 |
| 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 | 4034 |
| proto_binary_fetched_blob | 969 |
| 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 | 30 |
| com_stmt_execute | 30 |
| com_stmt_send_long_data | 0 |
| com_stmt_close | 29 |
| 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 | 547592 |