| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | sc | range | idspectacle_2, date | date | 3 | 321 | Using index condition; Using where | |
| 1 | SIMPLE | s | eq_ref | PRIMARY | PRIMARY | 4 | theatreok_dev.sc.idspectacle | 1 | Using index |
| 1 | SIMPLE | om | ref | idobject, object | idobject | 5 | theatreok_dev.sc.idspectacle, const | 2 | Using where; Using index |