DAM

DAM

Sortare după:

Lanseta DAM XT1 Spod & Marker 50mm 3.90m 2tr 5.00Lbs

Lanseta DAM XT1 Spod & Marker 50mm 3.90m 2tr 5.00Lbs

dam.70893

Livrare imediată!

408,52Lei

Fir, Fluorocarbon, Damyl, Tectan, Superior, 0.14mm, 25m, 1.8kg, 11100960626, Fire Monofilament Rapitori, Fire Monofilament Rapitori DAM, DAM

Fir, Fluorocarbon, Damyl, Tectan, Superior, 0.14mm, 25m, 1.8kg, 11100960626, Fire Monofilament Rapitori, Fire Monofilament Rapitori DAM, DAM

11100960626

Livrare imediată!

22,60Lei(-25%) 16,90Lei

Avertizor Electronic DAM B-Alert Bite Alarm

Avertizor Electronic DAM B-Alert Bite Alarm

a.dam.63616

Livrare imediată!

54,67Lei

Mulineta Dam Quick Darkside 8 FD 6000s

Mulineta Dam Quick Darkside 8 FD 6000s

dam.73029

Livrare imediată!

321,68Lei(-23%) 247,90Lei

Struna DAM Effzett Coated 1x7 Black, 30cm, 11kg. 2buc/pac

Struna DAM Effzett Coated 1x7 Black, 30cm, 11kg. 2buc/pac

a7.dam.56414

Livrare 24-48 ore

8,57Lei

Mulineta DAM Nova FD 7000 + Fir Monofilament, 0.40mm-337m, 4.1:1, 1BB

Mulineta DAM Nova FD 7000 + Fir Monofilament, 0.40mm-337m, 4.1:1, 1BB

dam.75960

Livrare 24-48 ore

112,46Lei

Lanseta DAM Yagi Spin F, 2.20m, 42-120g, 2seg

Lanseta DAM Yagi Spin F, 2.20m, 42-120g, 2seg

dam.60044

Livrare 24-48 ore

257,79Lei

Mulineta DAM Shadow 7 8000 SLS BF/ 0.35MM-550M, 4.1:1, 6+1BB

Mulineta DAM Shadow 7 8000 SLS BF/ 0.35MM-550M, 4.1:1, 6+1BB

dam.73057

Livrare 24-48 ore

562,01Lei(-30%) 393,40Lei

Lanseta DAM Madcat Green Vertical 1.80m, 150-250g, 1seg

Lanseta DAM Madcat Green Vertical 1.80m, 150-250g, 1seg

mad.1604084

Livrare 24-48 ore

513,16Lei

Lanseta DAM Yagi Light Spoon 1.90m 2-5g

Lanseta DAM Yagi Light Spoon 1.90m 2-5g

dam.70662

Livrare 24-48 ore

210,93Lei

Mulineta, DAM, Quick, 2, 3000, FD, V2, dam.75979, 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

Mulineta, DAM, Quick, 2, 3000, FD, V2, dam.75979, 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

dam.75979

Livrare 24-48 ore

197,67Lei(-20%) 158,13Lei

Fir, Monofilament, Damyl, Spezi, Line, Feeder, Dark, Brown,, 0.18mm,, 2.8kg,, 500m, a.dam.66636, Fire Monofilament Crap, Fire Monofilament Crap DAM, DAM

Fir, Monofilament, Damyl, Spezi, Line, Feeder, Dark, Brown,, 0.18mm,, 2.8kg,, 500m, a.dam.66636, Fire Monofilament Crap, Fire Monofilament Crap DAM, DAM

a.dam.66636

Livrare imediată!

20,83Lei

Mulineta, DAM, QUICK, FUN-TECH, 3, MK1, 5000, FD, dam.72979, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M

Mulineta, DAM, QUICK, FUN-TECH, 3, MK1, 5000, FD, dam.72979, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M

dam.72979

Livrare imediată!

160,88Lei

Fir, Monofilament, Inaintas, DAM, Tectan, Soft, Leader, Transparent,, 0.70mm,, 36.2kg/80lb,, 100m, a.dam.66200, Fire Monofilament Inaintas, Fire Monofilament Inaintas DAM, Fire DAM, Monofilament DAM, Inaintas DAM, DAM

Fir, Monofilament, Inaintas, DAM, Tectan, Soft, Leader, Transparent,, 0.70mm,, 36.2kg/80lb,, 100m, a.dam.66200, Fire Monofilament Inaintas, Fire Monofilament Inaintas DAM, Fire DAM, Monofilament DAM, Inaintas DAM, DAM

a.dam.66200

Livrare 24-48 ore

32,80Lei

Lanseta DAM Imax Boat Quiver 2.10m, 250g, 2+2seg

Lanseta DAM Imax Boat Quiver 2.10m, 250g, 2+2seg

dam.70634

Livrare 24-48 ore

306,29Lei

Lanseta DAM Yagi Classic Spin F, 2.10m, 10-30g, 2seg

Lanseta DAM Yagi Classic Spin F, 2.10m, 10-30g, 2seg

dam.65915

Livrare 24-48 ore

256,55Lei

Mulineta DAM Quick Finessa 8 5000S FD, 0.33mm-230m, 5.1:1, 7+1BB

Mulineta DAM Quick Finessa 8 5000S FD, 0.33mm-230m, 5.1:1, 7+1BB

dam.73021

Livrare 24-48 ore

281,07Lei

Fir, DAM, Damyl, New, Spezi, Line, Zander, 0.28mm, 450m, 11050966634, Fire Monofilament Rapitori, Fire Monofilament Rapitori DAM, DAM

Fir, DAM, Damyl, New, Spezi, Line, Zander, 0.28mm, 450m, 11050966634, Fire Monofilament Rapitori, Fire Monofilament Rapitori DAM, DAM

11050966634

Livrare imediată!

24,24Lei

Kit DAM Detek Method Feeder 2+1 M

Kit DAM Detek Method Feeder 2+1 M

4190466023

Livrare imediată!

49,83Lei

Lanseta DAM Base-X Spin 2.40 20-40g

Lanseta DAM Base-X Spin 2.40 20-40g

dam.70369

Livrare 24-48 ore

104,80Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 1125 (57 pagini)

Queries: 9, Total time: 84.704 ms [By time] [By id] [By file]

1 (0.148)

SELECT data
FROM `oc_session`
WHERE session_id = '643ad023725d78015feeab5c24'

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

2 (0.142)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.102)

SELECT `trigger`, `action`
FROM oc_event

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

4 (0.132)

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

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

5 (0.202)

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

6 (34.472)

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:1650

7 (49.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 = '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:432

8 (0.119)

SELECT *
FROM oc_platforma_promovari

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

9 (0.115)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38