更新查询每次将列值减少2

Here i have created an sql statement to update a column value reduced by one each time.But whenever i run the query it is getting reduced by two.What might be the reason for this Here i have created an sql statement to update