This is a very basic library which can be used to create data of varying types. The main purpose is to generate dummy data which can be used for testing.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001285s ]
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.088130s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001225s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001891s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001265s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003627s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001141s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003196s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014668s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001298s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 265068 [ RunTime:0.001225s ]