NutriCology

NutriCology

For more than thirty-five years, NutriCology has been known for the highest quality, most hypoallergenic, and most cutting-edge nutritional supplements available. Physicians and healthcare practitioners… Read more

There are no products matching the selection.
[profiler]
Memory usage: real: 19660800, emalloc: 19132024
Code ProfilerTimeCntEmallocRealMem
Executed 115 queries in 0.021291017532349 seconds
Average query length: 0.00018513928288999 seconds
Queries per second: 5401.3388427901
Longest query length: 0.0028681755065918
Longest query:
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_sort.value_id > 0, at_sort.value, at_sort_default.value) AS `sort`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_aitmanufacturers_sort.value_id > 0, at_aitmanufacturers_sort.value, at_aitmanufacturers_sort_default.value) AS `aitmanufacturers_sort` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=17 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '7891' INNER JOIN `catalog_product_index_price_store` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '10' AND price_index.customer_group_id = 0 LEFT JOIN `catalog_product_entity_int` AS `at_sort_default` ON (`at_sort_default`.`entity_id` = `e`.`entity_id`) AND (`at_sort_default`.`attribute_id` = '283') AND `at_sort_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_sort` ON (`at_sort`.`entity_id` = `e`.`entity_id`) AND (`at_sort`.`attribute_id` = '283') AND (`at_sort`.`store_id` = 17) INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '95') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '95') AND (`at_visibility`.`store_id` = 17) LEFT JOIN `catalog_product_entity_int` AS `at_aitmanufacturers_sort_default` ON (`at_aitmanufacturers_sort_default`.`entity_id` = `e`.`entity_id`) AND (`at_aitmanufacturers_sort_default`.`attribute_id` = '283') AND `at_aitmanufacturers_sort_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_aitmanufacturers_sort` ON (`at_aitmanufacturers_sort`.`entity_id` = `e`.`entity_id`) AND (`at_aitmanufacturers_sort`.`attribute_id` = '283') AND (`at_aitmanufacturers_sort`.`store_id` = 17) WHERE (price_index.store_id = 17) AND (`e`.`entity_id` IN('2037', '2038', '2039', '2040', '2041', '2042', '2043', '2045', '2050', '2051', '2052', '2053', '2054', '2055', '2056', '2057', '2058', '2059', '2060', '2061', '2062', '2063', '2064', '2065', '2067', '2068', '2071', '2072', '2073', '2074', '2076', '2077', '2078', '2080', '2081', '2083', '2084', '2086', '2088', '2090', '2091', '2093', '2094', '2095', '2097', '2099', '2101', '2102', '2103', '2104', '2105', '2106', '2107', '2108', '2110', '2112', '2113', '2114', '2115', '2116', '2117', '2118', '2119', '2120', '2121', '2126', '2129', '2131', '2132', '2134', '2136', '2138', '2141', '2143', '2144', '2146', '2148', '2151', '2152', '2153', '2154', '2155', '2159', '2161', '2165', '2166', '2167', '2168', '2169', '2170', '2171', '2172', '2173', '2177', '2178', '2179', '2180', '2183', '2184', '2187', '2188', '2189', '2190', '2191', '3973', '4003', '4005', '4009', '4735', '4738', '4739', '4740', '4751', '4804', '5328', '5442', '6437', '6589', '6849', '6850', '6851', '6855', '6860', '6861', '6868', '6869', '6884', '6885', '6887', '6888', '6889', '6890', '6891', '6893', '7048', '7187', '7342', '7566', '26607', '27697', '27705', '27707', '27720', '28038', '29696', '29718', '32984', '32985', '32986', '32988', '32989', '32990', '32991', '32992', '32993', '32994', '32995', '32996', '32997', '32998', '32999', '33000', '33001', '33002', '33003', '33004', '33005', '33006', '33007', '33008', '33009', '33011', '33012', '33013', '33014', '33015', '33017', '33018', '33019', '33020', '33021', '33022', '33023', '33024', '33025', '33026', '33027', '33028', '33031', '33032', '33033', '33034', '33035', '33036', '33037', '33039', '33040', '33041', '33042', '33043', '33044', '33045', '33046', '33047', '33048', '33051', '33052', '33053', '33054', '33055', '33056', '33057', '33058', '33059', '33060', '33061', '33062', '33063', '33065', '33067', '33068', '33069', '33070', '33071', '33073', '33074', '33075', '33076', '33078', '33079', '33080', '33082', '33083', '33085', '35342', '35343')) AND (((IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '2') OR (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4'))) ORDER BY `aitmanufacturers_sort` ASC LIMIT 24