Daiwa


, 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

Lanseta, Daiwa, Ninja, X, Feeder, 3.60m,, 220g,, 3+3seg, d.11608.366, Lansete Feeder, Lansete Feeder Daiwa, Lansete Daiwa, Feeder Daiwa, Daiwa
Mulineta, Daiwa, Tatula, TW, 100HL, 0.33mm/100m,, 6.3:1,, 7rul, d.10714.110, Mulinete Casting, Mulinete Casting Daiwa, Mulinete Daiwa, Casting Daiwa, Daiwa
Lanseta, Spinning, Daiwa, Tatula, 701MFS, 2.13m,, 7-21g,, 1seg, d.tat701mfsbf, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Lanseta, Spinning, Daiwa, Ninja, X, Kids, Pink,, 1.60m,, 10-30g,, 2seg, d.11208.161, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Mulineta, DAIWA, 23, Revros, LT, 3000-C,, 0.13mm/200m,, 5.3:1,, 4rul, d.10221.302, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa -28%
BAC DAIWA EVA CU MANER PT.NADA 23X20CM

BAC DAIWA EVA CU MANER PT.NADA 23X20CM

a8.15809.120
Livrare 24-48 ore

81,59Lei

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

TRICOU DAIWA POLO GREY CAMO MARIME L -30%

TRICOU DAIWA POLO GREY CAMO MARIME L

d.18293.730
Livrare 24-48 ore

312,59Lei(-30%) 218,81Lei

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

d.11607.365y
Livrare imediată!

43,17Lei

Afişare 141 - 160 din 1475 (74 pagini)
Queries: 7, Total time: 100.840 ms [By time] [By id] [By file]
1 (0.169)
SELECT data
FROM `oc_session`
WHERE session_id = '686871fd1ded23dabb6b71d6e4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.107)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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 (37.887)
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:1667
6 (62.297)
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 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.158)
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