在这里假设InnoDB，您可以使用

Assuming InnoDB here, you can use SELECT ... LOCK IN SHARE MODE to lock the rows when you select them.