Daiwa


Lanseta Daiwa Black Widow XT Bait 3.60m, 50-125g, 3seg

Lanseta Daiwa Black Widow XT Bait 3.60m, 50-125g, 3seg

d.11554.362
Livrare imediată!

314,21Lei

Mulineta Daiwa Whisker 45scw QD OT 0.35mm/300m, 4.9:1, 7rul

Mulineta Daiwa Whisker 45scw QD OT 0.35mm/300m, 4.9:1, 7rul

d.10930.500
Livrare imediată!

1.390,44Lei

Lanseta Daiwa Procaster Allround 3.60m, 40-110g, 3seg

Lanseta Daiwa Procaster Allround 3.60m, 40-110g, 3seg

d.11643.360
Livrare imediată!

307,65Lei

Cicada Daiwa DZA 3.1cm, 2.5g, Gold

Cicada Daiwa DZA 3.1cm, 2.5g, Gold

f.d15445.114
Livrare 24-48 ore

42,44Lei

Lanseta, Daiwa, Crosscast, Traditional, Stalker, Carp, 3.90m,, 3.50lbs,, 2seg, d.11912.395, Lansete Crap, Lansete Crap Daiwa, Lansete Daiwa, Crap Daiwa, Daiwa
Mulineta, Daiwa, Exceler, LT2000D,, 0.23mm/150m,, 5.2:1,, 5rul, d.10336.200, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa -17%
Mulineta Daiwa Revros LT 2500, 0.10mm/200m, 5.3:1, 4+1rul -28%

Mulineta Daiwa Revros LT 2500, 0.10mm/200m, 5.3:1, 4+1rul

d.10221.252
Livrare imediată!

435,08Lei(-28%) 311,24Lei

Lanseta Daiwa N'Zon Distance Special Power Feeder 3.96m, 150g, 3+3seg

Lanseta Daiwa N'Zon Distance Special Power Feeder 3.96m, 150g, 3+3seg

d.11172.390
Livrare imediată!

1.368,50Lei

Lanseta, Spinning, Daiwa, Preso, Trout, Spin, 2.10m,, 1-6g,, 2seg, d.11718.211, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
LANSETA, SPINNING, DAIWA, 2SEG, NINJA, SF, 2.15M, 15-50G, d.11207.215, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Lanseta, Spinning, Daiwa, Ninja, X, SF, , 2.15m,, 7-21g,, 2seg, d.11207.210, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Pelete Daiwa Advantage Method Box + Booster 500g/cutie Green Betain

Pelete Daiwa Advantage Method Box + Booster 500g/cutie Green Betain

a0.13300.200
Livrare imediată!

62,82Lei

DAIWA, FEEDER, N, ZON, OPEN, END, M, 40G, a.13351.040, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

DAIWA, FEEDER, N, ZON, OPEN, END, M, 40G, a.13351.040, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

a.13351.040
Livrare imediată!

15,18Lei

VARF, DAIWA, PENTRU, NINJA, X, FEEDER, GREEN, 220g, (11607.395), d.11607.395g, Varfuri Feeder, Varfuri Feeder Daiwa, Daiwa
Mulineta Daiwa GS Bite N Run LT 3000 -10%

Mulineta Daiwa GS Bite N Run LT 3000

d.10144.300
Livrare 24-48 ore

629,89Lei(-10%) 566,90Lei

TAMBUR DE REZERVA MULINETA DAIWA CALDIA LT 3000D-C

TAMBUR DE REZERVA MULINETA DAIWA CALDIA LT 3000D-C

d.19412.305
Livrare 24-48 ore

462,17Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 2.75LBS 2SEG

LANSETA DAIWA BLACK WIDOW CARP 3.60M 2.75LBS 2SEG

d.11584.361
Livrare 24-48 ore

282,23Lei

METHOD FEEDER DAIWA NZON METHOD 45G MAR. M

METHOD FEEDER DAIWA NZON METHOD 45G MAR. M

a3.13345.145
Livrare imediată!

22,00Lei

Lanseta Spinning Daiwa MF Travel Spin 2.25, 5-25, 4seg

Lanseta Spinning Daiwa MF Travel Spin 2.25, 5-25, 4seg

d.11253.225
Livrare imediată!

258,16Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 30-90g, 2seg

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 30-90g, 2seg

d.11554.301
Livrare 24-48 ore

253,78Lei

Afişare 1 - 20 din 1485 (75 pagini)
Queries: 9, Total time: 98.244 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = 'a31631cdacaa6a20f8326cf11c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.129)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.118)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '11' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (36.015)
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 = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (61.413)
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 = '11' 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:432
8 (0.119)
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