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` = 'huawei') 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` = 4989 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 | 564 | 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 (837995, 835573, 835020, 832284, 830055, 829634, 828718, 828037, 827936, 827464, 826378, 826070, 824278, 822225, 821645, 820491, 817713, 813420, 812379, 812298, 809311, 808103, 807592, 807389, 806191, 804831, 800783, 798928, 798868, 798399, 796902, 792352, 792269, 791636, 791593, 791003, 789803, 787516, 786299, 783637, 783207, 782470, 782112, 781835, 779685, 779667, 779091, 778859, 778064, 773026, 771203, 768708, 768404, 768390, 767821, 767325, 766825, 765639, 764944, 764207, 763982, 759710, 759664, 759392, 757149, 756676, 755449, 755385, 755381, 755143, 754863, 746933, 745539, 744344, 744340, 743955, 743727, 742295, 739962, 738514, 738380, 738121, 736504, 735933, 735675, 734654, 733549, 731870, 731753, 731689, 731167, 730950, 730590, 729396, 729099, 726120, 724516, 719249, 719121, 717635, 717336, 717235, 715568, 712505, 712222, 711459, 708681, 707970, 707903, 707896, 707724, 707414, 706737, 706483, 705915, 704940, 704260, 703958, 703573, 702861, 702625, 702318, 701279, 701227, 700801, 700504, 699994, 699514, 699351, 699350, 698809, 697186, 696551, 695840, 694040, 693251, 692860, 691564, 690710, 690620, 690124, 690117, 687892, 686395, 685620, 685285, 684629, 681348, 681128, 681015, 680935, 680472, 679404, 678574, 678432, 678314, 677584, 676869, 676807, 676247, 675712, 673290, 672491, 672334, 671728, 671214, 670805, 669636, 669553, 669492, 669005, 667905, 667322, 667258, 666793, 666472, 665527, 665466, 664642, 664443, 664055, 663896, 663769, 662252, 662047, 661785, 661388, 660771, 660688, 660220, 659246, 659142, 658775, 658351, 657883, 656477, 656031, 654898, 618789, 654594, 653979, 653765, 653384, 653372, 652904, 652560, 652559, 651444, 650996, 649888, 647258, 645646, 644606, 644047, 644005, 643431, 643257, 642886, 642751, 642554, 641985, 641777, 641600, 641595, 641545, 641362, 641241, 641174, 640417, 639673, 639347, 639207, 638984, 638468, 638128, 637972, 637908, 637756, 637720, 636973, 635594, 635491, 634529, 634116, 634055, 632629, 632487, 632259, 632228, 631924, 631849, 631776, 631059, 630793, 630725, 630650, 630633, 630582, 629605, 629540, 629237, 629069, 629012, 628898, 628753, 628644, 628377, 628356, 628311, 628200, 628090, 628086, 628083, 627662, 627143, 626500, 626297, 626296, 626262, 625906, 625451, 625186, 625051, 624885, 624881, 624876, 623879, 623870, 623800, 623405, 622889, 622810, 622320, 622219, 621442, 621329, 621083, 619688, 619367, 618625, 618459, 618432, 618162, 617710, 617464, 617291, 617224, 616894, 616529, 616348, 615794, 614787, 614630, 614193, 614159, 613947, 613871, 613765, 613008, 612501, 610874, 610808, 610445, 610441, 610157, 609958, 609292, 608483, 608408, 608206, 607657, 607342, 606945, 605543, 605258, 605000, 604070, 603709, 602766, 601772, 600618, 600346, 599961, 598855, 598590, 598537, 597474, 595807, 595326, 594972, 594705, 593938, 593127, 593086, 592851, 592833, 586861, 586232, 585564, 585139, 584959, 582672, 581300, 580567, 578661, 578276, 577562, 577504, 577214, 577206, 576900, 576898, 576510, 573468, 571667, 570415, 569269, 567907, 567868, 567376, 565966, 564294, 561986, 561566, 560980, 560843, 560790, 559358, 556898, 556212, 555617, 554784, 553822, 553561, 552306, 551891, 550626, 549955, 549890, 549594, 548876, 548724, 547888, 547799, 547396, 547231, 547197, 546954, 546706, 545716, 545676, 545266, 545199, 544850, 544584, 544083, 543016, 542531, 541970, 541950, 540887, 540081, 539450, 538642, 538597, 538069, 537656, 536606, 536383, 535668, 535629, 535276, 533918, 533507, 532528, 532391, 531957, 531084, 530870, 530661, 530442, 530440, 530301, 529795, 528801, 526673, 525680, 525287, 524624, 524428, 523622, 522963, 522976, 522768, 522739, 522266, 521833, 521730, 521595, 521101, 521087, 520972, 520756, 520065, 520032, 519574, 519552, 518587, 518330, 518088, 517910, 517777, 517312, 499222, 516887, 515942, 515912, 515517, 515427, 515326, 514500, 512539, 511588, 511218, 510545, 510222, 510013, 509940, 509517, 509502, 509409, 508803, 508625, 504798, 504478, 504456, 504363, 504279, 504163, 503917, 501588, 501136, 499000, 498601, 498175, 497399, 496640, 495845, 495836, 495385, 493858, 493412, 492765, 492376, 490174, 482662, 482056, 482005, 481201, 479581, 479541, 479538, 479537, 479536, 479535, 479477, 479454, 479352, 479140, 478820, 477382, 475951, 475950, 475097, 473666, 469205, 468081, 467923, 466057, 466046, 464144, 460287, 459968, 456619, 456095))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | 545 | 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 (795))
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` = 670333
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 |
bytes_sent | 19313 |
bytes_received | 1964264 |
packets_sent | 236 |
packets_received | 2443 |
protocol_overhead_in | 9772 |
protocol_overhead_out | 944 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 918 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 328 |
bytes_received_prepare_response_packet | 73620 |
bytes_received_change_user_packet | 1888489 |
packets_sent_command | 117 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 102 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 42 |
packets_received_prepare_response | 1088 |
packets_received_change_user | 1171 |
result_set_queries | 36 |
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 | 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 | 1135 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 1135 |
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 | 1135 |
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 | 2884 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 10129 |
proto_binary_fetched_int24 | 4299 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 40673 |
proto_binary_fetched_decimal | 29 |
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 | 18807 |
proto_binary_fetched_blob | 8665 |
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 | 1841454 |