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_liamw_accountdelete_account_deletions`.*, `xf_user_User_1`.* FROM `xf_liamw_accountdelete_account_deletions` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_liamw_accountdelete_account_deletions`.`user_id`) WHERE (`xf_liamw_accountdelete_account_deletions`.`user_id` = 0) AND (`xf_liamw_accountdelete_account_deletions`.`status` = 'pending') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_liamw_accountdelete_account_deletions | ref | user_id | user_id | 4 | const | 1 | Using where |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_tag`.* FROM `xf_tag` WHERE (`xf_tag`.`tag_url` = 'welt-der-dunkelheit') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag | const | tag_url | tag_url | 402 | const | 1 |
SELECT `xf_tag_result_cache`.* FROM `xf_tag_result_cache` WHERE (`xf_tag_result_cache`.`tag_id` = 1748 AND `xf_tag_result_cache`.`user_id` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag_result_cache | const | tag_id_user_id | tag_id_user_id | 8 | const,const | 1 |
SELECT content_type, content_id FROM xf_tag_content WHERE tag_id = ? AND visible = 1 ORDER BY content_date DESC LIMIT 500
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 347 | Using where |
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.* 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_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` IN (100206, 99903, 99830, 99440, 99115, 98958, 98712, 98579, 98378, 98333, 98331, 98141, 98124, 98047, 98045, 98044, 98006, 98001, 97968, 97681, 97564, 97559, 97539, 97514, 97490, 97450, 97385, 97156, 97127, 97054, 96960, 96897, 96891, 96568, 96553, 96458, 96337, 96154, 96004, 96003, 96002, 95994, 69225, 95952, 95893, 95886, 95857, 95849, 95828, 95807, 95713, 95691, 95667, 95565, 95511, 95482, 95366, 95359, 95214, 95162, 95037, 94865, 94755, 94746, 94723, 94707, 94626, 94592, 94504, 94366, 94150, 94074, 94048, 94042, 94012, 93654, 93637, 93303, 93174, 92978, 92784, 91889, 91508, 89362, 88765, 88402, 88104, 91444, 87421, 86514, 894, 84273, 84103, 83979, 83795, 82781, 82771, 82662, 81856, 81799, 81233, 81080, 80660, 80442, 80415, 80133, 79874, 79582, 79441, 79169, 78919, 78850, 77307, 76966, 76770, 76686, 76474, 76328, 75874, 75703, 75350, 75056, 74936, 74654, 74470, 74439, 74434, 74411, 73600, 73489, 72999, 69809, 69355, 69276, 68789, 67937, 65969, 65912, 65131, 64802, 64579, 64369, 64218, 63737, 63461, 62582, 62430, 61361, 71469, 58447, 58056, 57570, 55888, 55567, 54915, 53202, 50865, 50159, 48893, 48148, 45887, 45099, 45016, 44592, 43991, 43871, 43609, 43444, 43404, 41946, 41945, 39765, 39565, 39244, 38864, 38122, 37881, 37180, 37172, 37171, 36428, 35974, 34673, 34616, 34047, 32961, 32464, 30544, 28662, 28570, 28457, 27726, 27521, 27005, 26853, 26773, 25608, 25530, 25483, 25438, 25226, 25132, 24809, 24716, 24712, 24641, 24625, 24004, 23676, 23587, 22726, 22723, 22544, 21970, 21739, 21656, 21620, 21560, 21229, 20963, 20457, 20207, 20183, 20177, 19633, 19628, 19588, 19541, 19508, 19424, 19086, 18999, 18849, 18797, 18627, 18598, 17841, 17612, 17384, 17089, 17032, 16984, 16881, 16780, 16502, 16365, 16280, 16242, 16169, 16027, 16000, 15894, 15699, 15472, 15333, 15051, 14858, 14709, 14648, 14586, 14527, 14462, 14457, 14340, 14090, 14057, 13722, 13497, 13429, 13275, 13006, 12828, 12749, 12612, 12477, 12403, 11621, 11468, 11037, 10645, 10410, 10212, 9974, 9927, 9914, 9327, 9084, 9073, 9022, 8667, 8315, 8285, 8093, 7689, 7569, 6913, 6407, 5828, 5386, 5257, 5177, 4967, 4793, 4415, 4359, 4199, 4188, 4133, 3894, 3813, 3687, 3402, 3058, 2882, 2819, 2657, 2523, 2510, 2441, 2054, 2028, 1905, 1614, 1610, 1354, 1231, 1215, 1136, 1103, 941, 823, 787, 691, 643, 509, 468, 401, 400, 399, 350, 285, 284, 271, 257, 180, 172, 72))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | 347 | Using where | |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.xf_node_Node_2.node_id | 1 | Using where |
BEGIN
UPDATE `xf_tag_result_cache` SET `expiry_date` = ? WHERE `result_cache_id` = 129905
COMMIT
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 `xf_cv6_dice`.* FROM `xf_cv6_dice` WHERE (`xf_cv6_dice`.`active` = '1') ORDER BY `xf_cv6_dice`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_cv6_dice | ALL | active | 23 | Using where; Using filesort |
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_node` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') WHERE (`xf_node`.`node_id` IN (324, 61, 147, 408, 203, 380, 204, 365, 286, 288, 289, 148, 149, 150))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | range | PRIMARY | PRIMARY | 4 | 14 | Using where | |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.xf_node.node_id | 1 | Using where |
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_node` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') WHERE ((`xf_node`.`lft` > 208 AND `xf_node`.`rgt` < 225)) AND (`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 | ref | display_in_list,lft | display_in_list | 1 | const | 104 | Using index condition; Using where |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.xf_node.node_id | 1 | Using where |
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 (61, 203, 286, 288, 289, 324, 365))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_category | ALL | PRIMARY | 19 | Using where | |||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.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 (204, 380, 408, 379, 355, 357, 358, 353, 362, 412, 406))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | range | PRIMARY | PRIMARY | 4 | 11 | Using where | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum.last_thread_id | 1 |
SELECT `xf_kl_em_bb_codes`.* FROM `xf_kl_em_bb_codes`
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_kl_em_bb_codes | ALL | 13 |
SELECT `xf_kl_em_fonts`.* FROM `xf_kl_em_fonts` WHERE (`xf_kl_em_fonts`.`active` = 1) ORDER BY `xf_kl_em_fonts`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_kl_em_fonts | ALL | 10 | Using where; Using filesort |
bytes_sent | 17326 |
bytes_received | 2024838 |
packets_sent | 200 |
packets_received | 2194 |
protocol_overhead_in | 8776 |
protocol_overhead_out | 800 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 612 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 298 |
bytes_received_prepare_response_packet | 91104 |
bytes_received_change_user_packet | 1932058 |
packets_sent_command | 99 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 68 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 36 |
packets_received_prepare_response | 1178 |
packets_received_change_user | 878 |
result_set_queries | 30 |
non_result_set_queries | 6 |
no_index_used | 4 |
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 | 31 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 848 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 848 |
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 | 848 |
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 | 1465 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 6095 |
proto_binary_fetched_int24 | 2791 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 26889 |
proto_binary_fetched_decimal | 27 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 10 |
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 | 12178 |
proto_binary_fetched_blob | 5910 |
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 | 4 |
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 | 32 |
com_stmt_execute | 32 |
com_stmt_send_long_data | 0 |
com_stmt_close | 31 |
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 | 1899552 |