awk '{if($5~/3306$/ && $6=="ESTABLISHED") print $5}' nowcoder.txt|
  awk -F: '{a[$1]++}END{for(k in a) print a[k],k}'|
    sort -k 1 -n -r