| 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 ('gl', 'gl')) WHERE ((`publish_date` <= '2026-01-03 01:39:17') 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 `Video`.`id`, `Video`.`project_id`, `Video`.`video_type_id`, `Video`.`title`, `Video`.`director`, `Video`.`music`, `Video`.`lyrics`, `Video`.`duration`, `Video`.`link`, `Video`.`description`, `Video`.`publish_date`, `Video`.`created`, `Video`.`updated`, (`I18n__descriptionTranslation`.`content`) AS `Video__i18n_descriptionTranslation`, `Project`.`id`, `Project`.`project`, `Project`.`artist_id`, `Project`.`description`, `Project`.`created`, `Project`.`updated`, `VideoType`.`id`, `VideoType`.`type`, `VideoType`.`description`, `VideoType`.`created`, `VideoType`.`updated` FROM `sumrra`.`videos` AS `Video` LEFT JOIN `sumrra`.`projects` AS `Project` ON (`Video`.`project_id` = `Project`.`id`) LEFT JOIN `sumrra`.`video_types` AS `VideoType` ON (`Video`.`video_type_id` = `VideoType`.`id`) INNER JOIN `sumrra`.`video_i18ns` AS `I18n__descriptionTranslation` ON (`Video`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Video' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` IN ('gl', 'gl')) WHERE ((`publish_date` <= '2026-01-03 01:39:17') OR (`publish_date` IS NULL)) AND `VideoType`.`id` IS NULL GROUP BY `Video`.`id` ORDER BY `publish_date` ASC | 10 | 10 | 1 | maybe slow |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content`, `descriptionTranslation`.`created`, `descriptionTranslation`.`modified` FROM `sumrra`.`video_i18ns` AS `descriptionTranslation` WHERE `model` = 'Video' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) ORDER BY `id` ASC | 10 | 10 | 0 | |
| SELECT `VideoType`.`id`, `VideoType`.`type` FROM `sumrra`.`video_types` AS `VideoType` WHERE 1 = 1 | 0 | 0 | 0 | |