Daiwa


Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 240g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 240g, 3+2seg

d.11165.390
Livrare imediată!

610,66Lei

Cap Suport Spate pentru Lansete Daiwa U N Zon Universal

Cap Suport Spate pentru Lansete Daiwa U N Zon Universal

a6.13406.000
Livrare 24-48 ore

26,58Lei

Mulineta Daiwa MATCHMAN 2500, 0.28mm/150m, 5.3:1, 3rul

Mulineta Daiwa MATCHMAN 2500, 0.28mm/150m, 5.3:1, 3rul

d.10113.250
Livrare 24-48 ore

286,73Lei

Mulineta Daiwa LAGUNA LT 3000-C JB4, 0.23mm/150m, 5.3:1, 3rul -17%

Mulineta Daiwa LAGUNA LT 3000-C JB4, 0.23mm/150m, 5.3:1, 3rul

d.10502.300
Livrare imediată!

333,80Lei(-17%) 277,31Lei

Lansete Daiwa Megaforce BF 292XH 2.90m, 100-300g, 2seg

Lansete Daiwa Megaforce BF 292XH 2.90m, 100-300g, 2seg

d.mfbf292xhcf
Livrare 24-48 ore

412,48Lei

Cosulet Daiwa Feeder N Zon Square Medium 30g

Cosulet Daiwa Feeder N Zon Square Medium 30g

a.13340.030
Livrare 24-48 ore

13,63Lei

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.23mm 300m 4.5kg

Fir Daiwa Tournament SF Grey 0.23mm 300m 4.5kg

d.12205.323
Livrare imediată!

33,20Lei

Momitor, Feeder, Daiwa, Feeder, N, Zon, L, 30g, a.13323.030, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

Momitor, Feeder, Daiwa, Feeder, N, Zon, L, 30g, a.13323.030, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

a.13323.030
Livrare 24-48 ore

13,74Lei

Spin momeala Daiwa N Zon Pin Bayonet 7mm 20buc/plic

Spin momeala Daiwa N Zon Pin Bayonet 7mm 20buc/plic

a.13308.307
Livrare imediată!

15,71Lei

Mulineta Daiwa Iprimi 19LT 1000 SP -23%

Mulineta Daiwa Iprimi 19LT 1000 SP

d.ip19lt1000sp
Livrare imediată!

508,00Lei(-23%) 390,90Lei

Bandana Daiwa BUFF WHITE/BLACK

Bandana Daiwa BUFF WHITE/BLACK

d.dnswb
Livrare 24-48 ore

69,92Lei

Lanseta Spinning Daiwa Wilderness Spin 2.10m, 4-14g, 2seg -23%

Lanseta Spinning Daiwa Wilderness Spin 2.10m, 4-14g, 2seg

d.11872.210
Livrare imediată!

450,75Lei(-23%) 346,90Lei

Carlige Legate Daiwa Tournament Feeder Nr.4, 10buc/pac

Carlige Legate Daiwa Tournament Feeder Nr.4, 10buc/pac

a.14455.004
Livrare 24-48 ore

24,88Lei

Lanseta, Spinning, Daiwa, Sweepfire, Telescopica, 2.70m,, 40-90g,, 7seg, d.11421.272, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Varf Daiwa pentru Ninja X Stalker Feeder 240, Red, 100g

Varf Daiwa pentru Ninja X Stalker Feeder 240, Red, 100g

d.11605.240r
Livrare 24-48 ore

32,71Lei

Lanseta Daiwa N Zon Super Slim Power Feeder 3.05m, 50g, 2+2seg

Lanseta Daiwa N Zon Super Slim Power Feeder 3.05m, 50g, 2+2seg

d.11161.300
Livrare 24-48 ore

404,24Lei

Mulineta Daiwa 23 Ninja Match LT 3000C, 5.3:1, 0.23mm/150m, 9rul -17%

Mulineta Daiwa 23 Ninja Match LT 3000C, 5.3:1, 0.23mm/150m, 9rul

d.10217.305
Livrare 24-48 ore

439,32Lei(-17%) 364,98Lei

Mulineta Daiwa Legalis LT1000D(U), 0.20mm/150m, 5.2:1, 5rul

Mulineta Daiwa Legalis LT1000D(U), 0.20mm/150m, 5.2:1, 5rul

d.10435.100
Livrare imediată!

476,62Lei

Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

d.cf240haf
Livrare 24-48 ore

206,71Lei

Afişare 161 - 180 din 1480 (74 pagini)
Queries: 7, Total time: 106.008 ms [By time] [By id] [By file]
1 (0.482)
SELECT data
FROM `oc_session`
WHERE session_id = 'd62b08277683b1ca51a3c57687'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.330)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.317)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.355)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (49.510)
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 = '3' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
6 (54.890)
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 = '3' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.124)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38