Who locked my column?

A look into MySQL Transaction Handling by showing unwanted table locks experienced on a REST API.