MariaDB [SNCF]> source ~/query2.sql
+------+-------------+---------------+--------+-----------------+------------+---------+----------------------------+-------+----------------------------------------------+
| id   | select_type | table         | type   | possible_keys   | key        | key_len | ref                        | rows  | Extra                                        |
+------+-------------+---------------+--------+-----------------+------------+---------+----------------------------+-------+----------------------------------------------+
|    1 | SIMPLE      | trip          | ALL    | PRIMARY         | NULL       | NULL    | NULL                       | 49582 | Using where; Using temporary; Using filesort |
|    1 | SIMPLE      | route         | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.trip.route_id         | 1     |                                              |
|    1 | SIMPLE      | cal           | ref    | service_id      | service_id | 263     | SNCF.trip.service_id,const | 1     | Using where; Using index                     |
|    1 | SIMPLE      | time_départ   | ref    | trip_id,stop_id | trip_id    | 5       | SNCF.trip.id               | 9     | Using where                                  |
|    1 | SIMPLE      | départ        | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.time_départ.stop_id   | 1     | Using where                                  |
|    1 | SIMPLE      | time_arrivée  | ref    | trip_id,stop_id | trip_id    | 5       | SNCF.trip.id               | 9     | Using where                                  |
|    1 | SIMPLE      | arrivée       | eq_ref | PRIMARY         | PRIMARY    | 4       | SNCF.time_arrivée.stop_id  | 1     | Using where                                  |
+------+-------------+---------------+--------+-----------------+------------+---------+----------------------------+-------+----------------------------------------------+
7 rows in set (0.002 sec)