MariaDB query explainer

Explain and understand query for MariaDB.