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 data_key, data_value FROM xf_data_registry WHERE data_key IN ('nfTicketCounts')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `xf_nf_tickets_status`.* FROM `xf_nf_tickets_status` WHERE (`xf_nf_tickets_status`.`active` = 1) AND (`xf_nf_tickets_status`.`include_in_counts` = 1) ORDER BY `xf_nf_tickets_status`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_nf_tickets_status | ALL | 3 | Using where; Using filesort |
SELECT `xf_nf_tickets_ticket`.* FROM `xf_nf_tickets_ticket` WHERE (`xf_nf_tickets_ticket`.`status_id` IN (1))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_nf_tickets_ticket | ALL | 2942 | Using where |
SELECT `xf_nf_tickets_category`.* FROM `xf_nf_tickets_category` WHERE (`xf_nf_tickets_category`.`ticket_category_id` = 5) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_nf_tickets_category | const | PRIMARY,parent_category_id_lft | PRIMARY | 4 | const | 1 |
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 |
SELECT `xf_nf_tickets_category`.* FROM `xf_nf_tickets_category` WHERE (`xf_nf_tickets_category`.`ticket_category_id` = 4) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_nf_tickets_category | const | PRIMARY,parent_category_id_lft | PRIMARY | 4 | const | 1 |
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 |
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_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.* FROM `xf_user` LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user`.`user_id` = '2564') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_3 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_nf_tickets_kb_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_nf_tickets_kb_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'nf_tickets_kb_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_nf_tickets_kb_category`.`kb_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') ORDER BY `xf_nf_tickets_kb_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_nf_tickets_kb_category | ALL | 1 | Using filesort | ||||
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chnkfctry.xf_nf_tickets_kb_category.kb_category_id | 1 | Using where |
SELECT `xf_nf_tickets_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_nf_tickets_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'nf_tickets_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_nf_tickets_category`.`ticket_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') ORDER BY `xf_nf_tickets_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_nf_tickets_category | ALL | 6 | Using filesort | ||||
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chnkfctry.xf_nf_tickets_category.ticket_category_id | 1 | Using where |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.* 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_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | 1 | |||||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.xf_forum.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chnkfctry.xf_node_Node_1.node_id | 1 | Using where |
SELECT `cf_category`.*, `xf_permission_cache_content_Permissions_1`.* FROM `cf_category` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'product_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `cf_category`.`product_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') ORDER BY `cf_category`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_category | ALL | 52 | Using filesort | ||||
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chnkfctry.cf_category.product_category_id | 1 | Using where |
SELECT `xf_alff_field_index`.*, `cf_product_ContentEntity_1`.*, `cf_product_field_FieldEntity_2`.* FROM `xf_alff_field_index` LEFT JOIN `cf_product` AS `cf_product_ContentEntity_1` ON (`cf_product_ContentEntity_1`.`product_id` = `xf_alff_field_index`.`content_id`) LEFT JOIN `cf_product_field` AS `cf_product_field_FieldEntity_2` ON (`cf_product_field_FieldEntity_2`.`field_id` = `xf_alff_field_index`.`field_id`) WHERE (`xf_alff_field_index`.`field_index_id` IN (21794, 22136, 22137, 22138, 23032, 23033, 23034, 24408, 24409, 24410, 13608, 13609, 13610, 13632, 13633, 13634, 14032, 14033, 14034, 14288, 14289, 14290, 14360, 14361, 14362, 14448, 14449, 14450, 14480, 14481, 14482, 14496, 14497, 14498, 14504, 14505, 14506, 14552, 14553, 14554, 17208, 17209, 17592, 17593, 18648, 18649, 18936, 18937, 18944, 18945, 18946, 19968, 19969, 19970, 21792, 21793, 13056, 13057, 13432, 13433, 13448, 13449, 13456, 13457, 13560, 13561, 13672, 13673, 21440, 21441, 21448, 21449, 22744, 22745, 37627, 37621, 37622, 37623, 37624, 37625, 37626, 37628, 37629, 37591, 37609, 37618, 37573, 37564, 37551, 37553, 37600, 37582, 37612, 37613, 37614, 37615, 37616, 37617, 37619, 37620, 37603, 37604, 37605, 37606, 37607, 37608, 37610, 37611, 37594, 37595, 37596, 37597, 37598, 37599, 37601, 37602, 37585, 37586, 37587, 37588, 37589, 37590, 37592, 37593, 37576, 37577, 37578, 37579, 37580, 37581, 37583, 37584, 37567, 37568, 37569, 37570, 37571, 37572, 37574, 37575, 37555, 37558, 37559, 37560, 37561, 37562, 37563, 37565, 37566, 37549, 37550, 37552, 37554, 37556, 37557, 13959, 34619, 14348, 14349, 14351, 34618, 15187, 15188, 15191, 34617, 17092, 17093, 17095, 34615, 17575, 18927, 34614, 20479, 34611, 21927, 34610, 22151, 34609, 15151, 34597, 16452, 16453, 16455, 34595, 16463, 34594, 17311, 19743, 20903, 21183, 22935, 34591, 23855, 34590, 24351, 24711, 12839, 34584, 12868, 12869, 12871, 34583, 13028, 13029, 13031, 34555, 13508, 13509, 13511, 34553, 13567, 14020, 14021, 14023, 14772, 14773, 14775, 34552, 15972, 15973, 15975, 34550, 16604, 16605, 16607, 34549, 21919, 34545, 22095, 34544, 22527, 34543, 22727, 34542, 23383, 34541, 22807, 34540, 23119, 23983, 34538, 13263, 34448, 14015, 34446, 15183, 34444, 18183, 34442, 22927, 34441, 21911, 34437, 23023, 34436, 23375, 34431, 15460, 15461, 15463, 34428, 23716, 23717, 23719, 34424, 13575, 19988, 19989, 19991, 34421, 15012, 15013, 15015, 34420, 12852, 12853, 12855, 34417, 17735, 34409, 17892, 17893, 17895, 34390, 13455, 13559, 13055, 13671, 34371, 13431, 13447)) AND (`xf_alff_field_index`.`content_type` = 'product')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_alff_field_index | range | PRIMARY | PRIMARY | 4 | 291 | Using where | |
SIMPLE | cf_product_ContentEntity_1 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.xf_alff_field_index.content_id | 1 | |
SIMPLE | cf_product_field_FieldEntity_2 | eq_ref | PRIMARY | PRIMARY | 27 | chnkfctry.xf_alff_field_index.field_id | 1 |
SELECT `cf_product`.*, `cf_category_Category_1`.*, `cf_product_update_Description_2`.*, `xf_user_User_3`.*, `cf_product_version_CurrentVersion_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `cf_product` LEFT JOIN `cf_category` AS `cf_category_Category_1` ON (`cf_category_Category_1`.`product_category_id` = `cf_product`.`product_category_id`) LEFT JOIN `cf_product_update` AS `cf_product_update_Description_2` ON (`cf_product_update_Description_2`.`product_update_id` = `cf_product`.`description_update_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `cf_product`.`user_id`) LEFT JOIN `cf_product_version` AS `cf_product_version_CurrentVersion_4` ON (`cf_product_version_CurrentVersion_4`.`product_version_id` = `cf_product`.`current_version_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'product_category' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `cf_category_Category_1`.`product_category_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`cf_product`.`product_id` IN (3534, 3533, 3532, 3531, 3530, 3529, 3528, 3527, 3526))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_product | range | PRIMARY | PRIMARY | 4 | 9 | Using where | |
SIMPLE | cf_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.product_category_id | 1 | |
SIMPLE | cf_product_update_Description_2 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.description_update_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.user_id | 1 | |
SIMPLE | cf_product_version_CurrentVersion_4 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.current_version_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chnkfctry.cf_category_Category_1.product_category_id | 1 | Using where |
SELECT `cf_product`.*, `cf_category_Category_1`.*, `cf_product_update_Description_2`.*, `xf_user_User_3`.*, `cf_product_version_CurrentVersion_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `cf_product` LEFT JOIN `cf_category` AS `cf_category_Category_1` ON (`cf_category_Category_1`.`product_category_id` = `cf_product`.`product_category_id`) LEFT JOIN `cf_product_update` AS `cf_product_update_Description_2` ON (`cf_product_update_Description_2`.`product_update_id` = `cf_product`.`description_update_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `cf_product`.`user_id`) LEFT JOIN `cf_product_version` AS `cf_product_version_CurrentVersion_4` ON (`cf_product_version_CurrentVersion_4`.`product_version_id` = `cf_product`.`current_version_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'product_category' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `cf_category_Category_1`.`product_category_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`cf_product`.`product_id` IN (3534, 3533, 3532, 3531, 3530, 3529, 3528, 3527, 3526))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_product | range | PRIMARY | PRIMARY | 4 | 9 | Using where | |
SIMPLE | cf_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.product_category_id | 1 | |
SIMPLE | cf_product_update_Description_2 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.description_update_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.user_id | 1 | |
SIMPLE | cf_product_version_CurrentVersion_4 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.current_version_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chnkfctry.cf_category_Category_1.product_category_id | 1 | Using where |
-- XFDB=noForceAllWrite INSERT INTO xf_session_activity (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date), robot_key = VALUES(robot_key)
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('cfProductFields')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3534) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3533) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3532) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3531) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3530) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3529) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3528) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3527) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_product_feature`.* FROM `cf_product_feature` WHERE (`cf_product_feature`.`product_id` = 3526) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `cf_category`.* FROM `cf_category` WHERE (`cf_category`.`depth` = 0) ORDER BY `cf_category`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_category | ALL | 52 | Using where; Using filesort |
SELECT `cf_category`.* FROM `cf_category` WHERE (`cf_category`.`depth` = 1) AND (`cf_category`.`parent_category_id` = 27) ORDER BY `cf_category`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_category | ref | parent_category_id_lft | parent_category_id_lft | 4 | const | 3 | Using where; Using filesort |
SELECT `cf_category`.* FROM `cf_category` WHERE (`cf_category`.`depth` = 1) AND (`cf_category`.`parent_category_id` = 45) ORDER BY `cf_category`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_category | ref | parent_category_id_lft | parent_category_id_lft | 4 | const | 4 | Using where; Using filesort |
SELECT `cf_category`.* FROM `cf_category` WHERE (`cf_category`.`depth` = 1) AND (`cf_category`.`parent_category_id` = 28) ORDER BY `cf_category`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_category | ref | parent_category_id_lft | parent_category_id_lft | 4 | const | 9 | Using where; Using filesort |
SELECT `cf_category`.* FROM `cf_category` WHERE (`cf_category`.`depth` = 1) AND (`cf_category`.`parent_category_id` = 55) ORDER BY `cf_category`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_category | ref | parent_category_id_lft | parent_category_id_lft | 4 | const | 3 | Using where; Using filesort |
SELECT `cf_cart`.* FROM `cf_cart` WHERE (`cf_cart`.`user_id` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_cart | ALL | 1050 | Using where |
SELECT `cf_cart`.* FROM `cf_cart` WHERE (`cf_cart`.`user_id` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | cf_cart | ALL | 1050 | Using where |
-- XFDB=noForceAllWrite INSERT INTO xf_session (session_id, session_data, expiry_date) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE session_data = VALUES(session_data), expiry_date = VALUES(expiry_date)
bytes_sent | 29638 |
bytes_received | 924597 |
packets_sent | 424 |
packets_received | 3366 |
protocol_overhead_in | 13464 |
protocol_overhead_out | 1696 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1296 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 384 |
bytes_received_prepare_response_packet | 189282 |
bytes_received_change_user_packet | 732061 |
packets_sent_command | 211 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 144 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 72 |
packets_received_prepare_response | 2516 |
packets_received_change_user | 562 |
result_set_queries | 68 |
non_result_set_queries | 4 |
no_index_used | 9 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 68 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 69 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 494 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 494 |
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 | 494 |
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 | 702 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 2144 |
proto_binary_fetched_int24 | 403 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 10590 |
proto_binary_fetched_decimal | 99 |
proto_binary_fetched_float | 1236 |
proto_binary_fetched_double | 618 |
proto_binary_fetched_date | 1164 |
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 | 7363 |
proto_binary_fetched_blob | 2481 |
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 | 70 |
com_stmt_execute | 70 |
com_stmt_send_long_data | 0 |
com_stmt_close | 69 |
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 | 714247 |