1 (0.146)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://lastochka.dp.ua/'
/home/velopo00/lastochka.dp.ua/www/index.php:51
2 (1.536)
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.113)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/velopo00/lastochka.dp.ua/www/index.php:140
4 (0.120)
SELECT *
FROM oc_currency
/home/velopo00/lastochka.dp.ua/www/system/library/currency.php:13
5 (0.152)
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.138)
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 (0.227)
SELECT news_id
FROM oc_article_to_news
WHERE article_id = '124'
ORDER BY main_news DESC LIMIT 1
/home/velopo00/lastochka.dp.ua/www/catalog/controller/common/seo_pro.php:412
8 (0.468)
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
9 (0.279)
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 = '124' 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.143)
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 = '124' 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.115)
SELECT *
FROM oc_article_image
WHERE article_id = '124'
ORDER BY sort_order ASC
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:220
12 (0.115)
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 = '124' 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.159)
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 = '124' 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.122)
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 = '124' AND dd.language_id = '1'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:305
15 (0.149)
UPDATE oc_article SET viewed = (viewed + 1)
WHERE article_id = '124'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:4
16 (0.092)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '124' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
17 (0.134)
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.138)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
19 (0.151)
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
20 (0.234)
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
21 (0.302)
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
22 (0.221)
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
23 (0.088)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '124' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
24 (0.122)
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
25 (0.129)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
26 (0.085)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '124' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
27 (0.115)
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.129)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
29 (0.084)
SELECT *
FROM oc_article_to_layout
WHERE article_id = '124' AND store_id = '0'
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:288
30 (0.112)
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.123)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
32 (0.561)
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
33 (0.230)
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
34 (0.213)
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
35 (0.263)
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
36 (0.197)
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
37 (0.214)
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
38 (0.346)
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
39 (0.436)
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
40 (0.230)
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
41 (0.228)
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
42 (0.228)
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
43 (0.228)
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
44 (0.221)
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
45 (0.221)
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
46 (0.221)
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
47 (0.220)
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
48 (0.221)
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
49 (0.116)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
50 (0.111)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4