Daiwa

Daiwa

Sortare după:

LANSETA DAIWA 2BUC.WINDCAST CARP 3,60M/3LBS B

LANSETA DAIWA 2BUC.WINDCAST CARP 3,60M/3LBS B

d.11684.361

Livrare imediată!

644,95Lei(-12%) 564,99Lei

Lanseta DAIWA Emblem X45 3.96m, 3.75lbs, 2seg

Lanseta DAIWA Emblem X45 3.96m, 3.75lbs, 2seg

d.ebxtx453334ax

Livrare imediată!

936,84Lei

Mulineta DAIWA Saltiga 2022 15 HL SJ 7.1:1, 3mm/400m, 8+1rul

Mulineta DAIWA Saltiga 2022 15 HL SJ 7.1:1, 3mm/400m, 8+1rul

d.saltiga2215hl

Livrare 24-48 ore

3.045,19Lei

Fir Textil Daiwa Tournament 8xBraid EVO+ Alb 0.12mm 135m 8.6kg

Fir Textil Daiwa Tournament 8xBraid EVO+ Alb 0.12mm 135m 8.6kg

d.12763.012

Livrare 24-48 ore

144,73Lei

Lanseta DAIWA Emblem Carp 3312, 3.96m, 3.50lbs, 2seg

Lanseta DAIWA Emblem Carp 3312, 3.96m, 3.50lbs, 2seg

d.ebc3312bx

Livrare 24-48 ore

639,90Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.23MM 4.30KG 50M

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.23MM 4.30KG 50M

d.12940.023

Livrare imediată!

29,02Lei

Sapca Daiwa D-Vec Black

Sapca Daiwa D-Vec Black

d.18205.504

Livrare imediată!

98,72Lei

Kit montura Daiwa N Zon Heli Feeder Rig M 5buc/plic

Kit montura Daiwa N Zon Heli Feeder Rig M 5buc/plic

a.13308.001

Livrare 24-48 ore

16,19Lei

JACHETA DAIWA CAMO GREY Marime XXL

JACHETA DAIWA CAMO GREY Marime XXL

d.18293.950

Livrare 24-48 ore

404,66Lei(-49%) 206,73Lei

KIT MONTURA DAIWA N'ZON HELI MARIME S 5BUC/PLIC

KIT MONTURA DAIWA N'ZON HELI MARIME S 5BUC/PLIC

a.13308.000

Livrare 24-48 ore

16,19Lei

PENAR DAIWA PENTRU MONTURI NZON EVA 13X7X8CM

PENAR DAIWA PENTRU MONTURI NZON EVA 13X7X8CM

a4.13309.000

Livrare imediată!

91,56Lei

Fir Fluorocarbon Daiwa J, 0.22mm, 3.4kg, 100m

Fir Fluorocarbon Daiwa J, 0.22mm, 3.4kg, 100m

d.12220.022

Livrare imediată!

46,09Lei(-20%) 37,05Lei

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.14mm, 135m, 10.2kg

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.14mm, 135m, 10.2kg

d.12760.014

Livrare imediată!

125,27Lei

Maner Minciog Daiwa Telescopic Carbon, 3.60m

Maner Minciog Daiwa Telescopic Carbon, 3.60m

a2.11920.360

Livrare imediată!

409,75Lei

Fir Monofilament Daiwa Tournament ST 300m, 0.19mm, 5lb/2.27kg

Fir Monofilament Daiwa Tournament ST 300m, 0.19mm, 5lb/2.27kg

d.tst005.300

Livrare imediată!

25,79Lei

CARLIGE LEGATE DAIWA TOURNAMENT PT.CRAP NR.2/10BUC

CARLIGE LEGATE DAIWA TOURNAMENT PT.CRAP NR.2/10BUC

a.14450.002

Livrare 24-48 ore

23,92Lei

Shad Daiwa Prorex Slim Shady, Motoroil Tiger, 7.5cm, 3.3g, 4buc/pac

Shad Daiwa Prorex Slim Shady, Motoroil Tiger, 7.5cm, 3.3g, 4buc/pac

d.15100.117

Livrare 24-48 ore

31,05Lei

MULINETA DAIWA EMBLEM BR 25A

MULINETA DAIWA EMBLEM BR 25A

d.10928.025

Livrare imediată!

1.354,28Lei(-22%) 1.060,41Lei

BORSETA DAIWA 35X12X19CM

BORSETA DAIWA 35X12X19CM

d.df1105

Livrare 24-48 ore

456,10Lei

CUTIE MOMEALA DAIWA 2 L

CUTIE MOMEALA DAIWA 2 L

d.dwbb2

Livrare 24-48 ore

33,66Lei

Afişare 1561 - 1580 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: 114.923 ms [By time] [By id] [By file]

1 (0.141)

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

/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.128)

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

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

5 (49.580)

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

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

6 (64.721)

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

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

7 (0.118)

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

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