1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 1 SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "blog" LIMIT 1;
3. select |
total: 16 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select |
total: 1 SELECT * FROM `mod_blog_categories` WHERE slug_en = "residential-hvac" LIMIT 1;
5. count |
total: 2
SELECT
COUNT(a.id)
FROM
`mod_blog` AS a
INNER JOIN `mod_blog_related_categories` AS rc
ON a.id = rc.item_id
WHERE rc.category_id = 22
AND a.active = 1
LIMIT 1;
6. SELECT |
total: 2 SELECT
a.id,
a.created,
a.title_en AS title,
a.slug_en AS slug,
a.body_en AS body,
a.thumb,
a.rating,
a.membership_id,
c.slug_en AS cslug,
c.name_en AS ctitle,
GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships,
(SELECT
COUNT(parent_id)
FROM
`mod_comments`
WHERE `mod_comments`.parent_id = a.id
AND section = 'blog') as comments
FROM
`mod_blog` AS a
LEFT JOIN `mod_blog_categories` AS c
ON c.id = a.category_id
INNER JOIN `mod_blog_related_categories` AS rc
ON a.id = rc.item_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, a.membership_id)
WHERE rc.category_id = 22
AND a.active = 1
AND c.active = 1
GROUP BY a.id
ORDER BY created DESC LIMIT 0,10
7. SELECT |
total: 0 SELECT
p.id,
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en as title,
p.body_en as body,
p.jscode,
p.show_title,
p.cplugin
FROM
`layout` AS l
LEFT JOIN plugins AS p
ON p.id = l.plug_id
WHERE l.modalias = "blog"
AND p.active = 1
ORDER BY l.sorting;
8. SELECT |
total: 1 SELECT
YEAR(created) AS year,
DATE_FORMAT(created, '%m') AS month,
COUNT(id) AS total
FROM
`mod_blog`
WHERE active = 1
AND created <= DATE_SUB(NOW(), INTERVAL 1 MONTH)
GROUP BY year, month
ORDER BY year DESC, month DESC;
9. SELECT |
total: 3 SELECT
title_en AS title,
slug_en AS slug,
thumb,
created,
id
FROM
`mod_blog`
WHERE active = 1
ORDER BY hits DESC LIMIT 5;
10. SELECT |
total: 0 SELECT
c.body,
a.title_en AS title,
a.slug_en AS slug,
c.created
FROM
`mod_comments` AS c
LEFT JOIN `mod_blog` AS a
ON a.id = c.parent_id
WHERE c.section = "blog"
AND c.active = 1
AND a.active = 1
ORDER BY c.created DESC
LIMIT 5;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 1 . SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "blog" LIMIT 1;
3. select | total: 16 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select | total: 1 . SELECT * FROM `mod_blog_categories` WHERE slug_en = "residential-hvac" LIMIT 1;
5. count | total: 2 .
SELECT
COUNT(a.id)
FROM
`mod_blog` AS a
INNER JOIN `mod_blog_related_categories` AS rc
ON a.id = rc.item_id
WHERE rc.category_id = 22
AND a.active = 1
LIMIT 1;
6. SELECT | total: 2 . SELECT
a.id,
a.created,
a.title_en AS title,
a.slug_en AS slug,
a.body_en AS body,
a.thumb,
a.rating,
a.membership_id,
c.slug_en AS cslug,
c.name_en AS ctitle,
GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships,
(SELECT
COUNT(parent_id)
FROM
`mod_comments`
WHERE `mod_comments`.parent_id = a.id
AND section = 'blog') as comments
FROM
`mod_blog` AS a
LEFT JOIN `mod_blog_categories` AS c
ON c.id = a.category_id
INNER JOIN `mod_blog_related_categories` AS rc
ON a.id = rc.item_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, a.membership_id)
WHERE rc.category_id = 22
AND a.active = 1
AND c.active = 1
GROUP BY a.id
ORDER BY created DESC LIMIT 0,10
7. SELECT | total: 0 . SELECT
p.id,
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en as title,
p.body_en as body,
p.jscode,
p.show_title,
p.cplugin
FROM
`layout` AS l
LEFT JOIN plugins AS p
ON p.id = l.plug_id
WHERE l.modalias = "blog"
AND p.active = 1
ORDER BY l.sorting;
8. SELECT | total: 1 . SELECT
YEAR(created) AS year,
DATE_FORMAT(created, '%m') AS month,
COUNT(id) AS total
FROM
`mod_blog`
WHERE active = 1
AND created <= DATE_SUB(NOW(), INTERVAL 1 MONTH)
GROUP BY year, month
ORDER BY year DESC, month DESC;
9. SELECT | total: 3 . SELECT
title_en AS title,
slug_en AS slug,
thumb,
created,
id
FROM
`mod_blog`
WHERE active = 1
ORDER BY hits DESC LIMIT 5;
10. SELECT | total: 0 . SELECT
c.body,
a.title_en AS title,
a.slug_en AS slug,
c.created
FROM
`mod_comments` AS c
LEFT JOIN `mod_blog` AS a
ON a.id = c.parent_id
WHERE c.section = "blog"
AND c.active = 1
AND a.active = 1
ORDER BY c.created DESC
LIMIT 5;
