Symfony Profiler

Query Metrics

4.00 ms Query Time

1 Node(s)

23 Indices

Queries

#▲ Execution Time Info

4.94 ms

#▲	Execution Time	Info
1	4.94 ms	Request: {"index":"sw_all4team_product","body":[{"index":{"_id":"018cddccd9a673a09ded1abf7d15e0d1"}},{"id":"018cddccd9a673a09ded1abf7d15e0d1","autoIncrement":1231202.0,"ratingAverage":0.0,"active":true,"available":true,"isCloseout":true,"shippingFree":false,"markAsTopseller":false,"visibilities":[{"_count":1,"visibility":30,"salesChannelId":"fe2c2495fdbc46908e05bdaf8ccc419b"},{"_count":1,"visibility":40,"salesChannelId":"a4d331012b00410ab817a4dd8c7bc7f0"}],"availableStock":50,"productNumber":"1072225K16995017","ean":"4062075150239","displayGroup":"e1a323f81befdf50e56ca849bc4ee6c7","sales":0,"stock":50,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"69126f5efcab45738b242009148aca51","manufacturerNumber":"1072225K","releaseDate":"2025-03-13T15:48:37+00:00","createdAt":"2024-01-06T08:03:59+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997685f47711d92351896a28f6110","01899769fec370a5b5e1928c86c411de","2ed97bbb21a840a4a74174028a008a89","018997bf6f5072778844c1f04f26c4f0","472042bbc4ab42cea38631c70b02e657","8bee7ab7cacf45d78a47947b902095b9"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997685f47711d92351896a28f6110","_count":1},{"id":"01899769fec370a5b5e1928c86c411de","_count":1},{"id":"2ed97bbb21a840a4a74174028a008a89","_count":1},{"id":"018997bf6f5072778844c1f04f26c4f0","_count":1},{"id":"472042bbc4ab42cea38631c70b02e657","_count":1},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"018cddccd9a773d28d067b214587b8ab","name":"all4team","_count":1},{"id":"018cddccd9a773d28d067b21467654a6","name":"Teamsportbekleidung","_count":1}],"parentId":"018c7e510b2670d7be29c476e119bab2","coverId":"019bc6c8016a73f19c97e849486d0b80","childCount":0,"categories":[{"id":"472042bbc4ab42cea38631c70b02e657","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Tiefbau"}},{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"01899769fec370a5b5e1928c86c411de","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Bekleidung"}},{"id":"018997bf6f5072778844c1f04f26c4f0","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Sweatshirts"}},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"trikot-meister.de"}}],"manufacturer":{"id":"69126f5efcab45738b242009148aca51","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f32b703288aad57690802852","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Kinder"}},{"id":"01896411e3007292bbf291a9837a8cc8","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fu\u00dfball"}},{"id":"01896412f46a7164bc08cd3d2a5052cc","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Sweatshirts lg.Arm Ki"}},{"id":"018bbe13bf4971378f6c9737de6890aa","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"rot"}}],"options":[{"id":"37347e78acc44de0a2b07896ba5339c0","_count":1,"groupId":"2d5f0f5a4f614de793262c22e833d545","group":{"id":"2d5f0f5a4f614de793262c22e833d545","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"116"}},{"id":"86bdb1b150dc41429d05122ba525479e","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"250950 red\/black"}}],"categoryIds":["01899769fec370a5b5e1928c86c411de","018997bf6f5072778844c1f04f26c4f0","23756acc3fa84304877fe50205f7585a","472042bbc4ab42cea38631c70b02e657","8bee7ab7cacf45d78a47947b902095b9"],"optionIds":["37347e78acc44de0a2b07896ba5339c0","86bdb1b150dc41429d05122ba525479e"],"propertyIds":["018963e5f32b703288aad57690802852","01896411e3007292bbf291a9837a8cc8","01896412f46a7164bc08cd3d2a5052cc","018bbe13bf4971378f6c9737de6890aa"],"tagIds":["018cddccd9a773d28d067b214587b8ab","018cddccd9a773d28d067b21467654a6"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":true,"custom_products_update_stock":550.0,"custom_products_update_updatedate":"2024-06-17 06:07:48.000","custom_products_update_planned_stock":0.0,"custom_products_update_incoming_stock":0.0,"allforteam_designer_extension_product_assigned_configuration":"fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9","kilb_productdesigner_product_fieldset_assigned_configuration":"fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9","purchasable_item":false,"kilb_productdesigner_product_fieldset_typ":6.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA Six Wings Sweatshirt","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Jede Menge Kombinationsm\u00f6glichkeiten! Das Sweatshirt vereint volle Funktion mit weichem Baumwollgef\u00fchl.","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA SIX WINGS sweatshirt 250950 red\/black 116","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Fussball Oberteile","Sweatshirts","Sweatshirts lg.Arm Ki","Teamsportartikel","Sportartikel","1072225K16995017","1072225K","1072225K169","4062075150239","ERIMA","SIX WINGS sweatshirt 250950 red\/black 116"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":22.5,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":18.907563025210084,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":49.99,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":49.99}]} Item count: View formatted request View formatted response View query backtrace POST http://localhost:9200/_bulk Accept: application/json Content-Type: application/json [ { "index": { "_id": "018cddccd9a673a09ded1abf7d15e0d1" } }, { "id": "018cddccd9a673a09ded1abf7d15e0d1", "autoIncrement": 1231202.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "fe2c2495fdbc46908e05bdaf8ccc419b" }, { "_count": 1, "visibility": 40, "salesChannelId": "a4d331012b00410ab817a4dd8c7bc7f0" } ], "availableStock": 50, "productNumber": "1072225K16995017", "ean": "4062075150239", "displayGroup": "e1a323f81befdf50e56ca849bc4ee6c7", "sales": 0, "stock": 50, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "69126f5efcab45738b242009148aca51", "manufacturerNumber": "1072225K", "releaseDate": "2025-03-13T15:48:37+00:00", "createdAt": "2024-01-06T08:03:59+00:00", "categoryTree": [ "e488bb219113483a84172a9a5c446883", "23756acc3fa84304877fe50205f7585a", "018997685f47711d92351896a28f6110", "01899769fec370a5b5e1928c86c411de", "2ed97bbb21a840a4a74174028a008a89", "018997bf6f5072778844c1f04f26c4f0", "472042bbc4ab42cea38631c70b02e657", "8bee7ab7cacf45d78a47947b902095b9" ], "categoriesRo": [ { "id": "e488bb219113483a84172a9a5c446883", "_count": 1 }, { "id": "23756acc3fa84304877fe50205f7585a", "_count": 1 }, { "id": "018997685f47711d92351896a28f6110", "_count": 1 }, { "id": "01899769fec370a5b5e1928c86c411de", "_count": 1 }, { "id": "2ed97bbb21a840a4a74174028a008a89", "_count": 1 }, { "id": "018997bf6f5072778844c1f04f26c4f0", "_count": 1 }, { "id": "472042bbc4ab42cea38631c70b02e657", "_count": 1 }, { "id": "8bee7ab7cacf45d78a47947b902095b9", "_count": 1 } ], "taxId": "572b2f69c09840c6a0c776d306ea2966", "tags": [ { "id": "018cddccd9a773d28d067b214587b8ab", "name": "all4team", "_count": 1 }, { "id": "018cddccd9a773d28d067b21467654a6", "name": "Teamsportbekleidung", "_count": 1 } ], "parentId": "018c7e510b2670d7be29c476e119bab2", "coverId": "019bc6c8016a73f19c97e849486d0b80", "childCount": 0, "categories": [ { "id": "472042bbc4ab42cea38631c70b02e657", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tiefbau" } }, { "id": "23756acc3fa84304877fe50205f7585a", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Teamsport" } }, { "id": "01899769fec370a5b5e1928c86c411de", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bekleidung" } }, { "id": "018997bf6f5072778844c1f04f26c4f0", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sweatshirts" } }, { "id": "8bee7ab7cacf45d78a47947b902095b9", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "trikot-meister.de" } } ], "manufacturer": { "id": "69126f5efcab45738b242009148aca51", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERIMA", "87c74cec26c54ed8867507ed00a0983a": null }, "_count": 1 }, "properties": [ { "id": "018963e5f32b703288aad57690802852", "_count": 1, "groupId": "018aeef8f32470db855643b76c70939d", "group": { "id": "018aeef8f32470db855643b76c70939d", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinder" } }, { "id": "01896411e3007292bbf291a9837a8cc8", "_count": 1, "groupId": "018963e5e9c372ae844959c17e5007bd", "group": { "id": "018963e5e9c372ae844959c17e5007bd", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fu\u00dfball" } }, { "id": "01896412f46a7164bc08cd3d2a5052cc", "_count": 1, "groupId": "018aeef91bde71e8be1f4167e2de9a86", "group": { "id": "018aeef91bde71e8be1f4167e2de9a86", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sweatshirts lg.Arm Ki" } }, { "id": "018bbe13bf4971378f6c9737de6890aa", "_count": 1, "groupId": "018ae9d28fa471979e520453984303f8", "group": { "id": "018ae9d28fa471979e520453984303f8", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "rot" } } ], "options": [ { "id": "37347e78acc44de0a2b07896ba5339c0", "_count": 1, "groupId": "2d5f0f5a4f614de793262c22e833d545", "group": { "id": "2d5f0f5a4f614de793262c22e833d545", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "116" } }, { "id": "86bdb1b150dc41429d05122ba525479e", "_count": 1, "groupId": "8b2821798c574ee187d1c58e63d4d424", "group": { "id": "8b2821798c574ee187d1c58e63d4d424", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "250950 red\/black" } } ], "categoryIds": [ "01899769fec370a5b5e1928c86c411de", "018997bf6f5072778844c1f04f26c4f0", "23756acc3fa84304877fe50205f7585a", "472042bbc4ab42cea38631c70b02e657", "8bee7ab7cacf45d78a47947b902095b9" ], "optionIds": [ "37347e78acc44de0a2b07896ba5339c0", "86bdb1b150dc41429d05122ba525479e" ], "propertyIds": [ "018963e5f32b703288aad57690802852", "01896411e3007292bbf291a9837a8cc8", "01896412f46a7164bc08cd3d2a5052cc", "018bbe13bf4971378f6c9737de6890aa" ], "tagIds": [ "018cddccd9a773d28d067b214587b8ab", "018cddccd9a773d28d067b21467654a6" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "sample_order_six_flag": true, "custom_products_update_stock": 550.0, "custom_products_update_updatedate": "2024-06-17 06:07:48.000", "custom_products_update_planned_stock": 0.0, "custom_products_update_incoming_stock": 0.0, "allforteam_designer_extension_product_assigned_configuration": "fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9", "kilb_productdesigner_product_fieldset_assigned_configuration": "fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9", "purchasable_item": false, "kilb_productdesigner_product_fieldset_typ": 6.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERIMA Six Wings Sweatshirt", "87c74cec26c54ed8867507ed00a0983a": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jede Menge Kombinationsm\u00f6glichkeiten! Das Sweatshirt vereint volle Funktion mit weichem Baumwollgef\u00fchl.", "87c74cec26c54ed8867507ed00a0983a": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERIMA SIX WINGS sweatshirt 250950 red\/black 116", "87c74cec26c54ed8867507ed00a0983a": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "87c74cec26c54ed8867507ed00a0983a": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [ "Fussball Oberteile", "Sweatshirts", "Sweatshirts lg.Arm Ki", "Teamsportartikel", "Sportartikel", "1072225K16995017", "1072225K", "1072225K169", "4062075150239", "ERIMA", "SIX WINGS sweatshirt 250950 red\/black 116" ], "87c74cec26c54ed8867507ed00a0983a": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.5, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.907563025210084, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 49.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 49.99 } ] `{ "took": 3, "errors": false, "items": [ { "index": { "_index": "sw_all4team_product_1716336301", "_id": "018cddccd9a673a09ded1abf7d15e0d1", "_version": 1669, "result": "updated", "_shards": { "total": 4, "successful": 1, "failed": 0 }, "_seq_no": 58910441, "_primary_term": 5, "status": 200 } } ] }` `Shopware\Elasticsearch\Framework\Indexing\ElasticsearchIndexer:handleIndexingMessage`

