Daiwa


LANSETA DAIWA 2 SEG BACK WIDOW CARP 3,60M/3LBS 50MM

LANSETA DAIWA 2 SEG BACK WIDOW CARP 3,60M/3LBS 50MM

d.11579.362
Livrare imediată!

240,23Lei

FIR DAIWA J-BRAID X8 CHARTREUSE 022MM/17.0KG/150M

FIR DAIWA J-BRAID X8 CHARTREUSE 022MM/17.0KG/150M

d.12750.022
Livrare imediată!

66,42Lei

FIR DAIWA PROREX FC LEADER 0.40MM/10.4KG/40M

FIR DAIWA PROREX FC LEADER 0.40MM/10.4KG/40M

d.12995.040
Livrare 24-48 ore

29,02Lei

NALUCA DAIWA PROREX MICRO SPINNER 5G PEARL AYU -16%

NALUCA DAIWA PROREX MICRO SPINNER 5G PEARL AYU

f.d.15426.011
Livrare 24-48 ore

37,33Lei(-16%) 31,36Lei

TRICOU DAIWA POLO NEGRU MARIMEA M -20%

TRICOU DAIWA POLO NEGRU MARIMEA M

d.18292.120
Livrare imediată!

95,17Lei(-20%) 76,15Lei

HUSA DAIWA NEOPREN PT. MULINETA 17X15CM

HUSA DAIWA NEOPREN PT. MULINETA 17X15CM

a8.15802.010
Livrare 24-48 ore

64,11Lei

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

Hanorac DAIWA Negru / Rosu, Marime XL

Hanorac DAIWA Negru / Rosu, Marime XL

d.dblkrdhood.xl
Livrare 24-48 ore

434,03Lei

STRUNA DAIWA PROREX 7X7 WIRE SPOOL 5M 18KG -16%

STRUNA DAIWA PROREX 7X7 WIRE SPOOL 5M 18KG

a7.17925.518
Livrare 24-48 ore

35,02Lei(-16%) 29,58Lei

DAIWA GEANTA UMAR TAILLE M BLACK GOLD 33X45X17CM

DAIWA GEANTA UMAR TAILLE M BLACK GOLD 33X45X17CM

d.mmbg
Livrare 24-48 ore

156,89Lei

Opritor DAIWA N Zon Quick Change 8buc/pac

Opritor DAIWA N Zon Quick Change 8buc/pac

a7.13318.001
Livrare imediată!

12,79Lei

Lanseta Daiwa Fuego Jiggerspin 2.40m 7-28g 2seg

Lanseta Daiwa Fuego Jiggerspin 2.40m 7-28g 2seg

d.11122.240
Livrare imediată!

383,07Lei

SHAD DAIWA TOURNAMENT D.FIN 10CM UV REAL MOTOR OIL 7BUC/PLIC

SHAD DAIWA TOURNAMENT D.FIN 10CM UV REAL MOTOR OIL 7BUC/PLIC

d.16502.710
Livrare imediată!

31,38Lei

CAP MINCIOG DAIWA N ZONE 50X40CM

CAP MINCIOG DAIWA N ZONE 50X40CM

a2.m13420.050
Livrare imediată!

73,01Lei

Burghiu Daiwa N Zon Boilies Orange

Burghiu Daiwa N Zon Boilies Orange

a.13319.001
Livrare imediată!

12,72Lei

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

Afişare 1421 - 1440 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: 120.265 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = '95e3b70cf5b7771e2eaf057bee'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.114)
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 (40.966)
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 (78.647)
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 1420,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.189)
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