Explaining a request may not report the names of all underlying database objects accessed by the request, but does provide the names of all the base tables accessed.
To determine the objects that a view accesses, including any nested views, use the SHOW statement. See SHOW request.
For example, the following request reports the create text and containing databases for all underlying tables and views accessed by view_name.
SHOW QUALIFIED SELECT * FROM view_name;
However, the following request reports only the underlying tables accessed by view_name, and not any nested views that are accessed.
EXPLAIN SELECT * FROM view_name;