MariaDB [SNCF]> source ~/query.sql
+------+--------------------+----------------+--------+-----------------+------------+---------+-----------------------------+--------+-------------------------------------------------+
| id   | select_type        | table          | type   | possible_keys   | key        | key_len | ref                         | rows   | Extra                                           |
+------+--------------------+----------------+--------+-----------------+------------+---------+-----------------------------+--------+-------------------------------------------------+
|    1 | PRIMARY            | stop_times     | ALL    | trip_id,stop_id | NULL       | NULL    | NULL                        | 430745 | Using where; Using temporary; Using filesort    |
|    1 | PRIMARY            | stops          | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.stop_times.stop_id     | 1      |                                                 |
|    1 | PRIMARY            | trips          | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.stop_times.trip_id     | 1      | Using where                                     |
|    1 | PRIMARY            | tec_trips      | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.stop_times.trip_id     | 1      | Using where                                     |
|    1 | PRIMARY            | tec_routes     | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.tec_trips.route_id     | 1      |                                                 |
|    1 | PRIMARY            | routes         | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.trips.route_id         | 1      |                                                 |
|    1 | PRIMARY            | calendar_dates | ref    | service_id      | service_id | 263     | SNCF.trips.service_id,const | 1      | Using where                                     |
|    1 | PRIMARY            | calendar_dates | ref    | service_id      | service_id | 263     | SNCF.trips.service_id,const | 1      | Using where; Using index                        |
|    1 | PRIMARY            | trips          | ALL    | PRIMARY         | NULL       | NULL    | NULL                        | 49582  | Using where; Using join buffer (flat, BNL join) |
|    1 | PRIMARY            | routes         | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.trips.route_id         | 1      |                                                 |
|    1 | PRIMARY            | stop_times     | ref    | trip_id,stop_id | trip_id    | 5       | SNCF.trips.id               | 9      | Using where                                     |
|    1 | PRIMARY            | stops          | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.stop_times.stop_id     | 1      |                                                 |
|   21 | SUBQUERY           | <derived46>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   46 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   48 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   47 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   20 | SUBQUERY           | <derived43>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   43 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   45 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   44 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   11 | SUBQUERY           | <derived28>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   28 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   30 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   29 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   10 | SUBQUERY           | <derived25>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   25 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   27 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   26 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|    6 | DEPENDENT SUBQUERY | tec_stops      | eq_ref | PRIMARY         | PRIMARY    | 4       | func                        | 1      | Using where                                     |
|    7 | SUBQUERY           | <derived2>     | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|    2 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|    4 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|    3 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|    8 | DEPENDENT UNION    | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|    9 | SUBQUERY           | <derived22>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   22 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   24 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   23 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
| NULL | UNION RESULT       | <union6,8>     | ALL    | NULL            | NULL       | NULL    | NULL                        | NULL   |                                                 |
|   18 | SUBQUERY           | <derived40>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   40 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   42 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   41 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   17 | SUBQUERY           | <derived37>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   37 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   39 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   38 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   13 | DEPENDENT SUBQUERY | tec_stops      | eq_ref | PRIMARY         | PRIMARY    | 4       | func                        | 1      | Using where                                     |
|   14 | SUBQUERY           | <derived31>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   31 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   33 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   32 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   15 | DEPENDENT UNION    | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   16 | SUBQUERY           | <derived34>    | system | NULL            | NULL       | NULL    | NULL                        | 1      |                                                 |
|   34 | DERIVED            | NULL           | NULL   | NULL            | NULL       | NULL    | NULL                        | NULL   | No tables used                                  |
|   36 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
|   35 | SUBQUERY           | tec_stops      | ALL    | NULL            | NULL       | NULL    | NULL                        | 8892   | Using where                                     |
| NULL | UNION RESULT       | <union13,15>   | ALL    | NULL            | NULL       | NULL    | NULL                        | NULL   |                                                 |
+------+--------------------+----------------+--------+-----------------+------------+---------+-----------------------------+--------+-------------------------------------------------+
58 rows in set (0.051 sec)