GET https://sylius.demo.wilma.dev/en_US/products-list/category/t-shirts?order_by=sold_units&sort=desc

Response
200 OK
IP
216.244.66.229
Profiled on
Token
78ee84

Query Metrics

5 Database Queries
4.18 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":["t_shirts"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 4
View formatted query   View cURL query   View query backtrace
2 0.79 ms 0.00 ms 
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["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: 6
View formatted query   View cURL query   View query backtrace
3 0.64 ms 0.00 ms 
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["t_shirts"]}}]}},"size":20}
Path: bitbag_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 4
View formatted query   View cURL query   View query backtrace
4 0.69 ms 0.00 ms 
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["t_shirts"]}}]}},"sort":[{"sold_units":{"order":"desc","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: 6
View formatted query   View cURL query   View query backtrace
5 0.80 ms 0.00 ms 
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["fashion_web"]}},{"terms":{"product_taxons":["t_shirts"]}}]}},"sort":[{"sold_units":{"order":"desc","unmapped_type":"keyword"}}],"from":0,"size":9}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 6
View formatted query   View cURL query   View query backtrace