Nufish

Nufish

Sortare după:

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

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

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

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

Geanta Termoizolanta NuFish Tackle & Bait Bag, 60x40x37cm

nfl205

Livrare imediată!

406,71Lei

Tub PTFE Ghidaj Elastic STONFO 694 Curved

Tub PTFE Ghidaj Elastic STONFO 694 Curved

8028651018498

Livrare 48-72 ore

30,40Lei

Brat Suport Accesorii NUFISH Cross Arm

Brat Suport Accesorii NUFISH Cross Arm

nfx13

Livrare imediată!

99,63Lei

Retainer Picior Scaun NuFish Restabox

Retainer Picior Scaun NuFish Restabox

sp010

Livrare 48-72 ore

34,45Lei

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

1
2
>
>|

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

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

1 (0.128)

SELECT data
FROM `oc_session`
WHERE session_id = '9c3310308a3d49f71e647f0b80'

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

2 (0.109)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.112)

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

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

4 (0.120)

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.376)

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.761)

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.110)

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