Daiwa


SHAD DAIWA D.FIN 10CM MO- AYU/7BUC

SHAD DAIWA D.FIN 10CM MO- AYU/7BUC

d.16500.010
Livrare 24-48 ore

31,38Lei

FIR DAIWA J-BRAID X8 MULTICOLOR 018MM/12KG/150M

FIR DAIWA J-BRAID X8 MULTICOLOR 018MM/12KG/150M

d.12755.018
Livrare 24-48 ore

66,42Lei

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.13MM 8,0KG 150M

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.13MM 8,0KG 150M

d.12751.013
Livrare 24-48 ore

66,42Lei

FIR DAIWA PROREX FC LEADER 0.18MM/2.5KG/50M

FIR DAIWA PROREX FC LEADER 0.18MM/2.5KG/50M

d.12995.018
Livrare imediată!

20,51Lei

VOBLER DAIWA PROREX MICRO MINNOW, BROWN TROUT, 3CM, 1.5G

VOBLER DAIWA PROREX MICRO MINNOW, BROWN TROUT, 3CM, 1.5G

f3.d15217.009
Livrare 24-48 ore

48,65Lei

MULINETA DAIWA CALDIA LT 2500D -29%

MULINETA DAIWA CALDIA LT 2500D

d.10412.255
Livrare imediată!

1.291,88Lei(-29%) 920,52Lei

Lanseta DAIWA Ninja X Spoon ST, 1.5-5g, 1.95m, 2seg

Lanseta DAIWA Ninja X Spoon ST, 1.5-5g, 1.95m, 2seg

d.11202.195
Livrare 24-48 ore

264,87Lei

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

Lanseta DAIWA Fuego Predator Spin Fast 2.10m, 5-20g, 2seg

Lanseta DAIWA Fuego Predator Spin Fast 2.10m, 5-20g, 2seg

d.11124.210
Livrare imediată!

287,00Lei

AGRAFA GAMAKATSU HYPER EZ BLACK NI 15KG 7BUC/PL

AGRAFA GAMAKATSU HYPER EZ BLACK NI 15KG 7BUC/PL

a7.gk149320.1
Livrare imediată!

19,86Lei

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.06mm 5.00kg

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.06mm 5.00kg

d.12796.006
Livrare imediată!

57,18Lei

Hanorac DAIWA Negru / Rosu, Marime M

Hanorac DAIWA Negru / Rosu, Marime M

d.dblkrdhood.m
Livrare 24-48 ore

426,88Lei

Ghete DAIWA D-Vec Boots, Marime 45

Ghete DAIWA D-Vec Boots, Marime 45

d.18518.045
Livrare 24-48 ore

427,76Lei

Tub lanseta Daiwa BLACK GOLD L 220CM

Tub lanseta Daiwa BLACK GOLD L 220CM

a8.e220bg
Livrare 24-48 ore

199,94Lei

ULEI DAIWA PENTRU MULINETE

ULEI DAIWA PENTRU MULINETE

d.dro1
Livrare 24-48 ore

41,06Lei

MULINETA DAIWA WHISKER 25QDA 7RUL -29%

MULINETA DAIWA WHISKER 25QDA 7RUL

d.10930.025
Livrare imediată!

2.330,16Lei(-29%) 1.663,93Lei

Agrafa cu Vartej DAIWA Emerillon, Nr.4/16kg, 20buc/pac

Agrafa cu Vartej DAIWA Emerillon, Nr.4/16kg, 20buc/pac

a7.em258050
Livrare 24-48 ore

13,06Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.35MM 8.100KG 50M

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.35MM 8.100KG 50M

d.12940.035
Livrare imediată!

34,52Lei

MINCIOG DAIWA CROSSCAST 1.80M 100X100CM 1SEG

MINCIOG DAIWA CROSSCAST 1.80M 100X100CM 1SEG

a2.m11561.175
Livrare 24-48 ore

369,62Lei

Mulineta Daiwa BG Monocoque 10000-H 6RUL -11%

Mulineta Daiwa BG Monocoque 10000-H 6RUL

d.10465.100
Livrare 24-48 ore

1.267,84Lei(-11%) 1.127,97Lei

Afişare 1221 - 1240 din 1663 (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: 109.986 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '5a4008a65d3d4c0bffc240b0a8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.064)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.082)
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 (51.033)
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 (58.487)
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 1220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.149)
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