Symfony Profiler

Query Metrics

1 Database Queries

74.29 ms Execution Time

2.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

74.29 ms

2.00 ms

#▲	Execution Time	Query Time	Info
1	74.29 ms	2.00 ms	{"query":{"bool":{"must":[{"terms":{"master":[false]}},{"terms":{"deleted":[false]}},{"terms":{"subdomain":["mv"]}}],"must_not":[{"terms":{"publicParticipationPhase":[""]}},{"terms":{"publicParticipationPhase":["configuration"]}}]}},"aggs":{"municipalCode_missing":{"missing":{"field":"municipalCode.raw"}},"municipalCode.raw":{"terms":{"field":"municipalCode.raw","size":10000}},"locationPostCode_missing":{"missing":{"field":"locationPostCode.raw"}},"locationPostCode.raw":{"terms":{"field":"locationPostCode.raw","size":10000}},"ars_missing":{"missing":{"field":"ars"}},"ars":{"terms":{"field":"ars","size":10000}},"locationName_missing":{"missing":{"field":"locationName.raw"}},"locationName.raw":{"terms":{"field":"locationName.raw","size":10000}},"planningArea_missing":{"missing":{"field":"planningArea.raw"}},"planningArea.raw":{"terms":{"field":"planningArea.raw","size":10000}},"procedureCategoryNames_missing":{"missing":{"field":"procedureCategoryNames"}},"procedureCategoryNames":{"terms":{"field":"procedureCategoryNames","size":10000}},"participationGuestOnly_missing":{"missing":{"field":"participationGuestOnly"}},"participationGuestOnly":{"terms":{"field":"participationGuestOnly","size":10000}},"subdomain_missing":{"missing":{"field":"subdomain"}},"subdomain":{"terms":{"field":"subdomain","size":10000}},"publicParticipationPhasePermissionset_missing":{"missing":{"field":"publicParticipationPhasePermissionset"}},"publicParticipationPhasePermissionset":{"terms":{"field":"publicParticipationPhasePermissionset","size":10000}},"publicParticipationPhase_missing":{"missing":{"field":"publicParticipationPhase"}},"publicParticipationPhase":{"terms":{"field":"publicParticipationPhase","size":10000}},"orgaName_missing":{"missing":{"field":"orgaName.raw"}},"orgaName.raw":{"terms":{"field":"orgaName.raw","size":10000}}},"sort":[{"publicParticipationEndDate":"asc"}]} Path: blp_h0x2c_procedures/_search Query: from=0&size=3000 Method: POST ( on :) Item count: 123 View formatted query View query backtrace { "query": { "bool": { "must": [ { "terms": { "master": [ false ] } }, { "terms": { "deleted": [ false ] } }, { "terms": { "subdomain": [ "mv" ] } } ], "must_not": [ { "terms": { "publicParticipationPhase": [ "" ] } }, { "terms": { "publicParticipationPhase": [ "configuration" ] } } ] } }, "aggs": { "municipalCode_missing": { "missing": { "field": "municipalCode.raw" } }, "municipalCode.raw": { "terms": { "field": "municipalCode.raw", "size": 10000 } }, "locationPostCode_missing": { "missing": { "field": "locationPostCode.raw" } }, "locationPostCode.raw": { "terms": { "field": "locationPostCode.raw", "size": 10000 } }, "ars_missing": { "missing": { "field": "ars" } }, "ars": { "terms": { "field": "ars", "size": 10000 } }, "locationName_missing": { "missing": { "field": "locationName.raw" } }, "locationName.raw": { "terms": { "field": "locationName.raw", "size": 10000 } }, "planningArea_missing": { "missing": { "field": "planningArea.raw" } }, "planningArea.raw": { "terms": { "field": "planningArea.raw", "size": 10000 } }, "procedureCategoryNames_missing": { "missing": { "field": "procedureCategoryNames" } }, "procedureCategoryNames": { "terms": { "field": "procedureCategoryNames", "size": 10000 } }, "participationGuestOnly_missing": { "missing": { "field": "participationGuestOnly" } }, "participationGuestOnly": { "terms": { "field": "participationGuestOnly", "size": 10000 } }, "subdomain_missing": { "missing": { "field": "subdomain" } }, "subdomain": { "terms": { "field": "subdomain", "size": 10000 } }, "publicParticipationPhasePermissionset_missing": { "missing": { "field": "publicParticipationPhasePermissionset" } }, "publicParticipationPhasePermissionset": { "terms": { "field": "publicParticipationPhasePermissionset", "size": 10000 } }, "publicParticipationPhase_missing": { "missing": { "field": "publicParticipationPhase" } }, "publicParticipationPhase": { "terms": { "field": "publicParticipationPhase", "size": 10000 } }, "orgaName_missing": { "missing": { "field": "orgaName.raw" } }, "orgaName.raw": { "terms": { "field": "orgaName.raw", "size": 10000 } } }, "sort": [ { "publicParticipationEndDate": "asc" } ] } #0 /srv/www/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(180): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /srv/www/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(115): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /srv/www/vendor/elasticsearch/elasticsearch/src/Traits/ClientEndpointsTrait.php(1736): FOS\ElasticaBundle\Elastica\Client->sendRequest() #3 /srv/www/vendor/ruflin/elastica/src/Search.php(306): Elastica\Client->search() #4 /srv/www/vendor/ruflin/elastica/src/Index.php(532): Elastica\Search->search() #5 /srv/www/vendor/pagerfanta/pagerfanta/lib/Adapter/Elastica/ElasticaAdapter.php(77): Elastica\Index->search() #6 /srv/www/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(260): Pagerfanta\Elastica\ElasticaAdapter->getSlice() #7 /srv/www/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(249): Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter() #8 /srv/www/demosplan/DemosPlanCoreBundle/Traits/DI/ElasticsearchQueryTrait.php(163): Pagerfanta\Pagerfanta->getCurrentPageResults() #9 /srv/www/demosplan/DemosPlanCoreBundle/Repository/ProcedureElasticsearchRepository.php(56): demosplan\DemosPlanCoreBundle\Repository\ProcedureElasticsearchRepository->getElasticsearchResult() #10 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/ProcedureService.php(1218): demosplan\DemosPlanCoreBundle\Repository\ProcedureElasticsearchRepository->searchProcedures() #11 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/ServiceOutput.php(151): demosplan\DemosPlanCoreBundle\Logic\Procedure\ProcedureService->getPublicList() #12 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/ProcedureHandler.php(182): demosplan\DemosPlanCoreBundle\Logic\Procedure\ServiceOutput->procedureListHandler() #13 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/PublicIndexProcedureLister.php(106): demosplan\DemosPlanCoreBundle\Logic\Procedure\ProcedureHandler->getProcedureList() #14 /srv/www/demosplan/DemosPlanCoreBundle/Controller/Platform/EntrypointController.php(218): demosplan\DemosPlanCoreBundle\Logic\Procedure\PublicIndexProcedureLister->getPublicIndexProcedureList() #15 /srv/www/demosplan/DemosPlanCoreBundle/Controller/Platform/EntrypointController.php(142): demosplan\DemosPlanCoreBundle\Controller\Platform\EntrypointController->renderPublicIndexList() #16 /srv/www/vendor/symfony/http-kernel/HttpKernel.php(181): demosplan\DemosPlanCoreBundle\Controller\Platform\EntrypointController->index() #17 /srv/www/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #18 /srv/www/vendor/symfony/http-kernel/Kernel.php(208): Symfony\Component\HttpKernel\HttpKernel->handle() #19 /srv/www/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #20 /srv/www/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #21 /srv/www/public/app_dev.php(13): require_once('...') #22 {main}

