GET https://sylius.demo.wilma.dev/en_US/products-list/jeans/women

Query Metrics

5 Database Queries
3.94 ms Execution Time
0.00 ms Query Time

Queries

# Execution Time Query Time Info
1 1.03 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["womens_jeans"]}}]}},"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":["womens_jeans"]}}]}},"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: 4
View formatted query   View cURL query   View query backtrace
3 0.69 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["womens_jeans"]}}]}},"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
4 0.76 ms 0.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["womens_jeans"]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}
Path: bitbag_shop_products_dev/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 4
View formatted query   View cURL query   View query backtrace
5 0.78 ms 0.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["womens_jeans"]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"from":0,"size":9}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 4
View formatted query   View cURL query   View query backtrace