Daiwa

Daiwa

Sortare după:

CACIULA DAIWA KNITTED GREEN BEANIE

CACIULA DAIWA KNITTED GREEN BEANIE

d.dkbh1

Livrare 24-48 ore

59,40Lei

Lanseta Spinning Daiwa 2seg Prorex S, 2,10m/7-21g

Lanseta Spinning Daiwa 2seg Prorex S, 2,10m/7-21g

d.11280.211

Livrare imediată!

336,46Lei(-18%) 274,69Lei

Mulineta Daiwa Exist LT2500D 12rul, 0.28mm/150m, 5.2:1

Mulineta Daiwa Exist LT2500D 12rul, 0.28mm/150m, 5.2:1

d.10102.252

Livrare 24-48 ore

4.638,51Lei

Shad Daiwa D.Fin Goby, 7.50cm, 10buc/pac

Shad Daiwa D.Fin Goby, 7.50cm, 10buc/pac

d.16504.308

Livrare 24-48 ore

30,60Lei

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

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

d.16500.008

Livrare 24-48 ore

30,60Lei

FIR DAIWA J-BRAID X8 MULTICOLOR 013MM/8KG/150M

FIR DAIWA J-BRAID X8 MULTICOLOR 013MM/8KG/150M

d.12755.013

Livrare imediată!

66,42Lei

Shad DAIWA D.Fin, UV Hot Tomato, 15cm, 3buc/pac

Shad DAIWA D.Fin, UV Hot Tomato, 15cm, 3buc/pac

d.16505.715

Livrare 24-48 ore

45,75Lei

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.10MM 6,0KG 150M

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.10MM 6,0KG 150M

d.12751.010

Livrare imediată!

66,42Lei

FIR DAIWA PROREX FC LEADER 0.16MM/2.0KG/50M

FIR DAIWA PROREX FC LEADER 0.16MM/2.0KG/50M

d.12995.016

Livrare 24-48 ore

20,51Lei

VOBLER DAIWA FLAT MINNOW SS, FIRE TIGER, 5CM, 4.8G

VOBLER DAIWA FLAT MINNOW SS, FIRE TIGER, 5CM, 4.8G

f3.d15216.000

Livrare 24-48 ore

41,27Lei

Vobler Daiwa Prorex Pencil Floating, Fire Tiger 6.5cm 5.8g

Vobler Daiwa Prorex Pencil Floating, Fire Tiger 6.5cm 5.8g

f3.d15209.000

Livrare 24-48 ore

41,62Lei

Shad Daiwa D.Fin, Hot Tomato, 12.5cm, 5buc/plic

Shad Daiwa D.Fin, Hot Tomato, 12.5cm, 5buc/plic

d.16502.612

Livrare 24-48 ore

40,03Lei

Cap Jig DAIWA Prorex Round Screw-In Heads Lead Free, 7g, 3buc/pac

Cap Jig DAIWA Prorex Round Screw-In Heads Lead Free, 7g, 3buc/pac

f2.15417.107

Livrare 24-48 ore

22,22Lei

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC URUME

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC URUME

d.15604.801

Livrare imediată!

42,91Lei

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

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.20mm 16.00kg

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.20mm 16.00kg

d.12796.020

Livrare imediată!

57,18Lei

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

Muste DAIWA Fly Pack Klinkhammers, 9buc/pac

f3.dfc12

Livrare 24-48 ore

71,54Lei

VARTEJ DAIWA N ZON NR.12

VARTEJ DAIWA N ZON NR.12

a7.13312.012

Livrare 24-48 ore

11,62Lei

MULINETA DAIWA AIRITY LT 2500D 8RUL 150MX028

MULINETA DAIWA AIRITY LT 2500D 8RUL 150MX028

d.10115.250

Livrare 24-48 ore

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

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

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

d.11400.420

Livrare 24-48 ore

348,29Lei

Afişare 1601 - 1620 din 1653 (83 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: 99.705 ms [By time] [By id] [By file]

1 (0.127)

SELECT data
FROM `oc_session`
WHERE session_id = '667a5a8eeb503b99d0211840a6'

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

2 (0.108)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.135)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.128)

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

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

5 (42.521)

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

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

6 (56.549)

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

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

7 (0.137)

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

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