Paste P8810

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Tgr on Jul 26 2019, 8:59 PM.

Tags

None

Referenced Files

	F29880214: raw.txt
	Jul 26 2019, 8:59 PM

Subscribers

None

	(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