Loading...
ул. Бурнаковская д.51А
ТЦ "Бурнаковский"
цоколь (4 и 5 входы)
пн-пт 9-19 (сб-вс 10-16)

Товары Ермак

Товары Ермак

История бренда «Ермак» началась с 1997 года и продолжается по сей день.

Масштабная исследовательская работа

Качественное развитие, успешное продвижение на рынке, разрабатываемая и выпускаемая продукция неоднократно были отмечены ценными призами на международных и инновационных выставках

Нашими специалистами была проведена масштабная инновационная исследовательская работа, что подтверждается патентами на изобретение (полезные модели).

Наша компания сегодня

Сегодня ERMAK & STOKER это ряд научно – исследовательских и экспертных организаций, дизайнерских бюро и рекламных агентств, несколько торговых фирм и производственных предприятий.

Успешное развитие на рынке нашего предприятия позволяет осуществлять профессиональный коллектив, качественная современная продукция и надежные партнеры по продвижению банного и отопительного оборудования ERMAK и STOKER!

Ценности и приоритеты компании

В своей деятельности ERMAK & STOKER основывается на традиционных общечеловеческих ценностях, привнося в жизнь людей тепло и комфорт.

Создавая новые продукты наши специалисты ставят в приоритет принципы надежности, функциональности и доступности выпускаемой продукции, постоянно совершенствуя и улучшая её качество


Сравнение товаров (0)


Сортировать:

Ваша скидка: -10%
Буржуйка Печь садовая — Ермак
Буржуйка Печь садовая — Ермак
Для обогрева (м3): до 50 м3

4 902 р. 4 412 р.

Ваша скидка: -10%
Выносной бак Ермак INOX (40 л) нержавеющая сталь
Выносной бак Ермак INOX (40 л) нержавеющая сталь
Материал: Нержавейка

4 814 р. 4 333 р.

Ваша скидка: -10%
Газовая горелка с пьезорозжигом САБК-3ТБ4 П — Ермак
Ваша скидка: -10%
Газовая печь для бани Уралочка 12
Газовая печь для бани Уралочка 12
Для парной, м3: 6-12 м3

21 840 р. 19 656 р.

Ваша скидка: -10%
Котел отопительный Stoker Aqua 12-П/Э
Котел отопительный Stoker Aqua 12-П/Э
Для обогрева (м2): 120

25 470 р. 22 923 р.

Ваша скидка: -10%
Электрокаменка для бани Ермак Elektrа-Box 12 (380)
Электрокаменка для бани Ермак Elektrа-Box 12 (380)
Для парной, м3: 14-20 м3

29 732 р. 26 759 р.

Ваша скидка: -10%
Буржуйка Печь садовая (стекло) — Ермак
Буржуйка Печь садовая (стекло) — Ермак
Для обогрева (м3): до 50 м3

5 305 р. 4 775 р.

Ваша скидка: -10%
Выносной бак Ермак INOX (55 л) нержавеющая сталь
Выносной бак Ермак INOX (55 л) нержавеющая сталь
Материал: Нержавейка

5 979 р. 5 381 р.

Ваша скидка: -10%
Газовая горелка с пьезорозжигом САБК-4ТБ-2П — Ермак
Ваша скидка: -10%
Газовая печь для бани Уралочка 12 с автоматикой
Газовая печь для бани Уралочка 12 с автоматикой
Для парной, м3: 6-12 м3

24 580 р. 22 122 р.

Ваша скидка: -10%
Дровяная колонка (титан) Ермак КВЛ-90 (С)
Дровяная колонка (титан) Ермак КВЛ-90 (С)
Помещение: Дом / Дача

13 650 р. 12 285 р.

Ваша скидка: -10%
Котел отопительный Stoker Aqua 14-Э
Котел отопительный Stoker Aqua 14-Э
Для обогрева (м2): 140

27 880 р. 25 092 р.

Ваша скидка: -10%
Электрокаменка для бани Ермак Elektrа-Box 15 (380)
Электрокаменка для бани Ермак Elektrа-Box 15 (380)
Для парной, м3: 16-24 м3

31 636 р. 28 472 р.

Ваша скидка: -5%
Лидер продаж!
Бак для колонки КВЛН-90 - Ермак
Бак для колонки КВЛН-90 - Ермак
Вес (кг): 25

11 813 р. 11 222 р.

Ваша скидка: -10%
Буржуйка Печь садовая 100-ОВ — Ермак
Буржуйка Печь садовая 100-ОВ — Ермак
Для обогрева (м3): до 100 м3