{"query":{"bool":{"must":[{"terms":{"master":[false]}},{"terms":{"deleted":[false]}},{"terms":{"subdomain":["mv"]}}],"must_not":[{"terms":{"publicParticipationPhase":[""]}},{"terms":{"publicParticipationPhase":["configuration"]}}]}},"aggs":{"municipalCode_missing":{"missing":{"field":"municipalCode.raw"}},"municipalCode.raw":{"terms":{"field":"municipalCode.raw","size":10000}},"locationPostCode_missing":{"missing":{"field":"locationPostCode.raw"}},"locationPostCode.raw":{"terms":{"field":"locationPostCode.raw","size":10000}},"ars_missing":{"missing":{"field":"ars"}},"ars":{"terms":{"field":"ars","size":10000}},"locationName_missing":{"missing":{"field":"locationName.raw"}},"locationName.raw":{"terms":{"field":"locationName.raw","size":10000}},"planningArea_missing":{"missing":{"field":"planningArea.raw"}},"planningArea.raw":{"terms":{"field":"planningArea.raw","size":10000}},"procedureCategoryNames_missing":{"missing":{"field":"procedureCategoryNames"}},"procedureCategoryNames":{"terms":{"field":"procedureCategoryNames","size":10000}},"participationGuestOnly_missing":{"missing":{"field":"participationGuestOnly"}},"participationGuestOnly":{"terms":{"field":"participationGuestOnly","size":10000}},"subdomain_missing":{"missing":{"field":"subdomain"}},"subdomain":{"terms":{"field":"subdomain","size":10000}},"publicParticipationPhasePermissionset_missing":{"missing":{"field":"publicParticipationPhasePermissionset"}},"publicParticipationPhasePermissionset":{"terms":{"field":"publicParticipationPhasePermissionset","size":10000}},"publicParticipationPhase_missing":{"missing":{"field":"publicParticipationPhase"}},"publicParticipationPhase":{"terms":{"field":"publicParticipationPhase","size":10000}},"orgaName_missing":{"missing":{"field":"orgaName.raw"}},"orgaName.raw":{"terms":{"field":"orgaName.raw","size":10000}}},"sort":[{"publicParticipationEndDate":"asc"}]}

