很多的都想用自已的和序控制自己的电脑,这里有一些常用函数,希望对大家有用-Many want to use their own and the sequence to control their own computer, here are some commonly used functions, in the hope that useful to everybody
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001242s ]
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.070626s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002289s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002214s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002025s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005665s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001587s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006715s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.023064s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001680s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 191530 [ RunTime:0.044405s ]
