Memory usage: real: 52690944, emalloc: 51346048

Executed 1998 queries in 0.8979754447937 seconds
Average query length: 0.00044943715955641 seconds
Queries per second: 2225.005161983
Longest query length: 0.031821966171265
Longest query: 
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 4)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 4)
LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='4' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('217', '138', '241', '223', '224', '313', '242', '243', '244', '232', '245', '246', '314', '231', '315', '191', '249', '317', '316', '318', '250', '151', '251', '234', '252', '146', '319', '253', '228', '320', '255', '164', '150', '153', '161', '229', '321', '259', '162', '218', '163', '322', '323', '324', '260', '154', '237', '248', '147', '148', '325', '326', '327', '328', '329', '330', '331', '332', '333', '334', '335', '336', '337', '338', '339', '140', '181', '183', '290', '293', '182', '184', '221', '292', '139', '157', '358', '359', '308', '360', '307', '172', '361', '170', '212', '362', '168', '363', '364', '365', '173', '366', '171', '167', '367', '174', '368', '369', '176', '165', '370', '371', '372', '373', '374', '180', '299', '375', '376', '414', '166', '377', '378', '143', '204', '379', '380', '381', '205', '207', '382', '383', '384', '438', '142', '284', '285', '286', '344', '345', '346', '347', '348', '349', '199', '266', '268', '267', '350', '351', '352', '196', '194', '278', '340', '341', '342', '309', '353', '354', '355', '356', '357', '310', '343', '169', '385', '388', '389', '390', '391', '392', '393', '394', '395', '396', '397', '386', '398', '399', '400', '401', '402', '403', '387', '404', '405', '406', '439', '453', '454', '456', '455', '312', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '458', '433', '440', '442', '443', '444', '445', '446', '447', '448', '449', '450', '451', '452')) AND (`e`.`entity_id` NOT IN('427', '428', '429', '430', '431', '432')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')