DAM

DAM

Sortare după:

Mulineta DAM Quick 3 3000 FS

Mulineta DAM Quick 3 3000 FS

svs60872

Livrare 7-14 zile

356,24Lei

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

svs70890

Livrare imediată!

315,00Lei

Conector Magnetic DAM Minciog Cablu Siguranta

Conector Magnetic DAM Minciog Cablu Siguranta

svs8420222

Livrare 7-14 zile

55,00Lei

Fir Fluorocarbon Damyl Tectan Superior 0.14mm 25m 1.8kg

Fir Fluorocarbon Damyl Tectan Superior 0.14mm 25m 1.8kg

11100960626

Livrare imediată!

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

Momitor DAM Detek Pellet Feeder Inline 35g

Momitor DAM Detek Pellet Feeder Inline 35g

a.dam.66033

Livrare 48-72ore

13,86Lei(-50%) 6,93Lei

Mulineta Dam Quick Panthera FD 4000s

Mulineta Dam Quick Panthera FD 4000s

svs73006

Livrare imediată!

194,90Lei(-53%) 92,20Lei

Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.50mm, 22.7kg/50lb, 100m

Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.50mm, 22.7kg/50lb, 100m

a.dam.66198

Livrare 24-48 ore

32,15Lei

Mulineta DAM RUnshift 6 6000S BF, 0.33mm-300m, 5.1:1, 5+1BB

Mulineta DAM RUnshift 6 6000S BF, 0.33mm-300m, 5.1:1, 5+1BB

dam.73050

Livrare 24-48 ore

235,72Lei(-20%) 188,56Lei

Combo Spinning DAM Fun Tech MK1 Spin, Lanseta 2.40m/15-40g + Mulineta 4000/2+1rul

Combo Spinning DAM Fun Tech MK1 Spin, Lanseta 2.40m/15-40g + Mulineta 4000/2+1rul

dam.80898

Livrare imediată!

321,01Lei

Lanseta DAM Yagi V2 Spin MH, 12-42g, 2.74m, 2seg

Lanseta DAM Yagi V2 Spin MH, 12-42g, 2.74m, 2seg

1619294

Livrare 7-14 zile

266,00Lei

Lanseta DAM Impulse X Feeder, 25-75g, 3.30m, 3+3seg

Lanseta DAM Impulse X Feeder, 25-75g, 3.30m, 3+3seg

1619238

Livrare 7-14 zile

278,00Lei

Combo DAM Full Tech Multi-Picker 10FT 3000, 10-50g, 3.00, 2+3seg

Combo DAM Full Tech Multi-Picker 10FT 3000, 10-50g, 3.00, 2+3seg

1608900

Livrare 7-14 zile

161,00Lei

Cizme DAM Flex Rubber Boots Neoprene, Nr. 45

Cizme DAM Flex Rubber Boots Neoprene, Nr. 45

svs8739245

Livrare 7-14 zile

335,00Lei

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 46

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 46

svs8739246

Livrare imediată!

335,00Lei

Lingura Oscilanata DAM Effzett Standard Spoon, Gold, 10cm, 60g, 1buc/pac

Lingura Oscilanata DAM Effzett Standard Spoon, Gold, 10cm, 60g, 1buc/pac

svs5021060

Livrare 7-14 zile

33,00Lei

Fir Monofilament Pastrav DAM Damyl New Spezi Line Trout 0.20mm, 3.20kg, 500m

Fir Monofilament Pastrav DAM Damyl New Spezi Line Trout 0.20mm, 3.20kg, 500m

a.dam.66630

Livrare imediată!

20,83Lei

Momitor DAM Detek Pellet Feeder Elasticated 25g

Momitor DAM Detek Pellet Feeder Elasticated 25g

a.dam.66029

Livrare 24-48 ore

13,61Lei(-30%) 9,52Lei

Mulineta DAM Quick Dynabraid 4 4000 FD cu Fir Textil 15Lb

Mulineta DAM Quick Dynabraid 4 4000 FD cu Fir Textil 15Lb

svs73003

Livrare 7-14 zile

204,00Lei

Fir Monofilament Damyl Spezi Line Salau Light Brown, 0.28mm, 6.7kg, 450m

Fir Monofilament Damyl Spezi Line Salau Light Brown, 0.28mm, 6.7kg, 450m

a.dam.66634

Livrare imediată!

20,83Lei

Mulineta DAM QUICK IMPULSE 4QF 2500S

Mulineta DAM QUICK IMPULSE 4QF 2500S

svs72998

Livrare imediată!

160,00Lei

Afişare 301 - 320 din 1084 (55 pagini)

Queries: 8, Total time: 100.242 ms [By time] [By id] [By file]

1 (0.120)

SELECT data
FROM `oc_session`
WHERE session_id = '2bdc3379fb2877f509d3520de1'

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

2 (0.096)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.142)

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

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

4 (0.104)

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

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

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 300,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.112)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

8 (0.093)

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