Daiwa


Lanseta Spinning Daiwa Morethan Shad Attack Ultra Fast, 2.40m, 14-56g, 2seg

Lanseta Spinning Daiwa Morethan Shad Attack Ultra Fast, 2.40m, 14-56g, 2seg

d.11116.241
Livrare 24-48 ore

1.860,64Lei

Fir Textil DAIWA J-Braid Expedition X8 PE 0.13mm, 8.40kg, 150m, Orange

Fir Textil DAIWA J-Braid Expedition X8 PE 0.13mm, 8.40kg, 150m, Orange

d.12550.013
Livrare imediată!

82,11Lei

Plumb Daiwa N Zone Bomb Inline, 20g, 2buc/pac

Plumb Daiwa N Zone Bomb Inline, 20g, 2buc/pac

a.13361.020
Livrare 24-48 ore

26,40Lei

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Yummi, 4.1cm, 6.5g, 1buc/pac

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Yummi, 4.1cm, 6.5g, 1buc/pac

f3.d15263.406
Livrare 24-48 ore

46,34Lei

Fir Monofilament Daiwa J-Threads, Khaki Gold, 8.10kg, 0.33mm, 600m

Fir Monofilament Daiwa J-Threads, Khaki Gold, 8.10kg, 0.33mm, 600m

d.12225.033
Livrare 24-48 ore

58,15Lei

Bluza UV DAIWA 21st LS Shirt 3012E, Camo Green, Marime M

Bluza UV DAIWA 21st LS Shirt 3012E, Camo Green, Marime M

d.21st3012greenm
Livrare 24-48 ore

222,98Lei

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 747 HM HFSCF 2.24m, 10-35g, 2seg

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 747 HM HFSCF 2.24m, 10-35g, 2seg

d.mtbrexags742hmhfsc
Livrare 24-48 ore

3.849,82Lei

Mulineta DAIWA 25 RZ 2500 Spinning 3Rul, 0,16mm-250m, 5.1:1

Mulineta DAIWA 25 RZ 2500 Spinning 3Rul, 0,16mm-250m, 5.1:1

d.25rz2500
Livrare 24-48 ore

225,11Lei

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

d.11607.365r
Livrare imediată!

32,15Lei

TRICOU DAIWA POLO GREY CAMO MARIME XXL -49%

TRICOU DAIWA POLO GREY CAMO MARIME XXL

d.18293.750
Livrare 24-48 ore

312,59Lei(-49%) 159,93Lei

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

d.11605.001y
Livrare imediată!

40,16Lei

LINGURITA DAIWA ROTATIVA 6G SILVER METAL

LINGURITA DAIWA ROTATIVA 6G SILVER METAL

d.07411558
Livrare 24-48 ore

23,92Lei

LANSETA SPINNING DAIWA TOURNAMENT AGS JIGGER 2.40M 7-28G 2SEG

LANSETA SPINNING DAIWA TOURNAMENT AGS JIGGER 2.40M 7-28G 2SEG

d.11117.240
Livrare 24-48 ore

2.194,11Lei

Hanorac Daiwa Carp XL

Hanorac Daiwa Carp XL

d.18865.140
Livrare imediată!

266,64Lei

Geanta Daiwa Black Widow Carp Carryall 62x40x24cm

Geanta Daiwa Black Widow Carp Carryall 62x40x24cm

d.18705.045
Livrare 24-48 ore

233,74Lei

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.447,08Lei

Lanseta Spinning Daiwa Sweepfire Telescopica 2.10m, 5-20g, 6seg

Lanseta Spinning Daiwa Sweepfire Telescopica 2.10m, 5-20g, 6seg

d.11421.210
Livrare imediată!

160,78Lei

Hanorac Daiwa Carp 3XL

Hanorac Daiwa Carp 3XL

d.18865.160
Livrare 24-48 ore

266,64Lei

Mulineta Daiwa Emblem Surf 45 SCW QD 4500, 0.30mm/300m, 4.9:1, 6rul

Mulineta Daiwa Emblem Surf 45 SCW QD 4500, 0.30mm/300m, 4.9:1, 6rul

d.10711.450
Livrare imediată!

1.241,69Lei

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

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

d.10221.252
Livrare imediată!

328,54Lei(-8%) 301,67Lei

Afişare 341 - 360 din 1665 (84 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 97.616 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = '3aef9cbb84e684985134fb7fb9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.107)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.105)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (39.873)
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 = '2' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (57.204)
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 = '2' AND p.manufacturer_id = '11' 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:440
7 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37