BPCA Courses

Total execution time: 0.007828 sec.
Framework 1.25 v5.50
Memory Usage 907.33kB
POST:

Array
(
)

GET:

Array
(
)

Array
(
    [before] => Closure Object
        (
        )

    [segment] => Array
        (
            [0] => digishop
            [1] => category
            [2] => bpca-courses
        )

    [route] => /digishop/category/bpca-courses
    [Bootstrap::Autoloader[1]] => registered path "autoloaded class "/var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/
    [Bootstrap::Autoloader[2]] => autoloaded class "/var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.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]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
            [6] => Warning [2]: Attempt to read property "mem_expire" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.class.php on line 1780
            [7] => 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_/digishop/Digishop.class.php on line 1780
            [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_/digishop/Digishop.class.php on line 1782
            [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_/digishop/Digishop.class.php on line 1782
            [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_/digishop/Digishop.class.php on line 1782
            [11] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.class.php on line 1782
            [12] => Warning [2]: Attempt to read property "discount" on null in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/front/modules_/digishop/snippets/_grid.tpl.php on line 32
            [13] => Warning [2]: Attempt to read property "discount" on null in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/front/modules_/digishop/snippets/_grid.tpl.php on line 35
            [14] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
            [15] => Warning [2]: Undefined variable $cc in /var/www/html/courtlin/public_html/bpca.co.uk.backup/lib/db.class.php on line 317
            [16] => Warning [2]: Attempt to read property "mem_expire" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.class.php on line 2152
            [17] => 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_/digishop/Digishop.class.php on line 2152
            [18] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.class.php on line 2154
            [19] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.class.php on line 2154
            [20] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.class.php on line 2154
            [21] => Warning [2]: Attempt to read property "membership_id" on bool in /var/www/html/courtlin/public_html/bpca.co.uk.backup/view/admin/modules_/digishop/Digishop.class.php on line 2154
        )

)

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_/digishop/Digishop.class.php on line 2154
)

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 = "digishop" LIMIT 1;

3. select | total: 28
SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;

4. select | total: 1
SELECT * FROM `mod_digishop_categories` WHERE slug_en = "bpca-courses" LIMIT 1;

5. count | total: 1
SELECT COUNT(p.id) FROM `mod_digishop` AS p INNER JOIN `mod_digishop_related_categories` AS rc ON p.id = rc.item_id WHERE rc.category_id = 13 AND p.active = 1 LIMIT 1;

6. SELECT | total: 1
SELECT d.disallow_discount, d.id, d.created, d.price, d.title_en AS title, d.slug_en AS slug, d.thumb, d.token, d.likes, d.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 = d.id AND section = 'digishop') as comments FROM `mod_digishop` AS d LEFT JOIN `mod_digishop_categories` AS c ON c.id = d.category_id INNER JOIN `mod_digishop_related_categories` AS rc ON d.id = rc.item_id LEFT JOIN `memberships` AS m ON FIND_IN_SET(m.id, d.membership_id) WHERE rc.category_id = 13 AND d.active = 1 AND c.active = 1 GROUP BY d.id ORDER BY d.sorting LIMIT 0,6

7. select | total: 0
SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;

8. select | total: 4
SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;

9. SELECT | total: 3
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 = "digishop" AND p.active = 1 ORDER BY l.sorting;

10. SELECT | total: 0
SELECT p.disallow_discount, c.totalprice, p.id AS pid, p.title_en AS title, p.slug_en AS slug, p.price, p.thumb, COUNT(*) AS items FROM `mod_digishop_cart` AS c LEFT JOIN `mod_digishop` AS p ON p.id = c.pid WHERE c.uid = "271ed4720f41ba5036a1bd2fa9e7ffdb6f738b09" GROUP BY c.pid, c.totalprice ORDER BY c.pid DESC;

11. select | total: 0
SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;

12. select | total: 4
SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;

13. SELECT | total: 2
SELECT c.id, c.parent_id, c.name_en AS name, c.slug_en AS slug, (SELECT COUNT(p.id) FROM mod_digishop p INNER JOIN `mod_digishop_related_categories` rc ON p.id = rc.item_id WHERE rc.category_id = c.id AND p.active = 1) AS items FROM `mod_digishop_categories` AS c GROUP BY c.id ORDER BY parent_id, 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 = "digishop" LIMIT 1;

