Daiwa


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

OCHELARI DAIWA POLARIZATI INFINITY CAMO LENTILA GREY -28%

OCHELARI DAIWA POLARIZATI INFINITY CAMO LENTILA GREY

d.icpsg1
Livrare 24-48 ore

191,62Lei(-28%) 137,40Lei

Pluta DAIWA Carpa Balsa Culisanta, 7g

Pluta DAIWA Carpa Balsa Culisanta, 7g

a1.clbpw7g
Livrare 24-48 ore

33,32Lei

Opritoare DAIWA FEEDER N ZON STOPS SMALL

Opritoare DAIWA FEEDER N ZON STOPS SMALL

a.13310.114
Livrare 24-48 ore

10,16Lei

Umbrela DAIWA Power Level Pegger 250cm

Umbrela DAIWA Power Level Pegger 250cm

d.plpu
Livrare 24-48 ore

685,89Lei

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde 0.18mm 270m 15.8kg

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde 0.18mm 270m 15.8kg

d.12760.118
Livrare 24-48 ore

198,60Lei

Lanseta DAIWA Tele Legalis Univeral Allround, 30-90g, 2.70g, 6seg

Lanseta DAIWA Tele Legalis Univeral Allround, 30-90g, 2.70g, 6seg

d.11761.277
Livrare imediată!

228,90Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.18MM 2.30KG 50M

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.18MM 2.30KG 50M

d.12940.018
Livrare 24-48 ore

30,41Lei

Fir Textil Daiwa J-Braid Grand X8 Chartreuse 0.20mm 135m 16kg

Fir Textil Daiwa J-Braid Grand X8 Chartreuse 0.20mm 135m 16kg

d.12797.020
Livrare imediată!

57,18Lei

Sistem antitangle Daiwa N Zon 6cm 3buc/plic

Sistem antitangle Daiwa N Zon 6cm 3buc/plic

a.13307.006
Livrare 24-48 ore

29,02Lei

Sistem antitangle Daiwa N Zon PG Feeder 0.8mm 10cm 6kg 3buc

Sistem antitangle Daiwa N Zon PG Feeder 0.8mm 10cm 6kg 3buc

a.13306.110
Livrare 24-48 ore

19,60Lei

Lanseta Daiwa Legalis Spin 2.40m 15-50g 2SEG

Lanseta Daiwa Legalis Spin 2.40m 15-50g 2SEG

d.11768.243
Livrare 24-48 ore

278,37Lei

Hanorac Daiwa Carp 2XL

Hanorac Daiwa Carp 2XL

d.18865.150
Livrare imediată!

266,64Lei

Fir Fluorocarbon Daiwa J, 0.18mm, 2.3kg, 100m

Fir Fluorocarbon Daiwa J, 0.18mm, 2.3kg, 100m

d.12220.018
Livrare 24-48 ore

40,64Lei

Lanseta Spinning Daiwa 2seg Caldia Spin 2,10m/7-21g -20%

Lanseta Spinning Daiwa 2seg Caldia Spin 2,10m/7-21g

d.11425.210
Livrare imediată!

499,03Lei(-20%) 397,45Lei

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.10mm, 135m, 6.7kg

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.10mm, 135m, 6.7kg

d.12760.010
Livrare imediată!

153,69Lei

Carlig Offset Daiwa Steez Worm Nr.3, 7buc/pac

Carlig Offset Daiwa Steez Worm Nr.3, 7buc/pac

a.17703.300
Livrare imediată!

22,74Lei

Lanseta Daiwa Pro Staff, 2.10m, 3-10g, 2seg -22%

Lanseta Daiwa Pro Staff, 2.10m, 3-10g, 2seg

d.11325.210
Livrare imediată!

744,69Lei(-22%) 583,53Lei

Foarfeca Daiwa pentru Fir Textil 13cm

Foarfeca Daiwa pentru Fir Textil 13cm

d.jbsc
Livrare 24-48 ore

29,55Lei

SAPCA DAIWA D-VEC

SAPCA DAIWA D-VEC

d.dc6
Livrare 24-48 ore

84,05Lei

Afişare 1341 - 1360 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: 118.335 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '52ea4a9231909860aef0f0721d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.112)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.106)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (41.342)
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 = '0' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (76.460)
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 = '0' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1340,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37