DDEV Magento Performance Tuning

Skill for performance audits on DDEV-hosted Magento 2 stacks. Covers profiling, SQL counting, cache verification, and post-refactor regression testing.

When to use

• User asks to "check code", "profile", "đếm SQL", "xem xhgui" for a Magento URL.
• After a perf refactor (eager-loaders, caches, plugin rewrites) — to prove it works.
• Investigating slow page / N+1 query suspicion.

Environment assumptions

• Project root: /var/www/html/magento (adjust if different).
• DDEV running. Site URL pattern: https://<project>.ddev.site.
• XHGui sidecar exposed via ddev describe (typically https://<project>.ddev.site:8142).
• Profiling triggered with header X-XHGUI-Profile: 1 (or whatever xhgui.collector config expects — verify in app/etc/env.php or xhgui module config).

Workflow