Wikia/app — pull request #2766 by jacekjursza (2014-02-13 13:12:31+00:00)
Title: Pla 1140

!! DONT MERGE BEFORE QA !!

@SQLReview

SELECT page_id,qc_value,page_title FROM `querycache`,`page`
WHERE (qc_title = page_title)
AND (qc_namespace = page_namespace)
AND (page_is_redirect = 0)
AND qc_type = 'Mostlinked'
AND qc_namespace = '0'
ORDER BY qc_value DESC
LIMIT 50

mysql> explain SELECT page_id,qc_value,page_title FROM `querycache`,`page` WHERE (qc_title = page_title) AND (qc_namespace = page_namespace) AND (page_is_redirect = 0) AND qc_type = 'Mostlinked' AND qc_namespace = '0' ORDER BY qc_value DESC LIMIT 50;
+----+-------------+------------+--------+----------------------------------------+------------+---------+-----------------------------------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+------------+--------+----------------------------------------+------------+---------+-----------------------------------+------+-------------+
| 1 | SIMPLE | querycache | ref | qc_type | qc_type | 32 | const | 999 | Using where |
| 1 | SIMPLE | page | eq_ref | name_title,page_redirect_namespace_len | name_title | 261 | const,firefly.querycache.qc_title | 1 | Using where |
+----+-------------+------------+--------+----------------------------------------+------------+---------+-----------------------------------+------+-------------+
2 rows in set (0.00 sec)