Query Metrics
3
Database Queries
20.87 ms
Execution Time
3.00 ms
Query Time
Queries
| #▲ | Execution Time | Query Time | Info |
|---|---|---|---|
| 1 | 13.88 ms | 1.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["126"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query: Method: POST (https on localhost:9200) Item count: 11 View formatted query View query backtrace |
| 2 | 3.95 ms | 1.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["126"]}}]}},"aggs":{"badge":{"terms":{"field":"badge_codes.keyword"}},"brand":{"terms":{"field":"brand_code.keyword"}},"product_type":{"terms":{"field":"attribute_product_type_en_US.keyword"}},"grip_type_options":{"terms":{"field":"attribute_grip_type_options_en_US.keyword"}},"style_options":{"terms":{"field":"attribute_style_options_en_US.keyword"}},"climbing_ability":{"terms":{"field":"attribute_climbing_ability_en_US.keyword"}},"climbing_style":{"terms":{"field":"attribute_climbing_style_en_US.keyword"}},"size_options":{"terms":{"field":"attribute_size_options_en_US.keyword"}},"raw_material":{"terms":{"field":"attribute_raw_material_en_US.keyword"}},"positivity_options":{"terms":{"field":"attribute_positivity_options_en_US.keyword"}},"haptics_options":{"terms":{"field":"attribute_haptics_options_en_US.keyword"}},"price":{"histogram":{"field":"price_web_eur","interval":10000,"min_doc_count":1}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query: Method: POST (https on localhost:9200) Item count: 37 View formatted query View query backtrace |
| 3 | 3.04 ms | 1.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["126"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query: Method: POST (https on localhost:9200) Item count: 11 View formatted query View query backtrace |