Parser for extracting fields from a single line of an Apache access.log (should work for other servers conforming to the Common Log Format).
Create the parser with the log format from your server .conf file, parse lines to get dict corresponding to fields defined in the log format.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001868s ]
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.121047s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001325s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002138s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001287s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003788s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001063s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003421s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015655s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001448s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 39575 [ RunTime:0.001454s ]