Mysql-索引优化分析

SELECT DISTINCT <select_list>
FROM <left_table> 
<join_type> JOIN <right_table> 
ON <join_condition>
WHERE <where_condition>
GROUP BY <group_by_list>
HAVING <having_condition>
ORDER BY <order_by_condition>
LIMIT <limit_number>　　SELECT DISTINCT <sel