3. select | total: 28 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;

4. select | total: 1 . SELECT * FROM `mod_digishop_categories` WHERE slug_en = "bpca-courses" LIMIT 1;

5. count | total: 0 . SELECT COUNT(p.id) FROM `mod_shop` AS p INNER JOIN `mod_shop_related_categories` AS rc ON p.id = rc.item_id WHERE rc.category_id = 48 AND p.active = 1 LIMIT 1;

6. SELECT | total: 0 . SELECT d.id, d.created, d.price, d.price_sale, d.quantity, d.subtract, d.label, d.ratings, d.variation_data, FORMAT((d.likes/d.ratings),0) as stars, d.title_en AS title, d.slug_en AS slug, d.thumb, d.likes, c.slug_en AS cslug, c.name_en AS name, (SELECT COUNT(parent_id) FROM `mod_comments` WHERE `mod_comments`.parent_id = d.id AND section = 'shop') as comments FROM `mod_shop` AS d LEFT JOIN `mod_shop_categories` AS c ON c.id = d.category_id INNER JOIN `mod_shop_related_categories` AS rc ON d.id = rc.item_id WHERE rc.category_id = 48 AND d.active = 1 AND c.active = 1 GROUP BY d.id ORDER BY  created DESC

7. select | total: 0 . SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;

8. select | total: 4 . SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;

9. SELECT | total: 3 . 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 = "digishop"
		  AND p.active = 1
		  ORDER BY l.sorting;

10. SELECT | total: 0 . SELECT p.disallow_discount, c.totalprice, p.id AS pid, p.title_en AS title, p.slug_en AS slug, p.price, p.thumb, COUNT(*) AS items FROM `mod_digishop_cart` AS c LEFT JOIN `mod_digishop` AS p ON p.id = c.pid WHERE c.uid = "271ed4720f41ba5036a1bd2fa9e7ffdb6f738b09" GROUP BY c.pid, c.totalprice ORDER BY c.pid DESC;

11. select | total: 0 . SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;

12. select | total: 4 . SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;

13. SELECT | total: 2 . SELECT c.id, c.parent_id, c.name_en AS name, c.slug_en AS slug, (SELECT COUNT(p.id) FROM mod_digishop p INNER JOIN `mod_digishop_related_categories` rc ON p.id = rc.item_id WHERE rc.category_id = c.id AND p.active = 1) AS items FROM `mod_digishop_categories` AS c GROUP BY c.id ORDER BY parent_id, sorting;

7. SELECT | total: 3 . 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 = "shop"
		  AND p.active = 1
		  ORDER BY l.sorting;

8. 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 = "271ed4720f41ba5036a1bd2fa9e7ffdb6f738b09" GROUP BY c.product_id, c.totalprice, c.total ORDER BY c.product_id DESC;

9. SELECT | total: 4 . SELECT c.id, c.parent_id, c.name_en AS name, c.slug_en AS slug, (SELECT COUNT(p.id) FROM mod_shop p INNER JOIN `mod_shop_related_categories` rc ON p.id = rc.item_id WHERE rc.category_id = c.id AND p.active = 1) AS items FROM `mod_shop_categories` AS c WHERE c.active = 1 GROUP BY c.id ORDER BY parent_id, sorting;

5. count | total: 1 . SELECT COUNT(p.id) FROM `mod_digishop` AS p INNER JOIN `mod_digishop_related_categories` AS rc ON p.id = rc.item_id WHERE rc.category_id = 13 AND p.active = 1 LIMIT 1;

6. SELECT | total: 1 . SELECT d.disallow_discount, d.id, d.created, d.price, d.title_en AS title, d.slug_en AS slug, d.thumb, d.token, d.likes, d.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 = d.id AND section = 'digishop') as comments FROM `mod_digishop` AS d LEFT JOIN `mod_digishop_categories` AS c ON c.id = d.category_id INNER JOIN `mod_digishop_related_categories` AS rc ON d.id = rc.item_id LEFT JOIN `memberships` AS m ON FIND_IN_SET(m.id, d.membership_id) WHERE rc.category_id = 13 AND d.active = 1 AND c.active = 1 GROUP BY d.id ORDER BY  d.sorting  LIMIT 0,6

BPCA Courses & Events

Worthing on 24th & 25th May - BPCA Professional Padel Coach Qualification Course