cat nowcoder.txt 
| grep :3306 
| awk '{print $(NF-1),$NF}' 
| awk '{split($1,arr,":");print arr[1],$2}' 
| awk 'BEGIN{nEST=0;nLk=0} {nEST++;arr[$1]++;nLK++} END{print "TOTAL_IP",length(arr),"\nESTABLISHED",nEST,"\nTOTAL_LINK",nLK}'