caching work for channel, add channel sample sql