Daiwa

Daiwa

Sortare după:

NALUCA DAIWA PROREX WILLOW SPINNER 7G GOLD PERCH

NALUCA DAIWA PROREX WILLOW SPINNER 7G GOLD PERCH

f.d.15426.104

Livrare imediată!

39,28Lei(-14%) 33,86Lei

SHAD DAIWA DUCKFIN 12.5CM/PEARL/5BUC/PL

SHAD DAIWA DUCKFIN 12.5CM/PEARL/5BUC/PL

d.16500.412

Livrare 24-48 ore

40,69Lei

Lanseta Daiwa Fuego Baitcast 661MFB, 1.98m, 7-21g, 1buc

Lanseta Daiwa Fuego Baitcast 661MFB, 1.98m, 7-21g, 1buc

d.fu661mfbaf

Livrare 24-48 ore

475,68Lei(-43%) 271,85Lei

AGRAFA+VARTEJ DAIWA TYPE.2 NR.4/10,0KG/10BUC/PL

AGRAFA+VARTEJ DAIWA TYPE.2 NR.4/10,0KG/10BUC/PL

a7.14905.304

Livrare 24-48 ore

13,10Lei

Key Holder Daiwa

Key Holder Daiwa

d.15803.001

Livrare imediată!

21,63Lei

Lanseta Fly DAIWA Wilderness Trout 8654-BU, Clasa 5, 2.59m, 4seg

Lanseta Fly DAIWA Wilderness Trout 8654-BU, Clasa 5, 2.59m, 4seg

d.wntf8654.bu

Livrare 24-48 ore

429,15Lei

LANSETA DAIWA CROSSCAST TELE CARP 3.90M, 3.5LBS, 7seg

LANSETA DAIWA CROSSCAST TELE CARP 3.90M, 3.5LBS, 7seg

d.11586.395

Livrare 24-48 ore

448,38Lei

VARTEJ DAIWA N ZON NR.8

VARTEJ DAIWA N ZON NR.8

a7.13312.008

Livrare 24-48 ore

12,71Lei

MULINETA DAIWA AIRITY LT 3000D-C 8RUL 150MX023

MULINETA DAIWA AIRITY LT 3000D-C 8RUL 150MX023

d.10115.300

Livrare 24-48 ore

2.635,85Lei(-29%) 1.878,03Lei

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

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

d.11400.390

Livrare 24-48 ore

336,99Lei

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 8/10mm ROSU 30g/borcan

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 8/10mm ROSU 30g/borcan

a0.13300.107

Livrare imediată!

31,62Lei

CACIULA DAIWA KNITTED GREEN BEANIE

CACIULA DAIWA KNITTED GREEN BEANIE

d.dkbh1

Livrare 24-48 ore

61,30Lei

FIR MONOFILAMENT DAIWA NZON S BRW 018MM 2.4KG 300M

FIR MONOFILAMENT DAIWA NZON S BRW 018MM 2.4KG 300M

d.12405.018

Livrare imediată!

32,15Lei

Lanseta Feeder Daiwa 3+2seg Black Widow, 3.60m, 150g

Lanseta Feeder Daiwa 3+2seg Black Widow, 3.60m, 150g

d.11789.365

Livrare imediată!

310,93Lei(-8%) 286,46Lei

Costum de Iarna Daiwa Winter Carp Olive Green, Marime XL

Costum de Iarna Daiwa Winter Carp Olive Green, Marime XL

d.18865.340

Livrare 24-48 ore

1.000,94Lei

Vobler Daiwa Steez Prop 85F 8.5cm, Wakasagi, 12.7g

Vobler Daiwa Steez Prop 85F 8.5cm, Wakasagi, 12.7g

f.d.17511.001

Livrare 24-48 ore

75,95Lei

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

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

f3.d17510.103

Livrare 24-48 ore

74,22Lei

Husa pentru 1 Lanseta + Mulineta Daiwa 128cm

Husa pentru 1 Lanseta + Mulineta Daiwa 128cm

d.15812.240

Livrare 24-48 ore

115,42Lei

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

147,15Lei

Lingurita Oscilanta Daiwa Presso MVR, Neon Glow, 2.8cm, 2.4g

Lingurita Oscilanta Daiwa Presso MVR, Neon Glow, 2.8cm, 2.4g

f.d15442.129

Livrare 24-48 ore

32,28Lei

Afişare 1401 - 1420 din 1597 (80 pagini)

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

1 (0.080)

SELECT data
FROM `oc_session`
WHERE session_id = '33f848d76131f4367300344764'

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

2 (0.116)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.136)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.133)

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

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

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

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

7 (0.153)

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