Korum


Cap Suport Feeder KORUM Angle Tilt Compact Rest, 1buc/pac

Cap Suport Feeder KORUM Angle Tilt Compact Rest, 1buc/pac

k0360047
Livrare imediată!

35,99Lei

Cap Minciog Pliabil Korum Folding Spoon 30" 75x65

Cap Minciog Pliabil Korum Folding Spoon 30" 75x65

k0380011
Livrare imediată!

134,96Lei

LANSETA KORUM BIG WATER 3.65M 2.25LBS 2seg

LANSETA KORUM BIG WATER 3.65M 2.25LBS 2seg

k0330040
Livrare imediată!

674,96Lei

Cutie Riguri Korum Rig Blox, 6.8x10.9x7.4cm -40%

Cutie Riguri Korum Rig Blox, 6.8x10.9x7.4cm

k0290083
Livrare 7-14 zile

33,75Lei(-40%) 20,25Lei

Geanta Korum Progress EVA Pouches, 3.5L

Geanta Korum Progress EVA Pouches, 3.5L

k0290099
Livrare imediată!

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

Momitor KORUM Grub Feeder, 45g

Momitor KORUM Grub Feeder, 45g

k0320030
Livrare imediată!

17,96Lei

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

15,99Lei

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

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

k0330070
Livrare 7-14 zile

494,96Lei

Lanseta KORUM Classic Avon, 1.1lbs, 15-60g, 3.35m, 2seg

Lanseta KORUM Classic Avon, 1.1lbs, 15-60g, 3.35m, 2seg

K0330072
Livrare 7-14 zile

321,25Lei

Cap Minciog Korum Speci Square Net, 22" 55x45cm

Cap Minciog Korum Speci Square Net, 22" 55x45cm

k0380017
Livrare 7-14 zile

107,96Lei

LANSETA KORUM SNAPPER ZT SPIN RODS 2.30M 3-18G 2SEG

LANSETA KORUM SNAPPER ZT SPIN RODS 2.30M 3-18G 2SEG

z0680018
Livrare imediată!

400,91Lei

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

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

khxpb/06
Livrare imediată!

11,25Lei

Picheti Korum Power Banksticks, 30cm

Picheti Korum Power Banksticks, 30cm

k0360061
Livrare 7-14 zile

58,46Lei

Croseta KORUM Ti-Hair Needle Large

Croseta KORUM Ti-Hair Needle Large

k0310139
Livrare imediată!

17,96Lei

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

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

k0310240
Livrare imediată!

15,76Lei

Lanseta KORUM 3K Barbel, 1.75lbs, 3.35m, 2seg

Lanseta KORUM 3K Barbel, 1.75lbs, 3.35m, 2seg

k0330057
Livrare 7-14 zile

269,96Lei

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

15,99Lei

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

15,76Lei

Hangere KORUM Bite Indicator Bobbin Set

Hangere KORUM Bite Indicator Bobbin Set

K0360085
Livrare 7-14 zile

96,34Lei

Afişare 81 - 100 din 484 (25 pagini)
Queries: 7, Total time: 91.997 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = 'c9dee333be5bebf46e78083cae'
/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.091)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Korum'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.094)
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.506)
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 (55.033)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.106)
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