| 1 |
6.75 ms |
3.00 ms |
{"query":{"bool":{"must":[{"terms":{"pId":["b27fc44b-170b-475a-b0d5-42b1b2315b58"]}},{"terms":{"deleted":[false]}},{"exists":{"field":"originalId"}},{"terms":{"publicVerified":["publication_approved"]}}],"must_not":[{"exists":{"field":"headStatementId"}}]}},"aggs":{"publicStatement":{"terms":{"field":"publicStatement","size":10000,"min_doc_count":1}},"oName.raw":{"terms":{"field":"oName.raw","size":10000,"min_doc_count":1}},"oName.raw_missing":{"missing":{"field":"oName.raw"}},"dName.raw":{"terms":{"field":"dName.raw","size":10000,"min_doc_count":1}},"dName.raw_missing":{"missing":{"field":"dName.raw"}},"phase":{"terms":{"field":"phase","size":10000,"min_doc_count":1}},"movedFromProcedureId":{"terms":{"field":"movedFromProcedureId","size":10000,"min_doc_count":1}},"movedToProcedureId":{"terms":{"field":"movedToProcedureId","size":10000,"min_doc_count":1}},"publicAllowed":{"terms":{"field":"publicAllowed","size":10000,"min_doc_count":1}},"publicCheck":{"terms":{"field":"publicCheck","size":10000,"min_doc_count":1}},"publicVerified":{"terms":{"field":"publicVerified","size":10000,"min_doc_count":1}},"meta.userState":{"terms":{"field":"meta.userState","size":10000,"min_doc_count":1}},"meta.userGroup":{"terms":{"field":"meta.userGroup","size":10000,"min_doc_count":1}},"meta.userOrganisation":{"terms":{"field":"meta.userOrganisation","size":10000,"min_doc_count":1}},"meta.userPosition":{"terms":{"field":"meta.userPosition","size":10000,"min_doc_count":1}},"assignee_id":{"terms":{"field":"assignee.id","size":10000,"min_doc_count":1}},"assignee.id_missing":{"missing":{"field":"assignee.id"}},"status":{"terms":{"field":"status","size":10000,"min_doc_count":1}},"votePla":{"terms":{"field":"votePla","size":10000,"min_doc_count":1}},"votePla_missing":{"missing":{"field":"votePla"}},"countyNames":{"terms":{"field":"countyNames.raw","size":10000,"min_doc_count":1}},"countyNames.raw_missing":{"missing":{"field":"countyNames.raw"}},"municipalityNames":{"terms":{"field":"municipalityNames.raw","size":10000,"min_doc_count":1}},"municipalityNames.raw_missing":{"missing":{"field":"municipalityNames.raw"}},"tagNames":{"terms":{"field":"tagNames.raw","size":10000,"min_doc_count":1}},"tagNames.raw_missing":{"missing":{"field":"tagNames.raw"}},"priorityAreaKeys":{"terms":{"field":"priorityAreaKeys","size":10000,"min_doc_count":1}},"priorityAreaKeys_missing":{"missing":{"field":"priorityAreaKeys"}},"elementId":{"terms":{"field":"elementId","size":10000,"order":{"_key":"asc"},"min_doc_count":1}},"elementId_missing":{"missing":{"field":"elementId"}},"paragraphParentId":{"terms":{"field":"paragraphParentId","size":10000,"min_doc_count":1}},"paragraphParentId_missing":{"missing":{"field":"paragraphParentId"}},"documentParentId":{"terms":{"field":"documentParentId","size":10000,"min_doc_count":1}},"documentParentId_missing":{"missing":{"field":"documentParentId"}},"topicNames":{"terms":{"field":"topicNames.raw","size":10000,"min_doc_count":1}},"topicNames.raw_missing":{"missing":{"field":"topicNames.raw"}},"externId":{"terms":{"field":"externId","size":10000,"min_doc_count":1}},"name.raw":{"terms":{"field":"name.raw","size":10000,"min_doc_count":1}},"type":{"terms":{"field":"type","size":10000,"min_doc_count":1}},"priority":{"terms":{"field":"priority","size":10000,"min_doc_count":1}},"voteStk":{"terms":{"field":"voteStk","size":10000,"min_doc_count":1}},"voteStk_missing":{"missing":{"field":"voteStk"}},"fragments_lastClaimed_id":{"terms":{"field":"fragments.lastClaimedUserId","size":10000,"min_doc_count":1}},"fragments.lastClaimedUserId_missing":{"nested":{"path":"fragments"},"aggs":{"fragments.lastClaimedUserId_missing":{"missing":{"field":"fragments.lastClaimedUserId"},"aggs":{"statements":{"terms":{"field":"fragments.statementId"}}}}}},"fragments_status":{"terms":{"field":"fragments.status","size":10000,"min_doc_count":1}},"fragments_vote":{"terms":{"field":"fragments.vote","size":10000,"min_doc_count":1}},"fragments.vote_missing":{"nested":{"path":"fragments"},"aggs":{"fragments.vote_missing":{"missing":{"field":"fragments.vote"},"aggs":{"statements":{"terms":{"field":"fragments.statementId"}}}}}},"fragments_countyNames":{"terms":{"field":"fragments.countyNames.raw","size":10000,"min_doc_count":1}},"fragments.countyNames.raw_missing":{"nested":{"path":"fragments"},"aggs":{"fragments.countyNames.raw_missing":{"missing":{"field":"fragments.countyNames.raw"},"aggs":{"statements":{"terms":{"field":"fragments.statementId"}}}}}},"fragments_municipalityNames":{"terms":{"field":"fragments.municipalityNames.raw","size":10000,"min_doc_count":1}},"fragments.municipalityNames.raw_missing":{"nested":{"path":"fragments"},"aggs":{"fragments.municipalityNames.raw_missing":{"missing":{"field":"fragments.municipalityNames.raw"},"aggs":{"statements":{"terms":{"field":"fragments.statementId"}}}}}},"fragments_tagNames":{"terms":{"field":"fragments.tags.name.raw","size":10000,"min_doc_count":1}},"fragments.priorityAreaKeys":{"terms":{"field":"fragments.priorityAreaKeys","size":10000,"min_doc_count":1}},"fragments_element":{"terms":{"field":"fragments.elementId","size":10000,"min_doc_count":1}},"fragments_paragraphParentId":{"terms":{"field":"fragments.paragraphParentId","size":10000,"min_doc_count":1}},"fragments.paragraphParentId_missing":{"nested":{"path":"fragments"},"aggs":{"fragments.paragraphParentId_missing":{"missing":{"field":"fragments.paragraphParentId"},"aggs":{"statements":{"terms":{"field":"fragments.statementId"}}}}}},"fragments.documentParentId_missing":{"nested":{"path":"fragments"},"aggs":{"fragments.documentParentId_missing":{"missing":{"field":"fragments.documentParentId"},"aggs":{"statements":{"terms":{"field":"fragments.statementId"}}}}}},"fragments.documentParentId":{"terms":{"field":"fragments.documentParentId","size":10000,"min_doc_count":1}},"fragments.departmentId_missing":{"nested":{"path":"fragments"},"aggs":{"fragments.departmentId_missing":{"missing":{"field":"fragments.departmentId"},"aggs":{"statements":{"terms":{"field":"fragments.statementId"}}}}}},"fragments.departmentId":{"terms":{"field":"fragments.departmentId","size":10000,"min_doc_count":1}}},"sort":[{"submit":"desc"}]}
Path: diplanbau_h0x19_statements/_search
Query: from=0&size=10
Method: POST ( on :)
Item count: 0
View formatted query
View query backtrace
{
"query": {
"bool": {
"must": [
{
"terms": {
"pId": [
"b27fc44b-170b-475a-b0d5-42b1b2315b58"
]
}
},
{
"terms": {
"deleted": [
false
]
}
},
{
"exists": {
"field": "originalId"
}
},
{
"terms": {
"publicVerified": [
"publication_approved"
]
}
}
],
"must_not": [
{
"exists": {
"field": "headStatementId"
}
}
]
}
},
"aggs": {
"publicStatement": {
"terms": {
"field": "publicStatement",
"size": 10000,
"min_doc_count": 1
}
},
"oName.raw": {
"terms": {
"field": "oName.raw",
"size": 10000,
"min_doc_count": 1
}
},
"oName.raw_missing": {
"missing": {
"field": "oName.raw"
}
},
"dName.raw": {
"terms": {
"field": "dName.raw",
"size": 10000,
"min_doc_count": 1
}
},
"dName.raw_missing": {
"missing": {
"field": "dName.raw"
}
},
"phase": {
"terms": {
"field": "phase",
"size": 10000,
"min_doc_count": 1
}
},
"movedFromProcedureId": {
"terms": {
"field": "movedFromProcedureId",
"size": 10000,
"min_doc_count": 1
}
},
"movedToProcedureId": {
"terms": {
"field": "movedToProcedureId",
"size": 10000,
"min_doc_count": 1
}
},
"publicAllowed": {
"terms": {
"field": "publicAllowed",
"size": 10000,
"min_doc_count": 1
}
},
"publicCheck": {
"terms": {
"field": "publicCheck",
"size": 10000,
"min_doc_count": 1
}
},
"publicVerified": {
"terms": {
"field": "publicVerified",
"size": 10000,
"min_doc_count": 1
}
},
"meta.userState": {
"terms": {
"field": "meta.userState",
"size": 10000,
"min_doc_count": 1
}
},
"meta.userGroup": {
"terms": {
"field": "meta.userGroup",
"size": 10000,
"min_doc_count": 1
}
},
"meta.userOrganisation": {
"terms": {
"field": "meta.userOrganisation",
"size": 10000,
"min_doc_count": 1
}
},
"meta.userPosition": {
"terms": {
"field": "meta.userPosition",
"size": 10000,
"min_doc_count": 1
}
},
"assignee_id": {
"terms": {
"field": "assignee.id",
"size": 10000,
"min_doc_count": 1
}
},
"assignee.id_missing": {
"missing": {
"field": "assignee.id"
}
},
"status": {
"terms": {
"field": "status",
"size": 10000,
"min_doc_count": 1
}
},
"votePla": {
"terms": {
"field": "votePla",
"size": 10000,
"min_doc_count": 1
}
},
"votePla_missing": {
"missing": {
"field": "votePla"
}
},
"countyNames": {
"terms": {
"field": "countyNames.raw",
"size": 10000,
"min_doc_count": 1
}
},
"countyNames.raw_missing": {
"missing": {
"field": "countyNames.raw"
}
},
"municipalityNames": {
"terms": {
"field": "municipalityNames.raw",
"size": 10000,
"min_doc_count": 1
}
},
"municipalityNames.raw_missing": {
"missing": {
"field": "municipalityNames.raw"
}
},
"tagNames": {
"terms": {
"field": "tagNames.raw",
"size": 10000,
"min_doc_count": 1
}
},
"tagNames.raw_missing": {
"missing": {
"field": "tagNames.raw"
}
},
"priorityAreaKeys": {
"terms": {
"field": "priorityAreaKeys",
"size": 10000,
"min_doc_count": 1
}
},
"priorityAreaKeys_missing": {
"missing": {
"field": "priorityAreaKeys"
}
},
"elementId": {
"terms": {
"field": "elementId",
"size": 10000,
"order": {
"_key": "asc"
},
"min_doc_count": 1
}
},
"elementId_missing": {
"missing": {
"field": "elementId"
}
},
"paragraphParentId": {
"terms": {
"field": "paragraphParentId",
"size": 10000,
"min_doc_count": 1
}
},
"paragraphParentId_missing": {
"missing": {
"field": "paragraphParentId"
}
},
"documentParentId": {
"terms": {
"field": "documentParentId",
"size": 10000,
"min_doc_count": 1
}
},
"documentParentId_missing": {
"missing": {
"field": "documentParentId"
}
},
"topicNames": {
"terms": {
"field": "topicNames.raw",
"size": 10000,
"min_doc_count": 1
}
},
"topicNames.raw_missing": {
"missing": {
"field": "topicNames.raw"
}
},
"externId": {
"terms": {
"field": "externId",
"size": 10000,
"min_doc_count": 1
}
},
"name.raw": {
"terms": {
"field": "name.raw",
"size": 10000,
"min_doc_count": 1
}
},
"type": {
"terms": {
"field": "type",
"size": 10000,
"min_doc_count": 1
}
},
"priority": {
"terms": {
"field": "priority",
"size": 10000,
"min_doc_count": 1
}
},
"voteStk": {
"terms": {
"field": "voteStk",
"size": 10000,
"min_doc_count": 1
}
},
"voteStk_missing": {
"missing": {
"field": "voteStk"
}
},
"fragments_lastClaimed_id": {
"terms": {
"field": "fragments.lastClaimedUserId",
"size": 10000,
"min_doc_count": 1
}
},
"fragments.lastClaimedUserId_missing": {
"nested": {
"path": "fragments"
},
"aggs": {
"fragments.lastClaimedUserId_missing": {
"missing": {
"field": "fragments.lastClaimedUserId"
},
"aggs": {
"statements": {
"terms": {
"field": "fragments.statementId"
}
}
}
}
}
},
"fragments_status": {
"terms": {
"field": "fragments.status",
"size": 10000,
"min_doc_count": 1
}
},
"fragments_vote": {
"terms": {
"field": "fragments.vote",
"size": 10000,
"min_doc_count": 1
}
},
"fragments.vote_missing": {
"nested": {
"path": "fragments"
},
"aggs": {
"fragments.vote_missing": {
"missing": {
"field": "fragments.vote"
},
"aggs": {
"statements": {
"terms": {
"field": "fragments.statementId"
}
}
}
}
}
},
"fragments_countyNames": {
"terms": {
"field": "fragments.countyNames.raw",
"size": 10000,
"min_doc_count": 1
}
},
"fragments.countyNames.raw_missing": {
"nested": {
"path": "fragments"
},
"aggs": {
"fragments.countyNames.raw_missing": {
"missing": {
"field": "fragments.countyNames.raw"
},
"aggs": {
"statements": {
"terms": {
"field": "fragments.statementId"
}
}
}
}
}
},
"fragments_municipalityNames": {
"terms": {
"field": "fragments.municipalityNames.raw",
"size": 10000,
"min_doc_count": 1
}
},
"fragments.municipalityNames.raw_missing": {
"nested": {
"path": "fragments"
},
"aggs": {
"fragments.municipalityNames.raw_missing": {
"missing": {
"field": "fragments.municipalityNames.raw"
},
"aggs": {
"statements": {
"terms": {
"field": "fragments.statementId"
}
}
}
}
}
},
"fragments_tagNames": {
"terms": {
"field": "fragments.tags.name.raw",
"size": 10000,
"min_doc_count": 1
}
},
"fragments.priorityAreaKeys": {
"terms": {
"field": "fragments.priorityAreaKeys",
"size": 10000,
"min_doc_count": 1
}
},
"fragments_element": {
"terms": {
"field": "fragments.elementId",
"size": 10000,
"min_doc_count": 1
}
},
"fragments_paragraphParentId": {
"terms": {
"field": "fragments.paragraphParentId",
"size": 10000,
"min_doc_count": 1
}
},
"fragments.paragraphParentId_missing": {
"nested": {
"path": "fragments"
},
"aggs": {
"fragments.paragraphParentId_missing": {
"missing": {
"field": "fragments.paragraphParentId"
},
"aggs": {
"statements": {
"terms": {
"field": "fragments.statementId"
}
}
}
}
}
},
"fragments.documentParentId_missing": {
"nested": {
"path": "fragments"
},
"aggs": {
"fragments.documentParentId_missing": {
"missing": {
"field": "fragments.documentParentId"
},
"aggs": {
"statements": {
"terms": {
"field": "fragments.statementId"
}
}
}
}
}
},
"fragments.documentParentId": {
"terms": {
"field": "fragments.documentParentId",
"size": 10000,
"min_doc_count": 1
}
},
"fragments.departmentId_missing": {
"nested": {
"path": "fragments"
},
"aggs": {
"fragments.departmentId_missing": {
"missing": {
"field": "fragments.departmentId"
},
"aggs": {
"statements": {
"terms": {
"field": "fragments.statementId"
}
}
}
}
}
},
"fragments.departmentId": {
"terms": {
"field": "fragments.departmentId",
"size": 10000,
"min_doc_count": 1
}
}
},
"sort": [
{
"submit": "desc"
}
]
}
#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/Logic/Statement/ElasticsearchResultCreator.php(679): Pagerfanta\Pagerfanta->getCurrentPageResults()
#9 /srv/www/demosplan/DemosPlanCoreBundle/Logic/Statement/StatementService.php(837): demosplan\DemosPlanCoreBundle\Logic\Statement\ElasticsearchResultCreator->getElasticsearchResult()
#10 /srv/www/demosplan/DemosPlanCoreBundle/Controller/Procedure/DemosPlanProcedureController.php(1808): demosplan\DemosPlanCoreBundle\Logic\Statement\StatementService->getStatementsByProcedureId()
#11 /srv/www/vendor/symfony/http-kernel/HttpKernel.php(181): demosplan\DemosPlanCoreBundle\Controller\Procedure\DemosPlanProcedureController->publicDetail()
#12 /srv/www/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#13 /srv/www/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#14 /srv/www/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(86): Symfony\Component\HttpKernel\Kernel->handle()
#15 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(482): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#16 /srv/www/vendor/symfony/framework-bundle/HttpCache/HttpCache.php(68): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#17 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(457): Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
#18 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(355): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#19 /srv/www/vendor/symfony/http-kernel/HttpCache/HttpCache.php(225): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#20 /srv/www/demosplan/DemosPlanCoreBundle/Application/FrontController.php(133): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#21 /srv/www/projects/diplanbau/web/app_dev.php(15): demosplan\DemosPlanCoreBundle\Application\FrontController::web()
#22 {main}
|