[Audit] Database Query Optimization

[Snider]

Audit Instructions

Perform a thorough audit focusing on database query performance.

Focus Areas

• N+1 query problems
• Missing indexes
• Inefficient Eloquent patterns
• Raw query injection risks
• Query caching opportunities
• Eager loading optimization

Output Format

Create a file named AUDIT-DATABASE.md with findings.

Requirements

• Use Laravel Debugbar or similar to identify slow queries
• Check for missing indexes on foreign keys
• Review complex query builders

[google-labs-jules]

Jules is on it. When finished, you will see another comment and be able to review a PR.

[google-labs-jules]

Ready for a review! A PR has been created.

[google-labs-jules]

I apologize, but I encountered an unexpected error and wasn't able to complete the task.