Your Cart
Nike Phantom GX

Nike Phantom GX

A Nike Phantom GX az egyik legújabb sorozatnak számít a piacon. Folyamatosan frissülő paletta jellemzi, amelynek segítségével csúcsteljesítményre leszünk képesek a pályán mind edzésen, mind éles mérkőzésen. A focicipő stabil tartást ad a lábunknak, ami nem fog a sebesség kárára menni. Függetlenül attól, hogy milyen pályatípusra keresünk cipőt, a Nike Phantom GX felhozatalában garantáltan meg fogjuk találni az ideálisat.


Ismerd meg a Nike Phantom GX kínálatunkat, és rendeld meg még ma a megfelelő focicipőt! Böngészd végig a felhozatalt most!

Legnépszerűbbek

Márka: NikeNike Cikkszám: dd9466-600
36.990 Ft
Nettó ár:36.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9463-446
47.990 Ft
Nettó ár:47.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9463-300
43.990 Ft
Nettó ár:43.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9463-010
43.990 Ft
Nettó ár:43.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9463-010
Megtakarítás -43%
24.990 Ft 43.990 Ft
Nettó ár:24.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9463-705
47.990 Ft
Nettó ár:47.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9465-300
49.990 Ft
Nettó ár:49.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9463-600
44.990 Ft
Nettó ár:44.990 Ft
Kosárba
Mutasd 1 tól 12 -ig 47 (4 oldalakat)
Márka: NikeNike Cikkszám: fd5227-071
79.990 Ft
Nettó ár:79.990 Ft
Kosárba
Márka: NikeNike Cikkszám: fd5230-071
79.990 Ft
Nettó ár:79.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9444-446
79.990 Ft
Nettó ár:79.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dc9969-705
77.990 Ft
Nettó ár:77.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9441-010
71.990 Ft
Nettó ár:71.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dv6970-071
69.990 Ft
Nettó ár:69.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dv6973-071
Megtakarítás -25%
59.990 Ft 79.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dv6972-071
Megtakarítás -14%
59.990 Ft 69.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9444-446
Megtakarítás -31%
54.990 Ft 79.990 Ft
Nettó ár:54.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9465-300
49.990 Ft
Nettó ár:49.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dv6972-071
Megtakarítás -29%
49.990 Ft 69.990 Ft
Nettó ár:49.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dd9463-705
47.990 Ft
Nettó ár:47.990 Ft
Kosárba

Csúcstechnológia segít a legjobb teljesítmény elérésében


A labdarúgás azért is tud a legnépszerűbb sport lenni a világon, mert nagyon kevés eszközre van szükség az elkezdéséhez. Azonban ahhoz, hogy a teljesítményünket a következő szintre emeljük, több eszközre és kiegészítőre is szükség van. Ilyen például a sípcsontvédő, a focilabda, a sportruházat, hálóőröknek a kapuskesztyű, valamint minden játékosnak kell egy minőségi focicipő.


Az sem mindegy, hogy milyen terméket választunk. A megfelelő teljesítményhez nem elég egy átlagos focicipő. Érdemes a legnagyobb gyártók felhozatalából böngészni, mivel azokat a legmagasabb szinteken is naponta használják. Premier League, Serie A, La Liga és Bajnokok Ligája: mindenhol megtalálhatóak a Nike és az Adidas termékei. Ha megtetszik egy, szinte azonnal leadhatjuk a rendelést és a következő edzésre, mérkőzésre már abban futhatunk ki a pályára.


A gyártók folyamatosan fejlesztik a focicipők kínálatát, ezért is ajánlott gyakran megnézni az elérhető újdonságokat. A Nike Phantom GX széria termékei igazi csúcstechnológiát képviselnek. A cipő minden egyes részét a hatékonyságnak szentelték. Egy minőségi focicipő segítségével sokkal stabilabban, magabiztosabban fogunk mozogni a pályán. Azonnal érezni fogjuk a különbséget, ha eddig “csak” egy átlagos lábbelit használtunk.


A Nike Phantom GX: az egyik legmozgékonyabb focicipő


