Methods to handle the N+1 query problem in TypeORM:

1. **Use the relations option to load related data**:
   ```typescript
   userRepository.find({ relations: ['posts', 'profile'] });
   ```

2. **Use join and leftJoinAndSelect**:
   ```typescript
   createQueryBuilder('user')
     .leftJoinAndSelect('user.posts', 'post')
     .leftJoinAndSelect('user.profile', 'profile')
     .getMany();
   ```

3. **Use FindOptions for relationship loading**:
   ```typescript
   userRepository.find({
     relations: {
       posts: true,
       profile: true
     }
   });
   ```

4. **Avoid querying in loops**:
   Do not query related data individually in forEach or map loops; load all needed data in the main query at once.

5. **Use DataLoader (suitable for GraphQL)**:
   For complex batch query scenarios, use DataLoader for data batching and caching.

Best practice is to always explicitly specify the related data to be loaded when querying, avoiding N+1 problems caused by lazy loading.

How to solve the N+1 query problem in TypeORM?