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