Query Metrics

4 Database Queries
14.93 ms Execution Time
6.00 ms Query Time

Queries

# Execution Time Query Time Info
1 3.55 ms 1.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5615"]}}]}},"size":20}
Path: normadoc_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
2 4.42 ms 3.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"terms":{"product_taxons":["taxon_5615"]}}]}},"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: 0
View formatted query   View cURL query   View query backtrace
3 3.08 ms 1.00 ms
{"query":{"bool":{"must":[{"terms":{"attribute_taxons":["taxon_5615"]}}]}},"size":20}
Path: normadoc_attribute_taxons_dev/_search
Query:
Method: POST (Http on localhost:9200)
Item count: 0
View formatted query   View cURL query   View query backtrace
4 3.88 ms 1.00 ms
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels":["default"]}},{"terms":{"product_taxons":["taxon_5615"]}}]}},"sort":[{"product_created_at":{"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: 0
View formatted query   View cURL query   View query backtrace