Symfony Profiler

Query Metrics

1 Database Queries

3.37 ms Execution Time

1.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

3.37 ms

1.00 ms

#▲	Execution Time	Query Time	Info
1	3.37 ms	1.00 ms	{"query":{"bool":{"must_not":[{"exists":{"field":"diagonal"}}]}},"from":0,"size":9} Path: itlabs_equipment/_search Query: Method: POST (Http on localhost:9200) Item count: 57 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must_not": [ { "exists": { "field": "diagonal" } } ] } }, "from": 0, "size": 9 }` `curl -XPOST 'http://localhost:9200/itlabs_equipment/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must_not":[{"exists":{"field":"diagonal"}}]}},"from":0,"size":9}'` #0 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /home/shared-backend/web/api.itlabs.top/public_html/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /home/shared-backend/web/api.itlabs.top/public_html/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search() #5 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults() #6 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(80): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults() #7 /home/shared-backend/web/api.itlabs.top/public_html/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(268): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getSlice() #8 /home/shared-backend/web/api.itlabs.top/public_html/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(257): Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter() #9 /home/shared-backend/web/api.itlabs.top/public_html/src/Controller/GetEquipmentsController.php(109): Pagerfanta\Pagerfanta->getCurrentPageResults() #10 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/http-kernel/HttpKernel.php(183): App\Controller\GetEquipmentsController->__invoke() #11 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #12 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\Component\HttpKernel\HttpKernel->handle() #13 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #14 /home/shared-backend/web/api.itlabs.top/public_html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #15 /home/shared-backend/web/api.itlabs.top/public_html/public/index.php(5): require_once('...') #16 {main}

{"query":{"bool":{"must_not":[{"exists":{"field":"diagonal"}}]}},"from":0,"size":9}

Path: itlabs_equipment/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 57
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must_not": [
                {
                    "exists": {
                        "field": "diagonal"
                    }
                }
            ]
        }
    },
    "from": 0,
    "size": 9
}

curl -XPOST 'http://localhost:9200/itlabs_equipment/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must_not":[{"exists":{"field":"diagonal"}}]}},"from":0,"size":9}'

#0 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(140): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(82): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /home/shared-backend/web/api.itlabs.top/public_html/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /home/shared-backend/web/api.itlabs.top/public_html/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search()
#5 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /home/shared-backend/web/api.itlabs.top/public_html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(80): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults()
#7 /home/shared-backend/web/api.itlabs.top/public_html/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(268): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getSlice()
#8 /home/shared-backend/web/api.itlabs.top/public_html/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(257): Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter()
#9 /home/shared-backend/web/api.itlabs.top/public_html/src/Controller/GetEquipmentsController.php(109): Pagerfanta\Pagerfanta->getCurrentPageResults()
#10 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/http-kernel/HttpKernel.php(183): App\Controller\GetEquipmentsController->__invoke()
#11 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#12 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\Component\HttpKernel\HttpKernel->handle()
#13 /home/shared-backend/web/api.itlabs.top/public_html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#14 /home/shared-backend/web/api.itlabs.top/public_html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#15 /home/shared-backend/web/api.itlabs.top/public_html/public/index.php(5): require_once('...')
#16 {main}

Symfony Profiler

GET https://api.itlabs.top/api/equipments/

Configuration Settings

Theme

Page Width

Query Metrics

Queries