Daiwa


Maner Minciog Daiwa Telescopic Carbon, 3.60m

Maner Minciog Daiwa Telescopic Carbon, 3.60m

a2.11920.360
Livrare imediată!

409,75Lei

Fir Monofilament Daiwa Tournament ST 300m, 0.19mm, 5lb/2.27kg

Fir Monofilament Daiwa Tournament ST 300m, 0.19mm, 5lb/2.27kg

d.tst005.300
Livrare imediată!

25,79Lei

Shad Daiwa D.Fin Goby, 10.00cm, 7buc/pac

Shad Daiwa D.Fin Goby, 10.00cm, 7buc/pac

d.16504.310
Livrare 24-48 ore

31,38Lei

SHAD DAIWA DUCKFIN 10CM LIME/7BUC

SHAD DAIWA DUCKFIN 10CM LIME/7BUC

d.16501.210
Livrare imediată!

31,90Lei

Shad Daiwa Prorex Slim Shady, Color Mix 2, 10.5cm, 8.0g, 4buc/pac

Shad Daiwa Prorex Slim Shady, Color Mix 2, 10.5cm, 8.0g, 4buc/pac

d.15100.701
Livrare 24-48 ore

33,87Lei

MULINETA DAIWA BLACK WIDOW 5500A -8%

MULINETA DAIWA BLACK WIDOW 5500A

d.10155.550
Livrare imediată!

542,25Lei(-8%) 497,23Lei

FIR TEXTIL DAIWA J-BRAID X4 0.15MM 6.9KG 135MT GALBEN

FIR TEXTIL DAIWA J-BRAID X4 0.15MM 6.9KG 135MT GALBEN

d.12740.015
Livrare imediată!

35,53Lei

BORSETA DAIWA 35X12X19CM

BORSETA DAIWA 35X12X19CM

d.df1105
Livrare 24-48 ore

456,10Lei

CUTIE MOMEALA DAIWA 2 L

CUTIE MOMEALA DAIWA 2 L

d.dwbb2
Livrare 24-48 ore

33,66Lei

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 155cm

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 155cm

a8.15843.155
Livrare 24-48 ore

170,63Lei

SHAD DAIWA DUCKFIN 12CM/ORANGE SHINER/5BUC/PL

SHAD DAIWA DUCKFIN 12CM/ORANGE SHINER/5BUC/PL

d.16500.612
Livrare imediată!

40,03Lei

Fir Textil Daiwa Prorex UL Finesse Braid Chartreuse 135m 1.80kg -4%

Fir Textil Daiwa Prorex UL Finesse Braid Chartreuse 135m 1.80kg

d.12996.002
Livrare imediată!

96,65Lei(-4%) 92,50Lei

AGRAFA+VARTEJ DAIWA TYPE.2 NR.2/28,0KG/10BUC/PL

AGRAFA+VARTEJ DAIWA TYPE.2 NR.2/28,0KG/10BUC/PL

a7.14905.302
Livrare imediată!

12,92Lei

Fir Textil DAIWA Tournament Sinking Feeder Braid 8+1X, 0.14m, 135m

Fir Textil DAIWA Tournament Sinking Feeder Braid 8+1X, 0.14m, 135m

d.12785.014
Livrare 24-48 ore

133,54Lei

SAPCA DAIWA D VEC ALBA

SAPCA DAIWA D VEC ALBA

d.dc9
Livrare 24-48 ore

73,27Lei

MULINETA DAIWA EMCAST BR LT 3RUL 4000 0.28mm/150m -6%

MULINETA DAIWA EMCAST BR LT 3RUL 4000 0.28mm/150m

d.10148.400
Livrare imediată!

522,99Lei(-6%) 491,87Lei

VARF DAIWA PT N ZON CARBON/30-60G FLUORO ORANGE 1OZ

VARF DAIWA PT N ZON CARBON/30-60G FLUORO ORANGE 1OZ

d.11135.010
Livrare 24-48 ore

101,08Lei

Muste DAIWA Fly Pack Boobies, 10buc/pac

Muste DAIWA Fly Pack Boobies, 10buc/pac

f3.dfc10
Livrare 24-48 ore

71,54Lei

Shad Daiwa Tournament D Fin UV Crush Candy 7.5cm 10buc/plic

Shad Daiwa Tournament D Fin UV Crush Candy 7.5cm 10buc/plic

d.16502.108
Livrare 24-48 ore

30,60Lei

Lanseta DAIWA Ninja Tele Surf 150-AI, 4.30m, 150g, 6seg

Lanseta DAIWA Ninja Tele Surf 150-AI, 4.30m, 150g, 6seg

d.njtsrf150ai
Livrare 24-48 ore

735,27Lei

Afişare 1481 - 1500 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: 117.687 ms [By time] [By id] [By file]
1 (0.183)
SELECT data
FROM `oc_session`
WHERE session_id = '95e3b70cf5b7771e2eaf057bee'
/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.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
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 (58.667)
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 (58.298)
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 1480,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.156)
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