System of Export South America Food Trading
The objective of managing all export transactions.
Reporting (for printer and PDF files) and operational management.
Integration with spreadsheet files and cvs.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002076s ]
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.102866s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.010544s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001269s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001113s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004518s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000942s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003629s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.045381s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001225s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 249967 [ RunTime:0.028519s ]
