https://testing-eg.am-root.com/ar/listing/37-projects-north-coast?source=related-listing

Query Metrics

2 Database Queries
155.46 ms Execution Time
31.00 ms Query Time

Queries

# Execution Time Query Time Info
1 118.34 ms 0.00 ms
{"update":{"_index":"aqarmap_eg_listings","_type":"listings","_id":37}}
{"doc":{"id":37,"title":"Dolores voluptatum molestias ut inventore corrupti vel.","description":"Autem quasi dolorem sit. Reiciendis rerum porro hic asperiores dolorem aperiam quis. Pariatur eos molestiae officiis. Dolorem eligendi ratione et enim.","address":"158 Ransom Ramp Suite 461\nCorkeryport, ME 46497","centerLat":-31.809093,"centerLng":105.585555,"status":2,"compound_status":null,"attributesList":{"floor":"8","rooms":"9","baths":"5","finish-type":"LUX"},"sellerRole":3,"paymentMethod":null,"featured":3,"propertyView":null,"source":null,"category":3,"publishedAt":"2023-03-03T10:33:36+02:00","price":4535030,"area":90,"translations":[{"content":"Dolores voluptatum molestias ut inventore corrupti vel.","field":"title"},{"content":"Autem quasi dolorem sit. Reiciendis rerum porro hic asperiores dolorem aperiam quis. Pariatur eos molestiae officiis. Dolorem eligendi ratione et enim.","field":"description"},{"content":"158 Ransom Ramp Suite 461\nCorkeryport, ME 46497","field":"address"}],"section":{"id":3,"title":"\u0645\u0634\u0627\u0631\u064a\u0639 \u062c\u062f\u064a\u062f\u0629"},"location":{"id":45,"title":"\u0627\u0644\u0633\u0627\u062d\u0644 \u0627\u0644\u0634\u0645\u0627\u0644\u064a"},"locations":[],"propertyType":{"id":13,"title":"\u0645\u0648\u0644"},"compoundField":[],"photos":[],"qualityScore":0,"compoundLocation":[],"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}]},"pricePerMeter":50389.222222222,"childrenPropertyType":[],"compoundStatus":null,"priceLevel":null,"childrenArea":{"area":10020},"childrenPrice":{"price":20000},"childrenPricePerMeter":{"pricePerMeter":1},"childrenAttributesList":{"floor":"1","rooms":"2","baths":"2","finish-type":"EXTRA_SUPER_LUX","year-built":"2043"},"geoPoint":"-31.809093,105.585555","parent":[],"isMortgage":false,"isTopPicks":false,"eligibleForMortgage":null,"marketPropertyType":null,"computedContactRate":3.7,"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 37.12 ms 31.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":4383862.333333333,"to":4686197.666666667}}},{"bool":{"should":[{"terms":{"location.id":[45]}},{"terms":{"locations.id":[45]}}]}}],"must_not":[{"terms":{"id":[37]}},{"terms":{"category":[4]}}]}}]}},"functions":[{"linear":{"aggregatedPublishedAt":{"origin":"2024-12-21T22:40:08+02:00","scale":"180d","offset":"0","decay":0.5}},"weight":"25"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-21T22:40:08+02:00","scale":"30d","offset":"0","decay":0.5}},"weight":"50"},{"linear":{"aggregatedPublishedAt":{"origin":"2024-11-16T22:40:08+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: 5
View formatted query   View query backtrace