MariaDB [toucher_admin]> ANALYZE
    ->         SELECT clubs.name, club_teams.name
    ->           FROM clubs
    ->           JOIN club_teams USING (club_id)
    ->          ORDER BY clubs.name
    -> ;
+------+-------------+------------+--------+---------------+---------+---------+----------------------------------+------+--------+----------+------------+---------------------------------+
| id   | select_type | table      | type   | possible_keys | key     | key_len | ref                              | rows | r_rows | filtered | r_filtered | Extra                           |
+------+-------------+------------+--------+---------------+---------+---------+----------------------------------+------+--------+----------+------------+---------------------------------+
|    1 | SIMPLE      | club_teams | ALL    | PRIMARY       | NULL    | NULL    | NULL                             | 14   | 14.00  |   100.00 |     100.00 | Using temporary; Using filesort |
|    1 | SIMPLE      | clubs      | eq_ref | club_id       | club_id | 4       | toucher_admin.club_teams.club_id | 1    | 1.00   |   100.00 |     100.00 | Using index                     |
+------+-------------+------------+--------+---------------+---------+---------+----------------------------------+------+--------+----------+------------+---------------------------------+
2 rows in set (0.001 sec)

MariaDB [toucher_admin]> ANALYZE FORMAT=JSON
    ->         SELECT clubs.name, club_teams.name
    ->           FROM clubs
    ->           JOIN club_teams USING (club_id)
    ->          ORDER BY clubs.name
    -> ;
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ANALYZE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query_block": {
    "select_id": 1,
    "r_loops": 1,
    "r_total_time_ms": 0.1496,
    "filesort": {
      "sort_key": "clubs."name"",
      "r_loops": 1,
      "r_total_time_ms": 0.0221,
      "r_used_priority_queue": false,
      "r_output_rows": 14,
      "r_buffer_size": "12Kb",
      "temporary_table": {
        "table": {
          "table_name": "club_teams",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "r_loops": 1,
          "rows": 14,
          "r_rows": 14,
          "r_total_time_ms": 0.0366,
          "filtered": 100,
          "r_filtered": 100
        },
        "table": {
          "table_name": "clubs",
          "access_type": "eq_ref",
          "possible_keys": ["club_id"],
          "key": "club_id",
          "key_length": "4",
          "used_key_parts": ["club_id"],
          "ref": ["toucher_admin.club_teams.club_id"],
          "r_loops": 14,
          "rows": 1,
          "r_rows": 1,
          "r_total_time_ms": 0.022,
          "filtered": 100,
          "r_filtered": 100,
          "using_index": true
        }
      }
    }
  }
} |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)