Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Playlist`.`id`, `Playlist`.`title` FROM `aquarelle`.`playlists` AS `Playlist` WHERE `user_id` IS NULL | 0 | 0 | 1 | maybe slow |
SELECT `Compositeur`.`id`, `Compositeur`.`nom`, `Compositeur`.`prenom`, `Compositeur`.`annee_naissance`, `Compositeur`.`annee_mort`, `Compositeur`.`biographie`, `Compositeur`.`photo`, `Compositeur`.`slug`, `Compositeur`.`video`, (CONCAT(`Compositeur`.`prenom`, " ", `Compositeur`.`nom`)) AS `Compositeur__fullname` FROM `aquarelle`.`compositeurs` AS `Compositeur` WHERE `Compositeur`.`slug` = 'kodaly_zoltan' ORDER BY `Compositeur`.`prenom` asc, `Compositeur`.`nom` asc LIMIT 1 | 1 | 1 | 1 | |
SELECT `Oeuvre`.`id`, `Oeuvre`.`titre`, `Oeuvre`.`visuel`, `CompositeursOeuvre`.`id`, `CompositeursOeuvre`.`oeuvre_id`, `CompositeursOeuvre`.`compositeur_id` FROM `aquarelle`.`oeuvres` AS `Oeuvre` JOIN `aquarelle`.`compositeurs_oeuvres` AS `CompositeursOeuvre` ON (`CompositeursOeuvre`.`compositeur_id` = 32 AND `CompositeursOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 1 | 1 | 1 | |
SELECT `Concert`.`date`, `Concert`.`id` FROM `aquarelle`.`concerts` AS `Concert` INNER JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`ConcertsOeuvre`.`concert_id` = `Concert`.`id`) WHERE `ConcertsOeuvre`.`oeuvre_id` = 92 ORDER BY `Concert`.`date` desc | 3 | 3 | 1 | maybe slow |
SELECT `Song`.`id`, `Song`.`title`, `Song`.`album`, `Song`.`artist`, `Song`.`source_path`, `Song`.`path`, `Song`.`cover`, `Song`.`playtime`, `Song`.`track_number`, `Song`.`concerts_oeuvre_id`, `Song`.`year`, `Song`.`disc`, `Song`.`band`, `Song`.`genre`, `Song`.`created`, `Song`.`modified`, `Song`.`order_mouvement`, `Song`.`vue`, `ConcertsOeuvre`.`id`, `ConcertsOeuvre`.`concert_id`, `ConcertsOeuvre`.`oeuvre_id` FROM `aquarelle`.`songs` AS `Song` LEFT JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`Song`.`concerts_oeuvre_id` = `ConcertsOeuvre`.`id`) WHERE `ConcertsOeuvre`.`oeuvre_id` = 92 AND `ConcertsOeuvre`.`concert_id` = 29 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 2 | 2 | 6 | maybe slow |
SELECT `Interprete`.`id`, `Interprete`.`type`, `Interprete`.`nom`, `Interprete`.`prenom`, `Interprete`.`biographie`, `Interprete`.`photo`, `Interprete`.`site`, `Interprete`.`slug`, `Interprete`.`video`, (CONCAT(`Interprete`.`prenom`, " ", `Interprete`.`nom`)) AS `Interprete__fullname`, `InterpretesSong`.`id`, `InterpretesSong`.`song_id`, `InterpretesSong`.`interprete_id` FROM `aquarelle`.`interpretes` AS `Interprete` JOIN `aquarelle`.`interpretes_songs` AS `InterpretesSong` ON (`InterpretesSong`.`song_id` IN (427, 141) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 4 | 4 | 1 | maybe slow |
SELECT `Concert`.`id`, `Concert`.`festival_id`, `Concert`.`date`, `Concert`.`c_date`, `Concert`.`description`, `Concert`.`heure`, `Concert`.`titre`, `Concert`.`visuel`, `Concert`.`video`, `Festival`.`id`, `Festival`.`title`, `Festival`.`sub_title`, `Festival`.`description`, `Festival`.`date`, `Festival`.`cover`, `Festival`.`active`, `Festival`.`partenaire_id` FROM `aquarelle`.`concerts` AS `Concert` LEFT JOIN `aquarelle`.`festivals` AS `Festival` ON (`Concert`.`festival_id` = `Festival`.`id`) INNER JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`ConcertsOeuvre`.`concert_id` = `Concert`.`id`) WHERE `ConcertsOeuvre`.`oeuvre_id` = 92 AND `ConcertsOeuvre`.`concert_id` = 29 ORDER BY `Concert`.`date` desc | 3 | 3 | 1 | maybe slow |
SELECT `Oeuvre`.`id`, `Oeuvre`.`titre`, `Oeuvre`.`visuel`, `ConcertsOeuvre`.`id`, `ConcertsOeuvre`.`concert_id`, `ConcertsOeuvre`.`oeuvre_id` FROM `aquarelle`.`oeuvres` AS `Oeuvre` JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`ConcertsOeuvre`.`concert_id` = 29 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 13 | 13 | 1 | maybe slow |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '16' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '42' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '42' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '16' | 1 | 1 | 0 | |
SELECT `Song`.`id`, `Song`.`title`, `Song`.`album`, `Song`.`artist`, `Song`.`source_path`, `Song`.`path`, `Song`.`cover`, `Song`.`playtime`, `Song`.`track_number`, `Song`.`concerts_oeuvre_id`, `Song`.`year`, `Song`.`disc`, `Song`.`band`, `Song`.`genre`, `Song`.`created`, `Song`.`modified`, `Song`.`order_mouvement`, `Song`.`vue`, `ConcertsOeuvre`.`id`, `ConcertsOeuvre`.`concert_id`, `ConcertsOeuvre`.`oeuvre_id` FROM `aquarelle`.`songs` AS `Song` LEFT JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`Song`.`concerts_oeuvre_id` = `ConcertsOeuvre`.`id`) WHERE `ConcertsOeuvre`.`oeuvre_id` = 92 AND `ConcertsOeuvre`.`concert_id` = 29 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 2 | 2 | 5 | maybe slow |
SELECT `Interprete`.`id`, `Interprete`.`type`, `Interprete`.`nom`, `Interprete`.`prenom`, `Interprete`.`biographie`, `Interprete`.`photo`, `Interprete`.`site`, `Interprete`.`slug`, `Interprete`.`video`, (CONCAT(`Interprete`.`prenom`, " ", `Interprete`.`nom`)) AS `Interprete__fullname`, `InterpretesSong`.`id`, `InterpretesSong`.`song_id`, `InterpretesSong`.`interprete_id` FROM `aquarelle`.`interpretes` AS `Interprete` JOIN `aquarelle`.`interpretes_songs` AS `InterpretesSong` ON (`InterpretesSong`.`song_id` IN (427, 141) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 4 | 4 | 1 | maybe slow |
SELECT `Concert`.`id`, `Concert`.`festival_id`, `Concert`.`date`, `Concert`.`c_date`, `Concert`.`description`, `Concert`.`heure`, `Concert`.`titre`, `Concert`.`visuel`, `Concert`.`video`, `Festival`.`id`, `Festival`.`title`, `Festival`.`sub_title`, `Festival`.`description`, `Festival`.`date`, `Festival`.`cover`, `Festival`.`active`, `Festival`.`partenaire_id` FROM `aquarelle`.`concerts` AS `Concert` LEFT JOIN `aquarelle`.`festivals` AS `Festival` ON (`Concert`.`festival_id` = `Festival`.`id`) INNER JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`ConcertsOeuvre`.`concert_id` = `Concert`.`id`) WHERE `ConcertsOeuvre`.`oeuvre_id` = 92 AND `ConcertsOeuvre`.`concert_id` = 29 ORDER BY `Concert`.`date` desc | 3 | 3 | 1 | maybe slow |
SELECT `Oeuvre`.`id`, `Oeuvre`.`titre`, `Oeuvre`.`visuel`, `ConcertsOeuvre`.`id`, `ConcertsOeuvre`.`concert_id`, `ConcertsOeuvre`.`oeuvre_id` FROM `aquarelle`.`oeuvres` AS `Oeuvre` JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`ConcertsOeuvre`.`concert_id` = 29 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 13 | 13 | 1 | maybe slow |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '16' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '42' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '42' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '16' | 1 | 1 | 0 | |
SELECT `Song`.`id`, `Song`.`title`, `Song`.`album`, `Song`.`artist`, `Song`.`source_path`, `Song`.`path`, `Song`.`cover`, `Song`.`playtime`, `Song`.`track_number`, `Song`.`concerts_oeuvre_id`, `Song`.`year`, `Song`.`disc`, `Song`.`band`, `Song`.`genre`, `Song`.`created`, `Song`.`modified`, `Song`.`order_mouvement`, `Song`.`vue`, `ConcertsOeuvre`.`id`, `ConcertsOeuvre`.`concert_id`, `ConcertsOeuvre`.`oeuvre_id` FROM `aquarelle`.`songs` AS `Song` LEFT JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`Song`.`concerts_oeuvre_id` = `ConcertsOeuvre`.`id`) WHERE `ConcertsOeuvre`.`oeuvre_id` = 92 AND `ConcertsOeuvre`.`concert_id` = 29 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 2 | 2 | 5 | maybe slow |
SELECT `Interprete`.`id`, `Interprete`.`type`, `Interprete`.`nom`, `Interprete`.`prenom`, `Interprete`.`biographie`, `Interprete`.`photo`, `Interprete`.`site`, `Interprete`.`slug`, `Interprete`.`video`, (CONCAT(`Interprete`.`prenom`, " ", `Interprete`.`nom`)) AS `Interprete__fullname`, `InterpretesSong`.`id`, `InterpretesSong`.`song_id`, `InterpretesSong`.`interprete_id` FROM `aquarelle`.`interpretes` AS `Interprete` JOIN `aquarelle`.`interpretes_songs` AS `InterpretesSong` ON (`InterpretesSong`.`song_id` IN (427, 141) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 4 | 4 | 1 | maybe slow |
SELECT `Concert`.`id`, `Concert`.`festival_id`, `Concert`.`date`, `Concert`.`c_date`, `Concert`.`description`, `Concert`.`heure`, `Concert`.`titre`, `Concert`.`visuel`, `Concert`.`video`, `Festival`.`id`, `Festival`.`title`, `Festival`.`sub_title`, `Festival`.`description`, `Festival`.`date`, `Festival`.`cover`, `Festival`.`active`, `Festival`.`partenaire_id` FROM `aquarelle`.`concerts` AS `Concert` LEFT JOIN `aquarelle`.`festivals` AS `Festival` ON (`Concert`.`festival_id` = `Festival`.`id`) INNER JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`ConcertsOeuvre`.`concert_id` = `Concert`.`id`) WHERE `ConcertsOeuvre`.`oeuvre_id` = 92 AND `ConcertsOeuvre`.`concert_id` = 29 ORDER BY `Concert`.`date` desc | 3 | 3 | 1 | maybe slow |
SELECT `Oeuvre`.`id`, `Oeuvre`.`titre`, `Oeuvre`.`visuel`, `ConcertsOeuvre`.`id`, `ConcertsOeuvre`.`concert_id`, `ConcertsOeuvre`.`oeuvre_id` FROM `aquarelle`.`oeuvres` AS `Oeuvre` JOIN `aquarelle`.`concerts_oeuvres` AS `ConcertsOeuvre` ON (`ConcertsOeuvre`.`concert_id` = 29 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 13 | 13 | 1 | maybe slow |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '16' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '42' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '42' | 1 | 1 | 0 | |
SELECT `Instrument`.`id`, `Instrument`.`libelle` FROM `aquarelle`.`instruments` AS `Instrument` INNER JOIN `aquarelle`.`instruments_interpretes` AS `InstrumentInterprete` ON (`InstrumentInterprete`.`instrument_id` = `Instrument`.`id`) WHERE `InstrumentInterprete`.`interprete_id` = '16' | 1 | 1 | 0 | |