fspy is an easy to use linux filesystem activity monitoring tool which is meant to be small, fast and to handle system resources conservative. you can apply filters, use diffing and your own output format in order to get the best results.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002223s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.092210s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002480s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001881s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002422s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003668s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002280s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003309s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015479s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.003064s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 245990 [ RunTime:0.001152s ]