Daiwa


Lanseta, Spinning, Daiwa, CrossFire, UL, 1.80m,, 2-7g,, 2seg, d.11437.180, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Varf, Daiwa, pentru, Ninja, X, Stalker, Feeder, 270,, Green,, 100g, d.11605.270g, Varfuri Feeder, Varfuri Feeder Daiwa, Daiwa
Lanseta Daiwa Super Spod 3.00m, 3.50lb, 2seg

Lanseta Daiwa Super Spod 3.00m, 3.50lb, 2seg

d.11915.305
Livrare 24-48 ore

494,45Lei

Mulineta, Daiwa, Exceler, LT2500,, 0.20mm/150m,, 5.3:1,, 5rul, d.10336.250, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa -17%
Mulineta, Daiwa, Revros, LT, 5000-C,, 0.37mm/150m,, 5.2:1,, 4rul, d.10221.502, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Lanseta, Daiwa, N'Zon, Distance, Special, X, Power, Feeder, 3.96m,, 180g,, 3+3seg, d.11173.390, Lansete Feeder, Lansete Feeder Daiwa, Lansete Daiwa, Feeder Daiwa, Daiwa -14%
Lanseta, Spinning, Daiwa, Prorex, XR, Spin, 2.40m,, 10-30g,, 2seg, d.11332.240, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
LANSETA CASTING DAIWA 2SEG TATULA BAITCAST 2.15M 8-35G

LANSETA CASTING DAIWA 2SEG TATULA BAITCAST 2.15M 8-35G

d.11460.210
Livrare 24-48 ore

817,71Lei

Cosulet, DAIWA, FEEDER, N, ZON, OPEN, END, M, 50G, a.13351.050, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa
HUSA DAIWA PROREX LANSETA CU MULINETA 128CM 2SEG

HUSA DAIWA PROREX LANSETA CU MULINETA 128CM 2SEG

d.15813.240
Livrare imediată!

146,66Lei

Mulineta Daiwa GS Bite N Run LT 3000 -10%

Mulineta Daiwa GS Bite N Run LT 3000

d.10144.300
Livrare 24-48 ore

629,89Lei(-10%) 566,90Lei

Tambur de rezerva Daiwa Ninja Match & Feeder LT 4000C

Tambur de rezerva Daiwa Ninja Match & Feeder LT 4000C

d.19217.400
Livrare 24-48 ore

203,22Lei

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

Fir Monofilament Daiwa N Zon S 0.23mm 3.9kg 300m -7%

Fir Monofilament Daiwa N Zon S 0.23mm 3.9kg 300m

d.12405.023
Livrare imediată!

43,10Lei(-7%) 40,00Lei

Lanseta, Daiwa, Black, Widow, XT, Bait, 3.60m,, 50-125g,, 3seg, d.11554.362, Lansete Universale, Lansete Universale Daiwa, Daiwa
Mulineta Daiwa Whisker 45scw QD OT 0.35mm/300m, 4.9:1, 7rul

Mulineta Daiwa Whisker 45scw QD OT 0.35mm/300m, 4.9:1, 7rul

d.10930.500
Livrare imediată!

1.390,44Lei

Lanseta Daiwa Procaster Float & Feeder 3.60m, 85g, 3+3seg

Lanseta Daiwa Procaster Float & Feeder 3.60m, 85g, 3+3seg

d.11644.361
Livrare imediată!

366,87Lei

Cicada Daiwa DZA 3.1cm, 2.5g, Latte Green Glow

Cicada Daiwa DZA 3.1cm, 2.5g, Latte Green Glow

f.d15445.121
Livrare 24-48 ore

42,55Lei

Lanseta, Daiwa, Ballistic, X, Spin, 2.10m,, 20-60g,, 2seg, d.11525.212, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Afişare 181 - 200 din 1485 (75 pagini)
Queries: 9, Total time: 90.040 ms [By time] [By id] [By file]
1 (0.223)
SELECT data
FROM `oc_session`
WHERE session_id = '2ad4196eccab053f9f2da907b0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.224)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.125)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (35.764)
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 = '2' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (53.227)
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 = '2' 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
8 (0.102)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.151)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38