1 (0.273)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://lastochka.dp.ua/'
/home/velopo00/lastochka.dp.ua/www/index.php:51
2 (2.837)
SELECT *
FROM oc_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/velopo00/lastochka.dp.ua/www/index.php:61
3 (0.344)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/velopo00/lastochka.dp.ua/www/index.php:140
4 (0.175)
SELECT *
FROM oc_currency
/home/velopo00/lastochka.dp.ua/www/system/library/currency.php:13
5 (0.234)
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'
/home/velopo00/lastochka.dp.ua/www/system/library/weight.php:9
6 (0.183)
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'
/home/velopo00/lastochka.dp.ua/www/system/library/length.php:9
7 (1.189)
SELECT *
FROM oc_news c
LEFT JOIN oc_news_description cd ON (c.news_id = cd.news_id)
LEFT JOIN oc_news_to_store c2s ON (c.news_id = c2s.news_id)
WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.parent_id, c.sort_order, cd.name
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/news.php:13
8 (0.649)
SELECT CONCAT_WS('_',t9.news_id,t8.news_id,t7.news_id,t6.news_id,t5.news_id,t4.news_id,t3.news_id,t2.news_id,t1.news_id,t0.news_id) AS blid
FROM oc_news t0
LEFT JOIN oc_news t1 ON (t1.news_id = t0.parent_id)
LEFT JOIN oc_news t2 ON (t2.news_id = t1.parent_id)
LEFT JOIN oc_news t3 ON (t3.news_id = t2.parent_id)
LEFT JOIN oc_news t4 ON (t4.news_id = t3.parent_id)
LEFT JOIN oc_news t5 ON (t5.news_id = t4.parent_id)
LEFT JOIN oc_news t6 ON (t6.news_id = t5.parent_id)
LEFT JOIN oc_news t7 ON (t7.news_id = t6.parent_id)
LEFT JOIN oc_news t8 ON (t8.news_id = t7.parent_id)
LEFT JOIN oc_news t9 ON (t9.news_id = t8.parent_id)
WHERE t0.news_id = '69'
/home/velopo00/lastochka.dp.ua/www/catalog/controller/common/seo_pro.php:389
9 (0.598)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '139' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
10 (0.204)
SELECT COUNT(*) AS total
FROM oc_review_article r
LEFT JOIN oc_article p ON (r.article_id = p.article_id)
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
WHERE p.article_id = '139' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/review_article.php:38
11 (0.237)
SELECT *
FROM oc_article_image
WHERE article_id = '139'
ORDER BY sort_order ASC
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:220
12 (0.226)
SELECT *
FROM oc_article_related pr
LEFT JOIN oc_article p ON (pr.related_id = p.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE pr.article_id = '139' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:228
13 (0.578)
SELECT *
FROM oc_article_related_product np
LEFT JOIN oc_product p ON (np.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE np.article_id = '139' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:278
14 (0.349)
SELECT *
FROM oc_article_to_download pd
LEFT JOIN oc_download d ON(pd.download_id=d.download_id)
LEFT JOIN oc_download_description dd ON(pd.download_id=dd.download_id)
WHERE article_id = '139' AND dd.language_id = '1'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:305
15 (0.194)
UPDATE oc_article SET viewed = (viewed + 1)
WHERE article_id = '139'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:4
16 (0.182)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '139' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
17 (0.157)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/velopo00/lastochka.dp.ua/www/catalog/model/design/layout.php:4
18 (0.176)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
19 (0.395)
SELECT COUNT(DISTINCT p.article_id) AS total
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
LEFT JOIN oc_article_to_news p2c ON (p.article_id = p2c.article_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.news_id = '70'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:408
20 (0.200)
SELECT CONCAT_WS('_',t9.news_id,t8.news_id,t7.news_id,t6.news_id,t5.news_id,t4.news_id,t3.news_id,t2.news_id,t1.news_id,t0.news_id) AS blid
FROM oc_news t0
LEFT JOIN oc_news t1 ON (t1.news_id = t0.parent_id)
LEFT JOIN oc_news t2 ON (t2.news_id = t1.parent_id)
LEFT JOIN oc_news t3 ON (t3.news_id = t2.parent_id)
LEFT JOIN oc_news t4 ON (t4.news_id = t3.parent_id)
LEFT JOIN oc_news t5 ON (t5.news_id = t4.parent_id)
LEFT JOIN oc_news t6 ON (t6.news_id = t5.parent_id)
LEFT JOIN oc_news t7 ON (t7.news_id = t6.parent_id)
LEFT JOIN oc_news t8 ON (t8.news_id = t7.parent_id)
LEFT JOIN oc_news t9 ON (t9.news_id = t8.parent_id)
WHERE t0.news_id = '70'
/home/velopo00/lastochka.dp.ua/www/catalog/controller/common/seo_pro.php:389
21 (0.282)
SELECT COUNT(DISTINCT p.article_id) AS total
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
LEFT JOIN oc_article_to_news p2c ON (p.article_id = p2c.article_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.news_id = '69'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:408
22 (0.203)
SELECT p.article_id
FROM oc_article p
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
ORDER BY p.viewed DESC, p.date_added DESC LIMIT 3
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:210
23 (0.451)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '128' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
24 (0.443)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '145' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
25 (0.355)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '135' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
26 (0.188)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '139' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
27 (0.228)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/velopo00/lastochka.dp.ua/www/catalog/model/design/layout.php:4
28 (0.190)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
29 (0.111)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '139' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
30 (0.146)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/velopo00/lastochka.dp.ua/www/catalog/model/design/layout.php:4
31 (0.180)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
32 (0.116)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '139' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
33 (0.148)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/velopo00/lastochka.dp.ua/www/catalog/model/design/layout.php:4
34 (0.173)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
35 (1.057)
SELECT p.article_id, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.article_id
ORDER BY LCASE(p.date_added) DESC, LCASE(pd.name) DESC LIMIT 0,3
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:173
36 (0.408)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '147' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
37 (0.322)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '146' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
38 (0.425)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '145' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
39 (0.832)
SELECT r.review_article_id, r.author, r.rating, r.text, p.article_id, pd.name, p.image, r.date_added
FROM oc_review_article r
LEFT JOIN oc_article p ON (r.article_id = p.article_id)
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p2s.store_id = '0' 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 3
/home/velopo00/lastochka.dp.ua/www/catalog/model/module/blog_reviews.php:4
40 (0.332)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT AVG(rating) AS total
FROM oc_review_article r1
WHERE r1.article_id = p.article_id AND r1.status = '1' GROUP BY r1.article_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review_article r2
WHERE r2.article_id = p.article_id AND r2.status = '1' GROUP BY r2.article_id) AS reviews, p.sort_order
FROM oc_article p
LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE p.article_id = '123' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:14
41 (0.566)
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
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/information.php:10
42 (1.004)
SELECT *
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.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
43 (0.365)
SELECT *
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.parent_id = '60' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
44 (0.299)
SELECT *
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.parent_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
45 (0.307)
SELECT *
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.parent_id = '33' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
46 (0.297)
SELECT *
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.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
47 (0.295)
SELECT *
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.parent_id = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
48 (0.314)
SELECT *
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.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
49 (0.290)
SELECT *
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.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
50 (0.297)
SELECT *
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.parent_id = '70' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
51 (0.284)
SELECT *
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.parent_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/velopo00/lastochka.dp.ua/www/catalog/model/catalog/category.php:10
52 (0.338)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
53 (0.165)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4