Daiwa

Daiwa

Sortare după:

LANSETA DAIWA VERTICE CARP 3.00M 3LBS 2SEG

LANSETA DAIWA VERTICE CARP 3.00M 3LBS 2SEG

d.11598.305

Livrare 24-48 ore

337,20Lei(-18%) 275,29Lei

Vobler Daiwa Steez Prop 85F 8.5cm, Ghost Ayu, 12.7g

Vobler Daiwa Steez Prop 85F 8.5cm, Ghost Ayu, 12.7g

f.d.17511.000

Livrare 24-48 ore

74,71Lei

Vobler Daiwa Steez Crank, Artistic Chart, 5.4cm, 10.1g

Vobler Daiwa Steez Crank, Artistic Chart, 5.4cm, 10.1g

f3.d17510.104

Livrare 24-48 ore

72,12Lei

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.12mm, 8.6kg

Fir Textil Daiwa Tournament 8x Braid EVO+ Chartreuse, 135m, 0.12mm, 8.6kg

d.12761.012

Livrare 24-48 ore

144,73Lei

Shad Daiwa D.Fin Pepper Ghost, 12.50cm, 5buc/pac

Shad Daiwa D.Fin Pepper Ghost, 12.50cm, 5buc/pac

d.16504.512

Livrare 24-48 ore

40,03Lei

Shad Daiwa Prorex Slim Shady, Chartreuse Shoker, 10.5cm, 8.0g, 4buc/pac

Shad Daiwa Prorex Slim Shady, Chartreuse Shoker, 10.5cm, 8.0g, 4buc/pac

d.15100.210

Livrare 24-48 ore

27,00Lei

HYDROLASTIC DAIWA PINK MATCH WINNER 4-6

HYDROLASTIC DAIWA PINK MATCH WINNER 4-6

d.mwhpnk

Livrare 24-48 ore

139,19Lei(-19%) 112,35Lei

MULINETA DAIWA SWEEPFIRE E 2500C 190M/025MM/5,3:1

MULINETA DAIWA SWEEPFIRE E 2500C 190M/025MM/5,3:1

d.10118.250

Livrare imediată!

110,56Lei

FIR TEXTIL DAIWA J-BRAID X4 0.19MM 10.2KG 135MT GALBEN

FIR TEXTIL DAIWA J-BRAID X4 0.19MM 10.2KG 135MT GALBEN

d.12740.019

Livrare imediată!

35,57Lei

CUTIE DAIWA PROREX PENTRU NALUCI SAU ACCESORII L 36X22.5X5.5CM

CUTIE DAIWA PROREX PENTRU NALUCI SAU ACCESORII L 36X22.5X5.5CM

a4.15809.452

Livrare imediată!

75,50Lei(-20%) 60,06Lei

FIR DAIWA PROREX FC LEADER 0,14MM/1,7KG/50M

FIR DAIWA PROREX FC LEADER 0,14MM/1,7KG/50M

d.12995.014

Livrare 24-48 ore

20,51Lei

Agrafe Prindere Rapida Daiwa Tournament D-SNAP 10buc/plic Marimea M

Agrafe Prindere Rapida Daiwa Tournament D-SNAP 10buc/plic Marimea M

d.16512.001

Livrare imediată!

28,89Lei

HUSA DAIWA NEOPREN PT. MULINETA BAITCAST 12X12,5CM

HUSA DAIWA NEOPREN PT. MULINETA BAITCAST 12X12,5CM

a8.15802.025

Livrare imediată!

44,41Lei

NALUCA DAIWA PROREX BOTH CRAW SPARKLE CRAW 7.5CM

NALUCA DAIWA PROREX BOTH CRAW SPARKLE CRAW 7.5CM

f.d.15429.804

Livrare 24-48 ore

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

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 TDM 3012QD 4RUL 3000 0.28mm/150m

MULINETA DAIWA TDM 3012QD 4RUL 3000 0.28mm/150m

d.10420.312

Livrare 24-48 ore

895,10Lei(-19%) 729,12Lei

Ghete DAIWA D-Vec Boots, Marime 42

Ghete DAIWA D-Vec Boots, Marime 42

d.18518.042

Livrare 24-48 ore

427,76Lei

Lanseta Daiwa TATULA 732HFB BAITCAST 2.21M/14-42G 2SEG

Lanseta Daiwa TATULA 732HFB BAITCAST 2.21M/14-42G 2SEG

d.tat732hfbaf

Livrare imediată!

827,04Lei(-19%) 673,75Lei

Umbrela DAIWA Power Level Pegger 250cm

Umbrela DAIWA Power Level Pegger 250cm

d.plpu

Livrare 24-48 ore

685,89Lei

Groundbait Daiwa Advantage Method Big Carp 1kg/punga

Groundbait Daiwa Advantage Method Big Carp 1kg/punga

a0.13300.005

Livrare 24-48 ore

28,95Lei

Afişare 1041 - 1060 din 1583 (80 pagini)

Queries: 7, Total time: 103.871 ms [By time] [By id] [By file]

1 (0.180)

SELECT data
FROM `oc_session`
WHERE session_id = '57c884f30a2fa29d26d9da0838'

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

2 (0.093)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.103)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.101)

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

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

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

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

7 (0.229)

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