Korum

Korum

Sortare după:

ADAPTOR KORUM SPEEDFIT TRIPOD

ADAPTOR KORUM SPEEDFIT TRIPOD

k0360045

Livrare imediată!

97,05Lei

COSULET KORUM RIVER CAGE SMALL 60g

COSULET KORUM RIVER CAGE SMALL 60g

k0320054

Livrare 7-14 zile

18,16Lei

Korum Speci Heli Kits, 4buc/plic

Korum Speci Heli Kits, 4buc/plic

k0310182

Livrare imediată!

17,01Lei

Fir Monofilament KORUM Limitless Low Stretch Feeder Line, 3.6kg, 0.26mm, 300m

Fir Monofilament KORUM Limitless Low Stretch Feeder Line, 3.6kg, 0.26mm, 300m

k0390023

Livrare imediată!

28,41Lei

Suport KORUM Pentru Telefon Self Take Station

Suport KORUM Pentru Telefon Self Take Station

k0310254

Livrare imediată!

55,87Lei

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

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

k0310126

Livrare imediată!

11,25Lei(-38%) 7,01Lei

TRIPOD KORUM BARBEL DOUBLE RIVER 2 POSTURI

TRIPOD KORUM BARBEL DOUBLE RIVER 2 POSTURI

k0360017

Livrare imediată!

435,64Lei

Scaun Korum S23 Accessory Chair II, 95x65x65cm

Scaun Korum S23 Accessory Chair II, 95x65x65cm

k0300040

Livrare imediată!

720,00Lei(-15%) 610,98Lei

Cutie Momeala Korum Maggot Bait Tub, 1Pt/0.6l, Kaki

Cutie Momeala Korum Maggot Bait Tub, 1Pt/0.6l, Kaki

k0310264

Livrare imediată!

12,44Lei

Suport + Cutii Momeala Korum Compact Bait Waiter Set

Suport + Cutii Momeala Korum Compact Bait Waiter Set

k0310190

Livrare 7-14 zile

110,78Lei

Hanorac KORUM Classic Barbel Hoodie, Marimea S

Hanorac KORUM Classic Barbel Hoodie, Marimea S

k0350154

Livrare 7-14 zile

189,00Lei(-24%) 143,25Lei

Costum KORUM Neoteric 5X5 Waterproof Suit, Marime L

Costum KORUM Neoteric 5X5 Waterproof Suit, Marime L

k0350133

Livrare 7-14 zile

550,02Lei

Pluta KORUM Classic Pro Quill, 0.8g, 1buc/pac

Pluta KORUM Classic Pro Quill, 0.8g, 1buc/pac

K0310330

Livrare 7-14 zile

8,22Lei

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

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

k0310251

Livrare 7-14 zile

15,75Lei(-36%) 10,06Lei

$Minciog KORUM Glide Wading Net Latex Plutitor Pentru Pastrav, 30-60cm$ -40%

Minciog KORUM Glide Wading Net Latex Plutitor Pentru Pastrav, 30-60cm

k0380037

Livrare 7-14 zile

220,60Lei(-40%) 132,89Lei

Cuite KORUM Divided Bait Tub 2Pt, 1.12L

Cuite KORUM Divided Bait Tub 2Pt, 1.12L

k0310275

Livrare 7-14 zile

19,61Lei

Plumb Korum pentru pasta Bait Gripper Lead 60g

Plumb Korum pentru pasta Bait Gripper Lead 60g

k0310099

Livrare imediată!

15,88Lei

TRIPOD KORUM COMPACT RIVER

TRIPOD KORUM COMPACT RIVER

k0360034

Livrare imediată!

389,89Lei

Pluta Korum Glide Stubba Floats, 1.6g

Pluta Korum Glide Stubba Floats, 1.6g

k0310194

Livrare 7-14 zile

12,44Lei

Fir Textil KORUM Smokeshield Coated Braid, 10lbs, 10m

Fir Textil KORUM Smokeshield Coated Braid, 10lbs, 10m

k0400004

Livrare 7-14 zile

74,95Lei(-38%) 46,73Lei

Afişare 461 - 480 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: 72.839 ms [By time] [By id] [By file]

1 (0.120)

SELECT data
FROM `oc_session`
WHERE session_id = '517f4ea8d39f2eb5773fdca8b4'

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.116)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Korum'

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

4 (0.117)

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 (31.850)

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 (40.368)

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 460,20

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

7 (0.164)

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