1 (0.739)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://nashedelo.biz.ua/'
/var/www/nashed10251/data/www/nashedelo.biz.ua/index.php:60
2 (21.977)
SELECT *
FROM oc_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/index.php:70
3 (0.865)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/index.php:149
4 (0.840)
SELECT *
FROM oc_currency
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/currency.php:13
5 (0.655)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/weight.php:9
6 (0.753)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/length.php:9
7 (0.960)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/agoo/multilang.php:157
8 (2.973)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:77
9 (0.818)
SELECT *
FROM oc_layout l
LEFT JOIN oc_layout_route lr ON (l.layout_id = lr.layout_id)
ORDER BY name ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/bloglayout.php:42
10 (5.111)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '24' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:4
11 (1.316)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:4
12 (1.794)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:12
13 (17.016)
SELECT SQL_CALC_FOUND_ROWS p.product_id, NULL AS rating, NULL AS discount, NULL AS special
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id = '61' GROUP BY p.product_id
ORDER BY p.sort_order DESC, p.quantity >0 DESC, LCASE(pd.name) ASC LIMIT 140,28
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:484
14 (2.234)
SELECT FOUND_ROWS() AS `found_rows`
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:486
15 (3.506)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5623' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
16 (11.654)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5624' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
17 (4.906)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5625' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
18 (2.266)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5626' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
19 (1.853)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5145' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
20 (2.639)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5627' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
21 (2.233)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5146' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
22 (7.037)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5147' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
23 (3.167)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5629' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
24 (2.918)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5630' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
25 (4.055)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5197' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
26 (5.382)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6542' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
27 (4.302)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6545' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
28 (1.651)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6547' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
29 (1.754)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6548' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
30 (2.217)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6546' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
31 (2.909)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6549' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
32 (1.696)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6550' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
33 (4.649)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6552' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
34 (7.393)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6553' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
35 (3.997)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6554' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
36 (4.623)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6555' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
37 (2.049)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6556' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
38 (5.196)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6557' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
39 (3.098)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6558' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
40 (2.333)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6559' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
41 (4.844)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6561' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
42 (4.659)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, NULL 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 < '2018-04-20 16:03:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 16:03:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, '1' AS weight_class, NULL AS length_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(*) 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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6562' AND pd.language_id = '1' AND p.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:31
43 (2.577)
SELECT oov2p.product_id, oo.option_id, ood.name, ood.postfix
FROM oc_ocfilter_option oo
LEFT JOIN oc_ocfilter_option_description ood ON (ood.option_id = oo.option_id)
LEFT JOIN oc_ocfilter_option_value_to_product oov2p ON (oo.option_id = oov2p.option_id)
WHERE ood.language_id = '1' AND oov2p.product_id IN (5623,5624,5625,5626,5145,5627,5146,5147,5629,5630,5197,6542,6545,6547,6548,6546,6549,6550,6552,6553,6554,6555,6556,6557,6558,6559,6561,6562)
ORDER BY oo.sort_order, ood.name
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:90
44 (2.946)
SELECT *, oov2p.product_id, oov2p.option_id, oov2p.value_id
FROM oc_ocfilter_option_value_to_product oov2p
LEFT JOIN oc_ocfilter_option_value_to_product_description oov2pd ON (oov2pd.value_id = oov2p.value_id AND oov2pd.option_id = oov2p.option_id)
LEFT JOIN oc_ocfilter_option_value oov ON (oov.value_id = oov2p.value_id)
LEFT JOIN oc_ocfilter_option_value_description oovd ON (oovd.value_id = oov.value_id)
WHERE (oovd.language_id = '1' OR oovd.language_id IS NULL) AND (oov2pd.language_id = '1' OR oov2pd.language_id IS NULL) AND oov2p.product_id IN (5623,5624,5625,5626,5145,5627,5146,5147,5629,5630,5197,6542,6545,6547,6548,6546,6549,6550,6552,6553,6554,6555,6556,6557,6558,6559,6561,6562)
ORDER BY oov.sort_order, oovd.name
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:91
45 (0.813)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
46 (0.580)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
47 (0.782)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
48 (1.028)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
49 (0.638)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
50 (0.600)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
51 (0.675)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
52 (18.742)
SELECT p.product_id, oov2p.value_id, oov2p.option_id, oov2p.slide_value_min, oov2p.slide_value_max, p.manufacturer_id, p.quantity, p.stock_status_id
FROM oc_product p
LEFT JOIN oc_ocfilter_option_value_to_product oov2p ON (oov2p.product_id = p.product_id)
LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id)
WHERE p.status = '1' AND p.date_available <= '2018-04-20' AND p2c.category_id = '61'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:267
53 (30.062)
SELECT p.product_id, p.price, NULL AS discount, (SELECT MIN(ps.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 < '2018-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20'))) AS special
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) AND p.status = '1' AND p.price > '0' AND p2c.category_id = '61'
ORDER BY p.price
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:190
54 (10.896)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/setting.php:6
55 (8.360)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
56 (0.821)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
57 (1.895)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
58 (0.877)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
59 (3.344)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
60 (3.083)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
61 (1.924)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
62 (0.740)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
63 (1.123)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/setting.php:6
64 (7.318)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
65 (1.026)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
66 (0.621)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
67 (0.942)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
68 (1.800)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
69 (0.776)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
70 (0.954)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
71 (0.817)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
72 (2.043)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
73 (0.798)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
74 (1.036)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
75 (10.356)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
76 (18.411)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
77 (1.921)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
78 (0.833)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
79 (1.710)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
80 (0.836)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
81 (1.904)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
82 (2.188)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
83 (1.044)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
84 (0.777)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
85 (0.795)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
86 (0.971)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
87 (3.955)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/setting.php:6
88 (1.280)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
89 (0.720)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
90 (0.609)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
91 (0.997)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
92 (0.797)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
93 (1.121)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
94 (0.737)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
95 (0.828)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
96 (1.339)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'ascp_admin'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/setting.php:6
97 (0.571)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
98 (0.711)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
99 (0.783)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
100 (1.831)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
101 (0.679)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
102 (0.584)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
103 (0.713)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
104 (0.993)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
105 (0.546)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
106 (1.000)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
107 (1.089)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
108 (0.940)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
109 (1.443)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '61' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/category.php:62
110 (0.536)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/design/layout.php:4
111 (0.701)
SELECT *
FROM oc_layout_route
WHERE layout_id='3' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/agoo/design/layout.php:118
112 (0.918)
SELECT author, rating, text, date_added
FROM oc_category_review
WHERE category_id = '61' AND status = '1'
ORDER BY date_added DESC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/categoryreviews.php:30
113 (0.989)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'specialofferoutsite'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/setting.php:6
114 (1.255)
SELECT m.*,
(SELECT description
FROM oc_multi_modal_translate
WHERE `key` = 'title' AND modal_id = m.id AND lang_id = '1') AS title,
(SELECT description
FROM oc_multi_modal_translate
WHERE `key` = 'content' AND modal_id = m.id AND lang_id = '1') AS content
FROM oc_multi_modals m
WHERE m.status = 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/multimodal.php:10
115 (1.583)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/information.php:10
116 (4.478)
SELECT 'store_id', 'url'
FROM oc_store
ORDER BY url
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/module/microdatapro.php:54
117 (1.696)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/information.php:10
118 (1.026)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
Ru
Ua