AI Code Review

Please review code change ini (PR diff), focus on:

1. Security vulnerability: SQL injection, XSS, CSRF, info leak, unsafe deserialization
2. Performance issue: N+1 query, unnecessary memory allocation, unindexed query, blocking operation
3. Edge case: null handling, race condition, huge data scenario

Buat tiap problem provide:
- Severity level (Critical / Warning / Suggestion)
- Location (file name + line number)
- Fix recommendation dan example code

Finish dengan overall assessment dan merge recommendation.

Check apakah code ini follow SOLID principle:

- S (Single Responsibility): class/function ini handle terlalu banyak hal?
- O (Open-Closed): feature baru perlu ubah existing code?
- L (Liskov Substitution): subclass bisa safe replace parent class?
- I (Interface Segregation): interface ini terlalu fat?
- D (Dependency Inversion): high-level module directly depend on low-level implementation?

Buat tiap violation:
1. Jelasin apa yang violation, dimana
2. Kenapa ini problem
3. Provide refactor plan dan code example

Analyze database query di code ini:

1. Identify semua N+1 query problem:
   - Mark query yang trigger di loop
   - Calculate worst-case query count
2. Provide optimization plan:
   - Mana yang bisa merge dengan JOIN
   - Mana yang bisa pake eager loading / preload
   - Mana yang butuh cache
3. Write optimized code
4. Estimate performance difference sebelum-sesudah

ORM framework yang lo pake adalah [your framework, like SQLAlchemy / Prisma / ActiveRecord].