DAM


Lanseta DAM Imax Boat 2.10m XH 150-450gr

Lanseta DAM Imax Boat 2.10m XH 150-450gr

svs70604
Livrare 7-14 zile

276,09Lei

Lanseta Spinning DAM Aqua-X Shad Pilk MF 2.70m, 50-150g, 2seg -19%

Lanseta Spinning DAM Aqua-X Shad Pilk MF 2.70m, 50-150g, 2seg

dam.66270
Livrare imediată!

164,01Lei(-19%) 132,10Lei

Set Avertizoare DAM Madcat Smart Mcl 4+1

Set Avertizoare DAM Madcat Smart Mcl 4+1

a.mad.70841
Livrare 24-48 ore

1.324,30Lei

Mulineta DAM QUICK IMPRESSA 4S 3000

Mulineta DAM QUICK IMPRESSA 4S 3000

svs72994
Livrare imediată!

160,00Lei

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 42

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 42

svs8739242
Livrare imediată!

335,00Lei

Mulineta DAM DarkSide 4B Spod FD 7000S cu 200m Fir Textil de 30lb, 5.1:1, 3+1BB

Mulineta DAM DarkSide 4B Spod FD 7000S cu 200m Fir Textil de 30lb, 5.1:1, 3+1BB

svs73061
Livrare imediată!

306,00Lei

Mulineta DAM Quick 3 4000 BF, 0.25mm-340m, 5.2:1, 9+1BB -30%

Mulineta DAM Quick 3 4000 BF, 0.25mm-340m, 5.2:1, 9+1BB

dam.60873
Livrare 24-48 ore

322,41Lei(-30%) 226,58Lei

Lanseta DAM Madcat White Clonk Teaser, 2.40m, 1200-250g, 2seg

Lanseta DAM Madcat White Clonk Teaser, 2.40m, 1200-250g, 2seg

mad.1604091
Livrare 24-48 ore

560,94Lei

Mulineta DAM Madcat Dominion Spinning 5500, 0.28mm/390m, 5.6:1, 6+1rul

Mulineta DAM Madcat Dominion Spinning 5500, 0.28mm/390m, 5.6:1, 6+1rul

mad.1610430
Livrare 24-48 ore

696,11Lei

Lanseta DAM Impulse X Feeder, 25-75g, 3.00m, 3+3seg

Lanseta DAM Impulse X Feeder, 25-75g, 3.00m, 3+3seg

1625226
Livrare 7-14 zile

266,00Lei

Combo DAM Full Tech Multi-Picker 8FT 3000, 10-50g, 2.44, 2+3seg

Combo DAM Full Tech Multi-Picker 8FT 3000, 10-50g, 2.44, 2+3seg

1608898
Livrare 7-14 zile

142,00Lei

Manusi DAM Neoprene Fighter Glove L, Black Gray

Manusi DAM Neoprene Fighter Glove L, Black Gray

svs76515
Livrare 7-14 zile

65,00Lei

Oscilanata DAM Effzett Twin Spinner Spoon, Silver Cooper, 10cm, 60g, 1buc/pac

Oscilanata DAM Effzett Twin Spinner Spoon, Silver Cooper, 10cm, 60g, 1buc/pac

svs5017060
Livrare 7-14 zile

38,00Lei

Lanseta DAM Steelhead Iconic Spin, 8-25g, 2.28m, 2seg

Lanseta DAM Steelhead Iconic Spin, 8-25g, 2.28m, 2seg

svs75525
Livrare 7-14 zile

156,00Lei

Lingura Oscilanata DAM Effzett Standard Spoon, Gold, 8cm, 45g, 1buc/pac

Lingura Oscilanata DAM Effzett Standard Spoon, Gold, 8cm, 45g, 1buc/pac

svs5021045
Livrare 7-14 zile

25,00Lei

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

4200466039
Livrare imediată!

26,33Lei

Lanseta DAM Madcat New Black Heavy Duty 2.40m 200-300gr

Lanseta DAM Madcat New Black Heavy Duty 2.40m 200-300gr

mad.70694
Livrare imediată!

282,52Lei

Mulineta DAM Quick 2 4000 FD V2 -30%

Mulineta DAM Quick 2 4000 FD V2

dam.75980
Livrare 24-48 ore

204,14Lei(-30%) 143,81Lei

Lanseta DAM Base-X Multipicker 2.70m 10-50gr

Lanseta DAM Base-X Multipicker 2.70m 10-50gr

2050970375
Livrare 48-72 ore

147,16Lei

Lanseta DAM Madcat White Spin 2.85m 175gr -27%

Lanseta DAM Madcat White Spin 2.85m 175gr

2033156876
Livrare imediată!

657,61Lei(-27%) 480,90Lei

Afişare 1 - 20 din 1073 (54 pagini)
Queries: 7, Total time: 109.467 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = 'af148f6f62874f8bb38bcb22d6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.105)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.106)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (55.864)
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 = '2' AND p.manufacturer_id = '124'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (53.087)
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 = '2' AND p.manufacturer_id = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.136)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37