ATM机的程序,可以供大家研究研究,呵呵...可以想一想我们平时取款的场景,我们也可以做出来啦!-ATM machine program, can be used for all research studies, He He ... you can imagine we usually withdrawal scenario, we can also make Laila! Hehe ...
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000967s ]
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.103844s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001215s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001175s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001051s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003186s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000892s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003749s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018587s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001837s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 216765 [ RunTime:0.020532s ]