This project is a small application written in PHP that will help the user to make the management of funds that had come for Telephone bills easy. This software is basically designed for NIC Departments of Districts of India.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001467s ]
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.168459s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001359s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002015s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001333s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005252s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001222s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006736s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025633s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001553s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 36555 [ RunTime:0.026635s ]
