sql多表多行加读锁（共享锁）

SELECT foo.a, bar.a
FROM foo AS foo
LEFT JOIN bar AS bar ON foo.a = bar.a
WHERE foo.a = '123'
FOR UPDATE;

参考：https://*.com/a/1416023