Query Metrics
3
Database Queries
2.73 ms
Execution Time
0.00 ms
Query Time
Queries
| #▲ | Execution Time | Query Time | Info |
|---|---|---|---|
| 1 | 1.11 ms | 0.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["mens_t_shirts"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 3 View formatted query View cURL query View query backtrace |
| 2 | 0.83 ms | 0.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["mens_t_shirts"]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_en_US.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_en_US.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_en_US.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_en_US.keyword"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_en_US.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_en_US.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_en_US.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_en_US.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_en_US.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_en_US.keyword"}},"length":{"terms":{"field":"attribute_length_en_US.keyword"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_en_US.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_en_US.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_en_US.keyword"}},"t_shirt_size":{"terms":{"field":"option_t_shirt_size.keyword"}},"dress_size":{"terms":{"field":"option_dress_size.keyword"}},"dress_height":{"terms":{"field":"option_dress_height.keyword"}},"jeans_size":{"terms":{"field":"option_jeans_size.keyword"}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 3 View formatted query View cURL query View query backtrace |
| 3 | 0.79 ms | 0.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["mens_t_shirts"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 3 View formatted query View cURL query View query backtrace |