ngmy / laravel-query-log-tracker
The Laravel package which log all executed queries.
Fund package maintenance!
ngmy
flattr.com/@ngmy
Requires
- php: ^7.3|^8.0
- illuminate/support: ^6.0|^7.0|^8.0
Requires (Dev)
- nunomaduro/larastan: 0.6.11
- orchestra/testbench: 4.13.0|5.12.1|6.7.2
This package is auto-updated.
Last update: 2024-11-30 01:29:44 UTC
README
The Laravel package which log all executed queries.
Demo
Features
Laravel Query Log Tracker has the following features:
- Log all executed queries with the following items:
- SQL with bound parameters
- Bind parameters
- Execution time in milliseconds
- Connection name
- Disable/Enable query logging at runtime
- More configurations:
- Log level
- Exclude patterns
- Channels
Requirements
Laravel Query Log Tracker has the following requirements:
- PHP >= 7.3
- Laravel >= 6.0
Installation
Execute the Composer require
command:
composer require ngmy/laravel-query-log-tracker
This will update your composer.json
file and install this package into the vendor
directory.
If you don't use package discovery, add the service provider to the providers
array in the config/app.php
file:
Ngmy\LaravelQueryLogTracker\QueryLogTrackerServiceProvider::class,
If you don't use package discovery, add the alias to the aliases
array in the config/app.php
file:
'QueryLogTracker' => Ngmy\LaravelQueryLogTracker\QueryLogTrackerFacade::class,
Publishing Configuration
Execute the Artisan vendor:publish
command:
php artisan vendor:publish
This will publish the configuration file to the config/ngmy-query-log-tracker.php
file.
You can also use the tag to execute the command:
php artisan vendor:publish --tag=ngmy-query-log-tracker
You can also use the service provider to execute the command:
php artisan vendor:publish --provider="Ngmy\LaravelQueryLogTracker\QueryLogTrackerServiceProvider"
Usage
Log Queries
Execute queries with Laravel. That's all.
Disable Log
There are two ways to disable log.
QueryLogTracker::beginDisable(); // Execute queries for which you want to disable log QueryLogTracker::endDisable();
QueryLogTracker::disable(function () { // Execute queries for which you want to disable log });