What could be wrong with the dle engine?

Question

DLE

Hello. I administer the site https://hd.hotmo.fun/genre/88/93952-zaberi-menya.html . This is an example of a track page.
The database of this site contains about 250 thousand tracks.
So: when it is the page with the full track that is loaded, the site lags terribly. Pages of other types load instantly https://hd.hotmo.fun/charts/hitmo-500/ .
That's what could be the problem with such a long load, in addition to a large number of records in the database. I heard that people have the same number of records on the engine and nothing. The server is fine.
I tried to think through the developer panel in the browser, I did not find anything strange.

Answer 1

There is a standard way.
Check the slow query log and use EXPLAIN to find out the reason from the slowest one.