Customer Service 1-800-328-9090

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

Cosmetics

Cosmetics

1 item(s) were found

Showing 1-1 of 1 results

  1. 1
  1. Terra Gloss, Shimmering Lip Gloss, Bloom, 0.42 oz, 12 Pack
    Alba Botanica

    Terra Gloss, Shimmering Lip Gloss, Bloom, 0.42 oz, 12 Pack

    1 Ounce

    Serving Size: 0.42 oz

    Retail Price: $71.40

    You Save: $24.25

    getIdSuffix() != '-upsell' && $this->getIdSuffix() != '-related' ) : ?>

    Our Price: $47.15

    You Save: 34% ($24.25)34% Off

Showing 1-1 of 1 results

  1. 1
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: 9251888
Code ProfilerTimeCntEmallocRealMem
Executed 77 queries in 0.103924036026 seconds
Average query length: 0.0013496628055325 seconds
Queries per second: 740.92580450528
Longest query length: 0.018266201019287
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')