Korum


LANSETA KORUM PHASE 1 FLOAT 3.04M 1-15G 2seg -17%

LANSETA KORUM PHASE 1 FLOAT 3.04M 1-15G 2seg

k0330026
Livrare imediată!

179,96Lei(-17%) 149,90Lei

Carlige KORUM Xpert Power Hook Micro-Barbed Nr.14, 10buc/plic

Carlige KORUM Xpert Power Hook Micro-Barbed Nr.14, 10buc/plic

khxpb/14
Livrare imediată!

11,25Lei

Picheti Korum Power Twist Banksticks, 60cm

Picheti Korum Power Twist Banksticks, 60cm

k0360066
Livrare 7-14 zile

94,46Lei

Jacheta Korum Thermashell Jacket, Green-Black, Marimea L

Jacheta Korum Thermashell Jacket, Green-Black, Marimea L

k0350126
Livrare 7-14 zile

269,96Lei

Carlige KORUM Xpert Power Hook Barbless Nr.6, 10buc/pac

Carlige KORUM Xpert Power Hook Barbless Nr.6, 10buc/pac

khxp/06
Livrare 24-48 ore

11,25Lei

Vesta KORUM Progress Roving Vest, Kaki

Vesta KORUM Progress Roving Vest, Kaki

k0350138
Livrare 7-14 zile

314,96Lei

Carlige Legate KORUM Big Fish Hair Rigs with Quickstop 10cm, Nr.8 Barbed, 8buc/pac

Carlige Legate KORUM Big Fish Hair Rigs with Quickstop 10cm, Nr.8 Barbed, 8buc/pac

k0310048
Livrare 7-14 zile

15,99Lei

Flotor KORUM Progress Slim Net Float, 20x6cm

Flotor KORUM Progress Slim Net Float, 20x6cm

k0290124
Livrare 7-14 zile

53,95Lei

Cantar digital Korum Compact Digital Scale

Cantar digital Korum Compact Digital Scale

k0310121
Livrare imediată!

161,96Lei

SCAUN FEEDER KORUM S23 DELUXE ACCESORY CHAIR

SCAUN FEEDER KORUM S23 DELUXE ACCESORY CHAIR

k0300023
Livrare imediată!

989,96Lei

CAP MINCIOG PLIABIL KORUM FOLDING TRIANGLE NET 26" 60X55CM

CAP MINCIOG PLIABIL KORUM FOLDING TRIANGLE NET 26" 60X55CM

k0380015
Livrare 7-14 zile

121,46Lei

Cutie Korum Tackle Blox - Fully Loaded, 19.6 x 25 x 9.1cm

Cutie Korum Tackle Blox - Fully Loaded, 19.6 x 25 x 9.1cm

k0290081
Livrare imediată!

179,96Lei

Carlige Legate Korum Banded Hook Hairs Barbed, Nr.8, 5buc/pac

Carlige Legate Korum Banded Hook Hairs Barbed, Nr.8, 5buc/pac

k0310237
Livrare imediată!

15,76Lei

Geanta Accesorii Korum Progress Hardcase Pouch 4L, 26x20x9.5cm

Geanta Accesorii Korum Progress Hardcase Pouch 4L, 26x20x9.5cm

k0290107
Livrare 7-14 zile

107,96Lei

Brolly Korum Recoil Shelter, 260x160x140cm

Brolly Korum Recoil Shelter, 260x160x140cm

k0370010
Livrare 7-14 zile

697,46Lei

Cosulet Naditor KORUM Combi Feeder, Large, 150g, 1buc/pac

Cosulet Naditor KORUM Combi Feeder, Large, 150g, 1buc/pac

k0320095
Livrare imediată!

23,63Lei

Lanseta KORUM 3K Barbel, 2.25lbs, 3.60m, 2seg

Lanseta KORUM 3K Barbel, 2.25lbs, 3.60m, 2seg

k0330059
Livrare 7-14 zile

292,45Lei

Fir Monofilament KORUM SmokeScreen Mono Hooklink, 2.72kg-6lbs, 0.23mm, 50m -50%

Fir Monofilament KORUM SmokeScreen Mono Hooklink, 2.72kg-6lbs, 0.23mm, 50m

k0390001
Livrare 7-14 zile

24,95Lei(-50%) 12,48Lei

Fir Monofilament KORUM Smokeshield Mono Hooklink, 8lbs/3.60kg, 0.26mm, 50m -40%

Fir Monofilament KORUM Smokeshield Mono Hooklink, 8lbs/3.60kg, 0.26mm, 50m

k0390012
Livrare 7-14 zile

24,95Lei(-40%) 14,97Lei

Carlige Legate KORUM Hair Rigs Barbless, 8lbs, Nr.14, 38cm, 8buc/pac

Carlige Legate KORUM Hair Rigs Barbless, 8lbs, Nr.14, 38cm, 8buc/pac

k0310316
Livrare 7-14 zile

16,87Lei

Afişare 141 - 160 din 451 (23 pagini)
Queries: 7, Total time: 77.925 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = '30d96584bf4f77379492bc35f1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.095)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Korum'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.111)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (36.320)
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 = '357'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (41.094)
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 = '357' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.139)
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