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` = 'turkiye') 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` = 59 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 20000
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 | 526 | 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 (828779, 827807, 811639, 810437, 809421, 809418, 807578, 807378, 807118, 807041, 807029, 806706, 806701, 806042, 805570, 805537, 805121, 804345, 804150, 804049, 803720, 801794, 794102, 784763, 781680, 777600, 777543, 776511, 775334, 774987, 774642, 772304, 767252, 763575, 761515, 761414, 761097, 761019, 760917, 760837, 760060, 759577, 756948, 755117, 755023, 754359, 753899, 753779, 753542, 750751, 742182, 741204, 740030, 739115, 738886, 737697, 735764, 734989, 732087, 731803, 731354, 729845, 729362, 728404, 726881, 726475, 722296, 721119, 713434, 709490, 709105, 708669, 708047, 704930, 704387, 702263, 701811, 700680, 700578, 700360, 698474, 697993, 697743, 697011, 695558, 695211, 694693, 694651, 694239, 694193, 693085, 692682, 692123, 692065, 691652, 690977, 690907, 690715, 690402, 688888, 687954, 687200, 686988, 686927, 686775, 683407, 683258, 681630, 679723, 677472, 671420, 667408, 667087, 665416, 664324, 664233, 663089, 662825, 661189, 659532, 659410, 659352, 659289, 658874, 657441, 657223, 655798, 655705, 654837, 654389, 653951, 653661, 653660, 653461, 653126, 653124, 652999, 652583, 652334, 649938, 648203, 648057, 647331, 646911, 644642, 644348, 643986, 643845, 642396, 641930, 639186, 638988, 637644, 632573, 632445, 632244, 629761, 628818, 628596, 623783, 622392, 621097, 619022, 618530, 617372, 617019, 616328, 616327, 616314, 616312, 616310, 616215, 616214, 616208, 616173, 616171, 616167, 614932, 614916, 614807, 614200, 610323, 606902, 606444, 606239, 605472, 605010, 604016, 603757, 603520, 602171, 600666, 600559, 599789, 599696, 597070, 594611, 593448, 592818, 588276, 586917, 585569, 582253, 581933, 579005, 578989, 578982, 577168, 575382, 574881, 573752, 570377, 569839, 569838, 569835, 569708, 569315, 568969, 567936, 567398, 567007, 566662, 564538, 564536, 564535, 564155, 563051, 562848, 562781, 561092, 560496, 559243, 559235, 557398, 552323, 552301, 551059, 545056, 543786, 543641, 542984, 542172, 541893, 541318, 540460, 539792, 539779, 539316, 539313, 539289, 533567, 533258, 531926, 531707, 531149, 529900, 529618, 529037, 528082, 526507, 525870, 525074, 524896, 524386, 524175, 523880, 522743, 522735, 522722, 522579, 522565, 522436, 522435, 522429, 521873, 521872, 521823, 521790, 521788, 521273, 521151, 520819, 520760, 520320, 520307, 520084, 519191, 518099, 517828, 517540, 517533, 517460, 517459, 517346, 517345, 517292, 517198, 517181, 517174, 517038, 516790, 516299, 514209, 513875, 513870, 513850, 512813, 512270, 512146, 511461, 510829, 510759, 509684, 509617, 509210, 509105, 509023, 508784, 508584, 508203, 508057, 507658, 507657, 507577, 505317, 505067, 504811, 504733, 504443, 504016, 503405, 503363, 503026, 502906, 502724, 502722, 501567, 501320, 501270, 500807, 500786, 500770, 500622, 500554, 500553, 500530, 500520, 500434, 500411, 500394, 500326, 500213, 500119, 500106, 500007, 499886, 499746, 499491, 499351, 499216, 499209, 499063, 499004, 498999, 498998, 498992, 498978, 498976, 498971, 498943, 498930, 498920, 498879, 498853, 498850, 498846, 498845, 498844, 498843, 498779, 498742, 498707, 498704, 498703, 498702, 498639, 498635, 498634, 498627, 498618, 498611, 498602, 498534, 498222, 498095, 498094, 497891, 497858, 497851, 497825, 497821, 497403, 497395, 497349, 497077, 496803, 496795, 496792, 496706, 496540, 496290, 496282, 496167, 496137, 496130, 495187, 495049, 494017, 493838, 492696, 492689, 492688, 492593, 492578, 492559, 492547, 492481, 492475, 491817, 491645, 491531, 491517, 491516, 491512, 491345, 491095, 491090, 491013, 490184, 488425, 486520, 486272, 485718, 484340, 484073, 484069, 484052, 482283, 477423, 477347, 476787, 472463, 470938, 470683, 469464, 468177, 466997, 466934, 466752, 466297, 466253, 466238, 466163, 465418, 463359, 462712, 462490, 462446, 462417, 462291, 461958, 461847, 461823, 461726, 461688, 461391, 460848, 460845, 460843, 460089, 459640, 459639, 457532, 457123, 456879, 455856, 455820, 455318, 454481, 454200, 453895, 453894, 453888, 453357, 453203, 452930, 452798, 452264, 451980, 451970, 451663, 451435, 451172, 451048, 451035, 447117, 400503, 376991, 170926))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | 509 | Using where | |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sdn_xenforo.xf_node_Node_2.node_id | 1 | Using where |
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.* FROM `xf_mg_media_item` LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`) LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`) WHERE (`xf_mg_media_item`.`media_id` IN (993))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mg_media_item | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_attachment_Attachment_4.data_id | 1 | Using where |
SELECT cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ? AND content_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
BEGIN
UPDATE `xf_tag_result_cache` SET `expiry_date` = ? WHERE `result_cache_id` = 670318
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 |
bytes_sent | 20729 |
bytes_received | 2594618 |
packets_sent | 308 |
packets_received | 2599 |
protocol_overhead_in | 10396 |
protocol_overhead_out | 1232 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1242 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 388 |
bytes_received_prepare_response_packet | 79056 |
bytes_received_change_user_packet | 2512771 |
packets_sent_command | 153 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 138 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 54 |
packets_received_prepare_response | 1232 |
packets_received_change_user | 1123 |
result_set_queries | 48 |
non_result_set_queries | 6 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 48 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 49 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 1075 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 1075 |
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 | 1075 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 2 |
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 | 1293 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 9669 |
proto_binary_fetched_int24 | 4075 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 38589 |
proto_binary_fetched_decimal | 35 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 2 |
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 | 18113 |
proto_binary_fetched_blob | 8162 |
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 | 50 |
com_stmt_execute | 50 |
com_stmt_send_long_data | 0 |
com_stmt_close | 49 |
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 | 2467547 |