in that user have some roll and rights to do his work and also assign functionality to display report, create report edit,delete or other extra functionality ,,,so when user login whatever his rights and roll to do function it assign ....
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001027s ]
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.081407s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000902s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001232s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001094s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003331s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001048s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003738s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015176s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001139s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 221540 [ RunTime:0.022383s ]
