| 1 |
SIMPLE |
schedules |
range |
idspectacle_2, date, idcontact |
date |
3 |
|
1680 |
Using index condition; Using where; Using temporary; Using filesort |
| 1 |
SIMPLE |
object_multimedia |
ref |
idobject, idrole, idmultimedia, object |
idobject |
5 |
theatreok_dev.schedules.idspectacle, const |
1 |
Using where; Using index |
| 1 |
SIMPLE |
multimedias |
eq_ref |
PRIMARY, publish |
PRIMARY |
4 |
theatreok_dev.object_multimedia.idmultimedia |
1 |
Using where |
| 1 |
SIMPLE |
contacts |
eq_ref |
PRIMARY, country |
PRIMARY |
4 |
theatreok_dev.schedules.idcontact |
1 |
Using where |
| 1 |
SIMPLE |
spectacles |
eq_ref |
PRIMARY |
PRIMARY |
4 |
theatreok_dev.schedules.idspectacle |
1 |
Using index |