Android application to identify flowers. Photograph a flower you find along the way and use this application to identify it.
The application uses information about your location and time of year to identify potential matches, and then uses image processing techniques to rank the potential matches.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001272s ]
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.088347s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001207s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001976s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001181s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003778s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001010s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003385s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015350s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001344s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 100340 [ RunTime:0.001480s ]