Daiwa


CAP MINCIOG DAIWA N ZON NANO MESH 55CM

CAP MINCIOG DAIWA N ZON NANO MESH 55CM

a2.m13415.055
Livrare imediată!

78,09Lei

Fir monofilament Daiwa Shorecast Red 0.35mm 10.1kg 840m

Fir monofilament Daiwa Shorecast Red 0.35mm 10.1kg 840m

d.shc35r
Livrare imediată!

82,61Lei

MINCIOG DAIWA PROREX 55X45CM

MINCIOG DAIWA PROREX 55X45CM

a2.m15809.745
Livrare 24-48 ore

342,21Lei

LANSETA DAIWA BLACK WIDOW FEEDER 2.70M 80G 3+2seg

LANSETA DAIWA BLACK WIDOW FEEDER 2.70M 80G 3+2seg

d.11789.275
Livrare 24-48 ore

260,00Lei

Fir Fluorocarbon Daiwa J, 0.45mm, 11.8kg, 50m

Fir Fluorocarbon Daiwa J, 0.45mm, 11.8kg, 50m

d.12220.045
Livrare imediată!

57,55Lei

Ochelari Polarizati Daiwa Clip L, Lentila Galbena

Ochelari Polarizati Daiwa Clip L, Lentila Galbena

d.df808y
Livrare 24-48 ore

56,17Lei

Mulineta Daiwa Freams LT 2000D 0.20mm/150m, 5.3:1, 5rul -8%

Mulineta Daiwa Freams LT 2000D 0.20mm/150m, 5.3:1, 5rul

d.10229.201
Livrare 24-48 ore

752,90Lei(-8%) 690,00Lei

Husa Lanseta cu Mulineta Daiwa Prorex, 2 Posturi, 145cm

Husa Lanseta cu Mulineta Daiwa Prorex, 2 Posturi, 145cm

d.15813.270
Livrare imediată!

147,54Lei

Lanseta Spinning Daiwa Tournament XT 2.35m, 14-42g, 2seg

Lanseta Spinning Daiwa Tournament XT 2.35m, 14-42g, 2seg

d.11128.236
Livrare imediată!

2.102,41Lei

Cutie pentru Momeala Daiwa D-Box SD Smoke, 21.7x16.4x9.0cm

Cutie pentru Momeala Daiwa D-Box SD Smoke, 21.7x16.4x9.0cm

d.14310.010
Livrare 24-48 ore

50,00Lei

SHAD DAIWA D.FIN 10CM CHARTREUSE AYU/7BUC

SHAD DAIWA D.FIN 10CM CHARTREUSE AYU/7BUC

d.16500.210
Livrare imediată!

31,90Lei

MULINETA DAIWA BG 4500 6RUL/320MX035MM/5,7:1 -8%

MULINETA DAIWA BG 4500 6RUL/320MX035MM/5,7:1

d.10460.450
Livrare 24-48 ore

903,71Lei(-8%) 828,02Lei

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.20MM 13KG 150M

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.20MM 13KG 150M

d.12751.020
Livrare 24-48 ore

66,42Lei

FIR DAIWA PROREX FC LEADER 0.36MM/9.3KG/50M

FIR DAIWA PROREX FC LEADER 0.36MM/9.3KG/50M

d.12995.036
Livrare 24-48 ore

29,02Lei

NALUCA DAIWA PROREX MICRO SPINNER 3.5G GREEN CHARTREUSE -16%

NALUCA DAIWA PROREX MICRO SPINNER 3.5G GREEN CHARTREUSE

f.d.15426.003
Livrare imediată!

36,82Lei(-16%) 30,96Lei

Agrafe Prindere Rapida Daiwa Tournament D-SNAP 10buc/plic Marimea M

Agrafe Prindere Rapida Daiwa Tournament D-SNAP 10buc/plic Marimea M

d.16512.001
Livrare imediată!

28,89Lei

Shad Daiwa D.Fin, Hot Tomato, 12.5cm, 5buc/plic

Shad Daiwa D.Fin, Hot Tomato, 12.5cm, 5buc/plic

d.16502.612
Livrare 24-48 ore

40,03Lei

Lanseta DAIWA Fuego Predator Spin Fast 2.40m, 10-40g, 2seg

Lanseta DAIWA Fuego Predator Spin Fast 2.40m, 10-40g, 2seg

d.11124.240
Livrare imediată!

310,59Lei

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC GHOST PERCH

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC GHOST PERCH

d.15604.802
Livrare 24-48 ore

39,76Lei

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.13mm 8.50kg

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.13mm 8.50kg

d.12796.013
Livrare imediată!

57,18Lei

Afişare 1181 - 1200 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: 120.230 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '78c37d8a4dc3fbce9733aa822b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.089)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.095)
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.426)
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 (61.278)
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 1180,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