https://testing-eg.am-root.com/ar/listing/14-projects-el-sheikh-zayed

Query Metrics

2 Database Queries
40.00 ms Execution Time
9.00 ms Query Time

Queries

# Execution Time Query Time Info
1 26.93 ms 0.00 ms
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":14}}
{"doc":{"id":14,"title":"Hi","description":"Architecto nulla molestias nostrum vero ipsam nisi aperiam velit. Ut qui esse neque quae porro et eaque non. Corrupti in aliquam ex et dolores et cum qui. Rerum quas voluptatum quae aut commodi deleniti.","address":"9455 Phyllis Via Apt. 332West Uriahport, KY 86241-6754","centerLat":-0.13657,"centerLng":-5.90338,"status":2,"compound_status":10,"attributesList":{"floor":"2","rooms":"1","baths":"3","finish-type":"WITHOUT_FINISH"},"sellerRole":3,"paymentMethod":1,"featured":7,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":12000000,"area":120,"translations":[{"content":"Dolore beatae minima in eum expedita debitis.","field":"title"},{"content":"Architecto nulla molestias nostrum vero ipsam nisi aperiam velit. Ut qui esse neque quae porro et eaque non. Corrupti in aliquam ex et dolores et cum qui. Rerum quas voluptatum quae aut commodi deleniti.","field":"description"},{"content":"9455 Phyllis Via Apt. 332\nWest Uriahport, KY 86241-6754","field":"address"}],"section":{"id":3,"title":"\u0645\u0634\u0627\u0631\u064a\u0639 \u062c\u062f\u064a\u062f\u0629"},"location":{"id":38,"title":"\u0627\u0644\u0634\u064a\u062e \u0632\u0627\u064a\u062f"},"locations":[{"id":37,"title":"\u0623\u0643\u062a\u0648\u0628\u0631"},{"id":39,"title":"\u0627\u0644\u062d\u0635\u0631\u064a"},{"id":40,"title":"\u0647\u0627\u064a\u0628\u0631 \u0648\u0627\u0646"},{"id":80,"title":"\u0627\u0644\u0631\u064a\u0627\u0636"},{"id":81,"title":"\u0634\u0642\u0631\u0627\u0621"},{"id":543,"title":"\u0639\u0631\u0639\u0631"},{"id":549,"title":"test"},{"id":554,"title":"testtttt"},{"id":556,"title":"test"},{"id":559,"title":"\u0627\u0644\u0633\u0628\u0639 \u0639\u0645\u0627\u064a\u0631"}],"propertyType":{"id":12,"title":"\u0645\u0628\u0646\u064a"},"compoundField":{"minPrice":null,"numberOfProjectsDelivered":2,"numberOfProjectsInhabited":2},"photos":[],"qualityScore":0,"compoundLocation":{"id":9,"title":"\u0625\u0645\u0628\u0627\u0628\u0629","coordinates":null,"location":[]},"user":{"id":11,"fullName":"Steve","groups":[]},"pricePerMeter":13235.490909091,"childrenPropertyType":[],"compoundStatus":10,"priceLevel":1,"childrenArea":{"area":120},"childrenPrice":{"price":12000000},"childrenPricePerMeter":{"pricePerMeter":0},"childrenAttributesList":{"floor":"3","rooms":"2","baths":"2","finish-type":"EXTRA_SUPER_LUX","year-built":"2043"},"geoPoint":"-0.13657,-5.90338","parent":[],"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":5.71,"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 13.07 ms 9.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":11600000,"to":12400000}}},{"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":[14]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2025-02-22T10:02:52+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-01-23T10:02:52+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-01-18T10:02:52+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