Query Metrics
5
Database Queries
14.90 ms
Execution Time
2.00 ms
Query Time
Queries
| #▲ | Execution Time | Query Time | Info |
|---|---|---|---|
| 1 | 3.42 ms | 1.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["sortiment-417"]}}]}},"size":20}
Path: otavan_bitbag_attribute_taxons_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 8 View formatted query View cURL query View query backtrace |
| 2 | 2.06 ms | 0.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["default"]}},{"terms":{"product_taxons.keyword":["sortiment-417"]}}]}},"aggs":{"attr_group_1":{"terms":{"field":"attribute_attr_group_1_cs_CZ.keyword"}},"attr_group_2":{"terms":{"field":"attribute_attr_group_2_cs_CZ.keyword"}},"attr_group_3":{"terms":{"field":"attribute_attr_group_3_cs_CZ.keyword"}},"attr_group_4":{"terms":{"field":"attribute_attr_group_4_cs_CZ.keyword"}},"attr_group_5":{"terms":{"field":"attribute_attr_group_5_cs_CZ.keyword"}},"attr_group_6":{"terms":{"field":"attribute_attr_group_6_cs_CZ.keyword"}},"attr_group_7":{"terms":{"field":"attribute_attr_group_7_cs_CZ.keyword"}},"attr_group_8":{"terms":{"field":"attribute_attr_group_8_cs_CZ.keyword"}},"attr_group_9":{"terms":{"field":"attribute_attr_group_9_cs_CZ.keyword"}},"attr_group_10":{"terms":{"field":"attribute_attr_group_10_cs_CZ.keyword"}},"attr_group_11":{"terms":{"field":"attribute_attr_group_11_cs_CZ.keyword"}},"attr_group_12":{"terms":{"field":"attribute_attr_group_12_cs_CZ.keyword"}},"attr_group_13":{"terms":{"field":"attribute_attr_group_13_cs_CZ.keyword"}},"attr_group_14":{"terms":{"field":"attribute_attr_group_14_cs_CZ.keyword"}},"attr_group_15":{"terms":{"field":"attribute_attr_group_15_cs_CZ.keyword"}},"attr_group_16":{"terms":{"field":"attribute_attr_group_16_cs_CZ.keyword"}},"attr_group_17":{"terms":{"field":"attribute_attr_group_17_cs_CZ.keyword"}},"attr_group_18":{"terms":{"field":"attribute_attr_group_18_cs_CZ.keyword"}},"attr_group_19":{"terms":{"field":"attribute_attr_group_19_cs_CZ.keyword"}},"attr_group_20":{"terms":{"field":"attribute_attr_group_20_cs_CZ.keyword"}},"attr_group_21":{"terms":{"field":"attribute_attr_group_21_cs_CZ.keyword"}},"attr_group_22":{"terms":{"field":"attribute_attr_group_22_cs_CZ.keyword"}},"attr_group_23":{"terms":{"field":"attribute_attr_group_23_cs_CZ.keyword"}},"attr_group_24":{"terms":{"field":"attribute_attr_group_24_cs_CZ.keyword"}},"attr_group_25":{"terms":{"field":"attribute_attr_group_25_cs_CZ.keyword"}},"attr_group_26":{"terms":{"field":"attribute_attr_group_26_cs_CZ.keyword"}},"attr_group_27":{"terms":{"field":"attribute_attr_group_27_cs_CZ.keyword"}},"attr_group_28":{"terms":{"field":"attribute_attr_group_28_cs_CZ.keyword"}},"attr_group_29":{"terms":{"field":"attribute_attr_group_29_cs_CZ.keyword"}},"attr_group_30":{"terms":{"field":"attribute_attr_group_30_cs_CZ.keyword"}},"attr_group_31":{"terms":{"field":"attribute_attr_group_31_cs_CZ.keyword"}},"attr_group_32":{"terms":{"field":"attribute_attr_group_32_cs_CZ.keyword"}},"attr_group_33":{"terms":{"field":"attribute_attr_group_33_cs_CZ.keyword"}},"attr_group_34":{"terms":{"field":"attribute_attr_group_34_cs_CZ.keyword"}},"attr_group_35":{"terms":{"field":"attribute_attr_group_35_cs_CZ.keyword"}},"attr_group_36":{"terms":{"field":"attribute_attr_group_36_cs_CZ.keyword"}},"attr_group_37":{"terms":{"field":"attribute_attr_group_37_cs_CZ.keyword"}},"attr_group_38":{"terms":{"field":"attribute_attr_group_38_cs_CZ.keyword"}},"attr_group_39":{"terms":{"field":"attribute_attr_group_39_cs_CZ.keyword"}},"attr_group_40":{"terms":{"field":"attribute_attr_group_40_cs_CZ.keyword"}},"attr_group_41":{"terms":{"field":"attribute_attr_group_41_cs_CZ.keyword"}},"attr_group_43":{"terms":{"field":"attribute_attr_group_43_cs_CZ.keyword"}},"attr_group_44":{"terms":{"field":"attribute_attr_group_44_cs_CZ.keyword"}},"attr_group_46":{"terms":{"field":"attribute_attr_group_46_cs_CZ.keyword"}},"attr_group_47":{"terms":{"field":"attribute_attr_group_47_cs_CZ.keyword"}},"attr_group_48":{"terms":{"field":"attribute_attr_group_48_cs_CZ.keyword"}},"attr_group_49":{"terms":{"field":"attribute_attr_group_49_cs_CZ.keyword"}},"attr_group_50":{"terms":{"field":"attribute_attr_group_50_cs_CZ.keyword"}},"attr_group_51":{"terms":{"field":"attribute_attr_group_51_cs_CZ.keyword"}},"attr_group_52":{"terms":{"field":"attribute_attr_group_52_cs_CZ.keyword"}},"attr_group_53":{"terms":{"field":"attribute_attr_group_53_cs_CZ.keyword"}},"option_group_45":{"terms":{"field":"option_option_group_45.keyword"}},"option_group_39":{"terms":{"field":"option_option_group_39.keyword"}},"option_group_40":{"terms":{"field":"option_option_group_40.keyword"}},"option_group_46":{"terms":{"field":"option_option_group_46.keyword"}},"option_group_47":{"terms":{"field":"option_option_group_47.keyword"}},"option_group_50":{"terms":{"field":"option_option_group_50.keyword"}},"option_group_53":{"terms":{"field":"option_option_group_53.keyword"}}},"size":0}
Path: otavan_bitbag_shop_products_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 8 View formatted query View cURL query View query backtrace |
| 3 | 2.10 ms | 0.00 ms |
{"query":{"bool":{"must":[{"terms":{"attribute_taxons.keyword":["sortiment-417"]}}]}},"size":20}
Path: otavan_bitbag_attribute_taxons_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 8 View formatted query View cURL query View query backtrace |
| 4 | 1.77 ms | 0.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["default"]}},{"terms":{"product_taxons.keyword":["sortiment-417"]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"size":0,"track_total_hits":true}
Path: otavan_bitbag_shop_products_dev/_search
Query: search_type=query_then_fetch Method: POST (Http on localhost:9200) Item count: 8 View formatted query View cURL query View query backtrace |
| 5 | 5.55 ms | 1.00 ms |
{"query":{"bool":{"must":[{"term":{"enabled":{"value":true,"boost":1}}},{"terms":{"channels.keyword":["default"]}},{"terms":{"product_taxons.keyword":["sortiment-417"]}}]}},"sort":[{"product_created_at":{"order":"asc","unmapped_type":"keyword"}}],"from":0,"size":24}
Path: otavan_bitbag_shop_products_dev/_search
Query: Method: POST (Http on localhost:9200) Item count: 8 View formatted query View cURL query View query backtrace |