如update join_brand_hot set
index = #{top}
where id = #{id}

这样明显会因为index与索引关键词导致的冲突

解决方法一

update join_brand_hot set
`index` = #{top}
where id = #{id}

解决方法二
update join_brand_hot h set
h.index = #{top}
where id = #{id}