Package Data | |
---|---|
Maintainer Username: | hansvn |
Maintainer Contact: | hans@brandworks.be (HansVN) |
Package Create Date: | 2015-10-01 |
Package Last Update: | 2016-01-14 |
Language: | PHP |
License: | MIT |
Last Refreshed: | 2024-12-22 03:01:16 |
Package Statistics | |
---|---|
Total Downloads: | 61 |
Monthly Downloads: | 0 |
Daily Downloads: | 0 |
Total Stars: | 2 |
Total Watchers: | 2 |
Total Forks: | 0 |
Total Open Issues: | 0 |
This package allows you to log and trace your queries. For example: if you have some slow queries you can find where they are called.
Install the brandworks/querylogger
package
$ composer require brandworks/querylogger
Update app/config/app.php` to activate the package
# Add `Brandworks\Querylogger\QueryloggerServiceProvider` to the `providers` array
'providers' => array(
...
'Brandworks\Querylogger\QueryloggerServiceProvider',
)
# You do not need to add the alias - This is being handled for you in the service provider
Publish the config file
$ php artisan config:publish brandworks/querylogger
Optionally, you can change the options
You can also add a route to your application to directly view your logs in a table
In the config: set the add_route and store_serialized options to true
# file: app/config/packages/brandworks/querylogger/config.php
'store_serialized' => false,
'add_route' => false,
You can optionally set the route you want to view your queries at
# file: app/config/packages/brandworks/querylogger/config.php
'route' => 'queries',
I don't recommend to enable this in a live environment; Your visitors can view your queries and deduct your database structure once they have found the route!
So if you are to add the routes do this in a local config file.
Below is a simple usage example of this package
//this does not affect user load since this is done in app finish (the client did already receive response)
App::finish(function($request, $response) {
//make sure the package is enabled -- prevent errors
if(class_exists("QueryLogger")) {
$queryLog = QueryLogger::getLog();
Log::info('The query log', $queryLog);
//or do some other stuff with the log so you can make it more readale/filter on query time/...
}
}
Contributions are welcome.
This project is licensed under the terms of the MIT license.