id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE schedules index_merge idspectacle_2, date, idcontact date, idcontact 3, 5 1 Using intersect(date, idcontact); Using where