1 |
SIMPLE |
schedules |
index_merge |
idspectacle_2, idcontact, idcontact_festival |
idcontact, idcontact_festival |
5, 5 |
|
270 |
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 |