Path: blp_h0x2c_procedures/_search
Query: from=0&size=3000
Method: POST ( on :)
Item count: 123
View formatted query View query backtrace


                                                            {
    "query": {
        "bool": {
            "must": [
                {
                    "terms": {
                        "master": [
                            false
                        ]
                    }
                },
                {
                    "terms": {
                        "deleted": [
                            false
                        ]
                    }
                },
                {
                    "terms": {
                        "subdomain": [
                            "mv"
                        ]
                    }
                }
            ],
            "must_not": [
                {
                    "terms": {
                        "publicParticipationPhase": [
                            ""
                        ]
                    }
                },
                {
                    "terms": {
                        "publicParticipationPhase": [
                            "configuration"
                        ]
                    }
                }
            ]
        }
    },
    "aggs": {
        "municipalCode_missing": {
            "missing": {
                "field": "municipalCode.raw"
            }
        },
        "municipalCode.raw": {
            "terms": {
                "field": "municipalCode.raw",
                "size": 10000
            }
        },
        "locationPostCode_missing": {
            "missing": {
                "field": "locationPostCode.raw"
            }
        },
        "locationPostCode.raw": {
            "terms": {
                "field": "locationPostCode.raw",
                "size": 10000
            }
        },
        "ars_missing": {
            "missing": {
                "field": "ars"
            }
        },
        "ars": {
            "terms": {
                "field": "ars",
                "size": 10000
            }
        },
        "locationName_missing": {
            "missing": {
                "field": "locationName.raw"
            }
        },
        "locationName.raw": {
            "terms": {
                "field": "locationName.raw",
                "size": 10000
            }
        },
        "planningArea_missing": {
            "missing": {
                "field": "planningArea.raw"
            }
        },
        "planningArea.raw": {
            "terms": {
                "field": "planningArea.raw",
                "size": 10000
            }
        },
        "procedureCategoryNames_missing": {
            "missing": {
                "field": "procedureCategoryNames"
            }
        },
        "procedureCategoryNames": {
            "terms": {
                "field": "procedureCategoryNames",
                "size": 10000
            }
        },
        "participationGuestOnly_missing": {
            "missing": {
                "field": "participationGuestOnly"
            }
        },
        "participationGuestOnly": {
            "terms": {
                "field": "participationGuestOnly",
                "size": 10000
            }
        },
        "subdomain_missing": {
            "missing": {
                "field": "subdomain"
            }
        },
        "subdomain": {
            "terms": {
                "field": "subdomain",
                "size": 10000
            }
        },
        "publicParticipationPhasePermissionset_missing": {
            "missing": {
                "field": "publicParticipationPhasePermissionset"
            }
        },
        "publicParticipationPhasePermissionset": {
            "terms": {
                "field": "publicParticipationPhasePermissionset",
                "size": 10000
            }
        },
        "publicParticipationPhase_missing": {
            "missing": {
                "field": "publicParticipationPhase"
            }
        },
        "publicParticipationPhase": {
            "terms": {
                "field": "publicParticipationPhase",
                "size": 10000
            }
        },
        "orgaName_missing": {
            "missing": {
                "field": "orgaName.raw"
            }
        },
        "orgaName.raw": {
            "terms": {
                "field": "orgaName.raw",
                "size": 10000
            }
        }
    },
    "sort": [
        {
            "publicParticipationEndDate": "asc"
        }
    ]
}

