Daiwa

Daiwa

Sortare după:

BRIDE SIMPLE DAIWA PREMIUM 1.4MM, 50BUC/PLIC

BRIDE SIMPLE DAIWA PREMIUM 1.4MM, 50BUC/PLIC

d.15408.202

Livrare imediată!

14,80Lei(-21%) 11,75Lei

Combo DAIWA Dwave, 14-42g, 2.44m, 2seg

Combo DAIWA Dwave, 14-42g, 2.44m, 2seg

d.setdw02

Livrare 24-48 ore

388,45Lei

LANSETA DAIWA 2BUC WINDCAST TRADITIONAL CARP 3.90M, 3.5LBS

LANSETA DAIWA 2BUC WINDCAST TRADITIONAL CARP 3.90M, 3.5LBS

d.11686.396

Livrare imediată!

699,49Lei

FIR TEXTIL DAIWA MORETHAN X12 EXplus SI LIME 135M 0.8MM 5.8KG

FIR TEXTIL DAIWA MORETHAN X12 EXplus SI LIME 135M 0.8MM 5.8KG

d.12695.008

Livrare 24-48 ore

249,31Lei

NALUCA DAIWA PROREX BOTH CRAW GREEN PUMPKIN PURPLE 7.5CM

NALUCA DAIWA PROREX BOTH CRAW GREEN PUMPKIN PURPLE 7.5CM

f.d.15429.805

Livrare 24-48 ore

55,45Lei(-27%) 40,47Lei

Lanseta Daiwa Tatula Spinning 1.95M 7-21g 2SEG

Lanseta Daiwa Tatula Spinning 1.95M 7-21g 2SEG

d.11461.195

Livrare 24-48 ore

708,48Lei(-19%) 577,32Lei

Muste DAIWA Fly Pack Selection Pike Flies 3 Different Types, 3buc/pac

Muste DAIWA Fly Pack Selection Pike Flies 3 Different Types, 3buc/pac

f3.dfc19

Livrare 24-48 ore

71,54Lei

HUSA DAIWA LANSETA CU MULINETA 2 POSTURI 145CM

HUSA DAIWA LANSETA CU MULINETA 2 POSTURI 145CM

d.15801.245

Livrare 24-48 ore

384,40Lei

VARTEJ DAIWA N ZON DUBLU NR.8

VARTEJ DAIWA N ZON DUBLU NR.8

a7.13313.008

Livrare 24-48 ore

14,88Lei

MULINETA DAIWA AIRITY LT 3000D-C 8RUL 150MX023

MULINETA DAIWA AIRITY LT 3000D-C 8RUL 150MX023

d.10115.300

Livrare 24-48 ore

2.635,85Lei(-29%) 1.877,11Lei

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

d.11211.205

Livrare imediată!

505,09Lei

SAPCA DAIWA CLASSIQUE MESH BLACK

SAPCA DAIWA CLASSIQUE MESH BLACK

d.ca402446

Livrare 24-48 ore

46,69Lei

Fir Elastic Daiwa N Zon Power Gum 1.0mm 8kg 10m

Fir Elastic Daiwa N Zon Power Gum 1.0mm 8kg 10m

d.13306.001

Livrare 24-48 ore

20,64Lei

Fir Struna Daiwa Prorex 7x7 5m 7kg

Fir Struna Daiwa Prorex 7x7 5m 7kg

a7.17925.507

Livrare 24-48 ore

35,14Lei(-26%) 26,02Lei

TRICOU POLO DAIWA CULOARE NEGRU MARIME 3XL

TRICOU POLO DAIWA CULOARE NEGRU MARIME 3XL

d.18996.060

Livrare 24-48 ore

369,59Lei(-59%) 151,33Lei

LANSETA DAIWA TELE LEGALIS 3.60 40-120G

LANSETA DAIWA TELE LEGALIS 3.60 40-120G

d.11761.368

Livrare 24-48 ore

272,53Lei

Multineta Daiwa Prorex V LT 3000C 0.23mm/150m, 5.3:1, 6rul

Multineta Daiwa Prorex V LT 3000C 0.23mm/150m, 5.3:1, 6rul

d.10609.300

Livrare 24-48 ore

637,26Lei

Hanorac Daiwa D-Vec Gri, Marime XL

Hanorac Daiwa D-Vec Gri, Marime XL

d.18205.640

Livrare 24-48 ore

362,04Lei(-39%) 221,88Lei

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

Afişare 1461 - 1480 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: 97.046 ms [By time] [By id] [By file]

1 (0.117)

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

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

2 (0.100)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.132)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.135)

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

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

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

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

7 (0.142)

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