MySQL, Query, Optimization, Web Performance, Database.
Query optimization several directions 1, try to avoid full-text scanning, add an index to the corresponding field, apply the index to query 2, delete unused or duplicate index 3, query rewriting, equivalent conversion (predicate, sub-query, join query) 4, delete the content to repeat unnecessary