ikiadmin2023@10.64.16.77(commonswiki)> explain SELECT  *  FROM (SELECT  file_id AS `img_file_id`,fr_id AS `img_filerevision_id`,file_name AS `img_name`,fr_size AS `img_size`,fr_width AS `img_width`,fr_height AS `img_height`,fr_metadata AS `img_metadata`,fr_bits AS `img_bits`,ft_media_type AS `img_media_type`,ft_major_mime AS `img_major_mime`,ft_minor_mime AS `img_minor_mime`,fr_timestamp AS `img_timestamp`,fr_sha1 AS `img_sha1`,fr_actor AS `img_actor`,image_actor.actor_user AS `img_user`,image_actor.actor_name AS `img_user_text`,comment_img_description.comment_text AS `img_description_text`,comment_img_description.comment_data AS `img_description_data`,comment_img_description.comment_id AS `img_description_cid`  FROM `file` JOIN `filerevision` ON ((file_latest = fr_id)) JOIN `filetypes` ON ((file_type = ft_id)) JOIN `actor` `image_actor` ON ((actor_id=fr_actor)) JOIN `comment` `comment_img_description` ON ((comment_img_description.comment_id = fr_description_id))   WHERE file_deleted = 0  ) `sqb1`    WHERE (img_timestamp < '20260317181512' OR (img_timestamp = '20260317181512' AND (img_name <= 'IN_Winamac_160372_1962_24000_geo_(TIF).tif')))  ORDER BY img_timestamp DESC,img_name DESC LIMIT 501  ;
+------+-------------+-------------------------+--------+-----------------------------------------+---------+---------+--------------------------------------------+-----------+----------------------------------------------+
| id   | select_type | table                   | type   | possible_keys                           | key     | key_len | ref                                        | rows      | Extra                                        |
+------+-------------+-------------------------+--------+-----------------------------------------+---------+---------+--------------------------------------------+-----------+----------------------------------------------+
|    1 | SIMPLE      | file                    | ALL    | file_name,file_latest                   | NULL    | NULL    | NULL                                       | 121806109 | Using where; Using temporary; Using filesort |
|    1 | SIMPLE      | filerevision            | eq_ref | PRIMARY,fr_actor_timestamp,fr_timestamp | PRIMARY | 8       | commonswiki.file.file_latest               | 1         | Using where                                  |
|    1 | SIMPLE      | filetypes               | eq_ref | PRIMARY                                 | PRIMARY | 2       | commonswiki.file.file_type                 | 1         |                                              |
|    1 | SIMPLE      | image_actor             | eq_ref | PRIMARY                                 | PRIMARY | 8       | commonswiki.filerevision.fr_actor          | 1         |                                              |
|    1 | SIMPLE      | comment_img_description | eq_ref | PRIMARY                                 | PRIMARY | 8       | commonswiki.filerevision.fr_description_id | 1         |                                              |
+------+-------------+-------------------------+--------+-----------------------------------------+---------+---------+--------------------------------------------+-----------+----------------------------------------------+
5 rows in set (0.003 sec)

wikiadmin2023@10.64.16.77(commonswiki)>

wikiadmin2023@10.64.32.58(commonswiki)> explain SELECT  img_name,img_size,img_width,img_height,img_metadata,img_bits,img_media_type,img_major_mime,img_minor_mime,img_timestamp,img_sha1,img_actor,image_actor.actor_user AS `img_user`,image_actor.actor_name AS `img_user_text`,comment_img_description.comment_text AS `img_description_text`,comment_img_description.comment_data AS `img_description_data`,comment_img_description.comment_id AS `img_description_cid`  FROM `image` JOIN `actor` `image_actor` ON ((actor_id=img_actor)) JOIN `comment` `comment_img_description` ON ((comment_img_description.comment_id = img_description_id))   WHERE (img_timestamp < '20260317181512' OR (img_timestamp = '20260317181512' AND (img_name <= 'IN_Winamac_160372_1962_24000_geo_(TIF).tif')))  ORDER BY img_timestamp DESC,img_name DESC LIMIT 5001  ;
+------+-------------+-------------------------+--------+-------------------------------------------+---------------+---------+--------------------------------------+----------+-------------+
| id   | select_type | table                   | type   | possible_keys                             | key           | key_len | ref                                  | rows     | Extra       |
+------+-------------+-------------------------+--------+-------------------------------------------+---------------+---------+--------------------------------------+----------+-------------+
|    1 | SIMPLE      | image                   | range  | PRIMARY,img_timestamp,img_actor_timestamp | img_timestamp | 271     | NULL                                 | 64542568 | Using where |
|    1 | SIMPLE      | image_actor             | eq_ref | PRIMARY                                   | PRIMARY       | 8       | commonswiki.image.img_actor          | 1        |             |
|    1 | SIMPLE      | comment_img_description | eq_ref | PRIMARY                                   | PRIMARY       | 8       | commonswiki.image.img_description_id | 1        |             |
+------+-------------+-------------------------+--------+-------------------------------------------+---------------+---------+--------------------------------------+----------+-------------+
3 rows in set (0.004 sec)

wikiadmin2023@10.64.32.58(commonswiki)>