学习DOS,现在虽然DOS环境已经很少有人使用,但是DOS的强大功能使我觉得学习好DOS会使我们更加快捷的学习其他知识!-learning DOS, although DOS environment has rarely been used, but the power of DOS makes me feel good to learn DOS make us all more efficient learning other knowledge!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001355s ]
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.099681s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001358s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002155s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001244s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003753s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001062s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003504s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016154s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001432s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 297998 [ RunTime:0.001349s ]