Total execution time: 0.004615 sec.
Framework 1.25 v5.50
Memory Usage 837.61kB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => page
[1] => comments
)
[route] => /page/comments
[template] => front/themes/master/page.tpl.php
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/var/www/vfma/view/admin/modules_/comments/
[Bootstrap::Autoloader[2]] => autoload registered
[Bootstrap::Autoloader[3]] => autoloaded class "/var/www/vfma/view/admin/modules_/comments/Comments.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 = "comments" AND page_type = "normal" AND active = 1 LIMIT 1;
4. count |
total: 0
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'page'
AND comment_id = 0
AND parent_id = 12
AND active = 1
LIMIT 1;
5. 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 = 12
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 = 12
AND c.active = 1
ORDER BY created DESC;
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 = "comments" AND page_type = "normal" AND active = 1 LIMIT 1;
4. count | total: 0 .
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'page'
AND comment_id = 0
AND parent_id = 12
AND active = 1
LIMIT 1;
5. 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 = 12
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 = 12
AND c.active = 1
ORDER BY created DESC;
