My logs report this query to be slow (+60 seconds).
SELECT COUNT(id) AS total, shortUrl FROM shorturl WHERE status='active' GROUP BY shortUrl ORDER BY visits DESC LIMIT 10
on my setup when accessing the admin panel of short url. I believe that query is being called for the top 10 table. My...