Daiwa

Daiwa

Sortare după:

Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

Lanseta Spinning Daiwa Crossfire 240H 2.40m, 14-42g, 2seg

d.cf240haf

Livrare 24-48 ore

211,19Lei

Mulineta Daiwa 24 TDR 3012QD, 4.8:1, 0.28mm/150m, 8+1rul

Mulineta Daiwa 24 TDR 3012QD, 4.8:1, 0.28mm/150m, 8+1rul

d.10516.312

Livrare 24-48 ore

1.442,24Lei

Montura DAIWA PX Screw-In Shallow Rig Nr.3/0+2/0

Montura DAIWA PX Screw-In Shallow Rig Nr.3/0+2/0

a.15419.730

Livrare 24-48 ore

28,50Lei

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul

d.10131.501

Livrare imediată!

646,29Lei(-10%) 582,66Lei

Husa DAIWA D-VEC, 3 Compartimente, Grey, 130cm

Husa DAIWA D-VEC, 3 Compartimente, Grey, 130cm

a8.15841.130

Livrare 24-48 ore

278,13Lei

Shad DAIWA Prorex Belly, Ghost Firetiger, 11cm, 12g, 4buc/pac

Shad DAIWA Prorex Belly, Ghost Firetiger, 11cm, 12g, 4buc/pac

d.15320.314

Livrare 24-48 ore

35,39Lei

Fir Monofilament Daiwa J-Threads, Pink, 5.10kg, 0.26mm, 600m

Fir Monofilament Daiwa J-Threads, Pink, 5.10kg, 0.26mm, 600m

d.12225.126

Livrare imediată!

51,22Lei

Maner Minciog DAIWA Prorex Stalker Multi Adjust Tele Handle, 2.50m, 5seg

Maner Minciog DAIWA Prorex Stalker Multi Adjust Tele Handle, 2.50m, 5seg

a2.15810.250

Livrare imediată!

261,95Lei

MULINETA DAIWA EMBLEM SPOD 35SCW QD

MULINETA DAIWA EMBLEM SPOD 35SCW QD

d.10158.606

Livrare 24-48 ore

827,25Lei(-8%) 763,59Lei

Lanseta DAIWA Airity Hybrid Spin Ultra Fast, 2.15m, 3-10g, 2seg

Lanseta DAIWA Airity Hybrid Spin Ultra Fast, 2.15m, 3-10g, 2seg

d.11930.210

Livrare 24-48 ore

1.397,25Lei(-13%) 1.221,16Lei

Lanseta DAIWA Prorex XR Spin 2.40m, 18-84g, 2seg

Lanseta DAIWA Prorex XR Spin 2.40m, 18-84g, 2seg

d.11332.242

Livrare 24-48 ore

886,53Lei

Tricou DAIWA D Old Shirt Short Sleeve 31, Dark Gray, Marime M

Tricou DAIWA D Old Shirt Short Sleeve 31, Dark Gray, Marime M

d.21sshirt31dgm

Livrare 24-48 ore

122,08Lei

Mulineta Spinning DAIWA RS 2000, 5.1:1, 0.10mm/200m, 3+1rul

Mulineta Spinning DAIWA RS 2000, 5.1:1, 0.10mm/200m, 3+1rul

d.rs2000

Livrare 24-48 ore

106,59Lei

Fir Monofilament DAIWA Tournament SF, Grey, 300m, 0.20mm, 3.5kg

Fir Monofilament DAIWA Tournament SF, Grey, 300m, 0.20mm, 3.5kg

d.12205.320

Livrare 24-48 ore

30,60Lei

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.36mm 11.10kg

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.36mm 11.10kg

d.12200.336

Livrare 24-48 ore

38,45Lei

LINGURITA DAIWA ROTATIVA 3G SILVER GREEN

LINGURITA DAIWA ROTATIVA 3G SILVER GREEN

d.07410884

Livrare 24-48 ore

23,66Lei(-14%) 20,24Lei

Galeata Daiwa +Capac Advantage 18 L

Galeata Daiwa +Capac Advantage 18 L

a.13305.300

Livrare imediată!

119,64Lei(-18%) 98,34Lei

LANSETA DAIWA TOURNAMENT AGS ULTRAFAST 2.20M, 3.5-14G, 2SEG

LANSETA DAIWA TOURNAMENT AGS ULTRAFAST 2.20M, 3.5-14G, 2SEG

d.11117.220

Livrare imediată!

2.137,01Lei(-22%) 1.672,53Lei

Mulineta Daiwa Crossfire LT 2500 4BS A

Mulineta Daiwa Crossfire LT 2500 4BS A

d.10186.250

Livrare 24-48 ore

241,37Lei(-17%) 199,27Lei

Lanseta Spinning Daiwa Tele Sweepfire 2.10m, 10-30g, 6seg

Lanseta Spinning Daiwa Tele Sweepfire 2.10m, 10-30g, 6seg

d.11421.211

Livrare imediată!

171,24Lei

Afişare 481 - 500 din 1558 (78 pagini)

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

1 (0.109)

SELECT data
FROM `oc_session`
WHERE session_id = '62de3397e628690389ea92fc53'

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

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

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

4 (0.090)

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

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

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

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

7 (0.185)

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