This is a geocaching application. It will allow you to load all you gpx files into one central application and allow you to view the details of each cache. The purpose for this application is to have one universal geocaching application that runs on Windows, Mac, and Linux.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002105s ]
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.089983s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002447s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002170s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002103s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003651s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002123s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003248s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014885s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.003931s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 50099 [ RunTime:0.001245s ]