Your Cart

Akciós termékek

A labdarúgás a világ legnépszerűbb sportja, és ezt a címet valószínűleg jó ideig nem is fogja elvenni tőle senki. Számtalan kiegészítőre van szükség ahhoz, ha a megfelelő szinten és magabiztossággal akarjuk űzni a mindennapokban vagy hétvégente az ismerősökkel, barátokkal, esetleg amatőr ligában. Az akciós termékeink között mindenki megtalálhatja a keresett terméket, ráadásul kedvezményes áron, amivel rengeteget lehet spórolni.


Ismerd meg akciós termékeinket és rendeld meg még ma a sajátodat! Böngészd végig a lehetőségek hosszú sorát!


Legnépszerűbbek

Márka: NikeNike Cikkszám: dj2837-484
79.990 Ft
Nettó ár:79.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cv0958-090
Megtakarítás -6%
74.990 Ft 79.990 Ft
Nettó ár:74.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cz9890-808
Megtakarítás -10%
71.990 Ft 79.990 Ft
Nettó ár:71.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dj4978-001
Megtakarítás -10%
69.990 Ft 77.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dj5166-780
Megtakarítás -22%
69.990 Ft 89.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dq5294-182
Megtakarítás -18%
69.990 Ft 84.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Cikkszám: db0822-800
Megtakarítás -13%
69.990 Ft 79.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dr5954-810
Megtakarítás -10%
69.990 Ft 77.990 Ft
Nettó ár:69.990 Ft
Kosárba
Mutasd 1 tól 25 -ig 378 (16 oldalakat)
Márka: NikeNike Készletállapot: Készleten
79.990 Ft
Nettó ár:79.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -6%
74.990 Ft 79.990 Ft
Nettó ár:74.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -10%
71.990 Ft 79.990 Ft
Nettó ár:71.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -10%
69.990 Ft 77.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -22%
69.990 Ft 89.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -18%
69.990 Ft 84.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -13%
69.990 Ft 79.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -13%
69.990 Ft 79.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -10%
69.990 Ft 77.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -13%
69.990 Ft 79.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -13%
69.990 Ft 79.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: AdidasAdidas Készletállapot: Készleten
Megtakarítás -13%
69.990 Ft 79.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -9%
67.990 Ft 74.990 Ft
Nettó ár:67.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -15%
67.990 Ft 79.990 Ft
Nettó ár:67.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -13%
67.990 Ft 77.990 Ft
Nettó ár:67.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -7%
64.990 Ft 69.990 Ft
Nettó ár:64.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -19%
64.990 Ft 79.990 Ft
Nettó ár:64.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -19%
64.990 Ft 79.990 Ft
Nettó ár:64.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -25%
59.990 Ft 79.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -20%
59.990 Ft 74.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -25%
59.990 Ft 79.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: AdidasAdidas Készletállapot: Készleten
Megtakarítás -14%
59.990 Ft 69.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -28%
57.990 Ft 79.990 Ft
Nettó ár:57.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -26%
57.990 Ft 77.990 Ft
Nettó ár:57.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
Megtakarítás -26%
57.990 Ft 77.990 Ft
Nettó ár:57.990 Ft
Kosárba

Webáruházunkban minden megtalálható ahhoz, hogy a pályán nyújtott teljesítményünket a következő szintre emeljük, vagy ha az egyik kiegészítőnk elhasználódott, akkor egy újjal pótoljuk azt. Több kategória kínálatából is lehet válogatni: sípcsontvédők, kapuskesztyűk, focilabdák, utcai cipők és minőségi focicipők egyaránt elérhetőek. A futballcipők között minden egyes pályára megtalálhatjuk az ideális lábbelit. Legyen az kemény felület, nedves, sáros futballpálya vagy műfüves kispálya, esetleg terem, a legnépszerűbb márkák termékei nyújtanak megbízható megoldást.


