Array
(
[NOTICE] => Array
(
[0] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
[1] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
[2] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
)
)
Array
(
[NOTICE] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
)
1. select |
total: 1 SELECT * FROM `settings` WHERE id = 1 ;
2. select |
total: 1 SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "blog" LIMIT 1;
3. select |
total: 28 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. SELECT |
total: 1 SELECT a.*, a.slug_en as slug, c.slug_en as catslug, c.name_en as catname, CONCAT(u.fname,' ',u.lname) as user, u.username, GROUP_CONCAT(m.title_en 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_en = "bpca" AND a.active = 1 GROUP BY a.id;
5. UPDATE |
total: 1 UPDATE `mod_blog` SET `hits` = `hits` + 1 WHERE id = 31
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_en as title,
p.body_en 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: 0
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'blog'
AND comment_id = 0
AND parent_id = 31
AND active = 1
LIMIT 1;
8. 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 |
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 = "blog"
AND parent_id = 31
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 = "blog"
AND parent_id = 31
AND c.active = 1
ORDER BY created DESC;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 1 . SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "blog" LIMIT 1;
3. select | total: 28 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. SELECT | total: 1 . SELECT a.*, a.slug_en as slug, c.slug_en as catslug, c.name_en as catname, CONCAT(u.fname,' ',u.lname) as user, u.username, GROUP_CONCAT(m.title_en 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_en = "bpca" AND a.active = 1 GROUP BY a.id;
5. UPDATE | total: 1 . UPDATE `mod_blog` SET `hits` = `hits` + 1 WHERE id = 31
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_en as title,
p.body_en 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: 0 .
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'blog'
AND comment_id = 0
AND parent_id = 31
AND active = 1
LIMIT 1;
8. 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 | 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 = "blog"
AND parent_id = 31
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 = "blog"
AND parent_id = 31
AND c.active = 1
ORDER BY created DESC;
