基于dos界面的超市管理系统,对人员和商品进行分别管理。可实现员工的增减,工资的查询查询。检察商品期限和库存和商品信息。功能强大。-Dos-based interface supermarket management system of personnel and goods to be administered separately. Enables changes in staff, wage query query. Attorney duration and inventory of goods and commodities information. Powerful.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001989s ]
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.087021s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002272s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002044s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002064s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003596s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001882s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003167s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014682s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002399s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 307347 [ RunTime:0.001206s ]