Database is isolation level RR, assuming that when you determine inventory just==1 to carry out stock=update stock - 1, will just lock the thread is quicker than he get, so there will be oversold phenomenon? I can think of is when judging inventory plus for updata, but I don't know SSM (boot + batis) what is the transaction, will commit to me directly? Then it's pointless to me this select,