Daiwa

Daiwa

Sortare după:

SHAD DAIWA D.FIN 12.5CM/GREEN PEARL/5BUC/PL

SHAD DAIWA D.FIN 12.5CM/GREEN PEARL/5BUC/PL

d.16500.112

Livrare 24-48 ore

40,03Lei

Lansete Daiwa Legalis UL Spin 2.10m 3-15g

Lansete Daiwa Legalis UL Spin 2.10m 3-15g

d.11768.210

Livrare 24-48 ore

247,97Lei

Agrafa cu Vartej Daiwa Nr.4, 16kg, 10buc/pac

Agrafa cu Vartej Daiwa Nr.4, 16kg, 10buc/pac

a7.14905.204

Livrare 24-48 ore

8,99Lei

HUSA DAIWA BLACK WIDOW HOLDALL 3 LANSETE PLUS 3 MULINETE 200X40CM

HUSA DAIWA BLACK WIDOW HOLDALL 3 LANSETE PLUS 3 MULINETE 200X40CM

d.18705.012

Livrare 24-48 ore

389,08Lei

MULINETA DAIWA CALDIA LT 6RUL 1000S-P 0.12mm/100m

MULINETA DAIWA CALDIA LT 6RUL 1000S-P 0.12mm/100m

d.10412.105

Livrare 24-48 ore

1.222,75Lei(-39%) 746,99Lei

Lanseta Daiwa Tatula Baitcast 701MRBAF 2.13M 7-21g 1SEG

Lanseta Daiwa Tatula Baitcast 701MRBAF 2.13M 7-21g 1SEG

d.tat701mrbaf

Livrare 24-48 ore

726,96Lei(-19%) 592,42Lei

Muste DAIWA Fly Pack Caddis Nymphs, 10buc/pac

Muste DAIWA Fly Pack Caddis Nymphs, 10buc/pac

f3.dfc20

Livrare 24-48 ore

73,63Lei

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Scopex Natural (Maro) 30g/borcan

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Scopex Natural (Maro) 30g/borcan

a0.13300.102

Livrare 24-48 ore

31,07Lei

Lanseta Spinning DAIWA Ninja X Spin 2.40m, 15-50g, 2seg

Lanseta Spinning DAIWA Ninja X Spin 2.40m, 15-50g, 2seg

d.11204.242

Livrare 24-48 ore

242,38Lei

AGRAFA+VARTEJ DUBLU DAIWA N ZON NR.10

AGRAFA+VARTEJ DUBLU DAIWA N ZON NR.10

a7.13315.010

Livrare 24-48 ore

19,46Lei

MULINETA DAIWA LAGUNA LT 4000 3RUL 0.25/190mm

MULINETA DAIWA LAGUNA LT 4000 3RUL 0.25/190mm

d.10414.405

Livrare imediată!

341,11Lei

Varga Telescopica Daiwa Legalis 4m 160g

Varga Telescopica Daiwa Legalis 4m 160g

d.11761.400

Livrare 24-48 ore

130,14Lei

MULINETA DAIWA BG Monocoque 6000D-XH 6RUL

MULINETA DAIWA BG Monocoque 6000D-XH 6RUL

d.10465.600

Livrare 24-48 ore

1.162,27Lei(-11%) 1.034,13Lei

SAPCA DAIWA NOIRE

SAPCA DAIWA NOIRE

d.ca258579

Livrare 24-48 ore

43,34Lei

HUSA DAIWA IS EXTENSION CARP 3 POSTURI 130X25X12CM

HUSA DAIWA IS EXTENSION CARP 3 POSTURI 130X25X12CM

d.18851.003

Livrare imediată!

295,03Lei

DAIWA CAP MINCIOG N ZONE 55X45CM

DAIWA CAP MINCIOG N ZONE 55X45CM

a2.m13410.055

Livrare imediată!

78,09Lei

FIR MONOFILAMENT DAIWA NZON S BRW 030MM 6.40KG 300M

FIR MONOFILAMENT DAIWA NZON S BRW 030MM 6.40KG 300M

d.12405.030

Livrare 24-48 ore

39,68Lei

Lanseta Feeder Daiwa 3+2seg Aqualite, 3,90m, 180g

Lanseta Feeder Daiwa 3+2seg Aqualite, 3,90m, 180g

d.11769.396

Livrare imediată!

520,05Lei

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

Afişare 1001 - 1020 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: 141.161 ms [By time] [By id] [By file]

1 (0.098)

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

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

2 (0.067)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.091)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.088)

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

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

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

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

7 (0.154)

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