| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| 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`.`id` = 12 AND `Post`.`published` = '1' ORDER BY `Post`.`position` ASC LIMIT 1 | 1 | 1 | 1 | |
| 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` = (12) AND `Asset`.`foreign_model` = "Post" 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` = 'post' AND `Thumbnail`.`type` = 'thumb' AND `Thumbnail`.`foreign_id` = (12) 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` = (12) 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` = 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 `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 | |