Symfony Profiler

POST http://localhost:9200/sw_product/_search?track_total_hits=1&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": "01916a8b94f873b8abf36daf28eb865c"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "01927bd86f8d7266903fe5e215a8cf62"
                                        }
                                    }
                                }
                            },
                            {
                                "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": "customFields",
                        "languages": [
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b"
                        ],
                        "suffix": "product_pre_ordered"
                    }
                },
                "order": "DESC"
            }
        },
        {
            "_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"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}
                                        

{
    "took": 5,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 1,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1734503886",
                "_type": "_doc",
                "_id": "0192fbf40288717694e62fe5348b3e3f",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "net": 0.0,
                            "gross": 0.0,
                            "linked": true,
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca"
                        }
                    ],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gutschein lebenatur lebe natur schenken"
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "id": "0192fbf40288717694e62fe5348b3e3f",
                    "autoIncrement": 224.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": false,
                    "isCloseout": true,
                    "shippingFree": true,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01916a8b94f873b8abf36daf28eb865c"
                        }
                    ],
                    "availableStock": -4,
                    "productNumber": "TEST-70020",
                    "ean": null,
                    "displayGroup": "edee3bf7a21315496d21db0ea0993c56",
                    "sales": 14,
                    "stock": -4,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-11-05T10:52:05+00:00",
                    "categoryTree": [
                        "01919397d27f707fa87aee0385e95a41",
                        "0191a17ecabc7458bcdf93a1dfdb4dfb",
                        "01927bd855bc7158b9e21db20aa058de",
                        "01927bd86f687321803a65d6dd9cee76",
                        "01927bd86f8d7266903fe5e215a8cf62"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01919397d27f707fa87aee0385e95a41",
                            "_count": 1
                        },
                        {
                            "id": "0191a17ecabc7458bcdf93a1dfdb4dfb",
                            "_count": 1
                        },
                        {
                            "id": "01927bd855bc7158b9e21db20aa058de",
                            "_count": 1
                        },
                        {
                            "id": "01927bd86f687321803a65d6dd9cee76",
                            "_count": 1
                        },
                        {
                            "id": "01927bd86f8d7266903fe5e215a8cf62",
                            "_count": 1
                        }
                    ],
                    "taxId": "01916a876ad671bc85484d7bc7d910ca",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0191a17ecabc7458bcdf93a1dfdb4dfb",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHOP"
                            }
                        },
                        {
                            "id": "01927bd86f8d7266903fe5e215a8cf62",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gutscheine"
                            }
                        },
                        {
                            "id": "01919397d27f707fa87aee0385e95a41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lebe Natur Home"
                            }
                        },
                        {
                            "id": "01927bd855bc7158b9e21db20aa058de",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Weitere Produkte"
                            }
                        },
                        {
                            "id": "01927bd86f687321803a65d6dd9cee76",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alle weiteren Produkte"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01919397d27f707fa87aee0385e95a41",
                        "0191a17ecabc7458bcdf93a1dfdb4dfb",
                        "01927bd855bc7158b9e21db20aa058de",
                        "01927bd86f687321803a65d6dd9cee76",
                        "01927bd86f8d7266903fe5e215a8cf62"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "Tags": "Gutschein f\u00fcr lebenatur, Gutschein lebe natur, Gutschein Natursubstanzen, Gutschein Nahrungserg\u00e4nzungsmittel, Gutschein Vitalpilze, Gutschein Gesundheit, Gesundheit schenken, Gutschein f\u00fcr nat\u00fcrliche Substanzen, Kolloide schenken, Natursubstanzen schenken, Nahrungserg\u00e4nzungsmittel schenken, Vitalpilze schenken, Lebensenergie schenken, Besonderes schenken, Gutschein mit Sinn, Gutschein f\u00fcr nachhaltige Produkte schenken, W\u00fcnsche erf\u00fcllen, Muttertag Gesundheit schenken, Vatertag Gesundheit schenken, Geburtstag Gesundheit schenken, Gesundheit verschenken, Freude schenken, wertvolle Geschenke, wertvolle Gutscheine,",
                            "Details": "\u2022\tGeschenkkarte\n\u2022\tIm Wert von 10\u20ac, 30\u20ac, 50\u20ac, 100\u20ac",
                            "product_group": false,
                            "product_pre_ordered": false,
                            "lebe_product_form_info": "1 STK"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gutschein \u20ac 10,-"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gutscheine sind genau das richtige Geschenk - eines, das man wirklich brauchen kann. Mit lebe natur\u00ae Geschenkgutscheinen liegen Sie dank unserer gro\u00dfen Auswahl immer richtig. Erh\u00e4ltlich in der H\u00f6he von 10\u20ac, 30\u20ac, 50\u20ac, 100\u20ac.Gesundheit schenken ist eine liebevolle Geste und sagt: \"Mir liegt etwas an dir\". Lassen Sie die Beschenkten unter den vielen lebe natur-Produkten, den Kolloiden und monoatomaren Stoffen und dem Wohlf\u00fchl-Sortiment wie Kogi Caf\u00e9, Maya-Regenbogendecke, Akaija oder odem Schmuck selbst ausw\u00e4hlen und machen Sie damit doppelt Freude."
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gutschein lebe natur\u00ae \u20ac 10,- | Freude schenken"
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gutschein von  lebe natur\u00ae, f\u00fcr jedes Budget. Direkt bei der Bestellung einl\u00f6sen. Nachhaltige Produkte, die Sinn machen. Betrag ausw\u00e4hlen und Freude schenken. Direkt im Onlineshop erh\u00e4ltlich."
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
                            "Gutschein f\u00fcr lebenatur",
                            " Gutschein lebe natur",
                            " Gutschein Natursubstanzen",
                            " Gutschein Nahrungserg\u00e4nzungsmittel",
                            " Gutschein Vitalpilze",
                            " Gutschein Gesundheit",
                            " Gesundheit schenken",
                            " Gutschein f\u00fcr nat\u00fcrliche Substanzen",
                            " Kolloide schenken",
                            " Natursubstanzen schenken",
                            " Nahrungserg\u00e4nzungsmittel schenken",
                            " Vitalpilze schenken",
                            " Lebensenergie schenken",
                            " Besonderes schenken",
                            " Gutschein mit Sinn",
                            " Gutschein f\u00fcr nachhaltige Produkte schenken",
                            " W\u00fcnsche erf\u00fcllen",
                            " Muttertag Gesundheit schenken",
                            " Vatertag Gesundheit schenken",
                            " Geburtstag Gesundheit schenken",
                            " Gesundheit verschenken",
                            " Freude schenken",
                            " wertvolle Geschenke",
                            " wertvolle Gutscheine",
                            ""
                        ]
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 10.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "test-70020",
                        "gutschein",
                        "10,-",
                        "lebe",
                        "natur\u00ae",
                        "freude",
                        "schenken",
                        "gutschein \u20ac 10,-",
                        "gutschein lebe natur\u00ae \u20ac 10,- | freude schenken"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "edee3bf7a21315496d21db0ea0993c56"
                    ]
                },
                "sort": [
                    "false",
                    "gutschein \u20ac 10,-",
                    "0192fbf40288717694e62fe5348b3e3f"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 1
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

POST http://localhost:9200/sw_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": "01916a8b94f873b8abf36daf28eb865c"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "01927bd86f8d7266903fe5e215a8cf62"
                                        }
                                    }
                                }
                            },
                            {
                                "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_rule01916a872aa67073a439dac37fda65ce_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01916a872b06731f944de6ce7d37a1ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01916a87582c7066ac933f518487bb58_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01916a872bc671468a07d17a479d67ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01926bff81cd7a28a9bef5237df79775_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01936c370d0f77298568834e2375435b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01938c23a6677e1abf55445326ad0934_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01916a872bcc7376bc9463a879514eff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net",
                                "factor": 1
                            }
                        ],
                        "decimals": 1000000,
                        "round": false,
                        "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": 6,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 1,
            "shipping-free": {
                "value": 1.0,
                "value_as_string": "true"
            }
        },
        "rating-exists": {
            "doc_count": 1,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 1,
            "min": 10.0,
            "max": 10.0,
            "avg": 10.0,
            "sum": 10.0
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 0,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": []
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate