Symfony Profiler

Query Metrics

1 Database Queries

50.28 ms Execution Time

22.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

50.28 ms

22.00 ms

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

{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"category":{"value":3,"boost":1}}},{"term":{"status":{"value":2,"boost":1}}},{"bool":{"should":[{"terms":{"compoundLocation.id":[6]}}]}},{"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: 4
View formatted query View query backtrace


                                                            {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "term": {
                                    "category": {
                                        "value": 3,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "term": {
                                    "status": {
                                        "value": 2,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "terms": {
                                                "compoundLocation.id": [
                                                    6
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {}
                            }
                        ],
                        "must_not": [
                            {
                                "exists": {
                                    "field": "parent"
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        "_score",
        {
            "featured": {
                "order": "desc"
            }
        }
    ],
    "from": 0,
    "size": 30
}

#0 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(164): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(101): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /srv/moonshot/vendor/ruflin/elastica/src/Search.php(352): FOS\ElasticaBundle\Elastica\Client->request()
#3 /srv/moonshot/vendor/ruflin/elastica/src/Index.php(546): Elastica\Search->search()
#4 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(169): Elastica\Index->search()
#5 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Paginator/TransformedPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(40): FOS\ElasticaBundle\Paginator\TransformedPaginatorAdapter->getResults()
#7 /srv/moonshot/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(116): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items()
#8 /srv/moonshot/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
#9 /srv/moonshot/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#10 /srv/moonshot/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(139): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
#11 /srv/moonshot/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php(93): Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
#12 /srv/moonshot/var/cache/dev/Container4UZDfIT/proxy-classes.php(204): Knp\Component\Pager\Paginator->paginate()
#13 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/CompoundSearchService.php(142): Container4UZDfIT\PaginatorProxy9cc2a8f->paginate()
#14 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/CompoundSearchService.php(121): Aqarmap\Bundle\SearchBundle\Services\CompoundSearchService->getResults()
#15 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/CompoundService.php(230): Aqarmap\Bundle\SearchBundle\Services\CompoundSearchService->getCompounds()
#16 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Controller/CompoundSearchController.php(29): Aqarmap\Bundle\ListingBundle\Service\CompoundService->search()
#17 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(181): Aqarmap\Bundle\ListingBundle\Controller\CompoundSearchController->compoundSearchResult()
#18 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#19 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#20 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#21 /srv/moonshot/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#22 /srv/moonshot/public/index.php(6): require_once('...')
#23 {main}

Symfony Profiler

GET https://testing-eg.am-root.com/en/compounds/el-hosary

Configuration Settings

Theme

Page Width

Query Metrics

Queries