GET https://dev.steinbeis-edition.de/detail/03640000000000000000000000000000

Query Metrics

32.00 ms Query Time
1 Node(s)
19 Indices

Queries

# Execution Time Info
1 32.40 ms Request:
{"index":"sw6_product","search_type":"query_then_fetch","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"nested":{"path":"tags","query":{"terms":{"tags.id":["019223c943b37659b7a9c442b9b29f93"]}}}}]}},{"bool":{"must_not":[{"term":{"id":"03640000000000000000000000000000"}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"35770e9aa5af44e5b861a83b1d6baca3"}}]}}}},{"term":{"active":true}}]}}]}}]}},"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"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

Cluster Status

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

Indices

Name Status Replication (pri, rep) Doc Count
sw6_admin-property-group-listing_1729458351 open 3, 3 1
sw6_admin-landing-page-listing_1729458350 open 3, 3 0
sw6_admin-payment-method-listing_1729458351 open 3, 3 25
sw6_admin-sales-channel-listing_1729458351 open 3, 3 2
sw6_admin-customer-listing_1729458350 open 3, 3 13
sw6_admin-order-listing_1729458351 open 3, 3 35
sw6_admin-product-stream-listing_1729458352 open 3, 3 39
sw6_admin-promotion-listing_1729458351 open 3, 3 3
sw6_product_2c06df6dde78421e8d5c8bbf1301d08e_1729458435 open 3, 3 5178
sw6_admin-cms-page-listing_1729458350 open 3, 3 13
sw6_admin-media-listing_1729458351 open 3, 3 1482
sw6_product_1737381753 open 3, 3 5271
sw6_admin-customer-group-listing_1729458350 open 3, 3 10
sw6_admin-category-listing_1729458351 open 3, 3 48
sw6_admin-shipping-method-listing_1729458351 open 3, 3 9
sw6_admin-newsletter-recipient-listing_1729458352 open 3, 3 2
sw6_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1729458435 open 3, 3 5178
sw6_admin-product-listing_1729458351 open 3, 3 778
sw6_admin-manufacturer-listing_1729458351 open 3, 3 2