| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Discography`.`id`, `Discography`.`project_id`, `Discography`.`title`, `Discography`.`role`, `Discography`.`release_date`, `Discography`.`review`, `Discography`.`label`, `Discography`.`itunes`, `Discography`.`spotify`, `Discography`.`soundcloud`, `Discography`.`bandcamp`, `Discography`.`publish_date`, `Discography`.`rating`, `Discography`.`votes`, `Discography`.`created`, `Discography`.`updated`, (`I18n__reviewTranslation`.`content`) AS `Discography__i18n_reviewTranslation`, `Project`.`project` FROM `sumrra`.`discographies` AS `Discography` LEFT JOIN `sumrra`.`projects` AS `Project` ON (`Discography`.`project_id` = `Project`.`id`) INNER JOIN `sumrra`.`discography_i18ns` AS `I18n__reviewTranslation` ON (`Discography`.`id` = `I18n__reviewTranslation`.`foreign_key` AND `I18n__reviewTranslation`.`model` = 'Discography' AND `I18n__reviewTranslation`.`field` = 'review' AND `I18n__reviewTranslation`.`locale` IN ('es', 'gl')) WHERE ((`publish_date` <= '2026-01-03 03:40:21') OR (`publish_date` IS NULL)) GROUP BY `Discography`.`id` ORDER BY `release_date` DESC | 8 | 8 | 2 | maybe slow |
| SELECT `TopSong`.`id`, `TopSong`.`discography_id`, `TopSong`.`song_id`, `TopSong`.`reproductions`, `TopSong`.`created`, `TopSong`.`modified` FROM `sumrra`.`top_songs` AS `TopSong` WHERE `TopSong`.`discography_id` IN (9, 8, 7, 6, 5, 4, 3, 14) | 0 | 0 | 0 | |
| SELECT `Item`.`id`, `Item`.`item_type_id`, `Item`.`digital_type_id`, `Item`.`project_id`, `Item`.`discography_id`, `Item`.`type`, `Item`.`digital_type`, `Item`.`name`, `Item`.`description`, `Item`.`shipping`, `Item`.`handling`, `Item`.`tax`, `Item`.`price`, `Item`.`song_price`, `Item`.`publish_date`, `Item`.`created`, `Item`.`updated` FROM `sumrra`.`items` AS `Item` WHERE `Item`.`discography_id` IN (9, 8, 7, 6, 5, 4, 3, 14) | 0 | 0 | 0 | |
| SELECT `reviewTranslation`.`id`, `reviewTranslation`.`locale`, `reviewTranslation`.`model`, `reviewTranslation`.`foreign_key`, `reviewTranslation`.`field`, `reviewTranslation`.`content`, `reviewTranslation`.`created`, `reviewTranslation`.`modified` FROM `sumrra`.`discography_i18ns` AS `reviewTranslation` WHERE `model` = 'Discography' AND `field` = 'review' AND `reviewTranslation`.`foreign_key` IN (9, 8, 7, 6, 5, 4, 3, 14) ORDER BY `id` ASC | 12 | 12 | 0 | |
| SELECT `Artist`.`id`, `Artist`.`name`, `Artist`.`surname`, `Artist`.`artistic_name`, `Artist`.`instrument`, `Artist`.`email`, `Artist`.`web`, `Artist`.`facebook`, `Artist`.`twitter`, `Artist`.`bandcamp`, `Artist`.`soundcloud`, `Artist`.`spotify`, `Artist`.`youtube`, `Artist`.`description`, `Artist`.`city`, `Artist`.`province`, `Artist`.`country`, `Artist`.`birthdate`, `Artist`.`created`, `Artist`.`modified`, `DiscographiesArtist`.`id`, `DiscographiesArtist`.`discography_id`, `DiscographiesArtist`.`artist_id`, `DiscographiesArtist`.`created`, `DiscographiesArtist`.`modified` FROM `sumrra`.`artists` AS `Artist` JOIN `sumrra`.`discographies_artists` AS `DiscographiesArtist` ON (`DiscographiesArtist`.`discography_id` IN (9, 8, 7, 6, 5, 4, 3, 14) AND `DiscographiesArtist`.`artist_id` = `Artist`.`id`) | 0 | 0 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `sumrra`.`tags` AS `Tag` JOIN `sumrra`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (9, 8, 7, 6, 5, 4, 3, 14) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Discography' | 0 | 0 | 0 | |
| SELECT `Article`.`id`, `Article`.`title`, `Article`.`summary`, `Article`.`content`, `Article`.`attach_type`, `Article`.`audio`, `Article`.`video`, `Article`.`publish_date`, `Article`.`created`, `Article`.`updated`, (`I18n__titleTranslation`.`content`) AS `Article__i18n_titleTranslation`, (`I18n__summaryTranslation`.`content`) AS `Article__i18n_summaryTranslation`, (`I18n__contentTranslation`.`content`) AS `Article__i18n_contentTranslation` FROM `sumrra`.`articles` AS `Article` INNER JOIN `sumrra`.`article_i18ns` AS `I18n__titleTranslation` ON (`Article`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Article' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` IN ('es', 'gl')) INNER JOIN `sumrra`.`article_i18ns` AS `I18n__summaryTranslation` ON (`Article`.`id` = `I18n__summaryTranslation`.`foreign_key` AND `I18n__summaryTranslation`.`model` = 'Article' AND `I18n__summaryTranslation`.`field` = 'summary' AND `I18n__summaryTranslation`.`locale` IN ('es', 'gl')) INNER JOIN `sumrra`.`article_i18ns` AS `I18n__contentTranslation` ON (`Article`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Article' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` IN ('es', 'gl')) WHERE ((`publish_date` <= '2026-01-03 03:40:21') OR (`publish_date` IS NULL)) GROUP BY `Article`.`id` | 0 | 0 | 0 | |