It includes information about book titles in the library, information about library members, about the number of times the books were read by members, about the suppliers who supply books to the library, and about orders placed with the suppliers
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001275s ]
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.085306s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001138s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001902s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001149s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003621s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001082s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003247s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.022276s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001330s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 479259 [ RunTime:0.001298s ]
