Daiwa


GEANTA DAIWA PROREX TACKLE BAG M 38X18X24CM

GEANTA DAIWA PROREX TACKLE BAG M 38X18X24CM

d.15810.600
Livrare imediată!

229,09Lei

Cosulet Daiwa Feeder N Zon X Large 60g

Cosulet Daiwa Feeder N Zon X Large 60g

a.13324.060
Livrare imediată!

17,55Lei

Borseta Daiwa pentru Accesorii

Borseta Daiwa pentru Accesorii

d.dwp.1
Livrare 24-48 ore

374,20Lei

BANDANA DAIWA BUFF RED/WHITE

BANDANA DAIWA BUFF RED/WHITE

d.dnsrw
Livrare 24-48 ore

69,92Lei

TAMBUR DAIWA UNIVERSAL MULINETA LT 1000D

TAMBUR DAIWA UNIVERSAL MULINETA LT 1000D

d.19115.100
Livrare 24-48 ore

93,05Lei

Tricou Daiwa Angler Negru Alb, Marime XL

Tricou Daiwa Angler Negru Alb, Marime XL

d.dvatbw.xl
Livrare 24-48 ore

199,16Lei

Lanseta Spinning Daiwa Silver Creek UL Spin 2.20m, 3-14g, 2seg

Lanseta Spinning Daiwa Silver Creek UL Spin 2.20m, 3-14g, 2seg

d.11441.220
Livrare imediată!

355,44Lei

Carlige Legate Daiwa Tournament Feeder Nr.10, 10buc/pac

Carlige Legate Daiwa Tournament Feeder Nr.10, 10buc/pac

a.14455.010
Livrare imediată!

23,44Lei

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

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

d.11440.170
Livrare imediată!

226,30Lei

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

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

d.11605.270r
Livrare 24-48 ore

31,56Lei

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg

d.11161.360
Livrare imediată!

562,14Lei

Mulineta Daiwa 23 Ninja Match LT 6000SS, 5.1:1, 0.28mm/150m, 9rul -17%

Mulineta Daiwa 23 Ninja Match LT 6000SS, 5.1:1, 0.28mm/150m, 9rul

d.10217.605
Livrare imediată!

553,67Lei(-17%) 459,97Lei

Mulineta Daiwa Legalis LT2500D(U), 0.28mm/150m, 5.3:1, 5rul

Mulineta Daiwa Legalis LT2500D(U), 0.28mm/150m, 5.3:1, 5rul

d.10435.250
Livrare 24-48 ore

494,89Lei

Mulineta, Daiwa, Emblem, Surf, 35, SCW, QD, Type, R, 0.18mm/300m,, 4.9:1,, 6+1rul, d.ems2335scwqdr, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Daiwa
Lanseta Spinning Daiwa Morethan Shad Attack Ultra Fast, 2.40m, 7-32g, 2seg

Lanseta Spinning Daiwa Morethan Shad Attack Ultra Fast, 2.40m, 7-32g, 2seg

d.11116.240
Livrare 24-48 ore

1.913,57Lei

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.40M 15-50G -12%

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.40M 15-50G

d.11205.245
Livrare imediată!

238,25Lei(-12%) 208,79Lei

Cosulet DAIWA FEEDER N ZON OPEN END M 30G

Cosulet DAIWA FEEDER N ZON OPEN END M 30G

a.13351.030
Livrare imediată!

14,40Lei

GEANTA DAIWA CHEST PACK NOIR PORTOCALIU -23%

GEANTA DAIWA CHEST PACK NOIR PORTOCALIU

d.dcp1
Livrare imediată!

354,47Lei(-23%) 272,90Lei

MATRITA DAIWA MOULD NZON METHOD MAR.S

MATRITA DAIWA MOULD NZON METHOD MAR.S

a.13345.000
Livrare imediată!

12,70Lei

METHOD, FEEDER, DAIWA, , NZON, METHOD, 35G, MAR., M, , a3.13345.135, Momitoare Method Feeder, Momitoare Method Feeder Daiwa, Daiwa -27%

METHOD, FEEDER, DAIWA, , NZON, METHOD, 35G, MAR., M, , a3.13345.135, Momitoare Method Feeder, Momitoare Method Feeder Daiwa, Daiwa

a3.13345.135
Livrare imediată!

20,43Lei(-27%) 14,90Lei

Afişare 1 - 20 din 1480 (74 pagini)
Queries: 7, Total time: 106.206 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '203da6b4d4d2ba46cc40e46e1d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.148)
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 (36.364)
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:1661
6 (69.241)
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 = '3' 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:438
7 (0.122)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38