Daiwa


Lanseta, Spinning, Daiwa, Preso, Trout, Spin, 1.90m,, 0.5-5g,, 2seg, d.11718.190, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
MULINETA DAIWA N ZON PLUS LT 5000S-CP -26%

MULINETA DAIWA N ZON PLUS LT 5000S-CP

d.10311.500
Livrare imediată!

1.041,67Lei(-26%) 769,24Lei

Lanseta Daiwa N Zon S Feeder 3.90m 150g

Lanseta Daiwa N Zon S Feeder 3.90m 150g

d.11136.396
Livrare 24-48 ore

691,82Lei

Fir, Daiwa, Tournament, SF, Green, 0.30mm, 300m, 7.9kg, d.12200.330, Fire Monofilament Crap, Fire Monofilament Crap Daiwa, Daiwa
GEANTA DAIWA INFINITY PENTRU ACCESORII 25X20X10

GEANTA DAIWA INFINITY PENTRU ACCESORII 25X20X10

d.18850.050
Livrare imediată!

76,36Lei

JIG DAIWA PROREX COVER JIG TG 8G BLUE GILL -20%

JIG DAIWA PROREX COVER JIG TG 8G BLUE GILL

f2.15429.008
Livrare 24-48 ore

28,51Lei(-20%) 22,81Lei

LINGURITA DAIWA ROTATIVA 6G GOLD METAL

LINGURITA DAIWA ROTATIVA 6G GOLD METAL

d.07411557
Livrare 24-48 ore

23,65Lei

, LANSETA, DAIWA, VERTICE, CARP, 3,60M, 3,5LBS, 2seg, d.11598.365, Lansete Crap, Lansete Crap Daiwa, Daiwa -20%

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

d.11598.365
Livrare 24-48 ore

462,41Lei(-20%) 369,94Lei

BLUZA DAIWA D-VEC LS BLACK MARIME M -20%

BLUZA DAIWA D-VEC LS BLACK MARIME M

d.18206.220
Livrare 24-48 ore

200,79Lei(-20%) 160,63Lei

METHOD FEEDER DAIWA NZON METHOD 20G MAR. S

METHOD FEEDER DAIWA NZON METHOD 20G MAR. S

a3.13345.020
Livrare imediată!

18,20Lei

MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 2seg -20%

MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 2seg

a2.m11990.185
Livrare imediată!

676,85Lei(-20%) 544,56Lei

Lanseta, Spinning, Daiwa, Silver, Creek, UL, F, Spoon, 1.90m,, 0.5-5g,, 2seg, d.11440.190, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Lanseta Spinning Daiwa Tele Sweepfire 3.00m, 40-90g, 6seg

Lanseta Spinning Daiwa Tele Sweepfire 3.00m, 40-90g, 6seg

d.11421.302
Livrare imediată!

273,35Lei

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

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

d.11643.300
Livrare imediată!

259,37Lei

Cicada Daiwa DZA 3.1cm, 2.5g, Dark Green

Cicada Daiwa DZA 3.1cm, 2.5g, Dark Green

f.d15445.112
Livrare 24-48 ore

43,78Lei

Lanseta daiwa Crosscast Traditional Stalker Carp 3.60m, 3.50lbs, 2seg

Lanseta daiwa Crosscast Traditional Stalker Carp 3.60m, 3.50lbs, 2seg

d.11912.365
Livrare 24-48 ore

777,39Lei

Pantaloni Daiwa Joggers Camo, Marime L

Pantaloni Daiwa Joggers Camo, Marime L

d.18865.530
Livrare imediată!

262,48Lei

Mulineta Daiwa Lexa LT2500S, 0.16mm/150m, 5.3:1, 5rul

Mulineta Daiwa Lexa LT2500S, 0.16mm/150m, 5.3:1, 5rul

d.10228.251
Livrare imediată!

1.097,67Lei

Lanseta Daiwa Ninja X Feeder 3.60m, 150g, 3+3seg -20%

Lanseta Daiwa Ninja X Feeder 3.60m, 150g, 3+3seg

d.11608.365
Livrare imediată!

375,99Lei(-20%) 299,99Lei

Mulineta Daiwa Tatula TW 100HL 0.33mm/100m, 7.1:1, 7rul

Mulineta Daiwa Tatula TW 100HL 0.33mm/100m, 7.1:1, 7rul

d.10714.111
Livrare 24-48 ore

1.124,76Lei

Afişare 21 - 40 din 1475 (74 pagini)
Queries: 7, Total time: 107.139 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = 'c94a55ca1042df848db5d7b570'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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.112)
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 (69.378)
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 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.145)
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