咨询锁 adlock

https://github.com/digoal/blog/blob/master/201805/20180524_02.md

行级锁

select .. for update 

select .. for update skip locked

select .. for share