Hey there! Does checking the MySQL processes on the server directly with the "mysqladmin proc status" command give you any more detail about those processes? That will show what is happening with the service in real-time, including the status of the queries and how long they have been running.
If the issue is always wit the same query, it is most likely an issue with the coding of the query and not a problem with MySQL itself.