DAM


9,00Lei

Rotativa DAM Effzett Predator Nr.2, Gold, 7g

f.dam.60581
Livrare 24-48 ore

15,22Lei

383,00Lei

Vartej DAM Madcat Power BB Swivels 130kg

403098152023
Livrare imediată!

20,33Lei

340,22Lei

16,09Lei

Lingura Rotativa 10gr DAM Effzett Fluo Yellow

803090032
Livrare imediată!

14,70Lei

Caciula DAM Hot Fleece Hat

5098656020
Livrare imediată!

33,40Lei

Stoper DAM Silicone Stopper XS

4098468001
Livrare imediată!

5,22Lei

Mulineta DAM Quick 1 BC 201

svs56364
Livrare 7-14 zile

253,01Lei

16,01Lei

15,09Lei

18,35Lei

Shad DAM Effzett Shadster Slim 8.5cm 5.2gr Roach

13012971233
Livrare imediată!

8,48Lei

124,95Lei(-68%) 40,25Lei

143,00Lei

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

svs71042
Livrare imediată!

55,00Lei

176,00Lei

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

8,50Lei

Afişare 1021 - 1040 din 1057 (53 pagini)
Queries: 7, Total time: 92.902 ms [By time] [By id] [By file]
1 (0.067)
SELECT data
FROM `oc_session`
WHERE session_id = '75db6cf7cf114a6b90cd45df80'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.113)
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 (43.311)
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 (49.107)
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.107)
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