{"repo":"tpetry/laravel-mysql-explain","free":true,"listed":false,"github":"https://github.com/tpetry/laravel-mysql-explain","clone":"git clone https://github.com/tpetry/laravel-mysql-explain.git","description":"Get Visual MySQL EXPLAIN plans with Laravel that are understandable for humans","language":"PHP","stars":267,"topics":["explain","laravel","mysql","query-optimization"],"license":"MIT","category":"databases-storage","readme_excerpt":"Laravel MySQL Visual Explains ![License][icon-license] ![PHP][icon-php] ![Laravel][icon-laravel] [![Latest Version on Packagist][icon-version]][href-version] [![GitHub Unit Tests Action Status][icon-tests]][href-tests] [![GitHub Static Analysis Action Status][icon-staticanalysis]][href-staticanalysis] [![GitHub Code Style Action Status][icon-codestyle]][href-codestyle] 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 executi","default_branch":null,"files":null,"tree":[],"storefront":"/r/tpetry","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tpetry/laravel-mysql-explain/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}