Analyze query execution time?

Question

API

There is a backend (api) on laravel. Requests for get, put take 100ms on average, and for some reason 300-1000ms for post.
How to analyze code execution, which processing takes the most time?

Answer 1

1) Use a profiler like xdebug. As a result, we get detailed information about the execution of all calls in the code. Then, using some tool, we view this information in a readable format.
2) Install the Laravel debugbar package . You will get a debug panel, which will display the time spent loading the framework and executing the code itself, the time spent executing database queries. Also, you can measure the execution time of the functions you are interested in in this way:

Debugbar::startMeasure('example', 'Time for example code');
// код, который нужно проанализировать
Debugbar::stopMeasure('example');

Answer 2

https://habrahabr.ru/post/129042/