Total execution time: 0.006155 sec.
Framework 1.25 v5.50
Memory Usage 868.88kB
POST:
Array
(
)
GET:
Array
(
)
Array
(
[before] => Closure Object
(
)
[segment] => Array
(
[0] => shop
[1] => btca-qualification-course
)
[route] => /shop/btca-qualification-course
[Bootstrap::Autoloader[1]] => registered path "autoloaded class "/var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/
[Bootstrap::Autoloader[2]] => autoloaded class "/var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.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
[3] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
[4] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
[5] => Warning [2]: Attempt to read property "mem_expire" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.class.php on line 2003
[6] => Deprecated [8192]: DateTime::__construct(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.class.php on line 2003
[7] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.class.php on line 2005
[8] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.class.php on line 2005
[9] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.class.php on line 2005
[10] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.class.php on line 2005
)
)
Array
(
[NOTICE] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/shop/Shop.class.php on line 2005
)
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 = "shop" LIMIT 1;
3. select |
total: 29 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. SELECT |
total: 1 SELECT d.*, d.title_en AS title, FORMAT((d.likes/d.ratings),0) as stars, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = d.id AND section = 'shop') as comments FROM `mod_shop` AS d WHERE slug_en = "btca-qualification-course" AND d.active = 1 GROUP BY d.id;
5. select |
total: 0 SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;
6. select |
total: 4 SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;
7. SELECT |
total: 0 SELECT SUM(totalprice) as grand, COUNT(id) AS items FROM `mod_shop_cart` WHERE user_id = "9566554734d827e77f70b47f9b451422c052e3de" GROUP BY user_id;
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 = "shop" LIMIT 1;
3. select | total: 29 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
4. select | total: 1 . SELECT * FROM `mod_blog_categories` WHERE slug_en = "world" LIMIT 1;
5. count | total: 1 .
SELECT
COUNT(a.id)
FROM
`mod_blog` AS a
INNER JOIN `mod_blog_related_categories` AS rc
ON a.id = rc.item_id
WHERE rc.category_id = 1
AND a.active = 1
LIMIT 1;
6. 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, a.rating, a.membership_id, c.slug_en AS cslug, c.name_en AS ctitle, GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships, (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 INNER JOIN `mod_blog_related_categories` AS rc ON a.id = rc.item_id LEFT JOIN `memberships` AS m ON FIND_IN_SET(m.id, a.membership_id) WHERE rc.category_id = 1 AND a.active = 1 AND c.active = 1 GROUP BY a.id ORDER BY created DESC LIMIT 0,5
7. SELECT | total: 0 . SELECT SUM(totalprice) as grand, COUNT(id) AS items FROM `mod_shop_cart` WHERE user_id = "9566554734d827e77f70b47f9b451422c052e3de" GROUP BY user_id;
4. SELECT | total: 1 . SELECT d.*, d.title_en AS title, FORMAT((d.likes/d.ratings),0) as stars, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = d.id AND section = 'shop') as comments FROM `mod_shop` AS d WHERE slug_en = "btca-qualification-course" AND d.active = 1 GROUP BY d.id;
5. select | total: 0 . SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;
6. select | total: 4 . SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;
