| 1 |
92.52 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":2689084.933333333,"to":2874539.066666667}}},{"bool":{"should":[{"terms":{"location.id":[41,42]}},{"terms":{"locations.id":[41,42]}}]}}],"must_not":[{"terms":{"id":[92]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-03T09:34:42+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-10-04T09:34:42+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-09-29T09:34:42+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: 2
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": 2689084.933333333,
"to": 2874539.066666667
}
}
},
{
"bool": {
"should": [
{
"terms": {
"location.id": [
41,
42
]
}
},
{
"terms": {
"locations.id": [
41,
42
]
}
}
]
}
}
],
"must_not": [
{
"terms": {
"id": [
92
]
}
},
{
"terms": {
"category": [
4
]
}
}
]
}
}
]
}
},
"functions": [
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-11-03T09:34:42+02:00",
"scale": "180d",
"offset": "0",
"decay": 0.5
}
},
"weight": "25"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-10-04T09:34:42+02:00",
"scale": "30d",
"offset": "0",
"decay": 0.5
}
},
"weight": "50"
},
{
"linear": {
"aggregatedPublishedAt": {
"origin": "2024-09-29T09:34:42+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