GET https://stage-sw6.radwelt-shop.de/cbax/manufacturer/detail/92c87f928927812f1588ad8f1fedd6d3

Query Metrics

4.00 ms Query Time
1 Node(s)
28 Indices

Queries

# Execution Time Info
1 4.85 ms Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"92c87f928927812f1588ad8f1fedd6d3"}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

Cluster Status

{
    "cluster_name": "elasticsearch",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 86,
    "active_shards": 86,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 252,
    "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": 25.443786982248522
}

Indices

Name Status Replication (pri, rep) Doc Count
sw-admin-payment-method-listing_1732606828 open 3, 3 45
shopware6-stage_product_1725962023 open 3, 3 698878
shopware6-new_product_1723452452 open 3, 3 698878
sw-admin-mollie-refund_1732606829 open 3, 3 0
shopware6-stage_product_01894ed2cf1a70659e13690a9aca16a3_1723451325 open 3, 3 411469
sw-admin-promotion-listing_1732606828 open 3, 3 9
shopware6-stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1723451325 open 3, 3 411469
sw-admin-media-listing_1732606828 open 3, 3 10049
sw-admin-product-stream-listing_1732606829 open 3, 3 7353
sw-admin-manufacturer-listing_1732606827 open 3, 3 127
sw-admin-newsletter-recipient-listing_1732606829 open 3, 3 1
sw-admin-cms-page-listing_1732606827 open 3, 3 65
sw-admin-product-listing_1732606828 open 3, 3 9462
shopware6-stage_product_1717777228 open 3, 3 698886
shopware6-stage_product_1725967126 open 3, 3 773930
sw-admin-sales-channel-listing_1732606828 open 3, 3 2
shopware6-new_product_1723451173 open 3, 3 698866
sw-admin-landing-page-listing_1732606827 open 3, 3 16
sw-admin-customer-group-listing_1732606827 open 3, 3 2
shopware6-stage_product_1725967107 open 3, 3 698878
sw-admin-category-listing_1732606829 open 3, 3 374
sw-admin-mollie-subscription_1732606829 open 3, 3 0
sw-admin-order-listing_1732606828 open 3, 3 462
shopware6-stage_product_1725958313 open 3, 3 698878
sw-admin-property-group-listing_1732606828 open 3, 3 137
sw-admin-customer-listing_1732606827 open 3, 3 133
sw-admin-shipping-method-listing_1732606828 open 3, 3 3
shopware6-stage_product_1725962160 open 3, 3 698878