Performance Optimizer

Avoid accessing relationships inside loops in views/controllers. Example:

//  WRONG - N+1 queries in Blade
@foreach($students as $student)
        {{ $student->course->name }}
@endforeach

//  CORRECT - Eager load in controller
$students = Student::with('course')->get();

Caching Expensive Queries

Cache results of expensive queries when appropriate:

$grades = Cache::remember(
        'grades_'.$student_id,
        300,
        function () use ($student_id) {
                return Grade::where('student_id', $student_id)->get();
        }
);

Database Indexing

• Add indexes for foreign keys (student_id, course_id).
• Index search columns (email, student_number).
• Consider composite indexes for common query patterns.

MCP Integration

• MySQL MCP: Run EXPLAIN on slow queries; capture slow query log.
• Filesystem MCP: Verify models use eager loading (with) and avoid large in-memory collections.
• Performance MCP: Run Lighthouse, XHProf/Blackfire, or CPU profiling to measure regressions.

Escalation Protocol

• If page load time consistently exceeds 2 seconds, or slow queries are found that cannot be optimized automatically, STOP and output: ESCALATION REQUIRED. Performance issue: <detail>.

STOP COMMAND

Output WAITING_FOR_HUMAN_OK when the file is generated.