Konger


Shad Konger Blinky, 019 Secret, 5cm, 12buc/pac

Shad Konger Blinky, 019 Secret, 5cm, 12buc/pac

130106337000019
Livrare 48-72 ore

18,99Lei

Spinnertail Konger Boogie, 007 Golden Perch, 6g

Spinnertail Konger Boogie, 007 Golden Perch, 6g

131606381101007
Livrare imediată!

27,41Lei

Valigeta Scaun Konger No.1, 365x232x365mm, Suporta Maxim 140kg

Valigeta Scaun Konger No.1, 365x232x365mm, Suporta Maxim 140kg

90306850900001
Livrare imediată!

170,02Lei

Rig Crap Konger Kamatsu Pro Carp Koi Bari, Nr.6, 25lbs, 20cm, 2buc/pac

Rig Crap Konger Kamatsu Pro Carp Koi Bari, Nr.6, 25lbs, 20cm, 2buc/pac

120206501420306
Livrare 48-72 ore

9,56Lei

Mulineta KONGER Turion Method Feeder 750FD, 4.7:1, 0.22mm/182m, 6+1rul

Mulineta KONGER Turion Method Feeder 750FD, 4.7:1, 0.22mm/182m, 6+1rul

30506005025750
Livrare imediată!

202,45Lei

Lingura Oscilanta KONGER Gnom No.0, Holo Green Scale, 7g

Lingura Oscilanta KONGER Gnom No.0, Holo Green Scale, 7g

130406340100295
Livrare imediată!

16,31Lei

Spinnertail Konger Boogie, 002 Blue Ridge, 4g

Spinnertail Konger Boogie, 002 Blue Ridge, 4g

131606381100002
Livrare imediată!

27,41Lei

Plumbi Drop Shot Konger Stick Weight 8g, 3buc/pac

Plumbi Drop Shot Konger Stick Weight 8g, 3buc/pac

40306665030008
Livrare imediată!

5,36Lei

Rig Crap Konger Kamatsu Pro Carp Matsui Expert, Nr.6, 25lbs, 20cm, 2buc/pac

Rig Crap Konger Kamatsu Pro Carp Matsui Expert, Nr.6, 25lbs, 20cm, 2buc/pac

120206501320306
Livrare 48-72 ore

9,56Lei

Lingura Oscilanta KONGER Castor, Gold , 20g

Lingura Oscilanta KONGER Castor, Gold , 20g

130406340220800
Livrare imediată!

15,90Lei

Lanseta KONGER Dread Cat Ground Rod, Up To 500g, 2.85m, 2seg

Lanseta KONGER Dread Cat Ground Rod, Up To 500g, 2.85m, 2seg

20306865200285
Livrare 48-72 ore

423,54Lei

Carlige Somn Konger Dread Cat Power Game Black Nickel Nr.8/0, 3buc/plic

Carlige Somn Konger Dread Cat Power Game Black Nickel Nr.8/0, 3buc/plic

121006865000018
Livrare 48-72 ore

18,23Lei

Agrafa Rapida Konger Team Carp Quick Snap Inel Oval 16mm 10buc/plic

Agrafa Rapida Konger Team Carp Quick Snap Inel Oval 16mm 10buc/plic

41406960000159
Livrare 48-72 ore

11,32Lei

Shad Konger Blinky, 021 Golden, 7.5cm, 8buc/pac

Shad Konger Blinky, 021 Golden, 7.5cm, 8buc/pac

130106337001021
Livrare 48-72 ore

15,93Lei

Lanseta Konger Kastmaster Jig Perch 2.32m, 1-10g, 2seg

Lanseta Konger Kastmaster Jig Perch 2.32m, 1-10g, 2seg

20406163002232
Livrare 48-72 ore

227,17Lei

Cosulet Feeder Konger Rotund Otel 60g, 6buc/pac

Cosulet Feeder Konger Rotund Otel 60g, 6buc/pac

40906776200060
Livrare 48-72 ore

41,55Lei

Rig Konger Kamatsu Kantousure Method Feeder Cu Spin, Monofilament, Nr.6, 0.25mm, 10cm, 5buc/pac

Rig Konger Kamatsu Kantousure Method Feeder Cu Spin, Monofilament, Nr.6, 0.25mm, 10cm, 5buc/pac

120306504021306
Livrare 48-72 ore

11,47Lei

Multifilament Konger Techron Olive 100m 0.06mm

Multifilament Konger Techron Olive 100m 0.06mm

259100006
Livrare 48-72 ore

140,00Lei

Fir Textil Konger Braider X8 Olive Green 0.20mm, 25.3kg, 150m

Fir Textil Konger Braider X8 Olive Green 0.20mm, 25.3kg, 150m

110606250150020
Livrare 48-72 ore

77,31Lei

Fir Fluorocarbon Coated Konger Steelon Method Feeder Verde 0.28mm, 10.5kg, 150m

Fir Fluorocarbon Coated Konger Steelon Method Feeder Verde 0.28mm, 10.5kg, 150m

110706257150028
Livrare imediată!

18,10Lei

Afişare 181 - 200 din 390 (20 pagini)
Queries: 7, Total time: 65.473 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = '6c01cf33e995d4612516fd5f4a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.071)
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 = 'konger.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.086)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '500' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.455)
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 = '500'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (34.526)
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 = '500' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.120)
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