Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => page
[1] => services
)
[route] => /page/services
[template] => front/themes/laguna/page.tpl.php
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/plugins_/donation/
[Bootstrap::Autoloader[2]] => autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/plugins_/donation/Donate.class.php
[Bootstrap::Autoloader[3]] => registered path "autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/plugins_/poll/
[Bootstrap::Autoloader[4]] => autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/plugins_/poll/Poll.class.php
[Bootstrap::Autoloader[5]] => registered path "autoloaded class "/home1/modernair/cms.modernairdesign.com/view/admin/modules_/blog/
[Bootstrap::Autoloader[6]] => 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 * FROM `pages` WHERE slug_en = "services" AND page_type = "normal" AND active = 1 LIMIT 1;
4. SELECT |
total: 2 SELECT
id,
plugin_id,
jscode,
show_title,
alt_class,
title_en AS title ,
body_en AS body
FROM
`plugins`
WHERE id IN (13,3)
AND active = 1
5. SELECT |
total: 1 SELECT
m.id,
m.title,
m.target_amount,
m.redirect_page,
m.pp_email,
(SELECT COALESCE(SUM(amount), 0) FROM `plug_donation_data` WHERE parent_id = m.id) as total
FROM
`plug_donation` AS m
WHERE m.id = "1";
6. select |
total: 1 SELECT slug_en as slug FROM `pages` WHERE id = 1 LIMIT 1;
7. SELECT |
total: 4 SELECT
q.question,
q.id as id,
o.value,
o.id As oid,
IFNULL(COUNT(v.option_id), 0) AS total
FROM
`plug_poll_options` AS o
LEFT JOIN `plug_poll_votes` AS v
ON o.id = v.option_id
JOIN `plug_poll_questions` AS q
ON o.question_id = q.id
WHERE o.question_id = "1"
GROUP BY o.id
ORDER BY o.position;
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: 16 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
3. select | total: 1 . SELECT * FROM `pages` WHERE slug_en = "services" AND page_type = "normal" AND active = 1 LIMIT 1;
4. SELECT | total: 2 . SELECT
id,
plugin_id,
jscode,
show_title,
alt_class,
title_en AS title ,
body_en AS body
FROM
`plugins`
WHERE id IN (13,3)
AND active = 1
5. SELECT | total: 1 . SELECT
m.id,
m.title,
m.target_amount,
m.redirect_page,
m.pp_email,
(SELECT COALESCE(SUM(amount), 0) FROM `plug_donation_data` WHERE parent_id = m.id) as total
FROM
`plug_donation` AS m
WHERE m.id = "1";
6. select | total: 1 . SELECT slug_en as slug FROM `pages` WHERE id = 1 LIMIT 1;
7. SELECT | total: 4 . SELECT
q.question,
q.id as id,
o.value,
o.id As oid,
IFNULL(COUNT(v.option_id), 0) AS total
FROM
`plug_poll_options` AS o
LEFT JOIN `plug_poll_votes` AS v
ON o.id = v.option_id
JOIN `plug_poll_questions` AS q
ON o.question_id = q.id
WHERE o.question_id = "1"
GROUP BY o.id
ORDER BY o.position;
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;
