SELECT COUNT(*) AS `count` FROM `dewe_cakeisalie`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`id` = 'daqx-hsi-pad-modules'
1
1
0
SELECT `Productgroup`.`id`, `Productgroup`.`slug`, `Productgroup`.`sort`, `Productgroup`.`description`, `Productgroup`.`name`, `Productgroup`.`productline_id`, `Productgroup`.`active`, `Productgroup`.`permissions`, `Productline`.`name`, `Productline`.`slug`, `Productline`.`id` FROM `dewe_cakeisalie`.`productgroups` AS `Productgroup` LEFT JOIN `dewe_cakeisalie`.`productlines` AS `Productline` ON (`Productgroup`.`productline_id` = `Productline`.`id` AND `Productline`.`active` = '1' AND (`Productline`.`permissions` & 1 != 0)) WHERE `Productgroup`.`active` = '1' AND (`Productgroup`.`permissions` & 1 != 0) AND `Productgroup`.`slug` = 'daqx-hsi-pad-modules' ORDER BY `Productline`.`sort` ASC, `Productline`.`name` ASC LIMIT 1
1
1
0
SELECT `Product`.`name`, `Product`.`slug`, `Product`.`id`, `Product`.`description`, `Product`.`productgroup_id` FROM `dewe_cakeisalie`.`products` AS `Product` WHERE `Product`.`active` = '1' AND (`Product`.`permissions` & 1 != 0) AND `Product`.`productgroup_id` = ('538ed271-7170-438b-abab-3722d9c49861') ORDER BY `Product`.`sort` ASC, `Product`.`name` ASC
0
0
0
SELECT `Download`.`description`, `Download`.`advancedOnly`, `Download`.`internalOnly`, `Download`.`name`, `Download`.`id`, `Download`.`filesize`, `Download`.`version`, `Download`.`releasedate`, `Download`.`active`, `Download`.`downloadtype`, `Download`.`filename`, `Download`.`oscompat`, `Download`.`language`, `Download`.`md5`, `Download`.`sha1`, `Download`.`download_count`, `DownloadsProductgroup`.`id`, `DownloadsProductgroup`.`download_id`, `DownloadsProductgroup`.`productgroup_id` FROM `dewe_cakeisalie`.`downloads` AS `Download` JOIN `dewe_cakeisalie`.`downloads_productgroups` AS `DownloadsProductgroup` ON (`DownloadsProductgroup`.`productgroup_id` = '538ed271-7170-438b-abab-3722d9c49861' AND `DownloadsProductgroup`.`download_id` = `Download`.`id`) WHERE `Download`.`active` = '1' AND (`Download`.`permissions` & 1 != 0) ORDER BY `Download`.`downloadtype` ASC, `Download`.`sort` ASC, `Download`.`name` ASC
69
69
2
Query Explain:
Click an "Explain" link above, to see the query explanation.