Daiwa


MULINETA DAIWA BALLISTIC LT 2000D -29%

MULINETA DAIWA BALLISTIC LT 2000D

d.10418.205
Livrare 24-48 ore

1.599,54Lei(-29%) 1.140,40Lei

Lanseta DAIWA Fuego Predator Spin Fast 2.40m, 10-40g, 2seg

Lanseta DAIWA Fuego Predator Spin Fast 2.40m, 10-40g, 2seg

d.11124.240
Livrare imediată!

315,79Lei

Shad Daiwa D.Fin, Perch, 10cm, 7buc/plic

Shad Daiwa D.Fin, Perch, 10cm, 7buc/plic

d.16502.410
Livrare 24-48 ore

32,82Lei

AGRAFA EGG DAIWA NR.8/7,0KG/10BUC/PL

AGRAFA EGG DAIWA NR.8/7,0KG/10BUC/PL

a7.14905.608
Livrare 24-48 ore

7,64Lei

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

f3.dfc12
Livrare 24-48 ore

73,63Lei

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.20mm 16.00kg

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.20mm 16.00kg

d.12796.020
Livrare imediată!

59,04Lei

STRUNA DAIWA PROREX TITAN 20CM 12KG

STRUNA DAIWA PROREX TITAN 20CM 12KG

a7.17925.712
Livrare 24-48 ore

19,89Lei

Mulineta Daiwa Team Match 4012QD 4000 -18%

Mulineta Daiwa Team Match 4012QD 4000

d.10420.412
Livrare 24-48 ore

902,01Lei(-18%) 735,66Lei

MULINETA DAIWA AIRITY LT 2500D 8RUL 150MX028 -29%

MULINETA DAIWA AIRITY LT 2500D 8RUL 150MX028

d.10115.250
Livrare 24-48 ore

2.635,85Lei(-29%) 1.878,03Lei

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

d.11211.205
Livrare imediată!

505,09Lei

SAPCA DAIWA CLASSIQUE MESH BLACK

SAPCA DAIWA CLASSIQUE MESH BLACK

d.ca402446
Livrare 24-48 ore

48,38Lei

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 8/10mm Natural (Maro) 30g/borcan

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 8/10mm Natural (Maro) 30g/borcan

a0.13300.103
Livrare 24-48 ore

32,49Lei

DAIWA CAP MINCIOG N ZONE 55X45CM

DAIWA CAP MINCIOG N ZONE 55X45CM

a2.m13410.055
Livrare imediată!

79,39Lei

FIR MONOFILAMENT DAIWA NZON S BRW 016MM 1.7KG 300M

FIR MONOFILAMENT DAIWA NZON S BRW 016MM 1.7KG 300M

d.12405.016
Livrare 24-48 ore

32,00Lei

Lanseta Feeder Daiwa Black Widow, 3.60m, 120g, 3+2seg -8%

Lanseta Feeder Daiwa Black Widow, 3.60m, 120g, 3+2seg

d.11789.361
Livrare imediată!

320,29Lei(-8%) 295,02Lei

Costum de Iarna Daiwa Winter Carp Olive Green, Marime L

Costum de Iarna Daiwa Winter Carp Olive Green, Marime L

d.18865.330
Livrare 24-48 ore

1.038,99Lei

Vobler Daiwa Steez Prop 85F 8.5cm, Ghost Ayu, 12.7g

Vobler Daiwa Steez Prop 85F 8.5cm, Ghost Ayu, 12.7g

f.d.17511.000
Livrare 24-48 ore

76,86Lei

Vobler Daiwa Steez Crank, Clear Monster Chart, 5.4cm, 10.1g

Vobler Daiwa Steez Crank, Clear Monster Chart, 5.4cm, 10.1g

f3.d17510.102
Livrare 24-48 ore

74,22Lei

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.10mm, 6.7kg

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.10mm, 6.7kg

d.12761.010
Livrare imediată!

153,69Lei

Lingurita Oscilanta Daiwa Presso MVR, Cream Glow, 2.8cm, 2.4g

Lingurita Oscilanta Daiwa Presso MVR, Cream Glow, 2.8cm, 2.4g

f.d15442.109
Livrare 24-48 ore

30,27Lei

Afişare 1361 - 1380 din 1597 (80 pagini)
Queries: 7, Total time: 102.962 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '434f630089322d4f76a6603d4c'
/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.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.123)
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.573)
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 (61.777)
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 1360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.133)
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