Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => blog
)
[route] => /blog
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/blog/
[Bootstrap::Autoloader[2]] => autoloaded class "/var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/blog/Blog.class.php
[template] => front/themes/readona/mod_index.tpl.php
)
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. count |
total: 1 SELECT COUNT(*) FROM `mod_blog` WHERE active = 1 LIMIT 1
4. SELECT |
total: 1 SELECT a.id, a.created, a.title_en AS title, a.slug_en AS slug, a.body_en AS body, a.thumb, c.slug_en AS cslug, c.name_en AS ctitle, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = a.id AND section = 'blog') as comments FROM `mod_blog` AS a LEFT JOIN `mod_blog_categories` AS c ON c.id = a.category_id LEFT JOIN `users` AS u ON u.id = a.user_id WHERE a.active = 1 ORDER BY a.created DESC LIMIT 0,11
5. select |
total: 28 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
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;
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: 0 . SELECT c.totalprice, c.total, Max(c.tax) as tax, Max(c.id) as id, Max(c.variants) as variants, p.id AS pid, p.title_en AS title, p.slug_en AS slug, p.price, p.thumb, COUNT(*) AS items FROM `mod_shop_cart` AS c LEFT JOIN `mod_shop` AS p ON p.id = c.product_id WHERE c.user_id = "c846cfd64883875a64a800e4c92c42aaf86853bd" GROUP BY c.product_id, c.totalprice, c.total ORDER BY c.product_id DESC;
3. count | total: 4 . SELECT COUNT(*) AS NUMROWS FROM `mod_portfolio`;
4. SELECT
| total: 4 . SELECT
d.id,
d.created,
d.title_en AS title,
d.slug_en AS slug,
d.thumb,
c.slug_en AS cslug,
c.name_en AS ctitle
FROM
`mod_portfolio` AS d
LEFT JOIN `mod_portfolio_categories` AS c
ON c.id = d.category_id
ORDER BY created DESC LIMIT 0,11
5. select | total: 28 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
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. select | total: 1 . SELECT id, name_en, slug_en FROM `mod_portfolio_categories` ORDER BY sorting;
3. count | total: 1 . SELECT COUNT(*) FROM `mod_blog` WHERE active = 1 LIMIT 1
4. SELECT | total: 1 . SELECT a.id, a.created, a.title_en AS title, a.slug_en AS slug, a.body_en AS body, a.thumb, c.slug_en AS cslug, c.name_en AS ctitle, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = a.id AND section = 'blog') as comments FROM `mod_blog` AS a LEFT JOIN `mod_blog_categories` AS c ON c.id = a.category_id LEFT JOIN `users` AS u ON u.id = a.user_id WHERE a.active = 1 ORDER BY a.created DESC LIMIT 0,11
