| 1 |
85.05 ms |
0.00 ms |
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":84}}
{"doc":{"id":84,"title":"Ea consequatur quia sint est.","description":"Dignissimos iure in nobis sequi minima optio quisquam necessitatibus. Aut laborum quas non iste ut voluptatibus. Asperiores velit voluptate voluptatum est nemo dolorem.","address":"14000 Ebert Crossroad Suite 188\nWest Colby, MO 18387-0752","centerLat":-42.167018,"centerLng":81.648338,"status":2,"compound_status":10,"attributesList":{"floor":"9","rooms":"5","baths":"1","finish-type":"WITHOUT_FINISH","year-built":"2044","land-area":"200"},"sellerRole":1,"paymentMethod":2,"featured":3,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":1000000,"area":10,"translations":[{"content":"Ea consequatur quia sint est.","field":"title"},{"content":"Dignissimos iure in nobis sequi minima optio quisquam necessitatibus. Aut laborum quas non iste ut voluptatibus. Asperiores velit voluptate voluptatum est nemo dolorem.","field":"description"},{"content":"14000 Ebert Crossroad Suite 188\nWest Colby, MO 18387-0752","field":"address"}],"section":{"id":3,"title":"Projects"},"location":{"id":38,"title":"El-Sheikh Zayed"},"locations":[],"propertyType":{"id":6,"title":"Villa"},"compoundField":{"minPrice":null,"numberOfProjectsDelivered":1,"numberOfProjectsInhabited":1},"photos":[],"qualityScore":0,"compoundLocation":{"id":11,"title":"Smouha","coordinates":null,"location":[]},"user":{"id":1,"fullName":"admin","groups":[{"id":1,"category":null},{"id":2,"category":null},{"id":3,"category":null},{"id":4,"category":null},{"id":12,"category":null},{"id":13,"category":null}]},"pricePerMeter":100000,"childrenPropertyType":{"id":6},"compoundStatus":10,"priceLevel":0,"childrenArea":{"area":260},"childrenPrice":{"price":2781812},"childrenPricePerMeter":{"pricePerMeter":10699},"childrenAttributesList":{"floor":"2","rooms":"10","baths":"5","finish-type":"LUX"},"geoPoint":"-42.167018,81.648338","parent":[],"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":3.7,"label":null,"isMortgageApproved":null},"doc_as_upsert":true}
Path: _bulk
Query:
Method: POST (http on elasticsearch-master.stack-services.svc.cluster.local:9200)
Item count: 0
View formatted query
View query backtrace
{
"update": {
"_index": "aqarmap_eg_listings",
"_type": "listings",
"_id": 84
}
}
{
"doc": {
"id": 84,
"title": "Ea consequatur quia sint est.",
"description": "Dignissimos iure in nobis sequi minima optio quisquam necessitatibus. Aut laborum quas non iste ut voluptatibus. Asperiores velit voluptate voluptatum est nemo dolorem.",
"address": "14000 Ebert Crossroad Suite 188\nWest Colby, MO 18387-0752",
"centerLat": -42.167018,
"centerLng": 81.648338,
"status": 2,
"compound_status": 10,
"attributesList": {
"floor": "9",
"rooms": "5",
"baths": "1",
"finish-type": "WITHOUT_FINISH",
"year-built": "2044",
"land-area": "200"
},
"sellerRole": 1,
"paymentMethod": 2,
"featured": 3,
"propertyView": null,
"source": null,
"category": 3,
"publishedAt": "2023-03-03T10:33:36+02:00",
"price": 1000000,
"area": 10,
"translations": [
{
"content": "Ea consequatur quia sint est.",
"field": "title"
},
{
"content": "Dignissimos iure in nobis sequi minima optio quisquam necessitatibus. Aut laborum quas non iste ut voluptatibus. Asperiores velit voluptate voluptatum est nemo dolorem.",
"field": "description"
},
{
"content": "14000 Ebert Crossroad Suite 188\nWest Colby, MO 18387-0752",
"field": "address"
}
],
"section": {
"id": 3,
"title": "Projects"
},
"location": {
"id": 38,
"title": "El-Sheikh Zayed"
},
"locations": [],
"propertyType": {
"id": 6,
"title": "Villa"
},
"compoundField": {
"minPrice": null,
"numberOfProjectsDelivered": 1,
"numberOfProjectsInhabited": 1
},
"photos": [],
"qualityScore": 0,
"compoundLocation": {
"id": 11,
"title": "Smouha",
"coordinates": null,
"location": []
},
"user": {
"id": 1,
"fullName": "admin",
"groups": [
{
"id": 1,
"category": null
},
{
"id": 2,
"category": null
},
{
"id": 3,
"category": null
},
{
"id": 4,
"category": null
},
{
"id": 12,
"category": null
},
{
"id": 13,
"category": null
}
]
},
"pricePerMeter": 100000,
"childrenPropertyType": {
"id": 6
},
"compoundStatus": 10,
"priceLevel": 0,
"childrenArea": {
"area": 260
},
"childrenPrice": {
"price": 2781812
},
"childrenPricePerMeter": {
"pricePerMeter": 10699
},
"childrenAttributesList": {
"floor": "2",
"rooms": "10",
"baths": "5",
"finish-type": "LUX"
},
"geoPoint": "-42.167018,81.648338",
"parent": [],
"isMortgage": false,
"isTopPicks": false,
"eligibleForMortgage": null,
"marketPropertyType": null,
"computedContactRate": 3.7,
"label": null,
"isMortgageApproved": null
},
"doc_as_upsert": true
}
#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(74): FOS\ElasticaBundle\Elastica\Client->logQuery()
#2 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Bulk.php(357): FOS\ElasticaBundle\Elastica\Client->request()
#3 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Client.php(324): Elastica\Bulk->send()
#4 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Index.php(133): Elastica\Client->updateDocuments()
#5 /srv/moonshot/vendor/ruflin/elastica/lib/Elastica/Type.php(181): Elastica\Index->updateDocuments()
#6 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Persister/ObjectPersister.php(127): Elastica\Type->updateDocuments()
#7 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(208): FOS\ElasticaBundle\Persister\ObjectPersister->replaceMany()
#8 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Doctrine/Listener.php(183): FOS\ElasticaBundle\Doctrine\Listener->persistScheduled()
#9 /srv/moonshot/vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php(69): FOS\ElasticaBundle\Doctrine\Listener->postFlush()
#10 /srv/moonshot/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(3514): Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent()
#11 /srv/moonshot/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(483): Doctrine\ORM\UnitOfWork->dispatchPostFlushEvent()
#12 /srv/moonshot/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(403): Doctrine\ORM\UnitOfWork->commit()
#13 /srv/moonshot/var/cache/dev/ContainerKiy3iqT/proxy-classes.php(137): Doctrine\ORM\EntityManager->flush()
#14 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/ListingManager.php(2840): ContainerKiy3iqT\EntityManager_9a5be93->flush()
#15 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/InteractionService.php(117): Aqarmap\Bundle\ListingBundle\Service\ListingManager->incrementViewsCounters()
#16 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/InteractionService.php(153): Aqarmap\Bundle\ListingBundle\Service\InteractionService->addInteraction()
#17 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Controller/ListingController.php(448): Aqarmap\Bundle\ListingBundle\Service\InteractionService->increaseViews()
#18 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(163): Aqarmap\Bundle\ListingBundle\Controller\ListingController->read()
#19 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#20 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(202): Symfony\Component\HttpKernel\HttpKernel->handle()
#21 /srv/moonshot/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()
#22 /srv/moonshot/vendor/autoload_runtime.php(35): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#23 /srv/moonshot/public/index.php(6): require_once('/srv/moonshot/v...')
#24 {main}
|
| 2 |
20.47 ms |
14.00 ms |
{"query":{"function_score":{"score_mode":"sum","boost_mode":"sum","query":{"bool":{"filter":[{"bool":{"must":[{"term":{"status":{"value":2,"boost":1}}},{"range":{"price":{"from":966666.6666666666,"to":1033333.3333333334}}},{"bool":{"should":[{"terms":{"location.id":[38,80,81,40,543,549,554,556]}},{"terms":{"locations.id":[38,80,81,40,543,549,554,556]}}]}}],"must_not":[{"terms":{"id":[84]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2025-04-02T16:50:18+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-03-03T16:50:18+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-02-26T16:50:18+02:00","scale":"5d","offset":"0","decay":0.5}},"weight":"50"},{"weight":-25,"filter":{"bool":{"must_not":[{"exists":{"field":"publishedAt"}}]}}},{"weight":"-50","filter":{"range":{"aggregatedLeadsCount":{"gte":"1","lte":"2"}}}},{"weight":"-100","filter":{"range":{"aggregatedLeadsCount":{"gte":"3","lte":"5"}}}},{"weight":"-125","filter":{"range":{"aggregatedLeadsCount":{"gte":"6","lte":"16"}}}},{"weight":"-150","filter":{"range":{"aggregatedLeadsCount":{"gte":"17","lte":"30"}}}},{"weight":"-175","filter":{"range":{"aggregatedLeadsCount":{"gte":"31","lte":"100"}}}},{"weight":"-500","filter":{"range":{"aggregatedLeadsCount":{"gte":"101","lte":"200"}}}},{"weight":"-500","filter":{"range":{"aggregatedLeadsCount":{"gte":"201","lte":"300"}}}},{"weight":"-500","filter":{"range":{"aggregatedLeadsCount":{"gte":"301","lte":"400"}}}},{"weight":"-500","filter":{"range":{"aggregatedLeadsCount":{"gte":"401","lte":"500"}}}},{"weight":"-500","filter":{"range":{"aggregatedLeadsCount":{"gte":"501","lte":"1000000"}}}},{"weight":"170","filter":{"term":{"featured":{"value":3,"boost":1}}}},{"weight":"485","filter":{"term":{"featured":{"value":7,"boost":1}}}},{"weight":"485","filter":{"term":{"featured":{"value":10,"boost":1}}}},{"weight":"300","filter":{"term":{"featured":{"value":8,"boost":1}}}},{"weight":"50","filter":{"term":{"featured":{"value":9,"boost":1}}}},{"weight":"60","filter":{"term":{"featured":{"value":1,"boost":1}}}},{"weight":"0","filter":{"term":{"featured":{"value":2,"boost":1}}}},{"weight":"-140","filter":{"term":{"category":{"value":4,"boost":1}}}},{"weight":"-140","filter":{"term":{"category":{"value":6,"boost":1}}}},{"weight":"-140","filter":{"term":{"category":{"value":7,"boost":1}}}},{"weight":"-75","filter":{"term":{"qualityScore":{"value":0,"boost":1}}}},{"weight":"-8","filter":{"range":{"qualityScore":{"gte":"1","lte":"1"}}}},{"weight":"0","filter":{"range":{"qualityScore":{"gte":"2","lte":"6"}}}},{"weight":"5","filter":{"range":{"qualityScore":{"gte":"7","lte":"11"}}}},{"weight":"8","filter":{"range":{"qualityScore":{"gte":"12"}}}},{"weight":-45,"filter":{"term":{"user.groups.category":{"value":-3,"boost":1}}}},{"weight":-30,"filter":{"term":{"user.groups.category":{"value":-2,"boost":1}}}},{"weight":-15,"filter":{"term":{"user.groups.category":{"value":-1,"boost":1}}}},{"weight":15,"filter":{"term":{"user.groups.category":{"value":1,"boost":1}}}},{"weight":30,"filter":{"term":{"user.groups.category":{"value":2,"boost":1}}}},{"weight":45,"filter":{"term":{"user.groups.category":{"value":3,"boost":1}}}},{"weight":60,"filter":{"term":{"user.groups.category":{"value":4,"boost":1}}}},{"weight":75,"filter":{"term":{"user.groups.category":{"value":5,"boost":1}}}},{"weight":525,"filter":{"term":{"user.groups.category":{"value":35,"boost":1}}}}]}},"sort":["_score"],"explain":true,"from":0,"size":5}
Path: aqarmap_eg_listings/listings/_search
Query:
Method: GET (http on elasticsearch-master.stack-services.svc.cluster.local:9200)
Item count: 1
View formatted query
View query backtrace
{
"query": {
"function_score": {
"score_mode": "sum",
"boost_mode": "sum",
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"term": {
"status": {
"value": 2,
"boost": 1
}
}
},
{
"range": {
"price": {
"from": 966666.6666666666,
"to": 1033333.3333333334
}
}
},
{
"bool": {
"should": [
{
"terms": {
"location.id": [
38,
80,
81,
40,
543,
549,
554,
556
]
}
},
{
"terms": {
"locations.id": [
38,
80,
81,
40,
543,
549,
554,
556
]
}
}
]
}
}
],
"must_not": [
{
"terms": {
"id": [
84
]
}
},
{
"terms": {
"category": [
4
]
}
}
]
}
}
]
}
},
"functions": [
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2025-04-02T16:50:18+02:00",
"scale": "180d",
"offset": "0",
"decay": 0.5
}
},
"weight": "25"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2025-03-03T16:50:18+02:00",
"scale": "30d",
"offset": "0",
"decay": 0.5
}
},
"weight": "50"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2025-02-26T16:50:18+02:00",
"scale": "5d",
"offset": "0",
"decay": 0.5
}
},
"weight": "50"
},
{
"weight": -25,
"filter": {
"bool": {
"must_not": [
{
"exists": {
"field": "publishedAt"
}
}
]
}
}
},
{
"weight": "-50",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "1",
"lte": "2"
}
}
}
},
{
"weight": "-100",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "3",
"lte": "5"
}
}
}
},
{
"weight": "-125",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "6",
"lte": "16"
}
}
}
},
{
"weight": "-150",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "17",
"lte": "30"
}
}
}
},
{
"weight": "-175",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "31",
"lte": "100"
}
}
}
},
{
"weight": "-500",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "101",
"lte": "200"
}
}
}
},
{
"weight": "-500",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "201",
"lte": "300"
}
}
}
},
{
"weight": "-500",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "301",
"lte": "400"
}
}
}
},
{
"weight": "-500",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "401",
"lte": "500"
}
}
}
},
{
"weight": "-500",
"filter": {
"range": {
"aggregatedLeadsCount": {
"gte": "501",
"lte": "1000000"
}
}
}
},
{
"weight": "170",
"filter": {
"term": {
"featured": {
"value": 3,
"boost": 1
}
}
}
},
{
"weight": "485",
"filter": {
"term": {
"featured": {
"value": 7,
"boost": 1
}
}
}
},
{
"weight": "485",
"filter": {
"term": {
"featured": {
"value": 10,
"boost": 1
}
}
}
},
{
"weight": "300",
"filter": {
"term": {
"featured": {
"value": 8,
"boost": 1
}
}
}
},
{
"weight": "50",
"filter": {
"term": {
"featured": {
"value": 9,
"boost": 1
}
}
}
},
{
"weight": "60",
"filter": {
"term": {
"featured": {
"value": 1,
"boost": 1
}
}
}
},
{
"weight": "0",
"filter": {
"term": {
"featured": {
"value": 2,
"boost": 1
}
}
}
},
{
"weight": "-140",
"filter": {
"term": {
"category": {
"value": 4,
"boost": 1
}
}
}
},
{
"weight": "-140",
"filter": {
"term": {
"category": {
"value": 6,
"boost": 1
}
}
}
},
{
"weight": "-140",
"filter": {
"term": {
"category": {
"value": 7,
"boost": 1
}
}
}
},
{
"weight": "-75",
"filter": {
"term": {
"qualityScore": {
"value": 0,
"boost": 1
}
}
}
},
{
"weight": "-8",
"filter": {
"range": {
"qualityScore": {
"gte": "1",
"lte": "1"
}
}
}
},
{
"weight": "0",
"filter": {
"range": {
"qualityScore": {
"gte": "2",
"lte": "6"
}
}
}
},
{
"weight": "5",
"filter": {
"range": {
"qualityScore": {
"gte": "7",
"lte": "11"
}
}
}
},
{
"weight": "8",
"filter": {
"range": {
"qualityScore": {
"gte": "12"
}
}
}
},
{
"weight": -45,
"filter": {
"term": {
"user.groups.category": {
"value": -3,
"boost": 1
}
}
}
},
{
"weight": -30,
"filter": {
"term": {
"user.groups.category": {
"value": -2,
"boost": 1
}
}
}
},
{
"weight": -15,
"filter": {
"term": {
"user.groups.category": {
"value": -1,
"boost": 1
}
}
}
},
{
"weight": 15,
"filter": {
"term": {
"user.groups.category": {
"value": 1,
"boost": 1
}
}
}
},
{
"weight": 30,
"filter": {
"term": {
"user.groups.category": {
"value": 2,
"boost": 1
}
}
}
},
{
"weight": 45,
"filter": {
"term": {
"user.groups.category": {
"value": 3,
"boost": 1
}
}
}
},
{
"weight": 60,
"filter": {
"term": {
"user.groups.category": {
"value": 4,
"boost": 1
}
}
}
},
{
"weight": 75,
"filter": {
"term": {
"user.groups.category": {
"value": 5,
"boost": 1
}
}
}
},
{
"weight": 525,
"filter": {
"term": {
"user.groups.category": {
"value": 35,
"boost": 1
}
}
}
}
]
}
},
"sort": [
"_score"
],
"explain": true,
"from": 0,
"size": 5
}
#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(177): Elastica\Type->search()
#5 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Paginator/HybridPaginatorAdapter.php(42): FOS\ElasticaBundle\Paginator\RawPaginatorAdapter->getElasticaResults()
#6 /srv/moonshot/vendor/friendsofsymfony/elastica-bundle/src/Subscriber/PaginateElasticaQuerySubscriber.php(46): FOS\ElasticaBundle\Paginator\HybridPaginatorAdapter->getResults()
#7 /srv/moonshot/vendor/symfony/event-dispatcher/Debug/WrappedListener.php(118): FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items()
#8 /srv/moonshot/vendor/symfony/event-dispatcher/EventDispatcher.php(230): Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
#9 /srv/moonshot/vendor/symfony/event-dispatcher/EventDispatcher.php(59): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
#10 /srv/moonshot/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php(154): 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/ContainerKiy3iqT/proxy-classes.php(545): Knp\Component\Pager\Paginator->paginate()
#13 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/DefaultListingSearch.php(25): ContainerKiy3iqT\PaginatorInterface_82dac15->paginate()
#14 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/AbstractElasticListingSearch.php(124): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\DefaultListingSearch->getResults()
#15 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Controller/ListingController.php(452): Aqarmap\Bundle\SearchBundle\Services\ElasticListingSearch\AbstractElasticListingSearch->search()
#16 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(163): Aqarmap\Bundle\ListingBundle\Controller\ListingController->read()
#17 /srv/moonshot/vendor/symfony/http-kernel/HttpKernel.php(75): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#18 /srv/moonshot/vendor/symfony/http-kernel/Kernel.php(202): 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(35): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
#21 /srv/moonshot/public/index.php(6): require_once('/srv/moonshot/v...')
#22 {main}
|
Doctrine MongoDB
0