Konger


Fir Textil Konger Braider X8 Olive Green 0.10mm, 10.7kg, 150m

Fir Textil Konger Braider X8 Olive Green 0.10mm, 10.7kg, 150m

110606250150010
Livrare 48-72 ore

77,31Lei

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.22mm, 6.7kg, 150m

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.22mm, 6.7kg, 150m

110706202150022
Livrare 48-72 ore

21,67Lei

Fir Textil Konger Rigging Line Kevlon X4 Black 0.25mm, 29.2kg, 10m

Fir Textil Konger Rigging Line Kevlon X4 Black 0.25mm, 29.2kg, 10m

110806250014025
Livrare imediată!

7,39Lei

Cicada Konger Viber Blue Ridge 002, 9g

Cicada Konger Viber Blue Ridge 002, 9g

130606381302002
Livrare 48-72 ore

29,06Lei

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

9,69Lei

Carlige Legate Method Feeder KONGER pe Spin Kamatsu Sensei Barbless Fir Textil, Nr.12, 0.12mm, 10cm, 5buc/pac

Carlige Legate Method Feeder KONGER pe Spin Kamatsu Sensei Barbless Fir Textil, Nr.12, 0.12mm, 10cm, 5buc/pac

120306502333312
Livrare 48-72 ore

12,25Lei

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

216,23Lei

Fir Textil Konger Braider X4 Fluo Green 0.08mm, 5.2kg, 150m

Fir Textil Konger Braider X4 Fluo Green 0.08mm, 5.2kg, 150m

110606250145008
Livrare 48-72 ore

54,84Lei

Fir Textil Konger Kevlon X4 Yellow Fluo 0.16mm, 15.9kg, 150m

Fir Textil Konger Kevlon X4 Yellow Fluo 0.16mm, 15.9kg, 150m

110606250154016
Livrare 48-72 ore

52,53Lei

Fir Textil Konger Rigging Line Braider X8 Black 0.20mm, 25.3kg, 10m

Fir Textil Konger Rigging Line Braider X8 Black 0.20mm, 25.3kg, 10m

110806250013020
Livrare 48-72 ore

9,81Lei

Cicada Konger Viber Golden Perch 007, 3g

Cicada Konger Viber Golden Perch 007, 3g

130606381300007
Livrare 48-72 ore

28,17Lei

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ă!

38,31Lei

Fir Monofilament Konger Team Catfish Grey 0.50mm, 16.9kg, 250m

Fir Monofilament Konger Team Catfish Grey 0.50mm, 16.9kg, 250m

110306214003050
Livrare 48-72 ore

21,41Lei

Fir Textil Konger Kevlon X4 Black 0.20mm, 22.3kg, 150m

Fir Textil Konger Kevlon X4 Black 0.20mm, 22.3kg, 150m

110606250151020
Livrare 48-72 ore

47,72Lei

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.18mm, 21.4kg

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.18mm, 21.4kg

110806250012018
Livrare imediată!

12,17Lei

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.14mm, 3.35kg

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.14mm, 3.35kg

110706240050014
Livrare imediată!

5,99Lei

Carlige Legate Kamatsu Fast Stop Chinu Mono, 10cm, Nr.10, 0.22mm, 5buc/pac

Carlige Legate Kamatsu Fast Stop Chinu Mono, 10cm, Nr.10, 0.22mm, 5buc/pac

120306504023310
Livrare 48-72 ore

11,09Lei

Lip Grip Konger Cu Cantar Si Metru, 22kg, 28cm

Lip Grip Konger Cu Cantar Si Metru, 22kg, 28cm

43006989100009
Livrare 48-72 ore

106,22Lei

Afişare 381 - 398 din 398 (20 pagini)
Queries: 7, Total time: 74.102 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = 'b1f5287f93ab18f23257fd7b71'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'konger.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.136)
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 (31.272)
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 (42.283)
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 380,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.136)
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