Open project for editing any type of source code on pocket PC.
For first stage target platform is WinMobile. In continiously it should be ported at any platform.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000991s ]
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.085004s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000960s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001207s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000945s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003141s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000758s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003646s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014874s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001113s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 270480 [ RunTime:4.092417s ]