https://testing-eg.am-root.com/ar/listing/888-new-projects-th

Query Metrics

2 Database Queries
112.31 ms Execution Time
28.00 ms Query Time

Queries

# Execution Time Query Time Info
1 79.56 ms 0.00 ms
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":888}}
{"doc":{"id":888,"title":"\u0634\u0642\u0629 110 \u0645\u062a\u0631\u00b2 \u0644\u0644\u0628\u064a\u0639 \u0641\u0649 Sit excepturi perferendis aut velit labore est.-95235 Odie Crossing\nNew Bertha, MN 16023","description":"Itaque officiis enim quas quasi sint dolor impedit. Est odio aut quae voluptas fugit voluptatibus. Voluptates magnam laborum quis expedita animi ut. Laudantium ut ad modi omnis exercitationem. Molestiae assumenda omnis sit non debitis iste.","address":"95235 Odie Crossing\nNew Bertha, MN 16023","centerLat":-80.352978,"centerLng":-80.304818,"status":2,"compound_status":null,"attributesList":{"floor":"21","rooms":"2","baths":"1","finish-type":"EXTRA_SUPER_LUX","year-built":"2028"},"sellerRole":1,"paymentMethod":1,"featured":null,"propertyView":2,"source":null,"category":1,"publishedAt":"2025-02-24T15:20:43+02:00","price":1200,"area":110,"translations":[{"content":"Apartment 110 M\u00b2 For Sale in Sit excepturi perferendis aut velit labore est.-95235 Odie Crossing\nNew Bertha, MN 16023","field":"title"},{"content":"Itaque officiis enim quas quasi sint dolor impedit. Est odio aut quae voluptas fugit voluptatibus. Voluptates magnam laborum quis expedita animi ut. Laudantium ut ad modi omnis exercitationem. Molestiae assumenda omnis sit non debitis iste.","field":"description"},{"content":"95235 Odie Crossing\nNew Bertha, MN 16023","field":"address"},{"content":null,"field":"metaTitle"},{"content":null,"field":"metaDescription"}],"section":{"id":1,"title":"\u0644\u0644\u0628\u064a\u0639"},"location":{"id":41,"title":"\u0627\u0644\u062c\u064a\u0632\u0629"},"locations":[],"propertyType":{"id":2,"title":"\u0634\u0642\u0629"},"compoundField":{"minPrice":1200,"numberOfProjectsDelivered":0,"numberOfProjectsInhabited":0},"photos":[],"qualityScore":0,"compoundLocation":{"id":6,"title":"\u0627\u0644\u062d\u0635\u0631\u064a","coordinates":null,"location":{"id":38}},"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":10.909090909091,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":[],"childrenPrice":[],"childrenPricePerMeter":[],"childrenAttributesList":[],"geoPoint":"-80.352978,-80.304818","parent":{"id":80},"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 32.75 ms 28.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":1160,"to":1240}}},{"bool":{"should":[{"terms":{"location.id":[41,42]}},{"terms":{"locations.id":[41,42]}}]}}],"must_not":[{"terms":{"id":[888]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2025-04-03T00:40:20+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-03-04T00:40:20+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-02-27T00:40:20+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