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 | ALL | PRIMARY | 42 | 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_tag`.* FROM `xf_tag` WHERE (`xf_tag`.`tag_url` = 'bahis-forumlari') 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` = 531 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 200
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 | 188 | 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 (10198, 5695, 5694, 5668, 5667, 5650, 5649, 5627, 5625, 5597, 5596, 5572, 5571, 5546, 5545, 5544, 5513, 5512, 5489, 5488, 5465, 5464, 5444, 5443, 5442, 5422, 5421, 5420, 5369, 5368, 5367, 5344, 5343, 5321, 5320, 5319, 5296, 5288, 5287, 5286, 5260, 5259, 5242, 5241, 5240, 5219, 5218, 5217, 5198, 5197, 5196, 5175, 5174, 5145, 5144, 5143, 5109, 5108, 5107, 5077, 5076, 5075, 5057, 5056, 5055, 5049, 5032, 5024, 5023, 4989, 4988, 4987, 4961, 4960, 4959, 4958, 4932, 4931, 4930, 4901, 4900, 4899, 4878, 4875, 4874, 4873, 4856, 4855, 4854, 4823, 4822, 4821, 4809, 4798, 4794, 4793, 4792, 4759, 4758, 4757, 4728, 4727, 4726, 4725, 4724, 4723, 4722, 4720, 4719, 4687, 4686, 4685, 4684, 4683, 4682, 4681, 4680, 4679, 4656, 4651, 4650, 4649, 4648, 4647, 4644, 4643, 4618, 4617, 4616, 4615, 4614, 4608, 4607, 4591, 4590, 4585, 4584, 4583, 4582, 4581, 4576, 4575, 4574, 4548, 4546, 4523, 4519, 4509, 4508, 4505, 4504, 4474, 4473, 4472, 4471, 4444, 4443, 4442, 4430, 4422, 4421, 4392, 4391, 4378, 4377, 4356, 4355, 4334, 4332, 4331, 4312, 4311, 4267, 4266, 4261, 4246, 4245, 4244, 4223, 4218, 4216, 4212, 4207, 4206, 4181, 4173, 4172, 4171, 4169))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | 189 | Using where | |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foru_12.xf_node_Node_2.node_id | 1 | Using where |
BEGIN
UPDATE `xf_tag_result_cache` SET `expiry_date` = ? WHERE `result_cache_id` = 52469
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 INSERT IGNORE INTO xf_session_activity ( ip, controller_name, controller_action, view_state, params, view_date, robot_key, user_id, unique_key ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT thread_prefix_type FROM xf_thread_prefix_groups
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_groups | ALL | 1 |
SELECT abstract_interface_type FROM xf_permission_interface_groups
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_interface_groups | ALL | 1 |
SELECT thread_prefix_id FROM xf_thread_prefix_groups
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_groups | index | PRIMARY | 14 | 1 | Using index |
SELECT `xf_user_profile`.* FROM `xf_user_profile` WHERE (`xf_user_profile`.`user_id` = 3472) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_atc_tc`.* FROM `xf_atc_tc` WHERE (`xf_atc_tc`.`user_id` = 3472) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_atc_tc | ALL | 1053 | Using where |
SELECT `xf_user_profile`.* FROM `xf_user_profile` WHERE (`xf_user_profile`.`user_id` = 3545) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_atc_tc`.* FROM `xf_atc_tc` WHERE (`xf_atc_tc`.`user_id` = 3545) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_atc_tc | ALL | 1053 | Using where |
SELECT `xf_user_profile`.* FROM `xf_user_profile` WHERE (`xf_user_profile`.`user_id` = 3426) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_atc_tc`.* FROM `xf_atc_tc` WHERE (`xf_atc_tc`.`user_id` = 3426) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_atc_tc | ALL | 1053 | Using where |
SELECT `xf_user_profile`.* FROM `xf_user_profile` WHERE (`xf_user_profile`.`user_id` = 3427) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_atc_tc`.* FROM `xf_atc_tc` WHERE (`xf_atc_tc`.`user_id` = 3427) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_atc_tc | ALL | 1053 | Using where |
bytes_sent | 12075 |
bytes_received | 1338729 |
packets_sent | 236 |
packets_received | 1548 |
protocol_overhead_in | 6192 |
protocol_overhead_out | 944 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 720 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 287 |
bytes_received_prepare_response_packet | 54062 |
bytes_received_change_user_packet | 1282768 |
packets_sent_command | 117 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 80 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 42 |
packets_received_prepare_response | 900 |
packets_received_change_user | 486 |
result_set_queries | 36 |
non_result_set_queries | 6 |
no_index_used | 8 |
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 | 37 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 450 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 450 |
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 | 450 |
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 | 1357 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 3223 |
proto_binary_fetched_int24 | 1516 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 12691 |
proto_binary_fetched_decimal | 46 |
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 | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 6627 |
proto_binary_fetched_blob | 3282 |
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 | 38 |
com_stmt_execute | 38 |
com_stmt_send_long_data | 0 |
com_stmt_close | 37 |
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 | 1265355 |