系统提供了基本的人员信息管理,同时对员工的基本工资、浮动工资和工资发放进行系统管理,同时配以查询功能,避免数据丢失系统还提供了数据备份及还原功能。-System provides the basic personnel information management, while staff of their basic wages, floating wages and payroll systems management, at the same time with the inquiry, to avoid loss of data system also provides data backup and restore functionality.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000895s ]
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.102258s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000980s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001179s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001006s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003053s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000847s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003658s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015778s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001120s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 217511 [ RunTime:0.019788s ]