Customer Service 1-800-328-9090

Every Order Helps Improve a Life.  Lives Improved: 19,578
 
SPECIAL!
FREE SHIPPING on orders over $49

Products

showing 4001-4050 of 19036 results

showing 4001-4050 of 19036 results

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: 2097152, emalloc: 6623336
Code ProfilerTimeCntEmallocRealMem
Executed 100 queries in 0.11493849754333 seconds
Average query length: 0.0011493849754333 seconds
Queries per second: 870.03051316464
Longest query length: 0.018894910812378
Longest query:
SELECT `e`.*, 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` 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')