Daiwa


Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

Lanseta Daiwa Infinity X45 Carp 3.90m 3.75lbs 2seg

d.11990.396
Livrare 24-48 ore

4.886,89Lei

Mulineta Daiwa DF4000A

Mulineta Daiwa DF4000A

d.df4000a
Livrare 24-48 ore

119,79Lei

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg

d.11440.190
Livrare 24-48 ore

237,00Lei

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

Cicada Daiwa DZA 3.1cm, 2.5g, Silver

Cicada Daiwa DZA 3.1cm, 2.5g, Silver

f.d15445.108
Livrare 24-48 ore

42,07Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 50-125g, 2seg -23%

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 50-125g, 2seg

d.11554.302
Livrare imediată!

280,04Lei(-23%) 215,90Lei

Mulineta Daiwa Fuego LT3000D-C, 0.23mm/150m, 6.2:1, 6rul

Mulineta Daiwa Fuego LT3000D-C, 0.23mm/150m, 6.2:1, 6rul

d.10333.305
Livrare 24-48 ore

602,98Lei

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

Lanseta Spinning Daiwa Preso IPRIMI 2.15m, 0.5-6g, 2seg

d.11719.215
Livrare 24-48 ore

450,28Lei

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 10-30G -12%

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 10-30G

d.11205.212
Livrare imediată!

205,75Lei(-12%) 180,32Lei

Lanseta Daiwa N Zon S Feeder 3.60m 120g

Lanseta Daiwa N Zon S Feeder 3.60m 120g

d.11136.360
Livrare 24-48 ore

654,79Lei

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

d.11606.001r
Livrare imediată!

29,33Lei

BLUZA, DAIWA, D-VEC, BLUE, MARIME, L, d.18299.330, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

BLUZA, DAIWA, D-VEC, BLUE, MARIME, L, d.18299.330, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

d.18299.330
Livrare 24-48 ore

240,26Lei

MULTIPLICATOR DAIWA TATULA SV TW 103HL 7RUL/90M/033/6,3:1

MULTIPLICATOR DAIWA TATULA SV TW 103HL 7RUL/90M/033/6,3:1

d.10714.100
Livrare 24-48 ore

1.345,16Lei

LINGURITA DAIWA ROTATIVA 6G GOLD RED BLACK

LINGURITA DAIWA ROTATIVA 6G GOLD RED BLACK

d.07410898
Livrare 24-48 ore

23,65Lei

BUFF DAIWA GREEN CAMO -20%

BUFF DAIWA GREEN CAMO

d.18206.102
Livrare 24-48 ore

37,08Lei(-20%) 29,67Lei

Husa lansete Daiwa IS 3 lansete 3.60m 200X25X12CM

Husa lansete Daiwa IS 3 lansete 3.60m 200X25X12CM

d.18851.012
Livrare 24-48 ore

376,58Lei

Maner Minciog Daiwa N Zon Tele Carbon 4.00m -23%

Maner Minciog Daiwa N Zon Tele Carbon 4.00m

a2.13420.400
Livrare imediată!

467,12Lei(-23%) 359,90Lei

Lanseta, Spinning, Daiwa, Sweepfire, Spin, 2.40m,, 15-50g,, 2seg, d.11446.241, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -23%

Lanseta, Spinning, Daiwa, Sweepfire, Spin, 2.40m,, 15-50g,, 2seg, d.11446.241, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11446.241
Livrare imediată!

203,31Lei(-23%) 156,90Lei

Afişare 201 - 220 din 1485 (75 pagini)
Queries: 9, Total time: 92.568 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '11fc5418f9fea102b1a51cfbb8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.124)
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
6 (35.844)
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:1650
7 (55.918)
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 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.126)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.126)
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