id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE schedules range idspectacle_2, date idspectacle_2 8 16 Using index condition; Using where