wikiadmin2023@10.64.32.35(enwiki)> analyze SELECT  /*! STRAIGHT_JOIN */ file_name,fr_timestamp,actor_user,actor_name  FROM `file` JOIN `filerevision` ON ((file_latest=fr_id)) JOIN `actor` ON ((actor_id=fr_actor)) LEFT JOIN `user_groups` ON (ug_group = 'bot' AND (ug_user = actor_user) AND ((ug_expiry IS NULL OR ug_expiry >= '20260410142742')))   WHERE ug_group IS NULL  ORDER BY fr_timestamp DESC,file_name DESC LIMIT 51  ;
+------+-------------+--------------+--------+----------------------------+---------+---------+-------------------------------+---------+------------+----------+------------+---------------------------------+
| id   | select_type | table        | type   | possible_keys              | key     | key_len | ref                           | rows    | r_rows     | filtered | r_filtered | Extra                           |
+------+-------------+--------------+--------+----------------------------+---------+---------+-------------------------------+---------+------------+----------+------------+---------------------------------+
|    1 | SIMPLE      | file         | ALL    | file_latest                | NULL    | NULL    | NULL                          | 1018833 | 1003200.00 |   100.00 |     100.00 | Using temporary; Using filesort |
|    1 | SIMPLE      | filerevision | eq_ref | PRIMARY,fr_actor_timestamp | PRIMARY | 8       | enwiki.file.file_latest       | 1       | 0.96       |   100.00 |     100.00 |                                 |
|    1 | SIMPLE      | actor        | eq_ref | PRIMARY                    | PRIMARY | 8       | enwiki.filerevision.fr_actor  | 1       | 1.00       |   100.00 |     100.00 |                                 |
|    1 | SIMPLE      | user_groups  | eq_ref | PRIMARY,ug_group,ug_expiry | PRIMARY | 261     | enwiki.actor.actor_user,const | 1       | 0.28       |    50.53 |     100.00 | Using where; Not exists         |
+------+-------------+--------------+--------+----------------------------+---------+---------+-------------------------------+---------+------------+----------+------------+---------------------------------+
4 rows in set (6.654 sec)

wikiadmin2023@10.64.32.35(enwiki)>

wikiadmin2023@10.64.32.35(enwiki)> analyze SELECT  /*! STRAIGHT_JOIN */ img_name,img_timestamp,actor_user,actor_name  FROM `image` JOIN `actor` ON ((actor_id=img_actor)) LEFT JOIN `user_groups` ON (ug_group = 'bot' AND (ug_user = actor_user) AND ((ug_expiry IS NULL OR ug_expiry >= '20260410144340')))   WHERE ug_group IS NULL  ORDER BY img_timestamp DESC,img_name DESC LIMIT 51  ;
+------+-------------+-------------+--------+----------------------------+---------------+---------+-------------------------------+--------+--------+----------+------------+-------------------------+
| id   | select_type | table       | type   | possible_keys              | key           | key_len | ref                           | rows   | r_rows | filtered | r_filtered | Extra                   |
+------+-------------+-------------+--------+----------------------------+---------------+---------+-------------------------------+--------+--------+----------+------------+-------------------------+
|    1 | SIMPLE      | image       | index  | img_actor_timestamp        | img_timestamp | 14      | NULL                          | 833611 | 51.00  |   100.00 |     100.00 |                         |
|    1 | SIMPLE      | actor       | eq_ref | PRIMARY                    | PRIMARY       | 8       | enwiki.image.img_actor        | 1      | 1.00   |   100.00 |     100.00 |                         |
|    1 | SIMPLE      | user_groups | eq_ref | PRIMARY,ug_group,ug_expiry | PRIMARY       | 261     | enwiki.actor.actor_user,const | 1      | 0.00   |    50.53 |     100.00 | Using where; Not exists |
+------+-------------+-------------+--------+----------------------------+---------------+---------+-------------------------------+--------+--------+----------+------------+-------------------------+
3 rows in set (0.003 sec)

wikiadmin2023@10.64.32.35(enwiki)>

wikiadmin2023@10.64.32.35(enwiki)> explain SELECT /*! STRAIGHT_JOIN */ file_name,fr_timestamp,actor_user,actor_name FROM `filerevision` JOIN `file` ON ((file_latest=fr_id)) JOIN `actor` ON ((actor_id=fr_actor)) LEFT JOIN `user_groups` ON (ug_group = 'bot' AND (ug_user = actor_user) AND ((ug_expiry IS NULL OR ug_expiry >= '20260410152454'))) WHERE ug_group IS NULL ORDER BY fr_timestamp DESC LIMIT 51;
+------+-------------+--------------+--------+----------------------------+--------------+---------+-------------------------------+------+-------------------------+
| id   | select_type | table        | type   | possible_keys              | key          | key_len | ref                           | rows | Extra                   |
+------+-------------+--------------+--------+----------------------------+--------------+---------+-------------------------------+------+-------------------------+
|    1 | SIMPLE      | filerevision | index  | PRIMARY,fr_actor_timestamp | fr_timestamp | 14      | NULL                          | 100  |                         |
|    1 | SIMPLE      | file         | ref    | file_latest                | file_latest  | 8       | enwiki.filerevision.fr_id     | 1    |                         |
|    1 | SIMPLE      | actor        | eq_ref | PRIMARY                    | PRIMARY      | 8       | enwiki.filerevision.fr_actor  | 1    |                         |
|    1 | SIMPLE      | user_groups  | eq_ref | PRIMARY,ug_group,ug_expiry | PRIMARY      | 261     | enwiki.actor.actor_user,const | 1    | Using where; Not exists |
+------+-------------+--------------+--------+----------------------------+--------------+---------+-------------------------------+------+-------------------------+
4 rows in set (0.001 sec)

wikiadmin2023@10.64.32.35(enwiki)>