· software
JOIN FETCH can be slower than N+1: a reproducible Doctrine benchmark (+ 1-row-per-entity JSON aggregation)
The real problem: multiple OneToMany JOINs explode rows JOINing multiple OneToMany relations multiplies the SQL result set cartesian product. Example: 3 images...