Request:

{"index":"sw_all4team_product","body":[{"index":{"_id":"018cddccd9a673a09ded1abf7d15e0d1"}},{"id":"018cddccd9a673a09ded1abf7d15e0d1","autoIncrement":1231202.0,"ratingAverage":0.0,"active":true,"available":true,"isCloseout":true,"shippingFree":false,"markAsTopseller":false,"visibilities":[{"_count":1,"visibility":30,"salesChannelId":"fe2c2495fdbc46908e05bdaf8ccc419b"},{"_count":1,"visibility":40,"salesChannelId":"a4d331012b00410ab817a4dd8c7bc7f0"}],"availableStock":50,"productNumber":"1072225K16995017","ean":"4062075150239","displayGroup":"e1a323f81befdf50e56ca849bc4ee6c7","sales":0,"stock":50,"weight":0.0,"width":0.0,"length":0.0,"height":0.0,"manufacturerId":"69126f5efcab45738b242009148aca51","manufacturerNumber":"1072225K","releaseDate":"2025-03-13T15:48:37+00:00","createdAt":"2024-01-06T08:03:59+00:00","categoryTree":["e488bb219113483a84172a9a5c446883","23756acc3fa84304877fe50205f7585a","018997685f47711d92351896a28f6110","01899769fec370a5b5e1928c86c411de","2ed97bbb21a840a4a74174028a008a89","018997bf6f5072778844c1f04f26c4f0","472042bbc4ab42cea38631c70b02e657","8bee7ab7cacf45d78a47947b902095b9"],"categoriesRo":[{"id":"e488bb219113483a84172a9a5c446883","_count":1},{"id":"23756acc3fa84304877fe50205f7585a","_count":1},{"id":"018997685f47711d92351896a28f6110","_count":1},{"id":"01899769fec370a5b5e1928c86c411de","_count":1},{"id":"2ed97bbb21a840a4a74174028a008a89","_count":1},{"id":"018997bf6f5072778844c1f04f26c4f0","_count":1},{"id":"472042bbc4ab42cea38631c70b02e657","_count":1},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1}],"taxId":"572b2f69c09840c6a0c776d306ea2966","tags":[{"id":"018cddccd9a773d28d067b214587b8ab","name":"all4team","_count":1},{"id":"018cddccd9a773d28d067b21467654a6","name":"Teamsportbekleidung","_count":1}],"parentId":"018c7e510b2670d7be29c476e119bab2","coverId":"019bc6c8016a73f19c97e849486d0b80","childCount":0,"categories":[{"id":"472042bbc4ab42cea38631c70b02e657","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Tiefbau"}},{"id":"23756acc3fa84304877fe50205f7585a","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Teamsport"}},{"id":"01899769fec370a5b5e1928c86c411de","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Bekleidung"}},{"id":"018997bf6f5072778844c1f04f26c4f0","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Sweatshirts"}},{"id":"8bee7ab7cacf45d78a47947b902095b9","_count":1,"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"trikot-meister.de"}}],"manufacturer":{"id":"69126f5efcab45738b242009148aca51","name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA","87c74cec26c54ed8867507ed00a0983a":null},"_count":1},"properties":[{"id":"018963e5f32b703288aad57690802852","_count":1,"groupId":"018aeef8f32470db855643b76c70939d","group":{"id":"018aeef8f32470db855643b76c70939d","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Kinder"}},{"id":"01896411e3007292bbf291a9837a8cc8","_count":1,"groupId":"018963e5e9c372ae844959c17e5007bd","group":{"id":"018963e5e9c372ae844959c17e5007bd","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Fu\u00dfball"}},{"id":"01896412f46a7164bc08cd3d2a5052cc","_count":1,"groupId":"018aeef91bde71e8be1f4167e2de9a86","group":{"id":"018aeef91bde71e8be1f4167e2de9a86","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Sweatshirts lg.Arm Ki"}},{"id":"018bbe13bf4971378f6c9737de6890aa","_count":1,"groupId":"018ae9d28fa471979e520453984303f8","group":{"id":"018ae9d28fa471979e520453984303f8","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"rot"}}],"options":[{"id":"37347e78acc44de0a2b07896ba5339c0","_count":1,"groupId":"2d5f0f5a4f614de793262c22e833d545","group":{"id":"2d5f0f5a4f614de793262c22e833d545","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"116"}},{"id":"86bdb1b150dc41429d05122ba525479e","_count":1,"groupId":"8b2821798c574ee187d1c58e63d4d424","group":{"id":"8b2821798c574ee187d1c58e63d4d424","_count":1},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"250950 red\/black"}}],"categoryIds":["01899769fec370a5b5e1928c86c411de","018997bf6f5072778844c1f04f26c4f0","23756acc3fa84304877fe50205f7585a","472042bbc4ab42cea38631c70b02e657","8bee7ab7cacf45d78a47947b902095b9"],"optionIds":["37347e78acc44de0a2b07896ba5339c0","86bdb1b150dc41429d05122ba525479e"],"propertyIds":["018963e5f32b703288aad57690802852","01896411e3007292bbf291a9837a8cc8","01896412f46a7164bc08cd3d2a5052cc","018bbe13bf4971378f6c9737de6890aa"],"tagIds":["018cddccd9a773d28d067b214587b8ab","018cddccd9a773d28d067b21467654a6"],"states":["is-physical"],"customFields":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"sample_order_six_flag":true,"custom_products_update_stock":550.0,"custom_products_update_updatedate":"2024-06-17 06:07:48.000","custom_products_update_planned_stock":0.0,"custom_products_update_incoming_stock":0.0,"allforteam_designer_extension_product_assigned_configuration":"fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9","kilb_productdesigner_product_fieldset_assigned_configuration":"fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9","purchasable_item":false,"kilb_productdesigner_product_fieldset_typ":6.0}},"name":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA Six Wings Sweatshirt","87c74cec26c54ed8867507ed00a0983a":null},"description":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"Jede Menge Kombinationsm\u00f6glichkeiten! Das Sweatshirt vereint volle Funktion mit weichem Baumwollgef\u00fchl.","87c74cec26c54ed8867507ed00a0983a":null},"metaTitle":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":"ERIMA SIX WINGS sweatshirt 250950 red\/black 116","87c74cec26c54ed8867507ed00a0983a":null},"metaDescription":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":null,"87c74cec26c54ed8867507ed00a0983a":null},"customSearchKeywords":{"2fbb5fe2e29a4d70aa5854ce7ce3e20b":["Fussball Oberteile","Sweatshirts","Sweatshirts lg.Arm Ki","Teamsportartikel","Sportartikel","1072225K16995017","1072225K","1072225K169","4062075150239","ERIMA","SIX WINGS sweatshirt 250950 red\/black 116"],"87c74cec26c54ed8867507ed00a0983a":null},"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross":22.5,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net":18.907563025210084,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage":49.99,"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage":49.99}]}

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


                                    POST http://localhost:9200/_bulk
    Accept: application/json
    Content-Type: application/json

        [
    {
        "index": {
            "_id": "018cddccd9a673a09ded1abf7d15e0d1"
        }
    },
    {
        "id": "018cddccd9a673a09ded1abf7d15e0d1",
        "autoIncrement": 1231202.0,
        "ratingAverage": 0.0,
        "active": true,
        "available": true,
        "isCloseout": true,
        "shippingFree": false,
        "markAsTopseller": false,
        "visibilities": [
            {
                "_count": 1,
                "visibility": 30,
                "salesChannelId": "fe2c2495fdbc46908e05bdaf8ccc419b"
            },
            {
                "_count": 1,
                "visibility": 40,
                "salesChannelId": "a4d331012b00410ab817a4dd8c7bc7f0"
            }
        ],
        "availableStock": 50,
        "productNumber": "1072225K16995017",
        "ean": "4062075150239",
        "displayGroup": "e1a323f81befdf50e56ca849bc4ee6c7",
        "sales": 0,
        "stock": 50,
        "weight": 0.0,
        "width": 0.0,
        "length": 0.0,
        "height": 0.0,
        "manufacturerId": "69126f5efcab45738b242009148aca51",
        "manufacturerNumber": "1072225K",
        "releaseDate": "2025-03-13T15:48:37+00:00",
        "createdAt": "2024-01-06T08:03:59+00:00",
        "categoryTree": [
            "e488bb219113483a84172a9a5c446883",
            "23756acc3fa84304877fe50205f7585a",
            "018997685f47711d92351896a28f6110",
            "01899769fec370a5b5e1928c86c411de",
            "2ed97bbb21a840a4a74174028a008a89",
            "018997bf6f5072778844c1f04f26c4f0",
            "472042bbc4ab42cea38631c70b02e657",
            "8bee7ab7cacf45d78a47947b902095b9"
        ],
        "categoriesRo": [
            {
                "id": "e488bb219113483a84172a9a5c446883",
                "_count": 1
            },
            {
                "id": "23756acc3fa84304877fe50205f7585a",
                "_count": 1
            },
            {
                "id": "018997685f47711d92351896a28f6110",
                "_count": 1
            },
            {
                "id": "01899769fec370a5b5e1928c86c411de",
                "_count": 1
            },
            {
                "id": "2ed97bbb21a840a4a74174028a008a89",
                "_count": 1
            },
            {
                "id": "018997bf6f5072778844c1f04f26c4f0",
                "_count": 1
            },
            {
                "id": "472042bbc4ab42cea38631c70b02e657",
                "_count": 1
            },
            {
                "id": "8bee7ab7cacf45d78a47947b902095b9",
                "_count": 1
            }
        ],
        "taxId": "572b2f69c09840c6a0c776d306ea2966",
        "tags": [
            {
                "id": "018cddccd9a773d28d067b214587b8ab",
                "name": "all4team",
                "_count": 1
            },
            {
                "id": "018cddccd9a773d28d067b21467654a6",
                "name": "Teamsportbekleidung",
                "_count": 1
            }
        ],
        "parentId": "018c7e510b2670d7be29c476e119bab2",
        "coverId": "019bc6c8016a73f19c97e849486d0b80",
        "childCount": 0,
        "categories": [
            {
                "id": "472042bbc4ab42cea38631c70b02e657",
                "_count": 1,
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tiefbau"
                }
            },
            {
                "id": "23756acc3fa84304877fe50205f7585a",
                "_count": 1,
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Teamsport"
                }
            },
            {
                "id": "01899769fec370a5b5e1928c86c411de",
                "_count": 1,
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bekleidung"
                }
            },
            {
                "id": "018997bf6f5072778844c1f04f26c4f0",
                "_count": 1,
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sweatshirts"
                }
            },
            {
                "id": "8bee7ab7cacf45d78a47947b902095b9",
                "_count": 1,
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "trikot-meister.de"
                }
            }
        ],
        "manufacturer": {
            "id": "69126f5efcab45738b242009148aca51",
            "name": {
                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERIMA",
                "87c74cec26c54ed8867507ed00a0983a": null
            },
            "_count": 1
        },
        "properties": [
            {
                "id": "018963e5f32b703288aad57690802852",
                "_count": 1,
                "groupId": "018aeef8f32470db855643b76c70939d",
                "group": {
                    "id": "018aeef8f32470db855643b76c70939d",
                    "_count": 1
                },
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinder"
                }
            },
            {
                "id": "01896411e3007292bbf291a9837a8cc8",
                "_count": 1,
                "groupId": "018963e5e9c372ae844959c17e5007bd",
                "group": {
                    "id": "018963e5e9c372ae844959c17e5007bd",
                    "_count": 1
                },
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fu\u00dfball"
                }
            },
            {
                "id": "01896412f46a7164bc08cd3d2a5052cc",
                "_count": 1,
                "groupId": "018aeef91bde71e8be1f4167e2de9a86",
                "group": {
                    "id": "018aeef91bde71e8be1f4167e2de9a86",
                    "_count": 1
                },
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sweatshirts lg.Arm Ki"
                }
            },
            {
                "id": "018bbe13bf4971378f6c9737de6890aa",
                "_count": 1,
                "groupId": "018ae9d28fa471979e520453984303f8",
                "group": {
                    "id": "018ae9d28fa471979e520453984303f8",
                    "_count": 1
                },
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "rot"
                }
            }
        ],
        "options": [
            {
                "id": "37347e78acc44de0a2b07896ba5339c0",
                "_count": 1,
                "groupId": "2d5f0f5a4f614de793262c22e833d545",
                "group": {
                    "id": "2d5f0f5a4f614de793262c22e833d545",
                    "_count": 1
                },
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "116"
                }
            },
            {
                "id": "86bdb1b150dc41429d05122ba525479e",
                "_count": 1,
                "groupId": "8b2821798c574ee187d1c58e63d4d424",
                "group": {
                    "id": "8b2821798c574ee187d1c58e63d4d424",
                    "_count": 1
                },
                "name": {
                    "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "250950 red\/black"
                }
            }
        ],
        "categoryIds": [
            "01899769fec370a5b5e1928c86c411de",
            "018997bf6f5072778844c1f04f26c4f0",
            "23756acc3fa84304877fe50205f7585a",
            "472042bbc4ab42cea38631c70b02e657",
            "8bee7ab7cacf45d78a47947b902095b9"
        ],
        "optionIds": [
            "37347e78acc44de0a2b07896ba5339c0",
            "86bdb1b150dc41429d05122ba525479e"
        ],
        "propertyIds": [
            "018963e5f32b703288aad57690802852",
            "01896411e3007292bbf291a9837a8cc8",
            "01896412f46a7164bc08cd3d2a5052cc",
            "018bbe13bf4971378f6c9737de6890aa"
        ],
        "tagIds": [
            "018cddccd9a773d28d067b214587b8ab",
            "018cddccd9a773d28d067b21467654a6"
        ],
        "states": [
            "is-physical"
        ],
        "customFields": {
            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                "sample_order_six_flag": true,
                "custom_products_update_stock": 550.0,
                "custom_products_update_updatedate": "2024-06-17 06:07:48.000",
                "custom_products_update_planned_stock": 0.0,
                "custom_products_update_incoming_stock": 0.0,
                "allforteam_designer_extension_product_assigned_configuration": "fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9",
                "kilb_productdesigner_product_fieldset_assigned_configuration": "fa5a518e796e4b308163c67b3ad4abc0,133f016161684ee1811ae72ed9ccc952,ecc4673adb984bf787080373f3f20dca,3627bd136040432aaa1924f1db2a02f9",
                "purchasable_item": false,
                "kilb_productdesigner_product_fieldset_typ": 6.0
            }
        },
        "name": {
            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERIMA Six Wings Sweatshirt",
            "87c74cec26c54ed8867507ed00a0983a": null
        },
        "description": {
            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jede Menge Kombinationsm\u00f6glichkeiten! Das Sweatshirt vereint volle Funktion mit weichem Baumwollgef\u00fchl.",
            "87c74cec26c54ed8867507ed00a0983a": null
        },
        "metaTitle": {
            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ERIMA SIX WINGS sweatshirt 250950 red\/black 116",
            "87c74cec26c54ed8867507ed00a0983a": null
        },
        "metaDescription": {
            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
            "87c74cec26c54ed8867507ed00a0983a": null
        },
        "customSearchKeywords": {
            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                "Fussball Oberteile",
                "Sweatshirts",
                "Sweatshirts lg.Arm Ki",
                "Teamsportartikel",
                "Sportartikel",
                "1072225K16995017",
                "1072225K",
                "1072225K169",
                "4062075150239",
                "ERIMA",
                "SIX WINGS sweatshirt 250950 red\/black 116"
            ],
            "87c74cec26c54ed8867507ed00a0983a": null
        },
        "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.5,
        "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.907563025210084,
        "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 49.99,
        "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 49.99
    }
]


                                    {
    "took": 3,
    "errors": false,
    "items": [
        {
            "index": {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018cddccd9a673a09ded1abf7d15e0d1",
                "_version": 1669,
                "result": "updated",
                "_shards": {
                    "total": 4,
                    "successful": 1,
                    "failed": 0
                },
                "_seq_no": 58910441,
                "_primary_term": 5,
                "status": 200
            }
        }
    ]
}

