Symfony Profiler

POST http://localhost:9200/sw_all4team_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": "a4d331012b00410ab817a4dd8c7bc7f0"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "018997c669177269a375ec510f358b38"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "sales": {
                "order": "DESC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 16,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}
                                        

{
    "took": 14,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 92,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018c7eefb30d730886e56482ee21a0e6",
                "_score": null,
                "_source": {
                    "autoIncrement": 1158417.0,
                    "id": "018c7eefb30d730886e56482ee21a0e6"
                },
                "fields": {
                    "displayGroup": [
                        "d352a17a6cbf32df7f8c4141f76b63e1"
                    ]
                },
                "sort": [
                    3,
                    "018c7eefb30d730886e56482ee21a0e6"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018c7eef05c671459a0c78b0fa3fb664",
                "_score": null,
                "_source": {
                    "autoIncrement": 1158367.0,
                    "id": "018c7eef05c671459a0c78b0fa3fb664"
                },
                "fields": {
                    "displayGroup": [
                        "a39188bcddf7dd35b581bdfbaa6d1501"
                    ]
                },
                "sort": [
                    2,
                    "018c7eef05c671459a0c78b0fa3fb664"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018c7ef00261708caf0d2652faf88d29",
                "_score": null,
                "_source": {
                    "autoIncrement": 1158430.0,
                    "id": "018c7ef00261708caf0d2652faf88d29"
                },
                "fields": {
                    "displayGroup": [
                        "b7b6cd50379334c722233952d0e8941d"
                    ]
                },
                "sort": [
                    2,
                    "018c7ef00261708caf0d2652faf88d29"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018c7ef0549a73eea607e9627b55c35d",
                "_score": null,
                "_source": {
                    "autoIncrement": 1158441.0,
                    "id": "018c7ef0549a73eea607e9627b55c35d"
                },
                "fields": {
                    "displayGroup": [
                        "e20b1922132fa56ca1fe7e6478859d4d"
                    ]
                },
                "sort": [
                    2,
                    "018c7ef0549a73eea607e9627b55c35d"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018c7eef5fbf717eaeb6ca8706cbe947",
                "_score": null,
                "_source": {
                    "autoIncrement": 1158403.0,
                    "id": "018c7eef5fbf717eaeb6ca8706cbe947"
                },
                "fields": {
                    "displayGroup": [
                        "3e861c3e411fa75aff725ee9c7b02900"
                    ]
                },
                "sort": [
                    1,
                    "018c7eef5fbf717eaeb6ca8706cbe947"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018cb2655bf9706aad8555e7b6695810",
                "_score": null,
                "_source": {
                    "autoIncrement": 1209219.0,
                    "id": "018cb2655bf9706aad8555e7b6695810"
                },
                "fields": {
                    "displayGroup": [
                        "21b3a59414a735a76b82f0b435e47e9c"
                    ]
                },
                "sort": [
                    0,
                    "018cb2655bf9706aad8555e7b6695810"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018cb26634d3723caec9d0fd9c23ce40",
                "_score": null,
                "_source": {
                    "autoIncrement": 1209242.0,
                    "id": "018cb26634d3723caec9d0fd9c23ce40"
                },
                "fields": {
                    "displayGroup": [
                        "1ab38a1f3967843fb0de07eb8bc448b7"
                    ]
                },
                "sort": [
                    0,
                    "018cb26634d3723caec9d0fd9c23ce40"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018cb2671bf5712580f3142e9cc52aad",
                "_score": null,
                "_source": {
                    "autoIncrement": 1209265.0,
                    "id": "018cb2671bf5712580f3142e9cc52aad"
                },
                "fields": {
                    "displayGroup": [
                        "527764e0e54643392120431ca33de16d"
                    ]
                },
                "sort": [
                    0,
                    "018cb2671bf5712580f3142e9cc52aad"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018cb267dad7700c87718c5b47801f47",
                "_score": null,
                "_source": {
                    "autoIncrement": 1209335.0,
                    "id": "018cb267dad7700c87718c5b47801f47"
                },
                "fields": {
                    "displayGroup": [
                        "8a661caf8c663df80c8a20b05ec1517a"
                    ]
                },
                "sort": [
                    0,
                    "018cb267dad7700c87718c5b47801f47"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018cd06f9a2b73f290eb4d82483c78b4",
                "_score": null,
                "_source": {
                    "autoIncrement": 1223628.0,
                    "id": "018cd06f9a2b73f290eb4d82483c78b4"
                },
                "fields": {
                    "displayGroup": [
                        "8f6f9bf9119a32c2d5a6c9dd8c0e91d8"
                    ]
                },
                "sort": [
                    0,
                    "018cd06f9a2b73f290eb4d82483c78b4"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "018d11058a657289bd53451c2198b45b",
                "_score": null,
                "_source": {
                    "autoIncrement": 1243291.0,
                    "id": "018d11058a657289bd53451c2198b45b"
                },
                "fields": {
                    "displayGroup": [
                        "f03aa16a1b96b91f71205a98d494636a"
                    ]
                },
                "sort": [
                    0,
                    "018d11058a657289bd53451c2198b45b"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "093ebec021484b069ec5056a331939b9",
                "_score": null,
                "_source": {
                    "autoIncrement": 1100823.0,
                    "id": "093ebec021484b069ec5056a331939b9"
                },
                "fields": {
                    "displayGroup": [
                        "e1940d9a351d7068e171ee15a8a8145c"
                    ]
                },
                "sort": [
                    0,
                    "093ebec021484b069ec5056a331939b9"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "1989ef403fb24787bee4b3cecae924b3",
                "_score": null,
                "_source": {
                    "autoIncrement": 1068057.0,
                    "id": "1989ef403fb24787bee4b3cecae924b3"
                },
                "fields": {
                    "displayGroup": [
                        "c093f95bec64e20049066ddb09666ca3"
                    ]
                },
                "sort": [
                    0,
                    "1989ef403fb24787bee4b3cecae924b3"
                ]
            },
            {
                "_index": "sw_all4team_product_1716336301",
                "_id": "1cb0c87b7ff245d08416440c1f728071",
                "_score": null,
                "_source": {
                    "autoIncrement": 1068079.0,
                    "id": "1cb0c87b7ff245d08416440c1f728071"
                },
                "fields": {
                    "displayGroup": [
                        "6616440c0515d25a1ad7d61c4b60d4b0"
                    ]
                },
                "sort": [
                    0,
                    "1cb0c87b7ff245d08416440c1f728071"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 14
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

POST http://localhost:9200/sw_all4team_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": "a4d331012b00410ab817a4dd8c7bc7f0"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "018997c669177269a375ec510f358b38"
                                        }
                                    }
                                }
                            },
                            {
                                "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_rule1eac567d7d314563bfa3305e2e8446bb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule9628985660b5415c9ee8f65bade111bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruleeb63558ebb734bde8518103eff3442cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule8444b9bcc809444aa5a3fe1f3260a9cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule43a89e1a4b454d078913ef45f83aafdf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule6e3190c99cf44a80a3b9407e5e813c45_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": 7,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 92,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 92,
            "min": 11.0,
            "max": 37.5,
            "avg": 17.796956521739133,
            "sum": 1637.3200000000002
        },
        "options": {
            "doc_count": 184,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "5e2f46d53cb046f9a5f9736c372966f8",
                        "doc_count": 20
                    },
                    {
                        "key": "60de90a916684ef696e8ba9bd8060cbc",
                        "doc_count": 20
                    },
                    {
                        "key": "20db184c1fdb49508a4ccd08b882a19f",
                        "doc_count": 19
                    },
                    {
                        "key": "507f2e527d524e359c477d74d4605b1f",
                        "doc_count": 19
                    },
                    {
                        "key": "018c690506c2729cbb113b4d05d2da4a",
                        "doc_count": 17
                    },
                    {
                        "key": "f4ae98e61a6e405cb0b5a221ef13dbfe",
                        "doc_count": 17
                    },
                    {
                        "key": "37347e78acc44de0a2b07896ba5339c0",
                        "doc_count": 11
                    },
                    {
                        "key": "addda850cb3d4d8d819a5a9f16b44b50",
                        "doc_count": 8
                    },
                    {
                        "key": "1c23aae651524363801a44213f31f325",
                        "doc_count": 6
                    },
                    {
                        "key": "f6238f13680a479b8e6dee5111a73833",
                        "doc_count": 6
                    },
                    {
                        "key": "018b6a9f6172709fbab305244104caa0",
                        "doc_count": 5
                    },
                    {
                        "key": "018b6a9f6c9873379da9231c4e2ac056",
                        "doc_count": 5
                    },
                    {
                        "key": "018b804b710272999ef4b599a9330691",
                        "doc_count": 5
                    },
                    {
                        "key": "018b804b74d570699c603cc34ce26f93",
                        "doc_count": 5
                    },
                    {
                        "key": "018b804b77197197911e66c2c4beac7b",
                        "doc_count": 5
                    },
                    {
                        "key": "88e37ca9c31b4575a7e4c105a1139281",
                        "doc_count": 5
                    },
                    {
                        "key": "f58faace294945af9f1442838b3a6e8d",
                        "doc_count": 5
                    },
                    {
                        "key": "4a1ef1250e6c4a7ca28b4bce6d2d4bac",
                        "doc_count": 3
                    },
                    {
                        "key": "df7e791689574717a8edfae609e4e340",
                        "doc_count": 3
                    }
                ]
            }
        },
        "properties": {
            "doc_count": 385,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "018963e5f32b703288aad57690802852",
                        "doc_count": 83
                    },
                    {
                        "key": "01896411e3007292bbf291a9837a8cc8",
                        "doc_count": 83
                    },
                    {
                        "key": "0189641307a6721f9f1bd0b4a5bcd176",
                        "doc_count": 61
                    },
                    {
                        "key": "018963ea3aba7042895b047285c1402e",
                        "doc_count": 56
                    },
                    {
                        "key": "018bbe13bff4727baa40d87b9df82a76",
                        "doc_count": 23
                    },
                    {
                        "key": "018964130653725e85cfc6c129e320a7",
                        "doc_count": 15
                    },
                    {
                        "key": "018963e5f5e173a4afde33792d6fe12f",
                        "doc_count": 9
                    },
                    {
                        "key": "01896411ea347043b0788892761b1dff",
                        "doc_count": 9
                    },
                    {
                        "key": "018963e5f53b7292b003bf6803f624b7",
                        "doc_count": 6
                    },
                    {
                        "key": "01896412db2e715281560944e033a329",
                        "doc_count": 6
                    },
                    {
                        "key": "018963ea1812737fb7f416641565cd24",
                        "doc_count": 5
                    },
                    {
                        "key": "018963ea20b670278236dc7103bcceb8",
                        "doc_count": 5
                    },
                    {
                        "key": "018963ea220370f6b3962a1108942bae",
                        "doc_count": 5
                    },
                    {
                        "key": "018963ea24c172519a11176e570bcae4",
                        "doc_count": 5
                    },
                    {
                        "key": "018963ea336b7003ba1d74549036192d",
                        "doc_count": 5
                    },
                    {
                        "key": "018963ea3964707fbbfb35b2b8e8084b",
                        "doc_count": 5
                    },
                    {
                        "key": "018c1b62b67e710d93b23a913cc3da22",
                        "doc_count": 4
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "1cadc079599b4e0386adc59541691ef7",
                    "doc_count": 52
                },
                {
                    "key": "0eb8635d02c643c2b1d22ea1631c0c90",
                    "doc_count": 17
                },
                {
                    "key": "1a0ffc50b3584a1abd28c2d06d6c6465",
                    "doc_count": 9
                },
                {
                    "key": "69126f5efcab45738b242009148aca51",
                    "doc_count": 8
                },
                {
                    "key": "d8ac016c293145ff9d20f96184a4ad02",
                    "doc_count": 6
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate