Query Metrics
1
Database Queries
1358.51 ms
Execution Time
1145.00 ms
Query Time
Queries
| #▲ |
Execution Time |
Query Time |
Info |
| 1 |
1358.51 ms |
1145.00 ms |
{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"category":{"value":3,"boost":1}}},{"term":{"status":{"value":2,"boost":1}}},{"bool":{"should":[{"terms":{"compoundLocation.id":[9]}}]}},{"bool":{}}],"must_not":[{"exists":{"field":"parent"}}]}}]}},"sort":["_score",{"featured":{"order":"desc"}}],"from":0,"size":30}
Path: aqarmap_eg_legacy_listings/_search
Query:
Method: POST (http on elasticsearch-master.elasticsearch-8.svc.cluster.local:9200)
Item count: 3
View formatted query
View query backtrace
#0 /var/www/html/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /var/www/html/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /var/www/html/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /var/www/html/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /var/www/html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search()
#5 /var/www/html/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /var/www/html/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(40): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults()
#7 /var/www/html/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(116): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items()
#8 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
#9 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#10 /var/www/html/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(139): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#11 /var/www/html/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(93): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
#12 /var/www/html/var/cache/dev/ContainerVb8mf1y/proxy-classes.php(204): Knp\Component\Pager\Paginator->paginate()
#13 /var/www/html/src/Aqarmap/Bundle/SearchBundle/Services/CompoundSearchService.php(142): ContainerVb8mf1y\PaginatorProxy9cc2a8f->paginate()
#14 /var/www/html/src/Aqarmap/Bundle/SearchBundle/Services/CompoundSearchService.php(121): Aqarmap\Bundle\SearchBundle\Services\CompoundSearchService->getResults()
#15 /var/www/html/src/Aqarmap/Bundle/ListingBundle/Service/CompoundService.php(230): Aqarmap\Bundle\SearchBundle\Services\CompoundSearchService->getCompounds()
#16 /var/www/html/src/Aqarmap/Bundle/ListingBundle/Controller/CompoundSearchController.php(29): Aqarmap\Bundle\ListingBundle\Service\CompoundService->search()
#17 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(181): Aqarmap\Bundle\ListingBundle\Controller\CompoundSearchController->compoundSearchResult()
#18 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#19 /var/www/html/vendor/symfony/http-kernel/Kernel.php(208): Symfony\Component\HttpKernel\HttpKernel->handle()
#20 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#21 /var/www/html/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#22 /var/www/html/public/index.php(6): require_once('...')
#23 {main}
|
