| 1 | SHOW FULL COLUMNS FROM `projects` | | 5 | 5 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 3 | SHOW FULL COLUMNS FROM `categories` | | 8 | 8 | 4 |
| 4 | SHOW FULL COLUMNS FROM `images` | | 6 | 6 | 1 |
| 5 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`url`, `Category`.`sort`, `Category`.`footer_color`, `Category`.`fore_color`, `Category`.`short_name`, `Category`.`info` FROM `categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`sort` ASC, `Category`.`id` ASC | | 3 | 3 | 4 |
| 6 | SELECT `Project`.`id`, `Project`.`category_id`, `Project`.`name`, `Project`.`url`, `Project`.`sort`, (SELECT count(`i`.`id`) FROM images as i WHERE `i`.`project_id` = `Project`.`id`) AS `Project__project_image_count` FROM `projects` AS `Project` WHERE `Project`.`category_id` IN (1, 2, 3) ORDER BY `Project`.`sort` ASC, `Project`.`id` ASC | | 15 | 15 | 6 |
| 7 | SELECT `Image`.*, `Project`.`id`, `Project`.`name`, `Project`.`category_id`, `Project`.`sort`, `Category`.`id`, `Category`.`name`, `Category`.`sort`, `Category`.`short_name` FROM `images` AS `Image` INNER JOIN projects AS `Project` ON (`Project`.`id` = `Image`.`project_id`) INNER JOIN categories AS `Category` ON (`Category`.`id` = `Project`.`category_id`) WHERE 1 = 1 ORDER BY `Category`.`sort` ASC, `Category`.`id` ASC, `Project`.`sort` ASC, `Project`.`id` ASC, `Image`.`sort` ASC, `Image`.`id` ASC | | 105 | 105 | 2 |