Why is it taking so long to query the database?

Question

MySQL

I am using Active Record in yii2. Most requests go very quickly, but here, it would seem, an elementary request to update the date of the last activity goes from 0.2 to 2 seconds. With what it can be connected?

Answer 1

LIMIT 1set? Is the ID unique?

Answer 2

And all updates-inserts are slow? or just this one?

Answer 3

It's strange, of course ... How many lines do you have in users? No one else loads the base? The engine is not MyIasm by any chance? id - Primary Key for User? What does EXPLAIN show? Maybe the disk is broken?