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