Log/Show number of (select) queries per table
Slight optimization:

SELECT ...
    round(VARIABLE_VALUE / usfs.VARIABLE VALUE)
    ...
FROM information_schema.GLOBAL_STATUS
JOIN ( select VARIABLE_VALUE from information_schema.GLOBAL_STATUS
               where VARIABLE_NAME = 'Uptime_since_flush_status') AS usfs 


That way, it will fetch Uptime_since_flush_status only once.

Turning on the "general log" is probably the only way to get more details.  And that would be quite messy, since you would have to deduce the "current database" for each query.