| 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`.`products` AS `Product` WHERE `Product`.`id` = 'dewe-cam-fw-70' | 1 | 1 | 0 | |
| SELECT `Product`.`name`, `Product`.`sort`, `Product`.`description`, `Product`.`id`, `Product`.`slug`, `Product`.`active`, `Product`.`permissions`, `Productgroup`.`slug`, `Productgroup`.`name`, `Productgroup`.`id` FROM `dewe_cakeisalie`.`products` AS `Product` LEFT JOIN `dewe_cakeisalie`.`productgroups` AS `Productgroup` ON (`Product`.`productgroup_id` = `Productgroup`.`id` AND `Productgroup`.`active` = '1' AND (`Productgroup`.`permissions` & 1 != 0)) WHERE `Product`.`active` = '1' AND (`Product`.`permissions` & 1 != 0) AND `Product`.`slug` = 'dewe-cam-fw-70' ORDER BY `Productgroup`.`sort` ASC, `Productgroup`.`name` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Download`.`description`, `Download`.`language`, `Download`.`filename`, `Download`.`releasedate`, `Download`.`name`, `Download`.`id`, `Download`.`active`, `Download`.`filesize`, `Download`.`version`, `Download`.`oscompat`, `Download`.`downloadtype`, `Download`.`advancedOnly`, `Download`.`internalOnly`, `Download`.`md5`, `Download`.`sha1`, `DownloadsProduct`.`product_id`, `DownloadsProduct`.`download_id`, `DownloadsProduct`.`id` FROM `dewe_cakeisalie`.`downloads` AS `Download` JOIN `dewe_cakeisalie`.`downloads_products` AS `DownloadsProduct` ON (`DownloadsProduct`.`product_id` = '53707db8-b314-432c-b623-2230d9c49862' AND `DownloadsProduct`.`download_id` = `Download`.`id`) WHERE `Download`.`active` = '1' AND (`Download`.`permissions` & 1 != 0) ORDER BY `Download`.`downloadtype` ASC, `Download`.`sort` ASC, `Download`.`name` ASC | 3 | 3 | 1 | maybe slow |
