Daiwa


GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

d.18850.200
Livrare imediată!

410,72Lei

Mulineta, Daiwa, Emblem, 45SCW, QD, OT, , d.10158.646, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Mulinete Feeder, Mulinete Feeder Daiwa, Mulinete Daiwa, Feeder Daiwa, Daiwa -20%
LINGURITA DAIWA ROTATIVA 6G SILVER METAL

LINGURITA DAIWA ROTATIVA 6G SILVER METAL

d.07411558
Livrare 24-48 ore

23,65Lei

, LANSETA, DAIWA, VERTICE, CARP, 3,60M, 4,5LBS, 2seg, d.11598.367, Lansete Crap, Lansete Crap Daiwa, Daiwa -10%

, LANSETA, DAIWA, VERTICE, CARP, 3,60M, 4,5LBS, 2seg, d.11598.367, Lansete Crap, Lansete Crap Daiwa, Daiwa

d.11598.367
Livrare 24-48 ore

506,80Lei(-10%) 456,12Lei

TRICOU DAIWA CARP CAMO MAR.2XL

TRICOU DAIWA CARP CAMO MAR.2XL

d.18865.050
Livrare imediată!

117,98Lei

METHOD FEEDER DAIWA NZON METHOD 30G MAR. S

METHOD FEEDER DAIWA NZON METHOD 30G MAR. S

a3.13345.030
Livrare imediată!

19,64Lei

Fir Daiwa Tournament SF Green 0.20mm 300m 3.5kg

Fir Daiwa Tournament SF Green 0.20mm 300m 3.5kg

d.12200.320
Livrare imediată!

31,86Lei

Mulineta Daiwa DF4000A

Mulineta Daiwa DF4000A

d.df4000a
Livrare 24-48 ore

119,79Lei

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, d.10336.200, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa -17%
Mulineta, Daiwa, Revros, LT, 2500,, 0.10mm/200m,, 5.3:1,, 4+1rul, d.10221.252, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa -28%
Lanseta, Daiwa, N'Zon, Distance, Special, Power, Feeder, 3.96m,, 150g,, 3+3seg, d.11172.390, Lansete Feeder, Lansete Feeder Daiwa, Lansete Daiwa, Feeder Daiwa, Daiwa
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

MULINETA DAIWA CERTATE G LT 2500-XH -10%

MULINETA DAIWA CERTATE G LT 2500-XH

d.10407.826
Livrare 24-48 ore

2.821,43Lei(-10%) 2.539,29Lei

Momitor Feeder Daiwa Feeder N-Zone Tunel M 40g

Momitor Feeder Daiwa Feeder N-Zone Tunel M 40g

a.13335.040
Livrare imediată!

14,40Lei

VARF DAIWA PENTRU NINJA X FEEDER YELLOW 50-150g

VARF DAIWA PENTRU NINJA X FEEDER YELLOW 50-150g

d.11607.395y
Livrare imediată!

44,38Lei

Afişare 1 - 20 din 1475 (74 pagini)
Queries: 7, Total time: 90.979 ms [By time] [By id] [By file]
1 (0.073)
SELECT data
FROM `oc_session`
WHERE session_id = '465aff9f46c821ad89f002e5d7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.070)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.095)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
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 (36.121)
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:1667
6 (54.405)
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 = '2' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38