Is it possible to optimize a query like "UPDATE ... WHERE id IN(...)"?

A

AlikDex2015-12-28 15:04:11

MySQL

AlikDex, 2015-12-28 15:04:11

UPDATE `images` SET `shows`=shows+1 WHERE `image_id` IN(5,12237,228634,230074,228823,187448,230150,230095,60,183692,228972,120066,119291,104369,93296)

Essence: updating the counter of displaying pictures. The decision in the forehead, so to speak. I have no idea how this can be optimized. Can you advise?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

K

Konstantin2020-01-28 16:20:04

How to adjust gradient color if only images are given? 2Reply

O

Oscar Handsome2017-10-12 19:47:00

UMI.CMS layout / integration / XSLT problems with the menu, is there anyone to help? 1Reply

N