Download the PHP package tpetry/laravel-mysql-explain without Composer
On this page you can find all versions of the php package tpetry/laravel-mysql-explain. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download tpetry/laravel-mysql-explain
More information about tpetry/laravel-mysql-explain
Files in tpetry/laravel-mysql-explain
Package laravel-mysql-explain
Short Description Get Visual MySQL EXPLAIN for Laravel.
License MIT
Homepage https://github.com/tpetry/laravel-mysql-explain
Informations about the package laravel-mysql-explain
Laravel MySQL Visual Explains
MySQL Query optimization with the EXPLAIN
command is unnecessarily complicated: The output contains a lot of cryptic information that is incomprehensible or entirely misleading.
This Laravel package collects many query metrics that will be sent to mysqlexplain.com and transformed to be much easier to understand.
Installation
You can install the package via composer:
Usage
Query Builder
Three new methods have been added to the query builder for very easy submission of query plans:
Type | Action |
---|---|
visualExplain |
returns URL to processed EXPLAIN output |
dumpVisualExplain |
dumps URL to processed EXPLAIN output and continue normal execution |
ddVisualExplain |
dumps URL to processed EXPLAIN output and stops execution |
explainForHumans (deprecated) |
returns URL to processed EXPLAIN output |
dumpExplainForHumans (deprecated) |
dumps URL to processed EXPLAIN output and continue normal execution |
ddExplainForHumans (deprecated) |
dumps URL to processed EXPLAIN output and stops execution |
Raw Queries
In some cases you are executing raw SQL queries and don't use the query builder. You can use the MysqlExplain
facade to get the EXPLAIN url for them:
Testing
Changelog
Please see CHANGELOG for more information on what has changed recently.
Credits
- Tobias Petry
- All Contributors
License
The MIT License (MIT). Please see License File for more information.
All versions of laravel-mysql-explain with dependencies
ext-pdo Version *
guzzlehttp/guzzle Version ^7.0
illuminate/contracts Version ^6.0|^7.0|^8.0|^9.0|^10.0|^11.0
tpetry/php-mysql-explain Version ^1.0