Symfony Profiler

Query Metrics

2 Database Queries

117.86 ms Execution Time

59.00 ms Query Time

Queries

#▲ Execution Time Query Time Info

54.56 ms

0.00 ms

#▲	Execution Time	Query Time	Info
1	54.56 ms	0.00 ms	{"update":{"_id":"642","_index":"aqarmap_eg_legacy_listings"}} {"doc":{"id":642,"title":"Explicabo reprehenderit vel est ut at.","description":"Aut aut quo libero minima ut. Repellendus dignissimos temporibus voluptatum eum repellat rerum. Laboriosam qui doloribus similique pariatur illum aut consectetur corporis. Eaque ut repellat asperiores optio.","address":"68391 Gleichner Branch Apt. 618\r\nBoyerton, NC 11632-6989","centerLat":23.52017,"centerLng":124.707295,"status":2,"compound_status":null,"attributesList":[],"sellerRole":1,"paymentMethod":null,"featured":7,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+03:00","price":225903,"area":370,"translations":[],"section":{"id":3,"title":"Projects"},"location":{"id":38,"title":"El-Sheikh Zayed"},"locations":[],"propertyType":{"id":4,"title":"Duplex with garden"},"compoundField":null,"photos":[],"qualityScore":0,"compoundLocation":null,"user":{"id":1,"fullName":"","groups":[{"id":1,"category":null},{"id":2,"category":null},{"id":3,"category":null},{"id":4,"category":null},{"id":8,"category":null},{"id":12,"category":null},{"id":13,"category":null}]},"pricePerMeter":610.54864864865,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"23.52017,124.707295","parent":null,"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":5.13,"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": "642", "_index": "aqarmap_eg_legacy_listings" } } { "doc": { "id": 642, "title": "Explicabo reprehenderit vel est ut at.", "description": "Aut aut quo libero minima ut. Repellendus dignissimos temporibus voluptatum eum repellat rerum. Laboriosam qui doloribus similique pariatur illum aut consectetur corporis. Eaque ut repellat asperiores optio.", "address": "68391 Gleichner Branch Apt. 618\r\nBoyerton, NC 11632-6989", "centerLat": 23.52017, "centerLng": 124.707295, "status": 2, "compound_status": null, "attributesList": [], "sellerRole": 1, "paymentMethod": null, "featured": 7, "propertyView": null, "source": null, "category": 3, "publishedAt": "2023-03-03T10:33:36+03:00", "price": 225903, "area": 370, "translations": [], "section": { "id": 3, "title": "Projects" }, "location": { "id": 38, "title": "El-Sheikh Zayed" }, "locations": [], "propertyType": { "id": 4, "title": "Duplex with garden" }, "compoundField": null, "photos": [], "qualityScore": 0, "compoundLocation": null, "user": { "id": 1, "fullName": "", "groups": [ { "id": 1, "category": null }, { "id": 2, "category": null }, { "id": 3, "category": null }, { "id": 4, "category": null }, { "id": 8, "category": null }, { "id": 12, "category": null }, { "id": 13, "category": null } ] }, "pricePerMeter": 610.54864864865, "childrenPropertyType": [], "compoundStatus": null, "priceLevel": null, "childrenArea": [], "childrenPrice": [], "childrenPricePerMeter": [], "childrenAttributesList": [], "geoPoint": "23.52017,124.707295", "parent": null, "isMortgage": false, "isTopPicks": false, "eligibleForMortgage": null, "marketPropertyType": null, "computedContactRate": 5.13, "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(2881): 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	63.30 ms	59.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: 121 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/ContainerXLUhb7G/proxy-classes.php(204): Knp\Component\Pager\Paginator->paginate() #13 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/DefaultListingSearch.php(24): ContainerXLUhb7G\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":"642","_index":"aqarmap_eg_legacy_listings"}}

{"doc":{"id":642,"title":"Explicabo reprehenderit vel est ut at.","description":"Aut aut quo libero minima ut. Repellendus dignissimos temporibus voluptatum eum repellat rerum. Laboriosam qui doloribus similique pariatur illum aut consectetur corporis. Eaque ut repellat asperiores optio.","address":"68391 Gleichner Branch Apt. 618\r\nBoyerton, NC 11632-6989","centerLat":23.52017,"centerLng":124.707295,"status":2,"compound_status":null,"attributesList":[],"sellerRole":1,"paymentMethod":null,"featured":7,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+03:00","price":225903,"area":370,"translations":[],"section":{"id":3,"title":"Projects"},"location":{"id":38,"title":"El-Sheikh Zayed"},"locations":[],"propertyType":{"id":4,"title":"Duplex with garden"},"compoundField":null,"photos":[],"qualityScore":0,"compoundLocation":null,"user":{"id":1,"fullName":"","groups":[{"id":1,"category":null},{"id":2,"category":null},{"id":3,"category":null},{"id":4,"category":null},{"id":8,"category":null},{"id":12,"category":null},{"id":13,"category":null}]},"pricePerMeter":610.54864864865,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"23.52017,124.707295","parent":null,"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":5.13,"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": "642",
        "_index": "aqarmap_eg_legacy_listings"
    }
}
                                                            {
    "doc": {
        "id": 642,
        "title": "Explicabo reprehenderit vel est ut at.",
        "description": "Aut aut quo libero minima ut. Repellendus dignissimos temporibus voluptatum eum repellat rerum. Laboriosam qui doloribus similique pariatur illum aut consectetur corporis. Eaque ut repellat asperiores optio.",
        "address": "68391 Gleichner Branch Apt. 618\r\nBoyerton, NC 11632-6989",
        "centerLat": 23.52017,
        "centerLng": 124.707295,
        "status": 2,
        "compound_status": null,
        "attributesList": [],
        "sellerRole": 1,
        "paymentMethod": null,
        "featured": 7,
        "propertyView": null,
        "source": null,
        "category": 3,
        "publishedAt": "2023-03-03T10:33:36+03:00",
        "price": 225903,
        "area": 370,
        "translations": [],
        "section": {
            "id": 3,
            "title": "Projects"
        },
        "location": {
            "id": 38,
            "title": "El-Sheikh Zayed"
        },
        "locations": [],
        "propertyType": {
            "id": 4,
            "title": "Duplex with garden"
        },
        "compoundField": null,
        "photos": [],
        "qualityScore": 0,
        "compoundLocation": null,
        "user": {
            "id": 1,
            "fullName": "",
            "groups": [
                {
                    "id": 1,
                    "category": null
                },
                {
                    "id": 2,
                    "category": null
                },
                {
                    "id": 3,
                    "category": null
                },
                {
                    "id": 4,
                    "category": null
                },
                {
                    "id": 8,
                    "category": null
                },
                {
                    "id": 12,
                    "category": null
                },
                {
                    "id": 13,
                    "category": null
                }
            ]
        },
        "pricePerMeter": 610.54864864865,
        "childrenPropertyType": [],
        "compoundStatus": null,
        "priceLevel": null,
        "childrenArea": [],
        "childrenPrice": [],
        "childrenPricePerMeter": [],
        "childrenAttributesList": [],
        "geoPoint": "23.52017,124.707295",
        "parent": null,
        "isMortgage": false,
        "isTopPicks": false,
        "eligibleForMortgage": null,
        "marketPropertyType": null,
        "computedContactRate": 5.13,
        "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(2881): 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}

63.30 ms

59.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: 121
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/ContainerXLUhb7G/proxy-classes.php(204): Knp\Component\Pager\Paginator->paginate()
#13 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/DefaultListingSearch.php(24): ContainerXLUhb7G\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/642-projects-el-sheikh-zayed

Configuration Settings

Theme

Page Width

Query Metrics

Queries