Konger


Carlige Legate Kamatsu Fast Stop Iseama Braid, 10cm, Nr.10, 0.12mm, 5buc/pac

Carlige Legate Kamatsu Fast Stop Iseama Braid, 10cm, Nr.10, 0.12mm, 5buc/pac

120306502001310
Livrare 48-72 ore

13,18Lei

Carlige KONGER Methodman Speed Grip Titanium Grey, Nr.14, 10buc/pac

Carlige KONGER Methodman Speed Grip Titanium Grey, Nr.14, 10buc/pac

121406810100414
Livrare 48-72 ore

10,09Lei

Fir Textil Konger Streeto Ultra Tiny Olive Green 0.06mm, 2.86kg, 150m

Fir Textil Konger Streeto Ultra Tiny Olive Green 0.06mm, 2.86kg, 150m

110606216151006
Livrare 48-72 ore

81,08Lei

Fir Textil Konger Kevlon X4 Yellow Fluo 0.14mm, 14.5kg, 150m

Fir Textil Konger Kevlon X4 Yellow Fluo 0.14mm, 14.5kg, 150m

110606250154014
Livrare 48-72 ore

54,41Lei

Fir Textil Konger Rigging Line Braider X8 Black 0.06mm, 4.9kg, 10m

Fir Textil Konger Rigging Line Braider X8 Black 0.06mm, 4.9kg, 10m

110806250013006
Livrare imediată!

12,02Lei

Larve Libelula Artificiale Konger Aroma Mayfly, 10gr

Larve Libelula Artificiale Konger Aroma Mayfly, 10gr

141106333000009
Livrare imediată!

24,71Lei

Montura Somn Konger Dread Cat Carlig Rattle Snake 80cm, 36.3kg, Nr.4/0, 1buc/pac

Montura Somn Konger Dread Cat Carlig Rattle Snake 80cm, 36.3kg, Nr.4/0, 1buc/pac

120406865100001
Livrare imediată!

39,95Lei

Carlige Legate Kamatsu Chinu Rig Method Feeder Cu Inel Silicon, 10cm, Nr.10, 0.22mm, 5buc/pac

Carlige Legate Kamatsu Chinu Rig Method Feeder Cu Inel Silicon, 10cm, Nr.10, 0.22mm, 5buc/pac

120306504026310
Livrare 48-72 ore

10,85Lei

Fir Monofilament Konger Team Carp Black 0.30mm, 11.3kg, 1000m

Fir Monofilament Konger Team Carp Black 0.30mm, 11.3kg, 1000m

110106228001030
Livrare 48-72 ore

40,27Lei

Fir Textil Konger Kevlon X4 Black 0.18mm, 17.3kg, 150m

Fir Textil Konger Kevlon X4 Black 0.18mm, 17.3kg, 150m

110606250151018
Livrare 48-72 ore

49,53Lei

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.06mm, 4.9kg

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.06mm, 4.9kg

110806250012006
Livrare imediată!

10,72Lei

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.12mm, 2.60kg

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.12mm, 2.60kg

110706240050012
Livrare imediată!

7,08Lei

Carlige Montate Nr.4 KONGER Sabiki, 120cm, Rig Nr.6

Carlige Montate Nr.4 KONGER Sabiki, 120cm, Rig Nr.6

121306401028004
Livrare 48-72 ore

11,07Lei

Fir Textil Konger Braider X8 Olive Green 0.18mm, 21.4kg, 150m

Fir Textil Konger Braider X8 Olive Green 0.18mm, 21.4kg, 150m

110606250150018
Livrare 48-72 ore

79,61Lei

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.18mm, 5kg, 150m

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.18mm, 5kg, 150m

110706202150018
Livrare 48-72 ore

19,28Lei

Fir Textil Konger Rigging Line Kevlon X4 Black 0.18mm, 17.3kg, 10m

Fir Textil Konger Rigging Line Kevlon X4 Black 0.18mm, 17.3kg, 10m

110806250014018
Livrare imediată!

8,51Lei

Cicada Konger Viber Blue Ridge 002, 9g

Cicada Konger Viber Blue Ridge 002, 9g

130606381302002
Livrare 48-72 ore

30,55Lei

Lanseta KONGER Tokyoto Spin Rod, Up To 30g, 2.10m, 2seg

Lanseta KONGER Tokyoto Spin Rod, Up To 30g, 2.10m, 2seg

20406167001210
Livrare 48-72 ore

220,87Lei

Carlige KONGER Methodman Diamond Grip Titanium Grey, Nr.12, 10buc/pac

Carlige KONGER Methodman Diamond Grip Titanium Grey, Nr.12, 10buc/pac

121406810100812
Livrare 48-72 ore

10,41Lei

Fir Textil Konger Braider X4 Fluo Green 0.10mm, 9.8kg, 150m

Fir Textil Konger Braider X4 Fluo Green 0.10mm, 9.8kg, 150m

110606250145010
Livrare 48-72 ore

54,20Lei

Afişare 301 - 320 din 382 (20 pagini)
Queries: 7, Total time: 92.672 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = 'ba6aefb9ae8cba82b0449cbab2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
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.122)
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 (40.636)
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 (51.370)
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 300,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.198)
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