1 (2.686)
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.345)
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 (3.332)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/index.php:140
4 (20.930)
SELECT *
FROM oc_currency
/home/lastochka.dp/web/lastochka.dp.ua/public_html/system/library/currency.php:13
5 (0.483)
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 (1.130)
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 (2.331)
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)
WHERE 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:408
8 (5.485)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:173
9 (4.375)
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
10 (2.761)
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
11 (2.955)
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
12 (1.304)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
13 (2.064)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
14 (3.774)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
15 (1.494)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
16 (2.361)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
17 (3.475)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
18 (3.644)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
19 (2.205)
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
20 (4.342)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
21 (3.155)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
22 (5.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 = '132' 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 (3.422)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
24 (3.011)
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
25 (0.932)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
26 (2.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 = '125' 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
27 (4.066)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
28 (4.038)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
29 (26.103)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
30 (2.856)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
31 (1.078)
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
32 (1.306)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:408
33 (1.037)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:408
34 (2.096)
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
35 (0.966)
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
36 (1.503)
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.701)
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
38 (1.286)
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/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/blog/article.php:14
39 (0.679)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
40 (3.167)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
41 (3.323)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
42 (0.642)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
43 (0.745)
SELECT *
FROM oc_layout_route
WHERE 'blog/latest' 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
44 (0.877)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
45 (1.059)
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
46 (1.836)
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
47 (0.851)
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
48 (0.786)
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
49 (0.446)
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
50 (0.497)
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
51 (0.389)
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
52 (1.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 = '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
53 (1.338)
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
54 (0.598)
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
55 (0.397)
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
56 (0.402)
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
57 (0.870)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4
58 (1.156)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/lastochka.dp/web/lastochka.dp.ua/public_html/catalog/model/setting/extension.php:4