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: 33 SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
3. select |
total: 1 SELECT * FROM `pages` WHERE slug_en = "bpca-centre-of-excellence" AND page_type = "normal" AND active = 1 LIMIT 1;
1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;
2. select | total: 33 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
3. select | total: 0 . SELECT * FROM `pages` WHERE slug_en = "bpca-lta" AND page_type = "normal" AND active = 1 LIMIT 1;
2. SELECT | total: 20 . SELECT body_en AS body, title_en AS title, slug_en AS slug, DATE_FORMAT(created, '%a, %d %b %Y %T GMT') AS created FROM pages WHERE active = 1 AND page_type = "normal" ORDER BY created DESC LIMIT 20;
2. select | total: 1 . SELECT title_en, info_en, keywords_en, description_en FROM `modules` WHERE modalias = "shop" LIMIT 1;
3. select | total: 1 . SELECT * FROM `pages` WHERE slug_en = "bpca-centre-of-excellence" AND page_type = "normal" AND active = 1 LIMIT 1;
4. SELECT
| total: 1 . SELECT
title_en AS title,
body_en AS body,
slug_en AS slug ,
page_type
FROM
`pages`
WHERE active = 1
AND page_type = "normal"
AND (`title_en` LIKE '%%') OR (`body_en` LIKE '%%')
ORDER BY created DESC
LIMIT 10;5. SELECT
TITLE_EN | total: 0 . SELECT
title_en AS title,
body_en AS body,
slug_en AS slug
FROM
`mod_portfolio`
WHERE MATCH (title_en) AGAINST ('*' IN BOOLEAN MODE)
OR MATCH (body_en) AGAINST ('*' IN BOOLEAN MODE)
ORDER BY created DESC
LIMIT 10;6. SELECT | total: 0 . SELECT title_en AS title, body_en AS body, slug_en AS slug FROM `mod_digishop` WHERE MATCH (title_en) AGAINST ('*' IN BOOLEAN MODE) OR MATCH (body_en) AGAINST ('*' IN BOOLEAN MODE) AND active = 1 ORDER BY created DESC LIMIT 10;7. SELECT | total: 0 . SELECT order_id, cart_id, SUM(totalprice) as grand, SUM(total) as sub, SUM(totaltax) as tax, COUNT(id) AS items FROM `mod_digishop_cart` WHERE uid = "eb8f5f200338bfe3a678ff89c5ad58985c2835fb" GROUP BY uid, order_id, cart_id;
8. SELECT | total: 0 . SELECT title_en AS title, body_en AS body, slug_en AS slug FROM `mod_shop` WHERE MATCH (title_en) AGAINST ('*' IN BOOLEAN MODE) OR MATCH (body_en) AGAINST ('*' IN BOOLEAN MODE) AND active = 1 ORDER BY created DESC LIMIT 10;3. select | total: 7 . SELECT * FROM `custom_fields` WHERE section = "profile" AND active = 1 ORDER BY sorting;
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 = "eb8f5f200338bfe3a678ff89c5ad58985c2835fb" GROUP BY c.product_id, c.totalprice, c.total ORDER BY c.product_id DESC;
5. SELECT
M.QUESTION_EN | total: 12 . SELECT
m.question_en AS title,
m.answer_en AS answer,
c.name_en AS name
FROM
`mod_faq` AS m
LEFT JOIN `mod_faq_categories` AS c
ON c.id = m.category_id
ORDER BY c.sorting, m.sorting
6. select | total: 4 . SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;
4. select | total: 30 . SELECT title_en AS title, slug_en AS slug FROM `pages` WHERE page_type = "normal" AND active = 1 ;
5. select | total: 1 . SELECT title_en AS title, slug_en AS slug FROM `mod_portfolio` ;
6. select | total: 1 . SELECT title_en AS title, slug_en AS slug FROM `mod_digishop` WHERE active = 1 ;
7. select | total: 2 . SELECT title_en AS title, slug_en AS slug FROM `mod_blog` WHERE active = 1 ;
8. select | total: 2 . SELECT title_en AS title, slug_en AS slug FROM `mod_shop` WHERE active = 1 ;
3. select | total: 33 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;
5. 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: 1 . SELECT * FROM `gateways` WHERE active = 1 ;
4. SELECT | total: 4 . SELECT title_en as title FROM `memberships` WHERE id IN(1,2,15,12)