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`.`published` = '1' ORDER BY `News`.`date` DESC LIMIT 20, 10 | 10 | 10 | 1 | 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` = 'News' AND `Asset`.`foreign_id` IN (288, 289, 193, 284, 282, 281, 259, 261, 260, 257) ORDER BY `Asset`.`position` ASC | 83 | 83 | 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` IN (288, 289, 193, 284, 282, 281, 259, 261, 260, 257) ORDER BY `Thumbnail`.`position` ASC | 10 | 10 | 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` IN (288, 289, 193, 284, 282, 281, 259, 261, 260, 257) ORDER BY `ExternalVideo`.`position` ASC | 0 | 0 | 0 | |
SELECT `News`.`id`, `News`.`title` FROM `asile_lu`.`news` AS `News` WHERE `News`.`published` = '1' ORDER BY `News`.`date` DESC | 48 | 48 | 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, 317, 61, 316, 315, 312, 314, 313, 237, 311, 308, 302, 303, 307, 299, 296, 297, 293, 292, 288, 289, 193, 284, 282, 281, 259, 261, 260, 257, 256, 255, 254, 253, 251, 250, 249, 248, 245, 238, 234, 228, 226, 225, 224, 204, 301, 320) ORDER BY `Asset`.`position` ASC | 247 | 247 | 6 | |
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, 317, 61, 316, 315, 312, 314, 313, 237, 311, 308, 302, 303, 307, 299, 296, 297, 293, 292, 288, 289, 193, 284, 282, 281, 259, 261, 260, 257, 256, 255, 254, 253, 251, 250, 249, 248, 245, 238, 234, 228, 226, 225, 224, 204, 301, 320) ORDER BY `Thumbnail`.`position` ASC | 48 | 48 | 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` = 'news' AND `ExternalVideo`.`foreign_id` IN (319, 318, 317, 61, 316, 315, 312, 314, 313, 237, 311, 308, 302, 303, 307, 299, 296, 297, 293, 292, 288, 289, 193, 284, 282, 281, 259, 261, 260, 257, 256, 255, 254, 253, 251, 250, 249, 248, 245, 238, 234, 228, 226, 225, 224, 204, 301, 320) 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 (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 | |