每一个参加排列的数据对应二叉树的一个结点，且任一结点如果有左（右）子树，则左（右）子树各结点的数据必须小（大）于该结点的数据。中序遍历排序二叉树即得排序结果。-Order to participate in each of the data corresponding to a binary tree node, and any one node if there is left (right) subtree, then the left (right) subtree of the data node must be small (large) in the node data. Order traversal of binary tree that is the result of a sort.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001091s ]
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.083925s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001569s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002090s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001522s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005569s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001290s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.007060s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017749s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001349s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 260763 [ RunTime:0.015860s ]
