| 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` <= '2025-12-20 01:28:45') OR (`publish_date` IS NULL)) GROUP BY `Discography`.`id` ORDER BY `release_date` DESC | 8 | 8 | 1 | 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 `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` <= '2025-12-20 01:28:45') OR (`publish_date` IS NULL)) GROUP BY `Discography`.`id` ORDER BY `Discography`.`role` asc, `Discography`.`release_date` DESC, `Discography`.`created` DESC LIMIT 10 | 8 | 8 | 1 | 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, 14, 7, 6, 5, 4, 3) | 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, 14, 7, 6, 5, 4, 3) | 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, 14, 7, 6, 5, 4, 3) 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, 14, 7, 6, 5, 4, 3) 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, 14, 7, 6, 5, 4, 3) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Discography' | 0 | 0 | 0 | |
| SELECT Tagged.tag_id, Tag.id, Tag.identifier, Tag.name, Tag.keyname, Tag.weight, COUNT(*) AS occurrence, `Tag`.`id` FROM `sumrra`.`tagged` AS `Tagged` LEFT JOIN `sumrra`.`tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) WHERE `model` = 'Discography' GROUP BY `Tagged`.`tag_id`, `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight` LIMIT 10 | 0 | 0 | 0 | |