Daiwa


Fir Monofilament Daiwa Infinity Carp, Camo Green, 6.9kg, 0.30mm, 1540m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 6.9kg, 0.30mm, 1540m

d.12767.130
Livrare 24-48 ore

119,40Lei

Fir Monofilament Daiwa Infinity Carp, Camo Green, 10.10kg, 0.37mm, 840m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 10.10kg, 0.37mm, 840m

d.12767.137
Livrare 24-48 ore

119,40Lei

Fir Monofilament Daiwa Infinity Carp, Camo Green, 9.2kg, 0.34mm, 500m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 9.2kg, 0.34mm, 500m

d.12767.034
Livrare 24-48 ore

82,07Lei

Fir Monofilament Daiwa Infinity Carp, Camo Green, 9.2kg, 0.34mm, 1200m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 9.2kg, 0.34mm, 1200m

d.12767.134
Livrare 24-48 ore

119,40Lei

Fir Monofilament Daiwa Infinity Carp, Camo Green, 6.9kg, 0.30mm, 500m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 6.9kg, 0.30mm, 500m

d.12767.030
Livrare 24-48 ore

67,12Lei

Fir Monofilament Daiwa Infinity Carp, Camo Green, 11.6kg, 0.41mm, 710m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 11.6kg, 0.41mm, 710m

d.12767.141
Livrare 24-48 ore

119,40Lei

Geanta Mulinete DAIWA D-Vec Reel Protection Case M, 36x26x14cm

Geanta Mulinete DAIWA D-Vec Reel Protection Case M, 36x26x14cm

a8.15844.002
Livrare imediată!

142,88Lei

Bluza UV DAIWA 21st LS Shirt 3012E, Camo White, Marime L

Bluza UV DAIWA 21st LS Shirt 3012E, Camo White, Marime L

d.21st3012whitel
Livrare 24-48 ore

192,68Lei

Cosulet DAIWA FEEDER N ZON OPEN END L 50G

Cosulet DAIWA FEEDER N ZON OPEN END L 50G

a.13352.050
Livrare imediată!

17,55Lei

Lanseta DAIWA Megaforce Catfish Spin 3.00m, 200-600g, 2seg

Lanseta DAIWA Megaforce Catfish Spin 3.00m, 200-600g, 2seg

d.11255.300
Livrare 24-48 ore

321,40Lei

Momitor Feeder Daiwa Feeder N-Zone Distance M 30g

Momitor Feeder Daiwa Feeder N-Zone Distance M 30g

a.13331.030
Livrare imediată!

14,27Lei

LINGURITA DAIWA ROTATIVA 3G SILVER GREEN

LINGURITA DAIWA ROTATIVA 3G SILVER GREEN

d.07410884
Livrare 24-48 ore

18,92Lei

JIG MUSTAD TRACESHOT BLACK FLASH 15G 8MM

JIG MUSTAD TRACESHOT BLACK FLASH 15G 8MM

f.m.jig07.blf.15
Livrare 24-48 ore

32,17Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS G40 2SEG -12%

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS G40 2SEG

d.11584.364
Livrare imediată!

271,42Lei(-12%) 239,90Lei

METHOD FEEDER DAIWA NZON METHOD 35G MAR. L

METHOD FEEDER DAIWA NZON METHOD 35G MAR. L

a3.13345.235
Livrare imediată!

21,21Lei

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ă!

343,64Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 50-125g, 3seg

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 50-125g, 3seg

d.11554.332
Livrare 24-48 ore

239,59Lei

Mulineta Daiwa Tournament Feeder 25QD 4.7:1, 0.28mm-150m, 7rul

Mulineta Daiwa Tournament Feeder 25QD 4.7:1, 0.28mm-150m, 7rul

d.10924.025
Livrare imediată!

2.309,65Lei

Mulineta Daiwa Emblem 35SCW QD 5500, 0.35mm/300m, 4.9:1, 6rul

Mulineta Daiwa Emblem 35SCW QD 5500, 0.35mm/300m, 4.9:1, 6rul

d.10158.635
Livrare imediată!

1.012,75Lei

Lanseta Daiwa Ninja X Feeder 3.90m, 220g, 3+3seg -11%

Lanseta Daiwa Ninja X Feeder 3.90m, 220g, 3+3seg

d.11608.396
Livrare imediată!

392,94Lei(-11%) 349,99Lei

Afişare 1 - 20 din 1592 (80 pagini)
Queries: 7, Total time: 97.953 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = '83c9fd0fa635b484302b0e3433'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.098)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
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 (40.549)
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:1699
6 (56.845)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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:440
7 (0.140)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37