| 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` = 36 ORDER BY `AnimalTypeCategory`.`position` ASC LIMIT 1 | 1 | 1 | 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` FROM `asile_lu`.`animals` AS `Animal` WHERE `Animal`.`animal_type_category_id` = (36) | 22 | 22 | 0 | |
| SELECT `Animal`.`id`, `Animal`.`name` FROM `asile_lu`.`animals` AS `Animal` LEFT JOIN `asile_lu`.`animal_types` AS `AnimalType` ON (`Animal`.`animal_type_id` = `AnimalType`.`id`) LEFT JOIN `asile_lu`.`animal_type_categories` AS `AnimalTypeCategory` ON (`Animal`.`animal_type_category_id` = `AnimalTypeCategory`.`id`) LEFT JOIN `asile_lu`.`animal_tempers` AS `AnimalTemper` ON (`Animal`.`animal_temper_id` = `AnimalTemper`.`id`) WHERE `Animal`.`animal_type_category_id` = 36 AND `Animal`.`published` = '1' AND `Animal`.`animal_temper_id` = 23 AND YEAR(`Animal`.`birthday`) = '2007' ORDER BY `Animal`.`position` ASC | 1 | 1 | 0 | |
| SELECT `AnimalAttributeValue`.`id`, `AnimalAttributeValue`.`updated`, `AnimalAttributeValue`.`created`, `AnimalAttributeValue`.`animal_attribute_definition_id`, `AnimalAttributeValue`.`animal_id`, `AnimalAttributeValue`.`value` FROM `asile_lu`.`animal_attribute_values` AS `AnimalAttributeValue` WHERE `AnimalAttributeValue`.`animal_id` = (1510) ORDER BY `AnimalAttributeValue`.`created` ASC | 9 | 9 | 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` = 'Animal' AND `Asset`.`foreign_id` = (1510) ORDER BY `Asset`.`position` ASC | 57 | 57 | 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` = 'animal' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` = (1510) ORDER BY `Thumbnail`.`position` ASC | 1 | 1 | 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` = 'animal' AND `ExternalVideo`.`foreign_id` = (1510) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 0 | |
| SELECT `Animal`.`animal_temper_id` FROM `asile_lu`.`animals` AS `Animal` WHERE `Animal`.`animal_type_category_id` = 36 AND `Animal`.`published` = '1' GROUP BY animal_temper_id ORDER BY `Animal`.`position` ASC | 6 | 6 | 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 (302, 307, 299, 303, 296) ORDER BY `Asset`.`position` ASC | 27 | 27 | 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 (302, 307, 299, 303, 296) 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 (302, 307, 299, 303, 296) 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 | |