Total execution time: 0.004069 sec.
Framework 1.25 v5.80
Memory Usage 5.31MB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => profile
[1] => cmsadmin
)
[route] => /profile/cmsadmin
[template] => front/themes/laguna/profile.tpl.php
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/modules_/blog/
[Bootstrap::Autoloader[2]] => autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/modules_/blog/Blog.class.php
)
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 *,u.id as id, m.title_en as mtitle
FROM `users` as u
LEFT JOIN memberships as m on m.id = u.membership_id
WHERE u.username = "cmsadmin"
AND u.active = "y"
4. SELECT |
total: 0 SELECT
cf.*,
cd.field_value
FROM
`custom_fields` AS cf
LEFT JOIN `custom_fields_data` AS cd
ON cd.field_id = cf.id
WHERE cd.user_id = 1
AND cf.section = "profile"
AND cf.active = 1
ORDER BY cf.sorting;
5. 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;
6. 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;
7. 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 *,u.id as id, m.title_en as mtitle
FROM `users` as u
LEFT JOIN memberships as m on m.id = u.membership_id
WHERE u.username = "cmsadmin"
AND u.active = "y"
4. SELECT | total: 0 . SELECT
cf.*,
cd.field_value
FROM
`custom_fields` AS cf
LEFT JOIN `custom_fields_data` AS cd
ON cd.field_id = cf.id
WHERE cd.user_id = 1
AND cf.section = "profile"
AND cf.active = 1
ORDER BY cf.sorting;
5. 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;
6. 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;
7. 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;
