https://preprod.theatre-contemporain.net/spectacles/theatre/affiche-videos?d=7&path=spectacles%2Ftheatre%2Faffiche-videos%2F

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE schedules range idspectacle_2, date, idcontact date 3 321 Using index condition; Using where; Using temporary; Using filesort
1 SIMPLE contacts eq_ref PRIMARY PRIMARY 4 theatreok_dev.schedules.idcontact 1 Using index
1 SIMPLE spectacles eq_ref PRIMARY PRIMARY 4 theatreok_dev.schedules.idspectacle 1 Using index
1 SIMPLE object_multimedia ref idobject, idrole, idmultimedia, object idobject 5 theatreok_dev.schedules.idspectacle, const 2 Using where; Using index
1 SIMPLE multimedias eq_ref PRIMARY, publish PRIMARY 4 theatreok_dev.object_multimedia.idmultimedia 1 Using where