DAM

DAM

Sortare după:

Oscilanata DAM Effzett Twin Spinner Spoon, Cooper Cooper, 10cm, 60g, 1buc/pac

Oscilanata DAM Effzett Twin Spinner Spoon, Cooper Cooper, 10cm, 60g, 1buc/pac

svs5018260

Livrare 7-14 zile

38,00Lei

Lanseta DAM Steelhead Iconic Spin, 5-20g, 2.10m, 2seg

Lanseta DAM Steelhead Iconic Spin, 5-20g, 2.10m, 2seg

svs75519

Livrare 7-14 zile

131,00Lei

Lingura Oscilanata DAM Effzett Standard Spoon, Gold, 8cm, 45g, 1buc/pac

Lingura Oscilanata DAM Effzett Standard Spoon, Gold, 8cm, 45g, 1buc/pac

svs5021045

Livrare 7-14 zile

25,00Lei

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

a.dam.66626

Livrare imediată!

20,83Lei

Momitor DAM Detek Pellet Feeder Elasticated 35g

Momitor DAM Detek Pellet Feeder Elasticated 35g

a.dam.66030

Livrare 24-48 ore

10,73Lei(-30%) 7,51Lei

Mulineta DAM Quick Insider 7 3000S FD

Mulineta DAM Quick Insider 7 3000S FD

svs73013

Livrare 7-14 zile

225,01Lei

Avertizor Electronic DAM Madcat Topcat Blue

Avertizor Electronic DAM Madcat Topcat Blue

svs707630003

Livrare 7-14 zile

402,01Lei

Mulineta DAM QUICK FUN-TECH 3 MK1 1000 FD

Mulineta DAM QUICK FUN-TECH 3 MK1 1000 FD

dam.72974

Livrare imediată!

124,13Lei

Minciog Barca DAM Floating 1seg, 50x34x28cm, 18cm

Minciog Barca DAM Floating 1seg, 50x34x28cm, 18cm

svs56853

Livrare imediată!

94,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(-30%) 95,69Lei

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

Mulineta DAM Quick Dynabraid 4 1000 FD 0.20mm/220m, 5.2:1, 3+1BB + Fir Textil

Mulineta DAM Quick Dynabraid 4 1000 FD 0.20mm/220m, 5.2:1, 3+1BB + Fir Textil

svs78881

Livrare 7-14 zile

184,00Lei

Combo Dam Lanseta Spinning Silure Alround, 3.00m, 200-400g, 8000/2Rul

Combo Dam Lanseta Spinning Silure Alround, 3.00m, 200-400g, 8000/2Rul

dam.1617953

Livrare 24-48 ore

864,45Lei

Lanseta DAM Impulse X Feeder, 150-200g, 3.90m, 3+3seg

Lanseta DAM Impulse X Feeder, 150-200g, 3.90m, 3+3seg

1619247

Livrare 7-14 zile

339,00Lei

Mulineta DAM Runshift 3 5000 FS Carp Reel

Mulineta DAM Runshift 3 5000 FS Carp Reel

svs73033

Livrare imediată!

131,00Lei

Man Gloves DAM Windproof Half Finger XL, Black

Man Gloves DAM Windproof Half Finger XL, Black

svs76513

Livrare 7-14 zile

84,61Lei(-20%) 67,69Lei

Lanseta Telescopica DAM Steelhead Iconic Tele Spin, 2.40m, 7-28g, 5seg

Lanseta Telescopica DAM Steelhead Iconic Tele Spin, 2.40m, 7-28g, 5seg

svs75531

Livrare 7-14 zile

168,00Lei

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

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

svs70893

Livrare imediată!

376,00Lei

Mulineta DAM RUNSHIFT 4 6000S BF

Mulineta DAM RUNSHIFT 4 6000S BF

svs73046

Livrare imediată!

176,00Lei

Fir Textil DAM CrossPower 8x Dark Grey, 0.20mm, 12.6kg, 150m

Fir Textil DAM CrossPower 8x Dark Grey, 0.20mm, 12.6kg, 150m

a.dam.66590

Livrare 24-48 ore

78,58Lei(-40%) 47,14Lei

Afişare 381 - 400 din 1084 (55 pagini)

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

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = '4ae5d8631d43680a16ee416372'

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

2 (0.103)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.106)

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

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

4 (0.109)

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.509)

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

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

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

7 (0.110)

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