DAM


Lanseta DAM Imax Spin Spinning Rod ML, 7-21g, 1.98m, 1+1seg

Lanseta DAM Imax Spin Spinning Rod ML, 7-21g, 1.98m, 1+1seg

svs70624
Livrare imediată!

239,94Lei

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.60m, 8seg

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.60m, 8seg

svs70362
Livrare 7-14 zile

286,00Lei

Agrafa Cu Vartej Swivel DAM Barrel, Nr.12, 8kg, 10buc/pac

Agrafa Cu Vartej Swivel DAM Barrel, Nr.12, 8kg, 10buc/pac

svs8109012
Livrare 7-14 zile

8,00Lei

Lanseta DAM Shadow Tele 2.10m 25-40gr

Lanseta DAM Shadow Tele 2.10m 25-40gr

2040970347
Livrare imediată!

217,81Lei

Mulineta DAM Quick 1 Pink FD 2000 -55%

Mulineta DAM Quick 1 Pink FD 2000

svs75951
Livrare 7-14 zile

174,89Lei(-55%) 77,90Lei

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

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

2040970368
Livrare imediată!

97,62Lei

Avertizor Electronic DAM B-Alert Bite Alarm

Avertizor Electronic DAM B-Alert Bite Alarm

svs63616
Livrare imediată!

51,00Lei

Mulineta DAM RUNSHIFT 3A 6000 BF

Mulineta DAM RUNSHIFT 3A 6000 BF

svs73042
Livrare imediată!

156,00Lei

Fir Textil DAM CrossPower 8x Dark Grey, 0.17mm, 11.3kg, 150m -40%

Fir Textil DAM CrossPower 8x Dark Grey, 0.17mm, 11.3kg, 150m

a.dam.66589
Livrare 24-48 ore

80,56Lei(-40%) 48,34Lei

Mulineta DAM Surf Shadow 5 7000 SLS, 0.33mm-500m, 4.1:1, 4+1BB

Mulineta DAM Surf Shadow 5 7000 SLS, 0.33mm-500m, 4.1:1, 4+1BB

dam.73062
Livrare 24-48 ore

323,09Lei

Varga Dam Tele Base-X, 3m

Varga Dam Tele Base-X, 3m

svs71041
Livrare imediată!

42,99Lei

Lanseta DAM Yagi V2 Spin MMH, 12-42g, 2.59m, 2seg

Lanseta DAM Yagi V2 Spin MMH, 12-42g, 2.59m, 2seg

1619293
Livrare 7-14 zile

245,00Lei

Combo DAM Full Tech Feeder 12FT 4000, Up To 90g, 3.60, 3+2seg

Combo DAM Full Tech Feeder 12FT 4000, Up To 90g, 3.60, 3+2seg

1608895
Livrare 7-14 zile

173,00Lei

Mulineta DAM Quick DunaBraid 4 3000 FD, 5.2:1, 0.25mm/205m, 3+1rul + Fir Textil

Mulineta DAM Quick DunaBraid 4 3000 FD, 5.2:1, 0.25mm/205m, 3+1rul + Fir Textil

dam.73002
Livrare 24-48 ore

198,77Lei

Mulineta DAM Nova Reel 4000 RD 1BB

Mulineta DAM Nova Reel 4000 RD 1BB

svs75964
Livrare 7-14 zile

57,00Lei

Lanseta Telescopica DAM Shadow Tele Mini Spin, 7-30g, 2.40m, 9seg

Lanseta Telescopica DAM Shadow Tele Mini Spin, 7-30g, 2.40m, 9seg

svs70794
Livrare imediată!

253,01Lei

Lingurita Rotativa DAM Effzett Fast Water Spinner, Silver, 10g

Lingurita Rotativa DAM Effzett Fast Water Spinner, Silver, 10g

svs66567
Livrare imediată!

17,99Lei

Oscilanta DAM EFFZETT Indicator Vehicle Scale, Silver Gold, 10cm, 60g, 1buc/pac

Oscilanta DAM EFFZETT Indicator Vehicle Scale, Silver Gold, 10cm, 60g, 1buc/pac

svs5019060
Livrare 7-14 zile

38,00Lei

Fir DAM Damyl New Spezi Line Zander 0.30mm 400m -41%

Fir DAM Damyl New Spezi Line Zander 0.30mm 400m

11050966635
Livrare imediată!

24,24Lei(-41%) 14,20Lei

Cosulet Feeder DAM Detek Flex Deschis cu Vartej, Marime L, 80g, 1buc/pac

Cosulet Feeder DAM Detek Flex Deschis cu Vartej, Marime L, 80g, 1buc/pac

4200466011
Livrare imediată!

19,64Lei

Afişare 1 - 20 din 1084 (55 pagini)
Queries: 7, Total time: 96.439 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = 'c53f8cab09eae1fd0df4a76ba7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.118)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (42.254)
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 = '0' AND p.manufacturer_id = '124'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (53.676)
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 = '0' 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.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37