Категории

Летние души и умывальники для дач продажа, цена в Минске

Выберите подкатегорию

Вид:  Сравнение товаров (0) На странице: Сортировка:
ЭлБЭТ Умывальник УМ-17
Код товара: 511477. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
24.85 Руб
AtlantidaSPb Кабина Эконом-095
Код товара: 170318. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
322.27 Руб
Элтерм Душ с подогревом (60 л)
Код товара: 170325. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
239.25 Руб
ЭлБЭТ Чистюля с ЭВБО-17 (металл)
Код товара: 512384. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
116.34 Руб
ЭкоПром Rostok 200 л (с подогревом)
Код товара: 548869. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
267.57 Руб
ЭкоПром Rostok 250 л (с подогревом)
Код товара: 551153. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
289.09 Руб
ЭкоПром Rostok 110 л
Код товара: 553800. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
165.25 Руб
Успех plus (110 л)
Код товара: 553802. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
201.79 Руб
ЭкоПром Rostok 150 л
Код товара: 554967. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ. бак, 150 л, черный, без подогрева, 100x100x26.7 см..
177.99 Руб
ЭкоПром Rostok 200 л
Код товара: 554968. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ. бак, 200 л, черный, без подогрева, 100x100x32 см..
175.54 Руб
Успех plus (80 л)
Код товара: 555080. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
176.57 Руб
ЭкоПром Rostok 150 л (с подогревом)
Код товара: 559040. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
253.85 Руб
ЭлБЭТ УМ-10
Код товара: 340026. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
22.80 Руб
ЭлБЭТ ЭВБО 55
Код товара: 511476. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
65.36 Руб
Karcher Садовый душ [2.645-181.0]
Код товара: 511480. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
124.90 Руб
ЭлБЭТ Чистюля с ЭВБО-17 (пластик)
Код товара: 515373. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
96.34 Руб
ЭлБЭТ Чистюля с УМ-17
Код товара: 511475. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
97.59 Руб
ЭлБЭТ Чистюля с ЭВБО-22 (металл)
Код товара: 512385. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
85.90 Руб
Петромаш Водонагреватель "Петромаш"
Код товара: 913340. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ. умывальник, 15 л, серебристый, с подогревом, 1.25 кВт, с терморегулятором, 34x15x46 см..
94.23 Руб
Успех plus (60 л)
Код товара: 169757. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
165.39 Руб
Вихрь 74/4/2
Код товара: 531946. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
158.42 Руб
Вихрь 74/4/1
Код товара: 531945. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
121.77 Руб
Вихрь 74/4/3
Код товара: 786920. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
156.58 Руб
Вихрь 74/4/5
Код товара: 865958. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
140.11 Руб
Петромаш Умывальник "Петромаш"
Код товара: 913455. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
167.64 Руб
ЭлБЭТ Умывальник с пластиковой тумбой УМ-17
Код товара: 511478. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
92.99 Руб
ЭлБЭТ Электроводонагреватель для ЭВБО-17
Код товара: 512397. Нал. и б/н. расчёт. Работаем по всей РБ. бак, 17 л, белый, с подогревом, 1.25 кВт, макс. температура 75°C, 2.5 кг..
49.29 Руб
Styron STY-350-F (черный)
Код товара: 822511. Нал. и б/н. расчёт. Работаем по всей РБ...
83.60 Руб
Styron STY-350 (белый)
Код товара: 822820. Нал. и б/н. расчёт. Работаем по всей РБ...
103.60 Руб
ЭкоПром Rostok 110 л (с подогревом)
Код товара: 560144. Нал. и б/н. расчёт. Работаем по всей РБ. бак, 110 л, черный, с подогревом, 2 кВт, макс. температура 60°C, 100x100x21.6 см..
240.14 Руб
Rostok Бак для душа с подогревом воды (150 л) [201.1500.899.1]
Код товара: 526204. Нал. и б/н. расчёт. Работаем по всей РБ...
289.41 Руб
ЭлБЭТ Электроводонагреватель для ЭВБО-22
Код товара: 512398. Нал. и б/н. расчёт. Работаем по всей РБ. бак, 22 л, белый, с подогревом, 1.25 кВт, макс. температура 75°C, 2.5 кг..
105.83 Руб
Total time 13.3699 seconds | Total queries:112
query time:0.0002 seconds | controller:
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://techno-land.by/'
query time:0.0048 seconds | controller:
SELECT * FROM oc_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
query time:0.0002 seconds | controller: multilingual_seo
SELECT * FROM `oc_language` WHERE status = '1'
query time:0.0002 seconds | controller: multilingual_seo
SELECT * FROM oc_currency
query time:0.0001 seconds | controller: multilingual_seo
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'
query time:0.0001 seconds | controller: multilingual_seo
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'
query time:0.0014 seconds | controller: ControllerProductCategory
SELECT DISTINCT * 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.category_id = '765' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.0006 seconds | controller: ControllerProductCategory
SELECT DISTINCT * 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.category_id = '849' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.3256 seconds | controller: ControllerProductCategory
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' AND c.hidden=0 ORDER BY c.sort_order, LCASE(cd.name)
query time:1.1015 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '3706'
query time:0.0008 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '3706'
query time:1.0756 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '8515'
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '8515'
query time:1.0361 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '42084'
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '42084'
query time:1.3184 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '41795'
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '41795'
query time:1.0942 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '29120'
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '29120'
query time:1.0561 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '8516'
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '8516'
query time:1.1158 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '3707'
query time:0.0006 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '3707'
query time:1.0813 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '3708'
query time:0.0006 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '3708'
query time:1.4243 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '850'
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '850'
query time:1.2287 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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 <= '2021-03-03 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '3709'
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '3709'
query time:0.0464 seconds | controller: ControllerProductCategory
SELECT DISTINCT cp.category_id FROM oc_category_path cp WHERE cp.path_id = 849
query time:0.0006 seconds | controller: ControllerProductCategory
SELECT p2c.product_id FROM oc_product_to_category p2c WHERE p2c.category_id IN (849,850,3706,3707,3708,3709,8515,8516,29120,41795,42084)
query time:0.0007 seconds | controller: ControllerProductCategory
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id FROM oc_product p WHERE 1=1 AND p.product_id IN (2581,22178,62573,88070,88351,89154,90520,200370,204538,218678,16009,24021,24090,153709,23781,23888,24020,24085,24086,24278,214671,16312,88071,129991,185824,165291,166751,169854,185684,210362,210452,216274) AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' GROUP BY p.product_id ORDER BY p.sort_order ASC, p.product_id ASC LIMIT 0,50
query time:0.0001 seconds | controller: ControllerProductCategory
SELECT FOUND_ROWS() AS `found_rows`
query time:0.0198 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '2581' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0193 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '16009' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0207 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '16312' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0184 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '22178' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0204 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '23781' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0208 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '23888' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0226 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '24020' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0183 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '24021' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0182 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '24085' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0178 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '24086' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0177 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '24090' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0191 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '24278' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0184 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '62573' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0176 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '88070' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0229 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '88071' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0267 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '88351' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0273 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '89154' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0218 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '90520' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0185 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '129991' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0172 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '153709' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0172 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '165291' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0171 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '166751' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.017 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '169854' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0171 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '185684' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0173 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '185824' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0177 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '200370' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0176 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '204538' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0175 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '210362' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0177 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '210452' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0175 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '214671' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.018 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '216274' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0176 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name 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 < '2021-03-03 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-03 23:59:00')) 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 < '2021-03-03 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-03 23:59:00')) 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 = '218678' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-03 23:59:00' AND p2s.store_id = '0'
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '2581' ORDER BY main_category DESC LIMIT 1
query time:0.0003 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '16009' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '16312' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '22178' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '23781' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '23888' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '24020' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '24021' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '24085' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '24086' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '24090' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '24278' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '62573' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '88070' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '88071' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '88351' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '89154' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '90520' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '129991' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '153709' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '165291' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '166751' ORDER BY main_category DESC LIMIT 1
query time:0.0006 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '169854' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '185684' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '185824' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '200370' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '204538' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '210362' ORDER BY main_category DESC LIMIT 1
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '210452' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '214671' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '216274' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '218678' ORDER BY main_category DESC LIMIT 1
query time:0.0003 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_category_to_layout WHERE category_id = '849' AND store_id = '0'
query time:0.0001 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1
query time:0.0001 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0002 seconds | controller: ControllerModuleBanner
SELECT * FROM oc_banner_image bi LEFT JOIN oc_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id) WHERE bi.banner_id = '6' AND bid.language_id = '1'
query time:0.0002 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_category_to_layout WHERE category_id = '849' AND store_id = '0'
query time:0.0001 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1
query time:0.0002 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0001 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_category_to_layout WHERE category_id = '849' AND store_id = '0'
query time:0.0001 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1
query time:0.0002 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0002 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_category_to_layout WHERE category_id = '849' AND store_id = '0'
query time:0.0001 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1
query time:0.0002 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0004 seconds | controller: ControllerCommonFooter
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
query time:0.0002 seconds | controller: ControllerModuleCart
SELECT * FROM oc_extension WHERE `type` = 'total'