Customer Service 1-800-328-9090

Every Order Helps Improve a Life.  Lives Improved: 19,578
 
SPECIAL!
FREE SHIPPING on orders over $49
McAfee SECURE sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
TRUSTe online privacy certification
[profiler]
Memory usage: real: 4194304, emalloc: 7100016
Code ProfilerTimeCntEmallocRealMem
Executed 56 queries in 0.12455105781555 seconds
Average query length: 0.0022241260324206 seconds
Queries per second: 449.61480843407
Longest query length: 0.023751974105835
Longest query:
SELECT `e`.*, IF(_table_name.value_id>0, _table_name.value, _table_name_default.value) AS `name`, IF(_table_is_active.value_id>0, _table_is_active.value, _table_is_active_default.value) AS `is_active`, IF(_table_include_in_menu.value_id>0, _table_include_in_menu.value, _table_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` LEFT JOIN `catalog_category_entity_varchar` AS `_table_name_default` ON (_table_name_default.entity_id = e.entity_id) AND (_table_name_default.attribute_id='33') AND _table_name_default.store_id=0 LEFT JOIN `catalog_category_entity_varchar` AS `_table_name` ON (_table_name.entity_id = e.entity_id) AND (_table_name.attribute_id='33') AND (_table_name.store_id='1') INNER JOIN `catalog_category_entity_int` AS `_table_is_active_default` ON (_table_is_active_default.entity_id = e.entity_id) AND (_table_is_active_default.attribute_id='34') AND _table_is_active_default.store_id=0 LEFT JOIN `catalog_category_entity_int` AS `_table_is_active` ON (_table_is_active.entity_id = e.entity_id) AND (_table_is_active.attribute_id='34') AND (_table_is_active.store_id='1') INNER JOIN `catalog_category_entity_int` AS `_table_include_in_menu_default` ON (_table_include_in_menu_default.entity_id = e.entity_id) AND (_table_include_in_menu_default.attribute_id='105') AND _table_include_in_menu_default.store_id=0 LEFT JOIN `catalog_category_entity_int` AS `_table_include_in_menu` ON (_table_include_in_menu.entity_id = e.entity_id) AND (_table_include_in_menu.attribute_id='105') AND (_table_include_in_menu.store_id='1') 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.product_id IS NULL AND core_url_rewrite.store_id="1" AND id_path LIKE "category/%") WHERE (e.entity_type_id = '3') AND (e.entity_id in ('5', '389', '111', '382', '383', '11', '15', '112', '114', '115', '117', '116', '16', '119', '120', '391', '17', '121', '122', '123', '124', '125', '126', '127', '128', '129', '12', '397', '131', '132', '130', '133', '134', '135', '436', '136', '137', '409', '138', '405', '139', '140', '141', '142', '147', '143', '144', '145', '146', '149', '148', '150', '151', '152', '18', '401', '153', '154', '155', '156', '245', '157', '158', '113', '160', '159', '161', '385', '162', '164', '22', '165', '166', '167', '168', '169', '170', '171', '172', '174', '21', '402', '175', '176', '177', '179', '178', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '173', '190', '191', '192', '194', '39', '437', '195', '196', '197', '13', '198', '199', '200', '201', '202', '203', '204', '205', '206', '23', '208', '209', '210', '211', '395', '24', '212', '213', '214', '215', '216', '217', '218', '25', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '26', '233', '404', '234', '235', '236', '237', '238', '410', '239', '240', '241', '242', '243', '244', '248', '249', '250', '251', '252', '253', '254', '255', '256', '257', '406', '28', '258', '259', '260', '261', '393', '262', '264', '265', '267', '268', '269', '3', '270', '29', '392', '272', '273', '274', '403', '275', '276', '277', '278', '30', '279', '280', '281', '282', '283', '284', '31', '285', '286', '388', '287', '288', '394', '193', '289', '290', '434', '291', '292', '293', '294', '295', '296', '297', '163', '299', '300', '301', '399', '304', '302', '32', '303', '247', '306', '298', '307', '266', '309', '310', '311', '312', '313', '396', '314', '34', '315', '316', '317', '318', '319', '320', '398', '321', '322', '323', '324', '325', '326', '327', '328', '329', '330', '331', '332', '333', '334', '335', '336', '83', '337', '338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '435', '350', '351', '352', '353', '354', '355', '438', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366', '367', '368', '369', '370', '371', '372', '373', '374', '375', '376', '400', '377', '378', '379', '380', '381', '408', '7', '413', '411', '414', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '433', '8', '40', '41', '43', '44', '45', '46', '91', '47', '48', '49', '64', '50', '95', '94', '93', '107', '51', '52', '53', '54', '55', '56', '96', '57', '58', '59', '60', '61', '62', '92', '70', '71', '98', '65', '66', '99', '100', '72', '108', '390', '73', '84', '101', '74', '75', '102', '103', '76', '77', '104', '78', '79', '97', '105', '80', '81', '82', '109', '85', '86', '87', '88', '110', '89', '106', '90', '9', '10')) AND (IF(_table_is_active.value_id>0, _table_is_active.value, _table_is_active_default.value) = '1') AND (IF(_table_include_in_menu.value_id>0, _table_include_in_menu.value, _table_include_in_menu_default.value) = '1') ORDER BY `name` asc LIMIT 50 OFFSET 100