Nevis


Monofilament Nevis Navy Feeder 150m 0.22mm

Monofilament Nevis Navy Feeder 150m 0.22mm

3208-022
Livrare 48-72 ore

12,99Lei

Multifilament, Nevis, Secure, Braided, 100m, 0.45mm, 3225-045, Fire Somn, Fire Somn Nevis, Nevis

Multifilament, Nevis, Secure, Braided, 100m, 0.45mm, 3225-045, Fire Somn, Fire Somn Nevis, Nevis

3225-045
Livrare 48-72 ore

28,00Lei

Monofilament Nevis Raptor 1000m 0.25mm

Monofilament Nevis Raptor 1000m 0.25mm

3241-125
Livrare imediată!

64,00Lei

Fir Nevis Power Gumi 10m 1.00mm

Fir Nevis Power Gumi 10m 1.00mm

3301-100
Livrare imediată!

16,51Lei

Juvelnic Concurs Nevis Match Rotund 2.00m

Juvelnic Concurs Nevis Match Rotund 2.00m

4225-200
Livrare 48-72 ore

72,99Lei

Lampa, Camping, Nevis, 4810-001, Lampi Si Felinare, Lampi Si Felinare Nevis, Nevis -32%

Lampa, Camping, Nevis, 4810-001, Lampi Si Felinare, Lampi Si Felinare Nevis, Nevis

4810-001
Livrare imediată!

26,39Lei(-32%) 17,90Lei

Penseta Nevis 18cm Dreapta

Penseta Nevis 18cm Dreapta

8100-003
Livrare imediată!

26,91Lei

Momitor, Nevis, Method, Feeder, la, Distanta, L, 60gr, 8100-961, Momitoare Method Feeder, Momitoare Method Feeder Nevis, Nevis
Cantar Digital Nevis max 40kg

Cantar Digital Nevis max 40kg

8303-040
Livrare imediată!

37,00Lei

Shad Nevis Twister 11cm 9511-004

Shad Nevis Twister 11cm 9511-004

9511-004
Livrare 48-72 ore

9,90Lei

Fir, Multifilament, Nevis, Nitro, Spin, 100m, 0.07mm, 5.20kg, 3235-007, Fire Textile Rapitori, Fire Textile Rapitori Nevis, Nevis
Opritor, Nevis, Bila, Cauciuc, Pentru, Somn, XXL, Fluo, 12buc/plic, 6432-002, Opritoare Porumb Boilies, Opritoare Porumb Boilies Nevis, Nevis
Cutie Naluci Nevis 185x100x33mm

Cutie Naluci Nevis 185x100x33mm

4520-003
Livrare 48-72 ore

16,90Lei

Jig Nevis Nr.4/0, 5g, 4buc/pac

Jig Nevis Nr.4/0, 5g, 4buc/pac

4932-400-005
Livrare 48-72 ore

7,79Lei

Vartej Nevis X-Strong, Nr.16, 10buc/pac

Vartej Nevis X-Strong, Nr.16, 10buc/pac

5575-016
Livrare 48-72 ore

4,30Lei

Umbrela Cort Nevis 2.5m

Umbrela Cort Nevis 2.5m

7509-251
Livrare 48-72 ore

316,00Lei

Fir Monofilament Nevis Powercat Catfish Lead Line Mono, Clear, 1.00mm, 54kg, 50m

Fir Monofilament Nevis Powercat Catfish Lead Line Mono, Clear, 1.00mm, 54kg, 50m

3281-100
Livrare imediată!

20,69Lei

Coada, Minciog, Nevis, Magnum, Black, Telescopic, 2m, 1274-200, Cozi de Minciog, Cozi de Minciog Nevis, Cozi de Minciog, Cozi de Minciog Nevis, Nevis
Set Method Feeder Nevis Matrita Cu Cosulet Plus Conector 70 Gr

Set Method Feeder Nevis Matrita Cu Cosulet Plus Conector 70 Gr

8100-470
Livrare imediată!

29,20Lei

Lanseta Nevis Reflexx Spin 2.40m 10-30g

Lanseta Nevis Reflexx Spin 2.40m 10-30g

1431-242
Livrare 48-72 ore

313,01Lei

Afişare 341 - 360 din 930 (47 pagini)
Queries: 9, Total time: 74.511 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '751f68befb4e78e4bf0b57e622'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.069)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.126)
SELECT *
FROM oc_url_alias
WHERE keyword = 'nevis.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.125)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '423' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (31.288)
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 = '423'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (42.411)
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 = '3' AND p.manufacturer_id = '423' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 340,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.130)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.115)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38