Product cards are loading for a very long time, what should I do?

Question

MySQL

product cards take a very long time to load, installed the plugin, revealed a long request

site edvin9ng.beget.tech/product/ball-guide

Answer 1

Database optimization
Adding indexes
Caching

Answer 2

Well, no, it doesn't seem to be a question here.
Although Query Monitor classified the query in the screenshot as slow (probably relative to the rest), it is not, because 0.06 sec (ie ~60 ms) is almost instantaneous.
And the page does not load immediately.
In general, I think you need to look not in database queries, but in the rest of the code.