1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 16 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
3. select |
total: 1 SELECT * FROM `pages` WHERE slug_en = "demo-faq" AND page_type = "normal" AND active = 1 LIMIT 1;
4. SELECT |
total: 0 SELECT
id,
plugin_id,
jscode,
show_title,
alt_class,
title_en AS title ,
body_en AS body
FROM
`plugins`
WHERE id IN (0)
AND active = 1
5. SELECT |
total: 0 SELECT
m.question_en AS title,
m.answer_en AS answer,
c.name_en AS name
FROM
`mod_faq` AS m
LEFT JOIN `mod_faq_categories` AS c
ON c.id = m.category_id
ORDER BY c.sorting, m.sorting
6. select |
total: 4 SELECT id, name_en FROM `mod_faq_categories` ORDER BY sorting;
7. count |
total: 0
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'page'
AND comment_id = 0
AND parent_id = 20
AND active = 1
LIMIT 1;
8. SELECT |
total: 0 SELECT
c.id,
c.user_id,
c.comment_id,
c.parent_id,
c.section,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`mod_comments` AS c
INNER JOIN
(SELECT
id
FROM
`mod_comments`
WHERE section = "page"
AND parent_id = 20
AND comment_id = 0
AND active = 1
ORDER BY created DESC
) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "page"
AND parent_id = 20
AND c.active = 1
ORDER BY created DESC;
9. 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;
10. 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;
11. 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: 16 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
3. select | total: 1 . SELECT * FROM `pages` WHERE slug_en = "demo-faq" AND page_type = "normal" AND active = 1 LIMIT 1;
4. SELECT | total: 0 . SELECT
id,
plugin_id,
jscode,
show_title,
alt_class,
title_en AS title ,
body_en AS body
FROM
`plugins`
WHERE id IN (0)
AND active = 1
5. SELECT | total: 0 . SELECT
m.question_en AS title,
m.answer_en AS answer,
c.name_en AS name
FROM
`mod_faq` AS m
LEFT JOIN `mod_faq_categories` AS c
ON c.id = m.category_id
ORDER BY c.sorting, m.sorting
6. select | total: 4 . SELECT id, name_en FROM `mod_faq_categories` ORDER BY sorting;
7. count | total: 0 .
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'page'
AND comment_id = 0
AND parent_id = 20
AND active = 1
LIMIT 1;
8. SELECT | total: 0 . SELECT
c.id,
c.user_id,
c.comment_id,
c.parent_id,
c.section,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`mod_comments` AS c
INNER JOIN
(SELECT
id
FROM
`mod_comments`
WHERE section = "page"
AND parent_id = 20
AND comment_id = 0
AND active = 1
ORDER BY created DESC
) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "page"
AND parent_id = 20
AND c.active = 1
ORDER BY created DESC;
9. 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;
10. 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;
11. 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;
