Query | Affected | Num. rows | Took (ms) | Actions |
---|
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`.`id` = 2420 AND `Animal`.`published` = '1' ORDER BY `Animal`.`position` ASC LIMIT 1 | 1 | 1 | 1 | |
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` = (2420) ORDER BY `AnimalAttributeValue`.`created` ASC | 9 | 9 | 3 | maybe slow |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 8 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 9 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 10 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 11 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 12 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 13 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 14 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 16 | 1 | 1 | 0 | |
SELECT `AnimalAttributeDefinition`.`id`, `AnimalAttributeDefinition`.`updated`, `AnimalAttributeDefinition`.`created`, `AnimalAttributeDefinition`.`label`, `AnimalAttributeDefinition`.`animal_type_id`, `AnimalAttributeDefinition`.`key`, `AnimalAttributeDefinition`.`type`, `AnimalAttributeDefinition`.`position`, `AnimalAttributeDefinition`.`predefined_values` FROM `asile_lu`.`animal_attribute_definitions` AS `AnimalAttributeDefinition` WHERE `AnimalAttributeDefinition`.`id` = 18 | 1 | 1 | 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` = (2420) ORDER BY `Asset`.`position` ASC | 11 | 11 | 6 | maybe slow |
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` = (2420) ORDER BY `Thumbnail`.`position` ASC | 1 | 1 | 5 | maybe slow |
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` = (2420) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 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 (319, 318, 312, 320, 317) 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 (319, 318, 312, 320, 317) 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 (319, 318, 312, 320, 317) 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` = 1 ORDER BY `Block`.`position` ASC | 1 | 1 | 0 | |