| 1 |
5.10 ms |
2.00 ms |
{"query":{"bool":{"must":[{"match_all":{}},{"terms":{"type":["person"]}},{"bool":{"should":[{"range":{"date_death":{"gte":"2025-04-30"}}},{"bool":{"must_not":[{"exists":{"field":"date_death"}}]}}]}},{"terms":{"tags.id":["7688"]}}]}},"sort":[{"date_last_update.raw":{"order":"desc","missing":"_last"}}],"track_total_hits":true,"from":0,"size":15}
Path: musicdb_metas_integration/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 483
View formatted query
View cURL query
View query backtrace
curl -XPOST 'http://localhost:9200/musicdb_metas_integration/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"match_all":{}},{"terms":{"type":["person"]}},{"bool":{"should":[{"range":{"date_death":{"gte":"2025-04-30"}}},{"bool":{"must_not":[{"exists":{"field":"date_death"}}]}}]}},{"terms":{"tags.id":["7688"]}}]}},"sort":[{"date_last_update.raw":{"order":"desc","missing":"_last"}}],"track_total_hits":true,"from":0,"size":15}'
#0 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery('musicdb_metas_i...', 'POST', Array, 0.0051000118255615, Array, Array, 2, 483)
#1 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery('musicdb_metas_i...', 'POST', Array, Array, 0.0051000118255615, 2, 483)
#2 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request('musicdb_metas_i...', 'POST', Array, Array)
#3 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search(Object(Elastica\Query), NULL, 'POST')
#4 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search(Object(Elastica\Query), Array)
#5 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(74): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults(0, 15)
#6 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/src/Service/ElasticaService.php(389): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getResults(0, 15)
#7 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/src/Admin/Controller/ContactController.php(308): App\Service\ElasticaService->search('tags.id', NULL, 1, 15, NULL, Object(Symfony\Component\HttpFoundation\Request), 'person', Array, true, false, 'date_last_updat...', 'desc', true)
#8 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/symfony/http-kernel/HttpKernel.php(181): App\Admin\Controller\ContactController->searchAdvancedAction(Object(App\Service\PaginationService), Object(App\Service\ElasticaService), Object(Symfony\Component\HttpFoundation\Request), 1)
#9 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#10 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /home/cnm-musicdb-es7/www/integration/releases/20250430075419/public/index.php(25): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#12 {main}
|