Daiwa


Lanseta Spinning Daiwa Silver Creek UL Spin 2.35m, 3-14g, 2seg

Lanseta Spinning Daiwa Silver Creek UL Spin 2.35m, 3-14g, 2seg

d.11441.235
Livrare imediată!

376,84Lei

Lanseta, Spinning, Daiwa, SweepFire, 2.70m,, 30-70g,, 2seg, d.11446.272, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Bluza UV Daiwa D-Vec LS Navy, Marime XL

Bluza UV Daiwa D-Vec LS Navy, Marime XL

d.18299.440
Livrare 24-48 ore

369,11Lei

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

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

d.11164.390
Livrare imediată!

607,48Lei

Mulineta Daiwa LAGUNA LT 2500 JB4, 0.20mm/150m, 5.3:1, 3rul -17%

Mulineta Daiwa LAGUNA LT 2500 JB4, 0.20mm/150m, 5.3:1, 3rul

d.10502.250
Livrare imediată!

328,08Lei(-17%) 272,55Lei

Lanseta, Spinning, Daiwa, Ninja, X, Kids, Blue,, 160m,, 10-30g, d.11208.160, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Lansete, Daiwa, Megaforce, BF, 272XH, 2.70m,, 100-300g,, 2seg, d.mfbf272xhcf, Lansete Somn, Lansete Somn Daiwa, Lansete Daiwa, Somn Daiwa, Daiwa
Cosulet Daiwa Feeder N Zon Square Medium 20g

Cosulet Daiwa Feeder N Zon Square Medium 20g

a.13340.020
Livrare 24-48 ore

12,44Lei

Momitor Feeder Daiwa Feeder N Zon XL 40g

Momitor Feeder Daiwa Feeder N Zon XL 40g

a.13324.040
Livrare imediată!

15,18Lei

Fir Daiwa Tournament SF Grey 0.20mm 300m 3.5kg

Fir Daiwa Tournament SF Grey 0.20mm 300m 3.5kg

d.12205.320
Livrare imediată!

31,86Lei

NADA DAIWA METHOD SWEET FISHMEAL 1KG

NADA DAIWA METHOD SWEET FISHMEAL 1KG

a0.13300.009
Livrare imediată!

33,19Lei

VARF DAIWA PENTRU NINJA X FEEDER RED

VARF DAIWA PENTRU NINJA X FEEDER RED

d.11605.001r
Livrare imediată!

29,33Lei

Suport feeder Daiwa N Zon EVA Feeder 50cm

Suport feeder Daiwa N Zon EVA Feeder 50cm

a6.13309.305
Livrare imediată!

98,87Lei

FIR, MONOFILAMENT, DAIWA, TOURNAMENT, SF, GREEN, 300M, 0.33mm, 9kg, d.12200.333, Fire Monofilament Crap, Fire Monofilament Crap Daiwa, Daiwa
LANSETA DAIWA CROSSCAST XT CARP 3.90M 3.5LBS 2SEG

LANSETA DAIWA CROSSCAST XT CARP 3.90M 3.5LBS 2SEG

d.11562.395
Livrare 24-48 ore

727,16Lei

LANSETA DAIWA BLACK WIDOW CARP 3.90M 3,5LBS 2seg -11%

LANSETA DAIWA BLACK WIDOW CARP 3.90M 3,5LBS 2seg

d.11584.395
Livrare imediată!

270,13Lei(-11%) 239,99Lei

Lanseta Spinning Daiwa Prorex X Light Spin 2.05m, 3-10g, 2seg -35%

Lanseta Spinning Daiwa Prorex X Light Spin 2.05m, 3-10g, 2seg

d.11285.205
Livrare imediată!

376,58Lei(-35%) 243,90Lei

Lanseta, Spinning, Daiwa, Sweepfire, Telescopica, 2.40m,, 15-50g,, 6seg, d.11421.242, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Varf Daiwa pentru Ninja X Stalker Feeder 240, Green, 120g

Varf Daiwa pentru Ninja X Stalker Feeder 240, Green, 120g

d.11605.240g
Livrare 24-48 ore

32,71Lei

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

d.11160.330
Livrare imediată!

415,91Lei

Afişare 1 - 20 din 1480 (74 pagini)
Queries: 7, Total time: 92.147 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '4326200ea9d9f9d93fddc02546'
/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.147)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.127)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (36.458)
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 = '2' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (55.128)
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 = '2' 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.083)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38