如何知道记录被查看的次数（SELECTED）？

I want to implement a feature that will show users how many times a record has been viewed (been SQL selected), but don't know what is the best way to do it. The only way I can think of right now is to get the all recordID that has been SELECTED and then use xml bulk update to update the view count. Is there a better way or table design to do the view count? Thanks!I want to implement a feature that will show us