8 716 р. 7 844 р.

Ваша скидка: -10%
Выносной бак Ермак INOX (65 л) нержавеющая сталь
Выносной бак Ермак INOX (65 л) нержавеющая сталь
Материал: Нержавейка

6 754 р. 6 079 р.

Ваша скидка: -10%
Газовая горелка с пьезорозжигом УГ-САБК-ТБ-12-1 — Ермак
Ваша скидка: -10%
Газовая печь для бани Уралочка 12-Н
Газовая печь для бани Уралочка 12-Н
Для парной, м3: 6-12 м3

25 144 р. 22 630 р.

Ваша скидка: -10%
Дровяная колонка (титан) Ермак КВЛ-90 (Ч)
Дровяная колонка (титан) Ермак КВЛ-90 (Ч)
Помещение: Дом / Дача

16 100 р. 14 490 р.

Ваша скидка: -10%
Котел отопительный Stoker Aqua 18-Э
Котел отопительный Stoker Aqua 18-Э
Для обогрева (м2): 180

30 580 р. 27 522 р.

Ваша скидка: -10%
Электрокаменка для бани Ермак Elektrа-Box 18 (380)
Электрокаменка для бани Ермак Elektrа-Box 18 (380)
Для парной, м3: 21-30 м3

37 668 р. 33 901 р.

Ваша скидка: -5%
Лидер продаж!
Бак для колонки КВЛ-90 - Ермак
Бак для колонки КВЛ-90 - Ермак
Вес (кг): 25

7 500 р. 7 125 р.

Ваша скидка: -10%
Буржуйка Печь садовая 150-ОВ — Ермак
Буржуйка Печь садовая 150-ОВ — Ермак
Для обогрева (м3): до 150 м3

11 214 р. 10 093 р.

Ваша скидка: -10%
Газовая горелка с пьезорозжигом УГ-САБК-ТБ-16-1 — Ермак
Ваша скидка: -10%
Газовая печь для бани Уралочка 16
Газовая печь для бани Уралочка 16
Для парной, м3: 8-16 м3

23 673 р. 21 306 р.

Ваша скидка: -10%
Дровяная колонка (титан) Ермак КВЛ-90 (Ш)
Дровяная колонка (титан) Ермак КВЛ-90 (Ш)
Помещение: Дом / Дача

15 450 р. 13 905 р.

Ваша скидка: -10%
Котел отопительный Stoker Pro 20-Э
Котел отопительный Stoker Pro 20-Э
Для обогрева (м2): 200

36 964 р. 33 268 р.

Ваша скидка: -10%
Навесной бак Ермак 12 INOX (35 л) нержавеющая сталь
Ваша скидка: -10%
Электрокаменка для бани Ермак Elektrа-Box 6 (220)
Электрокаменка для бани Ермак Elektrа-Box 6 (220)
Для парной, м3: 6-10 м3

19 808 р. 17 827 р.

Ваша скидка: -10%
Буржуйка Печь садовая 70-ОВ — Ермак
Буржуйка Печь садовая 70-ОВ — Ермак
Для обогрева (м3): до 70 м3

7 747 р. 6 972 р.

Ваша скидка: -10%
Газовая горелка САБК-3ТБ4 — Ермак
Газовая горелка САБК-3ТБ4 — Ермак
Мощность (кВт): 19 кВт

7 971 р. 7 174 р.

Ваша скидка: -10%
Газовая печь для бани Уралочка 16 с автоматикой
Газовая печь для бани Уралочка 16 с автоматикой
Для парной, м3: 8-16 м3

26 015 р. 23 414 р.

