SHOW FULL PROCESSLIST;
SELECT * FROM information_schema.PROCESSLIST where info like '%select%';
describe information_schema.processlist;
ID bigint(4) NO 0
USER varchar(16) NO
HOST varchar(64) NO
DB varchar(64) YES
COMMAND varchar(16) NO
TIME int(7) NO 0
STATE varchar(64) YES
INFO longtext YES