grep 2018-03-07T16 access.log |awk '{arrs[$5]+=1} END {for(k in arrs) {print k,arrs[k]}}'|sort -nr -k 2|head -10
grep -E "Preparing" ~/xxxx.log |awk -F ":" '{m[$6]+=1} END {for(k in m){print m[k] , k}}'|sort -nrk1 >~/sqluniq.log
grep 2018-03-07T16 access.log |awk '{arrs[$5]+=1} END {for(k in arrs) {print k,arrs[k]}}'|sort -nr -k 2|head -10
grep -E "Preparing" ~/xxxx.log |awk -F ":" '{m[$6]+=1} END {for(k in m){print m[k] , k}}'|sort -nrk1 >~/sqluniq.log