SpecialWhatLinksHere::showIndirectLinks [0.03s] db1157: SELECT  page_id,page_namespace,page_title,rd_from,rd_fragment,page_is_redirect  FROM (SELECT  tl_from,rd_from,rd_fragment  FROM `templatelinks` LEFT JOIN `redirect` ON ((rd_from = tl_from) AND rd_title = 'Documentation' AND rd_namespace = 10 AND (rd_interwiki = '' OR rd_interwiki IS NULL))   WHERE tl_target_id = 37 AND tl_from_namespace IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,90,91,92,93,100,101,102,103,104,105,106,107,486,487,828,829,1198,1199,2300,2301,2302,2303,2600,5500,5501)   ORDER BY tl_from_namespace ASC,tl_from ASC LIMIT 102  ) `temp_backlink_range` JOIN `page` ON ((tl_from = page_id))    ORDER BY page_namespace ASC,page_id ASC LIMIT 51

SELECT  tl_target_id,lt_namespace,lt_title,page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model  FROM `templatelinks` JOIN `linktarget` ON ((tl_target_id=lt_id)) LEFT JOIN `page` ON ((page_namespace=lt_namespace) AND (page_title=lt_title))   WHERE tl_from = 5443966  LIMIT 50

SELECT  lt_title,tl_from_namespace,tl_from,lt_namespace AS `bl_namespace`,lt_title AS `bl_title`,page_namespace,page_title,page_id,page_content_model,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_restrictions  FROM `page`,`templatelinks` FORCE INDEX (tl_backlinks_namespace_target_id) JOIN `linktarget` ON ((tl_target_id=lt_id))   WHERE tl_from_namespace IN
(0,1,2,3,4,5,12,13)  AND (tl_from = page_id) AND (
    (lt_namespace = 10 AND lt_title  = 'SPE') OR
    (lt_namespace = 10 AND lt_title  = 'Semi-protection_étendue') ) AND page_is_redirect = 0  ORDER BY lt_title,tl_from_namespace,tl_from LIMIT 5  ;

mysql:root@localhost [frwiki]> explain SELECT  lt_title,tl_from_namespace,tl_from,lt_namespace AS `bl_namespace`,lt_title AS `bl_title`,page_namespace,page_title,page_id,page_content_model,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_restrictions  FROM `page`,`templatelinks` FORCE INDEX (tl_backlinks_namespace_target_id) JOIN `linktarget` ON ((tl_target_id=lt_id))   WHERE tl_from_namespace IN
    -> (0,1,2,3,4,5,12,13)  AND (tl_from = page_id) AND (lt_namespace = 10 AND lt_title  = 'Semi-protection_étendue') AND page_is_redirect = 0  ORDER BY lt_title,tl_from_namespace,tl_from LIMIT 5  ;
+------+-------------+---------------+--------+-------------------------------------+----------------------------------+---------+------------------------------+------+------------------------------------------+
| id   | select_type | table         | type   | possible_keys                       | key                              | key_len | ref                          | rows | Extra                                    |
+------+-------------+---------------+--------+-------------------------------------+----------------------------------+---------+------------------------------+------+------------------------------------------+
|    1 | SIMPLE      | linktarget    | const  | PRIMARY,lt_namespace_title          | lt_namespace_title               | 261     | const,const                  | 1    | Using index                              |
|    1 | SIMPLE      | templatelinks | range  | tl_backlinks_namespace_target_id    | tl_backlinks_namespace_target_id | 13      | NULL                         | 309  | Using where; Using index; Using filesort |
|    1 | SIMPLE      | page          | eq_ref | PRIMARY,page_redirect_namespace_len | PRIMARY                          | 4       | frwiki.templatelinks.tl_from | 1    | Using where                              |
+------+-------------+---------------+--------+-------------------------------------+----------------------------------+---------+------------------------------+------+------------------------------------------+
3 rows in set (0.001 sec)

mysql:root@localhost [frwiki]> explain SELECT  lt_title,tl_from_namespace,tl_from,lt_namespace AS `bl_namespace`,lt_title AS `bl_title`,page_namespace,page_title,page_id,page_content_model,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_restrictions  FROM `page`,`templatelinks` FORCE INDEX (tl_backlinks_namespace_target_id) JOIN `linktarget` ON ((tl_target_id=lt_id))   WHERE tl_from_namespace IN (0,1,2,3,4,5,12,13)  AND (tl_from = page_id) AND (lt_namespace = 10 AND lt_title  = 'SPE') AND page_is_redirect = 0  ORDER BY lt_title,tl_from_namespace,tl_from LIMIT 5;
+------+-------------+---------------+--------+-------------------------------------+----------------------------------+---------+------------------------------+------+------------------------------------------+
| id   | select_type | table         | type   | possible_keys                       | key                              | key_len | ref                          | rows | Extra                                    |
+------+-------------+---------------+--------+-------------------------------------+----------------------------------+---------+------------------------------+------+------------------------------------------+
|    1 | SIMPLE      | linktarget    | const  | PRIMARY,lt_namespace_title          | lt_namespace_title               | 261     | const,const                  | 1    | Using index                              |
|    1 | SIMPLE      | templatelinks | range  | tl_backlinks_namespace_target_id    | tl_backlinks_namespace_target_id | 13      | NULL                         | 8    | Using where; Using index; Using filesort |
|    1 | SIMPLE      | page          | eq_ref | PRIMARY,page_redirect_namespace_len | PRIMARY                          | 4       | frwiki.templatelinks.tl_from | 1    | Using where                              |
+------+-------------+---------------+--------+-------------------------------------+----------------------------------+---------+------------------------------+------+------------------------------------------+
3 rows in set (0.001 sec)