Показано с 1 по 32 из 158 (всего 5 страниц)
Queries: 338, Total time: 405.109 ms [By time] [By id] [By file]
1 (0.304)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/library/openbay.php:117
2 (0.217)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://xn--80ajbvln7ce4bf.xn--p1ai/'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/controller/startup/startup.php:6
3 (5.591)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/controller/startup/startup.php:25
4 (0.244)
SELECT *
FROM oc_currency
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/library/cart/currency.php:10
5 (0.517)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2766')
ORDER BY tr1.priority ASC
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/library/cart/tax.php:17
6 (0.374)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2766')
ORDER BY tr1.priority ASC
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/library/cart/tax.php:45
7 (0.251)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/library/cart/weight.php:10
8 (0.255)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/library/cart/length.php:10
9 (0.735)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:57
10 (0.221)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/library/openbay.php:117
11 (0.268)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/extension/event.php:4
12 (0.594)
SELECT GROUP_CONCAT(REPLACE(`query`, 'category_id=', '')
ORDER BY FIELD(keyword, 'ermak') SEPARATOR '_') AS path, GROUP_CONCAT(`keyword`
ORDER BY FIELD(keyword, 'ermak') SEPARATOR '/') AS keywords
FROM oc_url_alias
WHERE `query` LIKE 'category_id=%' AND (keyword = 'ermak')
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/ocfilter.php:149
13 (0.237)
SELECT *
FROM oc_language
WHERE status = '1'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/controller/common/seoblog.php:87
14 (0.562)
SELECT *
FROM oc_layout l
LEFT JOIN oc_layout_route lr ON (l.layout_id = lr.layout_id)
ORDER BY name ASC
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/design/bloglayout.php:42
15 (0.448)
SELECT DISTINCT *, md.name AS name
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE md.language_id = '1' && m.manufacturer_id = '58' AND m2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/catalog/manufacturer.php:24
16 (191.095)
SELECT DISTINCT c.category_id,cd.name
FROM oc_manufacturer m
LEFT JOIN oc_product p ON (m.manufacturer_id = p.manufacturer_id)
LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id)
LEFT JOIN oc_category c ON (c.category_id = p2c.category_id)
LEFT JOIN oc_category_description cd ON (cd.category_id = p2c.category_id)
WHERE p.status = 1 AND m.manufacturer_id = '58' AND c.status= 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/catalog/manufacturer.php:18
17 (2.462)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '58'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:632
18 (8.656)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '58' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,32
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:267
19 (1.061)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14038' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
20 (0.975)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14037' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
21 (1.074)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14045' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
22 (0.969)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14055' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
23 (0.983)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14111' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
24 (1.063)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14122' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
25 (1.109)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14039' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
26 (1.001)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14041' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
27 (0.887)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14046' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
28 (0.805)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14091' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
29 (0.783)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14143' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
30 (0.811)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14118' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
31 (1.042)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14125' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
32 (1.146)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6720' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
33 (0.971)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14047' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
34 (0.982)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14042' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
35 (1.038)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14048' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
36 (1.431)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14148' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
37 (1.319)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14146' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
38 (1.308)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14124' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
39 (1.310)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14128' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
40 (1.216)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6722' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
41 (1.294)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14050' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
42 (1.130)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14049' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
43 (1.108)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14058' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
44 (1.237)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14145' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
45 (1.128)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14127' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
46 (1.183)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14035' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
47 (1.090)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14087' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
48 (1.138)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14043' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
49 (1.095)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14044' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
50 (1.107)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14102' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:20
51 (1.087)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14038' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
52 (0.718)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14038' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
53 (0.250)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'related_options'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/module/related_options.php:1179
54 (0.249)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14038'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
55 (0.552)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14037' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
56 (0.608)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14037' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
57 (0.233)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14037'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
58 (0.367)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14045' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
59 (0.400)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14045' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
60 (0.254)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14045'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
61 (0.905)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14055' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
62 (0.681)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14055' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
63 (0.260)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14055'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
64 (1.763)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14111' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
65 (0.843)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14111' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
66 (0.920)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14122' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
67 (0.607)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14122' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
68 (0.323)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14122'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
69 (1.079)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14039' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
70 (0.723)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14039' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
71 (0.307)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14039'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
72 (0.633)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14041' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
73 (0.607)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14041' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
74 (0.445)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14041'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
75 (0.553)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14046' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
76 (0.633)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14046' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
77 (0.223)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14046'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
78 (0.693)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14091' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
79 (0.560)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14091' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
80 (0.621)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14091'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
81 (0.815)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14143' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
82 (10.122)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14143' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
83 (0.383)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14143'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
84 (2.047)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14118' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
85 (1.042)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14118' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
86 (1.290)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14125' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
87 (0.578)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14125' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
88 (0.258)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14125'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
89 (1.040)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '6720' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
90 (0.534)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '6720' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
91 (0.308)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6720'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
92 (1.098)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14047' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
93 (0.676)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14047' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
94 (0.251)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14047'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
95 (0.505)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14042' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
96 (0.591)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14042' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
97 (0.286)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14042'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
98 (0.569)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14048' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
99 (2.376)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14048' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
100 (0.310)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14048'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
101 (0.750)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14148' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
102 (0.590)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14148' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
103 (0.251)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14148'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
104 (0.581)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14146' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
105 (0.513)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14146' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
106 (0.229)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14146'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
107 (1.519)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14124' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
108 (0.840)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14124' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
109 (0.294)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14124'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
110 (0.826)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14128' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
111 (0.632)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14128' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
112 (0.299)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14128'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
113 (1.140)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '6722' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
114 (0.830)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '6722' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
115 (0.312)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6722'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
116 (1.182)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14050' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
117 (0.731)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14050' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
118 (0.317)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14050'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
119 (0.485)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14049' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
120 (0.621)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14049' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
121 (0.277)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14049'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
122 (0.917)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14058' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
123 (0.693)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14058' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
124 (0.294)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14058'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
125 (0.749)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14145' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
126 (0.588)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14145' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
127 (0.261)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14145'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
128 (2.175)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14127' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
129 (0.900)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14127' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
130 (0.330)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14127'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
131 (0.584)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14035' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
132 (0.646)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14035' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
133 (0.251)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14035'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
134 (0.996)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14087' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
135 (0.676)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14087' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
136 (0.292)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14087'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
137 (1.029)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14043' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
138 (0.700)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14043' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
139 (0.289)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14043'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
140 (0.441)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14044' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
141 (0.559)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14044' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
142 (0.256)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14044'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
143 (1.115)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '14102' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:387
144 (0.575)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '14102' AND a.attribute_group_id = '146' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:392
145 (0.238)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14102'
ORDER BY main_category DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:278
146 (0.266)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
147 (0.224)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'column_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
148 (0.250)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
149 (0.218)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'column_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
150 (0.276)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
151 (0.185)
SELECT *
FROM oc_hyper_positions_width
WHERE layout_id = '20'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/design/hyper_positions.php:8
152 (0.215)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'pos_sliders'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
153 (0.222)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
154 (0.392)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
155 (0.217)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
156 (0.210)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top1_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
157 (0.220)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top1_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
158 (0.237)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top1_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
159 (0.250)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top1_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
160 (0.225)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top2_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
161 (0.253)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top2_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
162 (0.208)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top2_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
163 (0.223)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'pos_banner'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
164 (0.231)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top3_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
165 (0.189)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top3_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
166 (0.175)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top3_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
167 (0.217)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'top3_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
168 (0.232)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
169 (0.186)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'content_top'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
170 (0.203)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
171 (0.188)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'content_bottom'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
172 (0.197)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
173 (0.160)
SELECT *
FROM oc_hyper_positions_width
WHERE layout_id = '20'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/design/hyper_positions.php:8
174 (0.178)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'pos_banner2'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
175 (0.170)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'column2_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
176 (0.172)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'column2_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
177 (0.174)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'column2_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
178 (0.176)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
179 (0.175)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
180 (0.169)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
181 (0.171)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
182 (0.168)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'pos_banner3'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
183 (0.171)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom1_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
184 (0.180)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom1_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
185 (0.203)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom1_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
186 (0.170)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom2_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
187 (0.177)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom2_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
188 (0.207)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom2_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
189 (0.174)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom2_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
190 (0.165)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom3_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
191 (0.152)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom3_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
192 (0.150)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom3_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
193 (0.201)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'pos_banner4'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
194 (0.201)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom4_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
195 (0.188)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom4_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
196 (0.158)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'bottom4_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
197 (0.185)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/extension/extension.php:4
198 (1.368)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/information.php:10
199 (0.194)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2019-11-19 20:34:22'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/tool/online.php:4
200 (0.203)
REPLACE INTO `oc_customer_online` SET `ip` = '3.92.92.168', `customer_id` = '0', `url` = 'http://xn--80ajbvln7ce4bf.xn--p1ai/ermak/', `referer` = '', `date_added` = '2019-11-19 21:34:22'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/tool/online.php:6
201 (0.190)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
202 (0.162)
SELECT *
FROM oc_hyper_positions_width
WHERE layout_id = '20'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/design/hyper_positions.php:8
203 (0.143)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
204 (0.126)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
205 (0.200)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
206 (0.194)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
207 (0.203)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'map_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
208 (0.189)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'map_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
209 (0.188)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'map_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
210 (0.191)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer2_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
211 (0.188)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer2_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
212 (0.185)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer2_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
213 (0.197)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer2_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
214 (0.188)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer3_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
215 (0.192)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer3_cent'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
216 (0.188)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer3_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
217 (0.264)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
218 (0.193)
SELECT *
FROM oc_hyper_positions_width
WHERE layout_id = '20'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/design/hyper_positions.php:8
219 (0.255)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer4_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
220 (0.205)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer4_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
221 (0.162)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer4_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
222 (0.163)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer4_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
223 (0.171)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer5_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
224 (0.158)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer5_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
225 (0.191)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'footer5_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
226 (0.218)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'copy_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
227 (0.215)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'copy_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
228 (0.202)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'copy_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
229 (0.216)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'copy2_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
230 (0.209)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'copy2_center'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
231 (0.225)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'copy2_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
232 (0.271)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/extension/extension.php:4
233 (0.258)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:4
234 (0.188)
SELECT *
FROM oc_hyper_positions_width
WHERE layout_id = '20'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/design/hyper_positions.php:8
235 (0.211)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'header_left'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
236 (0.243)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'header_cl'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
237 (0.209)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'header_cr'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
238 (0.211)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'header_right'
ORDER BY sort_order
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/system/storage/modification/catalog/model/design/layout.php:23
239 (0.273)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'liveprice'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/module/liveprice.php:33
240 (0.227)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'related_options'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/module/related_options.php:1179
241 (1.415)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
242 (1.265)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
243 (1.049)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
244 (0.653)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '238' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
245 (0.463)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
246 (0.431)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
247 (0.727)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
248 (0.470)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '320' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
249 (0.423)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '232' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
250 (0.452)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '249' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
251 (0.431)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '248' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
252 (1.061)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '259' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
253 (1.160)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '101' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
254 (0.940)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '404' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
255 (0.443)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '405' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
256 (0.417)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '861' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
257 (0.403)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '172' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
258 (0.762)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '68' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
259 (0.803)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '180' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
260 (0.513)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '243' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
261 (0.380)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '765' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
262 (0.728)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '244' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
263 (0.435)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '245' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
264 (0.512)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '76' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
265 (1.187)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
266 (0.690)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
267 (0.688)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '398' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
268 (0.765)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '378' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
269 (0.671)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '341' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
270 (0.705)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '780' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
271 (0.728)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '418' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
272 (0.676)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '465' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
273 (0.487)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '241' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
274 (0.477)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '505' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
275 (0.473)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
276 (0.524)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '124' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
277 (0.472)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '130' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
278 (0.477)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '698' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
279 (0.922)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '247' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
280 (0.966)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '72' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
281 (0.954)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '70' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
282 (0.527)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '254' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
283 (0.480)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '301' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
284 (0.479)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '171' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
285 (1.345)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '174' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
286 (0.802)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '239' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
287 (0.505)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '179' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
288 (0.792)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '808' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
289 (0.908)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '849' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
290 (0.689)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '792' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
291 (0.659)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '805' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
292 (0.984)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '819' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
293 (0.704)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '830' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
294 (0.700)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '785' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
295 (0.641)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '790' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
296 (0.747)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '800' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
297 (0.657)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '815' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
298 (0.626)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '834' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
299 (0.629)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '837' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
300 (0.627)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '840' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
301 (0.747)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '843' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
302 (0.816)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
303 (0.893)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '125' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
304 (0.729)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '367' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
305 (0.647)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '90' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
306 (0.914)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '87' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
307 (1.373)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
308 (0.969)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '80' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
309 (0.821)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '78' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
310 (0.699)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '81' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
311 (0.633)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '79' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
312 (0.849)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '924' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
313 (0.562)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '726' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
314 (1.029)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '83' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
315 (0.623)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '632' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
316 (0.492)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '668' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
317 (0.468)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '634' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
318 (0.778)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '215' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
319 (0.500)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '240' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
320 (0.483)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '725' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
321 (0.885)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '864' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
322 (0.958)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '892' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
323 (0.682)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '870' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
324 (0.809)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '881' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
325 (0.654)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '915' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
326 (0.664)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '876' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
327 (0.458)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '914' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
328 (0.681)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '865' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
329 (1.058)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/catalog/category.php:10
330 (0.190)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:151
331 (0.165)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:231
332 (0.153)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/catalog/model/extension/extension.php:4
333 (0.181)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:151
334 (0.146)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:231
335 (0.190)
SELECT SUM(quantity) as total
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:802
336 (0.130)
SELECT SUM(quantity) as total
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:802
337 (0.148)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:151
338 (0.129)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '09484b083d8a577f15b1352a514dcc4d'
/home/j/jpierre/xn--80ajbvln7ce4bf.xn--p1ai/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:231