PB中对文件的操作应用 PB中对文件的操作应用-PB operation of the document PB application of the document PB operational applications of the document operational applications PB the operation of the document PB application of the document operational applications
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001404s ]
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.089749s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001168s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002261s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001204s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003743s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001092s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003425s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014979s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001333s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 155889 [ RunTime:0.001328s ]
