1 (0.130)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://lastochka.dp.ua/'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/index.php:49
2 (1.595)
SELECT *
FROM oc_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/lastochka.dp/web/lastochka.dp.ua/public_html/index.php:61
3 (0.142)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/index.php:140
4 (0.353)
SELECT *
FROM oc_currency
/home/lastochka.dp/web/lastochka.dp.ua/public_html/system/library/currency.php:13
5 (0.187)
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/lastochka.dp/web/lastochka.dp.ua/public_html/system/library/weight.php:9
6 (0.272)
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/lastochka.dp/web/lastochka.dp.ua/public_html/system/library/length.php:9
7 (3.431)
SELECT LOWER(`keyword`) as 'keyword', `query`
FROM oc_url_alias
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/controller/common/seo_pro.php:9
8 (0.473)
SELECT news_id
FROM oc_article_to_news
WHERE article_id = '147'
ORDER BY main_news DESC LIMIT 1
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/controller/common/seo_pro.php:412
9 (0.134)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/news.php:13
10 (0.521)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
11 (0.386)
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 = '147' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/review_article.php:38
12 (0.205)
SELECT *
FROM oc_article_image
WHERE article_id = '147'
ORDER BY sort_order ASC
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:220
13 (0.201)
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 = '147' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:228
14 (0.221)
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 = '147' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:278
15 (0.145)
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 = '147' AND dd.language_id = '1'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:305
16 (0.294)
UPDATE oc_article SET viewed = (viewed + 1)
WHERE article_id = '147'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:4
17 (0.514)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '147' AND store_id = '0'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:288
18 (0.074)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/design/layout.php:4
19 (0.111)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
20 (0.759)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:210
21 (0.522)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
22 (0.640)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
23 (1.397)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
24 (0.399)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '147' AND store_id = '0'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:288
25 (0.062)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/design/layout.php:4
26 (2.831)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
27 (2.928)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '147' AND store_id = '0'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:288
28 (3.410)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/design/layout.php:4
29 (5.090)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
30 (0.725)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '147' AND store_id = '0'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:288
31 (0.096)
SELECT *
FROM oc_layout_route
WHERE 'blog/article' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/design/layout.php:4
32 (0.174)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
33 (2.246)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:173
34 (0.900)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
35 (0.773)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
36 (0.666)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
37 (0.731)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/module/blog_reviews.php:4
38 (0.394)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
39 (0.264)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/information.php:10
40 (0.526)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
41 (0.069)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
42 (0.074)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
43 (0.058)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
44 (0.065)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
45 (0.061)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
46 (0.054)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
47 (0.069)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
48 (0.056)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
49 (0.058)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/catalog/category.php:10
50 (0.349)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
51 (0.307)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4