DAM

DAM

Sortare după:

Fir DAM Damyl New Spezi Line Coarse Transparent, 2.80kg, 0.18mm, 500m

Fir DAM Damyl New Spezi Line Coarse Transparent, 2.80kg, 0.18mm, 500m

11070966643

Livrare imediată!

24,24Lei

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.15mm 150m

Fir textil DAM Crosspower 4 Braid 0.15mm 150m

11020966577

Livrare imediată!

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

Kit DAM Feeder Detek Method L, 50+80g, 2+1buc/pac

a.dam.66024

Livrare imediată!

57,57Lei

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 Impulse 4OTT 4000 Feed / Match 2XGRAPH, 0.25mm-100m, 5.2:1, 3+1BB

Mulineta DAM Impulse 4OTT 4000 Feed / Match 2XGRAPH, 0.25mm-100m, 5.2:1, 3+1BB

dam.73074

Livrare 24-48 ore

229,82Lei

Lanseta, DAM, Yagi, Spin, F,, 2.59m,, 12-42g,, 2seg, dam.60038, Lansete Rapitori, Lansete Rapitori DAM, DAM

Lanseta, DAM, Yagi, Spin, F,, 2.59m,, 12-42g,, 2seg, dam.60038, Lansete Rapitori, Lansete Rapitori DAM, DAM

dam.60038

Livrare 24-48 ore

271,86Lei

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB

dam.73049

Livrare 24-48 ore

216,52Lei(-20%) 173,20Lei

Montura DAM Madcat Profi River Rig Noseclip, Nr.3/0, 1.3mm, 250cm

Montura DAM Madcat Profi River Rig Noseclip, Nr.3/0, 1.3mm, 250cm

a.mad.1604099

Livrare imediată!

76,91Lei

Fir DAM Damyl New Spezi Line Trout 0.18mm 500m

Fir DAM Damyl New Spezi Line Trout 0.18mm 500m

11070966629

Livrare imediată!

24,24Lei

Momitor DAM Detek Pellet Feeder Elasticated 15g

Momitor DAM Detek Pellet Feeder Elasticated 15g

a.dam.66028

Livrare 24-48 ore

12,83Lei(-30%) 8,98Lei

Mulineta, DAM, Quick, Nova, FS, 5000, dam.75968, 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, Nova, FS, 5000, dam.75968, 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.75968

Livrare 24-48 ore

107,77Lei

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

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

2050970375

Livrare imediată!

147,16Lei

Lanseta Spinning DAM Tele Nova Exped 2.40m, 20-40g, 6seg

Lanseta Spinning DAM Tele Nova Exped 2.40m, 20-40g, 6seg

dam.75554

Livrare imediată!

71,76Lei

Set Avertizoare DAM Madcat Smart Mcl 4+1

Set Avertizoare DAM Madcat Smart Mcl 4+1

a.mad.70841

Livrare imediată!

1.464,14Lei

Mulineta DAM QUICK FUN-TECH 3 MK1 2500 FD

Mulineta DAM QUICK FUN-TECH 3 MK1 2500 FD

dam.72975

Livrare imediată!

137,83Lei

Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.45mm, 18.1kg/40lb, 100m

Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.45mm, 18.1kg/40lb, 100m

a.dam.66197

Livrare imediată!

32,80Lei

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

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

dam.66275

Livrare 24-48 ore

164,01Lei

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

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

Queries: 7, Total time: 84.515 ms [By time] [By id] [By file]

1 (0.134)

SELECT data
FROM `oc_session`
WHERE session_id = 'bec1281ae50e453de4aafe8678'

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

2 (0.094)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.123)

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

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

4 (0.127)

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 (35.113)

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 (48.792)

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

7 (0.132)

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