Категории

Категории
Главная » Авто » Автомобильные усилители

Автомобильные усилители продажа, цена в Минске

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

Вид:  Сравнение товаров (0) На странице: Сортировка:
Автомобильный усилитель Swat M-4.65
Код товара: 20389. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
151.55 Руб
В корзину
Автомобильный усилитель ACV LX-2.100
Код товара: 623177. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
135.70 Руб
В корзину
Автомобильный усилитель Aura AMP-2.60
Код товара: 637451. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
158.78 Руб
Нет в наличии
Автомобильный усилитель Digma DCP-400
Код товара: 668319. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
157.15 Руб
В корзину
Автомобильный усилитель Aura AMP-A455
Код товара: 837578. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
166.64 Руб
В корзину
Автомобильный усилитель Aura AMP-A275
Код товара: 840765. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
135.01 Руб
В корзину
Автомобильный усилитель JVC KS-DR3002
Код товара: 20278. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
173.82 Руб
В корзину
Автомобильный усилитель Calcell VAC 90.4
Код товара: 20126. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
138.35 Руб
Нет в наличии
Автомобильный усилитель Ground Zero GZIA 4115HPX
Код товара: 20176. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
258.24 Руб
Нет в наличии
Автомобильный усилитель Урал PB 4.120
Код товара: 421706. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
306.94 Руб
Нет в наличии
Автомобильный усилитель Alphard MA-50.4
Код товара: 418514. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
170.28 Руб
Нет в наличии
Автомобильный усилитель Prology CLUB CA-400
Код товара: 20461. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
155.60 Руб
Нет в наличии
Автомобильный усилитель Calcell BST 1000.1
Код товара: 20160. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
252.19 Руб
Нет в наличии
Автомобильный усилитель JBL GX-A602
Код товара: 20197. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
165.47 Руб
В корзину
Автомобильный усилитель Урал AKM 1.700
Код товара: 20537. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
278.04 Руб
Нет в наличии
Автомобильный усилитель KICX KAP 27
Код товара: 20245. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
279.00 Руб
Нет в наличии
Автомобильный усилитель Alpine BBX-F1200
Код товара: 20083. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
325.82 Руб
В корзину
Автомобильный усилитель ACV LX-4.60
Код товара: 362065. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
151.83 Руб
В корзину
Автомобильный усилитель JVC KS-AX204
Код товара: 20204. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
216.64 Руб
Нет в наличии
Автомобильный усилитель Pioneer GM-A4704
Код товара: 20412. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
398.90 Руб
В корзину
Автомобильный усилитель Kenwood XR400-4
Код товара: 20284. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
383.77 Руб
Нет в наличии
Автомобильный усилитель KICX Angry Ant mono
Код товара: 271712. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
306.00 Руб
Нет в наличии
Автомобильный усилитель JVC KS-DR3001D
Код товара: 20277. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
291.60 Руб
В корзину
Автомобильный усилитель KICX AR 1.350
Код товара: 20241. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
266.39 Руб
В корзину
Автомобильный усилитель Alpine BBX-T600
Код товара: 20009. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
275.68 Руб
В корзину
Автомобильный усилитель Pioneer GM-A3702
Код товара: 20411. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
180.56 Руб
В корзину
Автомобильный усилитель JBL GX-A604
Код товара: 20269. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
283.78 Руб
Нет в наличии
Автомобильный усилитель KICX RTS 2.60
Код товара: 20342. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
178.10 Руб
В корзину
Автомобильный усилитель Calcell BST 100.2
Код товара: 20123. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
189.95 Руб
В корзину
Автомобильный усилитель Mystery MA-2.340V3
Код товара: 20314. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
172.69 Руб
Нет в наличии
Автомобильный усилитель Урал W 4.135 V.3
Код товара: 20538. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
358.97 Руб
Нет в наличии
Автомобильный усилитель Alpine MRV-M250
Код товара: 20012. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
389.76 Руб
В корзину
Автомобильный усилитель Blaupunkt GTA-470
Код товара: 20078. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
235.50 Руб
Нет в наличии
Автомобильный усилитель KICX SP 4.80AB
Код товара: 378165. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
182.35 Руб
В корзину
Автомобильный усилитель Kenwood KAC-PS404
Код товара: 362906. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
281.07 Руб
В корзину
Автомобильный усилитель Kenwood KAC-PS704EX
Код товара: 397661. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
247.95 Руб
Нет в наличии
Автомобильный усилитель Sony XM-N1004
Код товара: 20467. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
365.40 Руб
В корзину
Автомобильный усилитель Alpine KTP-445A
Код товара: 20010. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
359.00 Руб
Нет в наличии
Автомобильный усилитель Mystery MA-2.240V3
Код товара: 20410. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
154.09 Руб
Нет в наличии
Автомобильный усилитель Mystery MK-4.80
Код товара: 20409. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
197.55 Руб
Нет в наличии
Автомобильный усилитель Pioneer GM-D8601
Код товара: 20417. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
323.97 Руб
Нет в наличии
Автомобильный усилитель Pioneer GM-D1004
Код товара: 20416. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
342.77 Руб
Нет в наличии
Автомобильный усилитель Aura AMP-4.80
Код товара: 454340. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
214.95 Руб
Нет в наличии
Автомобильный усилитель ACV LX-1.800
Код товара: 454341. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
244.47 Руб
Нет в наличии
Автомобильный усилитель ACV GX-2.150
Код товара: 454345. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
219.90 Руб
Нет в наличии
Автомобильный усилитель EDGE EDA150.4-E7
Код товара: 454363. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
225.16 Руб
В корзину
Автомобильный усилитель EDGE EDA200.4-E7
Код товара: 454364. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
293.46 Руб
В корзину
Автомобильный усилитель KICX AP 4.120AB
Код товара: 454382. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
277.75 Руб
В корзину
Автомобильный усилитель KICX SP 600D
Код товара: 454383. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
191.74 Руб
В корзину
Автомобильный усилитель Swat M-4.100
Код товара: 454393. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
223.70 Руб
В корзину
Total time 37.1217 seconds | Total queries:184
query time:0.0001 seconds | controller:
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://techno-land.by/'
query time:0.0053 seconds | controller:
SELECT * FROM oc_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
query time:0.0003 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.0002 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 = '1' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.0001 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 = '109' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.294 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 = '109' 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.0436 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '110'
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 = '110'
query time:1.0299 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2689'
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 = '2689'
query time:1.0871 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2690'
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 = '2690'
query time:1.0288 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2691'
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 = '2691'
query time:1.1931 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '31536'
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 = '31536'
query time:1.2829 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '111'
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 = '111'
query time:1.02 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2692'
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 = '2692'
query time:1.4479 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2693'
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 = '2693'
query time:1.1063 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2694'
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 = '2694'
query time:1.4727 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2695'
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 = '2695'
query time:1.145 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2696'
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 = '2696'
query time:1.0104 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '112'
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 = '112'
query time:1.068 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2697'
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 = '2697'
query time:1.4017 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2698'
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 = '2698'
query time:1.2417 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2699'
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 = '2699'
query time:1.1035 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '44893'
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 = '44893'
query time:1.0302 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2700'
query time:0.0007 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 = '2700'
query time:1.0438 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2701'
query time:0.0012 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 = '2701'
query time:1.0316 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '113'
query time:1.0627 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2703'
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 = '2703'
query time:0.9798 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2702'
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 = '2702'
query time:1.0723 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '28684'
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 = '28684'
query time:0.9872 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2704'
query time:0.0007 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 = '2704'
query time:1.5078 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '28685'
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 = '28685'
query time:1.186 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2705'
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 = '2705'
query time:0.9971 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2706'
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 = '2706'
query time:1.1136 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2707'
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 = '2707'
query time:1.1351 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2708'
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 = '2708'
query time:1.086 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '114'
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 = '114'
query time:1.3625 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-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '2709'
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 = '2709'
query time:0.0751 seconds | controller: ControllerProductCategory
SELECT DISTINCT cp.category_id FROM oc_category_path cp WHERE cp.path_id = 109
query time:0.0025 seconds | controller: ControllerProductCategory
SELECT p2c.product_id FROM oc_product_to_category p2c WHERE p2c.category_id IN (109,110,111,112,113,114,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,28684,28685,31536,44893)
query time:0.004 seconds | controller: ControllerProductCategory
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id FROM oc_product p WHERE 1=1 AND p.product_id IN (3381,10058,20032,20033,20044,20045,22809,27093,31732,49748,92300,157649,162813,162970,187074,219666,234127,3485,4752,4780,20031,27092,27735,34587,34588,34589,124796,165878,190100,208311,211899,239357,245627,3707,28880,28888,103207,5575,10276,11969,42292,1576,20039,20040,21863,22814,36622,36623,36625,36968,55851,62239,131862,156536,191053,227510,228910,7261,41409,41501,48764,162578,163638,169739,215412,215734,9821,12484,14549,16606,40429,45634,54598,54617,60516,95055,111917,117057,120409,122722,124052,128364,177501,184799,194887,39595,156884,163127,176171,184273,27533,27534,161620,166250,169012,184544,219111,227135,39939,45015,14894,42151,156273,157547,188984,189037,202490,23941,31895,31910,50516,50517,6264,8764,14026,62010,152793,156297,188972,30559,20035,20036,20047,33103,154812,171463,191632,238040,6442,26713,9055,12757,23957,38821,222614,228973,237902,9602,11148,12438,13054,14986,20037,20038,20188,20189,21500,21501,21554,22856,28881,37298,41369,48052,49318,55707,56772,156538,156619,164016,168437,168469,173277,174586,174964,200590,10889,15179,16155,153104,14438,17411,17506,33637,33640,40620,80493,102496,188508,188510,188950,23152,23956,10460,12591,19368,19525,31132,31134,41506,43397,53082,53184,53445,55633,7357,16160,40170,188576,196849,7240,9523,14524,22815,23974,38587,47499,56760,58956,158666,187060,187319,198787,237929,159144,183172,166824,232311,245690,247559,188896,246074) AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' GROUP BY p.product_id ORDER BY p.sort_order ASC, p.product_id ASC LIMIT 0,50
query time:0.0002 seconds | controller: ControllerProductCategory
SELECT FOUND_ROWS() AS `found_rows`
query time:0.0295 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '1576' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0289 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '3381' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0285 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '3485' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0284 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '3707' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0285 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '4752' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0284 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '4780' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0283 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '5575' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0287 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '6264' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0299 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '6442' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0283 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '7240' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0283 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '7261' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0283 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '7357' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0299 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '8764' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0306 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '9055' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0187 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '9523' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0188 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '9602' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0214 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '9821' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0192 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '10058' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0197 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '10276' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '10460' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0186 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '10889' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0189 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '11148' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.025 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '11969' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0282 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '12438' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0295 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '12484' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.029 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '12591' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0284 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '12757' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0284 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '13054' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0286 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '14026' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0283 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '14438' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0282 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '14524' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0285 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '14549' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0283 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '14894' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0285 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '14986' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0286 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '15179' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0284 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '16155' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0285 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '16160' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0294 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '16606' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0285 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '17411' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0286 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '17506' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0287 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '19368' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0287 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '19525' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0315 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20031' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0284 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20032' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0284 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20033' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0225 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20035' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20036' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0188 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20037' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0186 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20038' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 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-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 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-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 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 = '20039' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 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 = '1576' 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 = '3381' 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 = '3485' 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 = '3707' 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 = '4752' 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 = '4780' 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 = '6264' 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 = '6442' 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 = '7240' ORDER BY main_category DESC LIMIT 1
query time:0.0013 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '7261' ORDER BY main_category DESC LIMIT 1
query time:0.0007 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '7357' ORDER BY main_category DESC LIMIT 1
query time:0.0008 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '8764' 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 = '9055' 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 = '9523' 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 = '9602' 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 = '9821' 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 = '10058' ORDER BY main_category DESC LIMIT 1
query time:0.0021 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '10460' ORDER BY main_category DESC LIMIT 1
query time:0.0008 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '10889' 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 = '11148' 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 = '12438' ORDER BY main_category DESC LIMIT 1
query time:0.0008 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '12484' 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 = '12591' 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 = '12757' ORDER BY main_category DESC LIMIT 1
query time:0.0009 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '13054' 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 = '14026' 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 = '14438' 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 = '14524' ORDER BY main_category DESC LIMIT 1
query time:0.0007 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '14549' 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 = '14894' 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 = '14986' 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 = '15179' 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 = '16155' 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 = '16160' 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 = '16606' 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 = '17411' 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 = '17506' ORDER BY main_category DESC LIMIT 1
query time:0.0007 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '19368' ORDER BY main_category DESC LIMIT 1
query time:0.0007 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '19525' 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 = '20031' 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 = '20032' 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 = '20033' 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 = '20035' 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 = '20036' 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 = '20037' 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 = '20038' 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 = '20039' ORDER BY main_category DESC LIMIT 1
query time:0.001 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_category_to_layout WHERE category_id = '109' 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.0004 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0013 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 = '109' 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.0003 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0003 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_category_to_layout WHERE category_id = '109' 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.0003 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_category_to_layout WHERE category_id = '109' 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.0001 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0006 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.0008 seconds | controller: ControllerModuleCart
SELECT * FROM oc_extension WHERE `type` = 'total'