上海很多地方都已经使用的会员软件,关于IC、磁条、MF卡等多种会员卡进行操作!部分注释,希望大家可以共同学习-Shanghai have many members of the software used on the IC, magnetic stripe, MF card and other membership cards operate! Notes some hope that we can learn together
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001355s ]
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.113987s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001623s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003285s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001845s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.006666s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001540s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006291s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025973s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002069s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 213614 [ RunTime:0.001503s ]