Daiwa


Lanseta Feeder Daiwa N Zon Z Power Feeder 3.60m 150g

Lanseta Feeder Daiwa N Zon Z Power Feeder 3.60m 150g

d.11138.366
Livrare 24-48 ore

1.268,84Lei

Fir, Daiwa, Tournament, SF, Green, 0.16mm, 300m, 2.3kg, d.12200.316, Fire Monofilament Crap, Fire Monofilament Crap Daiwa, Daiwa
TAMBUR DAIWA MULINETA NINJA LT 6000

TAMBUR DAIWA MULINETA NINJA LT 6000

d.19219.600
Livrare imediată!

121,37Lei

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

d.18850.010
Livrare imediată!

190,55Lei

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G LIME CHART

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G LIME CHART

f3.d16711.203
Livrare 24-48 ore

73,34Lei

LINGURITA DAIWA ROTATIVA 4G SILVER METAL -20%

LINGURITA DAIWA ROTATIVA 4G SILVER METAL

d.07411555
Livrare 24-48 ore

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

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

BLUZA DAIWA D-VEC LS BLACK MARIME S

d.18206.210
Livrare 24-48 ore

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

MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 1seg -23%

MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 1seg

a2.m11990.180
Livrare imediată!

658,09Lei(-23%) 506,90Lei

Lanseta Spinning Daiwa 2seg Triforce Spin Trout, 2,10m, 5-20g

Lanseta Spinning Daiwa 2seg Triforce Spin Trout, 2,10m, 5-20g

d.11400.215
Livrare imediată!

195,41Lei

Geanta Daiwa Back Widow Compact BWCTB 52x30x24cm

Geanta Daiwa Back Widow Compact BWCTB 52x30x24cm

d.18705.055
Livrare imediată!

190,55Lei

Lanseta, Spinning, Daiwa, Tele, Sweepfire, 2.40m,, 10-30g,, 6seg, d.11421.241, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -23%

Lanseta, Spinning, Daiwa, Tele, Sweepfire, 2.40m,, 10-30g,, 6seg, d.11421.241, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11421.241
Livrare imediată!

201,49Lei(-23%) 155,90Lei

Cicada, Daiwa, DZA, 3.1cm,, 2.5g,, Silver, f.d15445.108, Cicade, Cicade Daiwa, Daiwa

Cicada, Daiwa, DZA, 3.1cm,, 2.5g,, Silver, f.d15445.108, Cicade, Cicade Daiwa, Daiwa

f.d15445.108
Livrare 24-48 ore

42,07Lei

Lanseta, Universala, Daiwa, Black, Widow, XT, Bait, 3.00m,, 50-125g,, 2seg, d.11554.302, Lansete Universale, Lansete Universale Daiwa, Daiwa -23%
Mulineta, Daiwa, Fuego, LT3000D-C,, 0.23mm/150m,, 6.2:1,, 6rul, d.10333.305, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Mulineta, Daiwa, Certate, FC, LT, 4000D-C, 0.37mm/150m,, 5.2:1,, 10rul, d.10424.400, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Lanseta Daiwa Hyper Spod 3500 3.90m, 5.0lbs, 2seg

Lanseta Daiwa Hyper Spod 3500 3.90m, 5.0lbs, 2seg

d.dhspd3500ax
Livrare imediată!

412,13Lei

Lanseta, Spinning, Daiwa, Preso, IPRIMI, 2.15m,, 0.5-6g,, 2seg, d.11719.215, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
MULINETA DAIWA LEXA E LT 2500 -26%

MULINETA DAIWA LEXA E LT 2500

d.10226.250
Livrare imediată!

1.073,31Lei(-26%) 792,61Lei

Momitor, Feeder, Daiwa, Feeder, N, Zon, XL, 50g, a.13324.050, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

Momitor, Feeder, Daiwa, Feeder, N, Zon, XL, 50g, a.13324.050, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

a.13324.050
Livrare imediată!

15,98Lei

Fir, Daiwa, Tournament, SF, Grey, 0.26mm, 300m, 5.7kg, d.12205.326, Fire Monofilament Crap, Fire Monofilament Crap Daiwa, Daiwa
Afişare 1 - 20 din 1475 (74 pagini)
Queries: 7, Total time: 94.247 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = 'c61e333b6aa11411c7677e90cc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.145)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.141)
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.288)
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 (56.320)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.103)
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