Code: Select all
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 setup has 2.3 million short urls.