Daiwa


VARF DAIWA PENTRU NINJA X METHOD FEEDER GREEN 80g

VARF DAIWA PENTRU NINJA X METHOD FEEDER GREEN 80g

d.11603.000g
Livrare imediată!

39,16Lei

HANORAC DAIWA D-VEC NEGRU MAR.M

HANORAC DAIWA D-VEC NEGRU MAR.M

d.18295.820
Livrare imediată!

259,87Lei

GEANTA DAIWA PT. ACCESORII L 38X25X15CM

GEANTA DAIWA PT. ACCESORII L 38X25X15CM

d.dabl
Livrare imediată!

401,71Lei

LANSETA DAIWA TOURNAMENT AGS ULTRAFAST 2.20M, 3.5-14G, 2SEG -23%

LANSETA DAIWA TOURNAMENT AGS ULTRAFAST 2.20M, 3.5-14G, 2SEG

d.11117.220
Livrare imediată!

2.137,01Lei(-23%) 1.643,90Lei

Lanseta Daiwa N Zon Super Slim Method Feeder 3.05m, 40g, 2+2seg

Lanseta Daiwa N Zon Super Slim Method Feeder 3.05m, 40g, 2+2seg

d.11160.300
Livrare 24-48 ore

373,68Lei

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

25,54Lei

Mulineta Daiwa Lexa LT2500S, 0.16mm/150m, 5.3:1, 5rul

Mulineta Daiwa Lexa LT2500S, 0.16mm/150m, 5.3:1, 5rul

d.10228.251
Livrare 24-48 ore

1.042,82Lei

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

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

d.11608.396
Livrare imediată!

435,33Lei(-17%) 359,99Lei

Lanseta Spinning Daiwa Tatula 732MHFS 2.21m, 7-28g, 2seg

Lanseta Spinning Daiwa Tatula 732MHFS 2.21m, 7-28g, 2seg

d.tat732mhfsbf
Livrare 24-48 ore

899,84Lei

Lanseta Daiwa Basia X45X Carp 3.90m, 3.75lbs, 2seg

Lanseta Daiwa Basia X45X Carp 3.90m, 3.75lbs, 2seg

d.11995.396
Livrare 24-48 ore

4.809,63Lei

Set Masurare Distanta Daiwa N'Zone Distance Sticks

Set Masurare Distanta Daiwa N'Zone Distance Sticks

a6.13420.800
Livrare imediată!

205,50Lei

Fir Monofilament Daiwa Mono, Dark Olive, 6.5kg, 0.28mm, 1540m

Fir Monofilament Daiwa Mono, Dark Olive, 6.5kg, 0.28mm, 1540m

d.12766.128
Livrare imediată!

99,47Lei

Mulineta DAIWA 24 Luvias LT 2000D, 5.1:1, 0.23mm/150m, 9rul

Mulineta DAIWA 24 Luvias LT 2000D, 5.1:1, 0.23mm/150m, 9rul

d.10214.200
Livrare 24-48 ore

2.333,53Lei

Geanta DAIWA D-Vec Shoulder, Grey, 39x23x18cm

Geanta DAIWA D-Vec Shoulder, Grey, 39x23x18cm

d.15840.001
Livrare 24-48 ore

76,12Lei

Shad DAIWA Prorex Belly, Flash Minnow, 11cm, 12g, 4buc/pac

Shad DAIWA Prorex Belly, Flash Minnow, 11cm, 12g, 4buc/pac

d.15320.303
Livrare 24-48 ore

27,91Lei

Vobler DAIWA Prorex Swift Crank Floating, Black Gold, 7cm, 12.9g, 1buc/pac

Vobler DAIWA Prorex Swift Crank Floating, Black Gold, 7cm, 12.9g, 1buc/pac

f3.d15264.707
Livrare 24-48 ore

52,03Lei

BUFF DAIWA ALBASTRU/ALB

BUFF DAIWA ALBASTRU/ALB

d.tdcbw
Livrare 24-48 ore

37,18Lei

Fir Inaintas DAIWA Double Tapered Mono, Olive Green, 7.25kg-16Lbs, 0.33mm, 320m

Fir Inaintas DAIWA Double Tapered Mono, Olive Green, 7.25kg-16Lbs, 0.33mm, 320m

d.12958.016
Livrare 24-48 ore

41,10Lei

Mulineta Daiwa 23 Ninja LT 3500CXH, 6.2:1, 0.23mm/150m, 4rul -10%

Mulineta Daiwa 23 Ninja LT 3500CXH, 6.2:1, 0.23mm/150m, 4rul

d.10005.351
Livrare 24-48 ore

366,38Lei(-10%) 329,74Lei

Rucsac Daiwa Black Gold 20x15x45cm

Rucsac Daiwa Black Gold 20x15x45cm

d.sebg
Livrare 24-48 ore

316,16Lei

Afişare 321 - 340 din 1640 (82 pagini)
Queries: 7, Total time: 98.481 ms [By time] [By id] [By file]
1 (0.073)
SELECT data
FROM `oc_session`
WHERE session_id = 'f91e13d61c288085ff403c5e81'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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 (40.351)
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:1699
6 (57.567)
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 = '3' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 320,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37