| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `AnimalTypeCategory`.`id`, `AnimalTypeCategory`.`updated`, `AnimalTypeCategory`.`created`, `AnimalTypeCategory`.`title`, `AnimalTypeCategory`.`animal_type_id`, `AnimalTypeCategory`.`position`, `AnimalTypeCategory`.`animal_count`, `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_type_categories` AS `AnimalTypeCategory` LEFT JOIN `asile_lu`.`animal_types` AS `AnimalType` ON (`AnimalTypeCategory`.`animal_type_id` = `AnimalType`.`id`) WHERE `AnimalTypeCategory`.`id` = 42 ORDER BY `AnimalTypeCategory`.`position` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Animal`.`id`, `Animal`.`updated`, `Animal`.`created`, `Animal`.`name`, `Animal`.`body`, `Animal`.`published`, `Animal`.`birthday`, `Animal`.`animal_temper_id`, `Animal`.`animal_type_id`, `Animal`.`featured`, `Animal`.`position`, `Animal`.`race`, `Animal`.`animal_type_category_id`, `Animal`.`gender`, `Animal`.`reserved` FROM `asile_lu`.`animals` AS `Animal` WHERE `Animal`.`animal_type_category_id` = (42) | 4 | 4 | 0 | |
| SELECT `Animal`.`id`, `Animal`.`updated`, `Animal`.`created`, `Animal`.`name`, `Animal`.`body`, `Animal`.`published`, `Animal`.`birthday`, `Animal`.`animal_temper_id`, `Animal`.`animal_type_id`, `Animal`.`featured`, `Animal`.`position`, `Animal`.`race`, `Animal`.`animal_type_category_id`, `Animal`.`gender`, `Animal`.`reserved`, `AnimalTemper`.`id`, `AnimalTemper`.`updated`, `AnimalTemper`.`created`, `AnimalTemper`.`title` FROM `asile_lu`.`animals` AS `Animal` LEFT JOIN `asile_lu`.`animal_tempers` AS `AnimalTemper` ON (`Animal`.`animal_temper_id` = `AnimalTemper`.`id`) WHERE `Animal`.`animal_type_category_id` = 42 AND `Animal`.`published` = '1' AND `Animal`.`gender` = 'male' ORDER BY `Animal`.`position` ASC LIMIT 10 | 0 | 0 | 1 | maybe slow |
| SELECT `Animal`.`animal_temper_id` FROM `asile_lu`.`animals` AS `Animal` WHERE `Animal`.`animal_type_category_id` = 42 AND `Animal`.`published` = '1' GROUP BY animal_temper_id ORDER BY `Animal`.`position` ASC | 1 | 1 | 0 | |
| SELECT `AnimalTemper`.`id`, `AnimalTemper`.`title` FROM `asile_lu`.`animal_tempers` AS `AnimalTemper` WHERE `AnimalTemper`.`id` = (NULL) ORDER BY `AnimalTemper`.`title` ASC | 0 | 0 | 0 | |
| SELECT `Animal`.`birthday` FROM `asile_lu`.`animals` AS `Animal` WHERE `Animal`.`published` = '1' AND `Animal`.`animal_type_category_id` = 42 ORDER BY `Animal`.`position` ASC | 1 | 1 | 0 | |
| SELECT `News`.`id`, `News`.`updated`, `News`.`created`, `News`.`title`, `News`.`body`, `News`.`published`, `News`.`featured`, `News`.`date`, `News`.`sticky` FROM `asile_lu`.`news` AS `News` WHERE `News`.`published` = '1' AND `News`.`featured` = '1' ORDER BY `News`.`sticky` DESC, `News`.`date` DESC LIMIT 5 | 5 | 5 | 0 | |
| SELECT `Asset`.`id`, `Asset`.`filename`, `Asset`.`filesize`, `Asset`.`filetype`, `Asset`.`type`, `Asset`.`anchor_x`, `Asset`.`anchor_y`, `Asset`.`foreign_model`, `Asset`.`foreign_id`, `Asset`.`thumbnail`, `Asset`.`created`, `Asset`.`updated`, `Asset`.`position`, `Asset`.`extras` FROM `asile_lu`.`assets` AS `Asset` WHERE `Asset`.`foreign_model` = 'News' AND `Asset`.`foreign_id` IN (318, 312, 320, 317, 314) ORDER BY `Asset`.`position` ASC | 11 | 11 | 0 | |
| SELECT `Thumbnail`.`id`, `Thumbnail`.`filename`, `Thumbnail`.`filesize`, `Thumbnail`.`filetype`, `Thumbnail`.`type`, `Thumbnail`.`anchor_x`, `Thumbnail`.`anchor_y`, `Thumbnail`.`foreign_model`, `Thumbnail`.`foreign_id`, `Thumbnail`.`thumbnail`, `Thumbnail`.`created`, `Thumbnail`.`updated`, `Thumbnail`.`position`, `Thumbnail`.`extras` FROM `asile_lu`.`assets` AS `Thumbnail` WHERE `Thumbnail`.`foreign_model` = 'news' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` IN (318, 312, 320, 317, 314) ORDER BY `Thumbnail`.`position` ASC | 5 | 5 | 0 | |
| SELECT `ExternalVideo`.`id`, `ExternalVideo`.`foreign_id`, `ExternalVideo`.`foreign_model`, `ExternalVideo`.`updated`, `ExternalVideo`.`created`, `ExternalVideo`.`videoID`, `ExternalVideo`.`videoType`, `ExternalVideo`.`embed`, `ExternalVideo`.`thumbnail`, `ExternalVideo`.`position` FROM `asile_lu`.`external_videos` AS `ExternalVideo` WHERE `ExternalVideo`.`foreign_model` = 'news' AND `ExternalVideo`.`foreign_id` IN (318, 312, 320, 317, 314) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 0 | |
| SELECT `Block`.`id`, `Block`.`updated`, `Block`.`created`, `Block`.`title`, `Block`.`body`, `Block`.`position`, `Block`.`block_category` FROM `asile_lu`.`blocks` AS `Block` WHERE `Block`.`block_category` = 0 ORDER BY `Block`.`position` ASC | 4 | 4 | 0 | |
