id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE schedules index_merge idspectacle_2, idcontact, idcontact_festival idcontact, idcontact_festival 5, 5 36 Using union(idcontact, idcontact_festival); Using where
1 SIMPLE spectacles eq_ref PRIMARY PRIMARY 4 theatreok_dev.schedules.idspectacle 1 Using where
1 SIMPLE spectacle_contact ref PRIMARY, idspectacle PRIMARY 4 theatreok_dev.schedules.idspectacle 1 Using index
1 SIMPLE object_content ref PRIMARY, idcontent PRIMARY 5 theatreok_dev.schedules.idspectacle, const 1 Using where; Using index
1 SIMPLE contents eq_ref PRIMARY PRIMARY 4 theatreok_dev.object_content.idcontent 1 Using where
1 SIMPLE content_classification eq_ref PRIMARY, idclassification PRIMARY 8 theatreok_dev.object_content.idcontent, const 1 Using index