Refactor KerangkaAcuan resource to remove unnecessary eager loading and update AppServiceProvider to handle lazy loading violations with logging

laravelwebdev · laravelwebdev · commit cee7ad05e62f · 2025-08-24T16:38:11.000+08:00
diff --git a/app/Nova/KerangkaAcuan.php b/app/Nova/KerangkaAcuan.php
@@ -34,7 +34,7 @@
 
 class KerangkaAcuan extends Resource
 {
-    public static $with = ['unitKerja', 'naskahKeluar', 'arsipDokumen', 'anggaranKerangkaAcuan', 'spesifikasiKerangkaAcuan', 'daftarSp2d'];
+    public static $with = ['unitKerja',  'arsipDokumen', 'anggaranKerangkaAcuan', 'spesifikasiKerangkaAcuan', 'daftarSp2d'];
 
     public static function label()
     {
diff --git a/app/Providers/AppServiceProvider.php b/app/Providers/AppServiceProvider.php
@@ -2,8 +2,10 @@
 
 namespace App\Providers;
 
+use Illuminate\Database\Eloquent\Model;
 use Illuminate\Support\Facades\URL;
 use Illuminate\Support\ServiceProvider;
+use Log;
 
 class AppServiceProvider extends ServiceProvider
 {
@@ -24,5 +26,10 @@ public function boot(): void
             URL::forceRootUrl(env('APP_URL'));
             URL::forceScheme('https');
         }
+        Model::preventLazyLoading();
+        Model::handleLazyLoadingViolationUsing(function ($model, $relation) {
+            Log::warning(sprintf('N+1 Query detected in %s::%s', get_class($model), $relation));
+        });
+
     }
 }
diff --git a/composer.json b/composer.json
@@ -22,7 +22,6 @@
     ],
     "require": {
         "php": "^8.2",
-        "beyondcode/laravel-query-detector": "*",
         "fidum/laravel-nova-metrics-polling": "^1.0",
         "fidum/nova-package-bundler-command": "^1.8",
         "intervention/image-laravel": "*",
diff --git a/config/querydetector.php b/config/querydetector.php

Original file line number	Diff line number	Diff line change
`@@ -34,7 +34,7 @@`
`34`	`34`
`35`	`35`	`class KerangkaAcuan extends Resource`
`36`	`36`	`{`
`37`		`- public static $with = ['unitKerja', 'naskahKeluar', 'arsipDokumen', 'anggaranKerangkaAcuan', 'spesifikasiKerangkaAcuan', 'daftarSp2d'];`
	`37`	`+ public static $with = ['unitKerja', 'arsipDokumen', 'anggaranKerangkaAcuan', 'spesifikasiKerangkaAcuan', 'daftarSp2d'];`
`38`	`38`
`39`	`39`	`public static function label()`
`40`	`40`	`{`
Original file line number	Diff line number	Diff line change
`@@ -2,8 +2,10 @@`
`2`	`2`
`3`	`3`	`namespace App\Providers;`
`4`	`4`
	`5`	`+use Illuminate\Database\Eloquent\Model;`
`5`	`6`	`use Illuminate\Support\Facades\URL;`
`6`	`7`	`use Illuminate\Support\ServiceProvider;`
	`8`	`+use Log;`
`7`	`9`
`8`	`10`	`class AppServiceProvider extends ServiceProvider`
`9`	`11`	`{`
`@@ -24,5 +26,10 @@ public function boot(): void`
`24`	`26`	`URL::forceRootUrl(env('APP_URL'));`
`25`	`27`	`URL::forceScheme('https');`
`26`	`28`	`}`
	`29`	`+ Model::preventLazyLoading();`
	`30`	`+ Model::handleLazyLoadingViolationUsing(function ($model, $relation) {`
	`31`	`+ Log::warning(sprintf('N+1 Query detected in %s::%s', get_class($model), $relation));`
	`32`	`+ });`
	`33`	`+`
`27`	`34`	`}`
`28`	`35`	`}`