https://testing-eg.am-root.com/en/listing/624-projects-%D9%8A%D8%B3%D9%86%D8%B4%D8%AA%D9%8A%D9%86%D8%B4%D8%B3

Query Metrics

2 Database Queries
236.61 ms Execution Time
11.00 ms Query Time

Queries

# Execution Time Query Time Info
1 222.02 ms 0.00 ms
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":624}}
{"doc":{"id":624,"title":"Duplex Apartment 120 M\u00b2 For Sale in Test title-Test Adress","description":"Eius beatae dignissimos ipsa doloremque qui architecto aut. Praesentium sunt beatae qui modi qui magnam consectetur. Qui atque est dolore et.","address":"\u0633\u0645\u0648\u062d\u0629, \u0627\u0644\u0625\u0633\u0643\u0646\u062f\u0631\u064a\u0629","centerLat":-56.91342568398788,"centerLng":-36.33115196280415,"status":2,"compound_status":null,"attributesList":{"rooms":"2","floor":"2","baths":"2","floors":"EXTRA_SUPER_LUX","apartments":"2043"},"sellerRole":1,"paymentMethod":1,"featured":null,"propertyView":2,"source":null,"category":2,"publishedAt":"2024-02-13T14:46:09+02:00","price":1200000,"area":120,"translations":[{"content":"Duplex Apartment 120 M\u00b2 For Sale in Test title-Test Adress","field":"title"},{"content":"Eius beatae dignissimos ipsa doloremque qui architecto aut. Praesentium sunt beatae qui modi qui magnam consectetur. Qui atque est dolore et.","field":"description"},{"content":"\u0633\u0645\u0648\u062d\u0629, \u0627\u0644\u0625\u0633\u0643\u0646\u062f\u0631\u064a\u0629","field":"address"},{"content":null,"field":"metaTitle"},{"content":null,"field":"metaDescription"}],"section":{"id":1,"title":"For Sale"},"location":{"id":44,"title":"Smouha"},"locations":[],"propertyType":{"id":3,"title":"Duplex Apartment"},"compoundField":{"minPrice":15000,"numberOfProjectsDelivered":4,"numberOfProjectsInhabited":5},"photos":[{"id":90,"caption":"Southmoor_Apartment_Hotel.jpg"}],"qualityScore":1,"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":8,"category":null},{"id":12,"category":null},{"id":13,"category":null}]},"pricePerMeter":10000,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"-56.913425683988,-36.331151962804","parent":{"id":179},"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":2,"computedContactRate":0,"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 14.59 ms 11.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":1160000,"to":1240000}}},{"bool":{"should":[{"terms":{"location.id":[44]}},{"terms":{"locations.id":[44]}}]}}],"must_not":[{"terms":{"id":[624]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2025-06-02T15:46:01+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-05-03T15:46:01+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-04-28T15:46:01+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