Daiwa


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

Lanseta Spinning Daiwa Ninja X SF, 2.25m, 5-18g, 3buc

Lanseta Spinning Daiwa Ninja X SF, 2.25m, 5-18g, 3buc

d.11207.225
Livrare imediată!

206,85Lei

Mulineta, Daiwa, Exceler, LT1000D,, 0.20mm/150m,, 5.2:1,, 5rul, d.10336.100, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa -17%
Lanseta, Spinning, Daiwa, Wilderness, ST, 2.00m,, 5-12g,, 2seg, d.11873.205, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Mulineta, Daiwa, Lexa, 23, LT2500, d.10228.250, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, 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
Lanseta Daiwa Ninja X Jiggerspin 2.70M 8-35g 2SEG

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

d.11206.271
Livrare imediată!

286,97Lei

Cosulet Daiwa Feeder N Zon Square Medium 50g

Cosulet Daiwa Feeder N Zon Square Medium 50g

a.13340.050
Livrare imediată!

15,07Lei

Degetar Daiwa Wrist Strap Finger Guard

Degetar Daiwa Wrist Strap Finger Guard

d.dl402361
Livrare imediată!

63,22Lei

Momitor, Feeder, Daiwa, Feeder, N-Zone, Distance, M, 30g, a.13331.030, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa
VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

d.11607.365r
Livrare imediată!

27,48Lei

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

d.11605.001y
Livrare imediată!

40,86Lei

LINGURITA DAIWA ROTATIVA 4G GOLD RED BLACK -20%

LINGURITA DAIWA ROTATIVA 4G GOLD RED BLACK

d.07410889
Livrare 24-48 ore

23,65Lei(-20%) 18,92Lei

JIG MUSTAD MOONRISER GREEN MACKEREL 120G 20MM

JIG MUSTAD MOONRISER GREEN MACKEREL 120G 20MM

f.m.jig03.gmk.120
Livrare 24-48 ore

45,96Lei

Afişare 81 - 100 din 1475 (74 pagini)
Queries: 7, Total time: 141.132 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = '4ef092210e32caad6acc0135b2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.111)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.114)
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 (71.368)
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.219)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.153)
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