晚晚网上书店系统源码
前台具有一般的购物车、会员注册、图书搜索(高级搜索)等功能
后台有书目管理、会员管理、订单管理、销售统计等功能-Online bookstore system晚晚front-source shopping cart with the general, membership registration, Book Search (Advanced Search) features such as the background there are bibliographic management, membership management, order management, sales statistics and other functions
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001261s ]
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.076126s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001371s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001288s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001090s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003433s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000946s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003656s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.024845s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001737s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 284092 [ RunTime:0.025317s ]