Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Productfamily`.`name`, `Productfamily`.`slug`, `Productfamily`.`id` FROM `dewe_cakeisalie`.`productfamilies` AS `Productfamily` WHERE `Productfamily`.`active` = '1' AND (`Productfamily`.`permissions` & 1 != 0) ORDER BY `Productfamily`.`sort` ASC, `Productfamily`.`name` ASC | 7 | 7 | 0 | |
SELECT `Productline`.`name`, `Productline`.`slug`, `ProductfamiliesProductline`.`productline_id`, `ProductfamiliesProductline`.`productfamily_id`, `ProductfamiliesProductline`.`id` FROM `dewe_cakeisalie`.`productlines` AS `Productline` JOIN `dewe_cakeisalie`.`productfamilies_productlines` AS `ProductfamiliesProductline` ON (`ProductfamiliesProductline`.`productfamily_id` IN ('570b9423-34fc-46a3-a0fd-0174d9c49861', '527a4087-3fb8-4940-93b0-354ed9c49862', '528c6122-4364-4f5c-98bf-4245d9c49862', '528c6220-c164-4094-ac70-19dad9c49862', '528c6207-3bd8-43f9-87f2-2bdcd9c49862', '528c6040-aa1c-4d0d-aad0-32e5d9c49862', '551412d9-b864-406a-a88a-0ca8d9c49861') AND `ProductfamiliesProductline`.`productline_id` = `Productline`.`id`) WHERE `Productline`.`active` = '1' AND (`Productline`.`permissions` & 1 != 0) ORDER BY `Productline`.`sort` ASC, `Productline`.`name` ASC | 23 | 23 | 0 | |
SELECT COUNT(*) AS `count` FROM `dewe_cakeisalie`.`productlines` AS `Productline` WHERE `Productline`.`id` = 'discontinued-software' | 1 | 1 | 0 | |
SELECT `Productline`.`name`, `Productline`.`sort`, `Productline`.`description`, `Productline`.`id`, `Productline`.`slug`, `Productline`.`active` FROM `dewe_cakeisalie`.`productlines` AS `Productline` WHERE `Productline`.`active` = '1' AND (`Productline`.`permissions` & 1 != 0) AND `Productline`.`slug` = 'discontinued-software' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Productgroup`.`slug`, `Productgroup`.`name`, `Productgroup`.`id`, `Productgroup`.`description`, `Productgroup`.`productline_id` FROM `dewe_cakeisalie`.`productgroups` AS `Productgroup` WHERE `Productgroup`.`active` = '1' AND (`Productgroup`.`permissions` & 1 != 0) AND `Productgroup`.`productline_id` = ('5f84398d-143c-42c0-94f4-382dd9c49a3c') ORDER BY `Productgroup`.`sort` ASC, `Productgroup`.`name` ASC | 7 | 7 | 0 | |
SELECT `Productfamily`.`name`, `Productfamily`.`slug`, `ProductfamiliesProductline`.`productline_id`, `ProductfamiliesProductline`.`productfamily_id`, `ProductfamiliesProductline`.`id` FROM `dewe_cakeisalie`.`productfamilies` AS `Productfamily` JOIN `dewe_cakeisalie`.`productfamilies_productlines` AS `ProductfamiliesProductline` ON (`ProductfamiliesProductline`.`productline_id` = '5f84398d-143c-42c0-94f4-382dd9c49a3c' AND `ProductfamiliesProductline`.`productfamily_id` = `Productfamily`.`id`) WHERE `Productfamily`.`active` = '1' AND (`Productfamily`.`permissions` & 1 != 0) | 1 | 1 | 0 | |
SELECT `Download`.`filename`, `Download`.`sort`, `Download`.`releasedate`, `Download`.`name`, `Download`.`id`, `Download`.`active`, `Download`.`filesize`, `Download`.`version`, `Download`.`oscompat`, `Download`.`downloadtype`, `Download`.`advancedOnly`, `Download`.`internalOnly`, `Download`.`language`, `Download`.`description`, `Download`.`md5`, `Download`.`sha1`, `DownloadsProductline`.`id`, `DownloadsProductline`.`download_id`, `DownloadsProductline`.`productline_id` FROM `dewe_cakeisalie`.`downloads` AS `Download` JOIN `dewe_cakeisalie`.`downloads_productlines` AS `DownloadsProductline` ON (`DownloadsProductline`.`productline_id` = '5f84398d-143c-42c0-94f4-382dd9c49a3c' AND `DownloadsProductline`.`download_id` = `Download`.`id`) WHERE `Download`.`active` = '1' AND (`Download`.`permissions` & 1 != 0) ORDER BY `Download`.`sort` ASC, `Download`.`downloadtype` ASC, `Download`.`name` ASC | 1 | 1 | 0 | |