Nufish

Nufish

Sortare după:

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

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.26mm, 3.63kg, 150m

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.26mm, 3.63kg, 150m

5061001690268

Livrare 48-72 ore

39,00Lei

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

Tava Laterala NUFISH Aqualock

Tava Laterala NUFISH Aqualock

nfx07

Livrare imediată!

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

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

Geanta NuFish Tray & Net Bag

Geanta NuFish Tray & Net Bag

nfl03

Livrare imediată!

235,00Lei

Geanta Universala NUFISH Hardbase Carryall, 60 Litri

Geanta Universala NUFISH Hardbase Carryall, 60 Litri

nfl02

Livrare imediată!

339,99Lei

Tava Laterala NUFISH 6040 Lite NFX14

Tava Laterala NUFISH 6040 Lite NFX14

nfx14

Livrare imediată!

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

Tava Laterala NUFISH Combi Tray

Tava Laterala NUFISH Combi Tray

nfx15

Livrare imediată!

865,00Lei

Umbrela NuFish Nylon Economi NFU050, 115cm

Umbrela NuFish Nylon Economi NFU050, 115cm

5035305800401

Livrare 48-72 ore

180,00Lei

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.23mm, 2.72kg, 150m

Fir Monofilament NUFISH Feeder Detexion Sinking, 0.23mm, 2.72kg, 150m

5061001690251

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 48-72 ore

38,00Lei

1
2
>
>|

Afişare 1 - 20 din 30 (2 pagini)

Queries: 9, Total time: 2.111 ms [By time] [By id] [By file]

1 (0.103)

SELECT data
FROM `oc_session`
WHERE session_id = '9914bca92298e4f222f02deb3a'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.108)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.088)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (0.139)

SELECT *
FROM oc_url_alias
WHERE keyword = 'nufish.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

5 (0.131)

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 = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

6 (0.416)

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 = '0' AND p.manufacturer_id = '541'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661

7 (0.904)

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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '0' 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:438

8 (0.110)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.112)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38