Your Cart
Utcai cipő

Utcai cipő

Ha utcai cipőről van szó, akkor számtalan kialakítással találkozhatunk. Ennek az az oka, hogy többféle felhasználási módja van: lehet csak egyszerűen munkába járáshoz, sétálásra is, de futáshoz és kosarazáshoz, röplabdához is ilyen lábbeliket szokás felhúzni. A sportos múlt egyértelműen látszik a megjelenésen és kialakításon is, hiszen mindegyiknek teljesen más igényeknek kell megfelelnie. Nagy előnyük az, hogy például egy kosárcipőt nyugodtan fel lehet venni sétához is, hisz elég univerzális a felépítésük.


Ismerd meg felhozatalunkat, és rendeld meg még ma álmaid utcai cipőjét! Fedezd fel termékeinket!


Legnépszerűbbek

Márka: NikeNike Cikkszám: cw3419-005
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cj0291-003
27.990 Ft
Nettó ár:27.990 Ft
Kosárba
Márka: NikeNike Cikkszám: aa7406-400
Megtakarítás -14%
23.990 Ft 27.990 Ft
Nettó ár:23.990 Ft
Kosárba
Márka: NikeNike Cikkszám: aj4114-400
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Cikkszám: do9354-001
Megtakarítás -16%
41.990 Ft 49.990 Ft
Nettó ár:41.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dj6149-003
Megtakarítás -29%
24.990 Ft 34.990 Ft
Nettó ár:24.990 Ft
Kosárba
Márka: NikeNike Cikkszám: ck5424-003
31.990 Ft
Nettó ár:31.990 Ft
Kosárba
Márka: NikeNike Cikkszám: bv3245-001
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Mutasd 1 tól 12 -ig 390 (33 oldalakat)
Márka: NikeNike Cikkszám: dx8965-100
59.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dv0815-100
59.990 Ft
Nettó ár:59.990 Ft
Kosárba
Márka: NikeNike Cikkszám: fj4416-100
57.990 Ft
Nettó ár:57.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dx2669-300
57.990 Ft
Nettó ár:57.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dx2662-100
57.990 Ft
Nettó ár:57.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dh4084-100
54.990 Ft
Nettó ár:54.990 Ft
Kosárba
Márka: NikeNike Cikkszám: fn3412-600
51.990 Ft
Nettó ár:51.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dq8963-100
Megtakarítás -9%
49.990 Ft 54.990 Ft
Nettó ár:49.990 Ft
Kosárba
Márka: NikeNike Cikkszám: ci2298-100
49.990 Ft
Nettó ár:49.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dh0833-071
49.990 Ft
Nettó ár:49.990 Ft
Kosárba
Márka: NikeNike Cikkszám: dm1206-107
Megtakarítás -17%
49.990 Ft 59.990 Ft
Nettó ár:49.990 Ft
Kosárba
Márka: NikeNike Cikkszám: cj0303-400
47.990 Ft
Nettó ár:47.990 Ft
Kosárba

Mindenki megtalálhatja a számára megfelelő lábbelit


Az utca cipők egyik megjelenése kifejezetten dizájnosnak és stílusosnak mondható. Ezért is lehet jó választás egy ilyen lábbeli egy szimpla sétához is, vagy akár a mindennapokban. Ez is jól mutatja, hogy ahány utcai cipő, annyiféle felhasználási móddal találkozhatunk. Séta, munkába járás, kosárlabda, röplabda és futás mind szóba jöhet egy jól választott lábbelivel. Ez persze azt is jelenti, hogy igazán speciális változatokkal is találkozhatunk, amelyeket kifejezetten az adott mozgástípusra terveztek.


Kínálatunk kialakítása során nemcsak a mennyiségre törekedtünk, hanem a minőségre is. Ez igaz minden egyes kategóriánkra, így a gyerekeknek való cipőkre, valamint más felnőtt (női, férfi) kínálatra is. A legnagyobb márkák termékeivel találkozhatunk: Nike, Adidas, minden egyes mozgásformára találhatunk egy kifejezetten profi változatot. A minőség garantált, hiszen ezek az utcai cipők hosszú éveken keresztül lesznek hű társaink a mozgásban.


Utcai cipő: melyik az ideális?


