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://stackoverflow.com/a/1416023