Daiwa


Mulineta Daiwa Fuego LT 1000D, 0.20mm/150m, 5.2:1, 6rul

Mulineta Daiwa Fuego LT 1000D, 0.20mm/150m, 5.2:1, 6rul

d.10333.100
Livrare 24-48 ore

589,00Lei

Mulineta, Daiwa, Certate, FC, LT, 2500D, 0.28mm/150m,, 5.2:1,, 10rul, d.10424.251, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Lanseta, Daiwa, Crosscast, Carp, Z, 0312, 3.05m,, 3.5lbs,, 2seg, d.cccz0312ax, Lansete Crap, Lansete Crap Daiwa, Lansete Daiwa, Crap Daiwa, Daiwa
Jig Daiwa Micro Bladed, Muddy Orange, Nr.1/0, 8g

Jig Daiwa Micro Bladed, Muddy Orange, Nr.1/0, 8g

f.d15151.408
Livrare 24-48 ore

49,61Lei

Mulineta, DAIWA, 23, Revros, LT, 1000,, 0.14mm/150m,, 5.2:1,, 4rul, d.10221.102, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
MULINETA DAIWA LEXA E LT 2500 -26%

MULINETA DAIWA LEXA E LT 2500

d.10226.250
Livrare imediată!

1.073,31Lei(-26%) 792,61Lei

Lanseta Feeder Daiwa N Zon S Feeder 3.60m 150g

Lanseta Feeder Daiwa N Zon S Feeder 3.60m 150g

d.11136.366
Livrare 24-48 ore

676,71Lei

MULINETA DAIWA CROSSCAST 35 SCW 5000LD QD 3RUL -18%

MULINETA DAIWA CROSSCAST 35 SCW 5000LD QD 3RUL

d.10128.609
Livrare imediată!

563,56Lei(-18%) 462,42Lei

VARF DAIWA PENTRU NINJA X METHOD FEEDER YELLOW 80g

VARF DAIWA PENTRU NINJA X METHOD FEEDER YELLOW 80g

d.11603.000y
Livrare imediată!

40,86Lei

BLUZA DAIWA D-VEC BLUE MARIME XXL -30%

BLUZA DAIWA D-VEC BLUE MARIME XXL

d.18299.350
Livrare 24-48 ore

300,33Lei(-30%) 210,23Lei

JUVELNIC DAIWA N ZON 3,50M

JUVELNIC DAIWA N ZON 3,50M

a2.j13430.350
Livrare imediată!

464,00Lei

LINGURITA DAIWA ROTATIVA 6G SILVER GREEN

LINGURITA DAIWA ROTATIVA 6G SILVER GREEN

d.07410900
Livrare 24-48 ore

23,65Lei

BUFF DAIWA ASPHALT -20%

BUFF DAIWA ASPHALT

d.18206.104
Livrare 24-48 ore

37,08Lei(-20%) 29,67Lei

TRICOU DAIWA CARP CAMO XL

TRICOU DAIWA CARP CAMO XL

d.18865.040
Livrare 24-48 ore

117,98Lei

Galeata Daiwa Advantage pentru Nada, 12l -20%

Galeata Daiwa Advantage pentru Nada, 12l

a.13305.305
Livrare imediată!

66,51Lei(-20%) 53,22Lei

Mulineta Daiwa Crossfire LT 2500 4BS A -17%

Mulineta Daiwa Crossfire LT 2500 4BS A

d.10186.250
Livrare imediată!

234,58Lei(-17%) 194,87Lei

MULINETA, DAIWA, CROSSCAST, 45SCW, 5000C, QD, d.10250.500, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Daiwa -15%

MULINETA, DAIWA, CROSSCAST, 45SCW, 5000C, QD, d.10250.500, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Daiwa

d.10250.500
Livrare imediată!

645,27Lei(-15%) 549,90Lei

Lanseta, Spinning, Daiwa, SweepFire, 2.70m,, 30-70g,, 2seg, d.11446.272, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Bluza UV Daiwa D-Vec LS Navy, Marime XL

Bluza UV Daiwa D-Vec LS Navy, Marime XL

d.18299.440
Livrare 24-48 ore

369,11Lei

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 180g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 180g, 3+2seg

d.11164.390
Livrare imediată!

607,48Lei

Afişare 381 - 400 din 1480 (74 pagini)
Queries: 7, Total time: 112.962 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = 'da4b96c7d2f165c4d4bc1cc652'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.123)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.174)
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 (56.503)
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:1667
6 (55.791)
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 380,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.105)
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