Korum

Korum

Sortare după:

Insetrii KORUM Speed Fit Inserts, 2buc/pac

Insetrii KORUM Speed Fit Inserts, 2buc/pac

K0360037

Livrare 7-14 zile

21,55Lei(-40%) 12,93Lei

BAIT BANDER KORUM MEGA BANDER

BAIT BANDER KORUM MEGA BANDER

k0310148

Livrare 7-14 zile

23,84Lei

Bac Nada + Sita Korum EVA Riddle Set, 3mm

Bac Nada + Sita Korum EVA Riddle Set, 3mm

k0290091

Livrare 7-14 zile

138,23Lei

Husa KORUM Progress Quiver, 23x23x150cm

Husa KORUM Progress Quiver, 23x23x150cm

k0290109

Livrare 7-14 zile

299,95Lei(-28%) 214,50Lei

Pluta KORUM Classic Missile, 6g, 1buc/pac

Pluta KORUM Classic Missile, 6g, 1buc/pac

K0310329

Livrare 7-14 zile

11,43Lei

JACHETA IMPERMEABILA KORUM SQUAD WATERPROOF XXL

JACHETA IMPERMEABILA KORUM SQUAD WATERPROOF XXL

z0750011

Livrare imediată!

172,41Lei

Bluza KORUM Embossed Microfleece, Olive Green-Black, Marime XXL

Bluza KORUM Embossed Microfleece, Olive Green-Black, Marime XXL

k0350151

Livrare 7-14 zile

161,96Lei(-37%) 102,58Lei

Costum KORUM Neoteric 5X5 Waterproof Suit, Marime XL

Costum KORUM Neoteric 5X5 Waterproof Suit, Marime XL

k0350134

Livrare 7-14 zile

550,02Lei

KIT CARUCIOR KORUM PENTRU SCAUN ACCESORY CHAIR BARROW KIT

KIT CARUCIOR KORUM PENTRU SCAUN ACCESORY CHAIR BARROW KIT

k0300007

Livrare 7-14 zile

504,28Lei

Cutie Accesorii Korum Bits Blox 4 Slot, 7.4x11x3.6cm

Cutie Accesorii Korum Bits Blox 4 Slot, 7.4x11x3.6cm

k0290082

Livrare imediată!

14,69Lei

Set Avertizori Korum KSi6 Rod Remote Alarm Set, 3+1

Set Avertizori Korum KSi6 Rod Remote Alarm Set, 3+1

k0360079

Livrare 7-14 zile

389,89Lei

Carlige Legate KORUM Quickstop Hook Hairs Barbless, Nr.8, 4buc/pac

Carlige Legate KORUM Quickstop Hook Hairs Barbless, Nr.8, 4buc/pac

k0310250

Livrare 7-14 zile

17,01Lei

Pluta KORUM Glide Speci Stick, 5g, 3ssg, 1buc/pac

Pluta KORUM Glide Speci Stick, 5g, 3ssg, 1buc/pac

k0310130

Livrare imediată!

12,50Lei(-31%) 8,63Lei

Scaun KORUM Supa Lite Stretch Wide, 56x42x31cm

Scaun KORUM Supa Lite Stretch Wide, 56x42x31cm

k0300053

Livrare 7-14 zile

841,03Lei

Set Korum Dura Method Feeder And Mould 30GR

Set Korum Dura Method Feeder And Mould 30GR

kdmfm

Livrare imediată!

32,98Lei

Vartej cu Agrafa Rapida Korum Quick Snap Swivels Large

Vartej cu Agrafa Rapida Korum Quick Snap Swivels Large

k0310135

Livrare 7-14 zile

12,44Lei

BUZZ BAR KORUM SPEED FIT 2 ROD TILTING NARROW 2 POSTURI 28CM

BUZZ BAR KORUM SPEED FIT 2 ROD TILTING NARROW 2 POSTURI 28CM

k0360030

Livrare imediată!

80,96Lei(-48%) 42,16Lei

Stopper Korum Meat Stoppas, Large, 8buc/pac

Stopper Korum Meat Stoppas, Large, 8buc/pac

k0310213

Livrare 7-14 zile

12,44Lei

Fir Elastic Korum Marka Flex, Green, 5m

Fir Elastic Korum Marka Flex, Green, 5m

k0400008

Livrare imediată!

22,74Lei

Avertizor KORUM KSi8 Remote Bite Alarm, Bule

Avertizor KORUM KSi8 Remote Bite Alarm, Bule

k0360082

Livrare 7-14 zile

140,97Lei

Afişare 521 - 540 din 543 (28 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: 77.439 ms [By time] [By id] [By file]

1 (0.082)

SELECT data
FROM `oc_session`
WHERE session_id = 'e8057de43d05b62a567826324a'

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

2 (0.087)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.183)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Korum'

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

4 (0.161)

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

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

5 (37.816)

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 = '0' AND p.manufacturer_id = '357'

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

6 (38.970)

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 = '0' AND p.manufacturer_id = '357' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 520,20

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

7 (0.140)

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

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