Категории

Метеостанции продажа, цена в Минске

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

Вид:  Сравнение товаров (0) На странице: Сортировка:
Метеостанция RST 05338
Код товара: 299773. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
160.01 Руб
Комнатный термометр RST 02717
Код товара: 297529. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
117.05 Руб
Метеостанция Ea2 ED608
Код товара: 170674. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
167.23 Руб
Метеостанция RST 07837
Код товара: 468519. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
138.04 Руб
Метеостанция RST 05535
Код товара: 468872. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
99.20 Руб
Метеостанция RST 07867
Код товара: 481907. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
111.10 Руб
Метеостанция Oregon Scientific RMR221P
Код товара: 170748. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
162.92 Руб
Метеостанция RST 88778
Код товара: 170753. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
244.33 Руб
Метеостанция RST 32705
Код товара: 170731. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
232.40 Руб
Метеостанция RST 32775
Код товара: 170732. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
246.55 Руб
Метеостанция RST 02889
Код товара: 297519. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
226.63 Руб
Метеостанция Oregon Scientific BAR223P
Код товара: 170747. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
186.23 Руб
Метеостанция RST 07819
Код товара: 297526. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
142.80 Руб
Метеостанция RST 07817
Код товара: 299775. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
121.38 Руб
Метеостанция Ea2 EN 209
Код товара: 170688. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
227.33 Руб
Метеостанция RST 02523
Код товара: 299771. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
175.26 Руб
Метеостанция RST 05337
Код товара: 468516. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
119.00 Руб
Метеостанция Oregon Scientific BAR339DP
Код товара: 468861. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
288.02 Руб
Метеостанция Oregon Scientific RRM222PN
Код товара: 468863. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
172.34 Руб
Метеостанция RST 88773
Код товара: 468875. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
166.70 Руб
Метеостанция RST 05235
Код товара: 469824. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
119.00 Руб
Метеостанция RST 05116
Код товара: 481880. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
196.69 Руб
Метеостанция RST 05330
Код товара: 481883. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
151.20 Руб
Метеостанция Oregon Scientific RAR502S
Код товара: 522687. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
165.10 Руб
Метеостанция Oregon Scientific Prysma BAR292
Код товара: 531886. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
159.29 Руб
Метеостанция Oregon Scientific BAR208S (черный)
Код товара: 704132. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
137.18 Руб
Метеостанция Oregon Scientific WMR86NS
Код товара: 704133. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
278.28 Руб
Метеостанция Ea2 ED 609
Код товара: 370430. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
139.10 Руб
Метеостанция Oregon Scientific BA900 Кристалл
Код товара: 170708. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
174.39 Руб
Метеостанция RST 05301
Код товара: 297520. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
184.45 Руб
Метеостанция Oregon Scientific WMR500
Код товара: 704131. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
711.97 Руб
Метеостанция Hama EWS-190
Код товара: 170714. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
60.86 Руб
Комнатный термометр RST 77110
Код товара: 297524. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
121.65 Руб
Метеостанция Hama EWS-185
Код товара: 382629. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
72.78 Руб
Метеостанция Hama EWS-840
Код товара: 170722. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
75.72 Руб
Метеостанция Ea2 EN203
Код товара: 170676. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
69.60 Руб
Метеостанция Ea2 ET100
Код товара: 170678. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
26.11 Руб
Метеостанция Ea2 EN206
Код товара: 170677. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
102.97 Руб
Метеостанция RST 02315 (IQ315)
Код товара: 170728. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
46.48 Руб
Метеостанция Oregon Scientific BAR206
Код товара: 170725. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
104.32 Руб
Метеостанция Hama EWS-890
Код товара: 297510. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
130.59 Руб
Метеостанция Hama EWS-370
Код товара: 170697. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
67.00 Руб
Метеостанция Hama i@Sky
Код товара: 382630. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
82.54 Руб
Метеостанция Oregon Scientific BAR806
Код товара: 170745. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ. монохромный анимационный дисплей, поддержка 3 датчиков, 160×94×46 мм, 222 г, прогноз погоды, календарь, часы, лунный календарь, предупреждение о заморозках..
75.04 Руб
Метеостанция Oregon Scientific RMR262-BK
Код товара: 299767. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
53.19 Руб
Метеостанция Ea2 BL502
Код товара: 170670. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
66.18 Руб
Метеостанция Hama 75299
Код товара: 170690. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
15.15 Руб
Внешний датчик Oregon Scientific THGN132N
Код товара: 381451. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
67.25 Руб
Метеостанция Oregon Scientific BAR368P-BK
Код товара: 370468. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
111.82 Руб
Комнатный термометр RST 02251
Код товара: 299778. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
70.64 Руб
Total time 24.9959 seconds | Total queries:150
query time:0.0002 seconds | controller:
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://techno-land.by/'
query time:0.0059 seconds | controller:
SELECT * FROM oc_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
query time:0.0002 seconds | controller: multilingual_seo
SELECT * FROM `oc_language` WHERE status = '1'
query time:0.0011 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.0004 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 = '224' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.0008 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 = '340' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.2842 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 = '340' 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.3472 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '44348'
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 = '44348'
query time:1.2274 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7493'
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 = '7493'
query time:1.5032 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7494'
query time:0.0014 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 = '7494'
query time:1.0963 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7495'
query time:0.0009 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 = '7495'
query time:1.0199 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '43447'
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 = '43447'
query time:1.0584 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '341'
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 = '341'
query time:1.177 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7496'
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 = '7496'
query time:1.2176 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7497'
query time:0.0009 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 = '7497'
query time:1.1362 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7498'
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 = '7498'
query time:1.3179 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7499'
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 = '7499'
query time:1.0807 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '41749'
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 = '41749'
query time:1.022 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '45171'
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 = '45171'
query time:0.9624 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7500'
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 = '7500'
query time:1.0629 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '342'
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 = '342'
query time:1.1379 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7501'
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 = '7501'
query time:1.0073 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '43528'
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 = '43528'
query time:1.0569 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '343'
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 = '343'
query time:1.337 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-02-28 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '7502'
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 = '7502'
query time:0.062 seconds | controller: ControllerProductCategory
SELECT DISTINCT cp.category_id FROM oc_category_path cp WHERE cp.path_id = 340
query time:0.0029 seconds | controller: ControllerProductCategory
SELECT p2c.product_id FROM oc_product_to_category p2c WHERE p2c.category_id IN (340,341,342,343,7493,7494,7495,7496,7497,7498,7499,7500,7501,7502,41749,43447,43528,44348,45171)
query time:0.0032 seconds | controller: ControllerProductCategory
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id FROM oc_product p WHERE 1=1 AND p.product_id IN (939,18077,38298,63519,64163,64602,70391,72435,77430,78934,79306,82918,128680,137497,137783,141627,141657,153012,221957,244434,5849,12072,20699,20700,22571,22995,29723,29724,42115,52965,66038,67557,69887,71394,71752,89910,134696,136136,159490,202581,202585,221939,224123,237666,57,825,2299,2304,2375,6599,9682,9727,10615,12935,13636,18647,20687,20702,20730,21075,21076,43381,62138,64969,72353,73262,77775,82195,86029,86737,94055,94311,95537,130238,130695,131117,131602,131878,154047,158859,159094,162860,163452,165085,165226,168724,184473,235782,235934,105323,107660,105347,79234,84342,86186,87139,88047,142626,142627,185446,129422,155766,160506,195522,196052,199519,211282,215797,217921,236139,246213,246510,88150,96682,102552,106943,61865,62647,62817,66099,67332,67530,70776,72688,72746,73737,74417,74635,74801,75329,77344,78344,82684,86724,86725,87541,89210,96613,101198,101417,107814,109786,110574,111964,112294,118578,129400,130884,136206,136941,139097,141550,161645,169879,176561,196159,120653,124556,117498,195688,206894,212132,219660,227293,112687,204473,226568,236826,237176,224977,225853,241217,249092) AND p.status = '1' AND p.date_available <= '2021-02-28 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.0308 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '57' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '825' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0288 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '939' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '2299' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0266 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '2304' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '2375' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0261 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '5849' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0236 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '6599' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0242 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '9682' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0248 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '9727' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0234 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '10615' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0292 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '12072' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0305 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '12935' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0293 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '13636' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.028 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '18077' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0267 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '18647' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0194 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '20687' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0238 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '20699' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0273 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '20700' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0277 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '20702' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0276 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '20730' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0226 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '21075' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0221 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '21076' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0213 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '22571' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0261 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '22995' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0261 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '29723' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0196 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '29724' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0206 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '38298' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0232 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '42115' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0253 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '43381' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0247 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '52965' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0229 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '61865' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '62138' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0207 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '62647' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0229 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '62817' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '63519' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0222 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '64163' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0245 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '64602' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0231 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '64969' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0218 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '66038' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0193 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '66099' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0205 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '67332' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0195 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '67530' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0213 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '67557' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0234 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '69887' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0215 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '70391' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0193 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '70776' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0224 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '71394' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '71752' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0261 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-02-28 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-02-28 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-02-28 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-02-28 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 = '72353' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-02-28 23:59:00' AND p2s.store_id = '0'
query time:0.0006 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '18077' 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 = '18647' 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 = '20687' ORDER BY main_category DESC LIMIT 1
query time:0.001 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '20699' 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 = '20700' 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 = '20702' 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 = '20730' 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 = '21075' 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 = '21076' ORDER BY main_category DESC LIMIT 1
query time:0.0032 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '22571' 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 = '22995' 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 = '29723' ORDER BY main_category DESC LIMIT 1
query time:0.0019 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '29724' 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 = '38298' 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 = '42115' 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 = '43381' 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 = '52965' 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 = '61865' 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 = '62138' 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 = '62647' 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 = '62817' 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 = '63519' 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 = '64163' 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 = '64602' 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 = '64969' 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 = '66038' 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 = '66099' 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 = '67332' 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 = '67530' 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 = '67557' 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 = '69887' 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 = '70391' 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 = '70776' 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 = '71394' 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 = '71752' 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 = '72353' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_category_to_layout WHERE category_id = '340' 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.0002 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0003 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.0016 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_category_to_layout WHERE category_id = '340' AND store_id = '0'
query time:0.0014 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.0015 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0013 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_category_to_layout WHERE category_id = '340' AND store_id = '0'
query time:0.0016 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.0009 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0019 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_category_to_layout WHERE category_id = '340' AND store_id = '0'
query time:0.0014 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.0003 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0004 seconds | controller: ControllerCommonFooter
SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
query time:0.0007 seconds | controller: ControllerModuleCart
SELECT * FROM oc_extension WHERE `type` = 'total'