MySQL查询太慢，我该如何改进呢?

I have this query, that on a table with ~300.000 rows take about 14sec to extract data. This table will increase its size in the near future...over a million rows. I have used the I have this query, that on a table with ~300.00