mysql explain 经典实战案例1

explain 经典实战案例1

explain select d1.name,(select id from t3) d2
from (select id, name from t1 where other_column='')d1
union
(select named from t2);