Категории

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

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

Вид:  Сравнение товаров (0) На странице: Сортировка:
Ноутбук Digma EVE 101 ES1030EW
Код товара: 888299. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
369.83 Руб
Ноутбук Lenovo IdeaPad 110-15IBR [80T7003TRK]
Код товара: 39343. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ. 15.6" 1366 x 768 глянцевый, Intel Celeron N3060 1600 МГц, 4 ГБ, 500 Гб (HDD), Intel HD Graphics 400, DOS, цвет крышки черный, цвет корпуса черный..
557.03 Руб
Ноутбук Acer Extensa 2519-C33F [NX.EFAER.058]
Код товара: 34790. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
685.90 Руб
Ноутбук HP 15-bw058ur [2CQ06EA]
Код товара: 36919. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
613.64 Руб
Ноутбук Acer Extensa 2519-P7VE [NX.EFAER.032]
Код товара: 34826. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
691.97 Руб
Ноутбук HP 15-bw530ur [2FQ67EA]
Код товара: 37436. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
574.33 Руб
Ноутбук HP Stream 14-ax018ur 2EQ35EA
Код товара: 436124. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
636.61 Руб
Ноутбук HP 255 G6 [1WY10EA]
Код товара: 36854. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
539.02 Руб
Ноутбук HP 250 G6 2HG51ES
Код товара: 483362. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
611.22 Руб
Ноутбук HP 15-bs023ur [1ZJ89EA]
Код товара: 37374. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
551.13 Руб
Ноутбук HP 15-ra020ur 3FY64EA
Код товара: 471035. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
682.34 Руб
Ноутбук Digma Eve 1401
Код товара: 471179. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
359.67 Руб
Ноутбук Digma Citi E401
Код товара: 509612. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
462.11 Руб
Ноутбук ASUS VivoBook X540YA-XO534D
Код товара: 471068. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
507.90 Руб
Ноутбук HP 15-bw013ur 1ZK02EA
Код товара: 509949. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
608.12 Руб
Ноутбук HP 15-ra047ur 3QT61EA
Код товара: 523561. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
844.12 Руб
Ноутбук Acer Extensa 2519-P690 NX.EFAER.087
Код товара: 539356. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
715.96 Руб
Ноутбук ASUS VivoBook 15 X540NA-GQ149
Код товара: 538528. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
450.99 Руб
Ноутбук ASUS VivoBook X540YA-DM660D
Код товара: 538472. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
553.51 Руб
Ноутбук HP 15-rb008ur 3FY74EA
Код товара: 547420. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
570.91 Руб
Ноутбук ASUS VivoBook X540YA-XO648D
Код товара: 530991. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
575.91 Руб
Ноутбук ASUS VivoBook E403NA-GA041
Код товара: 547264. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
670.98 Руб
Ноутбук IRBIS NB131
Код товара: 547443. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
516.89 Руб
Ноутбук HP 15-bs640ur 3CD10EA
Код товара: 565466. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
604.32 Руб
Ноутбук HP 15-ra025ur 3FZ10EA
Код товара: 565490. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
547.31 Руб
Ноутбук HP 15-rb015ur 3QU50EA
Код товара: 553188. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
617.36 Руб
Ноутбук Lenovo IdeaPad 320-15IAP 80XR00XVRK
Код товара: 568970. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
539.04 Руб
Ноутбук Lenovo IdeaPad 320-15IAP 80XR013QRK
Код товара: 555741. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
527.33 Руб
Ноутбук Lenovo IdeaPad 330-15IGM 81D1003MRU
Код товара: 589040. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
697.70 Руб
Ноутбук Lenovo IdeaPad 320-15IAP 80XR00BSRI
Код товара: 576050. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
681.12 Руб
Ноутбук Digma EVE 604 ES6021EW
Код товара: 583203. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
497.08 Руб
Ноутбук Digma Citi E400
Код товара: 554457. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
426.65 Руб
Ноутбук ASUS X541NA-GQ041
Код товара: 598554. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
736.35 Руб
Ноутбук ASUS VivoBook X540YA-XO751D
Код товара: 605036. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
575.40 Руб
Ноутбук Lenovo IdeaPad 330-15AST 81D6001QRU
Код товара: 587061. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
955.12 Руб
Ноутбук HP 15-ra062ur 3QU48EA
Код товара: 587378. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
782.45 Руб
Ноутбук HP 15-ra066ur 3YB55EA
Код товара: 620315. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
720.32 Руб
Ноутбук HP 15-db0196ur 4MR62EA
Код товара: 626515. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
1 006.44 Руб
Ноутбук ASUS VivoBook 15 X540NA-GQ063
Код товара: 626846. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
884.82 Руб
Ноутбук Acer Aspire 3 A315-21-22UD NX.GNVER.042
Код товара: 605015. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
686.66 Руб
Ноутбук ASUS VivoBook 15 X540NA-GQ005
Код товара: 605034. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
764.78 Руб
Ноутбук Digma CITI E603 ES6020EW
Код товара: 638724. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
603.18 Руб
Ноутбук Digma CITI E602 ES6019EW
Код товара: 638749. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
655.35 Руб
Ноутбук HP 15-ra054ur 3QT87EA
Код товара: 598411. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
655.70 Руб
Ноутбук Lenovo IdeaPad 330-15AST 81D600A5RU
Код товара: 620391. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
500.57 Руб
Ноутбук HP 15-db0185ur 4MJ73EA
Код товара: 626460. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
658.80 Руб
Ноутбук HP 15-db0197ur 4MY28EA
Код товара: 626702. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
641.89 Руб
Ноутбук HP 14-ck0008ur 4KH01EA
Код товара: 626758. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
630.27 Руб
Ноутбук HP 15-db0044ur 4HB42EA
Код товара: 626682. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
587.48 Руб
Ноутбук Lenovo IdeaPad 330-15AST 81D600A6RU
Код товара: 610957. Нал. и б/н. расчёт. Профессиональная консультация в выборе. Работаем по всей РБ...
887.21 Руб
Total time 24.6629 seconds | Total queries:166
query time:0.0002 seconds | controller:
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://techno-land.by/'
query time:0.0037 seconds | controller:
SELECT * FROM oc_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
query time:0.0001 seconds | controller: multilingual_seo
SELECT * FROM `oc_language` WHERE status = '1'
query time:0.0001 seconds | controller: multilingual_seo
SELECT * FROM oc_currency
query time:0.0001 seconds | controller: multilingual_seo
SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
query time:0.0001 seconds | controller: multilingual_seo
SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
query time:0.0002 seconds | controller: ControllerProductCategory
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '1043' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.0006 seconds | controller: ControllerProductCategory
SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '4225' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
query time:0.0005 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 = '4225' 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.0004 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6306'
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 = '6306'
query time:1.1 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '9660'
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '9660'
query time:1.2503 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6305'
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 = '6305'
query time:1.2192 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6307'
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '6307'
query time:1.1027 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '4226'
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 = '4226'
query time:1.0276 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '9661'
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 = '9661'
query time:1.2348 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '29377'
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 = '29377'
query time:1.0566 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '44103'
query time:1.0543 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6309'
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 = '6309'
query time:1.245 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '41329'
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 = '41329'
query time:1.3655 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '41604'
query time:1.1692 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6308'
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 = '6308'
query time:1.2333 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '9662'
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 = '9662'
query time:1.1778 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6310'
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 = '6310'
query time:1.0378 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6311'
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 = '6311'
query time:1.1007 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6312'
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '6312'
query time:0.9853 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '9663'
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 = '9663'
query time:0.9784 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '43656'
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '43656'
query time:1.0045 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '6313'
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 = '6313'
query time:1.0635 seconds | controller: ControllerProductCategory
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0' AND cp.path_id = '9664'
query time:0.0008 seconds | controller: ControllerProductCategory
SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM oc_category t0 LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '9664'
query time:0.0439 seconds | controller: ControllerProductCategory
SELECT DISTINCT cp.category_id FROM oc_category_path cp WHERE cp.path_id = 4225
query time:0.0485 seconds | controller: ControllerProductCategory
SELECT p2c.product_id FROM oc_product_to_category p2c WHERE p2c.category_id IN (4225,4226,6305,6306,6307,6308,6309,6310,6311,6312,6313,9660,9661,9662,9663,9664,29377,41329,41604,43656,44103)
query time:0.0806 seconds | controller: ControllerProductCategory
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id FROM oc_product p WHERE 1=1 AND p.product_id IN (36675,49294,49492,51138,51191,51846,51847,52986,54363,54686,60154,60165,110382,157154,208010,49687,50043,50138,50197,50272,51316,51370,51718,51768,52601,52602,52856,52878,53033,53054,53582,54610,54893,54958,55424,55888,55991,56041,56149,56173,56208,58511,59669,59887,60649,60668,60741,60742,76300,82479,85073,86261,86325,87034,87560,87730,87965,88315,88501,91518,91970,92729,93207,93378,94753,94848,94920,94922,95081,95381,95866,96597,96600,96645,96654,97610,97714,97831,97893,97948,98230,98248,98583,98618,99004,99261,99291,99447,99744,99769,100526,100579,100580,100687,101256,101639,101888,101912,101916,102052,102547,102559,103288,103621,103940,104070,104071,104758,104801,105022,105093,105288,105291,105385,105406,105407,105658,106211,106281,106412,106873,106877,106939,106940,106968,107032,107053,107330,107435,107491,107543,107567,107569,107570,107707,107782,107783,107786,107821,107824,107825,107851,107854,107956,108248,108249,108276,108371,108395,108438,108489,108757,109027,109044,109055,109063,109624,109707,109915,110097,110194,110310,110465,110526,110728,111312,111619,111656,111785,111980,112171,112175,112326,112327,112328,112349,112399,112411,112466,112479,112481,112507,112664,112665,112692,112697,112782,112821,112973,112974,112997,113045,113079,113296,113306,113310,113352,113394,113407,113441,113442,113473,113482,113501,113543,113574,113617,113688,113689,113693,113713,113825,113846,113851,114573,114576,114836,114839,114882,114897,114998,115058,115061,115070,115077,115227,115381,115388,115390,115494,115551,115569,115638,115665,115668,115801,115926,115943,115951,115952,115986,116090,116159,116167,116169,116246,116357,116359,116363,116580,116815,116824,116881,116887,116891,116897,116920,116944,116947,116991,116996,116999,117350,117559,117666,117755,117759,117763,117807,117813,117824,117828,117831,117839,117846,117847,117879,117880,117979,118170,118182,118189,118194,118195,118199,118202,118203,118221,118284,118301,118312,118314,118315,118317,118321,118422,118432,118498,118501,118772,118881,118900,118901,118943,118974,118979,119028,119043,119059,119065,119311,119314,119402,119403,119466,119476,119482,119500,119534,119571,119595,119596,119597,119656,119691,119704,119800,119804,119809,119810,119811,119912,119913,119914,119915,119950,119979,120006,120140,120224,120225,120259,120278,120334,120340,120364,120365,120434,120435,120440,120441,120552,120553,120554,120555,120556,120561,120568,120596,120687,120837,120921,120996,120998,121000,121062,121064,121067,121068,121250,121371,121381,121384,121419,121423,121424,121428,121477,121516,121539,121541,121653,121886,121887,121899,121963,121972,122090,122166,122334,122338,122504,122550,122652,122653,122655,122693,122713,122714,122732,122770,122777,122804,122839,122841,122842,122845,122846,122847,122926,122968,122970,122973,122977,122978,122979,123122,123173,123250,123330,123409,123440,123487,123530,123574,123732,123734,123735,123770,123772,123778,124005,124007,124168,124190,124194,124598,124785,124817,124820,124826,124827,124950,124952,124957,124998,125000,125001,125036,125039,125244,125346,125352,125386,125712,125767,125868,125869,125895,125922,126005,126012,126054,126055,126150,126221,126225,126227,126467,126740,126742,126822,126872,126874,126911,126915,126916,126918,126919,126920,127236,127239,127240,127459,127532,127724,128015,128019,128048,128057,128444,128447,128595,128597,128653,128660,128663,128667,128688,128689,128692,128695,128698,128954,129137,129140,129141,129208,129216,129889,130263,130595,130890,130893,130894,132892,133448,133449,133946,133949,133977,134528,134529,134562,134833,134839,135355,135503,135857,135897,135898,135899,136489,136492,136495,136496,136753,136776,136779,137226,143982,144014,144180,144274,144284,144388,144597,144777,144880,144950,145518,145603,145606,145655,145836,145843,145906,145991,145999,146000,146008,146091,146162,146279,146292,146330,146561,146567,146573,146574,146586,146587,146597,146604,146606,146613,146614,146674,146907,146995,147000,147004,147010,147124,147141,147143,147149,147254,147256,147261,147265,147300,147304,147396,147537,147706,147758,147761,147762,147763,147801,147814,148022,148028,148029,148030,148101,148217,148350,148351,148857,151229,151290,151387,151565,151566,152136,154681,155663,155897,155981,155993,156743,157005,157071,157083,157169,157409,157712,157975,158252,158316,158334,161693,162013,162060,162112,162189,162267,162275,162289,162291,162356,162393,162413,162422,162519,162547,162574,162661,162678,162726,162783,162823,162958,162967,162968,163021,163042,163239,163251,163266,163273,163295,163319,163381,163468,163490,163540,163545,163547,163609,163691,163783,163837,163844,163860,163937,163963,163966,164083,164213,164262,164309,164324,164348,164374,164460,164465,164553,164567,164656,164758,164771,164840,164963,165401,165403,165519,165533,165678,165709,166246,166536,166599,166810,166833,166852,166860,166901,166969,166987,167095,167097,167099,167514,167581,167635,167668,167686,167847,167853,167854,167975,168195,168871,168874,168932,168973,169114,169117,169219,169538,170228,170272,170754,171271,171283,171344,171373,171623,171639,171962,172090,172092,172093,172237,172387,172389,172600,172644,172774,172916,173454,173455,173480,173842,173996,173998,174329,174399,174401,174480,174691,174692,174696,174697,174698,174766,175095,175181,175653,176140,176141,176255,176358,176360,176421,176653,177136,177138,177148,177322,177595,177677,177815,177999,178390,178578,178615,178692,178843,179017,179020,179225,179226,179330,179377,179530,180204,180205,180207,180210,180426,180822,180826,180892,181121,181181,181587,181698,181699,181700,181996,182244,182245,182246,182369,182386,182387,182547,182644,182722,182818,182900,182968,183279,183287,183508,183649,184119,184268,185240,185244,185260,185277,185373,185611,185720,185769,185860,186082,186085,186165,186275,186281,186656,186811,186894,187025,187049,187158,187312,187648,187657,187854,188266,188267,188466,188872,188875,188919,188924,188989,189256,189471,189476,189626,189699,189715,189738,189840,189873,189878,189904,189911,189951,189984,190022,190057,190068,190155,190186,190250,190255,190274,190333,190357,190388,190468,190484,190725,190773,190774,190817,190839,191185,191825,191940,192030,192474,192647,193204,193226,194415,194426,194775,194967,194978,194991,195128,195147,195165,195242,195417,195726,196057,196091,196135,196255,196415,196540,196550,196596,196605,196620,196690,196772,196809,196963,197098,197176,197413,197456,197813,198055,198395,198632,199228,199310,199465,199564,200698,200818,204333,204831,204957,204973,204987,205005,205177,205570,205607,205610,205614,205683,205943,205968,206040,206128,206215,206296,206422,206475,206545,206574,206578,206609,206614,206675,206730,206761,206852,206871,206877,206926,207033,207050,207100,207112,207167,207170,207249,207257,207301,207317,207319,207413,207507,207514,207576,207872,208182,208325,208338,208351,208484,208506,208587,208622,208632,208673,208685,208706,209221,209243,209248,209278,209308,209319,209326,209338,209367,209523,209546,211392,211422,211471,211504,211516,211973,212059,212060,212070,212086,212994,214481,214591,214680,214712,214729,214755,215000,215092,215190,215322,215330,215585,215658,215701,215922,216416,216681,216724,216827,216863,216964,217691,217696,217709,217806,218426,218564,218582,219458,219520,219656,219806,219926,221270,221456,221941,221994,222006,222008,222009,222011,222015,222037,222040,222043,222049,222072,222075,222095,222100,222130,222151,222163,222167,222205,222246,222335,222420,222428,222457,222483,222524,222555,222711,222718,222967,222992,223048,223073,223074,223096,223097,223098,223103,223144,223145,223147,223174,223175,223183,223197,223220,223221,223240,223244,223274,223296,223315,223320,223322,223323,223324,223330,223333,223379,223474,223493,223503,223524,223535,223544,223579,223911,225444,225677,225713,225716,225717,226264,226269,226284,226321,226325,226506,226538,226621,226795,226800,226897,226945,227075,227099,227297,227387,227396,227455,227492,227502,227531,227534,227793,227853,227898,227926,227955,228174,228195,228203,228269,228328,228368,228419,228519,228576,228664,228672,228690,229130,229650,229651,229654,229693,229697,231338,231820,232087,232199,232297,232300,232303,232317,232358,232385,232448,232512,232525,232596,232655,232718,232734,232777,232798,232886,233276,233294,233679,233701,233866,233964,233971,234034,234268,234298,234330,234496,234538,234579,234629,234647,234661,234671,234742,234757,234817,234844,234846,234878,234939,234945,234964,234980,235194,235652,236188,236527,236531,236586,236591,236592,236599,236602,236603,236612,236615,236693,236751,236752,236819,236824,236882,236883,236939,236958,236988,236993,237024,237050,237051,237072,237076,237160,237161,237162,237164,237213,237218,237235,237270,237303,237329,237331,237332,237426,237488,237490,237497,237565,237584,237685,237730,237795,237796,237828,237843,237898,44345,45479,50027,51767,52747,52820,53193,53612,53999,54408,54486,54606,54611,54642,54776,54946,54957,55300,55301,55302,55566,55590,55627,55628,55646,55657,55699,55746,55770,55816,55826,55862,55986,55987,56078,56237,56267,59583,60142,60588,60656,63055,64798,65159,66483,67200,68057,71871,78181,82774,85072,87057,87526,92083,92891,94570,97070,97411,98140,98364,98928,99087,99493,99540,99897,100017,101162,101163,101707,101910,102655,103913,104010,104066,104113,104228,104322,105082,105083,105123,105125,105410,105490,105656,105754,105805,105848,105866,106082,106210,106221,106222,106366,106398,106406,106411,106413,106426,106516,106614,106615,106674,106766,106871,107066,107490,107740,107741,107747,107778,107781,107853,108122,108161,108178,108290,108336,108445,108990,109025,109056,109057,109071,109189,109199,109415,109610,109612,109613,109731,109732,109962,110008,110166,110167,110525,110529,111116,111857,111981,112169,112212,112310,112324,112325,112331,112348,112400,112453,112482,112531,112533,112655,112690,112776,112780,112781,112829,112946,112988,112990,113047,113080,113344,113414,113437,113444,113451,113471,113485,113499,113573,113587,113599,113619,113621,113622,113694,113695,113826,113834,113835,113848,113957,114045,114085,114116,114120,114241,114342,114715,114780,114881,114894,114901,114986,114993,115186,115330,115441,115468,115469,115472,115475,115574,115600,115601,115682,115915,115935,115970,115971,115979,115987,116047,116144,116369,116387,116437,116509,116814,116883,116894,116922,116992,117349,117352,117453,117820,117849,117851,117984,118177,118200,118233,118283,118522,118527,118530,118957,118967,118984,119029,119066,119284,119393,119395,119404,119477,119559,119600,119601,119705,119865,119910,119980,120066,120067,120336,120337,120345,120354,120420,120484,120496,120562,120671,120672,120715,120733,120916,120919,120950,120952,121512,121584,121585,121597,121598,121893,121903,121924,121976,121980,121986,122249,122356,122624,122656,122660,123061,123338,123408,123410,123424,123426,123476,123744,123746,123771,123781,123789,124034,124080,124085,124086,124164,124181,124183,124185,124192,124195,124197,124586,124587,124759,125235,125329,125349,125351,125387,125434,125436,125479,125483,125484,125714,125842,125923,126277,126279,126465,126497,126701,126794,126820,127238,127277,127465,127466,127527,127568,127569,127574,127723,128021,128067,128690,128697,128700,128952,129143,129144,129203,129204,129232,129262,129644,129885,129893,130544,130589,130590,130599,131172,131540,134526,134840,134956,134957,134958,134966,135353,135359,135428,135570,135859,136493,137225,139703,140463,140635,143864,144529,144530,144644,145344,145407,145717,145718,145721,145722,145748,145752,145890,145891,145981,145992,145993,146012,146116,146581,146598,146610,146645,146651,146798,146803,146809,146999,147019,147127,147133,147146,147210,147255,147257,147713,147909,147910,148168,148345,148346,148348,148465,150370,150371,150733,150922,150921,150982,151128,151129,151154,151155,151184,151185,151188,151322,151338,151337,151626,151627,151645,151646,151691,151692,151693,152125,153417,153501,154397,154439,154461,154735,154762,154848,154906,155301,156397,156402,156583,156585,156640,156739,156996,157001,157029,157086,157170,157191,157203,157705,157709,158206,158319,158323,161561,161601,161709,161746,161747,161823,161860,161887,162010,162041,162043,162075,162149,162214,162218,162227,162303,162349,162352,162365,162368,162423,162445,162459,162492,162506,162529,162631,162681,162690,162717,162833,162948,162978,162993,163017,163039,163160,163164,163210,163263,163265,163270,163297,163299,163302,163318,163372,163410,163447,163586,163667,163695,163713,163721,164081,164135,164156,164193,164279,164342,164429,164462,164571,164821,165844,165901,165906,165965,165983,165989,166494,166538,166596,166605,166614,166622,166644,166854,166916,166971,167062,167067,167073,167591,167712,167844,167871,167874,167918,167920,167982,168008,168036,168044,168121,168197,168688,168779,168865,168935,169882,170177,170178,170510,170637,170658,170694,170908,171133,171323,171387,171416,171663,171664,171825,171989,172071,172091,172238,172386,172432,172433,172628,172646,172690,172693,172737,172802,172803,172804,172990,172992,173065,173071,173377,173386,173389,173443,173453,173456,173624,173632,173760,173841,173845,173849,173938,174204,174224,174227,174228,174236,174237,174554,174556,174557,174693,174695,174761,174762,174763,174767,174796,175047,175052,175161,175292,175528,175590,175592,175703,175706,176005,176136,176143,176357,176362,176454,176843,177137,177139,177140,177584,177586,177588,177814,177816,177818,177819,177820,177821,177993,178001,178209,178318,178492,178629,178819,178826,178840,178841,178844,178846,178855,178857,179021,179428,179429,179431,179741,180146,180202,180312,180507,180551,180560,180777,180880,180929,181029,181120,181124,181175,181179,181323,181346,181516,181547,181551,181793,181794,181802,181941,181994,181995,182000,182001,182166,182167,182448,182449,182451,182471,182472,182474,182513,182609,182972,182973,182975,183084,183230,183448,183505,183509,183600,183601,183650,183651,183844,183880,183881,183938,183939,184117,184122,184125,184126,184264,184266,184277,184282,185132,185166,185265,185859,185864,185865,185971,185972,185973,186031,186084,186160,186349,186351,186352,187560,187612,188649,188657,188666,188680,188821,188913,188928,189311,189672,189739,189883,189898,190003,190136,190197,190203,190234,190307,190326,190383,190515,190667,191237,191271,191824,192220,192223,192232,192278,192630,193051,193187,193461,193493,194487,194635,194787,194945,194997,195071,195283,195317,195546,195553,195719,195926,196053,196123,196133,196266,196318,196394,196559,196769,196872,197233,197250,197366,197386,197624,197659,198318,198813,198871,199186,199518,199549,201942,202173,202320,202494,202516,205010,205011,205043,205087,205365,205376,206219,206379,206383,206388,206408,206481,206717,206994,207232,207321,207736,207855,207954,208077,208087,208230,208263,208516,209198,209230,209256,209274,209389,209401,209737,211356,211393,211489,211496,211933,212165,212537,212689,214513,214967,215194,215430,215615,215683,216369,217165,217837,219490,219498,219810,221167,222007,222010,222022,222055,222060,222061,222062,222114,222116,222129,222204,222212,222222,222231,222236,222248,222266,222267,222269,222352,222354,222355,222423,222424,222425,222426,222429,223003,223010,223139,223202,223212,223237,223336,223383,223500,223537,223643,223982,224148,225720,225839,226296,226344,226347,226745,226890,226928,226985,227025,227034,227130,227174,227435,227483,227496,227529,227828,227831,227837,227839,227874,227935,227937,227945,227961,228118,228205,228216,228272,228336,228418,228468,228493,228517,228555,228556,228580,228641,228651,228656,228662,228663,228675,228682,228704,228966,228970,229098,229122,229128,229200,229204,229205,229726,230487,230515,230531,230535,230536,230550,230551,231967,232125,232186,232187,232192,232198,232219,232373,232404,232426,232562,232597,232613,232687,232806,232808,232817,232832,232979,233007,233459,233475,233688,233767,233768,233865,233879,233956,233961,234099,234639,234643,234675,234729,234743,234790,234884,234942,234974,235049,235231,235235,235294,235392,236362,236467,236469,236561,236583,236655,236759,236863,236934,236937,236941,237042,237124,237193,237290,237291,237338,237352,237440,237489,237509,237713,237757,237824,52447,52503,53181,53283,54389,54483,54609,54914,55062,55123,55880,56211,60002,60725,71989,76609,76734,76924,78805,84369,84370,86243,86771,87003,87100,87525,87561,89349,89394,89489,91972,92226,92474,92578,92905,92985,93208,93364,93379,93380,93439,93440,93513,93523,93975,94354,94358,94416,94571,94754,94755,94759,94923,94925,94928,95032,95793,95841,96200,96589,96601,97016,97061,97345,97425,97793,97896,97990,98231,98893,98986,98993,99081,99083,99267,99503,99561,99658,99660,99802,100211,100308,100871,101067,101204,101369,101640,101657,101658,101783,101892,101893,101911,101981,102055,102236,102237,102238,102549,102746,103290,103294,103459,103503,103954,104227,104323,104324,104438,104614,104664,104669,104832,104912,104913,105081,105092,105238,105384,105386,105387,105764,105826,106282,106770,106831,107207,107331,107440,107627,107703,107743,107744,107788,107792,107795,108119,108182,108185,108256,108287,108288,108297,108298,108344,108502,108667,109022,109024,109028,109066,109213,109215,109304,109325,109673,110073,110075,110165,110170,110186,110568,110626,110628,110888,110894,110921,111006,111114,111115,111663,111675,112022,112042,112135,112438,112442,112467,112663,112693,112915,112943,112947,113112,113398,113455,113457,113512,113514,113585,113603,113647,113648,113691,113759,113879,114044,114047,114090,114117,114280,114402,114568,114692,114694,114724,114769,114838,114843,114884,114885,114887,114890,114943,114946,114991,114994,114995,114996,114997,115000,115001,115002,115003,115059,115062,115066,115068,115072,115189,115263,115307,115308,115364,115387,115391,115462,115463,115552,115637,115793,115802,115803,115805,115809,115860,115937,115947,115972,115975,115985,116061,116069,116140,116142,116163,116165,116170,116172,116176,116177,116218,116304,116345,116361,116362,116388,116507,116630,116631,116826,116828,116875,116877,116878,116879,116907,116908,116935,116938,116939,116980,116990,116994,117082,117271,117520,117620,117682,117683,117762,117795,117799,117803,117804,117806,117810,117811,117819,117830,117922,118126,118169,118187,118224,118228,118230,118234,118235,118244,118271,118285,118289,118365,118497,118500,118503,118553,118929,119032,119117,119182,119202,119289,119305,119306,119309,119396,119485,119529,119533,119535,119536,119590,119593,119799,119831,119911,119939,119940,119947,119948,119975,119976,119977,119983,120001,120138,120166,120175,120277,120331,120351,120393,120481,120557,120567,120598,120628,120717,120719,120720,120721,120723,120726,120728,120734,120909,120914,120915,120926,120930,120994,120997,121001,121002,121094,121307,121308,121315,121319,121385,121402,121403,121427,121429,121430,121514,121517,121540,121655,121894,121895,121896,121897,122020,122167,122169,122180,122333,122336,122357,122444,122445,122446,122449,122455,122503,122608,122611,122623,122649,122650,122661,122697,122709,122712,122715,122756,122774,122799,122800,122802,122838,122840,122844,122927,122963,122974,122976,123100,123126,123333,123400,123401,123422,123423,123479,123485,123491,123528,123570,123736,123740,123782,123846,123859,123992,123994,124165,124166,124416,124655,124828,124830,124999,125018,125035,125041,125278,125281,125327,125331,125332,125345,125372,125494,125705,125831,125920,125926,126111,126112,126281,126358,126468,126475,126476,126495,126739,126741,126868,126871,126875,126913,126914,127184,127231,127235,127271,127890,128047,128050,128051,128054,128061,128063,128064,128065,128066,128598,128601,128647,128664,128691,128693,129210,129211,129227,129230,129265,129381,129382,129643,129890,130265,130588,130596,132813,132895,132896,133978,133979,134527,134563,134564,134849,135358,135867,135873,135874,135895,135896,136494,136772,136774,136829,136831,137235,143091,143633,143826,144088,144141,144275,144323,144325,144818,144951,144952,144993,145354,145458,145605,145723,145859,145892,145894,145986,145989,145994,146440,146583,146584,146641,146682,146722,146731,146764,147003,147012,147130,147134,147303,147538,147545,147546,147551,147556,147557,147759,147765,147767,147768,147802,147805,147807,147817,147819,147824,148003,148020,148021,148023,148025,148026,148027,148173,148221,148224,148229,148230,148257,148258,148349,148613,150977,150978,151017,151018,151027,151026,151227,151228,151304,151305,151351,151350,151429,151447,151446,151462,151471,151504,151503,151509,151660,151661,151683,151684,151922,151923,152327,152948,153247,153252,153274,153277,153295,153330,153386,153405,153423,153447,153460,153509,154075,154569,154580,154769,154786,154888,155001,155266,155737,155790,155937,155989,156323,156391,156481,156482,156483,156563,156564,156598,156632,156747,156777,157009,157187,157190,157200,157400,157672,157689,157891,157967,158197,158223,158273,158287,158315,158437,161406,161656,161716,161729,161742,161950,161967,162035,162039,162222,162276,162306,162330,162351,162408,162447,162548,162561,162575,162579,162584,162597,162607,162609,162654,162682,162714,162771,162849,162864,162866,162916,162957,163026,163233,163333,163363,163483,163488,163492,163506,163509,163527,163561,163674,163701,163723,163725,163832,163922,164072,164096,164225,164427,164529,164530,164531,164599,164639,164654,164659,164782,164832,164910,164957,165418,165685,165705,165767,166011,166020,166130,166155,166490,166634,166656,166837,166859,167121,168002,168004,168153,168571,168822,169154,169530,170203,170493,171134,171219,171561,171622,171637,171640,171690,171733,171935,171990,171991,171995,172491,172643,172645,172666,172741,172941,172942,172943,172952,172991,173069,173252,173457,173621,174003,174229,174230,174231,174232,174233,174241,174400,174436,174484,174511,174553,174555,174558,174559,174700,174764,174769,174770,175042,175044,175048,175054,175179,175289,175290,175524,175705,175885,176077,176133,176137,176138,176361,176401,176410,176542,176543,176741,176791,176936,176960,176981,177141,177219,177338,177426,177523,177587,177590,177591,177718,177719,177721,177995,177996,177997,178241,178242,178426,178627,178630,178847,178848,178854,178973,179430,179505,179509,179531,179923,179933,180061,180142,180314,180365,180367,180369,180462,180503,180504,180505,180506,180556,180758,180821,180928,180930,180933,180934,181032,181033,181345,181617,181618,181619,181708,181792,181798,181944,181998,182163,182168,182218,182450,182452,182662,182745,182883,182886,182887,182888,182897,182898,182974,182977,183082,183083,183085,183116,183117,183119,183229,183281,183453,183743,183746,183747,183937,184033,184034,184035,184120,184121,184124,184205,184206,184267,184280,185122,185124,185150,185173,185273,185624,185707,185966,186029,186083,186162,186166,186167,186168,186277,186278,186353,186354,186355,186681,186693,186695,186732,186744,186749,186754,186767,186812,186862,186880,186882,187011,187376,187377,187991,188136,188135,188219,188218,188406,188407,188835,189280,189351,189481,189490,189514,189515,189598,189869,189974,190001,190033,190079,190088,190109,190111,190152,190167,190263,190385,190560,190783,191492,191633,191641,192022,192468,193004,194404,194442,194828,194963,195406,195419,195445,195548,195549,195583,195607,195758,195761,195766,195767,195783,195826,195877,195928,196015,196089,196107,196125,196233,196364,196428,196582,196619,196716,197234,197279,197399,197637,198937,199460,199489,199504,199528,204375,204613,204772,204792,204853,204917,206167,206196,206989,206998,207008,207241,207780,208460,209461,209545,209570,211895,212045,212075,212080,214330,214596,214630,214639,214707,214709,214714,214749,214819,215233,215250,215254,215514,215747,215825,215959,216503,216765,217666,217940,218386,221055,221946,222714,223030,223100,223260,223295,224102,224208,225491,225707,225721,226224,226294,226681,226922,226979,227032,227208,227420,227437,227452,227790,227933,227979,228144,228152,228168,228186,228192,228430,228915,229153,230342,232747,233158,233214,233264,233472,234193,234213,234249,234294,234299,234309,234326,234338,234412,234414,234418,234420,234435,234447,234453,234470,234476,234478,234489,234521,234522,234529,234548,234576,234578,234590,234597,234665,234688,234713,234714,234717,234733,234872,234881,234892,234946,234949,234984,235179,235209,235244,235264,235578,235983,236281,236485,236517,236528,236550,236620,236712,236742,236757,236785,236803,236812,236876,236879,236931,236933,236974,237009,237071,237078,237094,237098,237145,237204,237342,237413,237416,237708,237753,237789,237794,237905,237920,237921,237922,44504,45786,47196,47860,49113,49201,49285,49828,49900,50143,50485,50709,50754,51387,51547,51716,51857,52085,52096,52097,52102,52254,52384,52626,52687,52748,52839,52930,52973,53092,53583,53664,53764,53814,53938,54011,54411,54503,54561,54607,54659,54660,54855,55567,55578,55710,55832,55833,55869,55898,55913,57680,59239,59730,60104,60249,60503,61542,61993,63058,64132,64777,65368,65391,65473,65705,65905,67887,67995,68115,69225,70666,71822,74730,74756,74978,75148,75785,77047,77077,77311,77438,77565,77667,78657,79524,80854,82843,83003,83177,83211,84094,84437,84438,84439,84471,85048,85074,85209,86245,86259,86260,86326,86772,86773,87004,87005,87006,87060,87061,87308,87309,87310,87562,87563,88321,88419,88760,89013,89088,89395,89582,89589,90202,90427,90727,90780,91529,91952,92208,92475,92575,93403,93976,94572,94573,94574,94575,94576,94765,94924,94926,95538,95590,95873,96297,96484,96591,96592,96655,97344,98068,98249,98360,98363,98365,98366,98367,98368,98369,98370,98371,98372,98373,98749,98776,98930,98931,98932,98933,98934,98935,99142,99143,99144,99161,99226,99262,99263,99265,99266,99292,99293,99294,99295,99296,99299,99300,99325,99448,99492,99522,99523,99524,99525,99526,99527,99528,99529,99530,99531,99532,99533,99534,99535,99536,99537,99592,99593,99594,99595,99596,99659,99740,99741,99743,99791,99792,99793,99910,99911,99912,99915,99916,99917,99919,100084,100085,100117,100118,100160,100161,100162,100213,100214,100215,100334,100369,100370,100371,100372,100373,100375,100376,100377,100378,100379,100380,100506,100563,100564,100622,100733,100779,100887,100888,100976,101007,101033,101073,101179,101199,101205,101239,101243,101244,101248,101255,101257,101258,101259,101260,101261,101262,101292,101293,101294,101295,101368,101370,101393,101394,101397,101398,101424,101446,101447,101493,101638,101704,101705,101708,101709,101711,101991,102056,102205,102265,102554,102555,102558,102937,102940,103458,103576,103946,104633,104663,104671,104979,105010,105175,105178,105193,105278,105297,105399,105403,105404,105405,105409,105415,105439,105440,105441,105442,105478,105655,105731,105762,105812,105813,105827,105846,105909,106015,106016,106018,106020,106021,106022,106023,106087,106121,106219,106220,106223,106224,106234,106399,106408,106410,106427,106438,106439,106493,106494,106497,106531,106594,106600,106631,106669,106670,106671,106675,106768,106771,106779,106861,106944,106985,107029,107092,107133,107134,107185,107198,107199,107206,107210,107253,107492,107568,107632,107779,107780,107784,107787,107838,107927,107994,107995,107997,108168,108325,108538,108668,108762,108808,108874,108967,108968,108969,108970,109042,109043,109046,109047,109048,109049,109050,109051,109058,109070,109107,109212,109214,109216,109217,109218,109232,109313,109323,109326,109327,109334,109356,109614,109623,109708,109733,109734,109737,109739,109802,109877,109909,109933,109934,109963,110009,110074,110100,110136,110169,110262,110306,110337,110338,110379,110380,110417,110427,110454,110488,110489,110527,110644,110645,110701,110716,110785,110839,110919,110922,110943,110954,110968,110982,111011,111118,111187,111189,111309,111310,111356,111391,111438,111620,111640,111641,111678,111679,111681,111682,111698,111722,111737,111799,111801,111803,112007,112010,112014,112016,112099,112126,112134,112167,112170,112339,112350,112408,112409,112410,112437,112508,112662,112691,112775,112989,113243,113244,113245,113278,113304,113350,113393,113420,113435,113484,113540,113611,113624,113670,113671,113673,113687,113718,113722,113829,113830,114055,114080,114087,114088,114097,114392,114781,114840,114879,114886,114969,114982,114988,114989,115067,115178,115225,115226,115474,115687,115718,115790,115796,115799,115812,115813,115933,115945,115946,115948,115950,115959,116085,116095,116143,116180,116181,116185,116220,116247,116248,116251,116263,116358,116364,116365,116366,116367,116368,116438,116439,116473,116506,116508,116619,116620,116621,116742,116816,116819,116822,116827,116829,116884,116910,116936,116979,117014,117018,117254,117257,117259,117263,117276,117317,117460,117514,117516,117517,117521,117522,117573,117669,117672,117689,117704,117976,117978,117980,117982,117983,117985,117993,117994,118053,118054,118079,118081,118167,118168,118171,118222,118223,118225,118231,118238,118239,118240,118241,118242,118243,118282,118287,118288,118290,118295,118297,118298,118299,118320,118363,118495,118499,118502,118504,118525,118526,118528,118529,118594,118604,118650,118652,118879,118903,118914,118915,118916,118917,118972,119031,119038,119047,119048,119083,119084,119085,119114,119118,119178,119181,119183,119184,119185,119189,119266,119268,119269,119270,119271,119272,119280,119281,119285,119286,119287,119288,119290,119291,119292,119310,119394,119470,119471,119472,119478,119479,119481,119483,119528,119537,119538,119540,119560,119570,119591,119594,119598,119599,119657,119676,119699,119801,119905,119916,119937,119938,119942,119943,119944,119949,119952,119978,120139,120251,120261,120330,120335,120355,120363,120389,120394,120395,120417,120438,120482,120558,120559,120560,120594,120595,120599,120600,120625,120626,120629,120673,120676,120716,120722,120724,120732,120735,120736,120737,120910,120917,120924,120925,120928,120929,120931,120947,121063,121305,121310,121314,121316,121318,121320,121358,121360,121378,121404,121405,121406,121407,121408,121431,121447,121481,121482,121483,121484,121515,121535,121537,121543,121588,121589,121590,121591,121669,121898,121921,121922,122140,122168,122170,122355,122401,122450,122451,122452,122453,122454,122456,122457,122546,122646,122666,122667,122669,122703,122704,122705,122706,122707,122708,122710,122830,122832,122833,122959,122975,123063,123124,123125,123249,123300,123301,123302,123303,123327,123337,123407,123425,123466,123467,123478,123481,123482,123483,123492,123493,123524,123526,123531,123532,123533,123575,123625,123666,123668,123671,123705,123708,123711,123712,123713,123738,123739,123742,123747,123779,123780,123783,123786,123802,123838,123907,124006,124008,124009,124079,124186,124251,124258,124392,124429,124560,124656,124819,124821,124822,124823,124824,124833,124865,124955,124992,124993,124994,124997,125255,125272,125273,125274,125276,125279,125280,125284,125333,125348,125365,125371,125373,125433,125481,125503,125570,125761,125764,125889,125890,125892,125921,126016,126226,126273,126275,126280,126364,126411,126493,126494,126496,126498,126666,126876,127237,127269,127270,127272,127274,127275,127276,127278,127989,128016,128049,128058,128059,128060,128068,128096,128211,128617,128648,128649,128699,129136,129142,129214,129215,129261,129263,129264,129894,130183,130189,130264,130266,130268,130545,130546,130591,130592,130593,130594,130647,130699,130891,130892,130897,131068,131159,131253,131750,131751,131752,132772,132773,132775,132776,132777,132778,132779,132807,132809,132810,132814,132815,132816,132887,132888,132890,132893,132894,132914,133790,133973,133974,133976,134445,134846,134853,134951,134952,134967,135146,135271,135363,135856,135868,135869,135870,135871,135872,136224,136260,136752,136775,138415,139983,140389,141500,141866,142319,142650,142656,142657,142658,142791,142792,142989,143742,143865,144021,144389,144391,144448,144531,144532,144533,144534,144535,144537,144538,144541,144542,144543,144544,144545,144547,144548,144598,144639,144640,144641,144642,144645,144648,144719,144774,144908,145552,145556,145604,145607,145608,145681,145797,145893,145895,146087,146093,146094,146095,146105,146107,146109,146218,146248,146250,146251,146315,146319,146321,146322,146331,146332,146362,146563,146571,146578,146585,146595,146601,146642,146667,146681,146800,146879,147007,147015,147017,147020,147138,147144,147206,147208,147212,147214,147216,147219,147239,147259,147260,147262,147263,147267,147274,147298,147299,147302,147305,147306,147330,147394,147398,147443,147531,147532,147533,147535,147539,147541,147542,147547,147548,147550,147708,147709,147808,147809,147811,147816,147818,147820,147822,147823,147825,147826,147827,148005,148015,148024,148031,148103,148220,148225,148668,149207,149777,149935,150267,150604,150605,150747,150748,150833,150834,151004,151005,151238,151239,151307,151404,151403,151457,151458,151467,151472,151480,151481,151482,151569,151633,151642,151700,151789,151790,152097,152098,152171,152172,152530,153035,153217,153270,153287,153391,153407,153442,153486,153504,154574,154616,154630,154646,154650,154682,154847,154886,154938,154994,155282,155490,155505,155506,155591,155671,155676,155698,155708,155735,155736,155947,155966,155978,156308,156312,156355,156387,156400,156480,156523,156560,156569,156593,156594,156636,156637,156661,156734,156742,156745,156776,156879,156972,157023,157058,157084,157103,157185,157660,157677,157713,158172,158240,158276,158279,158292,158312,158317,159371,161655,161683,161685,161713,161762,161828,161943,161968,162057,162113,162164,162168,162238,162278,162279,162314,162315,162524,162576,162592,162640,162780,162848,162873,162874,162884,162894,162915,162964,163037,163043,163301,163420,163449,163464,163529,163590,163666,163960,164071,164195,164208,164211,164249,164269,164308,164327,164358,164408,164472,164494,164496,164833,164904,165661,165760,165902,165961,165971,166038,166059,166523,166576,166618,166664,166671,167124,167423,167435,167845,167865,168003,168067,168084,168769,168821,168847,168876,169077,169096,169115,170282,170491,170509,170689,170790,170924,170991,170993,171059,171241,171281,171285,171286,171342,171343,171389,171546,171625,171803,171888,171931,171992,172056,172239,172242,172243,172278,172281,172282,172738,172740,172773,173388,173440,173441,173789,174045,174238,174278,174395,174497,174546,174560,174561,174562,174699,174768,174795,174840,174985,175046,175246,175471,175525,175595,175596,175650,175654,175882,176356,176411,176414,176451,176536,176740,176788,176789,176794,176795,177143,177144,177220,177293,177427,177549,177589,177593,177594,177660,177748,177770,177845,177939,178137,178138,178152,178243,178425,178430,178432,178727,178780,178858,179167,179201,179224,179507,179508,179565,179630,179926,180008,180208,180619,180759,180780,180824,181012,181178,181180,181310,181543,181544,181616,181702,181704,181705,181797,181927,181939,181940,181942,181946,182002,182003,182248,182262,182388,182389,182473,182515,182516,182517,182518,182529,182530,182623,182678,182817,182885,183276,183283,183506,184118,184132,184283,185067,185449,185708,186028,187558,187738,187931,188210,188213,188352,188353,188385,188386,188644,188648,188655,188856,189064,189243,189290,189310,189335,189601,189612,189629,189752,189823,189849,189851,189865,189872,189893,189901,189935,189960,189981,189988,190006,190070,190140,190142,190157,190191,190201,190227,190243,190256,190257,190389,190581,190731,190732,190767,190768,191661,191776,191802,192111,192228,192379,192437,192507,192720,193218,193438,194434,194874,195141,195143,195161,195520,195696,195704,195728,195889,195920,195978,196485,196873,196992,197027,197180,197453,197680,197779,197794,198035,198219,198248,198863,200465,200982,201681,202746,203378,203607,203677,204421,204461,204649,204678,204821,204828,204990,205009,205041,205085,205089,205333,205452,205470,205544,205876,206082,206083,206148,206166,206214,206220,206284,206392,206473,206550,206830,206904,206975,207097,207228,207239,207262,207333,207348,207371,207503,207738,208034,208046,208094,208286,208294,208330,208341,208432,208437,208445,208453,208531,208533,208588,208617,208637,208686,208699,209027,209288,209472,209474,209525,209532,209583,209585,209733,209743,210355,210575,210638,210975,211148,211155,211335,211363,211405,211423,211485,211502,211511,211513,211515,211521,211602,212069,212073,212076,212385,212422,212435,212971,213214,214475,214536,214613,214633,214897,215188,215275,215685,215700,215948,216145,216351,216364,216437,216597,216772,216774,217698,217699,217716,217718,217721,218125,219394,219454,219795,219934,220190,220695,221025,221071,221427,222013,222016,222026,222405,222466,222976,223029,223070,223075,223126,223218,223517,224250,224755,224774,224846,224986,225044,225125,225157,225294,225299,225397,225500,225524,225648,225669,225692,225778,225790,225808,225852,225983,226035,226042,226330,226418,226441,226444,226507,226517,226713,226718,226787,226810,226812,226852,226909,226934,226941,226971,227036,227097,227132,227188,227199,227202,227289,227290,227351,227371,227376,227412,227432,227513,227542,227570,227596,227733,227856,227862,228015,228065,228115,228175,228181,228193,228297,228424,228515,228574,228591,228760,228772,228796,229061,229188,229198,229436,229658,230250,230418,230430,230477,230492,230867,231150,231181,231187,231335,232040,232143,232251,232333,232478,232544,232642,232673,233223,233272,233289,233304,233507,233820,233843,233860,233957,233967,234009,234011,234097,234585,234640,234710,234792,234803,234804,234876,234889,234890,234932,234936,235027,235290,235324,236421,236515,236611,236632,236737,236743,236816,236817,236907,236920,236961,236987,237105,237239,237246,237333,237345,237414,237431,237443,237506,237513,237583,237737,237755,237769,237837,237848,237858,245833,54317,109918,216864,219484,221575,221626,222513,249696,50274,53066,53067,53118,53929,54111,54786,185579,214594,237842,60669,43801,50772,50791,50915,51110,51382,51963,52175,53425,53613,54010,54596,54608,54839,54929,55060,55134,55171,55299,55526,55527,55565,55577,55735,55736,55769,55789,56065,56151,56270,56329,56635,56826,56827,56978,57184,60089,60267,60278,60386,60387,60472,60655,61135,63469,63562,63614,64513,65293,69420,69518,69974,70990,71586,72115,74783,76161,76819,76894,77613,79870,80179,80231,80515,81466,86244,87606,88261,88727,89111,90230,90341,90461,90777,91338,91406,91432,91861,91895,91897,92210,92554,92555,92854,92977,93203,93210,93400,93404,93657,93846,93945,94046,94047,94057,94233,94417,94424,94538,94539,94580,94581,94598,94756,94888,94895,94921,94927,94933,95033,95461,95591,95592,95593,95867,95897,95898,95902,96291,96292,96608,96665,96666,96670,96750,96752,96753,96755,96971,97220,97265,97296,97341,97342,97391,97392,97476,97482,97550,97715,97792,97794,97796,97802,98418,98430,98431,98470,98471,98472,98475,98595,98596,98619,98664,98750,98759,98897,98936,98983,98987,98988,99227,99264,99298,99321,99328,99494,99538,99539,99574,99575,99597,99738,99814,99861,99908,100018,100237,100238,100239,100309,100507,100508,100657,100872,100889,100951,100952,100953,100954,100955,100961,101072,101402,101647,101669,101827,101889,102051,102276,102741,103292,103293,103914,104291,104665,104840,104841,104914,105342,105344,105389,106017,106414,106441,106548,106878,107158,107273,107332,107419,107421,107594,107595,107597,107922,107924,108083,108084,108114,108116,108169,108217,108277,108292,108340,108621,108989,109041,109233,109331,109961,110071,110139,110336,110348,110418,110493,110713,110959,110980,111014,111040,111137,111377,111379,111497,111639,111642,111677,111680,111982,112011,112012,112074,112112,112172,112311,112322,112454,112473,112474,112477,112552,112624,112777,112778,112779,112875,112907,112949,112977,113307,113351,113409,113433,113438,113445,113476,113477,113546,113576,113614,113651,113672,113719,113850,113852,114046,114131,114254,114256,114404,114572,114575,114581,114717,114837,114842,114844,114880,114892,114999,115060,115069,115073,115075,115123,115181,115386,115466,115470,115471,115491,115495,115567,115571,115575,115597,115598,115599,115636,115642,115688,115729,115738,115808,115825,115906,115928,115930,115944,115949,115958,115961,115962,115974,115988,116164,116166,116168,116178,116179,116253,116296,116360,116659,116813,116885,116886,116889,116892,116914,116919,116937,116941,116942,116952,116956,116993,116995,116997,116998,117218,117315,117343,117459,117472,117515,117519,117523,117524,117526,117684,117687,117778,117794,117796,117797,117800,117805,117808,117809,117812,117817,117822,117829,117919,117975,117981,118055,118076,118178,118179,118180,118181,118183,118188,118227,118254,118257,118303,118366,118433,118496,118596,118648,118651,118740,118770,118944,118946,118973,118976,118977,118978,119024,119026,119033,119061,119186,119188,119273,119274,119283,119313,119398,119405,119473,119474,119526,119530,119568,119802,119808,119824,119826,119830,120003,120167,120332,120333,120338,120339,120341,120342,120343,120344,120390,120391,120392,120442,120447,120448,120449,120450,120466,120627,120670,120674,120675,120689,120718,120725,120727,120911,120912,120913,120922,120923,120927,120948,120999,121093,121317,121361,121379,121380,121382,121421,121422,121476,121478,121480,121511,121513,121534,121538,121586,121587,121857,121889,121892,121901,121902,121971,121973,121974,122018,122019,122194,122337,122400,122547,122548,122549,122607,122610,122613,122644,122648,122657,122668,122690,122691,122692,122694,122695,122699,122711,122775,122837,122962,122980,123123,123248,123251,123252,123253,123254,123299,123402,123403,123404,123405,123406,123421,123427,123428,123429,123430,123464,123477,123480,123512,123513,123529,123535,123572,123644,123702,123703,123704,123707,123709,123731,123733,123737,123743,123745,123768,123769,123784,123785,123787,123788,123844,123847,123848,123908,124003,124196,124218,124417,124559,124654,124786,124787,124788,124789,124818,124829,124938,124939,124948,124949,124951,124953,124954,124956,124996,125038,125252,125275,125282,125328,125341,125347,125350,125389,125392,125393,125489,125504,125711,125716,125758,125870,125891,125893,125894,125896,125897,125924,125927,126006,126008,126009,126014,126015,126222,126223,126228,126274,126276,126278,126354,126363,126669,126825,127232,127233,127234,127266,127267,127268,127567,128018,128020,128055,128056,128082,128449,128450,128594,128600,128646,128650,128661,128666,128694,128696,128951,129138,129139,129224,129225,129226,129228,129267,130186,130262,130267,130547,130597,130600,130900,131160,132015,132198,132774,132811,132891,132919,133353,133450,133789,133980,134834,134835,134836,134837,134838,134843,134844,134845,134848,134850,134954,134960,135499,135858,135865,136490,136497,136513,136754,136756,136769,136770,136771,136773,136828,136830,136832,137480,137880,143027,143634,143636,144092,144392,144393,144396,144446,144469,144470,144539,144649,144819,144820,144954,145401,145609,145610,145612,145613,145720,145980,145983,146002,146005,146111,146164,146184,146271,146318,146359,146360,146365,146367,146369,146370,146441,146448,146580,146582,146591,146600,146646,146664,146724,146801,146875,146998,147002,147016,147018,147068,147072,147123,147128,147129,147132,147137,147140,147207,147218,147220,147221,147258,147543,147552,147554,147555,147640,147641,147711,147712,147714,147800,147803,147804,147806,147810,147812,147813,147815,147821,147828,147903,147906,148000,148001,148004,148012,148013,148014,148102,148162,148222,148223,148226,148228,148231,149164,149993,150680,150679,150727,150728,151035,151182,151186,151187,151287,151306,151391,151401,151452,151453,151615,151643,151644,151650,151649,151662,151663,152151,152193,152194,153209,153245,153267,153272,153289,153304,153313,153455,154340,154588,154590,154602,154614,154703,154736,154844,154856,154920,155000,155300,155326,155341,155556,155623,155700,155728,155742,155752,155980,155986,155987,156007,156015,156079,156440,156466,156553,156581,156589,156642,156663,156664,156669,157060,157080,157085,157112,157120,157189,157202,157205,157670,157678,157870,157935,158229,158321,158331,158346,158362,161694,161758,161763,162205,162223,162292,162296,162347,162399,162420,162455,162531,162611,162612,162658,162673,162713,163019,163038,163175,163255,163416,163442,163546,163591,163597,163632,163657,163720,163778,163787,163795,163820,163883,163893,164063,164117,164228,164237,164345,164347,164426,164475,164565,164689,164759,164816,164847,164915,164939,165604,165707,165849,165907,166013,166016,166083,166087,166096,166509,166744,166857,166989,167079,167090,167125,167128,167328,167411,167622,167705,167738,167863,167956,168113,168115,168150,168687,168846,168971,168994,169283,169292,169744,169773,169774,169936,169944,170169,170492,170501,170619,170685,170884,171128,171129,171130,171242,171282,171284,171346,171445,171501,171638,171857,171889,171963,172072,172234,172361,172362,172627,172743,172776,172862,172914,172945,172946,172947,172948,172950,172975,173070,173251,173404,173405,173406,173481,173482,173483,173622,173623,173625,173634,173788,173843,173936,173939,174004,174135,174136,174161,174234,174398,174458,174481,174482,174749,174886,175041,175093,175185,175244,175319,175347,175512,175513,175514,175527,175638,175640,175648,176008,176078,176135,176165,176363,176402,176413,176422,176423,176424,176449,176453,176544,176547,176786,176787,176798,176958,177149,177218,177339,177678,177679,177806,177846,177847,177928,177994,178024,178025,178429,178488,178665,178696,178845,179018,179019,179022,179095,179143,179162,179169,179314,179316,179322,179401,179511,179564,179631,179635,179801,179802,179803,179879,180149,180200,180201,180216,180362,180368,180460,180561,180620,180725,180820,180825,180881,180931,181126,181182,181254,181256,181324,181325,181348,181350,181542,181546,181715,181947,181949,182162,182164,182165,182169,182219,182232,182247,182261,182332,182379,182380,182650,182652,182653,182654,182679,182685,182816,182899,182902,182967,183086,183114,183284,183285,183286,183450,183451,183507,183577,183602,183744,183745,183749,183783,183845,183847,183910,184032,184036,184203,184208,185100,185103,185275,185670,185786,185787,185788,185863,185867,186030,186161,186163,186203,186280,186282,186696,187212,187284,187529,187608,187844,187848,187857,187864,187876,187903,187919,187967,188014,188015,188034,188035,188206,188235,188236,188483,188665,188771,188818,188825,188827,188854,188886,188906,188971,189014,189102,189315,189323,189342,189527,189706,189755,189868,189880,189891,189925,189947,189976,190037,190119,190143,190154,190214,190229,190247,190550,190583,190654,190674,190708,191193,191257,191259,191286,191401,191435,191639,191644,191937,192235,192252,192453,192742,192795,192849,193182,193185,193479,193481,193916,194461,194483,194549,194855,194888,195122,195169,195319,195325,195332,195441,195530,195684,195798,195818,196152,196265,196312,196574,196622,196666,196707,196709,197108,197111,197118,197139,197142,197231,197260,197458,197831,197884,198215,198550,198583,198763,198764,199096,199461,199468,199497,199590,200296,200349,200475,200722,201131,201152,201225,201287,201838,202194,202195,202252,202303,202316,202408,202496,202502,202503,203000,203153,203349,203379,203491,204209,204425,204715,204868,204983,204984,205059,205062,205209,205245,205314,205387,205440,205487,205489,205547,205669,205671,205741,205932,205969,205980,206015,206022,206068,206071,206156,206198,206413,206549,206604,206686,206770,206782,206945,206955,207024,207034,207162,207165,207198,207200,207221,207291,207342,207345,207346,207417,207475,207520,207569,207571,207627,207717,207812,207878,207941,207950,208074,208099,208211,208269,208274,208323,208328,208381,208415,208421,208455,208479,208486,208551,208576,208582,208603,208650,208712,208764,209016,209088,209241,209336,209343,209352,209369,209509,209518,209541,209682,210222,210445,210642,210800,210965,211198,211255,211256,211279,211469,211569,211780,211943,212065,212732,212733,212742,212839,212968,213905,214572,214620,214635,214640,214801,214810,214833,215164,215180,215255,215257,215268,215279,215294,215326,215373,215397,215401,215421,215429,215483,215487,215494,215562,215605,215633,215704,215718,215759,215770,215785,215833,215840,215889,215896,215906,215907,215936,215947,215953,215958,215962,216010,216127,216137,216166,216171,216227,216229,216291,216518,216590,216593,216670,216680,216689,216813,216866,216957,216967,216970,216972,216978,217133,217150,217173,217208,217237,217376,217467,217765,217809,217824,217843,217847,217901,217923,218098,218180,218184,218202,218333,218387,218636,218847,218897,219137,219383,219386,219400,219482,220063,220147,220252,220253,220743,220972,221225,221272,221275,221336,221338,221403,221540,221558,221610,221745,221794,221985,221990,222003,222024,222035,222044,222059,222099,222102,222309,222399,222400,222412,222415,222418,222421,222468,222477,222680,222715,222882,222909,222931,222933,222942,222950,223043,223052,223091,223127,223171,223265,223316,223317,223419,223502,223518,223560,223566,223606,223659,225307,225373,225394,225446,225549,225662,225679,225727,225832,225968,226026,226036,226109,226140,226160,226190,226193,226194,226214,226247,226380,226511,226612,226687,226748,226768,226813,226837,226841,226866,226946,226980,226987,227039,227138,227151,227189,227207,227222,227223,227252,227269,227363,227418,227475,227476,227515,227597,227801,227822,227893,227913,227929,228029,228037,228078,228082,228105,228107,228127,228167,228289,228312,228313,228331,228365,228381,228420,228546,228566,228894,228912,229065,229104,229202,229403,229460,229608,229708,230389,230415,230463,230503,230546,230841,231209,231792,231959,232031,232058,232081,232201,232289,232298,232304,232316,232327,232400,232535,232571,232589,232618,232659,232686,232735,232783,232874,232905,232931,232943,232969,232970,232997,233051,233067,233105,233124,233417,233498,233672,233809,233833,233855,233857,233867,233886,233891,233917,234554,235280,235714,235768,236050,236215,236374,236444,236450,236498,236510,236522,236524,236551,236589,236593,236596,236601,236641,236670,236672,236673,236675,236686,236697,236765,236815,236848,236849,236867,236874,236881,236911,236928,236959,236997,237047,237049,237100,237187,237190,237192,237207,237225,237232,237259,237301,237346,237365,237394,237402,237478,237557,237610,237736,237754,237771,237779,237780,237831,237871,237888,237892,237893,237906,237912,53011,55762,60135,162251,164136,176006,197756,205987,207435,248230,63224,64091,74292,74770,75557,78688,82916,82973,93816,95530,96054,96782,101741,101774,104831,111965,111974,112041,115461,115573,115810,117825,118196,120550,120995,122065,122651,122801,122961,122971,122972,126869,129213,129223,134002,134524,134525,135313,135334,137563,140938,143915,146207,147760,158005,166210,173846,178002,179023,181123,184484,203676,205605,209590,221389,224982,224992,225203,225563,225902,227463,231893,232151,232197,232818,232841,233505,234594,234715,234911,235273,236842,237171,237918,104290,104632,107451,121003,121004,121069,121070,122843,123099,126912,148227,154770,154965,161599,161858,162688,165985,174030,233246,111516,164789,173154,234613,64479,71027,75038,86774,91403,91434,91450,92211,92229,92928,99320,99742,100216,100623,106071,106492,106874,107813,108247,109031,109414,110810,111147,112475,112820,112872,112876,113479,114770,114893,115464,115473,115929,115932,115936,116297,116812,116882,116893,116895,116896,117845,117850,118083,118198,118316,118318,118982,119480,119532,120630,121312,121313,121518,121536,121677,121888,122447,122448,122612,122647,122662,122701,122702,122925,122928,123137,123495,123845,124641,124643,124644,124677,124678,124825,124995,125037,125369,126827,126877,126878,126879,126881,126891,128052,128053,128062,128485,128599,128651,129229,129895,129919,132808,132838,132913,134953,135866,136512,137240,137241,144390,144394,145656,147008,147069,147135,147145,147540,147549,148002,148006,148007,148008,148009,148010,148011,148016,148017,148018,148019,148169,148170,148171,148172,151194,151193,151468,152148,152149,153300,155005,155951,155998,156398,156411,156599,157014,157688,158291,158348,158443,161700,162331,162555,162656,162728,162870,164288,166042,171466,172279,172280,172736,172739,172805,173442,173762,174138,175593,175594,176359,176541,177998,178820,180778,181125,181127,181926,183282,186081,186283,186829,188095,190277,190310,190352,190613,195119,195568,195895,196090,196528,202548,205337,208895,209138,223426,226024,227284,228688,232285,232450,233177,234157,234679,234859,234925,235211,236463,236584,236600,236638,236649,236707,236708,236734,236744,236745,236762,236897,236901,236908,236914,236924,236948,236978,236990,237148,237152,237231,237240,237266,237286,237287,237302,237364,237374,237398,237401,237548,237782,237856,63397,72294,92212,98093,100381,100411,104016,106876,110627,114673,117844,119282,120564,121309,121311,123741,145811,146001,147904,155845,164474,170502,170791,172806,172951,174285,174906,175510,175886,176011,176455,177038,179407,183452,186713,186720,189447,189462,194698,198775,198922,198935,198951,198959,199552,199697,203531,204238,207888,207914,209087,224669,228648,232174,232233,163734,166632,168103,185147,185161,198607,223922) AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' GROUP BY p.product_id ORDER BY p.sort_order ASC, p.product_id ASC LIMIT 0,50
query time:0.0003 seconds | controller: ControllerProductCategory
SELECT FOUND_ROWS() AS `found_rows`
query time:0.0185 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '36675' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.018 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '43801' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0207 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '44345' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.02 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '44504' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0185 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '45479' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0198 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '45786' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0188 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '47196' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0216 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '47860' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0178 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49113' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0202 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49201' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0235 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49285' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.021 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49294' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.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-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49492' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0223 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49687' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0219 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49828' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.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-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '49900' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0188 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50027' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.02 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50043' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.023 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50138' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.021 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50143' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0201 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50197' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0207 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50272' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.019 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50274' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.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-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50485' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0283 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50709' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.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-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50754' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0257 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50772' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0263 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50791' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0209 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '50915' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0252 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51110' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0227 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51138' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0199 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51191' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0192 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51316' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0183 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51370' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.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-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51382' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.02 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51387' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0197 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51547' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0192 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51716' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.02 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51718' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0214 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51767' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0184 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51768' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0189 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51846' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0219 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51847' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0184 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51857' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0188 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '51963' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0188 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '52085' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.018 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '52096' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.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-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '52097' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0223 seconds | controller: ControllerProductCategory
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2021-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '52102' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.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-03-01 23:59:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2021-03-01 23:59:00')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2021-03-01 23:59:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2021-03-01 23:59:00')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '52175' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2021-03-01 23:59:00' AND p2s.store_id = '0'
query time:0.0005 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '36675' 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 = '43801' 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 = '44345' 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 = '44504' 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 = '45479' 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 = '45786' 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 = '47196' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '47860' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '49113' ORDER BY main_category DESC LIMIT 1
query time:0.0003 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '49201' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '49285' 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 = '49294' 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 = '49492' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '49687' 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 = '49828' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '49900' 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 = '50027' 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 = '50043' 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 = '50138' 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 = '50143' 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 = '50197' 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 = '50272' 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 = '50274' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '50485' 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 = '50709' 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 = '50754' 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 = '50772' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '50791' 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 = '50915' 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 = '51110' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '51138' 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 = '51191' 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 = '51316' 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 = '51370' 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 = '51382' 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 = '51387' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '51547' 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 = '51716' 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 = '51718' 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 = '51767' 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 = '51768' 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 = '51846' 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 = '51847' 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 = '51857' 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 = '51963' 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 = '52085' ORDER BY main_category DESC LIMIT 1
query time:0.0004 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '52096' ORDER BY main_category DESC LIMIT 1
query time:0.0003 seconds | controller: ControllerProductCategory
SELECT category_id FROM oc_product_to_category WHERE product_id = '52097' 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 = '52102' 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 = '52175' ORDER BY main_category DESC LIMIT 1
query time:0.0003 seconds | controller: ControllerCommonColumnLeft
SELECT * FROM oc_category_to_layout WHERE category_id = '4225' 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.0002 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_category_to_layout WHERE category_id = '4225' AND store_id = '0'
query time:0.0001 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1
query time:0.0002 seconds | controller: ControllerCommonColumnRight
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0001 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_category_to_layout WHERE category_id = '4225' AND store_id = '0'
query time:0.0001 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1
query time:0.0001 seconds | controller: ControllerCommonContentTop
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0004 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_category_to_layout WHERE category_id = '4225' AND store_id = '0'
query time:0.0001 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1
query time:0.0002 seconds | controller: ControllerCommonContentBottom
SELECT * FROM oc_extension WHERE `type` = 'module'
query time:0.0003 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.0018 seconds | controller: ControllerModuleCart
SELECT * FROM oc_extension WHERE `type` = 'total'