A Scenario involving a small airline companies who wishes to purchase software to manage ticket sales and offer such services to the public. This project shall has been asked to be completed using Java and mySQL for the components.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001053s ]
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.074671s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.011147s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.014086s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001114s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004261s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001644s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004428s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.034468s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.006654s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 98055 [ RunTime:0.041703s ]
