DAM

DAM

Sortare după:

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 100gr

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 100gr

a.dam.66038

Livrare 24-48 ore

23,93Lei(-30%) 16,76Lei

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 3.00m 10-50g

Lanseta DAM Base-X Multipicker 3.00m 10-50g

2050970376

Livrare imediată!

158,51Lei

Mulineta DAM QUICK IMPULSE 3L 3000

Mulineta DAM QUICK IMPULSE 3L 3000

svs72972

Livrare imediată!

107,00Lei

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.70m, 100-200g, 2seg

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

svs66275

Livrare imediată!

160,00Lei

Mulineta DAM Quick 2 Feeder 4000, 0.22mm-240m, 5.2:1, 5+1BB

Mulineta DAM Quick 2 Feeder 4000, 0.22mm-240m, 5.2:1, 5+1BB

dam.75984

Livrare 24-48 ore

204,14Lei(-20%) 164,22Lei

Montura DAM Madcat Profi River Rig Noseclip, Nr.6/0, 1.3mm, 250cm

Montura DAM Madcat Profi River Rig Noseclip, Nr.6/0, 1.3mm, 250cm

1604097

Livrare 7-14 zile

56,00Lei

Set Varfuri DAM Impulse-X Feeder Tips Kit3, 75-150g, 3buc/pac

Set Varfuri DAM Impulse-X Feeder Tips Kit3, 75-150g, 3buc/pac

1625229

Livrare 7-14 zile

85,00Lei

Mulineta DAM Nova Reel 4000 RD 1BB

Mulineta DAM Nova Reel 4000 RD 1BB

svs75964

Livrare 7-14 zile

57,00Lei

Lanseta DAM Imax Spin Spinning Rod ML, 7-21g, 1.98m, 1+1seg

Lanseta DAM Imax Spin Spinning Rod ML, 7-21g, 1.98m, 1+1seg

svs70624

Livrare imediată!

239,94Lei

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.60m, 8seg

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.60m, 8seg

svs70362

Livrare 7-14 zile

286,00Lei

Agrafa Cu Vartej Swivel DAM Barrel, Nr.6, 14kg, 10buc/pac

Agrafa Cu Vartej Swivel DAM Barrel, Nr.6, 14kg, 10buc/pac

svs8109006

Livrare 7-14 zile

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

Geanta DAM O.T.T. Carryall L 54x29x45cm

Geanta DAM O.T.T. Carryall L 54x29x45cm

9040974979

Livrare 48-72 ore

344,83Lei

Varga DAM Base-X Tele Pole 4.00m, 4seg

Varga DAM Base-X Tele Pole 4.00m, 4seg

svs71042

Livrare imediată!

55,00Lei

Lanseta Telescopica DAM Tele Aqua X Surf F 3.60m, 100-250g, 6seg

Lanseta Telescopica DAM Tele Aqua X Surf F 3.60m, 100-250g, 6seg

svs66279

Livrare 7-14 zile

164,01Lei

Rotativa DAM Effzett Executor Dressed Nr.3, Silver, 6g

Rotativa DAM Effzett Executor Dressed Nr.3, Silver, 6g

f.dam.60505

Livrare 24-48 ore

25,22Lei(-26%) 18,55Lei

Taparina DAM Searig 2 Herring Real SKin UV Nr.8, 140cm/10cm, 0.40/0.30mm, 5buc/pac

Taparina DAM Searig 2 Herring Real SKin UV Nr.8, 140cm/10cm, 0.40/0.30mm, 5buc/pac

svs61441

Livrare imediată!

8,00Lei

Combo DAM Impressa Classic Spin 1000, 2-12g, 1.80m, 2seg

Combo DAM Impressa Classic Spin 1000, 2-12g, 1.80m, 2seg

1608914

Livrare 7-14 zile

180,00Lei

Afişare 401 - 420 din 1052 (53 pagini)

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

1 (0.112)

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

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

2 (0.101)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.090)

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

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

4 (0.125)

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

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

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

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

7 (0.124)

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