Daiwa


Groundbait Daiwa Advantage F1 1kg/punga

Groundbait Daiwa Advantage F1 1kg/punga

a0.13300.003
Livrare imediată!

32,63Lei

Lanseta DAIWA Ninja X Spin, 10-30g, 2.10m, 2seg

Lanseta DAIWA Ninja X Spin, 10-30g, 2.10m, 2seg

d.11204.211
Livrare imediată!

208,45Lei

AGRAFA+VARTEJ DAIWA N ZON NR.8

AGRAFA+VARTEJ DAIWA N ZON NR.8

a7.13314.008
Livrare 24-48 ore

15,00Lei

VARF DAIWA PENTRU N ZON CARBON HEAVY 80-180G GREEN 4OZ

VARF DAIWA PENTRU N ZON CARBON HEAVY 80-180G GREEN 4OZ

d.11138.040
Livrare imediată!

128,07Lei

MULINETA DAIWA N ZON LT 5000S-CP 4RUL 150MX0.28MM -8%

MULINETA DAIWA N ZON LT 5000S-CP 4RUL 150MX0.28MM

d.10312.500
Livrare imediată!

397,71Lei(-8%) 364,96Lei

Lanseta Daiwa Black Widow Exttention Carp 2.74m 2.75lbs 2seg

Lanseta Daiwa Black Widow Exttention Carp 2.74m 2.75lbs 2seg

d.11578.270
Livrare 24-48 ore

209,87Lei

POP-UP DAIWA ADVANTAGE ORANGE 8/10MM 18G

POP-UP DAIWA ADVANTAGE ORANGE 8/10MM 18G

a0.13300.301
Livrare 24-48 ore

36,73Lei

LANSETA DAIWA 3+2BUC N.ZON FEEDER 3,66M/100G -18%

LANSETA DAIWA 3+2BUC N.ZON FEEDER 3,66M/100G

d.11331.365
Livrare imediată!

428,13Lei(-18%) 349,90Lei

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

30,60Lei

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

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

d.11789.365
Livrare imediată!

310,93Lei(-8%) 285,54Lei

Varga Daiwa Sweepfire Telescopica 3.00m

Varga Daiwa Sweepfire Telescopica 3.00m

d.11521.300
Livrare imediată!

57,06Lei

Shad Daiwa Steez Stirring 11.0cm, Magic Shad, 6buc/pac

Shad Daiwa Steez Stirring 11.0cm, Magic Shad, 6buc/pac

d.17513.400
Livrare 24-48 ore

32,13Lei

Lanseta Spinning Daiwa Tournament XT 2.35m, 18-64g, 2seg

Lanseta Spinning Daiwa Tournament XT 2.35m, 18-64g, 2seg

d.11128.237
Livrare 24-48 ore

2.142,01Lei

Cutie pentru Momeala Daiwa D-Box SS Smoke, 21.7x16.4x4.8cm

Cutie pentru Momeala Daiwa D-Box SS Smoke, 21.7x16.4x4.8cm

d.14310.005
Livrare 24-48 ore

35,30Lei

SHAD DAIWA D.FIN 10CM CHARTREUSE/7BUC

SHAD DAIWA D.FIN 10CM CHARTREUSE/7BUC

d.16500.310
Livrare imediată!

31,38Lei

LANSETA SPINNING DAIWA 2SEG PROREX 2,10M/7-21G

LANSETA SPINNING DAIWA 2SEG PROREX 2,10M/7-21G

d.11298.210
Livrare imediată!

351,73Lei

FIR DAIWA J-BRAID X8 CHARTREUSE 024MM/18.0KG/150M

FIR DAIWA J-BRAID X8 CHARTREUSE 024MM/18.0KG/150M

d.12750.024
Livrare 24-48 ore

66,42Lei

FIR DAIWA PROREX FC LEADER 0.45MM/12.8KG/28M

FIR DAIWA PROREX FC LEADER 0.45MM/12.8KG/28M

d.12995.045
Livrare 24-48 ore

29,02Lei

NALUCA DAIWA PROREX MICRO SPINNER 5G GREEN CHARTREUSE -26%

NALUCA DAIWA PROREX MICRO SPINNER 5G GREEN CHARTREUSE

f.d.15426.013
Livrare 24-48 ore

37,33Lei(-26%) 27,58Lei

SAPCA DAIWA CARP KAKI

SAPCA DAIWA CARP KAKI

d.ca258647
Livrare imediată!

47,46Lei

Afişare 1541 - 1560 din 1665 (84 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 117.986 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = '93b0bc24de25b2ff17aa69bbd2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.085)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.111)
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
5 (53.512)
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:1699
6 (63.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 = '2' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1540,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.177)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37