Korum


Con Korum Anti Tangle Sleeve Short, Camo, 10buc/plic

Con Korum Anti Tangle Sleeve Short, Camo, 10buc/plic

k0310229
Livrare 7-14 zile

23,84Lei

Jacheta Korum Thermashell Jacket, Green-Black, Marimea XL

Jacheta Korum Thermashell Jacket, Green-Black, Marimea XL

k0350127
Livrare 7-14 zile

275,50Lei

Husa Lansete KORUM Progress Folding Quiver 2 Rod

Husa Lansete KORUM Progress Folding Quiver 2 Rod

k0290119
Livrare 7-14 zile

275,50Lei

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

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

k0310051
Livrare 7-14 zile

17,25Lei

Lanseta KORUM Limitless Power, 2.75lbs, 3.60m, 2seg

Lanseta KORUM Limitless Power, 2.75lbs, 3.60m, 2seg

k0330070
Livrare 7-14 zile

504,27Lei

Hangere KORUM Bite Indicator Bobbin Set

Hangere KORUM Bite Indicator Bobbin Set

k0360085
Livrare 7-14 zile

98,97Lei

Cizme KORUM Thermalite EVA Welly Boot, Marime 42

Cizme KORUM Thermalite EVA Welly Boot, Marime 42

K0350181
Livrare 7-14 zile

275,35Lei

SET CROSETE KORUM TI BAITING NEEDLE SET

SET CROSETE KORUM TI BAITING NEEDLE SET

k0310141
Livrare imediată!

97,05Lei

MOMITOR INLINE KORUM CAMO METHOD LARGE 30g

MOMITOR INLINE KORUM CAMO METHOD LARGE 30g

k0320046
Livrare imediată!

14,69Lei

Carlige Legate Korum Xpert Maggot Barbless Hooks to Nylon Nr.16, 30cm, 0.15mm, 4lb, 8buc/pac

Carlige Legate Korum Xpert Maggot Barbless Hooks to Nylon Nr.16, 30cm, 0.15mm, 4lb, 8buc/pac

k0310211
Livrare 7-14 zile

17,01Lei

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

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

k0310238
Livrare imediată!

17,01Lei

Rucksac Korum Progress Roversack 25L, 40x30x20cm

Rucksac Korum Progress Roversack 25L, 40x30x20cm

k0290103
Livrare 7-14 zile

229,74Lei

Tava Laterala Korum Tackle Tray, 30x32cm

Tava Laterala Korum Tackle Tray, 30x32cm

k0300038
Livrare imediată!

183,98Lei

Cosulet Naditor KORUM Combi Feeder, Medium, 120g, 1buc/pac

Cosulet Naditor KORUM Combi Feeder, Medium, 120g, 1buc/pac

k0320091
Livrare imediată!

23,84Lei

Sistem KORUM Distance Marker Sticks, 50cm

Sistem KORUM Distance Marker Sticks, 50cm

k0360075
Livrare 7-14 zile

55,87Lei

Fir Monofilament KORUM SmokeScreen Mono Hooklink, 4.53kg-10lbs, 0.28mm, 50m -45%

Fir Monofilament KORUM SmokeScreen Mono Hooklink, 4.53kg-10lbs, 0.28mm, 50m

k0390003
Livrare imediată!

24,95Lei(-45%) 13,69Lei

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

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

k0310058
Livrare 7-14 zile

17,25Lei

Carlige Legate KORUM Power Hair Rigs Barbed Mono, 100cm, 12lbs, 0.30mm, Nr.8, 6buc/pac

Carlige Legate KORUM Power Hair Rigs Barbed Mono, 100cm, 12lbs, 0.30mm, Nr.8, 6buc/pac

k0310283
Livrare 7-14 zile

17,01Lei

Cosulet KORUM River Cage XT Feeder Large, 90g, 1buc/pac

Cosulet KORUM River Cage XT Feeder Large, 90g, 1buc/pac

k0310304
Livrare 7-14 zile

21,02Lei

MULINETA KORUM ZELOS 4000 -26%

MULINETA KORUM ZELOS 4000

k0340017
Livrare imediată!

292,51Lei(-26%) 216,57Lei

Afişare 261 - 280 din 493 (25 pagini)
Queries: 7, Total time: 71.201 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '4b4621e6ddd7fbdabfd61361ad'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.184)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Korum'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.114)
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 (32.619)
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 (37.847)
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 260,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.180)
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