Konger


Varga Konger Grafitex Pole 6.00m, 5-20gr, 6seg

Varga Konger Grafitex Pole 6.00m, 5-20gr, 6seg

10106143002600
Livrare 48-72 ore

132,71Lei

Shad Konger Blinky, 001 Blue Pearl, 5cm, 12buc/pac

Shad Konger Blinky, 001 Blue Pearl, 5cm, 12buc/pac

130106337000001
Livrare 48-72 ore

18,99Lei

Spinnertail Konger Boogie, 006 Black Perch, 4g

Spinnertail Konger Boogie, 006 Black Perch, 4g

131606381100006
Livrare imediată!

27,41Lei

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

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

40306665030020
Livrare 48-72 ore

8,68Lei

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

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

120206501320304
Livrare 48-72 ore

9,56Lei

Lingura Oscilanta KONGER Castor, Cooper, 20g

Lingura Oscilanta KONGER Castor, Cooper, 20g

130406340220700
Livrare imediată!

15,90Lei

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

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

20306865200315
Livrare 48-72 ore

439,73Lei

Carlige Konger Carplabs Stiff Rigger Titanium Grey Ringed Nr.2, 6buc/plic

Carlige Konger Carplabs Stiff Rigger Titanium Grey Ringed Nr.2, 6buc/plic

120506765105902
Livrare 48-72 ore

11,61Lei

Agrafa Rapida Konger Carplabs Fastach Snap 10buc/plic

Agrafa Rapida Konger Carplabs Fastach Snap 10buc/plic

41406765000079
Livrare 48-72 ore

7,89Lei

Shad Konger Blinky, 004 Rash, 7.5cm, 8buc/pac

Shad Konger Blinky, 004 Rash, 7.5cm, 8buc/pac

130106337001004
Livrare 48-72 ore

15,93Lei

Lanseta Konger Turion Feeder 3.90m, 150g, 3+3seg

Lanseta Konger Turion Feeder 3.90m, 150g, 3+3seg

20506150006390
Livrare 48-72 ore

394,07Lei

Cosulet Feeder Konger Patrat Otel 40g, 6buc/pac

Cosulet Feeder Konger Patrat Otel 40g, 6buc/pac

40906778200040
Livrare 48-72 ore

36,10Lei

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

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

120306504019308
Livrare 48-72 ore

11,47Lei

Fir Textil Konger Dread Cat Braided VX8 Negru, 300m, 0.60mm, 72.2kg

Fir Textil Konger Dread Cat Braided VX8 Negru, 300m, 0.60mm, 72.2kg

110406865000091
Livrare 48-72 ore

121,33Lei

Shad Konger Blinky, 013 Blue Ghost, 7.5cm, 8buc/pac

Shad Konger Blinky, 013 Blue Ghost, 7.5cm, 8buc/pac

130106337001013
Livrare 48-72 ore

15,93Lei

Larve Libelula Artificiale Konger Bloodworm cu Aroma Shrimp, 10g, 180buc/pac

Larve Libelula Artificiale Konger Bloodworm cu Aroma Shrimp, 10g, 180buc/pac

141106333000010
Livrare imediată!

23,32Lei

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 2.00m, 4seg

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 2.00m, 4seg

20406161005200
Livrare 48-72 ore

529,04Lei

Lanseta KONGER Kastmaster Spin H, 2.70m, 10-42g, 2seg

Lanseta KONGER Kastmaster Spin H, 2.70m, 10-42g, 2seg

20406163011270
Livrare 48-72 ore

330,51Lei

Leadcore Konger Vara Toamna, 45lbs, 5m

Leadcore Konger Vara Toamna, 45lbs, 5m

110206960000156
Livrare imediată!

27,27Lei

Shad Konger Blinky, 015 Transparent Ayu, 5cm, 12buc/pac

Shad Konger Blinky, 015 Transparent Ayu, 5cm, 12buc/pac

130106337000015
Livrare 48-72 ore

18,99Lei

Afişare 1 - 20 din 388 (20 pagini)
Queries: 7, Total time: 75.204 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '2e3e800e560fa297f96d6e6ad4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'konger.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.131)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (32.941)
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 = '3' AND p.manufacturer_id = '500'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (41.650)
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 = '3' AND p.manufacturer_id = '500' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.123)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37