CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`balance` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;
update user set balance = balance - 1 where id = ?
上面表结构,下面查询语句。表不大,只有上百条数据,但是高并发访问的时候会锁住。请问怎么优化?