Your Cart
Focilabda

Focilabda

A világ egyértelműen legnépszerűbb sportja a labdarúgás. Ahhoz, hogy el tudjuk kezdeni, elég hozzá csak egy focilabda, plusz pár kiegészítő, de azok sokszor elhanyagolhatóak. A labda viszont központi elemet játszik a grundon, az amatőr mérkőzéseken, a teremben és a legnagyobb bajnokságokon és döntőkön is. Többféle méret, kialakítás, mintázat és megjelenés – mindenki megtalálhatja a számára megfelelő modellt, de egyáltalán nem mindegy, hogy milyet fogunk választani.


Nézd végig focilabda kínálatunkat, és válaszd ki az ideális bőrt, amit aztán rúgni lehet! Ismerd meg felhozatalunkat most!

Legnépszerűbbek

Márka: NikeNike Cikkszám: da2616-100
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cq7147-101
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cq7147-710
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cq7328-100
31.990 Ft
Nettó ár:31.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dc2362-100
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cq7354-100
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cq7148-100
16.990 Ft
Nettó ár:16.990 Ft
Kosárba
Márka: AdidasAdidas Cikkszám: h57820
14.990 Ft
Nettó ár:14.990 Ft
Kosárba
Mutasd 1 tól 8 -ig 8 (1 oldalakat)
Márka: NikeNike Készletállapot: Készleten
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
31.990 Ft
Nettó ár:31.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
16.990 Ft
Nettó ár:16.990 Ft
Kosárba
Márka: AdidasAdidas Készletállapot: Készleten
14.990 Ft
Nettó ár:14.990 Ft
Kosárba

A legnagyobb bajnokságok labdái közül lehet válogatni


Kínálatunkban rengeteg eszköz és kiegészítő található, ami a minőségi labdarúgáshoz szükséges lehet. Ezek a legnagyobb márkák termékei, amelyeket nap mint nap használnak a legmagasabb szinteken, profi körülmények között. Ez nemcsak a focilabdákra igaz, de a minőségi focicipőkre, ruházatra, kapuskesztyűre és más kiegészítőkre is. Függetlenül attól, hogy milyen pályán (terem, természetes vagy műfű) játszunk, garantáltan megtalálhatjuk az ideális termékeket, amelyekkel növelhetjük a teljesítményünket, biztonságosabban tudunk kifutni a pályára, és kényelmesebb lesz a mozgás is.


A focilabda a legfontosabb része a labdarúgásnak. Ha áthalad a gólvonalon, akkor meg is van a hőn áhított gól. Ez az a kiegészítő, ami nélkül nem is lehetne futballozni. Kapuskesztyű, mez, speciális focicipő nélkül is elkezdhetjük a játékot (bár nem érdemes), de focilabda nélkül biztosan nem.


Focilabda különböző kialakításban


Kínálatunkban megtalálható az összes típusú labda, amit napjainkban használnak. Ott van például a Nike Premier League Flight focilabda, amit az angol ligában használnak. Ezenkívül még speciális események labdái is beszerezhetőek, mint amilyen az UEFA Women’s EURO 2022 Nike Flight, amit a női Európa-bajnokságon használtak. Nem csak felnőtteknek készült darabokkal lehet találkozni kínálatunkban. Ha valaki még éppen tanulja a labdarúgást, neki a Nike Academy változatot ajánljuk.


Fontos kiemelni, hogy egyáltalán nem mindegy, hogy milyen labdát vásárolunk. Több tényezőre is oda kell figyelni, mivel nincs két egyforma labda a piacon. Itt nemcsak a megjelenésre gondolunk, de azok között is találhatunk igazán figyelemre méltó modelleket. Az egyik elsődleges szempont a méret. A legtöbb focilabda standard méretű, de vannak kisebbek is, amiket leginkább a gyerekeknek ajánlott beszerezni. Az anyag sem mindegy, mivel van műbőr, bőr és gumi anyagú labda is. A bőr sokkal pontosabb, jobb használni, de kevésbé bírja a szélsőséges, rossz időjárási körülményeket. A műbőr és a gumilabdák élettartama sokkal hosszabb és kevesebb törődést, ápolást igényelnek.


A súlyra is oda kell figyelni: a könnyebb labdákkal pontosabban lehet rúgni, viszont nem repülnek nagy sebességgel. Ezzel szemben a nehezebb focilabdák gyorsabbak, de nagyobb erő kell a mozgatásukhoz. 


Nemzetközileg elismert labdákat is vásárolhatunk


Kínálatunkban olyan focilabda is található, ami az UEFA és a FIFA által jóváhagyott, így akár profi körülmények között is lehet őket használni. Fontos, hogy a minőségre odafigyeljünk a labda kiválasztásánál. Garantáltan nem érhet minket csalódás, ha a Nike AGL Flight vagy az Adidas UCL League labdát választjuk, mivel ezeket a legmagasabb szinteken tesztelték, éles körülmények között. Ma már többféle focilabda érhető el, így a vásárlás gyakran nem egyszerű. Böngészd végig kínálatunkat, és vásárold meg most a tökéletes focilabdát!

Queries: 279, Total time: 95.152 ms [By time] [By id] [By file]
1 (0.035)
SET time_zone = '+00:00'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/framework.php:84
2 (0.427)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '81b3b4fbab7209529351f0affe' AND `expire` > '2024-03-02 10:08:07'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/session/db.php:16
3 (0.046)
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.268)
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.070)
SET time_zone = '+01:00'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/startup.php:40
6 (0.132)
SELECT *
FROM oc_currency
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/cart/currency.php:10
7 (0.074)
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.021)
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.034)
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.041)
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.444)
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.361)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'labda' 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.091)
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.077)
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.422)
SELECT *
FROM oc_seo_url
WHERE keyword = 'labda' AND store_id = '0'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:34
16 (0.433)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '81b3b4fbab7209529351f0affe'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/system/library/cart/cart.php:45
17 (0.146)
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.084)
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.079)
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 = '103' 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.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
21 (0.382)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=103' 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.033)
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.055)
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 = '103' 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.520)
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 = '6216' 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 (1.202)
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 = '5473' 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 (1.145)
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 = '6210' 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 (1.046)
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 = '6209' 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 (1.057)
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 = '5203' 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 (1.090)
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 = '5288' 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 (1.010)
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 = '6214' 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 (1.073)
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 = '5524' 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.378)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6216'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
33 (0.075)
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 = '103'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
34 (0.058)
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
35 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
36 (0.424)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6216' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
37 (0.330)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5473'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
38 (0.079)
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 = '103'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
39 (0.067)
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
40 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
41 (0.381)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5473' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
42 (0.333)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6210'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
43 (0.073)
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 = '103'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
44 (0.055)
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
45 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
46 (0.381)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6210' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
47 (0.322)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6209'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
48 (0.151)
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 = '103'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
49 (0.072)
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
50 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
51 (0.349)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=6209' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
52 (0.377)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5203'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
53 (0.069)
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 = '103'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
54 (0.066)
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
55 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
56 (0.443)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=5203' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
57 (0.134)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5288'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:129
58 (0.177)
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 = '103'
/home/949090.cloudwaysapps.com/ddnzkvwxen/public_html/system/library/tagmanager.php:157
59 (0.086)
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<