wikiadmin2023@10.192.0.225(enwiki)> explain SELECT  actor_rev_user.actor_user AS `rev_user`  FROM `revision` JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = rev_comment_id))   WHERE rev_page = 62750956  ORDER BY rev_timestamp,rev_id LIMIT 1;
+------+-------------+---------------------+--------+-----------------------------------------------------------------+---------------+---------+--------------------------------+-------+-------------+
| id   | select_type | table               | type   | possible_keys                                                   | key           | key_len | ref                            | rows  | Extra       |
+------+-------------+---------------------+--------+-----------------------------------------------------------------+---------------+---------+--------------------------------+-------+-------------+
|    1 | SIMPLE      | revision            | index  | rev_actor_timestamp,rev_page_actor_timestamp,rev_page_timestamp | rev_timestamp | 14      | NULL                           | 17980 | Using where |
|    1 | SIMPLE      | actor_rev_user      | eq_ref | PRIMARY                                                         | PRIMARY       | 8       | enwiki.revision.rev_actor      | 1     |             |
|    1 | SIMPLE      | comment_rev_comment | eq_ref | PRIMARY                                                         | PRIMARY       | 8       | enwiki.revision.rev_comment_id | 1     | Using index |
+------+-------------+---------------------+--------+-----------------------------------------------------------------+---------------+---------+--------------------------------+-------+-------------+
3 rows in set (0.001 sec)

wikiadmin2023@10.192.0.225(enwiki)>