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