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

Query Metrics

2 Database Queries
40.94 ms Execution Time
12.00 ms Query Time

Queries

# Execution Time Query Time Info
1 24.97 ms 0.00 ms
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":627}}
{"doc":{"id":627,"title":"\u0634\u0642\u0629 \u062f\u0648\u0628\u0644\u064a\u0643\u0633 500 \u0645\u062a\u0631\u00b2 \u0644\u0644\u0628\u064a\u0639 \u0641\u0649 \u0643\u0645\u0628\u0648\u0646\u062f \u0639\u0642\u0627\u0631 \u0645\u0627\u0628-\u0627\u0644\u0639\u0646\u0648\u0627\u0646","description":"Eius beatae dignissimos ipsa doloremque qui architecto aut. Praesentium sunt beatae qui modi qui magnam consectetur. Qui atque est dolore et.","address":"\u0627\u0644\u0639\u0646\u0648\u0627\u0646","centerLat":-58.184605528994,"centerLng":-26.512069702148,"status":2,"compound_status":null,"attributesList":{"floor":"3","rooms":"3","baths":"2","finish-type":"EXTRA_SUPER_LUX","year-built":"2043"},"sellerRole":3,"paymentMethod":1,"featured":null,"propertyView":3,"source":null,"category":2,"publishedAt":"2024-02-14T21:19:10+02:00","price":100000,"area":500,"translations":[{"content":"Duplex Apartment 500 M\u00b2 For Sale in Compound Aqarmap-the Address","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":"the Address","field":"address"},{"content":null,"field":"metaTitle"},{"content":null,"field":"metaDescription"}],"section":{"id":1,"title":"\u0644\u0644\u0628\u064a\u0639"},"location":{"id":44,"title":"\u0633\u0645\u0648\u062d\u0629"},"locations":[],"propertyType":{"id":3,"title":"\u0634\u0642\u0629 \u062f\u0648\u0628\u0644\u064a\u0643\u0633"},"compoundField":{"minPrice":15000,"numberOfProjectsDelivered":4,"numberOfProjectsInhabited":5},"photos":[{"id":96,"caption":"0 meter compound guide.PNG"},{"id":97,"caption":"Southmoor_Apartment_Hotel.jpg"}],"qualityScore":2,"compoundLocation":{"id":11,"title":"\u0633\u0645\u0648\u062d\u0629","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},{"id":13,"category":null}]},"pricePerMeter":200,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"-58.184605528994,-26.512069702148","parent":{"id":179},"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"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 15.96 ms 12.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":96666.66666666667,"to":103333.33333333333}}},{"bool":{"should":[{"terms":{"location.id":[44]}},{"terms":{"locations.id":[44]}}]}}],"must_not":[{"terms":{"id":[627]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2025-02-22T10:01:17+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-01-23T10:01:17+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-01-18T10:01:17+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