Troubleshootng slow MySQL queries

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.

SELECT SQL_NO_QUERY * FROM tblTable