Nytro


Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.09mm, 0.8kg

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.09mm, 0.8kg

20600020
Livrare imediată!

25,09Lei

Tricou Nytro Negru, Marime L

Tricou Nytro Negru, Marime L

22500027
Livrare 48-72 ore

99,86Lei

Lanseta Nytro Starkx Big River H, 3.90m, 100g, 3+2seg

Lanseta Nytro Starkx Big River H, 3.90m, 100g, 3+2seg

20200061
Livrare imediată!

575,54Lei

Lanseta Nytro Impax Allrounder, 80g, 3.90m, 3+2seg

Lanseta Nytro Impax Allrounder, 80g, 3.90m, 3+2seg

20200075
Livrare 48-72 ore

353,82Lei

Mulineta Nytro Aryzon 4000, 6.2:1, 0.26mm/130m, 6+1rul

Mulineta Nytro Aryzon 4000, 6.2:1, 0.26mm/130m, 6+1rul

20100024
Livrare 48-72 ore

425,31Lei

Bac Nada / Geanta Accesorii Nytro Starkx EVA Patrata L 24x24cm

Bac Nada / Geanta Accesorii Nytro Starkx EVA Patrata L 24x24cm

22400003
Livrare imediată!

94,90Lei

Suport Lansete Nytro Steady Rod Sliding Front

Suport Lansete Nytro Steady Rod Sliding Front

21900008
Livrare imediată!

99,86Lei

Agrafa cu Vartej Dublu NYTRO Feeder Swivel + Hooked Snap, Nr.8, 8buc/pac

Agrafa cu Vartej Dublu NYTRO Feeder Swivel + Hooked Snap, Nr.8, 8buc/pac

22100009
Livrare 48-72 ore

15,34Lei

Costum Nytro 3/4 Jacket + Bib N Brace WP, Marime L

Costum Nytro 3/4 Jacket + Bib N Brace WP, Marime L

22510002
Livrare 48-72 ore

1.016,27Lei

Fir Monofilament Nytro Sublime Sinking Feeder Transparent, 0.18mm, 2.3kg, 150m

Fir Monofilament Nytro Sublime Sinking Feeder Transparent, 0.18mm, 2.3kg, 150m

20600011
Livrare imediată!

37,97Lei

Juvelnic Nytro Lake & Canal QuickDry Rectangular 40x45cm / 50x40cm, 4.00m

Juvelnic Nytro Lake & Canal QuickDry Rectangular 40x45cm / 50x40cm, 4.00m

20900008
Livrare imediată!

350,24Lei

Geanta Accesorii Nytro Sublime Accessory Carryall Large 42x42x24cm

Geanta Accesorii Nytro Sublime Accessory Carryall Large 42x42x24cm

22400028
Livrare 48-72 ore

357,83Lei

Mulineta Nytro Impax 4000

Mulineta Nytro Impax 4000

20100007
Livrare imediată!

258,96Lei

Maner Minciog Nytro Comercial NTR Landing Net Handle, 3.00m

Maner Minciog Nytro Comercial NTR Landing Net Handle, 3.00m

20500007
Livrare imediată!

174,97Lei

Pantaloni NYTRO Black Joggers, Marime L

Pantaloni NYTRO Black Joggers, Marime L

22500017
Livrare 48-72 ore

204,00Lei

Method Feeder NYTRO TCS Inline Flat Large, 40g, 1buc/pac

Method Feeder NYTRO TCS Inline Flat Large, 40g, 1buc/pac

22210010
Livrare imediată!

17,75Lei

Mulineta NYTRO Aryzon Bait-Up Cu Fir Textil Hy-Viz, 200m, 0.16mm, 5000 FD

Mulineta NYTRO Aryzon Bait-Up Cu Fir Textil Hy-Viz, 200m, 0.16mm, 5000 FD

20100061
Livrare imediată!

406,40Lei

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.19mm, 2.8kg

Fir Monofilament Nytro Sublime Power Rig Mono Transparent, 100m, 0.19mm, 2.8kg

20600025
Livrare imediată!

25,09Lei

Varf Feeder Nytro Aryzon Continental Feeder 2oz, 2.9mm, 63cm

Varf Feeder Nytro Aryzon Continental Feeder 2oz, 2.9mm, 63cm

20200046
Livrare 48-72 ore

109,83Lei

Varf Rezerva Nytro Starkx Big River Feeder si Nytro Starkx Method Feeder, 4oz

Varf Rezerva Nytro Starkx Big River Feeder si Nytro Starkx Method Feeder, 4oz

20200068
Livrare 48-72 ore

109,83Lei

Afişare 81 - 100 din 233 (12 pagini)
Queries: 7, Total time: 67.000 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = '745b6a8a71cefe75e6f9aac876'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'nytro.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.122)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '727' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (27.995)
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 = '727'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (38.367)
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 = '727' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.131)
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