Nufish


Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Blue, 2.40mm, 3m

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Blue, 2.40mm, 3m

5035305802832
Livrare 48-72 ore

38,00Lei

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.18mm, 1.82kg, 150m

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.18mm, 1.82kg, 150m

5061001690237
Livrare 48-72 ore

39,00Lei

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Orange, 1.60mm, 3m

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Orange, 1.60mm, 3m

5035305802795
Livrare 48-72 ore

38,00Lei

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.20mm, 2.27kg, 150m

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.20mm, 2.27kg, 150m

5061001690244
Livrare 48-72 ore

39,00Lei

Elastic NuFish Zipp Hybrid EZ Match Feeder, White, 1.80mm, 3m

Elastic NuFish Zipp Hybrid EZ Match Feeder, White, 1.80mm, 3m

5035305802801
Livrare 48-72 ore

38,00Lei

Geanta NuFish Tray & Net Bag

Geanta NuFish Tray & Net Bag

nfl03
Livrare imediată!

235,00Lei

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.28mm, 4.54kg, 150m

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.28mm, 4.54kg, 150m

5061001690275
Livrare 48-72 ore

39,00Lei

Elastic NuFish Zipp Hybrid EZ Match Feeder, Black, 2.00mm, 3m

Elastic NuFish Zipp Hybrid EZ Match Feeder, Black, 2.00mm, 3m

5035305802818
Livrare imediată!

38,00Lei

Brat Umbrela NUFISH Dublu NFX06

Brat Umbrela NUFISH Dublu NFX06

nfx06
Livrare imediată!

145,00Lei

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Pink, 1.20mm, 3m

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Pink, 1.20mm, 3m

5035305802771
Livrare 48-72 ore

39,00Lei

Geanta Universala NUFISH Hardbase Carryall, 60 Litri

Geanta Universala NUFISH Hardbase Carryall, 60 Litri

nfl02
Livrare imediată!

339,99Lei

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Green, 2.20mm, 3m

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Green, 2.20mm, 3m

5035305802825
Livrare 48-72 ore

38,00Lei

Geanta NUFISH Hardbase 55 Litri, 60x40x37cm

Geanta NUFISH Hardbase 55 Litri, 60x40x37cm

nfl200
Livrare imediată!

399,00Lei

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.16mm, 1.36kg, 150m

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.16mm, 1.36kg, 150m

5061001690220
Livrare 48-72 ore

39,00Lei

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Yellow, 1.40mm, 3m

Elastic NuFish Zipp Hybrid EZ Match Feeder, Fluoro Yellow, 1.40mm, 3m

5035305802788
Livrare 48-72 ore

38,00Lei

Struna NUFISH Elastic / Fir, 3m

Struna NUFISH Elastic / Fir, 3m

5035305800821
Livrare imediată!

25,00Lei

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

nfl205
Livrare imediată!

399,00Lei

Tub PTFE Ghidaj Elastic STONFO 694 Curved

Tub PTFE Ghidaj Elastic STONFO 694 Curved

8028651018498
Livrare 48-72 ore

28,00Lei

Brat Suport Accesorii NUFISH Cross Arm

Brat Suport Accesorii NUFISH Cross Arm

nfx13
Livrare imediată!

97,00Lei

Retainer Picior Scaun NuFish Restabox

Retainer Picior Scaun NuFish Restabox

sp010
Livrare 48-72 ore

32,00Lei

Afişare 1 - 20 din 23 (2 pagini)
Queries: 7, Total time: 2.470 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = '16db5a2c35d0dd1af5201fb089'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'nufish.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.140)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '541' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (0.583)
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 = '541'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (1.242)
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 = '541' 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.137)
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