Daiwa


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

OCHELARI POLARIZANTI DAIWA PRO LENTILA NEGRU GRI

OCHELARI POLARIZANTI DAIWA PRO LENTILA NEGRU GRI

d.dpropsg1
Livrare 24-48 ore

138,53Lei

FIR TEXTIL DAIWA J-BRAID X4 0.13MM 5.9KG 135MT GALBEN

FIR TEXTIL DAIWA J-BRAID X4 0.13MM 5.9KG 135MT GALBEN

d.12740.013
Livrare imediată!

35,53Lei

VOBLER DAIWA PROREX HYBRID 18CM 50G GOLDEN SHINER

VOBLER DAIWA PROREX HYBRID 18CM 50G GOLDEN SHINER

f3.d15418.002
Livrare imediată!

84,39Lei

CUTIE MOMEALA DAIWA 1.5 L

CUTIE MOMEALA DAIWA 1.5 L

d.dwbb1.5
Livrare imediată!

36,06Lei

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 12.5CM/PEARL/5BUC/PL

SHAD DAIWA DUCKFIN 12.5CM/PEARL/5BUC/PL

d.16500.412
Livrare 24-48 ore

40,03Lei

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

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

d.12996.003
Livrare imediată!

95,69Lei

AGRAFA+VARTEJ DAIWA NR.12/8,0KG/10BUC/PL

AGRAFA+VARTEJ DAIWA NR.12/8,0KG/10BUC/PL

a7.14905.212
Livrare 24-48 ore

8,99Lei

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

VARTEJ RAPID DAIWA N ZON + VARTEJ NR.14

VARTEJ RAPID DAIWA N ZON + VARTEJ NR.14

a7.13316.014
Livrare imediată!

17,50Lei

Stoppere Daiwa N Zon Feeder Stops Marime L

Stoppere Daiwa N Zon Feeder Stops Marime L

a.13310.108
Livrare 24-48 ore

10,56Lei

MULINETA DAIWA LEGALIS LT 2500-XH 5RUL

MULINETA DAIWA LEGALIS LT 2500-XH 5RUL

d.10425.251
Livrare 24-48 ore

453,22Lei

Varga Telescopica Daiwa Legalis 6.00m 320g

Varga Telescopica Daiwa Legalis 6.00m 320g

d.11761.600
Livrare 24-48 ore

238,61Lei

Afişare 1201 - 1220 din 1664 (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: 220.956 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = 'ae071101be7bee561a15ed30be'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.136)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.134)
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 (99.684)
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 (120.480)
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 1200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.247)
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