Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => blog
[1] => immobilier
)
[route] => /blog/immobilier
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/home/clients/a13a9e24b1babc7602e94a86a48ab7e0/web/view/admin/modules_/blog/
[Bootstrap::Autoloader[2]] => autoload registered
[Bootstrap::Autoloader[3]] => autoloaded class "/home/clients/a13a9e24b1babc7602e94a86a48ab7e0/web/view/admin/modules_/blog/Blog.class.php
[template] => front/themes/master/mod_index.tpl.php
[Bootstrap::Autoloader[4]] => autoload registered
[Bootstrap::Autoloader[5]] => registered path "autoloaded class "/home/clients/a13a9e24b1babc7602e94a86a48ab7e0/web/view/admin/modules_/comments/
[Bootstrap::Autoloader[6]] => autoload registered
[Bootstrap::Autoloader[7]] => autoloaded class "/home/clients/a13a9e24b1babc7602e94a86a48ab7e0/web/view/admin/modules_/comments/Comments.class.php
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 1 SELECT title_fr, info_fr, keywords_fr, description_fr FROM `modules` WHERE modalias = "blog" LIMIT 1;
3. select |
total: 44 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. SELECT |
total: 2 SELECT
a.*,
a.slug_fr as slug,
c.slug_fr as catslug,
c.name_fr as catname,
CONCAT(u.fname,' ',u.lname) as user,
u.username,
GROUP_CONCAT(m.title_fr SEPARATOR ', ') AS memberships
FROM
`mod_blog` AS a
LEFT JOIN `users` AS u
ON u.id = a.user_id
LEFT JOIN `mod_blog_categories` AS c
ON c.id = a.category_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, a.membership_id)
WHERE a.slug_fr = "immobilier"
AND a.active = 1
GROUP BY a.id;
5. UPDATE |
total: 1 UPDATE `mod_blog`
SET `hits` = `hits` + 1
WHERE id = 40;
6. 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_fr as title,
p.body_fr 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;
7. count |
total: 1
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'blog'
AND comment_id = 0
AND parent_id = 40
AND active = 1
LIMIT 1;
8. SELECT |
total: 2 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 = "blog"
AND parent_id = 40
AND comment_id = 0
AND active = 1
ORDER BY created DESC
LIMIT 0,5) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "blog"
AND parent_id = 40
AND c.active = 1
ORDER BY created DESC;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 1 . SELECT title_fr, info_fr, keywords_fr, description_fr FROM `modules` WHERE modalias = "blog" LIMIT 1;
3. select | total: 44 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. SELECT | total: 2 . SELECT
a.*,
a.slug_fr as slug,
c.slug_fr as catslug,
c.name_fr as catname,
CONCAT(u.fname,' ',u.lname) as user,
u.username,
GROUP_CONCAT(m.title_fr SEPARATOR ', ') AS memberships
FROM
`mod_blog` AS a
LEFT JOIN `users` AS u
ON u.id = a.user_id
LEFT JOIN `mod_blog_categories` AS c
ON c.id = a.category_id
LEFT JOIN `memberships` AS m
ON FIND_IN_SET(m.id, a.membership_id)
WHERE a.slug_fr = "immobilier"
AND a.active = 1
GROUP BY a.id;
5. UPDATE | total: 1 . UPDATE `mod_blog`
SET `hits` = `hits` + 1
WHERE id = 40;
6. 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_fr as title,
p.body_fr 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;
7. count | total: 1 .
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'blog'
AND comment_id = 0
AND parent_id = 40
AND active = 1
LIMIT 1;
8. SELECT | total: 2 . 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 = "blog"
AND parent_id = 40
AND comment_id = 0
AND active = 1
ORDER BY created DESC
LIMIT 0,5) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "blog"
AND parent_id = 40
AND c.active = 1
ORDER BY created DESC;
