DAM

DAM

Sortare după:

Lanseta Telescopica DAM Steelhead Iconic Tele Spin, 1.80m, 2-12g, 5seg

Lanseta Telescopica DAM Steelhead Iconic Tele Spin, 1.80m, 2-12g, 5seg

svs75528

Livrare 7-14 zile

134,20Lei

Fir DAM Damyl New Spezi Line Zander 0.30mm 400m

Fir DAM Damyl New Spezi Line Zander 0.30mm 400m

11050966635

Livrare 48-72 ore

24,24Lei(-36%) 15,44Lei

Mulineta DAM Quick 2 6000 FD V2

Mulineta DAM Quick 2 6000 FD V2

svs75982

Livrare imediată!

204,36Lei

Lanseta Spinning DAM Tele Nova Exped 2.40m, 20-40g, 6seg

Lanseta Spinning DAM Tele Nova Exped 2.40m, 20-40g, 6seg

svs75554

Livrare imediată!

87,43Lei

Mulineta DAM Quick Insider 7 FD 2500S

Mulineta DAM Quick Insider 7 FD 2500S

svs73012

Livrare imediată!

221,65Lei

Suport DAM Salt-X pentri 1 Lanseta, Ajustabil, 75cm

Suport DAM Salt-X pentri 1 Lanseta, Ajustabil, 75cm

svs52810

Livrare 7-14 zile

74,21Lei

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB

svs73049

Livrare imediată!

208,43Lei

Lanseta DAM Yagi V2 Spin MH, 12-42g, 2.74m, 2seg

Lanseta DAM Yagi V2 Spin MH, 12-42g, 2.74m, 2seg

1619294

Livrare 7-14 zile

271,48Lei

Mulineta DAM Impressa 3 Reel 2500 FD 2+1BB

Mulineta DAM Impressa 3 Reel 2500 FD 2+1BB

svs72981

Livrare imediată!

117,93Lei

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.00m, 7seg

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.00m, 7seg

svs70356

Livrare 7-14 zile

262,32Lei

Lanseta Telescopica DAM New Shadow Mini Spin 2.10m 5-15g 8seg

Lanseta Telescopica DAM New Shadow Mini Spin 2.10m 5-15g 8seg

svs70792

Livrare 7-14 zile

217,58Lei

Lanseta DAM Base-X Spin 2.10m 10-30g

Lanseta DAM Base-X Spin 2.10m 10-30g

svs70368

Livrare 7-14 zile

96,58Lei

Lanseta DAM Madcat White Spin 2.85m 175gr

Lanseta DAM Madcat White Spin 2.85m 175gr

2033156876

Livrare imediată!

657,61Lei(-25%) 489,98Lei

Avertizor Electronic DAM Madcat Topcat Red

Avertizor Electronic DAM Madcat Topcat Red

svs707630001

Livrare 7-14 zile

409,75Lei

Mulineta DAM QUICK IMPRESSA 4S 2500S

Mulineta DAM QUICK IMPRESSA 4S 2500S

svs72993

Livrare imediată!

159,62Lei

Combo Spinning DAM Fun Tech MK1 Spin, Lanseta 2.10m/10-30g + Mulineta 3000/2+1rul

Combo Spinning DAM Fun Tech MK1 Spin, Lanseta 2.10m/10-30g + Mulineta 3000/2+1rul

dam.80897

Livrare 24-48 ore

310,78Lei

Mulineta DAM Madcat Dominion Spinning 10500, 0.56mm/395m, 4.2:1, 6+1rul

Mulineta DAM Madcat Dominion Spinning 10500, 0.56mm/395m, 4.2:1, 6+1rul

mad.1610433

Livrare 24-48 ore

831,45Lei

Set Varfuri DAM Impulse-X Feeder Tips Kit4, 125-200g, 3buc/pac

Set Varfuri DAM Impulse-X Feeder Tips Kit4, 125-200g, 3buc/pac

1633267

Livrare 7-14 zile

87,43Lei

Lingurita Rotativa DAM Effzett Tandem Dressed, Silver Red, 10g, 1buc/pac

Lingurita Rotativa DAM Effzett Tandem Dressed, Silver Red, 10g, 1buc/pac

svs5115010

Livrare 7-14 zile

24,39Lei

Costum DAM Xtherm Winter Suit, Green, Masura XL

Costum DAM Xtherm Winter Suit, Green, Masura XL

svs60123

Livrare 7-14 zile

615,15Lei

Afişare 301 - 320 din 866 (44 pagini)

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

1 (0.115)

SELECT data
FROM `oc_session`
WHERE session_id = '5c564845632fe1c7d23adc4e12'

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

2 (0.085)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.118)

SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'

/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 = '124' AND m2s.store_id = '3'

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

5 (38.456)

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

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

6 (59.361)

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 = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 300,20

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

7 (0.192)

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