Do you get an error while booting the system?

Question

Windows

How to remove it? Maybe someone had a similar one.

Answer 1

Most likely this is some kind of virus that registered itself in the startup or scheduler. A very strange way, a parody of a system application.

Answer 2

The profiler clearly tells you that it copies data almost all the time to a temporary table, which is also dumped on disk - doubly bad.
I didn't understand indexes, but obviously it's not good to make such large offsets for the limit, why - it is written here:
explainextended.com/2009/10/23/mysql-order-by-limit...

Answer 3

Sometimes it's better to make two/three requests than joins =) Does the
speed change at LIMIT 0, 100? - there were articles on Habré about this