1 (0.133)
SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://lastochka.dp.ua/'
/home/velopo00/lastochka.dp.ua/www/index.php:51
2 (1.347)
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.101)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/velopo00/lastochka.dp.ua/www/index.php:140
4 (0.094)
SELECT *
FROM oc_currency
/home/velopo00/lastochka.dp.ua/www/system/library/currency.php:13
5 (0.149)
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.113)
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.781)
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,20
/home/velopo00/lastochka.dp.ua/www/catalog/model/blog/article.php:173
8 (0.229)
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
9 (0.180)
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
10 (0.206)
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
11 (0.170)
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 = '142' 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
12 (0.160)
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 = '141' 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
13 (0.159)
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 = '140' 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
14 (0.154)
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
15 (0.151)
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 = '138' 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
16 (0.149)
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 = '137' 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
17 (0.158)
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 = '136' 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
18 (0.162)
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
19 (0.206)
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 = '134' 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
20 (0.209)
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 = '133' 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.193)
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 = '132' 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.195)
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 = '130' 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.168)
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.157)
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 = '127' 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.165)
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 = '125' 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.162)
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
27 (0.181)
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 = '120' 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
28 (0.181)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
29 (0.121)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
30 (0.560)
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
31 (0.142)
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
32 (0.228)
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
33 (0.233)
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
34 (0.179)
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
35 (0.192)
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 = '120' 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.116)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
37 (0.095)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
38 (0.079)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
39 (0.089)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
40 (0.079)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
41 (0.088)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
42 (0.167)
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
43 (0.185)
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
44 (0.387)
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
45 (0.427)
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
46 (0.192)
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
47 (0.197)
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
48 (0.191)
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
49 (0.185)
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
50 (0.184)
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
51 (0.188)
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
52 (0.203)
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
53 (0.187)
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
54 (0.186)
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
55 (0.111)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4
56 (0.078)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/velopo00/lastochka.dp.ua/www/catalog/model/setting/extension.php:4