idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEgoodindex_mergeis_delete,visibilityis_delete,visibility1,5NULL119Using intersect(is_delete,visibility); Using where; Using index