Slow queries continue running after php times out

The slow query log shows a number of long running queries (more than 2 hours) for counts.

The app should set a query timeout similar to the php execution timeout so these queries are stopped.