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 d.*, GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships FROM `mod_digishop` AS d LEFT JOIN `memberships` AS m ON FIND_IN_SET(m.id, d.membership_id) WHERE slug_en = "bpca-national-conference-2025-day-1-may-7th" 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: 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;
8. SELECT |
total: 0 SELECT
cf.*,
cd.field_value
FROM
`custom_fields` AS cf
LEFT JOIN `custom_fields_data` AS cd
ON cd.field_id = cf.id
WHERE cd.digishop_id = 8
AND cf.section = "digishop"
AND cf.active = 1
ORDER BY cf.sorting;
9. 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 = "346dc801c590a0068bfb8bb0e6e25126fdeadcaa" GROUP BY c.pid, c.totalprice ORDER BY c.pid DESC;
10. select |
total: 0 SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;
11. select |
total: 4 SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;
12. 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 d.*, GROUP_CONCAT(m.title_en SEPARATOR ', ') AS memberships FROM `mod_digishop` AS d LEFT JOIN `memberships` AS m ON FIND_IN_SET(m.id, d.membership_id) WHERE slug_en = "bpca-national-conference-2025-day-1-may-7th" 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: 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;
8. SELECT | total: 0 . SELECT
cf.*,
cd.field_value
FROM
`custom_fields` AS cf
LEFT JOIN `custom_fields_data` AS cd
ON cd.field_id = cf.id
WHERE cd.digishop_id = 8
AND cf.section = "digishop"
AND cf.active = 1
ORDER BY cf.sorting;
9. 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 = "346dc801c590a0068bfb8bb0e6e25126fdeadcaa" GROUP BY c.pid, c.totalprice ORDER BY c.pid DESC;
10. select | total: 0 . SELECT avatar, card_link, email, fname, lname, mem_expire, membership_id, enable_family FROM `users` WHERE id = 0 LIMIT 1;
11. select | total: 4 . SELECT * FROM `memberships` WHERE 0 = :s_0 ORDER BY price;
12. 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;
