Nufish

Nufish

Sortare după:

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

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

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

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

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

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

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

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

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

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

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

Tub PTFE Ghidaj Elastic STONFO 694 Curved

Tub PTFE Ghidaj Elastic STONFO 694 Curved

8028651018498

Livrare 48-72 ore

28,91Lei

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

Brat Suport Accesorii NUFISH NFX11

Brat Suport Accesorii NUFISH NFX11

nfx11

Livrare imediată!

85,00Lei

Surub Blocare Spatar NuFish Restabox

Surub Blocare Spatar NuFish Restabox

sp025

Livrare 48-72 ore

24,89Lei

1
2
>
>|

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

Queries: 7, Total time: 2.416 ms [By time] [By id] [By file]

1 (0.091)

SELECT data
FROM `oc_session`
WHERE session_id = '383e4bc120dfb100e3df554ad3'

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

2 (0.132)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.119)

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

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

4 (0.127)

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

5 (0.542)

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:1699

6 (1.205)

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 = '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:440

7 (0.200)

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

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