DAM


Lanseta DAM Yagi Spin F, 2.10m, 12-42g, 2seg

Lanseta DAM Yagi Spin F, 2.10m, 12-42g, 2seg

dam.60036
Livrare 24-48 ore

234,36Lei

Mulineta DAM Runshift 3QF 5000 BF, 0.33mm-265m, 5.1:1, 2+1BB -30%

Mulineta DAM Runshift 3QF 5000 BF, 0.33mm-265m, 5.1:1, 2+1BB

dam.73038
Livrare 24-48 ore

163,63Lei(-30%) 114,53Lei

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

602,47Lei

Fir DAM Damyl New Spezi Line Feeder 5.60kg 0.25mm 500m

Fir DAM Damyl New Spezi Line Feeder 5.60kg 0.25mm 500m

11070966639
Livrare imediată!

24,24Lei

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

dam.70890
Livrare imediată!

351,50Lei

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

11020966575
Livrare 48-72 ore

46,68Lei

Mulineta DAM Quick 2 6000 FD V2 -20%

Mulineta DAM Quick 2 6000 FD V2

dam.75982
Livrare imediată!

217,02Lei(-20%) 173,61Lei

Saltea Receptie DAM Iconic Carp Mat Small 45x80cm

Saltea Receptie DAM Iconic Carp Mat Small 45x80cm

9050929111
Livrare 48-72 ore

63,86Lei

Kit DAM Feeder Detek Method S, 15+25g, 2+1buc/pac

Kit DAM Feeder Detek Method S, 15+25g, 2+1buc/pac

a.dam.66022
Livrare imediată!

39,87Lei

Mulineta, DAM, Quick, Insider, 7, FD, 4000S, , dam.73014, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, Mulinete Match, Mulinete Match D.A.M, Mulinete D.A.M, Match D.A.M, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M
Mulineta, DAM, QUICK, IMPULSE, 3L, 4000, dam.72973, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M
Lanseta cu Aplicatie Universala DAM Aqua X AllRound MF 2.10m, 100-170g, 2seg

Lanseta cu Aplicatie Universala DAM Aqua X AllRound MF 2.10m, 100-170g, 2seg

dam.66273
Livrare 24-48 ore

136,70Lei

Mulineta, DAM, Quick, Fahrenheit, 6, 5000, S, FD,, 0.33mm-230m,, 5.1:1,, 5+1BB, dam.73010, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M
Lanseta Dam Iconic Carp, 3.50lbs, 3.90m, 3seg

Lanseta Dam Iconic Carp, 3.50lbs, 3.90m, 3seg

dam.75847
Livrare imediată!

267,16Lei

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

a.dam.66626
Livrare imediată!

20,83Lei

Momitor DAM Detek Pellet Feeder Inline 25g -30%

Momitor DAM Detek Pellet Feeder Inline 25g

a.dam.66032
Livrare 24-48 ore

17,15Lei(-30%) 12,00Lei

Mulineta, DAM, Quick, 4, Trent, Centrepin, dam.75953, Mulinete Musca, Mulinete Musca D.A.M, Mulinete D.A.M, Musca D.A.M, D.A.M
Lanseta DAM Base-X Allround 3.00m 30-60g

Lanseta DAM Base-X Allround 3.00m 30-60g

2040970373
Livrare 48-72 ore

132,09Lei

Set Avertizoare Dam Madcat Smart MCL 2+1

Set Avertizoare Dam Madcat Smart MCL 2+1

a.mad.70839
Livrare imediată!

928,01Lei

Mulineta, DAM, Quick, Darkside, 4, 6000S, FD, dam.73058, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M -23%
Afişare 61 - 80 din 1121 (57 pagini)
Queries: 7, Total time: 86.785 ms [By time] [By id] [By file]
1 (0.134)
SELECT data
FROM `oc_session`
WHERE session_id = '10fa52f6121b6723536eeef7f8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.143)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.139)
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.137)
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:1667
6 (47.996)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38