Nufish


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

40,55Lei

Geanta NuFish Tray & Net Bag

Geanta NuFish Tray & Net Bag

nfl03
Livrare imediată!

239,96Lei

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

41,58Lei

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

40,55Lei

Brat Umbrela NUFISH Dublu NFX06

Brat Umbrela NUFISH Dublu NFX06

nfx06
Livrare imediată!

148,44Lei

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

41,58Lei

Geanta Universala NUFISH Hardbase Carryall, 60 Litri

Geanta Universala NUFISH Hardbase Carryall, 60 Litri

nfl02
Livrare imediată!

346,71Lei

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

40,55Lei

Geanta NUFISH Hardbase 55 Litri, 60x40x37cm

Geanta NUFISH Hardbase 55 Litri, 60x40x37cm

nfl200
Livrare imediată!

406,71Lei

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

41,58Lei

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

40,55Lei

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

40,55Lei

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

41,58Lei

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

40,55Lei

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

41,58Lei

Brat Suport Accesorii NUFISH NFX11

Brat Suport Accesorii NUFISH NFX11

nfx11
Livrare imediată!

87,43Lei

Surub Blocare Spatar NuFish Restabox

Surub Blocare Spatar NuFish Restabox

sp025
Livrare 48-72 ore

26,32Lei

MIXER NADA NuFish INOX WSK

MIXER NADA NuFish INOX WSK

5035305802160
Livrare 48-72 ore

163,59Lei

Struna NUFISH Elastic / Fir, 3m

Struna NUFISH Elastic / Fir, 3m

5035305800821
Livrare imediată!

27,35Lei

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

nfl205
Livrare imediată!

406,71Lei

Afişare 1 - 20 din 23 (2 pagini)
Queries: 7, Total time: 1.670 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '4815013e4f96a7e6936a3dc1c3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.093)
SELECT *
FROM oc_url_alias
WHERE keyword = 'nufish.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.088)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (0.383)
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 = '541'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (0.846)
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 = '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.101)
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