Query logger for Laravel 5.8 to 11
composer require --dev sunaoka/laravel-query-logger
<?php
\DB::beginTransaction();
\App\User::whereEmail('[email protected]')->update(['name' => 'example']);
\DB::commit();
\DB::beginTransaction();
\App\User::whereEmail('[email protected]')->update(['name' => 'example']);
\DB::rollBack();
tail -F storage/logs/laravel.log
[2020-09-11 01:08:37] local.DEBUG: BEGIN;
[2020-09-11 01:08:37] local.DEBUG: [0.31ms] update "users" set "name" = 'example' where "email" = '[email protected]';
[2020-09-11 01:08:37] local.DEBUG: COMMIT;
[2020-09-11 01:08:37] local.DEBUG: BEGIN;
[2020-09-11 01:08:37] local.DEBUG: [0.12ms] update "users" set "name" = 'example' where "email" = '[email protected]';
[2020-09-11 01:08:37] local.DEBUG: ROLLBACK;