After a long time, I decided to check the status of the database, even if everything was working normally. I used the
mysqltuner.pl to check.
At some point, there is the following information:
(!!) Joins performed without indexes: 8915215 (OK) Temporary tables created on disk: 0% (6K on disk / 19B total)
My question is:
How to quickly identify which JOINS do not use index?