Page MenuHomePhabricator
Paste P8810

(An Untitled Masterwork)
ActivePublic

Authored by Tgr on Jul 26 2019, 8:59 PM.
(20:58) vagrant@localhost:[wiki]> explain SELECT 6 AS `namespace`,img_name AS `title` FROM `machine_vision_label` JOIN `image` ON ((mvl_image_sha1 = img_sha1)) WHERE mvl_review = '0' GROUP BY img_sha1,mvl_image_sha1 ORDER BY mvl_image_sha1 DESC LIMIT 2;
+------+-------------+----------------------+------+--------------------------------------------+-----------------+---------+---------------------------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+----------------------+------+--------------------------------------------+-----------------+---------+---------------------------+------+---------------------------------+
| 1 | SIMPLE | image | ALL | img_sha1 | NULL | NULL | NULL | 7 | Using temporary; Using filesort |
| 1 | SIMPLE | machine_vision_label | ref | mvl_sha1_provider_wikidata,mvl_review_sha1 | mvl_review_sha1 | 35 | const,wiki.image.img_sha1 | 5 | Using index |
+------+-------------+----------------------+------+--------------------------------------------+-----------------+---------+---------------------------+------+---------------------------------+
2 rows in set (0.02 sec)

Event Timeline

Tgr created this paste.Jul 26 2019, 8:59 PM