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: 6 SELECT * FROM `menus` 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 = "neverwinter-nights"
AND d.active = 1
GROUP BY d.id;
5. SELECT |
total: 3 SELECT
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en,
p.body_en,
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;
6. SELECT |
total: 3 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 = "5"
AND cf.section = "digishop"
ORDER BY cf.sorting;
7. count |
total: 2
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'digishop'
AND comment_id = 0
AND parent_id = 5
AND active = 1
LIMIT 1;
8. SELECT |
total: 2 SELECT
c.id,
c.user_id,
c.comment_id,
c.parent_id,
c.section,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`mod_comments` AS c
INNER JOIN
(SELECT
id
FROM
`mod_comments`
WHERE section = "digishop"
AND parent_id = "5"
AND comment_id = 0
AND active = 1
ORDER BY created DESC
LIMIT 0,5) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "digishop"
AND parent_id = "5"
AND c.active = 1
ORDER BY created DESC;
9. SELECT |
total: 0 SELECT
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 = "80abd5d3025c342c713d960e1c2b68c2b56c833e"
GROUP BY c.pid, c.totalprice
ORDER BY c.pid DESC;
10. SELECT |
total: 9 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: 6 . SELECT * FROM `menus` 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 = "neverwinter-nights"
AND d.active = 1
GROUP BY d.id;
5. SELECT | total: 3 . SELECT
l.plug_id,
l.space,
l.place,
p.system,
p.alt_class,
p.plugalias,
p.plugin_id,
p.title_en,
p.body_en,
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;
6. SELECT | total: 3 . 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 = "5"
AND cf.section = "digishop"
ORDER BY cf.sorting;
7. count | total: 2 .
SELECT
COUNT(*)
FROM
`mod_comments`
WHERE section = 'digishop'
AND comment_id = 0
AND parent_id = 5
AND active = 1
LIMIT 1;
8. SELECT | total: 2 . SELECT
c.id,
c.user_id,
c.comment_id,
c.parent_id,
c.section,
c.vote_down,
c.vote_up,
c.body,
c.created,
c.username as uname,
u.username,
CONCAT(u.fname, ' ', u.lname) AS name,
u.avatar
FROM
`mod_comments` AS c
INNER JOIN
(SELECT
id
FROM
`mod_comments`
WHERE section = "digishop"
AND parent_id = "5"
AND comment_id = 0
AND active = 1
ORDER BY created DESC
LIMIT 0,5) AS ch
ON ch.id IN (c.id, c.comment_id)
LEFT JOIN `users` AS u
ON u.id = c.user_id
WHERE section = "digishop"
AND parent_id = "5"
AND c.active = 1
ORDER BY created DESC;
9. SELECT | total: 0 . SELECT
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 = "80abd5d3025c342c713d960e1c2b68c2b56c833e"
GROUP BY c.pid, c.totalprice
ORDER BY c.pid DESC;
10. SELECT | total: 9 . 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;