Daiwa


Mulineta Daiwa Fuego LT3000D-C, 0.23mm/150m, 6.2:1, 6rul

Mulineta Daiwa Fuego LT3000D-C, 0.23mm/150m, 6.2:1, 6rul

d.10333.305
Livrare 24-48 ore

602,98Lei

Mulineta, Daiwa, Certate, FC, LT, 4000D-C, 0.37mm/150m,, 5.2:1,, 10rul, d.10424.400, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Lanseta Daiwa Hyper Spod 3500 3.90m, 5.0lbs, 2seg

Lanseta Daiwa Hyper Spod 3500 3.90m, 5.0lbs, 2seg

d.dhspd3500ax
Livrare imediată!

412,13Lei

Lanseta Spinning Daiwa Preso IPRIMI 2.15m, 0.5-6g, 2seg

Lanseta Spinning Daiwa Preso IPRIMI 2.15m, 0.5-6g, 2seg

d.11719.215
Livrare 24-48 ore

450,28Lei

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 10-30G -12%

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 10-30G

d.11205.212
Livrare imediată!

205,75Lei(-12%) 180,32Lei

GEANTA DAIWA CHEST PACK NOIR PORTOCALIU -23%

GEANTA DAIWA CHEST PACK NOIR PORTOCALIU

d.dcp1
Livrare imediată!

354,47Lei(-23%) 272,90Lei

LANSETA DAIWA VERTICE CARP 3,90M 3,5LBS 2seg

LANSETA DAIWA VERTICE CARP 3,90M 3,5LBS 2seg

d.11598.395
Livrare imediată!

387,55Lei

TRICOU DAIWA CARP CAMO MAR.3XL

TRICOU DAIWA CARP CAMO MAR.3XL

d.18865.060
Livrare imediată!

117,98Lei

METHOD FEEDER DAIWA NZON METHOD 25G MAR. M -27%

METHOD FEEDER DAIWA NZON METHOD 25G MAR. M

a3.13345.125
Livrare imediată!

18,99Lei(-27%) 13,90Lei

Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

d.11990.396
Livrare 24-48 ore

4.886,89Lei

Mulineta Daiwa DF4000A

Mulineta Daiwa DF4000A

d.df4000a
Livrare 24-48 ore

119,79Lei

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg

d.11440.190
Livrare 24-48 ore

237,00Lei

Lanseta Spinning Daiwa Tele Sweepfire 3.00m, 40-90g, 6seg

Lanseta Spinning Daiwa Tele Sweepfire 3.00m, 40-90g, 6seg

d.11421.302
Livrare imediată!

273,35Lei

Cicada Daiwa DZA 3.1cm, 2.5g, Silver

Cicada Daiwa DZA 3.1cm, 2.5g, Silver

f.d15445.108
Livrare 24-48 ore

42,07Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 50-125g, 2seg -23%

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 50-125g, 2seg

d.11554.302
Livrare imediată!

280,04Lei(-23%) 215,90Lei

Mulineta DAIWA Tournament S 5000T ENTO, 0.35mm/360m, 4.1:1, 7rul

Mulineta DAIWA Tournament S 5000T ENTO, 0.35mm/360m, 4.1:1, 7rul

d.10124.055
Livrare imediată!

1.779,66Lei

Lanseta, Daiwa, Ninja, X, Feeder, 3.60m,, 120g,, 3+3seg, d.11608.360, Lansete Feeder, Lansete Feeder Daiwa, Lansete Daiwa, Feeder Daiwa, Daiwa
Lanseta Spinning Daiwa Triforce Target Spoon 1.95m, 1-8g, 2seg

Lanseta Spinning Daiwa Triforce Target Spoon 1.95m, 1-8g, 2seg

d.11400.190
Livrare 24-48 ore

168,66Lei

Lanseta, Daiwa, Tatula, 610MHFBAF, Baitcast, 2.08m,, 7-28g,, 1seg, d.tat6101mhfbbf, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Lanseta Daiwa N'Zon Distance Special Power Feeder 4.27m, 150g, 3+3seg

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

d.11172.420
Livrare 24-48 ore

1.384,23Lei

Afişare 1 - 20 din 1485 (75 pagini)
Queries: 9, Total time: 92.046 ms [By time] [By id] [By file]
1 (0.161)
SELECT data
FROM `oc_session`
WHERE session_id = 'e2594f07e2f8491f0ffcbe7fbc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.149)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/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 = '11' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (36.689)
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 = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (54.442)
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 = '0' 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:438
8 (0.138)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.122)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38