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