Depending on your database engine and WHERE conditions it may not be cached as you assume it to be.