| 1 |
107.87 ms |
0.00 ms |
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":23}}
{"doc":{"id":23,"title":"Aspernatur perspiciatis vero deserunt qui a id.","description":"Debitis consequatur omnis incidunt voluptatem. Minus et repudiandae doloremque qui quod dolores aut. Voluptatem asperiores aliquid quibusdam quas saepe porro provident quam. Ducimus est perspiciatis consequatur.","address":"1642 Medhurst Vista Suite 916\nEmardland, MS 18638","centerLat":1.15973,"centerLng":158.15645,"status":2,"compound_status":10,"attributesList":{"floor":"6","rooms":"3","baths":"2","finish-type":"WITHOUT_FINISH","year-built":"2043","land-area":"100"},"sellerRole":0,"paymentMethod":1,"featured":3,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":10000,"area":10,"translations":[{"content":"Aspernatur perspiciatis vero deserunt qui a id.","field":"title"},{"content":"Debitis consequatur omnis incidunt voluptatem. Minus et repudiandae doloremque qui quod dolores aut. Voluptatem asperiores aliquid quibusdam quas saepe porro provident quam. Ducimus est perspiciatis consequatur.","field":"description"},{"content":"1642 Medhurst Vista Suite 916\nEmardland, MS 18638","field":"address"}],"section":{"id":3,"title":"Projects"},"location":{"id":42,"title":"Imbaba"},"locations":[],"propertyType":{"id":6,"title":"Villa"},"compoundField":{"minPrice":100,"numberOfProjectsDelivered":1,"numberOfProjectsInhabited":1},"photos":[],"qualityScore":0,"compoundLocation":{"id":3,"title":"90th Street","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}]},"pricePerMeter":1000,"childrenPropertyType":{"id":2},"compoundStatus":10,"priceLevel":0,"childrenArea":{"area":10},"childrenPrice":{"price":100},"childrenPricePerMeter":{"pricePerMeter":10},"childrenAttributesList":{"floor":"1","rooms":"1","baths":"1","finish-type":"EXTRA_SUPER_LUX","year-built":"2042"},"geoPoint":"1.15973,158.15645","parent":[],"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":4.76,"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": 23
}
}
{
"doc": {
"id": 23,
"title": "Aspernatur perspiciatis vero deserunt qui a id.",
"description": "Debitis consequatur omnis incidunt voluptatem. Minus et repudiandae doloremque qui quod dolores aut. Voluptatem asperiores aliquid quibusdam quas saepe porro provident quam. Ducimus est perspiciatis consequatur.",
"address": "1642 Medhurst Vista Suite 916\nEmardland, MS 18638",
"centerLat": 1.15973,
"centerLng": 158.15645,
"status": 2,
"compound_status": 10,
"attributesList": {
"floor": "6",
"rooms": "3",
"baths": "2",
"finish-type": "WITHOUT_FINISH",
"year-built": "2043",
"land-area": "100"
},
"sellerRole": 0,
"paymentMethod": 1,
"featured": 3,
"propertyView": null,
"source": null,
"category": 3,
"publishedAt": "2023-03-03T10:33:36+02:00",
"price": 10000,
"area": 10,
"translations": [
{
"content": "Aspernatur perspiciatis vero deserunt qui a id.",
"field": "title"
},
{
"content": "Debitis consequatur omnis incidunt voluptatem. Minus et repudiandae doloremque qui quod dolores aut. Voluptatem asperiores aliquid quibusdam quas saepe porro provident quam. Ducimus est perspiciatis consequatur.",
"field": "description"
},
{
"content": "1642 Medhurst Vista Suite 916\nEmardland, MS 18638",
"field": "address"
}
],
"section": {
"id": 3,
"title": "Projects"
},
"location": {
"id": 42,
"title": "Imbaba"
},
"locations": [],
"propertyType": {
"id": 6,
"title": "Villa"
},
"compoundField": {
"minPrice": 100,
"numberOfProjectsDelivered": 1,
"numberOfProjectsInhabited": 1
},
"photos": [],
"qualityScore": 0,
"compoundLocation": {
"id": 3,
"title": "90th Street",
"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
}
]
},
"pricePerMeter": 1000,
"childrenPropertyType": {
"id": 2
},
"compoundStatus": 10,
"priceLevel": 0,
"childrenArea": {
"area": 10
},
"childrenPrice": {
"price": 100
},
"childrenPricePerMeter": {
"pricePerMeter": 10
},
"childrenAttributesList": {
"floor": "1",
"rooms": "1",
"baths": "1",
"finish-type": "EXTRA_SUPER_LUX",
"year-built": "2042"
},
"geoPoint": "1.15973,158.15645",
"parent": [],
"isMortgage": false,
"isTopPicks": false,
"eligibleForMortgage": null,
"marketPropertyType": null,
"computedContactRate": 4.76,
"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/ContainerOFJeC8R/proxy-classes.php(137): Doctrine\ORM\EntityManager->flush()
#14 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/ListingManager.php(2841): ContainerOFJeC8R\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(446): 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 |
8.79 ms |
5.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":9666.666666666666,"to":10333.333333333334}}},{"bool":{"should":[{"terms":{"location.id":[42]}},{"terms":{"locations.id":[42]}}]}}],"must_not":[{"terms":{"id":[23]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2024-12-22T05:31:10+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-22T05:31:10+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-17T05:31:10+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: 0
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": 9666.666666666666,
"to": 10333.333333333334
}
}
},
{
"bool": {
"should": [
{
"terms": {
"location.id": [
42
]
}
},
{
"terms": {
"locations.id": [
42
]
}
}
]
}
}
],
"must_not": [
{
"terms": {
"id": [
23
]
}
},
{
"terms": {
"category": [
4
]
}
}
]
}
}
]
}
},
"functions": [
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-12-22T05:31:10+02:00",
"scale": "180d",
"offset": "0",
"decay": 0.5
}
},
"weight": "25"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-11-22T05:31:10+02:00",
"scale": "30d",
"offset": "0",
"decay": 0.5
}
},
"weight": "50"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-11-17T05:31:10+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/ContainerOFJeC8R/proxy-classes.php(545): Knp\Component\Pager\Paginator->paginate()
#13 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/DefaultListingSearch.php(25): ContainerOFJeC8R\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(450): 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