BPCA Members Only Shop

You must first register or log in to pay and confirm your bookings - or call us to pay by phone on 0330 1136 190

Rackets

Reset Your Membership Name Price Date

Total: 0 / Current Page: 0 of 0

Debug General Params (6) Warnings (2) Errors (0) SQL Queries (9)

Total execution time: 0.006489 sec.
Framework 1.25 v5.50
Memory Usage 876.29kB
POST:

Array
(
)

GET:

Array
(
    [mode] => list
)

Array
(
    [before] => Closure Object
        (
        )

    [segment] => Array
        (
            [0] => shop
            [1] => category
            [2] => rackets
        )

    [route] => /shop/category/rackets
    [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
        )

)

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

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

4. select | total: 1
SELECT * FROM `mod_shop_categories` WHERE slug_en = "rackets" 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 = 46 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 = 46 AND d.active = 1 AND c.active = 1 GROUP BY d.id ORDER BY created DESC

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 = "3ddf6822321e55017029b0db705b88ce5c0b670e" 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;

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: 28 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;

4. select | total: 1 . SELECT * FROM `mod_shop_categories` WHERE slug_en = "rackets" 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 = 46 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 = 46 AND d.active = 1 AND c.active = 1 GROUP BY d.id ORDER BY  created DESC

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 = "3ddf6822321e55017029b0db705b88ce5c0b670e" 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;

HEY