Shopware 6 Hidden Gems #1: Criteria::setTitle() — name tags for your SQL queries
A while ago I stared at the slow query log of a customer’s shop. Three seconds for this one: Great. But who sent it? The listing? A plugin? The sitemap generator? Some CMS element? The DAL generates SQL, and generated SQL looks the same everywhere. So the usual detective work begins: copy the query, grep the codebase, guess which filter combination produces exactly this WHERE clause, attach Xdebug, cry a little. […]