| 1 |
32.06 ms |
0.00 ms |
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":474}}
{"doc":{"id":474,"title":"Aliquid temporibus qui dolorem consequatur quibusdam.","description":"Excepturi et corporis praesentium et. Voluptatem quae dolorem eos itaque sit magnam libero. Aspernatur error quis autem corporis non et laudantium. Amet blanditiis deleniti mollitia.","address":"238 Delbert Brooks Suite 221\nPort Andreanneberg, TX 79786","centerLat":-49.852435,"centerLng":-101.70531,"status":2,"compound_status":11,"attributesList":[],"sellerRole":3,"paymentMethod":3,"featured":1,"propertyView":null,"source":null,"category":3,"aggregatedLeadsCount":2,"leadsCount":2,"publishedAt":"2023-03-03T10:33:36+02:00","aggregatedPublishedAt":"2023-03-03T10:33:36+02:00","price":4465540,"area":400,"translations":[{"content":"Aliquid temporibus qui dolorem consequatur quibusdam.","field":"title"},{"content":"Excepturi et corporis praesentium et. Voluptatem quae dolorem eos itaque sit magnam libero. Aspernatur error quis autem corporis non et laudantium. Amet blanditiis deleniti mollitia.","field":"description"},{"content":"238 Delbert Brooks Suite 221\nPort Andreanneberg, TX 79786","field":"address"}],"section":{"id":3,"title":"\u0645\u0634\u0627\u0631\u064a\u0639 \u062c\u062f\u064a\u062f\u0629"},"location":{"id":44,"title":"\u0633\u0645\u0648\u062d\u0629"},"locations":[],"propertyType":{"id":10,"title":"\u0628\u0631\u062c"},"compoundField":[],"photos":[],"qualityScore":0,"compoundLocation":{"id":2,"title":"\u0627\u0644\u0642\u0627\u0647\u0631\u0629 \u0627\u0644\u062c\u062f\u064a\u062f\u0629","coordinates":null,"location":[]},"user":{"id":6,"fullName":"Gideon","groups":[{"id":8,"category":null}]},"pricePerMeter":11163.85,"childrenPropertyType":[],"compoundStatus":11,"priceLevel":0,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"-49.852435,-101.70531","parent":{"id":471},"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"clickRate":4.24,"computedContactRate":28.57,"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
#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/Container4hYbIFQ/proxy-classes.php(137): Doctrine\ORM\EntityManager->flush()
#14 /srv/moonshot/src/Aqarmap/Bundle/ListingBundle/Service/ListingManager.php(2821): Container4hYbIFQ\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 |
11.61 ms |
9.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":4316688.666666667,"to":4614391.333333333}}},{"bool":{"should":[{"terms":{"location.id":[44]}},{"terms":{"locations.id":[44]}}]}}],"must_not":[{"terms":{"id":[474]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-03T03:22:46+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-10-04T03:22:46+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-09-29T03:22:46+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": 4316688.666666667,
"to": 4614391.333333333
}
}
},
{
"bool": {
"should": [
{
"terms": {
"location.id": [
44
]
}
},
{
"terms": {
"locations.id": [
44
]
}
}
]
}
}
],
"must_not": [
{
"terms": {
"id": [
474
]
}
},
{
"terms": {
"category": [
4
]
}
}
]
}
}
]
}
},
"functions": [
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-11-03T03:22:46+02:00",
"scale": "180d",
"offset": "0",
"decay": 0.5
}
},
"weight": "25"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-10-04T03:22:46+02:00",
"scale": "30d",
"offset": "0",
"decay": 0.5
}
},
"weight": "50"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-09-29T03:22:46+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/Container4hYbIFQ/proxy-classes.php(545): Knp\Component\Pager\Paginator->paginate()
#13 /srv/moonshot/src/Aqarmap/Bundle/SearchBundle/Services/ElasticListingSearch/DefaultListingSearch.php(25): Container4hYbIFQ\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