完成一个售前业务管理，涉及总经理、部门经理、销售经理和销售助理等四个角色，在管理系统中明晰各职位的相应任务和完成操作。-Complete a pre-market business management, involving the general manager, department managers, sales managers and sales assistants four roles in the management system of the positions corresponding clear mission and complete the operation.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000993s ]
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.076220s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001025s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001221s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001120s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003090s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000977s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003643s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020483s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001641s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 286785 [ RunTime:0.016573s ]
