网上书店,实现了管理员和普通用户的功能,提供注册,添加删除等相关功能,以及购物车的功能。-Online bookstore, the manager and the general implementation of the function of the user to provide registration, add delete functionality, etc., as well as the shopping cart feature.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001470s ]
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.079938s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001092s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001667s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001316s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004344s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001013s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005602s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016912s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001251s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 141271 [ RunTime:0.015513s ]