Troubleshoot Slow MySQL QueriesBy Dag, on December 30th, 2016
A normal MySQL powered website will cache its results for a while, which makes troubleshooting slow queries very unpractical as they will only be slow on initial loads. Using SQL_NO_CACHE should give you a realistic load time per query as long as the query is not already cached.
Turning off caching per query can be very helpful when troubleshooting:
SELECT SQL_NO_CACHE * FROM tblTable