GET https://shopware64.ideabooks.albertvanderveen.nl/navigation/6e3eff42952a4a2e82bcebe949be0d92?p=89

Query Metrics

38.00 ms Query Time
1 Node(s)
44 Indices

Queries

# Execution Time Info
1 30.38 ms Request:
{"index":"sw64_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_0a197278a7514b78a06ea27ef27e9ef8":{"gte":30}}}]}},{"term":{"categoryTree":"6e3eff42952a4a2e82bcebe949be0d92"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":2112,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
2 8.37 ms Request:
{"index":"sw64_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_0a197278a7514b78a06ea27ef27e9ef8":{"gte":30}}}]}},{"term":{"categoryTree":"6e3eff42952a4a2e82bcebe949be0d92"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule11c3ef6d5d97449d9b62e33e38f6d372_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule46c2cfb0bf07427a86929107eea988db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec21b551eb6014165bac73b68f2030e9c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec5e4d29334d147fda9b28cc58bff0604_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee43d962ef8364182bb743202cdb17c75_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef205ab57b6e343ca8d4614231ef10ef1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule248cdd2182084057ae22fce425ab4b2d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee0cf15b6d9364300942b4e1af482796d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"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"}

Cluster Status

{
    "cluster_name": "albertvanderveen",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 45,
    "active_shards": 45,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 2,
    "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": 95.74468085106383
}

Indices

Name Status Replication (pri, rep) Doc Count
security-auditlog-2026.01.10 open 1, 0 138036
.ql-datasources open 1, 0 0
top_queries-2026.01.17-65767 open 1, 0 19
top_queries-2026.01.19-65769 open 1, 0 15
security-auditlog-2026.01.18 open 1, 0 138024
security-auditlog-2026.01.17 open 1, 0 138040
security-auditlog-2026.01.16 open 1, 0 138032
security-auditlog-2025.12.31 open 1, 0 138032
security-auditlog-2026.01.15 open 1, 0 138028
security-auditlog-2025.12.30 open 1, 0 138032
security-auditlog-2026.01.14 open 1, 0 100525
security-auditlog-2026.01.13 open 1, 0 138044
.opendistro_security open 1, 0 9
security-auditlog-2026.01.12 open 1, 0 138032
security-auditlog-2026.01.11 open 1, 0 138036
.opensearch-observability open 1, 0 0
top_queries-2026.01.13-65763 open 1, 0 22
security-auditlog-2026.01.09 open 1, 0 138040
security-auditlog-2026.01.08 open 1, 0 138036
top_queries-2026.01.16-65766 open 1, 0 31
sw64_product_1766774037 open 1, 1 145101
security-auditlog-2026.01.20 open 1, 0 112904
security-auditlog-2025.12.29 open 1, 0 138032
security-auditlog-2025.12.28 open 1, 0 138032
security-auditlog-2025.12.27 open 1, 0 138016
security-auditlog-2025.12.26 open 1, 0 134811
top_queries-2026.01.20-65791 open 1, 0 740
security-auditlog-2025.12.25 open 1, 0 36655
.kibana_92668751_admin_1 open 1, 0 1
security-auditlog-2026.01.07 open 1, 0 138044
security-auditlog-2026.01.06 open 1, 0 138032
security-auditlog-2026.01.05 open 1, 0 138032
security-auditlog-2026.01.04 open 1, 0 138036
security-auditlog-2026.01.03 open 1, 0 138040
security-auditlog-2026.01.02 open 1, 0 138036
.kibana_1 open 1, 0 1
security-auditlog-2026.01.01 open 1, 0 138032
top_queries-2026.01.18-65768 open 1, 0 29
.tasks open 1, 0 1
top_queries-2026.01.14-65764 open 1, 0 39
.plugins-ml-config open 1, 0 1
top_queries-2026.01.15-65765 open 1, 0 24
security-auditlog-2026.01.19 open 1, 0 138032
sw64_product_1766773199 open 1, 1 145101