DAM

DAM

Sortare după:

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

Varga DAM Tele Tact-X 6m

Varga DAM Tele Tact-X 6m

dam.71155

Livrare 24-48 ore

236,14Lei

Husa DAM Intenze pentru 4 Lansete cu Mulineta, 170x38x29cm

Husa DAM Intenze pentru 4 Lansete cu Mulineta, 170x38x29cm

svs60364

Livrare 7-14 zile

319,00Lei

Lanseta DAM Impulse-X Tele Match 13ft, 10-30g, 3.90m

Lanseta DAM Impulse-X Tele Match 13ft, 10-30g, 3.90m

1619258

Livrare 7-14 zile

233,00Lei

Combo DAM Full Tech Carp 12FT 6000FD, 3.00lbs, 3.60m, 3seg

Combo DAM Full Tech Carp 12FT 6000FD, 3.00lbs, 3.60m, 3seg

1608892

Livrare 7-14 zile

191,99Lei

Borseta pentru Accesorii DAM O. T. T. EVA Accesorie Bag, Size M, 21.5x29x6

Borseta pentru Accesorii DAM O. T. T. EVA Accesorie Bag, Size M, 21.5x29x6

svs74981

Livrare imediată!

114,95Lei(-47%) 60,79Lei

Agrafa DAM Effzett Secu Snap Nr 2 11kg

Agrafa DAM Effzett Secu Snap Nr 2 11kg

410090131

Livrare 48-72 ore

7,04Lei

Grub DAM Effzett 110mm Purple Haze

Grub DAM Effzett 110mm Purple Haze

5748303

Livrare 48-72 ore

30,86Lei

Lingura Oscilanta 32gr 95mm DAM Effzett Slim Standard Spoon Silver Gold

Lingura Oscilanta 32gr 95mm DAM Effzett Slim Standard Spoon Silver Gold

802095032132

Livrare imediată!

25,24Lei

Lingura Rotativa 14gr DAM Effzett Tandem Dressed Stripe

Lingura Rotativa 14gr DAM Effzett Tandem Dressed Stripe

803090090

Livrare imediată!

25,39Lei

Rotativa DAM Effzett Standard Nr.1, Cupru Black Dot, 3g

Rotativa DAM Effzett Standard Nr.1, Cupru Black Dot, 3g

f.dam.5131501

Livrare imediată!

11,94Lei

Vesta DAM Hydroforce G2 Fly Vest M

Vesta DAM Hydroforce G2 Fly Vest M

5098625201

Livrare imediată!

231,43Lei(-22%) 179,90Lei

Mulineta DAM Quick 6 SLS 7000 FS

Mulineta DAM Quick 6 SLS 7000 FS

3020960069

Livrare 48-72 ore

710,58Lei

Oscilanta DAM Effzett Standard Olive Silver UV 6gr 32mm

Oscilanta DAM Effzett Standard Olive Silver UV 6gr 32mm

13042969589

Livrare 48-72 ore

15,09Lei

Rotativa DAM Effzett Fast Water Spinner Copper 10gr Marime:3

Rotativa DAM Effzett Fast Water Spinner Copper 10gr Marime:3

13052966568

Livrare imediată!

18,35Lei

Shad DAM Effzett Shadster Slim 8.5cm 5.2gr Motoroil Chartreuse UV

Shad DAM Effzett Shadster Slim 8.5cm 5.2gr Motoroil Chartreuse UV

13012971230

Livrare 48-72 ore

7,35Lei

Geanta DAM Camovision Carryall 78L 75x45x35cm

Geanta DAM Camovision Carryall 78L 75x45x35cm

svs70511

Livrare imediată!

361,83Lei(-24%) 274,90Lei

Carlige Montate Ron Thompson 10 Octopus III No.5/0 UV 120cm/6.5cm 0.60mm

Carlige Montate Ron Thompson 10 Octopus III No.5/0 UV 120cm/6.5cm 0.60mm

12130961491

Livrare 48-72 ore

9,58Lei

Shad DAM Paddletail Blue Silver 6.5cm

Shad DAM Paddletail Blue Silver 6.5cm

13010965429

Livrare imediată!

1,45Lei

Agrafa cu Vartej DAM D-Lock Nr.10, 12kg, 10buc/pac

Agrafa cu Vartej DAM D-Lock Nr.10, 12kg, 10buc/pac

a7.dam.56439

Livrare 24-48 ore

11,94Lei

Afişare 901 - 920 din 1084 (55 pagini)

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

1 (0.106)

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

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

2 (0.118)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.158)

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

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

4 (0.146)

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

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

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

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

7 (0.230)

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