文件名攻心为上
觉得还有用的可下看看,学习学习!
不一定有用,不一定没用!
仅供参考!-File name for the hearts and minds feel that there can be used under the look, learn! Not necessarily useful, not necessarily useless! For reference purposes only!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001058s ]
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.076775s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.061135s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001587s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001076s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003469s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000756s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004007s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014718s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001108s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 172565 [ RunTime:0.011945s ]