1 |
SIMPLE |
object_multimedia |
range |
idobject, idrole, idmultimedia, object |
idobject |
5 |
|
54 |
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 |
8 |
Using where; Using index |
1 |
SIMPLE |
contacts |
eq_ref |
PRIMARY |
PRIMARY |
4 |
theatreok_dev.schedules.idcontact |
1 |
Using index |