This program uses the EVE API to gather transaction data for traders in EVE Online to track profits and make educated choices on what items to trade in.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002215s ]
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.118330s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.004239s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002069s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.010367s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.006038s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001437s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.007075s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.026564s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.005111s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 275807 [ RunTime:0.055594s ]
