Query | Affected | Num. rows | Took (ms) | Actions |
---|
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` = '64' | 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` = '53' | 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` = '68' | 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` = '5' | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 4 | 4 | 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 (351, 51, 242, 434) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 20 | 20 | 2 | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Concert`.`date` desc | 5 | 5 | 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` = 1 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 16 | 16 | 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` = '68' | 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` = '64' | 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 `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` = '53' | 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` = '5' | 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 `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` = '68' | 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` = '53' | 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` = '64' | 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` = '5' | 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` = '53' | 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` = '64' | 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` = '68' | 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` = '5' | 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 `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` = '64' | 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` = '53' | 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` = '68' | 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` = '5' | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 4 | 4 | 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 (351, 51, 242, 434) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 20 | 20 | 2 | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Concert`.`date` desc | 5 | 5 | 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` = 1 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 16 | 16 | 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` = '68' | 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` = '64' | 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 `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` = '53' | 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` = '5' | 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 `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` = '68' | 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` = '53' | 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` = '64' | 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` = '5' | 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` = '53' | 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` = '64' | 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` = '68' | 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` = '5' | 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 `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` = '64' | 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` = '53' | 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` = '68' | 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` = '5' | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 4 | 4 | 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 (351, 51, 242, 434) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 20 | 20 | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Concert`.`date` desc | 5 | 5 | 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` = 1 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 16 | 16 | 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` = '68' | 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` = '64' | 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 | 1 | |
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` = '53' | 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` = '5' | 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 `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` = '68' | 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` = '53' | 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` = '64' | 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` = '5' | 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` = '53' | 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` = '64' | 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` = '68' | 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` = '5' | 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 `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` = '64' | 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` = '53' | 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` = '68' | 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` = '5' | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 4 | 4 | 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 (351, 51, 242, 434) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 20 | 20 | 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` = 2 AND `ConcertsOeuvre`.`concert_id` = 1 ORDER BY `Concert`.`date` desc | 5 | 5 | 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` = 1 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 16 | 16 | 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` = '68' | 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` = '64' | 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 `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` = '53' | 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` = '5' | 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 `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` = '68' | 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` = '53' | 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` = '64' | 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` = '5' | 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` = '53' | 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` = '64' | 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` = '68' | 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` = '5' | 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 `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` = '64' | 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` = '53' | 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` = '68' | 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` = '5' | 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` = 48 AND `ConcertsOeuvre`.`concert_id` = 15 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 (349, 458) 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` = 48 AND `ConcertsOeuvre`.`concert_id` = 15 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` = 15 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 15 | 15 | 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` = '64' | 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` = '35' | 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` = '64' | 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` = '35' | 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` = 48 AND `ConcertsOeuvre`.`concert_id` = 15 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 (349, 458) 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` = 48 AND `ConcertsOeuvre`.`concert_id` = 15 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` = 15 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 15 | 15 | 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` = '64' | 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` = '35' | 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` = '64' | 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` = '35' | 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` = 48 AND `ConcertsOeuvre`.`concert_id` = 15 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 (349, 458) 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` = 48 AND `ConcertsOeuvre`.`concert_id` = 15 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` = 15 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 15 | 15 | 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` = '64' | 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` = '35' | 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` = '64' | 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` = '35' | 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` = 172 AND `ConcertsOeuvre`.`concert_id` = 55 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 1 | 1 | 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` = 621 AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 2 | 2 | 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` = 172 AND `ConcertsOeuvre`.`concert_id` = 55 ORDER BY `Concert`.`date` desc | 2 | 2 | 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` = 55 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 23 | 23 | 1 | |
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` = '45' | 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` = '3' | 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` = 172 AND `ConcertsOeuvre`.`concert_id` = 55 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 1 | 1 | 8 | 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` = 621 AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 2 | 2 | 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` = 172 AND `ConcertsOeuvre`.`concert_id` = 55 ORDER BY `Concert`.`date` desc | 2 | 2 | 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` = 55 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 23 | 23 | 1 | |
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` = '45' | 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` = '3' | 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` = 215 AND `ConcertsOeuvre`.`concert_id` = 77 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 3 | 3 | 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 (704, 705, 751) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 15 | 15 | 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` = 215 AND `ConcertsOeuvre`.`concert_id` = 77 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` = 77 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` = '35' | 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` = '89' | 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` = '21' | 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` = '51' | 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` = '25' | 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` = '25' | 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` = '35' | 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` = '89' | 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` = '51' | 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` = '21' | 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` = '25' | 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` = '51' | 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` = '35' | 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` = '89' | 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` = '21' | 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` = 215 AND `ConcertsOeuvre`.`concert_id` = 77 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 3 | 3 | 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 (704, 705, 751) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 15 | 15 | 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` = 215 AND `ConcertsOeuvre`.`concert_id` = 77 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` = 77 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` = '35' | 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` = '89' | 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` = '21' | 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` = '51' | 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` = '25' | 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` = '25' | 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` = '35' | 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` = '89' | 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` = '51' | 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` = '21' | 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` = '25' | 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` = '51' | 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` = '35' | 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` = '89' | 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` = '21' | 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` = 215 AND `ConcertsOeuvre`.`concert_id` = 77 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 3 | 3 | 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 (704, 705, 751) AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 15 | 15 | 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` = 215 AND `ConcertsOeuvre`.`concert_id` = 77 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` = 77 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` = '35' | 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` = '89' | 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` = '21' | 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` = '51' | 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` = '25' | 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` = '25' | 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` = '35' | 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` = '89' | 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` = '51' | 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` = '21' | 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` = '25' | 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` = '51' | 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` = '35' | 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` = '89' | 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` = '21' | 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` = 264 AND `ConcertsOeuvre`.`concert_id` = 55 ORDER BY `Song`.`order_mouvement` asc, `Song`.`title` asc, `Song`.`album` asc, `Song`.`disc`+0 asc, `Song`.`track_number` asc | 1 | 1 | 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` = 657 AND `InterpretesSong`.`interprete_id` = `Interprete`.`id`) | 2 | 2 | 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` = 264 AND `ConcertsOeuvre`.`concert_id` = 55 ORDER BY `Concert`.`date` desc | 1 | 1 | 1 | |
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` = 55 AND `ConcertsOeuvre`.`oeuvre_id` = `Oeuvre`.`id`) | 23 | 23 | 1 | |
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` = '45' | 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` = '3' | 1 | 1 | 0 | |