Mysql update multiple update in one request

Your decision slow. It is more efficient to update 1 field in 1 regular query, no joins s.
Or use this option, it is much more effective in performance than Yours:
\r
UPDATE `table` SET `field` = CASE `id`
WHEN val1 THEN data1
WHEN val2 THEN data2
ELSE `field` END
\r
Just be sure to do not forget ELSE.

else can
\r
INSERT INTO `table` (id, field) VALUES (1, 1), (2, 12), (3, 0.5) ON DUPLICATE KEY UPDATE field = VALUES(field)