DAM


9,00Lei

Maner Telescopic Minciog DAM O.T.T. 186cm

svs74985
Livrare imediată!

54,89Lei(-48%) 28,30Lei

Rotativa DAM Effzett Predator Nr.1, Silver, 4g

f.dam.60578
Livrare 24-48 ore

13,55Lei

Vartej DAM Madcat Power Swivels 140kg

403098152002
Livrare imediată!

26,68Lei

Umbrela DAM Standard 220 cm

5018491220
Livrare imediată!

254,87Lei

24,80Lei

Lingura Rotativa 6gr DAM Effzett Nature 3D Perch

8035130506
Livrare imediată!

11,73Lei

Fir DAM Fly Tapered Leader 9FT 0.152mm 2.7m

6093007015
Livrare imediată!

11,65Lei

2,00Lei

Mulineta DAM Quick PRO 130 FD

3020956668
Livrare imediată!

70,67Lei

16,01Lei

15,09Lei

20,56Lei

7,35Lei

217,00Lei

9,58Lei

196,00Lei

23,97Lei(-26%) 17,67Lei

38,00Lei

Lanseta DAM Match 4.20m, 8-20g, 3+3seg

dam.70330
Livrare 24-48 ore

448,56Lei(-20%) 359,75Lei

Afişare 1021 - 1040 din 1057 (53 pagini)
Queries: 7, Total time: 110.534 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '02bc255f48b93fce4c3af56f80'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
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 (51.353)
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 (58.657)
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 1020,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.143)
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