GET https://boutique.up-pulse.dev/fr_FR/taxons/jeans/femmes?page=1

Query Metrics

5 Database Queries
15.93 ms Execution Time
3.00 ms Query Time

Queries

# Execution Time Query Time Info
1 5.14 ms 1.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["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 2.68 ms 1.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["womens_jeans"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"aggs":{"t_shirt_brand":{"terms":{"field":"attribute_t_shirt_brand_fr_FR.keyword"}},"t_shirt_collection":{"terms":{"field":"attribute_t_shirt_collection_fr_FR.keyword"}},"t_shirt_material":{"terms":{"field":"attribute_t_shirt_material_fr_FR.keyword"}},"damage_reduction":{"terms":{"field":"attribute_damage_reduction_fr_FR"}},"cap_brand":{"terms":{"field":"attribute_cap_brand_fr_FR.keyword"}},"cap_collection":{"terms":{"field":"attribute_cap_collection_fr_FR.keyword"}},"cap_material":{"terms":{"field":"attribute_cap_material_fr_FR.keyword"}},"dress_brand":{"terms":{"field":"attribute_dress_brand_fr_FR.keyword"}},"dress_collection":{"terms":{"field":"attribute_dress_collection_fr_FR.keyword"}},"dress_material":{"terms":{"field":"attribute_dress_material_fr_FR.keyword"}},"length":{"terms":{"field":"attribute_length_fr_FR"}},"jeans_brand":{"terms":{"field":"attribute_jeans_brand_fr_FR.keyword"}},"jeans_collection":{"terms":{"field":"attribute_jeans_collection_fr_FR.keyword"}},"jeans_material":{"terms":{"field":"attribute_jeans_material_fr_FR.keyword"}},"Taille":{"terms":{"field":"attribute_taille_fr_FR.keyword"}},"Poids":{"terms":{"field":"attribute_poids_fr_FR.keyword"}},"Pays_fabrication":{"terms":{"field":"attribute_pays_fabrication_fr_FR.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"}},"Iphone-color":{"terms":{"field":"option_iphone-color.keyword"}},"grav":{"terms":{"field":"option_grav.keyword"}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 18
View formatted query   View cURL query   View query backtrace
3 1.74 ms 0.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["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 2.43 ms 0.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["womens_jeans"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"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: 18
View formatted query   View cURL query   View query backtrace
5 3.94 ms 1.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}},{"terms":{"product_taxons.keyword":["womens_jeans"]}},{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customer_groups"}},{"exists":{"field":"organizations"}}]}}]}}]}},"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: 18
View formatted query   View cURL query   View query backtrace