用vb编的一个商品库存管理系统,用于百货商店和超市的库存管理,该系统功能完整,方便实用。无解压密码,解压后可直接使用。-vb series with a commodity inventory management system for department stores and supermarkets in inventory management, functional integrity of the system, convenient and practical. Without extracting passwords, unpacked can be used directly.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000941s ]
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.082843s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000912s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001128s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001173s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003080s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001021s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003644s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016242s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001287s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 224822 [ RunTime:0.015604s ]