#0 /srv/www/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(180): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /srv/www/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(115): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /srv/www/vendor/elasticsearch/elasticsearch/src/Traits/ClientEndpointsTrait.php(1736): FOS\ElasticaBundle\Elastica\Client->sendRequest()
#3 /srv/www/vendor/ruflin/elastica/src/Search.php(306): Elastica\Client->search()
#4 /srv/www/vendor/ruflin/elastica/src/Index.php(532): Elastica\Search->search()
#5 /srv/www/vendor/pagerfanta/pagerfanta/lib/Adapter/Elastica/ElasticaAdapter.php(77): Elastica\Index->search()
#6 /srv/www/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(260): Pagerfanta\Elastica\ElasticaAdapter->getSlice()
#7 /srv/www/vendor/pagerfanta/pagerfanta/lib/Core/Pagerfanta.php(249): Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter()
#8 /srv/www/demosplan/DemosPlanCoreBundle/Traits/DI/ElasticsearchQueryTrait.php(163): Pagerfanta\Pagerfanta->getCurrentPageResults()
#9 /srv/www/demosplan/DemosPlanCoreBundle/Repository/ProcedureElasticsearchRepository.php(56): demosplan\DemosPlanCoreBundle\Repository\ProcedureElasticsearchRepository->getElasticsearchResult()
#10 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/ProcedureService.php(1218): demosplan\DemosPlanCoreBundle\Repository\ProcedureElasticsearchRepository->searchProcedures()
#11 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/ServiceOutput.php(151): demosplan\DemosPlanCoreBundle\Logic\Procedure\ProcedureService->getPublicList()
#12 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/ProcedureHandler.php(182): demosplan\DemosPlanCoreBundle\Logic\Procedure\ServiceOutput->procedureListHandler()
#13 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Procedure/PublicIndexProcedureLister.php(106): demosplan\DemosPlanCoreBundle\Logic\Procedure\ProcedureHandler->getProcedureList()
#14 /srv/www/demosplan/DemosPlanCoreBundle/Controller/Platform/EntrypointController.php(218): demosplan\DemosPlanCoreBundle\Logic\Procedure\PublicIndexProcedureLister->getPublicIndexProcedureList()
#15 /srv/www/demosplan/DemosPlanCoreBundle/Controller/Platform/EntrypointController.php(142): demosplan\DemosPlanCoreBundle\Controller\Platform\EntrypointController->renderPublicIndexList()
#16 /srv/www/vendor/symfony/http-kernel/HttpKernel.php(181): demosplan\DemosPlanCoreBundle\Controller\Platform\EntrypointController->index()
#17 /srv/www/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#18 /srv/www/vendor/symfony/http-kernel/Kernel.php(208): Symfony\Component\HttpKernel\HttpKernel->handle()
#19 /srv/www/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#20 /srv/www/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#21 /srv/www/public/app_dev.php(13): require_once('...')
#22 {main}

Symfony Profiler

GET http://blp-dev-debug.demos-europe.eu/

Configuration Settings

Theme

Page Width

Query Metrics

Queries