Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

14.47 ms Execution Time

2.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

14.47 ms

2.00 ms

#▲	Execution Time	Query Time	Info
1	14.47 ms	2.00 ms	{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"section.id":{"value":1,"boost":1}}},{"bool":{"should":[{"terms":{"propertyType.id":[9]}}]}},{"bool":{}}],"must_not":[{"terms":{"category":[4]}}]}}]}},"sort":["_score"],"aggs":{"uniqueLocations":{"terms":{"field":"location.id"}}}} Path: aqarmap_eg_listings/listings/_search Query: Method: GET (http on elasticsearch-master.stack-services.svc.cluster.local:9200) Item count: 18 View formatted query View query backtrace `{ "query": { "bool": { "filter": [ { "bool": { "must": [ { "term": { "section.id": { "value": 1, "boost": 1 } } }, { "bool": { "should": [ { "terms": { "propertyType.id": [ 9 ] } } ] } }, { "bool": {} } ], "must_not": [ { "terms": { "category": [ 4 ] } } ] } } ] } }, "sort": [ "_score" ], "aggs": { "uniqueLocations": { "terms": { "field": "location.id" } } } }` #0 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery() #1 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Search.php(459): FOS\ElasticaBundle\Elastica\Client->request() #3 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Type.php(356): Elastica\Search->search() #4 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(107): Elastica\Type->search() #5 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(47): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations() #6 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/RelatedListingSearch.php(16): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations() #7 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/AbstractElasticListingSearch.php(124): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\RelatedListingSearch->getResults() #8 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/RelatedResultService.php(155): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\AbstractElasticListingSearch->search() #9 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/RelatedResultService.php(194): Aqarmap\Bundle\ListingBundle\Service\RelatedResultService->getNearestLocations() #10 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Controller/Api/V4/ListingSearchController.php(503): Aqarmap\Bundle\ListingBundle\Service\RelatedResultService->joinListingsWithPaginatedLocations() #11 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(163): Aqarmap\Bundle\SearchBundle\Controller\Api\V4\ListingSearchController->getRelatedSearchListings() #12 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #13 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle() #14 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #15 /srv/moonshot/vendor/autoload_runtime.php(35): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #16 /srv/moonshot/public/index.php(6): require_once('/srv/moonshot/v...') #17 {main}

{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"section.id":{"value":1,"boost":1}}},{"bool":{"should":[{"terms":{"propertyType.id":[9]}}]}},{"bool":{}}],"must_not":[{"terms":{"category":[4]}}]}}]}},"sort":["_score"],"aggs":{"uniqueLocations":{"terms":{"field":"location.id"}}}}

Path: aqarmap_eg_listings/listings/_search
Query:
Method: GET (http on elasticsearch-master.stack-services.svc.cluster.local:9200)
Item count: 18
View formatted query View query backtrace


                                                            {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "term": {
                                    "section.id": {
                                        "value": 1,
                                        "boost": 1
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "terms": {
                                                "propertyType.id": [
                                                    9
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {}
                            }
                        ],
                        "must_not": [
                            {
                                "terms": {
                                    "category": [
                                        4
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        "_score"
    ],
    "aggs": {
        "uniqueLocations": {
            "terms": {
                "field": "location.id"
            }
        }
    }
}

#0 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(145): FOS\ElasticaBundle\Logger\ElasticaLogger->logQuery()
#1 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Elastica/Client.php(72): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Search.php(459): FOS\ElasticaBundle\Elastica\Client->request()
#3 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Type.php(356): Elastica\Search->search()
#4 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Paginator/RawPaginatorAdapter.php(107): Elastica\Type->search()
#5 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Paginator/FantaPaginatorAdapter.php(47): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getAggregations()
#6 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/RelatedListingSearch.php(16): FOS\ElasticaBundle\Paginator\FantaPaginatorAdapter->getAggregations()
#7 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/AbstractElasticListingSearch.php(124): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\RelatedListingSearch->getResults()
#8 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/RelatedResultService.php(155): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\AbstractElasticListingSearch->search()
#9 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/RelatedResultService.php(194): Aqarmap\Bundle\ListingBundle\Service\RelatedResultService->getNearestLocations()
#10 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Controller/Api/V4/ListingSearchController.php(503): Aqarmap\Bundle\ListingBundle\Service\RelatedResultService->joinListingsWithPaginatedLocations()
#11 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(163): Aqarmap\Bundle\SearchBundle\Controller\Api\V4\ListingSearchController->getRelatedSearchListings()
#12 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#13 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#14 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#15 /srv/moonshot/vendor/autoload_runtime.php(35): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#16 /srv/moonshot/public/index.php(6): require_once('/srv/moonshot/v...')
#17 {main}

Symfony Profiler

http://moonshot.testing-eg.svc.cluster.local/api/v4/listings/search/related?esdebug=&limit=20&location=37&page=3&propertyType=9&section=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries