Senzor


18,00Lei

20,00Lei

Nada Senzor Top Amix Fruttis, 1kg

snz99319
Livrare imediată!

19,00Lei

32,00Lei

30,00Lei

30,00Lei

38,00Lei

Pop Up Senzor Planet, Capsuna, 6-8-10mm, 30g

snz99405
Livrare imediată!

22,00Lei

Pop Up Senzor Planet, Krill, 10mm, 30g

snz99372
Livrare imediată!

22,00Lei

22,00Lei

30,00Lei

29,00Lei

30,00Lei

25,00Lei

18,00Lei

Pelete Senzor Faina De Peste 4mm 800g

snz99636
Livrare imediată!

25,00Lei

Pop Up SENZOR Fumigena, Tutti Frutti, 8mm, 25g

snz99571
Livrare imediată!

22,00Lei

Wafters Senzor Dulap Planet 1016 14-16mm

snz99464
Livrare imediată!

39,00Lei

22,00Lei

Pop Up Fumigena Senzor Planet, Capsuna, 6mm, 15g

snz99425
Livrare imediată!

20,00Lei

AfiÅŸare 101 - 120 din 512 (26 pagini)
Queries: 108, Total time: 99.522 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '0ba7b9fdb2230708b831f16d55'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.091)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Senzor'
/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 = '28' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (0.078)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=28'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
6 (35.544)
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 = '28'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
7 (39.548)
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 = '28' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
8 (0.754)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '174026' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
9 (0.179)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '174026' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
10 (0.157)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '174026' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
11 (0.078)
SELECT *
FROM oc_product_image
WHERE product_id = '174026'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
12 (0.641)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '200389' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
13 (0.194)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '200389' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
14 (0.158)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '200389' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
15 (0.083)
SELECT *
FROM oc_product_image
WHERE product_id = '200389'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
16 (0.594)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '200495' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
17 (0.169)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '200495' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
18 (0.157)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '200495' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
19 (0.091)
SELECT *
FROM oc_product_image
WHERE product_id = '200495'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
20 (0.590)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '224794' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
21 (0.167)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '224794' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
22 (0.157)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '224794' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
23 (0.081)
SELECT *
FROM oc_product_image
WHERE product_id = '224794'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
24 (0.581)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '237287' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
25 (0.169)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '237287' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
26 (0.177)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '237287' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
27 (0.090)
SELECT *
FROM oc_product_image
WHERE product_id = '237287'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
28 (0.699)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '245991' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
29 (0.176)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '245991' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
30 (0.198)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '245991' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
31 (0.079)
SELECT *
FROM oc_product_image
WHERE product_id = '245991'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
32 (0.695)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '115570' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
33 (0.158)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '115570' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
34 (0.136)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '115570' AND a.attribute_group_id = '37' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
35 (0.071)
SELECT *
FROM oc_product_image
WHERE product_id = '115570'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
36 (0.620)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '173882' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
37 (0.158)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '173882' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
38 (0.170)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '173882' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
39 (0.081)
SELECT *
FROM oc_product_image
WHERE product_id = '173882'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
40 (0.570)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '173936' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
41 (0.166)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '173936' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
42 (0.164)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '173936' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
43 (0.082)
SELECT *
FROM oc_product_image
WHERE product_id = '173936'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
44 (0.568)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '174011' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
45 (0.166)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '174011' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
46 (0.157)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '174011' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
47 (0.080)
SELECT *
FROM oc_product_image
WHERE product_id = '174011'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
48 (0.570)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '200367' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
49 (0.169)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '200367' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
50 (0.156)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '200367' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
51 (0.082)
SELECT *
FROM oc_product_image
WHERE product_id = '200367'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
52 (0.593)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '200445' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
53 (0.165)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '200445' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
54 (0.157)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '200445' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
55 (0.088)
SELECT *
FROM oc_product_image
WHERE product_id = '200445'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
56 (0.675)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '237278' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
57 (0.164)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '237278' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
58 (0.160)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '237278' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
59 (0.083)
SELECT *
FROM oc_product_image
WHERE product_id = '237278'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
60 (0.620)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '238403' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
61 (0.160)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '238403' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
62 (0.151)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '238403' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
63 (0.092)
SELECT *
FROM oc_product_image
WHERE product_id = '238403'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
64 (0.840)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '246597' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
65 (0.208)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '246597' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
66 (0.196)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '246597' AND a.attribute_group_id = '37' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
67 (0.088)
SELECT *
FROM oc_product_image
WHERE product_id = '246597'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
68 (0.840)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '100299' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
69 (0.168)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '100299' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
70 (0.156)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '100299' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
71 (0.100)
SELECT *
FROM oc_product_image
WHERE product_id = '100299'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
72 (0.792)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '118080' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
73 (0.167)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '118080' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
74 (0.156)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '118080' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
75 (0.069)
SELECT *
FROM oc_product_image
WHERE product_id = '118080'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
76 (0.776)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '156261' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
77 (0.217)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '156261' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
78 (0.209)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '156261' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
79 (0.089)
SELECT *
FROM oc_product_image
WHERE product_id = '156261'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
80 (0.847)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '173865' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
81 (0.211)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '173865' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
82 (0.204)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '173865' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
83 (0.087)
SELECT *
FROM oc_product_image
WHERE product_id = '173865'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
84 (0.831)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '173922' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
85 (0.211)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '173922' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1297
86 (0.206)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '173922' AND a.attribute_group_id = '11' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1302
87 (0.086)
SELECT *
FROM oc_product_image
WHERE product_id = '173922'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1398
88 (0.108)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=174026'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
89 (0.109)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=200389'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
90 (0.094)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=200495'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
91 (0.097)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=224794'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
92 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=237287'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
93 (0.078)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=245991'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
94 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=115570'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
95 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=173882'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
96 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=173936'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
97 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=174011'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
98 (0.078)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=200367'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
99 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=200445'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
100 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=237278'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
101 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=238403'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
102 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=246597'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
103 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=100299'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
104 (0.081)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=118080'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
105 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=156261'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
106 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=173865'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
107 (0.102)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '3'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:8
108 (0.093)
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