1 (0.856)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://nashedelo.biz.ua/'
/var/www/nashed10251/data/www/nashedelo.biz.ua/index.php:58
2 (23.801)
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.944)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/index.php:149
4 (0.834)
SELECT *
FROM oc_currency
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/currency.php:13
5 (0.802)
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.886)
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.962)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/agoo/multilang.php:157
8 (1.464)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '807'
ORDER BY main_category DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:264
9 (1.079)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:77
10 (2.378)
SELECT *
FROM oc_url_alias_blog
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:101
11 (0.960)
SELECT blog_id, design, path
FROM oc_blog
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:113
12 (0.942)
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
13 (1.380)
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 = '34' 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
14 (1.344)
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 = '75' 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
15 (2.861)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '807' 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 (1.180)
SELECT *
FROM oc_product_image
WHERE product_id = '807'
ORDER BY sort_order ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:715
17 (1.237)
SELECT *
FROM oc_product_discount
WHERE product_id = '807' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < '2018-11-13 10:05:00') AND (date_end = '0000-00-00' OR date_end > '2018-11-13 10:05:00'))
ORDER BY quantity ASC, priority ASC, price ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:709
18 (6.143)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '807' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:651
19 (2.663)
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 (807)
ORDER BY oo.sort_order, ood.name
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:90
20 (2.226)
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 (807)
ORDER BY oov.sort_order, oovd.name
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:91
21 (2.211)
SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '807' AND p.status = '1' AND p.date_available <= '2018-11-13 10:05:00' AND p2s.store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
22 (2.625)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '808' 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 (2.549)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '809' 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.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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '810' 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 (6.234)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '807'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:20
26 (6.223)
SELECT *, IF(td.name_short IS NULL or td.name_short = '', td.name, td.name_short) as name,
(select category_id
from oc_tag_to_category
where tag_id = t.tag_id) as category_id,
(select count(*)
from oc_product_to_tag
where tag_id = pt.tag_id) as kol
FROM oc_product_to_tag pt
INNER JOIN oc_tag t ON (t.tag_id = pt.tag_id)
INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id)
INNER JOIN oc_tag_to_store ts ON (pt.tag_id = ts.tag_id)
WHERE td.language_id = '1'
AND ts.store_id = '0'
AND t.status = '1'
AND pt.product_id = 807
group by t.tag_id
ORDER BY kol desc
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/tags.php:28
27 (1.370)
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 = '75' 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
28 (1.532)
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 = '34' 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
29 (1.402)
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 = '75' 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
30 (1.780)
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 = '34' 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
31 (1.179)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '807'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:20
32 (1.400)
SELECT *, IF(td.name_short IS NULL or td.name_short = '', td.name, td.name_short) as name,
(select category_id
from oc_tag_to_category
where tag_id = t.tag_id) as category_id,
(select count(*)
from oc_product_to_tag
where tag_id = pt.tag_id) as kol
FROM oc_product_to_tag pt
INNER JOIN oc_tag t ON (t.tag_id = pt.tag_id)
INNER JOIN oc_tag_description td ON (t.tag_id = td.tag_id)
INNER JOIN oc_tag_to_store ts ON (pt.tag_id = ts.tag_id)
WHERE td.language_id = '1'
AND ts.store_id = '0'
AND t.status = '1'
AND pt.product_id = 807
group by t.tag_id
ORDER BY kol desc
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/tags.php:28
33 (1.293)
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 = '75' 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
34 (1.358)
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 = '34' 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
35 (1.414)
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 = '75' 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
36 (1.611)
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 = '34' 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
37 (2.001)
SELECT author, date_added, rating, text
FROM oc_review
WHERE product_id = '807' AND status = '1'
ORDER BY date_added DESC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/module/microdatapro.php:156
38 (1.738)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
39 (1.402)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
40 (1.710)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
41 (1.071)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
42 (0.851)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
43 (1.137)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
44 (0.760)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
45 (0.729)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
46 (0.695)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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.722)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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 (0.881)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
49 (0.823)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
50 (0.925)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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.810)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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 (1.044)
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
53 (0.848)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
54 (0.824)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
55 (0.800)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
56 (1.092)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
57 (0.902)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
58 (0.860)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
59 (0.826)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
60 (0.964)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
61 (2.209)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
62 (1.140)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
63 (0.745)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
64 (0.872)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
65 (1.106)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
66 (0.786)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
67 (0.627)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
68 (0.910)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
69 (0.701)
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
70 (0.881)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
71 (0.706)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
72 (0.776)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
73 (0.871)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
74 (0.769)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
75 (0.683)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
76 (0.659)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
77 (1.216)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
78 (0.938)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
79 (0.737)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
80 (0.816)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
81 (0.863)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
82 (0.664)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
83 (0.751)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
84 (0.788)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
85 (0.809)
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
86 (0.769)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
87 (0.805)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
88 (0.758)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
89 (0.915)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
90 (0.794)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
91 (0.722)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
92 (0.653)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
93 (0.944)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
94 (3.156)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '807' 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
95 (2.120)
SHOW TABLES LIKE 'oc\\_review\\_fields';
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:597
96 (72.457)
SELECT
p.product_id,
cu.avatar as avatar,
o.order_id as buy,
MAX(op.product_id) as buyproduct,
r_f.*,
r.*,
r.review_id as review_id, r.review_id as comment_id,
p.product_id, pd.name, p.price, p.image, r.date_added as date_added,
r.date_added as date_added, r.date_added as date_available,
(r.sorthex) as hsort
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_customer` cu ON (r.customer_id = cu.customer_id)
LEFT JOIN `oc_order` o ON ( r.customer_id = o.customer_id AND o.customer_id <> 0 AND o.order_status_id IN (5) )
LEFT JOIN oc_order_product op ON (op.order_id = o.order_id AND o.customer_id <> 0 AND o.order_status_id IN (5) AND op.product_id = '807')
LEFT JOIN oc_review_fields r_f ON (r.review_id = r_f.review_id AND r_f.mark = 'product_id' )
WHERE
r.product_id = '807'
AND p.product_id = '807'
AND p.status = '1'
AND r.status = '1'
AND pd.language_id = '1'
AND r.type_id = '1'
GROUP by r.review_id
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:86
97 (1.456)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:77
98 (3.060)
SELECT *
FROM oc_url_alias_blog
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:101
99 (0.813)
SELECT blog_id, design, path
FROM oc_blog
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:113
100 (0.611)
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
101 (0.890)
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
102 (1.701)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '807'
ORDER BY category_id DESC LIMIT 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/path.php:119
103 (0.886)
SELECT td.name as name, CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM oc_category t0
LEFT JOIN oc_category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN oc_category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN oc_category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN oc_category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN oc_category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN oc_category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN oc_category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN oc_category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN oc_category t9 ON (t9.category_id = t8.parent_id)
LEFT JOIN oc_category_description td ON ( td.category_id = t0.category_id )
WHERE
td.language_id = '1' AND
t0.category_id = '75'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/path.php:96
104 (1.669)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '807' 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
105 (1.815)
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 = '75'
AND
cd.language_id = '1'
AND
c2s.store_id = '0'
AND
c.status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:417
106 (1.926)
SELECT COUNT(*) AS total
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE
r.product_id = '807'
AND
p.product_id = '807'
AND p.status = '1'
AND r.status = '1'
AND pd.language_id = '1' AND r.type_id = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:135
107 (5.289)
SHOW TABLES LIKE 'oc\\_review\\_fields';
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:597
108 (1.938)
SELECT
p.product_id,
cu.avatar as avatar,
o.order_id as buy,
MAX(op.product_id) as buyproduct,
r_f.*,
r.*,
r.review_id as review_id, r.review_id as comment_id,
p.product_id, pd.name, p.price, p.image, r.date_added as date_added,
r.date_added as date_added, r.date_added as date_available,
(r.sorthex) as hsort
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_customer` cu ON (r.customer_id = cu.customer_id)
LEFT JOIN `oc_order` o ON ( r.customer_id = o.customer_id AND o.customer_id <> 0 AND o.order_status_id IN (5) )
LEFT JOIN oc_order_product op ON (op.order_id = o.order_id AND o.customer_id <> 0 AND o.order_status_id IN (5) AND op.product_id = '807')
LEFT JOIN oc_review_fields r_f ON (r.review_id = r_f.review_id AND r_f.mark = 'product_id' )
WHERE
r.product_id = '807'
AND p.product_id = '807'
AND p.status = '1'
AND r.status = '1'
AND pd.language_id = '1'
AND r.type_id = '1'
GROUP by r.review_id
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:86
109 (1.689)
SELECT
rc.*,
rc.review_id as cid,
rc.review_id as review_id,
IF ((SELECT urc.delta
FROM oc_rate_review urc
WHERE urc.customer_id = '0' AND urc.review_id = rc.review_id LIMIT 1) < 0, -1 ,
IF ((SELECT urc.delta
FROM oc_rate_review urc
WHERE urc.customer_id = '0' AND urc.review_id = rc.review_id LIMIT 1) > 0, 1 , 0 ) ) as customer_delta ,
COUNT(rc.review_id) as rate_count,
SUM(rc.delta) as rate_delta,
SUM(rc.delta > 0) as rate_delta_blog_plus,
SUM(rc.delta < 0) as rate_delta_blog_minus
FROM
oc_rate_review rc
LEFT JOIN oc_review c on (rc.review_id = c.review_id)
LEFT JOIN oc_product r on (r.product_id = c.product_id)
LEFT JOIN oc_product_description pd ON (r.product_id = pd.product_id)
WHERE
r.product_id= 807
AND r.status = '1'
AND c.status = '1'
AND pd.language_id = '1'
GROUP BY rc.review_id
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:173
110 (0.961)
SELECT f.*
FROM oc_fields f
GROUP BY f.field_id
ORDER BY f.field_order DESC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/fields.php:35
111 (1.032)
SELECT *
FROM oc_fields_description
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/fields.php:43
112 (1.228)
SELECT f.*
FROM oc_fields f
GROUP BY f.field_id
ORDER BY f.field_order DESC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/fields.php:35
113 (1.082)
SELECT *
FROM oc_fields_description
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/fields.php:43
114 (1.828)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '807' 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
115 (1.315)
SELECT *
FROM oc_product_image
WHERE product_id = '807'
ORDER BY sort_order ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:715
116 (0.980)
SELECT name
FROM oc_category_description
WHERE category_id = '75' and language_id = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:109
117 (2.107)
SELECT name
FROM oc_product_description
WHERE product_id = '807' and language_id = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:114
118 (1.167)
SELECT cr.rcategory_id, cr.limit, cd.name
FROM oc_category_related cr
LEFT JOIN oc_category_description cd ON (cr.rcategory_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (cd.category_id = c2s.category_id)
WHERE cr.category_id = 75 AND cd.language_id='1' AND c2s.store_id = '0'
ORDER BY cd.name
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:7
119 (4.166)
SELECT p.product_id
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id=p2c.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '109' AND main_category = 1
ORDER BY rand() ASC LIMIT 5
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:73
120 (7.862)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '2715' 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
121 (2.973)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '4975' 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
122 (2.821)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '4993' 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
123 (3.328)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '9393' 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
124 (3.863)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '4977' 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
125 (0.915)
SELECT parent_id
FROM oc_category
WHERE category_id = '109'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
126 (0.926)
SELECT parent_id
FROM oc_category
WHERE category_id = '24'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
127 (12.520)
SELECT p.product_id
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id=p2c.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '61' AND main_category = 1
ORDER BY rand() ASC LIMIT 5
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:73
128 (2.666)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '6321' 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
129 (1.847)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '5313' 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
130 (1.981)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '5205' 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
131 (1.728)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '6544' 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
132 (13.900)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '5921' 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
133 (2.284)
SELECT parent_id
FROM oc_category
WHERE category_id = '61'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
134 (1.012)
SELECT parent_id
FROM oc_category
WHERE category_id = '24'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
135 (1.285)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '807' AND main_category = 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/similar.php:14
136 (9.758)
SELECT p.product_id
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p2c.category_id = '75' AND p.status = '1' AND p.date_available <= NOW() AND p.product_id > '807'
ORDER BY p.product_id ASC LIMIT 5
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/similar.php:19
137 (2.618)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '808' 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
138 (2.799)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '809' 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
139 (2.519)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '810' 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
140 (2.366)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '812' 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
141 (3.503)
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-11-13 10:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-13 10:05: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 = '813' 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
142 (0.978)
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
143 (0.809)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
144 (0.934)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
145 (0.944)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
146 (1.353)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
147 (1.165)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '807' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:733
148 (0.964)
SELECT *
FROM oc_layout_route
WHERE 'product/product' 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
149 (0.930)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' 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
150 (1.293)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
151 (7.548)
SELECT *, p.record_id as record_id
FROM oc_record_related pr
LEFT JOIN oc_record p ON (pr.pointer_id = p.record_id)
LEFT JOIN oc_record_to_store p2s ON (p.record_id = p2s.record_id)
LEFT JOIN oc_record_to_blog p2c ON (p.record_id = p2c.record_id)
LEFT JOIN oc_record_access raccess ON (raccess.record_id = p.record_id)
WHERE
pr.related_id = '807' AND pointer='product_id'
AND p2c.blog_id IN (4)
AND p.status = '1'
AND raccess.customer_group_id IN (1)
AND NOW() BETWEEN p.date_available AND p.date_end
AND p2s.store_id = '0' GROUP BY p.record_id
ORDER BY p.sort_order DESC LIMIT 0,20
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/record.php:158
152 (0.800)
SELECT FOUND_ROWS() as total
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/record.php:160
153 (0.864)
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
154 (1.577)
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
155 (2.971)
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
156 (0.971)
SELECT 'store_id', 'url'
FROM oc_store
ORDER BY url
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/module/microdatapro.php:54
157 (1.959)
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
158 (1.034)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
159 (2.286)
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '807' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
ORDER BY r.date_added DESC LIMIT 0,20
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/review.php:16
Ru
Ua
Приятное вежливое общение, что не мало важно!!
Спс
