更新产品数据表（product)中id为$id的点击率（hits)，下面正确的是

A、select * from product where id={$id}

B、select hits from product where id={$id}

C、update product set hits+1 where id={$id}

D、update product set hits=hits+1 where id={$id}