I hope all of you know the debug toolbar which can be installed with Symfony.
One of the big problems – until today for me was, that the query parameters are shown as UTF-8 binary strings, which is not helpful.
Today I learned, that under each of these queries you have four buttons:
- View formatted query
- View runnable query
- Explain query
- View query backtrace
And the second “View runnable query” does exactly what it says: It shows you a runnable version of the query, including all UUIDs as in the X’UUID’ syntax.
This tip was brought to me by Soner Sayakci.