HIGH CPU USAGE WITH INNER JOIN

[DoyaCat]

I want to know the number of incoming messages, but the server is excessively using CPU. When I coded with a joinless Select, it didn't use any CPU at all. ???? I managed to solve it, sometimes it's necessary to define an index...