Konger


Fir Textil Konger Rigging Line Kevlon X4 Black 0.10mm, 9.8kg, 10m

Fir Textil Konger Rigging Line Kevlon X4 Black 0.10mm, 9.8kg, 10m

110806250014010
Livrare imediată!

8,51Lei

Cicada Konger Viber Golden Perch 007, 6g

Cicada Konger Viber Golden Perch 007, 6g

130606381301007
Livrare 48-72 ore

30,17Lei

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

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

120306504024312
Livrare 48-72 ore

12,28Lei

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

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

121406810100810
Livrare 48-72 ore

10,56Lei

Fir Textil Konger Streeto Ultra Tiny Olive Green 0.08mm, 3.95kg, 150m

Fir Textil Konger Streeto Ultra Tiny Olive Green 0.08mm, 3.95kg, 150m

110606216151008
Livrare 48-72 ore

80,96Lei

Fir Textil Konger Rigging Line Braider X8 Black 0.08mm, 7.6kg, 10m

Fir Textil Konger Rigging Line Braider X8 Black 0.08mm, 7.6kg, 10m

110806250013008
Livrare imediată!

10,97Lei

Cicada Konger Viber Natural Perch 003, 3g

Cicada Konger Viber Natural Perch 003, 3g

130606381300003
Livrare 48-72 ore

29,65Lei

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

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

120306504025308
Livrare imediată!

10,85Lei

Fir Monofilament Konger Team Carp Black 0.35mm, 13.5kg, 1000m

Fir Monofilament Konger Team Carp Black 0.35mm, 13.5kg, 1000m

110106228001035
Livrare imediată!

47,52Lei

Fir Textil Konger Kevlon X4 Black 0.25mm, 29.2kg, 150m

Fir Textil Konger Kevlon X4 Black 0.25mm, 29.2kg, 150m

110606250151025
Livrare 48-72 ore

49,53Lei

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.04mm, 4.05kg

Fir Textil Konger Rigging Line Braider X8 Olive Green, 10m, 0.04mm, 4.05kg

110806250012004
Livrare imediată!

13,37Lei

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.22mm, 6.65kg

Fir Monofilament Konger Steelon CC Cristal Clear Ice, 50m, 0.22mm, 6.65kg

110706240050022
Livrare imediată!

7,08Lei

Carlige Legate Kamatsu Iseama Rig Method Feeder Braid, 10cm, Nr.12, 0.12mm, 5buc/pac

Carlige Legate Kamatsu Iseama Rig Method Feeder Braid, 10cm, Nr.12, 0.12mm, 5buc/pac

120306502011312
Livrare 48-72 ore

11,89Lei

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

13,46Lei

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

79,61Lei

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.20mm, 5.9kg, 150m

Fir Monofilament Konger Metron Specialist ProCarp and Feeder Verde Camou 0.20mm, 5.9kg, 150m

110706202150020
Livrare 48-72 ore

20,96Lei

Fir Textil Konger Rigging Line Kevlon X4 Black 0.20mm, 22.3kg, 10m

Fir Textil Konger Rigging Line Kevlon X4 Black 0.20mm, 22.3kg, 10m

110806250014020
Livrare imediată!

8,51Lei

Cicada Konger Viber White Perch 005, 9g

Cicada Konger Viber White Perch 005, 9g

130606381302005
Livrare 48-72 ore

30,55Lei

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

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

120306502001308
Livrare 48-72 ore

13,18Lei

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

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

121406810100410
Livrare 48-72 ore

10,56Lei

Afişare 261 - 280 din 388 (20 pagini)
Queries: 7, Total time: 74.419 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = 'b8c4368838c4f57afc66bcb81e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'konger.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.092)
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.985)
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.937)
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 260,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.129)
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