DAM

DAM

Sortare după:

Lanseta DAM Madcat White Clonk Teaser, 2.40m, 1200-250g, 2seg

Lanseta DAM Madcat White Clonk Teaser, 2.40m, 1200-250g, 2seg

mad.1604091

Livrare 24-48 ore

560,94Lei

Mulineta DAM Madcat Dominion Spinning 5500, 0.28mm/390m, 5.6:1, 6+1rul

Mulineta DAM Madcat Dominion Spinning 5500, 0.28mm/390m, 5.6:1, 6+1rul

mad.1610430

Livrare 24-48 ore

696,11Lei

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

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

1625226

Livrare 7-14 zile

266,00Lei

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

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

1608898

Livrare 7-14 zile

142,00Lei

Manusi DAM Neoprene Fighter Glove L, Black Gray

Manusi DAM Neoprene Fighter Glove L, Black Gray

svs76515

Livrare 7-14 zile

65,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, 10cm, 60g, 1buc/pac

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

svs5021060

Livrare 7-14 zile

33,00Lei

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

4200466039

Livrare imediată!

26,33Lei

Lanseta DAM Imax Boat 2.10m XH 150-450gr

Lanseta DAM Imax Boat 2.10m XH 150-450gr

svs70604

Livrare 7-14 zile

276,09Lei

Lanseta Spinning DAM Aqua-X Shad Pilk MF 2.70m, 50-150g, 2seg

Lanseta Spinning DAM Aqua-X Shad Pilk MF 2.70m, 50-150g, 2seg

dam.66270

Livrare imediată!

164,01Lei(-19%) 132,10Lei

Set Avertizoare DAM Madcat Smart Mcl 4+1

Set Avertizoare DAM Madcat Smart Mcl 4+1

a.mad.70841

Livrare 24-48 ore

1.324,30Lei

Mulineta DAM QUICK IMPRESSA 4S 3000

Mulineta DAM QUICK IMPRESSA 4S 3000

svs72994

Livrare imediată!

160,00Lei

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 42

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 42

svs8739242

Livrare imediată!

335,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

Afişare 401 - 420 din 1072 (54 pagini)

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

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = '2527075544b07dbc9aefc7ba00'

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

2 (0.091)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.110)

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

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

4 (0.105)

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

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

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

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

7 (0.175)

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