Az első lépés az, hogy eldöntsük, hogyan fogjuk használni az adott utcai cipőt. Ha például egy igazán könnyed, de rugalmas lábbelit keresünk, akkor például jó választás lehet a Nike Air VaporMax Evo vagy a Nike Air More Uptempo is. A dizájnos, hétköznapi utcai cipőket képviseli a Nike Air Max 720, Nike Air Force 1 LV8 és a Nike Dunk Low Golden Moss. Ha ezek közül valamelyiket használjuk, akkor biztosan kényelmes lesz a mindennapos mozgás, és még a megfelelő megjelenés miatt sem kell aggódnunk.


Ott vannak a speciális utcai cipők is, amelyek közül kiemelkednek a kosárcipők. Ezeket kifejezetten úgy tervezték meg, hogy minden olyan igénybevételnek, terhelésnek ellenálljon, ami a kosárlabdázás során a lábunkat érheti. Az egyik leginkább terhelt testrész a kosarazás során a boka, ezért is ajánlott olyan cipőt választani, ami stabilan tartja a lábfejünket. Ilyen például a Nike Zion 2 vagy a Nike LeBron, esetleg a Nike Jordan sorozatok. 


Az utcai cipőknek több feladata is van: stabil tartást adni, növelni a teljesítményt, kényelmes viseletet és megfelelő megjelenést nyújtani. Ha valami igazán extrém dizájnra vágyunk, arra nagyon jó példa a Nike Air Jordan 36 Luka. A könnyedebb lépők kategóriáját képviseli az Adidas Ultraboost sorozat, amiben több tucat modellel is találkozhatunk. Hölgyeknek ajánljuk az Adidas Ultraboost 2.0 termékeit, de férfiak is megtalálhatják a számukra megfelelőt.


Keressük a minőséget


Nem hiába az Adidas és a Nike számít az utcai cipők legnépszerűbb márkáinak. Igazi minőséget képviselnek, ami azért is előnyös, mert nem kell attól tartani, hogy rövid időn belül elhasználódik a lábbeli. Nagy terhelést is kibírnak úgy, hogy még a teljesítményt is képesek javítani. Emellett a kényelemről sem szabad megfeledkezni, valamint a tökéletes megjelenésről. Ismerd meg utcai cipőinket, és válaszd ki a tökéletes lábbelit, ami hű társad lesz a mindennapokban és sportolás során!

Queries: 204, Total time: 122.874 ms [By time] [By id] [By file]
1 (0.037)
SET time_zone = '+00:00'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/system/framework.php:84
2 (3.220)
DELETE
FROM `oc_session`
WHERE `expire` < '2024-04-19 06:09:12'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/system/library/session/db.php:53
3 (0.342)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '45298a6aa1218de0a86f9014b8' AND `expire` > '2024-04-19 06:09:12'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/system/library/session/db.php:16
4 (0.138)
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
5 (0.283)
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
6 (0.096)
SET time_zone = '+02:00'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/startup.php:40
7 (0.091)
SELECT *
FROM oc_currency
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/system/library/cart/currency.php:10
8 (0.105)
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
9 (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/kbpfcxwhkh/public_html/system/library/cart/tax.php:44
10 (0.033)
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
11 (0.029)
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
12 (0.370)
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
13 (2.593)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'utcai-cipo' 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
14 (0.102)
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
15 (0.045)
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
16 (0.023)
SELECT *
FROM oc_seo_url
WHERE keyword = 'utcai-cipo' AND store_id = '0'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:34
17 (0.384)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '45298a6aa1218de0a86f9014b8'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/system/library/cart/cart.php:45
18 (0.121)
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
19 (0.049)
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
20 (0.061)
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 = '87' 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
21 (0.024)
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
22 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=87' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
23 (0.019)
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
24 (0.068)
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 = '87' 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
25 (0.042)
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
26 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=87' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
27 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=95' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
28 (0.015)
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
29 (0.014)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=87' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
30 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=96' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
31 (0.014)
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
32 (0.014)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=87' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
33 (0.014)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=97' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kbpfcxwhkh/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
34 (1.254)
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 = '6673' 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
35 (1.077)
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 = '6573' 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
36 (0.977)
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 = '6765' 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
37 (0.867)
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 = '5917' 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/c