09.04.2024・TechStuff
09.04.2024・TechStuff

Symfony/Shopware: Get useable queries

Fabian Blechschmidt

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.

Screenshot of a query with parameters, which are UUIDs and shown as UTF-8 garbage

Today I learned, that under each of these queries you have four buttons:

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.