EXPLAIN SELECT QUERY
Tune your queries with EXPLAIN SELECT.
EXPLAIN SELECT is a critical SQL command to understand. Its output can help you understand how your SQL will perform before you ever execute a single query with them. It can also provide strong indications of where you need to make changes, such as with the creation of indexes.
