Daiwa

Daiwa

Sortare după:

FIR TEXTIL DAIWA J-BRAID X4 0.13MM 5.9KG 135MT GALBEN

FIR TEXTIL DAIWA J-BRAID X4 0.13MM 5.9KG 135MT GALBEN

d.12740.013

Livrare imediată!

35,53Lei

Shad DAIWA D.Fin, UV Chartreuse Tiger, 15cm, 3buc/pac

Shad DAIWA D.Fin, UV Chartreuse Tiger, 15cm, 3buc/pac

d.16505.615

Livrare 24-48 ore

45,75Lei

AGRAFA CU VARTEJ DAIWA PROREX S 10BUC PLIC

AGRAFA CU VARTEJ DAIWA PROREX S 10BUC PLIC

a7.15408.100

Livrare imediată!

9,51Lei

NALUCA DAIWA PROREX WILLOW SPINNER 7G GREEN CHARTREUSE

NALUCA DAIWA PROREX WILLOW SPINNER 7G GREEN CHARTREUSE

f.d.15426.103

Livrare imediată!

40,32Lei

BRIDE SIMPLE DAIWA PREMIUM 1.8MM/50BUC/PL

BRIDE SIMPLE DAIWA PREMIUM 1.8MM/50BUC/PL

d.15408.204

Livrare imediată!

20,26Lei

Mulineta Daiwa Emblem Pro 5000 7RUL/370MX035MM/5,1:1

Mulineta Daiwa Emblem Pro 5000 7RUL/370MX035MM/5,1:1

d.emp5000

Livrare 24-48 ore

1.259,19Lei(-19%) 1.025,28Lei

FIR TEXTIL DAIWA MORETHAN X12 EXplus SI LIME 135M 0.10MM 7.3KG

FIR TEXTIL DAIWA MORETHAN X12 EXplus SI LIME 135M 0.10MM 7.3KG

d.12695.010

Livrare 24-48 ore

240,55Lei

Foarfeca Daiwa pentru Fir Textil

Foarfeca Daiwa pentru Fir Textil

a.15803.070

Livrare imediată!

22,48Lei

Minciog Pastrav DAIWA D-Vec Floating Wading, 73x55x45cm

Minciog Pastrav DAIWA D-Vec Floating Wading, 73x55x45cm

a2.15810.520

Livrare 24-48 ore

140,11Lei

Lanseta Daiwa Tatula 6101 MXS 2.08M 5-21g 1SEG

Lanseta Daiwa Tatula 6101 MXS 2.08M 5-21g 1SEG

d.tat6101mxsaf

Livrare 24-48 ore

768,56Lei(-19%) 626,18Lei

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

f3.dfc12

Livrare 24-48 ore

71,54Lei

GEANTA DAIWA N ZON EVA 3BUC PT ACC 19X15X8CM

GEANTA DAIWA N ZON EVA 3BUC PT ACC 19X15X8CM

d.13305.090

Livrare 24-48 ore

172,21Lei

VARTEJ DAIWA N ZON DUBLU NR.10

VARTEJ DAIWA N ZON DUBLU NR.10

a7.13313.010

Livrare 24-48 ore

14,88Lei

Lanseta Telescopica Daiwa Sensor Bombette 42THF 4.20m 30-80g

Lanseta Telescopica Daiwa Sensor Bombette 42THF 4.20m 30-80g

d.sebb42thfbf

Livrare 24-48 ore

211,41Lei

MULINETA DAIWA FUEGO LT 1000, 6RUL, 150M/0.14MM

MULINETA DAIWA FUEGO LT 1000, 6RUL, 150M/0.14MM

d.10223.100

Livrare imediată!

611,32Lei(-29%) 436,11Lei

Lanseta Daiwa Aqualite Power Match 3.90m 7-30g 3seg

Lanseta Daiwa Aqualite Power Match 3.90m 7-30g 3seg

d.11400.390

Livrare 24-48 ore

330,54Lei

Fir Elastic Daiwa N Zon Power Gum 0.6mm 4kg 10m

Fir Elastic Daiwa N Zon Power Gum 0.6mm 4kg 10m

d.13306.006

Livrare 24-48 ore

15,94Lei

Fir Struna Daiwa Prorex 7x7 5m 9.5kg

Fir Struna Daiwa Prorex 7x7 5m 9.5kg

a7.17925.510

Livrare 24-48 ore

35,02Lei(-16%) 29,58Lei

SAPCA DAIWA MATELASSE MESH BLUE/WHITE

SAPCA DAIWA MATELASSE MESH BLUE/WHITE

d.ca402422

Livrare 24-48 ore

48,38Lei

Varga Daiwa Compass Mobile Tele, 3.00m

Varga Daiwa Compass Mobile Tele, 3.00m

d.11752.306

Livrare 24-48 ore

136,71Lei

Afişare 1581 - 1600 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: 122.841 ms [By time] [By id] [By file]

1 (0.088)

SELECT data
FROM `oc_session`
WHERE session_id = 'cdae8a0b7a0254f497928846f5'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.070)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.083)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.096)

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 = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (55.117)

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 = '0' AND p.manufacturer_id = '11'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (67.184)

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 = '0' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1580,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.203)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37