Handle SHOW PROCESSLIST results as an input

[macbre]

| 2317800865 | wikia_foo    | 1.8.2.0:55020   | wikicities           | Query   |       0 | statistics                                             | SELECT /* WikiFactoryLoader::execute::domaindb */  city_id,city_public,city_factory_timestamp,city_url,city_dbname,city_cluster  FROM `city_list`  WHERE city_list.city_id = '252723'  LIMIT 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |         0 |             0 |
| 2317800866 | wikia_foo    | 1.1.1.1:53019  | wikicities           | Query   |       0 | statistics                                             | SELECT /* GenderCache::getGenderOfUsersFromDB/Title::getNsText 2A02:810D:82C0:... - fcbfc63a-1df1-43db-bfbd-08c54e922b50 */  user_name,up_value  FROM `user` LEFT JOIN `user_properties` ON ((user_id = up_user) AND up_property = 'gender')  WHERE user_name = 'Rorret'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |         0 |             0 |
| 2317800867 | wikia_foo    | 2.2.2.2:47214   | wikicities           | Sleep   |       0 |                                                        | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         0 |             0 |
| 2317800868 | wikia_foo    | 1.1.1.1:42640   | wikicities           | Query   |       0 | statistics                                             | SELECT /* GenderCache::getGenderOfUsersFromDB/Title::getNsText 66.249.79.146 - 7fbf4e37-3508-4a71-ae58-015d85281048 */  user_name,up_value  FROM `user` LEFT JOIN `user_properties` ON ((user_id = up_user) AND up_property = 'gender')  WHERE user_name = 'Batman 10'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |         0 |             0 |
| 2317800869 | wikia_foo    | 3.3.3.3:60540   | content_review       | Query   |       0 | Sending data                                           | SELECT /* Wikia\ContentReview\Models\CurrentRevisionModel:getLatestReviewedRevision  */ revision_id, touched
	 FROM current_reviewed_revisions
	 WHERE wiki_id = '490'
	 AND page_id = '345732'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             

https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
https://dev.mysql.com/doc/refman/5.7/en/threads-table.html

[macbre]

mysql> SHOW FULL PROCESSLIST;
+----+--------------+-----------+--------------+---------+------+------------+-----------------------+
| Id | User         | Host      | db           | Command | Time | State      | Info                  |
+----+--------------+-----------+--------------+---------+------+------------+-----------------------+
| 39 | index_digest | localhost | index_digest | Query   |    6 | User sleep | SELECT SLEEP(20)      |
| 40 | index_digest | localhost | index_digest | Query   |    0 | NULL       | SHOW FULL PROCESSLIST |
+----+--------------+-----------+--------------+---------+------+------------+-----------------------+
2 rows in set (0.00 sec)