The query used to check if a SURL is pinned does not leverage the index built on the SURL hash value, resulting in all the rows being checked by MySQL to get the status of the SURL.
This causes unnecessary high load on the MySQL server and slows down request handling