id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c const PRIMARY PRIMARY 4 const 1
1 SIMPLE sc ref idnew, idcontact idnew 4 const 1 Using where