求助大佬帮忙看看 sql 大约有两百万数据执行批量修改太慢了 有啥优化的好办法码

[chaodada]

0
UPDATE `wx_user` SET `member_id` = '378281'  WHERE  login_id='1362' and   vip ='1' and shangji_id='378281'
0
UPDATE `wx_user` SET `member_upgrade_time` = '1578046841'  WHERE login_id='1362' and  `id` = '378284'
1
UPDATE `wx_user` SET `member_id` = '378284' WHERE  login_id='1362' and   id > '378284'  and  `member_id` ='343296' and  `path` LIKE '/0/343264/343296/378284/%'
0
UPDATE `wx_user` SET `member_id` = '378284'  WHERE  login_id='1362' and   vip ='1' and shangji_id='378284'
0
UPDATE `wx_user` SET `member_upgrade_time` = '1578046842'  WHERE login_id='739' and  `id` = '378290'
1
UPDATE `wx_user` SET `member_id` = '378290' WHERE  login_id='739' and   id > '378290'  and  `member_id` ='377382' and  `path` LIKE '/0/314155/374804/377382/378290/%'
0
UPDATE `wx_user` SET `member_id` = '378290'  WHERE  login_id='739' and   vip ='1' and shangji_id='378290'
0
UPDATE `wx_user` SET `member_upgrade_time` = '1578046842'  WHERE login_id='739' and  `id` = '378300'
1
UPDATE `wx_user` SET `member_id` = '378300' WHERE  login_id='739' and   id > '378300'  and  `member_id` ='0' and  `path` LIKE '/0/378300/%'
0
UPDATE `wx_user` SET `member_id` = '378300'  WHERE  login_id='739' and   vip ='1' and shangji_id='378300'
0
UPDATE `wx_user` SET `member_upgrade_time` = '1578046842'  WHERE login_id='739' and  `id` = '378309'
1
UPDATE `wx_user` SET `member_id` = '378309' WHERE  login_id='739' and   id > '378309'  and  `member_id` ='377329' and  `path` LIKE '/0/314155/377329/378309/%'
0
UPDATE `wx_user` SET `member_id` = '378309'  WHERE  login_id='739' and   vip ='1' and shangji_id='378309'
0
UPDATE `wx_user` SET `member_upgrade_time` = '1578046842'  WHERE login_id='1362' and  `id` = '378313'
1
UPDATE `wx_user` SET `member_id` = '378313' WHERE  login_id='1362' and   id > '378313'  and  `member_id` ='343296' and  `path` LIKE '/0/343264/343296/378313/%'
0
UPDATE `wx_user` SET `member_id` = '378313'  WHERE  login_id='1362' and   vip ='1' and shangji_id='378313'
0
UPDATE `wx_user` SET `member_upgrade_time` = '1578046843'  WHERE login_id='739' and  `id` = '378316'
1
UPDATE `wx_user` SET `member_id` = '378316' WHERE  login_id='739' and   id > '378316'  and  `member_id` ='377335' and  `path` LIKE '/0/314155/377335/378316/%'

目前 login_id 加了 index 索引 path 加了一个 fulltext 索引 求大佬帮忙看一下

[surfire91]

login_id 我看都是 739， 筛选性很小？