EXPLAIN [EXTENDED] SELECT
is synonymous with
COLUMNS FROM .
When you precede a
statement with the keyword
EXPLAIN, MySQL displays
information from the optimizer about the query execution plan.
That is, MySQL explains how it would process the
SELECT, including information
about how tables are joined and in which order.
EXTENDED can be used to provide additional