| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Quote`.`id`, `Quote`.`content`, `Quote`.`chapter`, `Quote`.`author` FROM `quotes` AS `Quote` WHERE `chapter` = 'projects' ORDER BY `Quote`.`id` DESC LIMIT 1 | | 0 | 0 | 0 | |
| SELECT `Quote`.`id`, `Quote`.`content`, `Quote`.`chapter`, `Quote`.`author` FROM `quotes` AS `Quote` WHERE `chapter` = 'main' ORDER BY `Quote`.`id` DESC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`image`, `Banner`.`position`, `Banner`.`disabled` FROM `banners` AS `Banner` WHERE `Banner`.`disabled` = 0 AND `image` <> '' AND `Banner`.`disabled` <> 1 ORDER BY RAND() ASC | | 5 | 5 | 0 | |
| SELECT `Rn`.`id`, `Rn`.`caption` FROM `rns` AS `Rn` LEFT JOIN projects AS `Project` ON (`Project`.`rn_id` = `Rn`.`id` and `Project`.`disabled` = 0) WHERE `Rn`.`disabled` = 0 AND `Rn`.`disabled` <> 1 GROUP BY `Rn`.`id` ORDER BY `Rn`.`position` DESC, `Rn`.`id` DESC | | 3 | 3 | 1 | maybe slow |
| SELECT `Dst`.`id`, `Dst`.`caption` FROM `dsts` AS `Dst` LEFT JOIN projects AS `Project` ON (`Project`.`dst_id` = `Dst`.`id` and `Project`.`disabled` = 0) WHERE `Dst`.`disabled` = 0 AND `Dst`.`disabled` <> 1 GROUP BY `Dst`.`id` ORDER BY `Dst`.`position` DESC, `Dst`.`id` DESC | | 8 | 8 | 1 | maybe slow |
| SELECT `UrlRule`.`id`, `UrlRule`.`url`, `UrlRule`.`disabled`, `UrlRule`.`note`, `UrlRule`.`created`, `UrlRule`.`modified` FROM `url_rules` AS `UrlRule` WHERE `UrlRule`.`disabled` = 0 AND `UrlRule`.`url` IN ('/object/38', '/object/*', '/*', '*') AND `UrlRule`.`disabled` <> 1 ORDER BY `UrlRule`.`url` ASC, `UrlRule`.`id` ASC | | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `projects` AS `Project` WHERE `Project`.`id` = 38 | | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `projects` AS `Project` WHERE `Project`.`id` = 38 | | 1 | 1 | 0 | |
| SELECT `Project`.`id`, `Project`.`rn_id`, `Project`.`dst_id`, `Project`.`caption`, `Project`.`caption_2`, `Project`.`content`, `Project`.`image`, `Project`.`thumbnail`, `Project`.`onmain`, `Project`.`position`, `Project`.`disabled`, `Dst`.`id`, `Dst`.`caption`, `Dst`.`content`, `Dst`.`image`, `Dst`.`position`, `Dst`.`disabled`, `Rn`.`id`, `Rn`.`caption`, `Rn`.`content`, `Rn`.`image`, `Rn`.`position`, `Rn`.`disabled` FROM `projects` AS `Project` LEFT JOIN `dsts` AS `Dst` ON (`Project`.`dst_id` = `Dst`.`id` AND `Dst`.`disabled` = 0) LEFT JOIN `rns` AS `Rn` ON (`Project`.`rn_id` = `Rn`.`id` AND `Rn`.`disabled` = 0) WHERE `Project`.`disabled` = 0 AND `Project`.`id` = 38 AND `Project`.`disabled` <> 1 ORDER BY `Project`.`position` DESC, `Dst`.`position` DESC, `Dst`.`id` DESC, `Rn`.`position` DESC, `Rn`.`id` DESC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `AttachmentImage`.`id`, `AttachmentImage`.`model`, `AttachmentImage`.`foreign_key`, `AttachmentImage`.`caption`, `AttachmentImage`.`image`, `AttachmentImage`.`thumbnail`, `AttachmentImage`.`alt`, `AttachmentImage`.`position`, `AttachmentImage`.`disabled`, `AttachmentImage`.`note`, `AttachmentImage`.`created`, `AttachmentImage`.`modified` FROM `attachment_images` AS `AttachmentImage` WHERE `model` = 'Project' AND `disabled` = 0 AND `AttachmentImage`.`foreign_key` = (38) | | 4 | 4 | 0 | |
| SELECT COUNT(*) AS `count` FROM `projects` AS `Project` WHERE `Project`.`id` = 38 | | 1 | 1 | 0 | |
| SELECT `Project`.`position` FROM `projects` AS `Project` WHERE `Project`.`id` = 38 ORDER BY `Project`.`position` DESC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Project`.`id`, `Project`.`rn_id`, `Project`.`dst_id`, `Project`.`caption`, `Project`.`caption_2`, `Project`.`content`, `Project`.`image`, `Project`.`thumbnail`, `Project`.`onmain`, `Project`.`position`, `Project`.`disabled` FROM `projects` AS `Project` WHERE `Project`.`disabled` = 0 AND `Project`.`id` <> 38 AND `Project`.`position` < 460 AND `Project`.`disabled` <> 1 ORDER BY `Project`.`position` DESC LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Project`.`id`, `Project`.`rn_id`, `Project`.`dst_id`, `Project`.`caption`, `Project`.`caption_2`, `Project`.`content`, `Project`.`image`, `Project`.`thumbnail`, `Project`.`onmain`, `Project`.`position`, `Project`.`disabled` FROM `projects` AS `Project` WHERE `Project`.`disabled` = 0 AND `Project`.`id` <> 38 AND `Project`.`position` > 460 AND `Project`.`disabled` <> 1 ORDER BY `Project`.`position` ASC LIMIT 1 | | 1 | 1 | 0 | |