Shopware\Elasticsearch\Framework\Indexing\ElasticsearchIndexer:handleIndexingMessage

Cluster Status

{
    "cluster_name": "opensearch",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 46,
    "active_shards": 46,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 108,
    "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": 29.87012987012987
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
top_queries-2026.01.10-65760	open	1, 1	13
top_queries-2026.01.11-65761	open	1, 1	13
sw_all4team_product_1716941102	open	3, 3	5216241
top_queries-2026.01.09-65738	open	1, 1	13
sw_all4team_product_1717545902	open	3, 3	5217183
sw_all4team_product_1717113901	open	3, 3	5216814
sw_all4team_product_1717027502	open	3, 3	5216573
.opendistro_security	open	1, 0	10
sw_all4team_product_1717286702	open	3, 3	5217102
sw_all4team_product_1717373101	open	3, 3	5217108
top_queries-2026.01.14-65764	open	1, 1	1810
sw_all4team_product_1716336301	open	3, 3	6258363
.plugins-ml-config	open	1, 0	1
.opensearch-observability	open	1, 0	0
sw_all4team_product_1717632302	open	3, 3	5217457
sw_all4team_product_1717718701	open	3, 3	5217475
top_queries-2026.01.13-65763	open	1, 1	1323
top_queries-2026.01.15-65765	open	1, 1	2055
security-auditlog-2023.07.13	open	1, 1	44
sw_all4team_product_1717200302	open	3, 3	5217018
sw_all4team_product_1717459502	open	3, 3	5217133
top_queries-2026.01.12-65762	open	1, 1	227
top_queries-2026.01.16-65766	open	1, 1	291

Symfony Profiler

POST https://www.all4team.de/api/product-media?_response=detail

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices