Daiwa


Vobler Daiwa Steez Prop 85F 8.5cm, Clear Lime, 12.7g

Vobler Daiwa Steez Prop 85F 8.5cm, Clear Lime, 12.7g

f.d.17511.002
Livrare 24-48 ore

74,71Lei

Vobler Daiwa Steez Crank, Monster Gill, 5.4cm, 10.6g

Vobler Daiwa Steez Crank, Monster Gill, 5.4cm, 10.6g

f3.d17510.200
Livrare 24-48 ore

72,12Lei

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.16mm, 12.2kg

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.16mm, 12.2kg

d.12761.016
Livrare 24-48 ore

114,45Lei

Shad Daiwa D.Fin Pepper Ghost, 7.50cm, 10buc/pac

Shad Daiwa D.Fin Pepper Ghost, 7.50cm, 10buc/pac

d.16504.508
Livrare 24-48 ore

30,60Lei

Shad Daiwa Prorex Slim Shady, White Ghost, 10.5cm, 8.0g, 4buc/pac

Shad Daiwa Prorex Slim Shady, White Ghost, 10.5cm, 8.0g, 4buc/pac

d.15100.207
Livrare 24-48 ore

27,00Lei

SHAD DAIWA D.FIN 10CM AYU/7BUC

SHAD DAIWA D.FIN 10CM AYU/7BUC

d.16500.510
Livrare 24-48 ore

31,38Lei

FIR TEXTIL DAIWA J-BRAID X8 CHARTREUSE 010MM/6,0KG/150M

FIR TEXTIL DAIWA J-BRAID X8 CHARTREUSE 010MM/6,0KG/150M

d.12750.010
Livrare imediată!

66,42Lei

Fir Monofilament Daiwa Infinity Carp, Camo Green, 10.10kg, 0.37mm, 840m

Fir Monofilament Daiwa Infinity Carp, Camo Green, 10.10kg, 0.37mm, 840m

d.12767.137
Livrare 24-48 ore

120,41Lei

FIR TEXTIL DAIWA J-BRAID X4 0.15MM 6.9KG 135MT VERDE

FIR TEXTIL DAIWA J-BRAID X4 0.15MM 6.9KG 135MT VERDE

d.12741.015
Livrare imediată!

46,04Lei

SHAD DAIWA DUCKFIN 10CM PEARL 7 BUCACTI/PLIC

SHAD DAIWA DUCKFIN 10CM PEARL 7 BUCACTI/PLIC

d.16500.410
Livrare imediată!

31,38Lei

MULINETA DAIWA BALLISTIC LT 2000D -39%

MULINETA DAIWA BALLISTIC LT 2000D

d.10418.205
Livrare 24-48 ore

1.599,54Lei(-39%) 976,85Lei

Fir Textil DAIWA Tournament Sinking Feeder Braid 8+1X, 0.14m, 135m

Fir Textil DAIWA Tournament Sinking Feeder Braid 8+1X, 0.14m, 135m

d.12785.014
Livrare 24-48 ore

133,54Lei

Shad Daiwa D.Fin, Chartreuse Tiger, 7.5cm, 10buc/plic

Shad Daiwa D.Fin, Chartreuse Tiger, 7.5cm, 10buc/plic

d.16502.508
Livrare imediată!

30,60Lei

Mulineta DAIWA 24 N Zon Plus 25QD 4RUL/150MX028M/4.7:1 -13%

Mulineta DAIWA 24 N Zon Plus 25QD 4RUL/150MX028M/4.7:1

d.10133.425
Livrare imediată!

1.514,23Lei(-13%) 1.322,84Lei

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

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

a7.14905.708
Livrare 24-48 ore

9,51Lei

Sapca DAIWA Matelasse Mesh Red / Black

Sapca DAIWA Matelasse Mesh Red / Black

d.ca402408
Livrare 24-48 ore

48,38Lei

Lanseta Pastrav DAIWA Presso Imprimi 604L, 1.80m, 2-8g, 4seg

Lanseta Pastrav DAIWA Presso Imprimi 604L, 1.80m, 2-8g, 4seg

d.pso604lcf
Livrare 24-48 ore

389,61Lei

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

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

a0.13300.102
Livrare 24-48 ore

31,07Lei

VARTEJ RAPID DAIWA N ZON + VARTEJ NR.14

VARTEJ RAPID DAIWA N ZON + VARTEJ NR.14

a7.13316.014
Livrare imediată!

17,50Lei

Stoppere Daiwa N Zon Feeder Stops Marime L

Stoppere Daiwa N Zon Feeder Stops Marime L

a.13310.108
Livrare 24-48 ore

10,56Lei

Afişare 1261 - 1280 din 1583 (80 pagini)
Queries: 7, Total time: 109.906 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = 'e9064343d21aa463f0c906e837'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.158)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.168)
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 (48.247)
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 (60.930)
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 1260,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.161)
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