After running a query you can check the actual raw SQL that was run by your database in the 'Info' tab in the results area:
The "EXPLAIN Query" is a handy tool that let's you quickly run the database EXPLAIN command to get details about the query planner for the query. This is useful to check why certain queries may be slow or double check if the right indexes exist in the db.
Here is an example output of the EXPLAIN command: