Daiwa


Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

d.cf240haf
Livrare 24-48 ore

206,71Lei

Mulineta Daiwa 23 Ninja LT 2500, 5.3:1, 0.20mm/150m, 4rul -12%

Mulineta Daiwa 23 Ninja LT 2500, 5.3:1, 0.20mm/150m, 4rul

d.10005.250
Livrare imediată!

312,26Lei(-12%) 274,99Lei

MULINETA DAIWA EMBLEM SURF35 SCW QD -16%

MULINETA DAIWA EMBLEM SURF35 SCW QD

d.10158.650
Livrare imediată!

843,12Lei(-16%) 710,20Lei

LANSETA DAIWA NINJA X SPINNING SF 2.45M/8-35G 2SEG

LANSETA DAIWA NINJA X SPINNING SF 2.45M/8-35G 2SEG

d.11207.241
Livrare imediată!

297,19Lei

Cosulet, Daiwa, Feeder, N, Zon, Distance, Medium, 50g, a.13331.050, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa
Husa Daiwa Prorez Rod Bag 127x8cm

Husa Daiwa Prorez Rod Bag 127x8cm

d.15810.240
Livrare imediată!

98,25Lei

Momitor, Feeder, Daiwa, Feeder, N, Zon, M, 20g, a.13321.020, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

Momitor, Feeder, Daiwa, Feeder, N, Zon, M, 20g, a.13321.020, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

a.13321.020
Livrare imediată!

13,10Lei

DEGORJOR DAIWA NZON -30%

DEGORJOR DAIWA NZON

a.13319.000
Livrare imediată!

4,26Lei(-30%) 2,98Lei

BANDANA DAIWA BUFF RED/WHITE

BANDANA DAIWA BUFF RED/WHITE

d.dnsrw
Livrare 24-48 ore

69,92Lei

Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

d.11990.396
Livrare 24-48 ore

4.886,89Lei

Mulineta Daiwa DF2000A

Mulineta Daiwa DF2000A

d.df2000a
Livrare imediată!

102,14Lei

Lanseta, Spinning, Daiwa, Silver, Creek, UL, F, Spoon, 2.10m,, 1-6g,, 2seg, d.11440.210, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -23%
Mulineta Daiwa Crosscast 45SCW 5000C QD OT 0.35mm/300m, 4.9:1, 3rul -23%

Mulineta Daiwa Crosscast 45SCW 5000C QD OT 0.35mm/300m, 4.9:1, 3rul

d.10250.505
Livrare imediată!

908,72Lei(-23%) 699,90Lei

Lanseta Daiwa Procaster Allround 3.60m, 40-110g, 3seg

Lanseta Daiwa Procaster Allround 3.60m, 40-110g, 3seg

d.11643.360
Livrare imediată!

307,65Lei

Cicada Daiwa DZA 3.1cm, 2.5g, Gold

Cicada Daiwa DZA 3.1cm, 2.5g, Gold

f.d15445.114
Livrare 24-48 ore

42,44Lei

Lanseta Daiwa Crosscast Traditional Stalker Carp 3.90m, 3.50lbs, 2seg

Lanseta Daiwa Crosscast Traditional Stalker Carp 3.90m, 3.50lbs, 2seg

d.11912.395
Livrare 24-48 ore

786,96Lei

Mulineta Daiwa Exceler LT2000D, 0.23mm/150m, 5.2:1, 5rul -17%

Mulineta Daiwa Exceler LT2000D, 0.23mm/150m, 5.2:1, 5rul

d.10336.200
Livrare 24-48 ore

583,81Lei(-17%) 485,01Lei

Mulineta Daiwa Revros LT 2500, 0.10mm/200m, 5.3:1, 4+1rul -28%

Mulineta Daiwa Revros LT 2500, 0.10mm/200m, 5.3:1, 4+1rul

d.10221.252
Livrare imediată!

435,08Lei(-28%) 311,24Lei

Lanseta Daiwa N'Zon Distance Special Power Feeder 3.96m, 150g, 3+3seg

Lanseta Daiwa N'Zon Distance Special Power Feeder 3.96m, 150g, 3+3seg

d.11172.390
Livrare imediată!

1.368,50Lei

Lanseta Spinning Daiwa Preso Trout Spin 2.10m, 1-6g, 2seg

Lanseta Spinning Daiwa Preso Trout Spin 2.10m, 1-6g, 2seg

d.11718.211
Livrare 24-48 ore

627,95Lei

Afişare 121 - 140 din 1485 (75 pagini)
Queries: 9, Total time: 93.354 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '95d757fbf36ba91870c257784c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.074)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.137)
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
6 (36.797)
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:1661
7 (55.788)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.088)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.126)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38