阅读本文，对您有所帮助

http://www.databasejournal.com/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm [

Have a read of this article, it will help you

http://www.databasejournal.com/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm[^]

So, you need to check your SQL statements. Only then will you know what indexes you should be creating on what tables so that your search SQL is optimised correctly.