https://preprod.theatre-contemporain.net/spectacles/Seras-tu-la/videos/?path=spectacles%2FSeras-tu-la%2Fvideos

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE object_multimedia index_merge idobject, idrole, idmultimedia, object idmultimedia, idrole 4, 3 2 Using intersect(idmultimedia, idrole); Using where; Using filesort
1 SIMPLE persons eq_ref PRIMARY PRIMARY 4 theatreok_dev.object_multimedia.idobject 1