Daiwa

Daiwa

Sortare după:

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

Costum de Iarna Daiwa Winter Carp Olive Green, Marime M

Costum de Iarna Daiwa Winter Carp Olive Green, Marime M

d.18865.320

Livrare 24-48 ore

983,51Lei

Mulineta Daiwa Prorex MQ LT 2500D 0.28mm/150m, 5.2:1, 6rul

Mulineta Daiwa Prorex MQ LT 2500D 0.28mm/150m, 5.2:1, 6rul

d.10610.250

Livrare imediată!

1.205,10Lei(-22%) 944,49Lei

Hanorac Daiwa D-Vec Navy, Marime L

Hanorac Daiwa D-Vec Navy, Marime L

d.18205.730

Livrare imediată!

388,56Lei

Lanseta Spinning Daiwa Megaforce Sensitip 2.60m, 4-21g, 2seg

Lanseta Spinning Daiwa Megaforce Sensitip 2.60m, 4-21g, 2seg

d.11251.260

Livrare imediată!

239,10Lei

Mulineta Daiwa N Zon LT 6000SS-P 4.9:1, 0.28mm/150m, 4rul

Mulineta Daiwa N Zon LT 6000SS-P 4.9:1, 0.28mm/150m, 4rul

d.10312.600

Livrare imediată!

443,25Lei(-8%) 407,71Lei

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

Cantar Digital DAIWA T-Bar, 50kg

Cantar Digital DAIWA T-Bar, 50kg

a.18860.251

Livrare 24-48 ore

156,16Lei

Afişare 841 - 860 din 1664 (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: 111.581 ms [By time] [By id] [By file]

1 (0.107)

SELECT data
FROM `oc_session`
WHERE session_id = '9e765363708e0cdc28d3275552'

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

2 (0.074)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.088)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.087)

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 (54.348)

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 (56.740)

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 840,20

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

7 (0.137)

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