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

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

Foarfeca Daiwa pentru Fir Textil

Foarfeca Daiwa pentru Fir Textil

a.15803.070

Livrare imediată!

22,48Lei

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

Geanta DAIWA Matchman Carryall, 56x47x22cm

Geanta DAIWA Matchman Carryall, 56x47x22cm

a8.dmmc1

Livrare 24-48 ore

312,95Lei

Ghete DAIWA D-Vec Boots, Marime 44

Ghete DAIWA D-Vec Boots, Marime 44

d.18518.044

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

MULINETA DAIWA WHISKER 25QDA 7RUL

d.10930.025

Livrare imediată!

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

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

Mulineta Daiwa BG Monocoque 10000-H 6RUL

d.10465.100

Livrare 24-48 ore

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

ROD-POD DAIWA BLACK WIDOW LOW LEVEL 3 POSTURI

ROD-POD DAIWA BLACK WIDOW LOW LEVEL 3 POSTURI

a6.18705.200

Livrare imediată!

318,74Lei

LANSETA DAIWA AQUALITE FEEDER 3.60M 120G 3+2seg

LANSETA DAIWA AQUALITE FEEDER 3.60M 120G 3+2seg

d.11769.362

Livrare 24-48 ore

436,27Lei(-18%) 355,89Lei

Fir Fluorocarbon Daiwa J, 0.33mm, 6.8kg, 100m

Fir Fluorocarbon Daiwa J, 0.33mm, 6.8kg, 100m

d.12220.033

Livrare 24-48 ore

54,50Lei

Lanseta Spinning Daiwa 2seg Triforce Target Zander Spin, 2.40m, 15-50g

Lanseta Spinning Daiwa 2seg Triforce Target Zander Spin, 2.40m, 15-50g

d.11400.246

Livrare imediată!

188,75Lei

Ochelari Polarizati Daiwa Sport, Lentila Galbena

Ochelari Polarizati Daiwa Sport, Lentila Galbena

d.df005y

Livrare 24-48 ore

128,62Lei

Husa Lanseta cu Mulineta Daiwa Widow, 3 Posturi, 13ft/213x35x15cm

Husa Lanseta cu Mulineta Daiwa Widow, 3 Posturi, 13ft/213x35x15cm

a8.18705.313

Livrare 24-48 ore

379,90Lei

Lanseta Spinning Daiwa Tournament XT 2.15m, 4-18g, 2seg

Lanseta Spinning Daiwa Tournament XT 2.15m, 4-18g, 2seg

d.11128.215

Livrare imediată!

1.910,23Lei

Afişare 1121 - 1140 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: 103.761 ms [By time] [By id] [By file]

1 (0.097)

SELECT data
FROM `oc_session`
WHERE session_id = '2d0d9240274201909d8ad86d32'

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

2 (0.143)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.119)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.092)

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

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.899)

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 1120,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