Use the EXPLAIN request modifier with an SQL request to determine what locks are set when the request is executed.