Daiwa

Daiwa

Sortare după:

Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.33mm, 16lbs, 30m

Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.33mm, 16lbs, 30m

d.12956.533

Livrare 24-48 ore

89,62Lei

Mulineta Daiwa QC 750, 0.16mm/100m, 5.1:1, 1rul

Mulineta Daiwa QC 750, 0.16mm/100m, 5.1:1, 1rul

d.10431.175

Livrare imediată!

155,40Lei(-8%) 143,22Lei

Penar pentru Oscilante Daiwa Presso Black, 14x20x4cm

Penar pentru Oscilante Daiwa Presso Black, 14x20x4cm

d.15900.001

Livrare 24-48 ore

174,40Lei

Mulineta Daiwa Emblem Surf 45 SCW QD Type R 0.35mm/300m, 4.9:1, 6+1rul

Mulineta Daiwa Emblem Surf 45 SCW QD Type R 0.35mm/300m, 4.9:1, 6+1rul

d.10711.456

Livrare 24-48 ore

1.392,33Lei(-8%) 1.275,17Lei

Lanseta Daiwa Morethan Shad Attack Ultra Fast, 2.10m, 14-42g, 2seg

Lanseta Daiwa Morethan Shad Attack Ultra Fast, 2.10m, 14-42g, 2seg

d.11116.210

Livrare 24-48 ore

1.650,77Lei

Lanseta Spinning Daiwa Exceler Spin ST 2.10m, 2-10g, 2seg

Lanseta Spinning Daiwa Exceler Spin ST 2.10m, 2-10g, 2seg

d.11664.211

Livrare 24-48 ore

272,29Lei

Mulineta DAIWA 23 Revros LT 4000-C, 0.28mm/150m, 5.2:1, 4rul

Mulineta DAIWA 23 Revros LT 4000-C, 0.28mm/150m, 5.2:1, 4rul

d.10221.402

Livrare 24-48 ore

360,97Lei(-10%) 325,87Lei

Cosulet Daiwa Nzon Window Feeder S, 40g, 1buc/pac

Cosulet Daiwa Nzon Window Feeder S, 40g, 1buc/pac

a3.13355.040

Livrare 24-48 ore

17,50Lei

Lanseta DAIWA Black Widow XT Stalker Carp 3.60m, 365g / 3.5lbs, 2seg

Lanseta DAIWA Black Widow XT Stalker Carp 3.60m, 365g / 3.5lbs, 2seg

d.11583.365

Livrare imediată!

302,78Lei(-8%) 278,08Lei

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Special Chartreuse, 4.1cm, 6.5g, 1buc/pac

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Special Chartreuse, 4.1cm, 6.5g, 1buc/pac

f3.d15263.404

Livrare 24-48 ore

46,34Lei

Shad DAIWA Prorex Belly, Golden Shiner, 6cm, 2g, 4buc/pac

Shad DAIWA Prorex Belly, Golden Shiner, 6cm, 2g, 4buc/pac

d.15320.101

Livrare 24-48 ore

23,98Lei

Lanseta DAIWA Prorex S Spin, 5-21g, 2.40m, 2seg

Lanseta DAIWA Prorex S Spin, 5-21g, 2.40m, 2seg

d.11282.210

Livrare imediată!

326,77Lei

Fir Monofilament Daiwa J-Threads, Khaki Gold, 5.10kg, 0.26mm, 600m

Fir Monofilament Daiwa J-Threads, Khaki Gold, 5.10kg, 0.26mm, 600m

d.12225.026

Livrare 24-48 ore

51,22Lei

Rucsac DAIWA 30ltr, 35x55x20cm

Rucsac DAIWA 30ltr, 35x55x20cm

a8.15840.002

Livrare 24-48 ore

183,90Lei

Lanseta Daiwa Ninja X Jiggerspin 2.40M 8-35g 2SEG

Lanseta Daiwa Ninja X Jiggerspin 2.40M 8-35g 2SEG

d.11206.241

Livrare 24-48 ore

274,25Lei

Bluza UV DAIWA 21st LS Shirt 3012E, Camo White, Marime M

Bluza UV DAIWA 21st LS Shirt 3012E, Camo White, Marime M

d.21st3012whitem

Livrare 24-48 ore

202,80Lei

Lanseta Spinning DAIWA Prorex E Casting 702 HX HFB 2.13m, 14-56g, 2seg

Lanseta Spinning DAIWA Prorex E Casting 702 HX HFB 2.13m, 14-56g, 2seg

d.pxe702hxhfbbf

Livrare 24-48 ore

467,06Lei

Fir DAIWA Justron DPLS Pink, 500m, 0.235mm, 3.9kg/8.6lbs

Fir DAIWA Justron DPLS Pink, 500m, 0.235mm, 3.9kg/8.6lbs

d.07300453

Livrare 24-48 ore

53,72Lei

VARF DAIWA PENTRU NINJA X METHOD FEEDER RED 80g

VARF DAIWA PENTRU NINJA X METHOD FEEDER RED 80g

d.11603.000r

Livrare imediată!

29,15Lei

BLUZA DAIWA D-VEC BLUE MARIME XL

BLUZA DAIWA D-VEC BLUE MARIME XL

d.18299.340

Livrare 24-48 ore

300,33Lei(-39%) 184,23Lei

Afişare 661 - 680 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: 94.469 ms [By time] [By id] [By file]

1 (0.127)

SELECT data
FROM `oc_session`
WHERE session_id = '61e75d9cfab2a8b25647182b13'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.101)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.128)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.125)

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 (38.589)

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 (55.232)

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 660,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.167)

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