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 = ?
上边表结构,下边语句。当同一个id高并发访问的时候会锁住。我应该怎么优化?