一个计算购买物品的金额以及总金额的小程序。根据你购买的物品的单价和数量计算总共的金额的多少!-a calculation of the amount of goods purchased and the total amount of small programs. Your purchased items are priced and the total quantity of the amount of numbers!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001829s ]
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.084459s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002064s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001882s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002042s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003648s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001947s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003200s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014296s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002234s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 321874 [ RunTime:0.001118s ]