DAM


Lanseta DAM Salt-X SW Spin 2.15m/5-25g

Lanseta DAM Salt-X SW Spin 2.15m/5-25g

2040956826
Livrare imediată!

224,76Lei

Lanseta DAM Nanoflex Pro+ 2.10m 10-30g

Lanseta DAM Nanoflex Pro+ 2.10m 10-30g

2040970268
Livrare 48-72 ore

245,43Lei

Mulineta, DAM, Quick, Impressa, 3, FD, 3000, dam.72982, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, Mulinete Bolognese, Mulinete Bolognese D.A.M, Mulinete D.A.M, Bolognese 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
Lanseta DAM Madcat White Spin 2.70m 175gr

Lanseta DAM Madcat White Spin 2.70m 175gr

2033156875
Livrare 48-72 ore

542,47Lei

Mulineta DAM RUNSHIFT 3A 6000 BF -30%

Mulineta DAM RUNSHIFT 3A 6000 BF

dam.73042
Livrare imediată!

174,34Lei(-30%) 122,03Lei

Struna DAM Kink Free Titanium 20cm, 7kig, 2buc/pac

Struna DAM Kink Free Titanium 20cm, 7kig, 2buc/pac

a7.dam.56395
Livrare 24-48 ore

16,66Lei

Avertizor Electronic DAM Mini E-Motion G2 Green -26%

Avertizor Electronic DAM Mini E-Motion G2 Green

4230960243
Livrare imediată!

108,11Lei(-26%) 80,00Lei

Mulineta DAM Quick 2 5000 BF, 0.35mm-200m, 5.1:1, 5+1BB -30%

Mulineta DAM Quick 2 5000 BF, 0.35mm-200m, 5.1:1, 5+1BB

dam.75987
Livrare 24-48 ore

277,15Lei(-30%) 194,01Lei

Carlige, DAM, Madcat, A-Static, Teaser, Nr.7/0,, 4buc/pac, a.mad.56839, Carlige Somn, Carlige Somn DAM, Carlige DAM, Somn DAM, DAM
Fir, DAM, Damyl, New, Spezi, Line, Coarse, Transparent,, 2.80kg,, 0.18mm,, 500m, 11070966643, Fire Monofilament Crap, Fire Monofilament Crap DAM, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder DAM, Fire Monofilament Rapitori, Fire Monofilament Rapitori DAM, DAM
Lanseta DAM Shadow Tele 2.10m 25-40gr

Lanseta DAM Shadow Tele 2.10m 25-40gr

2040970347
Livrare imediată!

217,81Lei

Fir textil DAM Crosspower 4 Braid 0.17mm 150m

Fir textil DAM Crosspower 4 Braid 0.17mm 150m

11020966578
Livrare 48-72 ore

43,80Lei

Caciula DAM Polar Beanie Chili Pepper Red

Caciula DAM Polar Beanie Chili Pepper Red

8110973787
Livrare 48-72 ore

52,25Lei

Kit, DAM, Feeder, Detek, Method, , L,, 50+80g,, 2+1buc/pac, a.dam.66024, Kit-uri Method Feeder, Kit-uri Method Feeder DAM, Kit-uri DAM, Method DAM, Feeder DAM, DAM
Mulineta DAM Quick Darkside 8 FD 1000

Mulineta DAM Quick Darkside 8 FD 1000

dam.73024
Livrare imediată!

275,71Lei

Mulineta DAM QUICK IMPULSE 4QF 2500S

Mulineta DAM QUICK IMPULSE 4QF 2500S

dam.72998
Livrare imediată!

174,64Lei

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

dam.73061
Livrare imediată!

322,57Lei

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

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

dam.60037
Livrare 24-48 ore

257,79Lei

Mulineta, DAM, Runshift, 4, 4000S, BF,, 0.28mm-215m,, 5.2:1,, 3+1BB, dam.73044, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M -20%
Montura, DAM, Madcat, Profi, River, Rig, Noseclip,, Nr.2/0,, 1.3mm,, 250cm, a.mad.1604098, Monturi Somn, Monturi Somn DAM, Monturi DAM, Somn DAM, DAM
Afişare 1 - 20 din 1125 (57 pagini)
Queries: 9, Total time: 94.751 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = '0c93ea226327d871a5b7f1fdad'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.122)
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
6 (40.731)
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:1650
7 (53.272)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.109)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.096)
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