Query Metrics
1
Database Queries
4.91 ms
Execution Time
3.00 ms
Query Time
Queries
#▲ | Execution Time | Query Time | Info |
---|---|---|---|
1 | 4.91 ms | 3.00 ms |
{"query":{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["206"]}}}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[206]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[206]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}},"_source":false,"from":0,"size":12}
Path: sk_product_dev/_search
Query: Method: POST (Http on elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200) Item count: 1 View formatted query View cURL query View query backtrace
curl -XPOST 'http://elastic:3PV1I61Qvv18QrqoKmha@127.0.0.1:59200/sk_product_dev/_search' -H 'Content-Type: application/json' -d '{"query":{"bool":{"must":[{"nested":{"path":"categories","query":{"terms":{"categories.id":["206"]}}}}]}},"sort":{"categories.position":{"nested":{"path":"categories","filter":{"terms":{"categories.id":[206]}}}}},"aggs":{"category":{"global":{},"aggs":{"category_nested":{"nested":{"path":"categories"},"aggs":{"category_filter":{"filter":{"terms":{"categories.id":[206]}},"aggs":{"category_global":{"reverse_nested":{},"aggs":{"price_min":{"min":{"field":"price"}},"price_max":{"max":{"field":"price"}},"dimensions":{"nested":{"path":"attributes"},"aggs":{"width_min":{"min":{"field":"attributes.width"}},"width_max":{"max":{"field":"attributes.width"}},"height_min":{"min":{"field":"attributes.height"}},"height_max":{"max":{"field":"attributes.height"}},"power_min":{"min":{"field":"attributes.power"}},"power_max":{"max":{"field":"attributes.power"}}}}}}}}}}}},"manufacturer":{"terms":{"field":"manufacturer","size":100}},"product_class":{"terms":{"field":"productClass","size":100}},"price":{"range":{"field":"price","ranges":[{"to":500,"key":"cheap"},{"from":500,"to":1500,"key":"average"},{"from":1500,"key":"expensive"}]}},"attribute":{"nested":{"path":"attributes"},"aggs":{"attributes":{"terms":{"field":"attributes.option","size":250}}}}},"_source":false,"from":0,"size":12}'
|