Daiwa


Penar pentru Oscilante Daiwa Presso Black, 17x23x4cm

Penar pentru Oscilante Daiwa Presso Black, 17x23x4cm

d.15900.002
Livrare 24-48 ore

208,42Lei

Lanseta, Spinning, Daiwa, Crossfire, 210M, 2.10m,, 5-21g,, 2seg, d.cf210maf, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Mulineta Daiwa Caldia SW 4000D-CXH, 6.2:1, 0.37mm/150m, 6rul

Mulineta Daiwa Caldia SW 4000D-CXH, 6.2:1, 0.37mm/150m, 6rul

d.10320.405
Livrare 24-48 ore

1.479,09Lei

LANSETA DAIWA 2SEG NINJA X CARP 3.60M 3LBS -20%

LANSETA DAIWA 2SEG NINJA X CARP 3.60M 3LBS

d.11595.367
Livrare imediată!

367,12Lei(-20%) 293,69Lei

Lanseta Daiwa Ninja X Spin 2.40M 10-30g 2SEG -20%

Lanseta Daiwa Ninja X Spin 2.40M 10-30g 2SEG

d.11205.242
Livrare imediată!

227,89Lei(-20%) 182,31Lei

DAIWA MANER MINCIOG TOURNAMENT 4,0M

DAIWA MANER MINCIOG TOURNAMENT 4,0M

a2.tnlnp403.au
Livrare 24-48 ore

888,07Lei

BAC DAIWA N ZON EVA WATER BUCKET 16X16X20CM

BAC DAIWA N ZON EVA WATER BUCKET 16X16X20CM

d.13305.105
Livrare imediată!

83,54Lei

JUVELNIC DAIWA N ZON 2,50M -20%

JUVELNIC DAIWA N ZON 2,50M

a2.j13425.250
Livrare imediată!

374,80Lei(-20%) 299,90Lei

MATRITA DAIWA MOULD NZON METHOD MAR.L

MATRITA DAIWA MOULD NZON METHOD MAR.L

a.13345.200
Livrare imediată!

16,76Lei

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, Daiwa, Procaster, Allround, 3.00m,, 40-110g,, 3seg, d.11643.300, Lansete Universale, Lansete Universale Daiwa, Daiwa
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, d.11912.365, Lansete Crap, Lansete Crap Daiwa, Daiwa
Lanseta, Spinning, Daiwa, Ninja, X, SF,, 2.25m,, 5-18g,, 3buc, d.11207.225, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Mulineta Daiwa Exceler LT1000D, 0.20mm/150m, 5.2:1, 5rul -17%

Mulineta Daiwa Exceler LT1000D, 0.20mm/150m, 5.2:1, 5rul

d.10336.100
Livrare 24-48 ore

583,81Lei(-17%) 485,01Lei

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

Mulineta Daiwa Lexa 23 LT2500

d.10228.250
Livrare imediată!

1.097,67Lei

Lanseta Spinning Daiwa Preso Trout Spin 1.90m, 0.5-5g, 2seg

Lanseta Spinning Daiwa Preso Trout Spin 1.90m, 0.5-5g, 2seg

d.11718.190
Livrare 24-48 ore

639,68Lei

LANSETA DAIWA 3SEG 2VARFURI N ZON S FEEDER 3.90M, 120G

LANSETA DAIWA 3SEG 2VARFURI N ZON S FEEDER 3.90M, 120G

d.11136.390
Livrare imediată!

688,43Lei

Lanseta Daiwa Ninja X 2.40m 30-70g 2SEG -20%

Lanseta Daiwa Ninja X 2.40m 30-70g 2SEG

d.11205.246
Livrare imediată!

265,77Lei(-20%) 212,62Lei

Afişare 161 - 180 din 1480 (74 pagini)
Queries: 7, Total time: 124.289 ms [By time] [By id] [By file]
1 (0.142)
SELECT data
FROM `oc_session`
WHERE session_id = '1be6c2430e555796829de19f36'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.117)
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 (66.511)
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 (57.178)
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 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.112)
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