PB9.0生成的图书管理系统,该系统包含读者管理和图书管理两部分,能完成图书借阅的基本功能。后缀为db的是数据库文件-PB9.0 generated library management system, which includes management and library management readers in two parts, to complete the basic functions of books to borrow. Db suffix to the database file
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002139s ]
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.103083s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002260s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001931s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002189s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003736s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002323s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003341s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016925s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002599s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 205385 [ RunTime:0.001201s ]