Konger


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

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

Cicada Konger Viber Golden Perch 007, 9g

Cicada Konger Viber Golden Perch 007, 9g

130606381302007
Livrare 48-72 ore

29,06Lei

Carlige Legate Kamatsu Fast Stop Kantousure, 10cm, Nr.10, 0.20mm, 5buc/pac

Carlige Legate Kamatsu Fast Stop Kantousure, 10cm, Nr.10, 0.20mm, 5buc/pac

120306504024310
Livrare 48-72 ore

11,09Lei

Pilker KONGER Kastmaster Turbo, Silver, 7g

Pilker KONGER Kastmaster Turbo, Silver, 7g

131706380200001
Livrare imediată!

16,10Lei

Fir Textil Konger Braider X8 Black 0.06mm, 4.9kg, 150m

Fir Textil Konger Braider X8 Black 0.06mm, 4.9kg, 150m

110606250148006
Livrare imediată!

79,83Lei

Fir Textil Konger Braider X8 Green Fluo 0.14mm, 17.5kg, 150m

Fir Textil Konger Braider X8 Green Fluo 0.14mm, 17.5kg, 150m

110606250157014
Livrare 48-72 ore

77,67Lei

Fir Textil Konger Rigging Line Kevlon X4 Black 0.14mm, 14.5kg, 10m

Fir Textil Konger Rigging Line Kevlon X4 Black 0.14mm, 14.5kg, 10m

110806250014014
Livrare imediată!

7,39Lei

Cicada Konger Viber White Perch 005, 6g

Cicada Konger Viber White Perch 005, 6g

130606381301005
Livrare 48-72 ore

28,68Lei

Carlige Legate Kamatsu Iseama Rig Method Feeder Cu Inel Silicon, 10cm, Nr.12, 0.20mm, 5buc/pac

Carlige Legate Kamatsu Iseama Rig Method Feeder Cu Inel Silicon, 10cm, Nr.12, 0.20mm, 5buc/pac

120306504025312
Livrare 48-72 ore

9,69Lei

Lanseta KONGER Vistar Spin Rod, Up To 35g, 2.70m, 2seg

Lanseta KONGER Vistar Spin Rod, Up To 35g, 2.70m, 2seg

20406101006270
Livrare 48-72 ore

278,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

78,75Lei

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

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

110606250153018
Livrare 48-72 ore

52,53Lei

Fir Textil Konger Rigging Line Braider X8 Black, 10m, 0.12mm, 11.8kg

Fir Textil Konger Rigging Line Braider X8 Black, 10m, 0.12mm, 11.8kg

110806250013012
Livrare imediată!

9,81Lei

Cicada Konger Viber Natural Perch 003, 3g

Cicada Konger Viber Natural Perch 003, 3g

130606381300003
Livrare 48-72 ore

28,17Lei

Larve Libelula Artificiale Konger Aroma Mayfly, 10gr

Larve Libelula Artificiale Konger Aroma Mayfly, 10gr

141106333000009
Livrare imediată!

23,32Lei

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

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

120306502111312
Livrare 48-72 ore

12,25Lei

Afişare 361 - 380 din 398 (20 pagini)
Queries: 7, Total time: 72.191 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '98079419c7dbaa1689e38e6c20'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.120)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.146)
SELECT *
FROM oc_url_alias
WHERE keyword = 'konger.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.100)
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 (33.564)
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 (38.048)
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 360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.108)
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