id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ALL 63869 Using where 1 PRIMARY DEGREE1 ALL 741 1 PRIMARY KD1 ALL 11558 1 PRIMARY ENUMGRADE1 ALL 3859 1 PRIMARY ENUMSTATUS1 ALL 3859 1 PRIMARY DEGREE2 ALL 741 1 PRIMARY KD2 ALL 11558 1 PRIMARY ENUMGRADE2 ALL 3859 1 PRIMARY ENUMSTATUS2 ALL 3859 1 PRIMARY DEGREE3 ALL 741 1 PRIMARY KD3 ALL 11558 1 PRIMARY ENUMGRADE3 ALL 3859 1 PRIMARY ENUMSTATUS3 ALL 3859 1 PRIMARY DEGREE4 ALL 741 1 PRIMARY ENUMEDULEVEL1 ALL 3859 1 PRIMARY ENUMEDULEVEL2 ALL 3859 1 PRIMARY ENUMEDULEVEL3 ALL 3859 1 PRIMARY ENUMEDULEVEL4 ALL 3859 1 PRIMARY KD4 ALL 11558 1 PRIMARY ENUMGRADE4 ALL 3859 1 PRIMARY ENUMSTATUS4 ALL 3859 1 PRIMARY REG4 ALL 36809 1 PRIMARY CEH ALL 1 1 PRIMARY RS ALL 1 2 DEPENDENT SUBQUERY CANDIDATE_FILTER_SCORE ALL 1 Using where