GET http://dev.climbholds.com/fr_FR/search?bitbag_elasticsearch_search%5Bfacets%5D%5Bproduct_type%5D%5B0%5D=macros

Query Metrics

3 Database Queries
50.08 ms Execution Time
8.00 ms Query Time

Queries

#▲ Execution Time Query Time Info
1 42.29 ms 5.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}}],"filter":[{"terms":{"attribute_product_type_fr_FR.keyword":["macros"]}}]}},"aggs":{"badge":{"terms":{"field":"badge_codes.keyword"}},"brand":{"terms":{"field":"brand_code.keyword"}},"product_type":{"terms":{"field":"attribute_product_type_fr_FR.keyword"}},"grip_type_options":{"terms":{"field":"attribute_grip_type_options_fr_FR.keyword"}},"style_options":{"terms":{"field":"attribute_style_options_fr_FR.keyword"}},"climbing_ability":{"terms":{"field":"attribute_climbing_ability_fr_FR.keyword"}},"climbing_style":{"terms":{"field":"attribute_climbing_style_fr_FR.keyword"}},"size_options":{"terms":{"field":"attribute_size_options_fr_FR.keyword"}},"raw_material":{"terms":{"field":"attribute_raw_material_fr_FR.keyword"}},"positivity_options":{"terms":{"field":"attribute_positivity_options_fr_FR.keyword"}},"haptics_options":{"terms":{"field":"attribute_haptics_options_fr_FR.keyword"}},"price":{"histogram":{"field":"price_web_eur","interval":10000,"min_doc_count":1}}},"size":0}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (https on localhost:9200)
Item count: 195
View formatted query   View query backtrace
2 2.99 ms 1.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}}],"filter":[{"terms":{"attribute_product_type_fr_FR.keyword":["macros"]}}]}},"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 (https on localhost:9200)
Item count: 195
View formatted query   View query backtrace
3 4.80 ms 2.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["WEB_EUR"]}}],"filter":[{"terms":{"attribute_product_type_fr_FR.keyword":["macros"]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"from":0,"size":16}
Path: bitbag_shop_products_dev/_search
Query:
Method: POST (https on localhost:9200)
Item count: 195
View formatted query   View query backtrace