DAM

DAM

Sortare după:

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

Lanseta DAM Madcat New Black Heavy Duty 2.40m 200-300gr

Lanseta DAM Madcat New Black Heavy Duty 2.40m 200-300gr

mad.70694

Livrare imediată!

282,52Lei

Mulineta DAM Quick 2 4000 FD V2

Mulineta DAM Quick 2 4000 FD V2

dam.75980

Livrare 24-48 ore

204,14Lei(-30%) 143,81Lei

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

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

2050970375

Livrare 48-72 ore

147,16Lei

Lanseta DAM Madcat White Spin 2.85m 175gr

Lanseta DAM Madcat White Spin 2.85m 175gr

2033156876

Livrare imediată!

657,61Lei(-27%) 480,90Lei

Mulineta DAM QUICK IMPULSE 3L 3000

Mulineta DAM QUICK IMPULSE 3L 3000

svs72972

Livrare imediată!

107,00Lei

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

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

dam.66273

Livrare imediată!

136,70Lei(-29%) 96,59Lei

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

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

dam.65918

Livrare 24-48 ore

270,59Lei(-30%) 189,41Lei

Combo Dam Lanseta Spinning Silure Vertical, 1.8m, 100-250g, 5000/2Rul

Combo Dam Lanseta Spinning Silure Vertical, 1.8m, 100-250g, 5000/2Rul

dam.1617952

Livrare 24-48 ore

673,21Lei

Lanseta DAM Impulse X Feeder, 50-100g, 3.90m, 3+3seg

Lanseta DAM Impulse X Feeder, 50-100g, 3.90m, 3+3seg

1619248

Livrare 7-14 zile

302,00Lei

Mulineta DAM Runshift 3 4000 FS Carp Reel

Mulineta DAM Runshift 3 4000 FS Carp Reel

svs73032

Livrare imediată!

123,00Lei

Combo DAM FP2 Boat TR 30Rhlw 0.50CMB, 20-30lbs, 1.80m, 2seg

Combo DAM FP2 Boat TR 30Rhlw 0.50CMB, 20-30lbs, 1.80m, 2seg

1608872

Livrare 7-14 zile

306,00Lei

Man Gloves DAM Windproof Half Finger M, Black

Man Gloves DAM Windproof Half Finger M, Black

svs76511

Livrare 7-14 zile

84,95Lei(-55%) 38,02Lei

Lanseta Telescopica DAM Steelhead Iconic Tele Spin, 2.40m, 6-18g, 5seg

Lanseta Telescopica DAM Steelhead Iconic Tele Spin, 2.40m, 6-18g, 5seg

svs75530

Livrare 7-14 zile

156,00Lei

Conector DAM Detek Shock Safe Bead Quick Change 5buc/pac

Conector DAM Detek Shock Safe Bead Quick Change 5buc/pac

a.dam.66006

Livrare imediată!

8,13Lei

Mulineta DAM Feeder Quick 1 4000FD

Mulineta DAM Feeder Quick 1 4000FD

3054673201

Livrare imediată!

149,62Lei

Lanseta DAM Madcat White Deluxe G2 2.75m, 150-350g, 2seg

Lanseta DAM Madcat White Deluxe G2 2.75m, 150-350g, 2seg

2033151833

Livrare imediată!

702,20Lei(-29%) 498,55Lei

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ă!

58,46Lei

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

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

a.dam.65850

Livrare 24-48 ore

157,81Lei(-49%) 79,80Lei

Afişare 361 - 380 din 1072 (54 pagini)

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

1 (0.110)

SELECT data
FROM `oc_session`
WHERE session_id = '3c72948fdc230eda8cb26315b4'

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

2 (0.090)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.097)

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

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

4 (0.103)

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

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

6 (50.212)

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 = '3' AND p.manufacturer_id = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 360,20

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

7 (0.125)

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

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