https://testing-eg.am-root.com/en/listing/4-new-projects-jskadsad

Query Metrics

2 Database Queries
118.44 ms Execution Time
10.00 ms Query Time

Queries

# Execution Time Query Time Info
1 102.65 ms 0.00 ms
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":4}}
{"doc":{"id":4,"title":"Architecto accusamus qui id amet.","description":"Aspernatur nihil aliquam molestiae id occaecati. Recusandae eveniet doloremque quas provident. In aut occaecati totam dicta maiores atque qui. Rerum molestiae ea quia autem. Dolores et sit et praesentium numquam.","address":"6167 Auer Overpass Apt. 300\nWest Chesley, AR 80188-3605","centerLat":-16.343748,"centerLng":-145.433023,"status":2,"compound_status":10,"attributesList":{"floor":"9","rooms":"4","baths":"6","finish-type":"SEMI_FINISHED","year-built":"2031"},"sellerRole":1,"paymentMethod":1,"featured":8,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":null,"area":0,"translations":[{"content":"Architecto accusamus qui id amet.","field":"title"},{"content":"Aspernatur nihil aliquam molestiae id occaecati. Recusandae eveniet doloremque quas provident. In aut occaecati totam dicta maiores atque qui. Rerum molestiae ea quia autem. Dolores et sit et praesentium numquam.","field":"description"},{"content":"6167 Auer Overpass Apt. 300\nWest Chesley, AR 80188-3605","field":"address"}],"section":{"id":3,"title":"Projects"},"location":{"id":38,"title":"El-Sheikh Zayed"},"locations":[],"propertyType":{"id":2,"title":"Apartment"},"compoundField":{"minPrice":null,"numberOfProjectsDelivered":0,"numberOfProjectsInhabited":0},"photos":[{"id":104,"caption":"download.jpg"}],"qualityScore":1,"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":null,"childrenPropertyType":{"id":1},"compoundStatus":10,"priceLevel":0,"childrenArea":{"area":120},"childrenPrice":{"price":0},"childrenPricePerMeter":{"pricePerMeter":0},"childrenAttributesList":[],"geoPoint":"-16.343748,-145.433023","parent":[],"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":3.85,"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
2 15.79 ms 10.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":0,"to":0}}},{"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":[4]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2024-12-22T00:54:56+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-22T00:54:56+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-17T00:54:56+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