Daiwa


Varf Daiwa pentru Ninja X Stalker Feeder 240, Red, 100g

Varf Daiwa pentru Ninja X Stalker Feeder 240, Red, 100g

d.11605.240r
Livrare 24-48 ore

32,71Lei

Lanseta, Daiwa, N, Zon, Super, Slim, Power, Feeder, 3.05m,, 50g,, 2+2seg, d.11161.300, Lansete Feeder, Lansete Feeder Daiwa, Daiwa
Mulineta Daiwa 23 Ninja Match LT 3000C, 5.3:1, 0.23mm/150m, 9rul -17%

Mulineta Daiwa 23 Ninja Match LT 3000C, 5.3:1, 0.23mm/150m, 9rul

d.10217.305
Livrare 24-48 ore

439,32Lei(-17%) 364,98Lei

Mulineta Daiwa Legalis LT1000D(U), 0.20mm/150m, 5.2:1, 5rul

Mulineta Daiwa Legalis LT1000D(U), 0.20mm/150m, 5.2:1, 5rul

d.10435.100
Livrare imediată!

476,62Lei

Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

d.cf240haf
Livrare 24-48 ore

206,71Lei

Mulineta, Daiwa, 23, Ninja, LT, 2500,, 5.3:1,, 0.20mm/150m,, 4rul, d.10005.250, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa -12%
LANSETA SPINNING DAIWA 2SEG CALDIA LURE SPIN 2.10M 10-40G

LANSETA SPINNING DAIWA 2SEG CALDIA LURE SPIN 2.10M 10-40G

d.11480.211
Livrare imediată!

426,34Lei

MULTIPLICATOR DAIWA TATULA 100HL 8RUL/135MX032/6,3:

MULTIPLICATOR DAIWA TATULA 100HL 8RUL/135MX032/6,3:

d.tate19100hl
Livrare 24-48 ore

1.401,59Lei

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

d.18850.200
Livrare imediată!

410,72Lei

Mulineta, Daiwa, Emblem, 45SCW, QD, OT, , d.10158.646, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Mulinete Feeder, Mulinete Feeder Daiwa, Mulinete Daiwa, Feeder Daiwa, Daiwa -20%
LINGURITA DAIWA ROTATIVA 6G SILVER METAL

LINGURITA DAIWA ROTATIVA 6G SILVER METAL

d.07411558
Livrare 24-48 ore

23,65Lei

LANSETA DAIWA VERTICE CARP 3,60M 4,5LBS 2seg -10%

LANSETA DAIWA VERTICE CARP 3,60M 4,5LBS 2seg

d.11598.367
Livrare 24-48 ore

506,80Lei(-10%) 456,12Lei

TRICOU DAIWA CARP CAMO MAR.2XL

TRICOU DAIWA CARP CAMO MAR.2XL

d.18865.050
Livrare imediată!

117,98Lei

METHOD, FEEDER, DAIWA, , NZON, METHOD, 30G, MAR., S, , a3.13345.030, Momitoare Method Feeder, Momitoare Method Feeder Daiwa, Daiwa
Fir Daiwa Tournament SF Green 0.20mm 300m 3.5kg

Fir Daiwa Tournament SF Green 0.20mm 300m 3.5kg

d.12200.320
Livrare imediată!

31,86Lei

Mulineta Daiwa DF4000A

Mulineta Daiwa DF4000A

d.df4000a
Livrare 24-48 ore

119,79Lei

Lanseta Spinning Daiwa Silver Creek UL F Spoon 2.10m, 1-6g, 2seg -23%

Lanseta Spinning Daiwa Silver Creek UL F Spoon 2.10m, 1-6g, 2seg

d.11440.210
Livrare imediată!

334,03Lei(-23%) 256,99Lei

Mulineta Daiwa Crosscast 45SCW 5000C QD OT 0.35mm/300m, 4.9:1, 3rul -23%

Mulineta Daiwa Crosscast 45SCW 5000C QD OT 0.35mm/300m, 4.9:1, 3rul

d.10250.505
Livrare imediată!

908,72Lei(-23%) 699,90Lei

Lanseta Daiwa Procaster Allround 3.60m, 40-110g, 3seg

Lanseta Daiwa Procaster Allround 3.60m, 40-110g, 3seg

d.11643.360
Livrare imediată!

307,65Lei

Cicada Daiwa DZA 3.1cm, 2.5g, Gold

Cicada Daiwa DZA 3.1cm, 2.5g, Gold

f.d15445.114
Livrare 24-48 ore

42,44Lei

Afişare 181 - 200 din 1475 (74 pagini)
Queries: 7, Total time: 118.633 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '85d0ab7fa669f0d878179d942f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.089)
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 (52.310)
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 (65.811)
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 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.118)
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