"One: The meaning of the MySQL query plan output column:
1.id: The identification of each operation performed independently, indicating the order in which the objects are manipulated, the larger the ID value, the first execution, and, if the same, the order of execution from top to bottom.
2.select_type: The type of each SELECT clause in the query.
3.table: Name, the name of the object being manipulated, usually the table name, but there are other formats.
4.partitions: Matching partition information (null for non-partitioned table values).
5.type: The type of connection operation.
6.possible_keys: Alternate index (lists the indexes that may be used).
7.key: The index selected by the optimizer; The Analyze table command is often used to enable the optimizer to correctly select an index.
8.key_len: The length of the index key selected by the optimizer, in bytes.
9.ref: A Reference object that represents the object that the bank is manipulating (the referenced object may be a const representation, or it may be the object that the key of the other table points to).
10.rows: The number of tuples scanned by the query execution (this value is an estimate for InnoDB).
11.filtered: According to the percentage of the number of tuples filtered by the data on the condition table, rows x filtered/100 can find out the number of tuples that have been filtered, that is, the actual number of tuples.
12.extra:mysql important supplemental information to query plans during query optimizer execution of queries. "
The meaning of the MySQL query plan output column