GET https://staging-b2b.gefu.com/navigation/14f405ab3ddb437fba7f33b7713309e9

Query Metrics

55.00 ms Query Time
1 Node(s)
10 Indices

Queries

# Execution Time Info
1 19.89 ms Request:
{"index":"gefu-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"nested":{"path":"mbdusSort","query":{"term":{"mbdusSort.categoryId":"14f405ab3ddb437fba7f33b7713309e9"}}}},{"nested":{"path":"mbdusSort","query":{"bool":{"must_not":[{"exists":{"field":"mbdusSort.categoryId"}}]}}}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ce6d8c1b894c45399f74e5050a8908f2"}}]}}}},{"term":{"active":true}}]}},{"bool":{"should":[{"nested":{"path":"tags","query":{"terms":{"tags.id":["8fde52cba4474ad38b36b83db21029cf"]}}}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"mbdusSort.sort":{"nested":{"path":"mbdusSort","filter":{"term":{"mbdusSort.categoryId":"14f405ab3ddb437fba7f33b7713309e9"}}},"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
2 5.22 ms Request:
{"index":"gefu-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"nested":{"path":"mbdusSort","query":{"term":{"mbdusSort.categoryId":"14f405ab3ddb437fba7f33b7713309e9"}}}},{"nested":{"path":"mbdusSort","query":{"bool":{"must_not":[{"exists":{"field":"mbdusSort.categoryId"}}]}}}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ce6d8c1b894c45399f74e5050a8908f2"}}]}}}},{"term":{"active":true}}]}},{"bool":{"should":[{"nested":{"path":"tags","query":{"terms":{"tags.id":["8fde52cba4474ad38b36b83db21029cf"]}}}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule09913b2ad6514ea3b2b58a82afa401e6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5bdc7e444a2f463896defc035c77ad32_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleaa1c1b8ec0044f52a4f36da2388b42cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef93609014fe84c7497236be8656c00e5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule825e183b736e48b58c24a489ad59e347_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea688f915c3854550bb824442c8675ad7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019232e5f160723db00ebf3f3b38da46_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule09693a1144784820870a4297d969f6b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule34e8378874544142b2c48d32584afa4e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule65101fbe7ded4fdeaa87551cda43cbc7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb5b076f2302a418fbb72ba615e02963a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefa8effeda51e4b02924c774acce11884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01980824bdf774f7b02f3245f6c69c98_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
3 6.08 ms Request:
{"index":"gefu-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"nested":{"path":"mbdusSort","query":{"term":{"mbdusSort.categoryId":"14f405ab3ddb437fba7f33b7713309e9"}}}},{"nested":{"path":"mbdusSort","query":{"bool":{"must_not":[{"exists":{"field":"mbdusSort.categoryId"}}]}}}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ce6d8c1b894c45399f74e5050a8908f2"}}]}}}},{"term":{"active":true}}]}},{"bool":{"should":[{"nested":{"path":"tags","query":{"terms":{"tags.id":["8fde52cba4474ad38b36b83db21029cf"]}}}}]}}]}}]}},"aggregations":{"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule09913b2ad6514ea3b2b58a82afa401e6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5bdc7e444a2f463896defc035c77ad32_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleaa1c1b8ec0044f52a4f36da2388b42cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef93609014fe84c7497236be8656c00e5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule825e183b736e48b58c24a489ad59e347_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea688f915c3854550bb824442c8675ad7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019232e5f160723db00ebf3f3b38da46_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule09693a1144784820870a4297d969f6b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule34e8378874544142b2c48d32584afa4e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule65101fbe7ded4fdeaa87551cda43cbc7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb5b076f2302a418fbb72ba615e02963a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefa8effeda51e4b02924c774acce11884_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01980824bdf774f7b02f3245f6c69c98_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
4 24.31 ms Request:
{"index":"gefu-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"nested":{"path":"mbdusSort","query":{"term":{"mbdusSort.categoryId":"14f405ab3ddb437fba7f33b7713309e9"}}}},{"nested":{"path":"mbdusSort","query":{"bool":{"must_not":[{"exists":{"field":"mbdusSort.categoryId"}}]}}}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"ce6d8c1b894c45399f74e5050a8908f2"}}]}}}},{"term":{"active":true}}]}},{"bool":{"should":[{"nested":{"path":"tags","query":{"terms":{"tags.id":["8fde52cba4474ad38b36b83db21029cf"]}}}}]}}]}}]}},"sort":[{"mbdusSort.sort":{"nested":{"path":"mbdusSort","filter":{"term":{"mbdusSort.categoryId":"14f405ab3ddb437fba7f33b7713309e9"}}},"order":"ASC"}}],"from":0,"size":24,"timeout":"5s"},"search_type":"query_then_fetch"}

Cluster Status

{
    "cluster_name": "elasticsearch_9200",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 30,
    "active_shards": 30,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 27,
    "delayed_unassigned_shards": 0,
    "number_of_pending_tasks": 0,
    "number_of_in_flight_fetch": 0,
    "task_max_waiting_in_queue_millis": 0,
    "active_shards_percent_as_number": 52.63157894736842
}

Indices

Name Status Replication (pri, rep) Doc Count
gefu-stage_product_1747045871 open 3, 3 20104
gefu-stage_product_1747045696 open 3, 3 20300
gefu-stage_category_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1711393396 open 3, 0 60
gefu-stage_category_c93c3558cca1479ea7b14c55c571aeb2_1711393396 open 3, 0 60
gefu-stage_product_1747045677 open 3, 3 10896
gefu-stage_action_search_term_c93c3558cca1479ea7b14c55c571aeb2_1711393396 open 3, 0 6
gefu-stage_action_search_term_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1711393396 open 3, 0 6
gefu-stage_action_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1711393396 open 3, 0 5
gefu-stage_action_c93c3558cca1479ea7b14c55c571aeb2_1711393396 open 3, 0 5
gefu-dev_product_1721920912 open 3, 0 13288