Symfony Profiler

{"index":"sw_stage_product_f9e43878b64d426abcdb820a918ca029","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":"8bf13830e35647b5911db25834d86400"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"58f4a4c779264f6ab088bf847898216f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"name":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"}}}

{"took":1,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":2,"relation":"eq"},"max_score":null,"hits":[{"_index":"sw_stage_product_f9e43878b64d426abcdb820a918ca029_1678714270","_type":"_doc","_id":"b4d3bec9c0e04315897fd8066036f9cd","_score":null,"_ignored":["createdAt"],"_source":{"fullText":"MELLOW Bedtray natur Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTNT","id":"b4d3bec9c0e04315897fd8066036f9cd","fullTextBoosted":"MELLOW Bedtray natur Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTNT"},"fields":{"displayGroup":["7ffdcf08170844a5c2d015c96d65004d"]},"sort":["mellow bedtray natur"]},{"_index":"sw_stage_product_f9e43878b64d426abcdb820a918ca029_1678714270","_type":"_doc","_id":"c5a76c5ef9cf4a59be43c98316f808cc","_score":null,"_ignored":["createdAt"],"_source":{"fullText":"MELLOW Bedtray wenge Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTWE","id":"c5a76c5ef9cf4a59be43c98316f808cc","fullTextBoosted":"MELLOW Bedtray wenge Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTWE"},"fields":{"displayGroup":["1247b33a547b5d186c93c1aaf6d6ccf4"]},"sort":["mellow bedtray wenge"]}]},"aggregations":{"total-count":{"value":2}}}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

{"index":"sw_stage_product_f9e43878b64d426abcdb820a918ca029","body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"8bf13830e35647b5911db25834d86400"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"58f4a4c779264f6ab088bf847898216f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"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}}

{"took":0,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":2,"relation":"eq"},"max_score":null,"hits":[]},"aggregations":{"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":[]}}}}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

{"index":"sw_stage_product_f9e43878b64d426abcdb820a918ca029","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"terms":{"id":["b4d3bec9c0e04315897fd8066036f9cd","c5a76c5ef9cf4a59be43c98316f808cc"]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"8bf13830e35647b5911db25834d86400"}}]}}}},{"term":{"active":true}}]}}]}},"from":0,"size":10000}}

{"took":0,"timed_out":false,"_shards":{"total":3,"successful":3,"skipped":0,"failed":0},"hits":{"total":{"value":2,"relation":"eq"},"max_score":0.0,"hits":[{"_index":"sw_stage_product_f9e43878b64d426abcdb820a918ca029_1678714270","_type":"_doc","_id":"c5a76c5ef9cf4a59be43c98316f808cc","_score":0.0,"_ignored":["createdAt"],"_source":{"fullText":"MELLOW Bedtray wenge Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTWE","id":"c5a76c5ef9cf4a59be43c98316f808cc","fullTextBoosted":"MELLOW Bedtray wenge Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTWE"}},{"_index":"sw_stage_product_f9e43878b64d426abcdb820a918ca029_1678714270","_type":"_doc","_id":"b4d3bec9c0e04315897fd8066036f9cd","_score":0.0,"_ignored":["createdAt"],"_source":{"fullText":"MELLOW Bedtray natur Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTNT","id":"b4d3bec9c0e04315897fd8066036f9cd","fullTextBoosted":"MELLOW Bedtray natur Breakfast in the morning, laptop or tablet in the middle of the day and the favorite book with a cup of tea in the evening \u2013 our bed tray \u201eMellow\u201c is the perfect allrounder for your home. Because of the large usable area, it is suitable for any situation. A Velcro closure connects the cushions and the wooden tray. The cover of the pillow is removable and washable through the zipper. A great accessory for comfortable hours at home.\r\nDetails\r\n\r\nLength: \u00a0\u00a0 60cm (incl. handle), 50cm (without handle)\r\nWidth: \u00a0\u00a0 \u00a037,5cm\r\nHeight:\u00a0\u00a0 \u00a012,3cm\r\n\r\nUsable area:\r\n\r\nLength:\u00a0\u00a0 \u00a050cm\r\nWidth:\u00a0\u00a0 \u00a0 35cm\r\n Mellow18BTNT"}}]}}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search