DAM

DAM

Sortare după:

Mulineta DAM DARKSIDE 4 8000S FD 3+1BB

Mulineta DAM DARKSIDE 4 8000S FD 3+1BB

svs73060

Livrare imediată!

245,00Lei

Avertizor Electronic DAM Nano Bite Blue

Avertizor Electronic DAM Nano Bite Blue

a.dam.52330

Livrare 24-48 ore

66,34Lei

Lanseta Telescopica DAM Imax Surf MF 3.90m, 100-250g, 4seg

Lanseta Telescopica DAM Imax Surf MF 3.90m, 100-250g, 4seg

svs70632

Livrare 7-14 zile

233,00Lei

Lanseta DAM Yagi Spin F, 2.10m, 7-28g, 2seg

Lanseta DAM Yagi Spin F, 2.10m, 7-28g, 2seg

dam.60035

Livrare 24-48 ore

234,36Lei(-20%) 188,39Lei

Lanseta DAM Madcat White Clonk Teaser, 1.80m, 100-150g, 2seg

Lanseta DAM Madcat White Clonk Teaser, 1.80m, 100-150g, 2seg

mad.1604089

Livrare 24-48 ore

501,17Lei

Suport Lanseta pentru Nisip DAM Madcat Sand Spike, 120cm

Suport Lanseta pentru Nisip DAM Madcat Sand Spike, 120cm

a6.mad.1610434

Livrare 24-48 ore

73,32Lei

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

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

1619242

Livrare 7-14 zile

278,00Lei

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

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

1608899

Livrare 7-14 zile

150,00Lei

Manusi DAM Neoprene Fighter Glove L, Black Gray

Manusi DAM Neoprene Fighter Glove L, Black Gray

svs76515

Livrare 7-14 zile

65,00Lei

Multiplicator DAM Quick 2 Bc 201 4 + 1Bb

Multiplicator DAM Quick 2 Bc 201 4 + 1Bb

svs65699

Livrare 7-14 zile

294,00Lei

Tambur Rezerva DAM Quick Shadow 7 FS 8000 SLS Spare Spool

Tambur Rezerva DAM Quick Shadow 7 FS 8000 SLS Spare Spool

svs73079

Livrare 7-14 zile

85,00Lei

Stinger DAM Effzett 7X7 Uncoated Stinger Silver Spinning System, Nr.6, 8cm, 10kg, 2buc/pac

Stinger DAM Effzett 7X7 Uncoated Stinger Silver Spinning System, Nr.6, 8cm, 10kg, 2buc/pac

svs56432

Livrare 7-14 zile

12,00Lei

Lanseta DAM Base-X Spin Rod, 30-60g, 2.70m, 2seg

Lanseta DAM Base-X Spin Rod, 30-60g, 2.70m, 2seg

2040970370

Livrare imediată!

119,63Lei

Lanseta Telescopica DAM Shadow 2.40m 5-25g 6seg

Lanseta Telescopica DAM Shadow 2.40m 5-25g 6seg

svs70349

Livrare 7-14 zile

213,00Lei

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

a.dam.66638

Livrare 24-48 ore

9,94Lei

Mulineta DAM Quick Darkside 8 FD 2500S

Mulineta DAM Quick Darkside 8 FD 2500S

svs73025

Livrare imediată!

266,00Lei

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

svs66197

Livrare imediată!

33,00Lei

Lanseta DAM Impulse X Feeder, 75-125g, 3.90m, 3+3seg

Lanseta DAM Impulse X Feeder, 75-125g, 3.90m, 3+3seg

1619249

Livrare 7-14 zile

306,00Lei

Lanseta DAM Rod Impulse-X Match 13FT, 5-25g, 3.90m, 3seg

Lanseta DAM Rod Impulse-X Match 13FT, 5-25g, 3.90m, 3seg

1619251

Livrare 7-14 zile

257,00Lei

Mulineta DAM Impressa 3 Reel 2500 FD 2+1BB

Mulineta DAM Impressa 3 Reel 2500 FD 2+1BB

svs72981

Livrare imediată!

115,00Lei

Afişare 361 - 380 din 1052 (53 pagini)

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

1 (0.167)

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

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

2 (0.105)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.137)

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

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

4 (0.131)

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 = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (36.490)

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 = '2' AND p.manufacturer_id = '124'

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

6 (47.460)

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 = '2' 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.175)

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

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