Az Adidas és a Nike cipői közül választhatjuk ki azt, ami az elkövetkező edzéseken, éles mérkőzéseken a hűséges társunk lesz. Ez pedig csak a focicipő kategória, ezenkívül ott van még a többi kiegészítő. Ráadásul a sportolás mellett a hétköznapi viseletünkhöz is megtalálhatjuk a megfelelő ruházati cikkeket. Lehet az egy kényelmes, sportos pulóver, de ha valaki nem a labdarúgásért rajong, hanem a kosárlabdáért, akkor a legnépszerűbb és legújabb kosaras cipők is elérhetőek nálunk.


Miért érdemes a prémium kategóriában válogatni, a legnagyobb gyártók termékei között? Mert ezek sokkal hatékonyabb megoldást nyújtanak, mint az átlagos, olykor névtelen kiegészítők. Kényelmesebb a viselésük, olyan, mintha a lábunkra öntötték volna ezeket a focicipőket, utcai cipőket. Sokkal lassabban használódnak el, jobban bírják a gyűrődést és még dizájnosabbak is, mint a többi.


Akciós termékeink: költséghatékony, prémium megoldások


Ebben a kategóriában mindent megtalálhatunk, amire éppen szükségünk van. Több száz termék érhető el. Szükség van egy új focicipőre, kedvező áron? Könnyedén megoldható! Ráadásul még attól sem kell tartani, hogy éppen egy utolsó darabról van szó, ami csak egy méretben érhető el. Időszakos, szezonális akciók keretein belül várunk minden érdeklődőt, aki focicipőt, utcai cipőt, kosárcipőt, kapuskesztyűt vagy más kiegészítőt keres. A legújabb Nike Mercurial futballcipőt néztük ki magunknak? Garantáltan fogunk belőle találni párat az akciós termékek között. 


Ha már focicipők: természetes fűvel borított pályára, műfüvesre és terembe is beszerezhetjük az ideális változatot. Válogathatunk az alacsony és magas szárú cipők között is. Ezeket nemcsak a futballpályára vihetjük ki, hanem vannak kifejezetten kosaras lábbelik is az akciós termékek között. A Nike és az Adidas minőségi kínálatában böngészhetünk, így elérhetőbbé válnak mindenki számára, mint eddig valaha.


Sportos stílus pár kattintásnyira


Ilyen cipőket, kiegészítőket azonban nem feltétlenül csak sportoláshoz lehet felhúzni. Van, akinek a mindennapos viseletéhez tartozik az, hogy magas szárú cipőben, melegítőben megy ki az utcára. Nekik is erősen ajánlott végignézni az akciós termékek felhozatalát, biztosan fognak találni olyan utcai lábbelit, ruházati cikket, ami még nem található meg a ruhatárukban. Szerezd be még ma álmaid cipőjét most akciósan!

