explain

ActivePublic

Actions

wikiadmin2023@10.192.16.4(enwiki)> EXPLAIN SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_content_model,page_namespace,page_title,linter_id,linter_params,linter_start,linter_end,linter_cat FROM `page` JOIN `linter` ON ((page_id=linter_page)) WHERE linter_cat = 25 ORDER BY linter_id LIMIT 51;
+------+-------------+--------+--------+----------------------------------------------------------------------------------------------+---------+---------+---------------------------+------+-------------+
| id   | select_type | table  | type   | possible_keys                                                                                | key     | key_len | ref                       | rows | Extra       |
+------+-------------+--------+--------+----------------------------------------------------------------------------------------------+---------+---------+---------------------------+------+-------------+
|    1 | SIMPLE      | linter | index  | linter_cat_page_position,linter_page,linter_cat_namespace,linter_cat_template,linter_cat_tag | PRIMARY | 4       | NULL                      | 259  | Using where |
|    1 | SIMPLE      | page   | eq_ref | PRIMARY                                                                                      | PRIMARY | 4       | enwiki.linter.linter_page | 1    |             |
+------+-------------+--------+--------+----------------------------------------------------------------------------------------------+---------+---------+---------------------------+------+-------------+
2 rows in set (0.001 sec)