Generates an Atom (RSS) feed of Microsoft Exchange tasks based on the category of the task. This primarily needed by GTD users implementing it using Microsoft Exchange.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002481s ]
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.084182s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.010516s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001219s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001117s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003353s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000950s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003884s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.019261s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001621s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 299262 [ RunTime:0.019926s ]