Query Metrics

3 Database Queries
34.13 ms Execution Time
22.00 ms Query Time

Queries

# Execution Time Query Time Info
1 6.11 ms 2.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"match_phrase":{"name_en_us":{"query":" IEEE\/ISO\/IEC 15068-2:1999","boost":10}}},{"multi_match":{"query":" IEEE\/ISO\/IEC 15068-2:1999","fields":["name_en_us^5"],"fuzziness":"AUTO"}},{"multi_match":{"query":" IEEE\/ISO\/IEC 15068-2:1999","fields":["code_en_us","short_description_en_us"],"fuzziness":"AUTO"}}]}}]}},"aggs":{"taxon":{"terms":{"field":"product_taxons.keyword"}},"available_in_subscription":{"terms":{"field":"attribute_available_in_subscription_en_US"}},"state":{"terms":{"field":"attribute_state_en_US.keyword"}},"most_recent":{"terms":{"field":"attribute_most_recent_en_US.keyword"}},"confirmed":{"terms":{"field":"attribute_confirmed_en_US"}},"has_draft":{"terms":{"field":"attribute_has_draft_en_US"}},"modified":{"terms":{"field":"attribute_modified_en_US"}},"new":{"terms":{"field":"attribute_new_en_US"}},"type":{"terms":{"field":"attribute_type_en_US.keyword"}},"edition":{"terms":{"field":"attribute_edition_en_US.keyword"}},"published_at":{"terms":{"field":"attribute_published_at_en_US"}},"keywords":{"terms":{"field":"attribute_keywords_en_US.keyword"}},"themes":{"terms":{"field":"attribute_themes_en_US.keyword"}},"supplier":{"terms":{"field":"attribute_supplier_en_US.keyword"}},"format":{"terms":{"field":"option_format.keyword"}},"languages":{"terms":{"field":"option_languages.keyword"}},"multi_user":{"terms":{"field":"option_multi_user.keyword"}},"red_line":{"terms":{"field":"option_red_line.keyword"}}},"size":0}
Path: normadoc_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 5574
View formatted query   View cURL query   View query backtrace
2 4.26 ms 1.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"match_phrase":{"name_en_us":{"query":"IEEE\/ISO\/IEC 15068-2:1999","boost":10}}},{"multi_match":{"query":"IEEE\/ISO\/IEC 15068-2:1999","fields":["name_en_us^5"],"fuzziness":"AUTO"}},{"multi_match":{"query":"IEEE\/ISO\/IEC 15068-2:1999","fields":["code_en_us","short_description_en_us"],"fuzziness":"AUTO"}}]}}]}},"sort":[{"price_default":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}
Path: normadoc_shop_products_dev/_search
Query: search_type=query_then_fetch
Method: POST (Http on localhost:9200)
Item count: 5574
View formatted query   View cURL query   View query backtrace
3 23.77 ms 19.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"bool":{"should":[{"match_phrase":{"name_en_us":{"query":"IEEE\/ISO\/IEC 15068-2:1999","boost":10}}},{"multi_match":{"query":"IEEE\/ISO\/IEC 15068-2:1999","fields":["name_en_us^5"],"fuzziness":"AUTO"}},{"multi_match":{"query":"IEEE\/ISO\/IEC 15068-2:1999","fields":["code_en_us","short_description_en_us"],"fuzziness":"AUTO"}}]}}]}},"sort":[{"price_default":{"order":"asc","unmapped_type":"keyword"}}],"from":960,"size":15}
Path: normadoc_shop_products_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 5574
View formatted query   View cURL query   View query backtrace