SELECT * FROM information_schema.processlist WHERE command != 'Sleep' ORDER BY id\G

Source – https://makandracards.com/makandra/7681-show-mysql-process-list-without-sleeping-connections