Query Metrics

3 Database Queries
2.55 ms Execution Time
0.00 ms Query Time

Queries

# Execution Time Query Time Info
1 1.25 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.68 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.62 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