| 1 |
77.03 ms |
3.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: 120
View formatted query
View query backtrace
#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(1207): 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(180): 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(204): demosplan\DemosPlanCoreBundle\Logic\Procedure\PublicIndexProcedureLister->getPublicIndexProcedureList()
#15 /srv/www/demosplan/DemosPlanCoreBundle/Controller/Platform/EntrypointController.php(141): 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(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#19 /srv/www/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#20 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(482): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#21 /srv/www/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(68): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#22 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(457): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#23 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(355): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#24 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(225): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#25 /srv/www/demosplan/DemosPlanCoreBundle/Application/FrontController.php(133): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#26 /srv/www/projects/blp/web/app_dev.php(15): demosplan\DemosPlanCoreBundle\Application\FrontController::web()
#27 {main}
|