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', '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 | 38 | 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_node`.* FROM `xf_node` WHERE (`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 | ALL | display_in_list | 591 | Using where; Using filesort |
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 (772, 93, 13, 555, 271, 15, 551, 554, 91, 737, 164, 471, 472, 532, 75, 76, 77, 78, 79, 97, 80, 81, 82, 83, 84, 96, 87, 88, 571, 90, 95, 255, 128, 129, 130, 131, 132, 141, 142, 143, 144, 145, 159, 160, 163, 162, 161, 169, 168, 171, 167, 170, 429, 425, 426, 427, 428, 190, 191, 192, 193, 194, 198, 199, 200, 201, 202, 204, 205, 206, 207, 208, 214, 215, 216, 217, 218, 226, 227, 228, 229, 230, 220, 221, 222, 223, 224, 453, 454, 455, 456, 457, 238, 239, 240, 241, 242, 251, 257, 252, 253, 254, 275, 276, 277, 278, 279, 302, 303, 304, 305, 308, 309, 310, 311, 312, 323, 324, 325, 326, 375, 334, 335, 336, 337, 338, 356, 357, 358, 359, 494, 365, 361, 362, 363, 364, 381, 382, 383, 384, 388, 389, 390, 391, 392, 394, 395, 396, 397, 398, 400, 401, 402, 403, 404, 408, 409, 410, 411, 412, 440, 441, 442, 443, 444, 446, 447, 448, 449, 450, 459, 460, 461, 462, 463, 466, 467, 468, 469, 470, 120, 477, 478, 479, 480, 481, 485, 486, 487, 488, 489, 499, 500, 501, 502, 503, 506, 507, 508, 509, 510, 512, 513, 514, 515, 516, 520, 521, 522, 523, 524, 527, 528, 529, 530, 531, 540, 541, 542, 543, 544, 546, 548, 549, 550, 661, 565, 566, 567, 568, 569, 575, 576, 577, 578, 579, 587, 588, 589, 590, 591, 599, 600, 601, 602, 607, 608, 609, 610, 611, 621, 622, 623, 624, 625, 627, 628, 629, 630, 631, 634, 635, 636, 637, 638, 640, 641, 642, 643, 644, 647, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657, 663, 664, 665, 666, 667, 669, 670, 671, 672, 673, 677, 678, 679, 680, 681, 685, 686, 687, 688, 689, 691, 692, 693, 694, 695, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 708, 710, 711, 712, 713, 714, 717, 718, 719, 720, 721, 723, 724, 725, 726, 727, 731, 732, 733, 734, 735, 740, 741, 742, 743, 744, 750, 746, 747, 748, 749, 752, 753, 754, 755, 756, 759, 760, 761, 762, 763, 766, 767, 768, 769, 770, 102, 116, 117, 118, 659, 604, 371, 372, 373, 377, 378, 379, 418, 419, 431, 432, 433, 451, 491, 492, 493, 496, 497, 535, 536, 537, 593, 594, 595, 583, 584, 585, 558, 560, 562, 605, 547, 613, 614, 617, 618, 619, 729, 8, 24, 25, 773, 474, 473, 774, 26, 11, 122, 9, 32, 33, 34, 437, 35, 517, 19, 764, 22, 12, 58, 59, 60, 775, 61, 438, 258, 14, 30, 66, 68, 675, 49, 65, 133, 518, 111, 112, 113, 20, 21, 314, 16, 316, 50, 51, 52, 53, 54, 55, 56, 57, 18, 36, 212, 42, 172, 173, 174, 175, 17, 31, 23, 320, 525, 317, 318, 319, 321, 553, 43, 44, 45, 46, 47, 98, 776, 176, 177, 178, 179, 180, 181, 29, 134, 135, 136, 137, 138, 139))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | PRIMARY | 611 | Using where | |||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_forum.last_thread_id | 1 |
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 (10, 7, 114, 272, 3, 280, 5, 6, 4))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | 13 | Using where; Using index | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_category.node_id | 1 |
SELECT content_id, cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 1356 | Using where |
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_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.* FROM `xf_siropu_ads_manager_ad` LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`) LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`)) WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active') ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_siropu_ads_manager_ad | ALL | type,status,status_display_order | 13 | Using where; Using filesort | |||
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
SELECT SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total, SUM(IF(user_id > 0, 1, 0)) AS members, SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests FROM xf_session_activity WHERE view_date >= ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | 112 | Using where |
SELECT `xf_session_activity`.*, `xf_user_User_1`.* FROM `xf_session_activity` INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`) WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1716132856) ORDER BY `xf_session_activity`.`view_date` DESC LIMIT 50
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | PRIMARY | 4 | 3 | Using where; Using filesort | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | nailclub_xfdb.xf_session_activity.user_id | 1 | Using where |
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.* FROM `xf_thread` FORCE INDEX (`last_post_date`) 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_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`) WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1713541756) ORDER BY `xf_thread`.`last_post_date` DESC LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | 658 | Using where | |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nailclub_xfdb.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.last_post_user_id | 1 |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('forumStatistics')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.* FROM `xf_profile_post` USE INDEX (`post_date`) LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`) WHERE (`xf_profile_post`.`message_state` = 'visible') ORDER BY `xf_profile_post`.`post_date` DESC LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | index | post_date | 4 | 10 | Using where | ||
SIMPLE | xf_user_ProfileUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_profile_post.profile_user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_user_ProfileUser_1.user_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_profile_post.user_id | 1 |
SELECT `xf_user_profile`.* FROM `xf_user_profile` WHERE (`xf_user_profile`.`user_id` = 14696) 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_user_ban`.*, `xf_user_User_1`.* FROM `xf_user_ban` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_ban`.`user_id`) WHERE (`xf_user_ban`.`user_id` = 94759) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user_ban`.*, `xf_user_User_1`.* FROM `xf_user_ban` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_ban`.`user_id`) WHERE (`xf_user_ban`.`user_id` = 94634) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | 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 `xf_bs_fsp_tab_group`.* FROM `xf_bs_fsp_tab_group` ORDER BY `xf_bs_fsp_tab_group`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bs_fsp_tab_group | ALL | 2 | Using filesort |
SELECT `xf_bs_fsp_tab`.*, `xf_addon_AddOn_1`.*, `xf_bs_fsp_tab_group_Group_2`.*, `xf_addon_AddOn_3`.* FROM `xf_bs_fsp_tab` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bs_fsp_tab`.`addon_id`) LEFT JOIN `xf_bs_fsp_tab_group` AS `xf_bs_fsp_tab_group_Group_2` ON (`xf_bs_fsp_tab_group_Group_2`.`group_id` = `xf_bs_fsp_tab`.`group_id`) LEFT JOIN `xf_addon` AS `xf_addon_AddOn_3` ON (`xf_addon_AddOn_3`.`addon_id` = `xf_bs_fsp_tab_group_Group_2`.`addon_id`) WHERE (`xf_bs_fsp_tab`.`group_id` = 'members') ORDER BY `xf_bs_fsp_tab`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bs_fsp_tab | ALL | group_id | 8 | Using where; Using filesort | |||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | nailclub_xfdb.xf_bs_fsp_tab.addon_id | 1 | |
SIMPLE | xf_bs_fsp_tab_group_Group_2 | const | PRIMARY | PRIMARY | 27 | const | 1 | Using where |
SIMPLE | xf_addon_AddOn_3 | eq_ref | PRIMARY | PRIMARY | 52 | nailclub_xfdb.xf_bs_fsp_tab_group_Group_2.addon_id | 1 | Using where |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('fspTabDefinitions')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `xf_addon`.* FROM `xf_addon` WHERE (`xf_addon`.`addon_id` = 'BS/FSPTabs') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | const | 1 |
SELECT `xf_bs_fsp_tab`.*, `xf_addon_AddOn_1`.*, `xf_bs_fsp_tab_group_Group_2`.*, `xf_addon_AddOn_3`.* FROM `xf_bs_fsp_tab` LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bs_fsp_tab`.`addon_id`) LEFT JOIN `xf_bs_fsp_tab_group` AS `xf_bs_fsp_tab_group_Group_2` ON (`xf_bs_fsp_tab_group_Group_2`.`group_id` = `xf_bs_fsp_tab`.`group_id`) LEFT JOIN `xf_addon` AS `xf_addon_AddOn_3` ON (`xf_addon_AddOn_3`.`addon_id` = `xf_bs_fsp_tab_group_Group_2`.`addon_id`) WHERE (`xf_bs_fsp_tab`.`group_id` = 'threads') ORDER BY `xf_bs_fsp_tab`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bs_fsp_tab | ALL | group_id | 8 | Using where; Using filesort | |||
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | nailclub_xfdb.xf_bs_fsp_tab.addon_id | 1 | |
SIMPLE | xf_bs_fsp_tab_group_Group_2 | const | PRIMARY | PRIMARY | 27 | const | 1 | Using where |
SIMPLE | xf_addon_AddOn_3 | eq_ref | PRIMARY | PRIMARY | 52 | nailclub_xfdb.xf_bs_fsp_tab_group_Group_2.addon_id | 1 | Using where |
SELECT `xf_addon`.* FROM `xf_addon` WHERE (`xf_addon`.`addon_id` = 'BS/FSPTabs') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') ORDER BY `xf_user`.`register_date` DESC LIMIT 15
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | index | user_state | register_date | 4 | 30 | Using where |
SELECT `xf_thread`.* FROM `xf_thread` WHERE (`xf_thread`.`discussion_state` = 'visible') ORDER BY `xf_thread`.`is_sticked` DESC, `xf_thread`.`sticked_order` ASC, `xf_thread`.`last_post_date` DESC LIMIT 30
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ALL | 22680 | Using where; Using filesort |
SELECT `xf_bs_fsptabs_sticked_link`.* FROM `xf_bs_fsptabs_sticked_link` ORDER BY `xf_bs_fsptabs_sticked_link`.`sticked_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_bs_fsptabs_sticked_link | ALL | 1 | Using filesort |
bytes_sent | 25527 |
bytes_received | 1945537 |
packets_sent | 322 |
packets_received | 4220 |
protocol_overhead_in | 16880 |
protocol_overhead_out | 1288 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 801 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 334 |
bytes_received_prepare_response_packet | 180325 |
bytes_received_change_user_packet | 1762856 |
packets_sent_command | 160 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 89 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 55 |
packets_received_prepare_response | 2153 |
packets_received_change_user | 1868 |
result_set_queries | 52 |
non_result_set_queries | 3 |
no_index_used | 10 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 52 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 52 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 1816 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 1816 |
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 | 1816 |
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 | 8114 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 9569 |
proto_binary_fetched_int24 | 3518 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 34819 |
proto_binary_fetched_decimal | 98 |
proto_binary_fetched_float | 12 |
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 | 15690 |
proto_binary_fetched_blob | 7135 |
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 | 53 |
com_stmt_execute | 53 |
com_stmt_send_long_data | 0 |
com_stmt_close | 52 |
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 | 1715959 |