Symfony Profiler

Query Metrics

2 Database Queries

79.86 ms Execution Time

1.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

69.54 ms

0.00 ms

#▲	Execution Time	Query Time	Info
1	69.54 ms	0.00 ms	{"update":{"_id":"431","_index":"aqarmap_eg_legacy_listings"}} {"doc":{"id":431,"title":"Aut in nihil sint quas a officia.","description":"Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.","address":"89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930","centerLat":44.26794,"centerLng":55.44131,"status":2,"compound_status":null,"attributesList":[],"sellerRole":3,"paymentMethod":null,"featured":0,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":2467740,"area":210,"translations":[{"content":"Aut in nihil sint quas a officia.","field":"title"},{"content":"Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.","field":"description"},{"content":"89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930","field":"address"}],"section":{"id":3,"title":"Projects"},"location":{"id":40,"title":"Miami"},"locations":[],"propertyType":{"id":13,"title":"Mall"},"compoundField":null,"photos":[],"qualityScore":0,"compoundLocation":null,"user":{"id":5,"fullName":"Hazle","groups":[]},"pricePerMeter":11751.142857143,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"44.26794,55.44131","parent":null,"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":3.03,"label":null,"isMortgageApproved":null},"doc_as_upsert":true} Path: _bulk Query: Method: POST (http on elasticsearch-master.elasticsearch-8.svc.cluster.local:9200) Item count: 0 View formatted query View query backtrace { "update": { "_id": "431", "_index": "aqarmap_eg_legacy_listings" } } { "doc": { "id": 431, "title": "Aut in nihil sint quas a officia.", "description": "Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.", "address": "89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930", "centerLat": 44.26794, "centerLng": 55.44131, "status": 2, "compound_status": null, "attributesList": [], "sellerRole": 3, "paymentMethod": null, "featured": 0, "propertyView": null, "source": null, "category": 3, "publishedAt": "2023-03-03T10:33:36+02:00", "price": 2467740, "area": 210, "translations": [ { "content": "Aut in nihil sint quas a officia.", "field": "title" }, { "content": "Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.", "field": "description" }, { "content": "89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930", "field": "address" } ], "section": { "id": 3, "title": "Projects" }, "location": { "id": 40, "title": "Miami" }, "locations": [], "propertyType": { "id": 13, "title": "Mall" }, "compoundField": null, "photos": [], "qualityScore": 0, "compoundLocation": null, "user": { "id": 5, "fullName": "Hazle", "groups": [] }, "pricePerMeter": 11751.142857143, "childrenPropertyType": [], "compoundStatus": null, "priceLevel": null, "childrenArea": [], "childrenPrice": [], "childrenPricePerMeter": [], "childrenAttributesList": [], "geoPoint": "44.26794,55.44131", "parent": null, "isMortgage": false, "isTopPicks": false, "eligibleForMortgage": null, "marketPropertyType": null, "computedContactRate": 3.03, "label": null, "isMortgageApproved": null }, "doc_as_upsert": true } #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(103): FOS\ElasticaBundle\Elastica\Client->logQuery() #2 /srv/moonshot/vendor/ruflin/elastica/src/Bulk.php(306): FOS\ElasticaBundle\Elastica\Client->request() #3 /srv/moonshot/vendor/ruflin/elastica/src/Client.php(230): Elastica\Bulk->send() #4 /srv/moonshot/vendor/ruflin/elastica/src/Index.php(175): Elastica\Client->updateDocuments() #5 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Persister/ObjectPersister.php(134): Elastica\Index->updateDocuments() #6 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(180): FOS\ElasticaBundle\Persister\ObjectPersister->replaceMany() #7 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(155): FOS\ElasticaBundle\Doctrine\Listener->persistScheduled() #8 /srv/moonshot/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php(63): FOS\ElasticaBundle\Doctrine\Listener->postFlush() #9 /srv/moonshot/vendor/doctrine/orm/src/UnitOfWork.php(3821): Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent() #10 /srv/moonshot/vendor/doctrine/orm/src/UnitOfWork.php(510): Doctrine\ORM\UnitOfWork->dispatchPostFlushEvent() #11 /srv/moonshot/vendor/doctrine/orm/src/EntityManager.php(414): Doctrine\ORM\UnitOfWork->commit() #12 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/ListingManager.php(2888): Doctrine\ORM\EntityManager->flush() #13 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/InteractionService.php(108): Aqarmap\Bundle\ListingBundle\Service\ListingManager->incrementViewsCounters() #14 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/InteractionService.php(150): Aqarmap\Bundle\ListingBundle\Service\InteractionService->addInteraction() #15 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Controller/ListingController.php(219): Aqarmap\Bundle\ListingBundle\Service\InteractionService->increaseViews() #16 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(181): Aqarmap\Bundle\ListingBundle\Controller\ListingController->read() #17 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #18 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #19 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #20 /srv/moonshot/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #21 /srv/moonshot/public/index.php(6): require_once('...') #22 {main}
2	10.32 ms	1.00 ms	{"from":0,"size":5,"query":{"match_all":{}}} Path: aqarmap_eg_legacy_listings/_search Query: Method: POST (http on elasticsearch-master.elasticsearch-8.svc.cluster.local:9200) Item count: 313 View formatted query View query backtrace `{ "from": 0, "size": 5, "query": { "match_all": {} } }` #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/HybridPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults() #6 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(40): FOS\ElasticaBundle\Paginator\HybridPaginatorAdapter->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/ElasticListingSearch/DefaultListingSearch.php(24): Container4UZDfIT\PaginatorProxy9cc2a8f->paginate() #14 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/AbstractElasticListingSearch.php(109): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\DefaultListingSearch->getResults() #15 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Controller/ListingController.php(223): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\AbstractElasticListingSearch->search() #16 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(181): Aqarmap\Bundle\ListingBundle\Controller\ListingController->read() #17 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #18 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle() #19 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle() #20 /srv/moonshot/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run() #21 /srv/moonshot/public/index.php(6): require_once('...') #22 {main}

{"update":{"_id":"431","_index":"aqarmap_eg_legacy_listings"}}

{"doc":{"id":431,"title":"Aut in nihil sint quas a officia.","description":"Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.","address":"89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930","centerLat":44.26794,"centerLng":55.44131,"status":2,"compound_status":null,"attributesList":[],"sellerRole":3,"paymentMethod":null,"featured":0,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":2467740,"area":210,"translations":[{"content":"Aut in nihil sint quas a officia.","field":"title"},{"content":"Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.","field":"description"},{"content":"89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930","field":"address"}],"section":{"id":3,"title":"Projects"},"location":{"id":40,"title":"Miami"},"locations":[],"propertyType":{"id":13,"title":"Mall"},"compoundField":null,"photos":[],"qualityScore":0,"compoundLocation":null,"user":{"id":5,"fullName":"Hazle","groups":[]},"pricePerMeter":11751.142857143,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"44.26794,55.44131","parent":null,"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":3.03,"label":null,"isMortgageApproved":null},"doc_as_upsert":true}

Path: _bulk
Query:
Method: POST (http on elasticsearch-master.elasticsearch-8.svc.cluster.local:9200)
Item count: 0
View formatted query View query backtrace


                                                            {
    "update": {
        "_id": "431",
        "_index": "aqarmap_eg_legacy_listings"
    }
}
                                                            {
    "doc": {
        "id": 431,
        "title": "Aut in nihil sint quas a officia.",
        "description": "Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.",
        "address": "89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930",
        "centerLat": 44.26794,
        "centerLng": 55.44131,
        "status": 2,
        "compound_status": null,
        "attributesList": [],
        "sellerRole": 3,
        "paymentMethod": null,
        "featured": 0,
        "propertyView": null,
        "source": null,
        "category": 3,
        "publishedAt": "2023-03-03T10:33:36+02:00",
        "price": 2467740,
        "area": 210,
        "translations": [
            {
                "content": "Aut in nihil sint quas a officia.",
                "field": "title"
            },
            {
                "content": "Quia culpa rerum eum natus. Consequuntur dolorum est sit sunt illum quia. Reprehenderit excepturi quia praesentium architecto id. Qui alias est omnis accusamus expedita.",
                "field": "description"
            },
            {
                "content": "89011 Stroman Camp Apt. 156\nPfefferberg, UT 39930",
                "field": "address"
            }
        ],
        "section": {
            "id": 3,
            "title": "Projects"
        },
        "location": {
            "id": 40,
            "title": "Miami"
        },
        "locations": [],
        "propertyType": {
            "id": 13,
            "title": "Mall"
        },
        "compoundField": null,
        "photos": [],
        "qualityScore": 0,
        "compoundLocation": null,
        "user": {
            "id": 5,
            "fullName": "Hazle",
            "groups": []
        },
        "pricePerMeter": 11751.142857143,
        "childrenPropertyType": [],
        "compoundStatus": null,
        "priceLevel": null,
        "childrenArea": [],
        "childrenPrice": [],
        "childrenPricePerMeter": [],
        "childrenAttributesList": [],
        "geoPoint": "44.26794,55.44131",
        "parent": null,
        "isMortgage": false,
        "isTopPicks": false,
        "eligibleForMortgage": null,
        "marketPropertyType": null,
        "computedContactRate": 3.03,
        "label": null,
        "isMortgageApproved": null
    },
    "doc_as_upsert": true
}

#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(103): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /srv/moonshot/vendor/ruflin/elastica/src/Bulk.php(306): FOS\ElasticaBundle\Elastica\Client->request()
#3 /srv/moonshot/vendor/ruflin/elastica/src/Client.php(230): Elastica\Bulk->send()
#4 /srv/moonshot/vendor/ruflin/elastica/src/Index.php(175): Elastica\Client->updateDocuments()
#5 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Persister/ObjectPersister.php(134): Elastica\Index->updateDocuments()
#6 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(180): FOS\ElasticaBundle\Persister\ObjectPersister->replaceMany()
#7 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(155): FOS\ElasticaBundle\Doctrine\Listener->persistScheduled()
#8 /srv/moonshot/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php(63): FOS\ElasticaBundle\Doctrine\Listener->postFlush()
#9 /srv/moonshot/vendor/doctrine/orm/src/UnitOfWork.php(3821): Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent()
#10 /srv/moonshot/vendor/doctrine/orm/src/UnitOfWork.php(510): Doctrine\ORM\UnitOfWork->dispatchPostFlushEvent()
#11 /srv/moonshot/vendor/doctrine/orm/src/EntityManager.php(414): Doctrine\ORM\UnitOfWork->commit()
#12 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/ListingManager.php(2888): Doctrine\ORM\EntityManager->flush()
#13 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/InteractionService.php(108): Aqarmap\Bundle\ListingBundle\Service\ListingManager->incrementViewsCounters()
#14 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/InteractionService.php(150): Aqarmap\Bundle\ListingBundle\Service\InteractionService->addInteraction()
#15 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Controller/ListingController.php(219): Aqarmap\Bundle\ListingBundle\Service\InteractionService->increaseViews()
#16 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(181): Aqarmap\Bundle\ListingBundle\Controller\ListingController->read()
#17 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#18 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#19 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#20 /srv/moonshot/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#21 /srv/moonshot/public/index.php(6): require_once('...')
#22 {main}

10.32 ms

1.00 ms

{"from":0,"size":5,"query":{"match_all":{}}}

Path: aqarmap_eg_legacy_listings/_search
Query:
Method: POST (http on elasticsearch-master.elasticsearch-8.svc.cluster.local:9200)
Item count: 313
View formatted query View query backtrace


                                                            {
    "from": 0,
    "size": 5,
    "query": {
        "match_all": {}
    }
}

#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/HybridPaginatorAdapter.php(39): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(40): FOS\ElasticaBundle\Paginator\HybridPaginatorAdapter->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/ElasticListingSearch/DefaultListingSearch.php(24): Container4UZDfIT\PaginatorProxy9cc2a8f->paginate()
#14 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/AbstractElasticListingSearch.php(109): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\DefaultListingSearch->getResults()
#15 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Controller/ListingController.php(223): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\AbstractElasticListingSearch->search()
#16 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(181): Aqarmap\Bundle\ListingBundle\Controller\ListingController->read()
#17 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#18 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#19 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#20 /srv/moonshot/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#21 /srv/moonshot/public/index.php(6): require_once('...')
#22 {main}

Symfony Profiler

GET https://testing-eg.am-root.com/en/listing/431-projects-hyper-one

Configuration Settings

Theme

Page Width

Query Metrics

Queries