,,,,,,

CodePudding user response:

With analyze check the SQL execution plan, see which steps there may be optimized

CodePudding user response:

Mysql index using a b + tree record

CodePudding user response:

If the SQL have gone index, it can only consider the depots table

CodePudding user response:

Using mysql slow query log, find the specified SQL, 100000 data, index, more than 100 w to query methods can
More than 500 w, it will consider the table

CodePudding user response:

Locating slow query