1 (0.922)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://nashedelo.biz.ua/'
/var/www/nashed10251/data/www/nashedelo.biz.ua/index.php:60
2 (12.535)
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.818)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/index.php:149
4 (0.893)
SELECT *
FROM oc_currency
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/currency.php:13
5 (0.815)
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.788)
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.733)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/system/library/agoo/multilang.php:157
8 (0.938)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:77
9 (1.118)
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 (1.823)
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
11 (1.349)
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 = '78' 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 (2.172)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4489' 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
13 (1.105)
SELECT *
FROM oc_product_image
WHERE product_id = '4489'
ORDER BY sort_order ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:705
14 (0.876)
SELECT *
FROM oc_product_discount
WHERE product_id = '4489' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < '2018-04-20 04:21:00') AND (date_end = '0000-00-00' OR date_end > '2018-04-20 04:21: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:699
15 (5.986)
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 = '4489' 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:641
16 (2.277)
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 (4489)
ORDER BY oo.sort_order, ood.name
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:90
17 (1.212)
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 (4489)
ORDER BY oov.sort_order, oovd.name
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/catalog/ocfilter.php:91
18 (1.315)
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 = '4489' AND p.status = '1' AND p.date_available <= '2018-04-20 04:21:00' AND p2s.store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:713
19 (1.792)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '9149' 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.818)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '4489'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:20
21 (1.096)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '4489'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:20
22 (1.250)
SELECT author, date_added, rating, text
FROM oc_review
WHERE product_id = '4489' AND status = '1'
ORDER BY date_added DESC
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/module/microdatapro.php:156
23 (0.938)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
24 (2.296)
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
25 (0.778)
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
26 (0.791)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
27 (0.711)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
28 (0.650)
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
29 (0.672)
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
30 (0.600)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
31 (0.765)
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
32 (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
33 (1.078)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
34 (0.779)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
35 (0.834)
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
36 (0.852)
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
37 (3.914)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
38 (0.927)
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
39 (0.678)
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
40 (0.849)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
41 (0.715)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
42 (0.626)
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
43 (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
44 (0.855)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
45 (0.754)
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
46 (0.815)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
47 (0.725)
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
48 (1.120)
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
49 (1.326)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
50 (1.155)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
51 (1.012)
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
52 (1.065)
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
53 (0.988)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
54 (0.867)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
55 (0.847)
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
56 (0.943)
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
57 (0.890)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
58 (0.830)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
59 (0.825)
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
60 (0.689)
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
61 (0.817)
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
62 (0.996)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
63 (0.846)
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
64 (0.848)
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
65 (0.853)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
66 (1.019)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
67 (0.818)
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
68 (0.809)
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
69 (2.063)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
70 (2.670)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4489' 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
71 (2.169)
SHOW TABLES LIKE 'oc\\_review\\_fields';
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:597
72 (26.883)
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 = '4489')
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 = '4489'
AND p.product_id = '4489'
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
73 (0.933)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/common/seoblog.php:77
74 (0.985)
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
75 (0.861)
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
76 (1.287)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4489' 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
77 (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 = '78'
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
78 (2.445)
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 = '4489'
AND
p.product_id = '4489'
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
79 (1.408)
SHOW TABLES LIKE 'oc\\_review\\_fields';
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/treecomments.php:597
80 (1.013)
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 = '4489')
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 = '4489'
AND p.product_id = '4489'
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
81 (2.337)
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= 4489
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
82 (0.641)
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
83 (1.228)
SELECT *
FROM oc_fields_description
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/fields.php:43
84 (0.994)
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
85 (0.859)
SELECT *
FROM oc_fields_description
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/fields.php:43
86 (1.234)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4489' 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
87 (0.703)
SELECT *
FROM oc_product_image
WHERE product_id = '4489'
ORDER BY sort_order ASC
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:705
88 (0.937)
SELECT name
FROM oc_category_description
WHERE category_id = '78' and language_id = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:109
89 (0.795)
SELECT name
FROM oc_product_description
WHERE product_id = '4489' and language_id = '1'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:114
90 (0.641)
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 = 78 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
91 (2.669)
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
92 (1.742)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5739' 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
93 (2.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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5927' 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
94 (2.216)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4971' 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.896)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5592' 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
96 (6.462)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4988' 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
97 (0.758)
SELECT parent_id
FROM oc_category
WHERE category_id = '109'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
98 (0.855)
SELECT parent_id
FROM oc_category
WHERE category_id = '24'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
99 (4.282)
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 = '111' AND main_category = 1
ORDER BY rand() ASC LIMIT 5
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:73
100 (3.174)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4817' 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
101 (2.287)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4813' 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
102 (5.078)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4823' 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
103 (4.569)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '4827' 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
104 (2.722)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '2701' 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 (0.900)
SELECT parent_id
FROM oc_category
WHERE category_id = '111'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
106 (0.924)
SELECT parent_id
FROM oc_category
WHERE category_id = '24'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/rcategory.php:96
107 (1.074)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4489' AND main_category = 1
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/similar.php:14
108 (2.703)
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 = '78' AND p.status = '1' AND p.date_available <= NOW() AND p.product_id > '4489'
ORDER BY p.product_id ASC LIMIT 5
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/module/similar.php:19
109 (4.198)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5583' 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
110 (2.710)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5962' 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
111 (4.609)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5975' 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
112 (5.380)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5976' 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
113 (3.953)
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 04:21:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-20 04:21: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 = '5977' 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
114 (0.661)
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
115 (0.943)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
116 (1.109)
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
117 (0.721)
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
118 (0.960)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
119 (0.762)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '4489' AND store_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/vqmod/vqcache/vq2-catalog_model_catalog_product.php:723
120 (0.709)
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
121 (0.640)
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
122 (0.787)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/record/avatar.php:10
123 (0.809)
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
124 (0.929)
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
125 (1.987)
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
126 (0.732)
SELECT 'store_id', 'url'
FROM oc_store
ORDER BY url
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/controller/module/microdatapro.php:54
127 (2.266)
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
128 (1.343)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/nashed10251/data/www/nashedelo.biz.ua/catalog/model/setting/extension.php:4
129 (1.364)
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 = '4489' 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
Боливар, неприхотливый, не растрескивается. Красивая форма с выполненным округлым носиком.
Отлично хранится. Рекомендую сеять не больше 950 тыс. на 1 га.
Семена отлично всходят. По этому на выходе на момент уборки из 950 тыс. посеяных легко получить 750 тыс. товарной моркови Боливар F1.
Отлично хранится. Рекомендую сеять не больше 950 тыс. на 1 га.
Семена отлично всходят. По этому на выходе на момент уборки из 950 тыс. посеяных легко получить 750 тыс. товарной моркови Боливар F1.