Queries: 399, Total time: 107.041 ms [By time] [By id] [By file]
1 (0.074)
SET time_zone = '+00:00'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/framework.php:84
2 (0.521)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = 'fecd89ca65f63003eab0cf730e' AND `expire` > '2024-05-01 16:58:47'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/session/db.php:16
3 (0.105)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://focicipobolt.hu/'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/startup.php:6
4 (0.524)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/startup.php:25
5 (0.124)
SET time_zone = '+02:00'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/startup.php:40
6 (0.151)
SELECT *
FROM oc_currency
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/currency.php:10
7 (0.092)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4259')
ORDER BY tr1.priority ASC
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/tax.php:16
8 (0.049)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4259')
ORDER BY tr1.priority ASC
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/tax.php:44
9 (0.059)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/weight.php:10
10 (0.054)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/length.php:10
11 (0.670)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:15
12 (0.085)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'akcios-termekeink' AND status = 1 AND store_id = 0 LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/controller/extension/module/redirect_manager_pro.php:46
13 (0.143)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/event.php:4
14 (0.093)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/setting.php:6
15 (0.057)
SELECT *
FROM oc_seo_url
WHERE keyword = 'akcios-termekeink' AND store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:34
16 (0.561)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
17 (0.124)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/design/translation.php:18
18 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
19 (0.103)
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 = '115' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/catalog/category.php:4
20 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
21 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
22 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
23 (0.034)
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 = '115' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/catalog/category.php:10
24 (1.419)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5326' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
25 (0.981)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5928' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
26 (0.715)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5571' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
27 (0.748)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6353' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
28 (0.664)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5846' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
29 (0.665)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6058' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
30 (0.630)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5847' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
31 (0.714)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6048' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
32 (0.658)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6055' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
33 (0.715)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5747' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
34 (0.584)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5386' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
35 (0.765)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5765' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
36 (0.610)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6040' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
37 (0.599)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5570' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
38 (0.658)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6083' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
39 (0.780)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5785' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
40 (0.668)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6060' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
41 (0.680)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5404' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
42 (0.642)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6153' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
43 (0.637)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5327' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
44 (0.635)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5238' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
45 (0.645)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '5762' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
46 (0.637)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6495' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
47 (0.748)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6821' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
48 (0.796)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '6452' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/catalog/product.php:11
49 (0.062)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5326'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
50 (0.023)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
51 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
52 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
53 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5326' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
54 (0.044)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5928'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
55 (0.047)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
56 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
57 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
58 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5928' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
59 (0.043)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5571'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
60 (0.024)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
61 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
62 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
63 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5571' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
64 (0.039)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6353'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
65 (0.018)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
66 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
67 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
68 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6353' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
69 (0.038)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5846'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
70 (0.020)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
71 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
72 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
73 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5846' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
74 (0.044)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6058'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
75 (0.021)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
76 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
77 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
78 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6058' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
79 (0.061)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5847'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
80 (0.020)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
81 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
82 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
83 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5847' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
84 (0.051)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6048'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
85 (0.023)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
86 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
87 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
88 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6048' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
89 (0.039)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6055'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
90 (0.016)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
91 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
92 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
93 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6055' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
94 (0.058)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5747'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
95 (0.017)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
96 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
97 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
98 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5747' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
99 (0.057)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5386'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
100 (0.021)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
101 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
102 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
103 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5386' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
104 (0.065)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5765'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
105 (0.029)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
106 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
107 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
108 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5765' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
109 (0.065)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6040'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
110 (0.042)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
111 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
112 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
113 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6040' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
114 (0.068)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5570'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
115 (0.034)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
116 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
117 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
118 (0.035)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5570' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
119 (0.074)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6083'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
120 (0.030)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
121 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
122 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
123 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6083' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
124 (0.070)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5785'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
125 (0.036)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
126 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
127 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
128 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5785' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
129 (0.055)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6060'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
130 (0.029)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
131 (0.036)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
132 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
133 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6060' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
134 (0.065)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5404'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
135 (0.043)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
136 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
137 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
138 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5404' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
139 (0.054)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6153'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
140 (0.018)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
141 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
142 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
143 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6153' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
144 (0.063)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5327'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
145 (0.036)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
146 (0.036)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
147 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
148 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5327' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
149 (0.069)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5238'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
150 (0.048)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
151 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
152 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
153 (0.033)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5238' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
154 (0.068)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5762'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
155 (0.029)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
156 (0.036)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
157 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
158 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5762' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
159 (0.040)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6495'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
160 (0.020)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
161 (0.036)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
162 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
163 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6495' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
164 (0.054)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6821'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
165 (0.029)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
166 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
167 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
168 (0.035)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6821' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
169 (0.065)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6452'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
170 (0.029)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
171 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
172 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
173 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6452' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
174 (0.035)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
175 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
176 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
177 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
178 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
179 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
180 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
181 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
182 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
183 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
184 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
185 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
186 (0.057)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
187 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
188 (0.036)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
189 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
190 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
191 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
192 (0.034)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
193 (0.087)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '115' AND store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/catalog/category.php:55
194 (0.083)
SELECT *
FROM oc_module
WHERE module_id = '41'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/module.php:4
195 (0.094)
SELECT *
FROM oc_seo_url
WHERE `query` = 'extension/module/ocme_mfp_filter' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
196 (0.124)
SELECT *
FROM oc_theme
WHERE store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/model/design/theme.php:12
197 (0.150)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
198 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
199 (14.292)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) special, p.viewed as `p.viewed`, if (p.quantity, 1, 0) in_stock
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND p2c.category_id IN (115) GROUP BY p.product_id
ORDER BY in_stock desc, (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) DESC, LCASE(pd.name) DESC LIMIT 0, 8
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/filter.php:892
200 (2.650)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 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 IN (5326,5928,5571,6353,5846,6058,5847,6055) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/product.php:29
201 (0.468)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) AND product_id IN (5326,5928,5571,6353,5846,6058,5847,6055) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/product.php:97
202 (0.693)
SELECT pi.product_id, pi.image
FROM oc_product_image pi
INNER JOIN ( SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (5326,5928,5571,6353,5846,6058,5847,6055) GROUP BY product_id ) pi2
WHERE pi.product_id = pi2.product_id AND pi.sort_order = pi2.sort_order GROUP BY product_id
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/product.php:117
203 (0.212)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5326
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
204 (0.040)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5326'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
205 (0.036)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
206 (0.027)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5326
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
207 (0.020)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5326'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
208 (0.021)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
209 (5.242)
SELECT *
FROM oc_seo_url
WHERE store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/url.php:102
210 (0.192)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
211 (0.478)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5928
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
212 (0.292)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5928'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
213 (0.103)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
214 (0.080)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5928
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
215 (0.075)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5928'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
216 (0.024)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
217 (0.033)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
218 (0.283)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5571
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
219 (0.055)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5571'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
220 (0.047)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
221 (0.046)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5571
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
222 (0.025)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5571'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
223 (0.027)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
224 (0.047)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
225 (0.321)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6353
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
226 (0.068)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6353'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
227 (0.049)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
228 (0.043)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6353
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
229 (0.024)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6353'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
230 (0.023)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
231 (0.033)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
232 (0.220)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5846
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
233 (0.234)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5846'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
234 (0.082)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
235 (0.045)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5846
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
236 (0.031)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5846'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
237 (0.029)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
238 (0.045)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
239 (0.281)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6058
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
240 (0.061)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6058'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
241 (0.052)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
242 (0.108)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6058
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
243 (0.031)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6058'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
244 (0.028)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
245 (0.061)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
246 (0.693)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5847
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
247 (0.147)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5847'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
248 (0.058)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
249 (0.031)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5847
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
250 (0.021)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5847'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
251 (0.019)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
252 (0.034)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
253 (0.285)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6055
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
254 (0.054)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6055'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
255 (0.039)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
256 (0.037)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6055
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
257 (0.027)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6055'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
258 (0.023)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
259 (0.115)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
260 (0.434)
SELECT p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.product_id IN (0) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.quantity > 0
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/product.php:424
261 (0.135)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5925
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
262 (0.051)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5925'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
263 (0.035)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
264 (0.087)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5925
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
265 (0.027)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5925'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
266 (0.022)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
267 (0.050)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 3309
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
268 (0.037)
SELECT *
FROM oc_product_to_category
WHERE product_id = '3309'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
269 (0.094)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
270 (0.044)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 3309
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
271 (0.027)
SELECT *
FROM oc_product_to_category
WHERE product_id = '3309'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
272 (0.025)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
273 (0.049)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6318
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
274 (0.031)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6318'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
275 (0.027)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
276 (0.039)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6318
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
277 (0.022)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6318'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
278 (0.021)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
279 (0.089)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4168
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
280 (0.030)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4168'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
281 (0.023)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '107'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
282 (0.022)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
283 (0.023)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4168
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
284 (0.026)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4168'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
285 (0.021)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '107'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
286 (0.020)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
287 (0.047)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6330
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
288 (0.069)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6330'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
289 (0.035)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
290 (0.045)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6330
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
291 (0.022)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6330'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
292 (0.020)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
293 (0.053)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5250
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
294 (0.031)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5250'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
295 (0.027)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
296 (0.027)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5250
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
297 (0.021)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5250'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
298 (0.021)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
299 (0.033)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2563
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
300 (0.027)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2563'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
301 (0.027)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '109'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
302 (0.022)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
303 (0.026)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2563
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
304 (0.023)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2563'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
305 (0.025)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '109'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
306 (0.025)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
307 (0.103)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2887
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
308 (0.078)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2887'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
309 (0.033)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
310 (0.029)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2887
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:163
311 (0.021)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2887'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
312 (0.024)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
313 (0.211)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/setting.php:6
314 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
315 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
316 (0.033)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
317 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
318 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
319 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
320 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
321 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
322 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
323 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
324 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
325 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
326 (38.640)
SELECT *
FROM `oc_journal3_module`
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/module.php:9
327 (0.131)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/setting.php:6
328 (0.114)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/extension.php:4
329 (0.042)
SELECT *
FROM oc_country
WHERE country_id = '97'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:1056
330 (0.093)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
331 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
332 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
333 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
334 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
335 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
336 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
337 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
338 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
339 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
340 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
341 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
342 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
343 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
344 (0.055)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
345 (0.052)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
346 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
347 (0.057)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
348 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
349 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
350 (0.049)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
351 (0.063)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
352 (0.028)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/extension.php:4
353 (0.041)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
354 (0.058)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
355 (0.050)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/customer.php:122
356 (0.052)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
357 (0.033)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
358 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
359 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
360 (0.038)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
361 (0.044)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/extension.php:4
362 (0.045)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
363 (0.038)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
364 (0.047)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/customer.php:122
365 (0.045)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'fecd89ca65f63003eab0cf730e'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
366 (0.131)
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 = '115' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/catalog/category.php:4
367 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
368 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
369 (0.098)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/setting.php:6
370 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
371 (2.771)
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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 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 IN (5326,5928,5571,6353,5846,6058,5847,6048,6055,5747,5386,5765,6040,5570,6083,5785,6060,5404,6153,5327,5238,5762,6495,6821,6452) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/product.php:29
372 (0.530)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) AND product_id IN (5326,5928,5571,6353,5846,6058,5847,6048,6055,5747,5386,5765,6040,5570,6083,5785,6060,5404,6153,5327,5238,5762,6495,6821,6452) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/product.php:97
373 (1.194)
SELECT pi.product_id, pi.image
FROM oc_product_image pi
INNER JOIN ( SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (5326,5928,5571,6353,5846,6058,5847,6048,6055,5747,5386,5765,6040,5570,6083,5785,6060,5404,6153,5327,5238,5762,6495,6821,6452) GROUP BY product_id ) pi2
WHERE pi.product_id = pi2.product_id AND pi.sort_order = pi2.sort_order GROUP BY product_id
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/journal3/product.php:117
374 (0.108)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
375 (0.071)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
376 (0.067)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
377 (0.125)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
378 (0.085)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
379 (0.085)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
380 (0.062)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
381 (0.154)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
382 (0.068)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
383 (0.104)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
384 (0.100)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
385 (0.107)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 14
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
386 (0.202)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
387 (0.097)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
388 (0.088)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
389 (0.084)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
390 (0.083)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
391 (0.103)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
392 (0.113)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
393 (0.119)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
394 (0.197)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
395 (0.183)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 14
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
396 (0.149)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
397 (0.140)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
398 (0.125)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/journal3/productextras.php:240
399 (0.165)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/catalog/model/setting/setting.php:6