Korda

Korda

Sortare după:

Korda Croseta Fine Mov

Korda Croseta Fine Mov

kbnf

Livrare imediată!

24,03Lei

Carlige Korda Long Shank X Nr.6

Carlige Korda Long Shank X Nr.6

klsx6

Livrare 7-14 zile

33,90Lei

Pantalon KORDA Kore, Olive, Marime 2XL

Pantalon KORDA Kore, Olive, Marime 2XL

kcl191

Livrare 7-14 zile

236,41Lei

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime XL

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime XL

kcl445

Livrare 7-14 zile

331,52Lei

Pantalon KORDA Kore Heavy, Dark Kamo, Marime S

Pantalon KORDA Kore Heavy, Dark Kamo, Marime S

kcl835

Livrare imediată!

331,21Lei

Pantaloni KORDA Kore Polar Kombats, Olive, Marime XL

Pantaloni KORDA Kore Polar Kombats, Olive, Marime XL

kcl088

Livrare 7-14 zile

458,05Lei

Korda Rubber Bead 4mm

Korda Rubber Bead 4mm

k4rbb

Livrare imediată!

19,80Lei

TRICOU KORDA LE DISTRESSED LOGO TEE OLIVE MARIME XL

kcl716

Livrare imediată!

133,26Lei

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime M

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime M

kcl984

Livrare imediată!

349,48Lei

Pantalon KORDA Kore, Olive, Marime S

Pantalon KORDA Kore, Olive, Marime S

kcl187

Livrare 7-14 zile

236,41Lei

CIORAPI KORDA KORE DIN LANA OLIVE, MARIME 7-8UK / 41-42EU

CIORAPI KORDA KORE DIN LANA OLIVE, MARIME 7-8UK / 41-42EU

kcl318

Livrare 7-14 zile

104,91Lei

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime 2XL

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime 2XL

kcl446

Livrare 7-14 zile

331,52Lei

Pantalon KORDA Kore Heavy, Dark Kamo, Marime M

Pantalon KORDA Kore Heavy, Dark Kamo, Marime M

kcl836

Livrare 7-14 zile

306,86Lei

Pantaloni KORDA Kore Polar Kombats, Olive, Marime 2XL

Pantaloni KORDA Kore Polar Kombats, Olive, Marime 2XL

kcl089

Livrare 7-14 zile

458,05Lei

KORDA PLUMB MARKER 3.0OZ

KORDA PLUMB MARKER 3.0OZ

ml3

Livrare 7-14 zile

39,08Lei

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME XL

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME XL

kcl734

Livrare 7-14 zile

152,21Lei

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime L

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime L

kcl985

Livrare imediată!

349,48Lei

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime 3XL

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime 3XL

kcl988

Livrare 7-14 zile

377,17Lei

Afişare 1621 - 1638 din 1638 (82 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 104.664 ms [By time] [By id] [By file]

1 (0.073)

SELECT data
FROM `oc_session`
WHERE session_id = '006cdca2749d53aeb78e6778cc'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.090)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.089)

SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.088)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '73' AND m2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (41.187)

SELECT COUNT(1) AS total
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '73'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (63.017)

SELECT p.product_id, (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 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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '73' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1620,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.120)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37