Download the PHP package tourze/doctrine-logger-bundle without Composer
On this page you can find all versions of the php package tourze/doctrine-logger-bundle. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package doctrine-logger-bundle
Doctrine Logger Bundle
中文
[]
(https://packagist.org/packages/tourze/doctrine-logger-bundle)
[
]
(https://github.com/tourze/php-monorepo/blob/master/LICENSE)
[
]
(https://github.com/tourze/php-monorepo/actions)
[
]
(https://codecov.io/gh/tourze/php-monorepo)
[]
(https://packagist.org/packages/tourze/doctrine-logger-bundle)
[
]
(https://packagist.org/packages/tourze/doctrine-logger-bundle)
A Symfony bundle that provides enhanced logging capabilities for Doctrine ORM queries, with a focus on performance monitoring and debugging.
Features
- Monitors SQL query execution time
- Logs queries that exceed configurable time thresholds
- Provides detailed backtrace information for slow queries
- Normalizes and truncates query parameters for better log readability
- Integrates with Symfony's Stopwatch component for precise timing
- Compatible with PSR-3 loggers
Installation
Configuration
The bundle works with minimal configuration. After installation, add it to your
bundles in config/bundles.php:
Environment Variables
You can configure the bundle using the following environment variables:
SQL_LOG_LENGTH: Maximum length of SQL queries in logs (default: 1000)LOG_DB_QUERY_BACKTRACE: Enable backtrace logging for all queries (default: false)
Usage
The bundle automatically registers the QueryExecutionTimeLogger service which
monitors Doctrine queries. By default, it logs:
- All queries in development environment
- Only slow queries (exceeding threshold) in production environment
Basic Example
Advanced Usage
Custom Query Threshold
You can customize the slow query threshold by extending the service:
Integrating with Custom Middleware
How It Works
The bundle uses Symfony's Stopwatch component to measure query execution time. When a query exceeds the configured threshold (default: 1000ms), it logs detailed information including:
- The SQL query
- Query parameters (normalized and truncated for readability)
- Execution time
- Backtrace information (if enabled)
Requirements
This bundle requires:
- PHP 8.1 or higher
- Symfony 6.4+ or 7.x
- Doctrine ORM 3.0+
- Doctrine DBAL 4.0+
For complete dependency list, see composer.json.
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
This bundle is available under the MIT license. See the LICENSE file for more information.
All versions of doctrine-logger-bundle with dependencies
doctrine/dbal Version ^4.0
doctrine/doctrine-bundle Version ^2.13
doctrine/orm Version ^3.0
monolog/monolog Version ^3.1
psr/log Version ^3|^2|^1
symfony/config Version ^7.3
symfony/console Version ^7.3
symfony/dependency-injection Version ^7.3
symfony/doctrine-bridge Version ^7.3
symfony/event-dispatcher Version ^7.3
symfony/expression-language Version ^7.3
symfony/framework-bundle Version ^7.4
symfony/http-foundation Version ^7.4
symfony/http-kernel Version ^7.3
symfony/messenger Version ^7.3
symfony/monolog-bundle Version ^3.10
symfony/property-access Version ^7.3
symfony/service-contracts Version ^3.6
symfony/stopwatch Version ^7.3
symfony/yaml Version ^7.3
tourze/backtrace-helper Version 1.*
tourze/bundle-dependency Version 1.*
yiisoft/strings Version ^2.1