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

Query Metrics

2 Database Queries
39.76 ms Execution Time
9.00 ms Query Time

Queries

# Execution Time Query Time Info
1 27.68 ms 0.00 ms
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":179}}
{"doc":{"id":179,"title":"\u0643\u0645\u0628\u0648\u0646\u062f \u0639\u0642\u0627\u0631 \u0645\u0627\u0628","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":10,"attributesList":[],"sellerRole":3,"paymentMethod":1,"featured":1,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":null,"area":0,"translations":[{"content":"Facere fugiat minus quis cum.","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":"21476 Grimes Islands Apt. 348\nCierrashire, GA 91301-2485","field":"address"},{"content":"Compound Aqarmap","field":"title"},{"content":"the Address","field":"address"}],"section":{"id":3,"title":"\u0645\u0634\u0627\u0631\u064a\u0639 \u062c\u062f\u064a\u062f\u0629"},"location":{"id":44,"title":"\u0633\u0645\u0648\u062d\u0629"},"locations":[],"propertyType":{"id":10,"title":"\u0628\u0631\u062c"},"compoundField":{"minPrice":15000,"numberOfProjectsDelivered":4,"numberOfProjectsInhabited":5},"photos":[{"id":99,"caption":"images.jpeg"},{"id":100,"caption":"download.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":null,"childrenPropertyType":{"id":3},"compoundStatus":10,"priceLevel":0,"childrenArea":{"area":500},"childrenPrice":{"price":100000},"childrenPricePerMeter":{"pricePerMeter":200},"childrenAttributesList":{"floor":"3","rooms":"3","baths":"2","finish-type":"EXTRA_SUPER_LUX","year-built":"2043"},"geoPoint":"-58.184605528994,-26.512069702148","parent":[],"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":12.77,"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 12.08 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":0,"to":0}}},{"bool":{"should":[{"terms":{"location.id":[44]}},{"terms":{"locations.id":[44]}}]}}],"must_not":[{"terms":{"id":[179]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2025-02-22T09:42:05+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-01-23T09:42:05+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2025-01-18T09:42:05+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