对系统随机生成的一组数据进行排序,查找,统计不同排序方法需要的比较次数和交换次数以及不同排序需要的时间,还有要记录查找时间-The system randomly generates a set of data to sort, search, statistical comparison of the different sorting methods require the number and frequency of exchange, as well as the time required for the different sort, as well as to find time to record
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001250s ]
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.075990s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001026s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001226s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001273s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003303s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001006s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004278s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015803s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001166s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 212046 [ RunTime:0.017734s ]