mysql:root@localhost [frwiki]> explain select * from revision join actor on rev_actor = actor_id where actor_name in ('X', 'Y', 'Z') limit 5;
+------+-------------+----------+-------+---------------------+---------------------+---------+-----------------------+------+-----------------------+
| id   | select_type | table    | type  | possible_keys       | key                 | key_len | ref                   | rows | Extra                 |
+------+-------------+----------+-------+---------------------+---------------------+---------+-----------------------+------+-----------------------+
|    1 | SIMPLE      | actor    | range | PRIMARY,actor_name  | actor_name          | 257     | NULL                  | 3    | Using index condition |
|    1 | SIMPLE      | revision | ref   | rev_actor_timestamp | rev_actor_timestamp | 8       | frwiki.actor.actor_id | 9    |                       |
+------+-------------+----------+-------+---------------------+---------------------+---------+-----------------------+------+-----------------------+
2 rows in set (0.001 sec)

mysql:root@localhost [frwiki]> explain SELECT  lt_title,tl_from_namespace,tl_from,lt_namespace AS `bl_namespace`,lt_title AS `bl_title`,page_namespace,page_title,page_id,page_content_model,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_restrictions  FROM `page`,`templatelinks` FORCE INDEX (tl_backlinks_namespace_target_id) JOIN `linktarget` ON ((tl_target_id=lt_id))   WHERE tl_from_namespace IN (0,1,2,3,4,5,12,13)  AND (tl_from = page_id) AND ((lt_namespace = 10 AND lt_title IN ('SPE','Semi-protection_étendue') )) AND page_is_redirect = 0 LIMIT 501;
+------+-------------+---------------+------------+-------------------------------------+--------------------------------------------+---------+------------------------------+-----------+---------------------------------------------------------------+
| id   | select_type | table         | type       | possible_keys                       | key                                        | key_len | ref                          | rows      | Extra                                                         |
+------+-------------+---------------+------------+-------------------------------------+--------------------------------------------+---------+------------------------------+-----------+---------------------------------------------------------------+
|    1 | SIMPLE      | linktarget    | range      | PRIMARY,lt_namespace_title          | lt_namespace_title                         | 261     | NULL                         | 2         | Using where; Using index                                      |
|    1 | SIMPLE      | templatelinks | hash_range | tl_backlinks_namespace_target_id    | #hash#$hj:tl_backlinks_namespace_target_id | 9:4     | frwiki.linktarget.lt_id      | 175855731 | Using where; Using index; Using join buffer (flat, BNLH join) |
|    1 | SIMPLE      | page          | eq_ref     | PRIMARY,page_redirect_namespace_len | PRIMARY                                    | 4       | frwiki.templatelinks.tl_from | 1         | Using where                                                   |
+------+-------------+---------------+------------+-------------------------------------+--------------------------------------------+---------+------------------------------+-----------+---------------------------------------------------------------+
3 rows in set (0.001 sec)

explain SELECT  tl_title,tl_from_namespace,tl_from,tl_namespace AS `bl_namespace`,tl_title AS `bl_title`,page_namespace,page_title,page_id,page_content_model,page_is_redirect,page_is_new,page_latest,page_touched,page_len  FROM `page`,`templatelinks` FORCE INDEX (tl_backlinks_namespace)    WHERE tl_from_namespace IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,100,101,102,103,104,105,828,829,2300,2301,2302,2303,2600)  AND (tl_from = page_id) AND ((tl_namespace = 10 AND tl_title IN ('SPE','Semi-protection_étendue') ))  ORDER BY tl_title,tl_from_namespace,tl_from LIMIT 11  ;
+------+-------------+---------------+--------+------------------------+------------------------+---------+------------------------------+------+------------------------------------------+
| id   | select_type | table         | type   | possible_keys          | key                    | key_len | ref                          | rows | Extra                                    |
+------+-------------+---------------+--------+------------------------+------------------------+---------+------------------------------+------+------------------------------------------+
|    1 | SIMPLE      | templatelinks | range  | tl_backlinks_namespace | tl_backlinks_namespace | 265     | NULL                         | 446  | Using where; Using index; Using filesort |
|    1 | SIMPLE      | page          | eq_ref | PRIMARY                | PRIMARY                | 4       | frwiki.templatelinks.tl_from | 1    |                                          |
+------+-------------+---------------+--------+------------------------+------------------------+---------+------------------------------+------+------------------------------------------+