Symfony Profiler

Query Metrics

1 Database Queries

979.65 ms Execution Time

962.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

979.65 ms

962.00 ms

#▲	Execution Time	Query Time	Info
1	979.65 ms	962.00 ms	{"query":{"bool":{"must":[{"match_all":{}}],"filter":[{"match":{"enabled":true}}]}},"sort":[{"ranks":{"order":"desc"}}],"size":500000} Path: establishment_catalogue_/_search Query: Method: POST (Http on 127.0.0.1:9200) Item count: 926 View formatted query View cURL query View query backtrace `{ "query": { "bool": { "must": [ { "match_all": {} } ], "filter": [ { "match": { "enabled": true } } ] } }, "sort": [ { "ranks": { "order": "desc" } } ], "size": 500000 }` `curl -XPOST 'http://127.0.0.1:9200/establishment_catalogue_/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"match_all":{}}],"filter":[{"match":{"enabled":true}}]}},"sort":[{"ranks":{"order":"desc"}}],"size":500000}'` #0 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(135): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(77): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request() #3 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search() #4 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(144): Elastica\Index->search() #5 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(46): FOS\ElasticaBundle\Finder\TransformedFinder->search() #6 /var/www/catalogue/guinee_catalogue/app/symfony/src/Elasticsearch/BaseEsService.php(146): FOS\ElasticaBundle\Finder\TransformedFinder->find() #7 /var/www/catalogue/guinee_catalogue/app/symfony/src/Controller/SearchController.php(65): App\Elasticsearch\BaseEsService->getAll() #8 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\SearchController->searchBySubPrefecture() #9 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #10 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #11 /var/www/catalogue/guinee_catalogue/app/symfony/public/index.php(23): Symfony\Component\HttpKernel\Kernel->handle() #12 {main}

{"query":{"bool":{"must":[{"match_all":{}}],"filter":[{"match":{"enabled":true}}]}},"sort":[{"ranks":{"order":"desc"}}],"size":500000}

Path: establishment_catalogue_/_search
Query:
Method: POST (Http on 127.0.0.1:9200)
Item count: 926
View formatted query View cURL query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "match_all": {}
                }
            ],
            "filter": [
                {
                    "match": {
                        "enabled": true
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "ranks": {
                "order": "desc"
            }
        }
    ],
    "size": 500000
}

curl -XPOST 'http://127.0.0.1:9200/establishment_catalogue_/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"match_all":{}}],"filter":[{"match":{"enabled":true}}]}},"sort":[{"ranks":{"order":"desc"}}],"size":500000}'

#0 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(135): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(77): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(144): Elastica\Index->search()
#5 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/friendsofsymfony/elastica-bundle/src/Finder/TransformedFinder.php(46): FOS\ElasticaBundle\Finder\TransformedFinder->search()
#6 /var/www/catalogue/guinee_catalogue/app/symfony/src/Elasticsearch/BaseEsService.php(146): FOS\ElasticaBundle\Finder\TransformedFinder->find()
#7 /var/www/catalogue/guinee_catalogue/app/symfony/src/Controller/SearchController.php(65): App\Elasticsearch\BaseEsService->getAll()
#8 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(181): App\Controller\SearchController->searchBySubPrefecture()
#9 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#10 /var/www/catalogue/guinee_catalogue/app/symfony/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#11 /var/www/catalogue/guinee_catalogue/app/symfony/public/index.php(23): Symfony\Component\HttpKernel\Kernel->handle()
#12 {main}

Symfony Profiler

GET http://193.70.3.237/index.php/establishment/search/establishmen/list?list=all&page=39

Configuration Settings

Theme

Page Width

Query Metrics

Queries