Query | Affected | Num. rows | Took (ms) | Actions |
---|
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`.`id` = 61 AND `News`.`published` = '1' ORDER BY `News`.`date` DESC LIMIT 1 | 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` = 'News' AND `Asset`.`foreign_id` = (61) ORDER BY `Asset`.`position` ASC | 1 | 1 | 9 | 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` = 'news' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` = (61) ORDER BY `Thumbnail`.`position` ASC | 1 | 1 | 4 | 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` = 'news' AND `ExternalVideo`.`foreign_id` = (61) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 0 | |
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 1 = 1 ORDER BY `AnimalTypeCategory`.`position` ASC | 12 | 12 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE 1 = 1 ORDER BY `AnimalType`.`created` DESC | 2 | 2 | 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`.`animal_type_id` IN (2, 1) ORDER BY `AnimalAttributeDefinition`.`label` DESC | 18 | 18 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 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_attribute_definition_id` IN (4, 5, 11, 10, 3, 9, 2, 8, 18, 19, 6, 12, 7, 13, 16, 17, 14, 15) | 3204 | 3204 | 9 | |
SELECT `AnimalTypeCategory`.`id`, `AnimalTypeCategory`.`updated`, `AnimalTypeCategory`.`created`, `AnimalTypeCategory`.`title`, `AnimalTypeCategory`.`animal_type_id`, `AnimalTypeCategory`.`position`, `AnimalTypeCategory`.`animal_count` FROM `asile_lu`.`animal_type_categories` AS `AnimalTypeCategory` WHERE `AnimalTypeCategory`.`animal_type_id` IN (2, 1) ORDER BY `AnimalTypeCategory`.`position` ASC | 12 | 12 | 1 | maybe slow |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 1 | 1 | 1 | 0 | |
SELECT `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count` FROM `asile_lu`.`animal_types` AS `AnimalType` WHERE `AnimalType`.`id` = 2 | 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` IN (35, 36, 37, 42, 38, 40, 39, 41, 44, 45, 46, 47) | 356 | 356 | 3 | |
SELECT `PostCategory`.`id`, `PostCategory`.`updated`, `PostCategory`.`created`, `PostCategory`.`title`, `PostCategory`.`post_category_section_id`, `PostCategory`.`position`, `PostCategory`.`post_count` FROM `asile_lu`.`post_categories` AS `PostCategory` WHERE 1 = 1 ORDER BY `PostCategory`.`position` ASC | 14 | 14 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 1 AND `published` = '1' | 1 | 1 | 1 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 1 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 2 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 2 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 3 AND `published` = '1' | 1 | 1 | 1 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 3 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 5 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 5 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 7 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 7 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 6 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 6 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 8 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 8 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 9 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 9 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 10 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 10 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 4 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 4 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 11 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 11 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 12 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 12 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 13 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 13 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 14 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 14 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 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 `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`, `AnimalType`.`id`, `AnimalType`.`updated`, `AnimalType`.`created`, `AnimalType`.`title`, `AnimalType`.`animal_count`, `AnimalType`.`animal_type_category_count`, `AnimalTypeCategory`.`id`, `AnimalTypeCategory`.`updated`, `AnimalTypeCategory`.`created`, `AnimalTypeCategory`.`title`, `AnimalTypeCategory`.`animal_type_id`, `AnimalTypeCategory`.`position`, `AnimalTypeCategory`.`animal_count`, `AnimalTemper`.`id`, `AnimalTemper`.`updated`, `AnimalTemper`.`created`, `AnimalTemper`.`title` 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`.`published` = '1' AND `Animal`.`featured` = '1' ORDER BY `Animal`.`position` ASC LIMIT 8 | 4 | 4 | 1 | maybe slow |
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` IN (2442, 2420, 2437, 2441) ORDER BY `AnimalAttributeValue`.`created` ASC | 36 | 36 | 3 | maybe slow |
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` IN (2442, 2420, 2437, 2441) ORDER BY `Asset`.`position` ASC | 17 | 17 | 9 | 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` IN (2442, 2420, 2437, 2441) ORDER BY `Thumbnail`.`position` ASC | 4 | 4 | 4 | |
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` IN (2442, 2420, 2437, 2441) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`updated`, `Post`.`created`, `Post`.`title`, `Post`.`body`, `Post`.`published`, `Post`.`post_category_id`, `Post`.`subtitle`, `Post`.`featured`, `Post`.`position`, `PostCategory`.`id`, `PostCategory`.`updated`, `PostCategory`.`created`, `PostCategory`.`title`, `PostCategory`.`post_category_section_id`, `PostCategory`.`position`, `PostCategory`.`post_count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `Post`.`published` = '1' AND `Post`.`featured` = '1' ORDER BY `Post`.`position` ASC LIMIT 5 | 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`, (`I18n__title`.`content`) AS `Asset__i18n_title`, (`I18n__description`.`content`) AS `Asset__i18n_description` FROM `assets` AS `Asset` INNER JOIN `i18n` AS `I18n__title` ON (`Asset`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = "Asset" AND `I18n__title`.`field` = "title" AND `I18n__title`.`locale` = "fra") INNER JOIN `i18n` AS `I18n__description` ON (`Asset`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = "Asset" AND `I18n__description`.`field` = "description" AND `I18n__description`.`locale` = "fra") WHERE `Asset`.`foreign_id` = (142) AND `Asset`.`foreign_model` = "Post" ORDER BY `Asset`.`position` ASC | 1 | 1 | 4 | 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` = 'post' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` = (142) ORDER BY `Thumbnail`.`position` ASC | 1 | 1 | 4 | 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` = 'post' AND `ExternalVideo`.`foreign_id` = (142) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 6 AND `published` = '1' | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`title` FROM `asile_lu`.`posts` AS `Post` LEFT JOIN `asile_lu`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE `post_category_id` = 6 AND `published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
30 duplicate queries run.