Symfony Profiler

Query Metrics

32.00 ms Query Time

1 Node(s)

19 Indices

Queries

#▲ Execution Time Info

30.91 ms

#▲	Execution Time	Info
1	30.91 ms	Request: {"index":"sw6_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"35770e9aa5af44e5b861a83b1d6baca3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"7c52c651b5187d188173a0dea67d3f0a"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"releaseDate":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 1 View formatted request View formatted response View query backtrace POST https://localhost:9200/sw6_product/_search?search_type=query_then_fetch&track_total_hits=1 Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "35770e9aa5af44e5b861a83b1d6baca3" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "7c52c651b5187d188173a0dea67d3f0a" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "sort": [ { "releaseDate": { "order": "DESC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 12, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 1, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw6_product_1737381753", "_id": "1545d2d144cebfc187f3e048554b0000", "_score": null, "_source": { "id": "1545d2d144cebfc187f3e048554b0000", "autoIncrement": 1837.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "35770e9aa5af44e5b861a83b1d6baca3" } ], "availableStock": 0, "productNumber": "194637", "ean": "9783956631726", "displayGroup": "2b8723f761383894d4ee6b6030f1b0ac", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": "2018-08-14T00:00:00+00:00", "createdAt": "2024-08-20T15:53:41+00:00", "categoryTree": [ "f6b181deb3dd4dbc8b320b168682ed17", "d5e9e43a77b65b05b94c88fd47c566a9", "7c52c651b5187d188173a0dea67d3f0a" ], "categoriesRo": [ { "id": "f6b181deb3dd4dbc8b320b168682ed17", "_count": 1 }, { "id": "d5e9e43a77b65b05b94c88fd47c566a9", "_count": 1 }, { "id": "7c52c651b5187d188173a0dea67d3f0a", "_count": 1 } ], "taxId": "24943afd50de4c6685bf677bf45f057e", "tags": [ { "id": "019223c76cff7422949898b06ad10e6c", "name": "Steinbeis Engineering Studien", "_count": 1 } ], "parentId": null, "coverId": "019174aa7c307086a7278619d0deed8d", "childCount": 0, "categories": [ { "id": "7c52c651b5187d188173a0dea67d3f0a", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Steinbeis Engineering Studie" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "2c06df6dde78421e8d5c8bbf1301d08e": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "7c52c651b5187d188173a0dea67d3f0a" ], "optionIds": [], "propertyIds": [], "tagIds": [ "019223c76cff7422949898b06ad10e6c" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "custom_books_isbn": "978-3-95663-172-6", "custom_books_author": "Simon Hiller, Michelle Moisa, Dominik Morar, Kathrin Pf\u00e4hler", "custom_books_shortdesc": "Wertsch\u00f6pfungsszenarien f\u00fcr die erfolgreiche Implementierung von Additive Manufacturing", "custom_books_medium": "Softcover, s\/w", "custom_books_pages": "40 S.", "custom_books_language": "dt." } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Leitfaden Additive Manufacturing", "2c06df6dde78421e8d5c8bbf1301d08e": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Blick ins BuchDer Leitfaden Additive Manufacturing (AM) liefert Handlungsempfehlungen zur Implementierung von AM im industriellen Einsatz. Die additive Fertigung wird darin in Form von vier unterschiedlichen Wertsch\u00f6pfungsszenarien dargestellt und in Betreibermodellen aufgezeigt. Eine Unterscheidung erfolgt in den unternehmensinternen oder -externen Wertsch\u00f6pfungsphasen. In diesem Leitfaden werden die folgenden Fragen zur Nutzung der additiven Fertigung beantwortet:Unter welchen Rahmenbedingungen lassen sich die Eigenschaften von Additive Manufacturing in bestehenden Wertsch\u00f6pfungsketten nutzen?Welche Herangehensweisen zur Implementierung von Additive Manufacturing existieren f\u00fcr produzierende Unternehmen?Welche Schlussfolgerungen lassen sich f\u00fcr Additive-Manufacturing-Betreibermodelle ziehen?Des Weiteren werden zum besseren Verst\u00e4ndnis die Grundlagen des Additive Manufacturing dargelegt. Hierbei wird einf\u00fchrend ein \u00dcberblick \u00fcber die verschiedenen Verfahren, deren Charakteristika sowie deren Potenziale gegeben.Simon Hiller arbeitet als wissenschaftlicher Mitarbeiter am Ferdinand-Steinbeis-Institut, im Forschungsbereich Industrial Internet & Industrie 4.0 speziell im Themengebiet Additive Manufacturing. Er studierte Medizintechnik (B.Sc.) im Kooperationsstudiengang der Universit\u00e4t Stuttgart und der Universit\u00e4t T\u00fcbingen bis 2015. Anschlie\u00dfend absolvierte er den Studiengang Master of Business Engineering (MBE) an der Steinbeis-Hochschule und schloss diesen 2017 ab.Michelle Moisa ist Doktorandin an der Graduate School of Excellence advanced Manufacturing Engineering (GSaME) der Universit\u00e4t Stuttgart in Kooperation mit dem Lehrstuhl f\u00fcr Wirtschaftsinformatik 1 zum Thema Capabilities im Kontext von Additive Manufacturing. Zuvor studierte sie Wirtschaftsinformatik an der Dualen Hochschule Baden-W\u00fcrttemberg in Mosbach (B.Sc.) sowie an den Universit\u00e4ten Hohenheim und Stuttgart (M.Sc.).Dominik Morar studierte Wirtschaftsinformatik (B.Sc. und M.Sc.) an den Universit\u00e4ten Stuttgart und Hohenheim bis 2013. Seit Oktober 2011 ist er akademischer Mitarbeiter am Lehrstuhl f\u00fcr Wirtschaftsinformatik 1 an der Universit\u00e4t Stuttgart und promoviert zum Informationsaustausch im Kontext des Additive-Manufacturing-Prozesses.Kathrin Pf\u00e4hler ist seit Mai 2017 Doktorandin der Graduate School of Excellence advanced Manufacturing Engineering (GSaME) der Universit\u00e4t Stuttgart in der Kooperation mit dem Lehrstuhl f\u00fcr Wirtschaftsinformatik 1 und promoviert zum Thema Gesch\u00e4ftsmodelle und Informationsmanagement f\u00fcr die Ersatzteilversorgung im Kontext von Additive Manufacturing. Zuvor studierte sie technisch orientierte BWL (B.Sc. und M.Sc.) an der Universit\u00e4t Stuttgart und schloss das Studium 2017 ab. \/\/ Stand der Angaben: Ver\u00f6ffentlichungsjahr der Publikation", "2c06df6dde78421e8d5c8bbf1301d08e": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "2c06df6dde78421e8d5c8bbf1301d08e": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "2c06df6dde78421e8d5c8bbf1301d08e": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "9783956631726", "evk2018" ], "2c06df6dde78421e8d5c8bbf1301d08e": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0 }, "fields": { "displayGroup": [ "2b8723f761383894d4ee6b6030f1b0ac" ] }, "sort": [ 1534204800000, "1545d2d144cebfc187f3e048554b0000" ] } ] }, "aggregations": { "total-count": { "value": 1 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	1.89 ms	Request: {"index":"sw6_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"35770e9aa5af44e5b861a83b1d6baca3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"7c52c651b5187d188173a0dea67d3f0a"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule822de89035684d7aa84117bfcdf52388_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefeb00d8c2af4452d81c47abe2f7153c1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d4031d9337369823dfcb22b7e8815_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d40388fbb7aa59604576622673163_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01960ae265cc7604946134c60b799bda_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule25e989c658ce4172af0218fee7ea8acf_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"} Item count: View formatted request View formatted response View query backtrace POST https://localhost:9200/sw6_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "35770e9aa5af44e5b861a83b1d6baca3" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "7c52c651b5187d188173a0dea67d3f0a" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule822de89035684d7aa84117bfcdf52388_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulefeb00d8c2af4452d81c47abe2f7153c1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d4031d9337369823dfcb22b7e8815_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018d40388fbb7aa59604576622673163_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01960ae265cc7604946134c60b799bda_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule25e989c658ce4172af0218fee7ea8acf_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" } { "took": 0, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 1, "rating": { "value": 0.0 } }, "properties": { "doc_count": 0, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "price": { "count": 1, "min": 0.0, "max": 0.0, "avg": 0.0, "sum": 0.0 }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw6_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"35770e9aa5af44e5b861a83b1d6baca3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"7c52c651b5187d188173a0dea67d3f0a"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"releaseDate":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

Item count: 1
View formatted request View formatted response View query backtrace


                                    POST https://localhost:9200/sw6_product/_search?search_type=query_then_fetch&track_total_hits=1
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "35770e9aa5af44e5b861a83b1d6baca3"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "7c52c651b5187d188173a0dea67d3f0a"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "releaseDate": {
                "order": "DESC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 12,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 1,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw6_product_1737381753",
                "_id": "1545d2d144cebfc187f3e048554b0000",
                "_score": null,
                "_source": {
                    "id": "1545d2d144cebfc187f3e048554b0000",
                    "autoIncrement": 1837.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "35770e9aa5af44e5b861a83b1d6baca3"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "194637",
                    "ean": "9783956631726",
                    "displayGroup": "2b8723f761383894d4ee6b6030f1b0ac",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": "2018-08-14T00:00:00+00:00",
                    "createdAt": "2024-08-20T15:53:41+00:00",
                    "categoryTree": [
                        "f6b181deb3dd4dbc8b320b168682ed17",
                        "d5e9e43a77b65b05b94c88fd47c566a9",
                        "7c52c651b5187d188173a0dea67d3f0a"
                    ],
                    "categoriesRo": [
                        {
                            "id": "f6b181deb3dd4dbc8b320b168682ed17",
                            "_count": 1
                        },
                        {
                            "id": "d5e9e43a77b65b05b94c88fd47c566a9",
                            "_count": 1
                        },
                        {
                            "id": "7c52c651b5187d188173a0dea67d3f0a",
                            "_count": 1
                        }
                    ],
                    "taxId": "24943afd50de4c6685bf677bf45f057e",
                    "tags": [
                        {
                            "id": "019223c76cff7422949898b06ad10e6c",
                            "name": "Steinbeis Engineering Studien",
                            "_count": 1
                        }
                    ],
                    "parentId": null,
                    "coverId": "019174aa7c307086a7278619d0deed8d",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "7c52c651b5187d188173a0dea67d3f0a",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Steinbeis Engineering Studie"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "2c06df6dde78421e8d5c8bbf1301d08e": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "7c52c651b5187d188173a0dea67d3f0a"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [
                        "019223c76cff7422949898b06ad10e6c"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "custom_books_isbn": "978-3-95663-172-6",
                            "custom_books_author": "Simon Hiller, Michelle Moisa, Dominik Morar, Kathrin Pf\u00e4hler",
                            "custom_books_shortdesc": "Wertsch\u00f6pfungsszenarien f\u00fcr die erfolgreiche Implementierung von Additive Manufacturing",
                            "custom_books_medium": "Softcover, s\/w",
                            "custom_books_pages": "40 S.",
                            "custom_books_language": "dt."
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Leitfaden Additive Manufacturing",
                        "2c06df6dde78421e8d5c8bbf1301d08e": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Blick ins BuchDer Leitfaden Additive Manufacturing (AM) liefert Handlungsempfehlungen zur Implementierung von AM im industriellen Einsatz. Die additive Fertigung wird darin in Form von vier unterschiedlichen Wertsch\u00f6pfungsszenarien dargestellt und in Betreibermodellen aufgezeigt. Eine Unterscheidung erfolgt in den unternehmensinternen oder -externen Wertsch\u00f6pfungsphasen. In diesem Leitfaden werden die folgenden Fragen zur Nutzung der additiven Fertigung beantwortet:Unter welchen Rahmenbedingungen lassen sich die Eigenschaften von Additive Manufacturing in bestehenden Wertsch\u00f6pfungsketten nutzen?Welche Herangehensweisen zur Implementierung von Additive Manufacturing existieren f\u00fcr produzierende Unternehmen?Welche Schlussfolgerungen lassen sich f\u00fcr Additive-Manufacturing-Betreibermodelle ziehen?Des Weiteren werden zum besseren Verst\u00e4ndnis die Grundlagen des Additive Manufacturing dargelegt. Hierbei wird einf\u00fchrend ein \u00dcberblick \u00fcber die verschiedenen Verfahren, deren Charakteristika sowie deren Potenziale gegeben.Simon Hiller arbeitet als wissenschaftlicher Mitarbeiter am Ferdinand-Steinbeis-Institut, im Forschungsbereich Industrial Internet &amp; Industrie 4.0 speziell im Themengebiet Additive Manufacturing. Er studierte Medizintechnik (B.Sc.) im Kooperationsstudiengang der Universit\u00e4t Stuttgart und der Universit\u00e4t T\u00fcbingen bis 2015. Anschlie\u00dfend absolvierte er den Studiengang Master of Business Engineering (MBE) an der Steinbeis-Hochschule und schloss diesen 2017 ab.Michelle Moisa ist Doktorandin an der Graduate School of Excellence advanced Manufacturing Engineering (GSaME) der Universit\u00e4t Stuttgart in Kooperation mit dem Lehrstuhl f\u00fcr Wirtschaftsinformatik 1 zum Thema Capabilities im Kontext von Additive Manufacturing. Zuvor studierte sie Wirtschaftsinformatik an der Dualen Hochschule Baden-W\u00fcrttemberg in Mosbach (B.Sc.) sowie an den Universit\u00e4ten Hohenheim und Stuttgart (M.Sc.).Dominik Morar studierte Wirtschaftsinformatik (B.Sc. und M.Sc.) an den Universit\u00e4ten Stuttgart und Hohenheim bis 2013. Seit Oktober 2011 ist er akademischer Mitarbeiter am Lehrstuhl f\u00fcr Wirtschaftsinformatik 1 an der Universit\u00e4t Stuttgart und promoviert zum Informationsaustausch im Kontext des Additive-Manufacturing-Prozesses.Kathrin Pf\u00e4hler ist seit Mai 2017 Doktorandin der Graduate School of Excellence advanced Manufacturing Engineering (GSaME) der Universit\u00e4t Stuttgart in der Kooperation mit dem Lehrstuhl f\u00fcr Wirtschaftsinformatik 1 und promoviert zum Thema Gesch\u00e4ftsmodelle und Informationsmanagement f\u00fcr die Ersatzteilversorgung im Kontext von Additive Manufacturing. Zuvor studierte sie technisch orientierte BWL (B.Sc. und M.Sc.) an der Universit\u00e4t Stuttgart und schloss das Studium 2017 ab. \/\/ Stand der Angaben: Ver\u00f6ffentlichungsjahr der Publikation",
                        "2c06df6dde78421e8d5c8bbf1301d08e": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "2c06df6dde78421e8d5c8bbf1301d08e": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "2c06df6dde78421e8d5c8bbf1301d08e": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "9783956631726",
                            "evk2018"
                        ],
                        "2c06df6dde78421e8d5c8bbf1301d08e": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.0
                },
                "fields": {
                    "displayGroup": [
                        "2b8723f761383894d4ee6b6030f1b0ac"
                    ]
                },
                "sort": [
                    1534204800000,
                    "1545d2d144cebfc187f3e048554b0000"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 1
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

1.89 ms

Request:

{"index":"sw6_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"35770e9aa5af44e5b861a83b1d6baca3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"7c52c651b5187d188173a0dea67d3f0a"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule822de89035684d7aa84117bfcdf52388_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulefeb00d8c2af4452d81c47abe2f7153c1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d4031d9337369823dfcb22b7e8815_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d40388fbb7aa59604576622673163_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01960ae265cc7604946134c60b799bda_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule25e989c658ce4172af0218fee7ea8acf_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"}

Item count:
View formatted request View formatted response View query backtrace


                                    POST https://localhost:9200/sw6_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "35770e9aa5af44e5b861a83b1d6baca3"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "7c52c651b5187d188173a0dea67d3f0a"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "id": "cheapest_price",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule822de89035684d7aa84117bfcdf52388_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulefeb00d8c2af4452d81c47abe2f7153c1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d4031d9337369823dfcb22b7e8815_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018d40388fbb7aa59604576622673163_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01960ae265cc7604946134c60b799bda_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule25e989c658ce4172af0218fee7ea8acf_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"
}


                                    {
    "took": 0,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 1,
            "rating": {
                "value": 0.0
            }
        },
        "properties": {
            "doc_count": 0,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "price": {
            "count": 1,
            "min": 0.0,
            "max": 0.0,
            "avg": 0.0,
            "sum": 0.0
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": []
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

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	12
sw6_admin-order-listing_1729458351	open	3, 3	34
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	1480
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

Symfony Profiler

GET https://dev.steinbeis-edition.de/navigation/7c52c651b5187d188173a0dea67d3f0a

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices