Symfony Profiler

Query Metrics

2 Database Queries

17.80 ms Execution Time

1.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

12.89 ms

0.00 ms

#▲	Execution Time	Query Time	Info
1	12.89 ms	0.00 ms	{"update":{"_id":"437","_index":"aqarmap_eg_legacy_listings"}} {"doc":{"id":437,"title":"Fugit voluptate et nihil quod reprehenderit vel atque error.","description":"Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.","address":"589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048","centerLat":-15.938202,"centerLng":-71.142063,"status":2,"compound_status":null,"attributesList":[],"sellerRole":0,"paymentMethod":null,"featured":3,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":3910513,"area":480,"translations":[{"content":"Fugit voluptate et nihil quod reprehenderit vel atque error.","field":"title"},{"content":"Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.","field":"description"},{"content":"589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048","field":"address"}],"section":{"id":3,"title":"Projects"},"location":{"id":39,"title":"San Stefano"},"locations":[],"propertyType":{"id":11,"title":"Chalet"},"compoundField":null,"photos":[],"qualityScore":0,"compoundLocation":null,"user":{"id":11,"fullName":"Steve","groups":[]},"pricePerMeter":8146.9020833333,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"-15.938202,-71.142063","parent":null,"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":0,"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": "437", "_index": "aqarmap_eg_legacy_listings" } } { "doc": { "id": 437, "title": "Fugit voluptate et nihil quod reprehenderit vel atque error.", "description": "Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.", "address": "589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048", "centerLat": -15.938202, "centerLng": -71.142063, "status": 2, "compound_status": null, "attributesList": [], "sellerRole": 0, "paymentMethod": null, "featured": 3, "propertyView": null, "source": null, "category": 3, "publishedAt": "2023-03-03T10:33:36+02:00", "price": 3910513, "area": 480, "translations": [ { "content": "Fugit voluptate et nihil quod reprehenderit vel atque error.", "field": "title" }, { "content": "Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.", "field": "description" }, { "content": "589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048", "field": "address" } ], "section": { "id": 3, "title": "Projects" }, "location": { "id": 39, "title": "San Stefano" }, "locations": [], "propertyType": { "id": 11, "title": "Chalet" }, "compoundField": null, "photos": [], "qualityScore": 0, "compoundLocation": null, "user": { "id": 11, "fullName": "Steve", "groups": [] }, "pricePerMeter": 8146.9020833333, "childrenPropertyType": [], "compoundStatus": null, "priceLevel": null, "childrenArea": [], "childrenPrice": [], "childrenPricePerMeter": [], "childrenAttributesList": [], "geoPoint": "-15.938202,-71.142063", "parent": null, "isMortgage": false, "isTopPicks": false, "eligibleForMortgage": null, "marketPropertyType": null, "computedContactRate": 0, "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	4.91 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: 314 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":"437","_index":"aqarmap_eg_legacy_listings"}}

{"doc":{"id":437,"title":"Fugit voluptate et nihil quod reprehenderit vel atque error.","description":"Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.","address":"589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048","centerLat":-15.938202,"centerLng":-71.142063,"status":2,"compound_status":null,"attributesList":[],"sellerRole":0,"paymentMethod":null,"featured":3,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":3910513,"area":480,"translations":[{"content":"Fugit voluptate et nihil quod reprehenderit vel atque error.","field":"title"},{"content":"Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.","field":"description"},{"content":"589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048","field":"address"}],"section":{"id":3,"title":"Projects"},"location":{"id":39,"title":"San Stefano"},"locations":[],"propertyType":{"id":11,"title":"Chalet"},"compoundField":null,"photos":[],"qualityScore":0,"compoundLocation":null,"user":{"id":11,"fullName":"Steve","groups":[]},"pricePerMeter":8146.9020833333,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"-15.938202,-71.142063","parent":null,"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":0,"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": "437",
        "_index": "aqarmap_eg_legacy_listings"
    }
}
                                                            {
    "doc": {
        "id": 437,
        "title": "Fugit voluptate et nihil quod reprehenderit vel atque error.",
        "description": "Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.",
        "address": "589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048",
        "centerLat": -15.938202,
        "centerLng": -71.142063,
        "status": 2,
        "compound_status": null,
        "attributesList": [],
        "sellerRole": 0,
        "paymentMethod": null,
        "featured": 3,
        "propertyView": null,
        "source": null,
        "category": 3,
        "publishedAt": "2023-03-03T10:33:36+02:00",
        "price": 3910513,
        "area": 480,
        "translations": [
            {
                "content": "Fugit voluptate et nihil quod reprehenderit vel atque error.",
                "field": "title"
            },
            {
                "content": "Debitis quam harum odit et et aut qui. Expedita quos id tenetur optio nesciunt ratione.",
                "field": "description"
            },
            {
                "content": "589 Streich Ridges Suite 406\nNew Ashleyville, UT 30048",
                "field": "address"
            }
        ],
        "section": {
            "id": 3,
            "title": "Projects"
        },
        "location": {
            "id": 39,
            "title": "San Stefano"
        },
        "locations": [],
        "propertyType": {
            "id": 11,
            "title": "Chalet"
        },
        "compoundField": null,
        "photos": [],
        "qualityScore": 0,
        "compoundLocation": null,
        "user": {
            "id": 11,
            "fullName": "Steve",
            "groups": []
        },
        "pricePerMeter": 8146.9020833333,
        "childrenPropertyType": [],
        "compoundStatus": null,
        "priceLevel": null,
        "childrenArea": [],
        "childrenPrice": [],
        "childrenPricePerMeter": [],
        "childrenAttributesList": [],
        "geoPoint": "-15.938202,-71.142063",
        "parent": null,
        "isMortgage": false,
        "isTopPicks": false,
        "eligibleForMortgage": null,
        "marketPropertyType": null,
        "computedContactRate": 0,
        "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}

4.91 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: 314
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/437-projects-el-hosary

Configuration Settings

Theme

Page Width

Query Metrics

Queries