Mitől is lesz egy futballcipő mozgékony? Attól, hogy a viselésével sokkal könnyebben tudunk majd kitérni és futni. A segítségével könnyen felébreszthetjük a bennünk rejlő játék- és versenyszellemet, amivel maximális teljesítményt nyújtunk majd a pályán. Az egyik első jellegzetesség, amit a Nike Phantom GX cipőkön észrevehetünk, hogy itt bizony nem kell a cipőfűzővel bajlódni.


A húzófülek és az állítható nyelv segítségével pillanatok alatt belebújhatunk a lábbelibe. A rugalmas fűzők szabályozható rögzítést tesznek lehetővé. Természetes fűvel borított pályán műfüves területen is maximális tapadást nyújt a generatív külső talp. Speciális hálóval egészítették ki a kiterjesztett NikeSkin érintőfelületet, aminek köszönhetően minden eddiginél közelebb érezhetjük a labdát a lábunkhoz. Ezáltal jobb lesz a labdakezelés passzolás és cselezés közben egyaránt.


Száraz és nedves körülmények között is nyugodtan használhatjuk. Laza talajra, felázott gyepre az egyik legjobb választás a Nike Gripknit Phantom GX Elite SG-Pro Anti-Clog Traction, amivel kiemelkedő tapadást érhetünk el. Kemény felületre a Nike Phantom GX Elite DF FG az ajánlott, de műfű-természetes fű átmenet is elérhető a Nike Phantom GX Academy DF FG/MG személyében. 


Modern, letisztult megjelenés


Nem kell extrém mintázatokra számítani, de mindenképpen különlegesnek számítanak. Elég megnézni a Nike Phantom GX Elite Fusion DF SG-Pro AC megjelenését. Mindenki megtalálhatja a stílusához illeszkedő minőségi focicipőt, amiben új szintre emelheti teljesítményét a pályán. Szerezd be még ma a legújabb Nike Phantom GX cipők egyikét!

Queries: 207, Total time: 62.793 ms [By time] [By id] [By file]
1 (0.054)
SET time_zone = '+00:00'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/system/framework.php:84
2 (0.401)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '4c45a8a8483ac0a422cc113bfd' AND `expire` > '2024-05-28 08:03:23'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/system/library/session/db.php:16
3 (0.078)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://kiralysportbolt.hu/'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/startup.php:6
4 (0.500)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/startup.php:25
5 (0.143)
SET time_zone = '+02:00'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/startup.php:40
6 (0.152)
SELECT *
FROM oc_currency
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/system/library/cart/currency.php:10
7 (0.064)
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/kbpfcxwhkh/public_html/system/library/cart/tax.php:16
8 (0.039)
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/kbpfcxwhkh/public_html/system/library/cart/tax.php:44
9 (0.051)
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/kbpfcxwhkh/public_html/system/library/cart/weight.php:10
10 (0.049)
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/kbpfcxwhkh/public_html/system/library/cart/length.php:10
11 (0.372)
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/kbpfcxwhkh/public_html/storage/modification/system/library/cart/cart.php:15
12 (2.545)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'nike-phantom-gx' AND status = 1 AND store_id = 0 LIMIT 1
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/catalog/controller/extension/module/redirect_manager_pro.php:46
13 (0.177)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/catalog/model/setting/event.php:4
14 (0.107)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/catalog/model/setting/setting.php:6
15 (0.037)
SELECT *
FROM oc_seo_url
WHERE keyword = 'nike-phantom-gx' AND store_id = '0'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:34
16 (0.399)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4c45a8a8483ac0a422cc113bfd'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/system/library/cart/cart.php:45
17 (0.139)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/model/design/translation.php:18
18 (0.069)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
19 (0.081)
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/kbpfcxwhkh/public_html/catalog/model/catalog/category.php:4
20 (0.033)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
21 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
22 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
23 (0.108)
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/kbpfcxwhkh/public_html/catalog/model/catalog/category.php:10
24 (0.869)
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 = '6612' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/model/catalog/product.php:11
25 (0.724)
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 = '6532' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/model/catalog/product.php:11
26 (0.556)
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 = '6319' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/model/catalog/product.php:11
27 (0.628)
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 = '6530' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/model/catalog/product.php:11
28 (0.540)
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 = '6819' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/model/catalog/product.php:11
29 (0.581)
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)