{"data":{"id":"ACSD-49973","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Improves performance of fetching bundled products through GraphQL.","categories":["GraphQL","Performance"],"components":["magento/module-bundle","magento/module-bundle-graph-ql","magento/module-catalog-inventory","magento/module-inventory-catalog","magento/module-inventory-catalog-search","magento/module-inventory-catalog-search-bundle-product","magento/module-inventory-catalog-search-configurable-product"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-30/acsd-49973-improved-performance-fetching-bundled-products-via-graphql","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-30/acsd-49973-improved-performance-fetching-bundled-products-via-graphql.md","blobSha":"245a484299d1031d46da3842cbf48a2d4208f554","description":"Performance degradation occurs when fetching bundled products via GraphQL.","stepsToReproduce":"1. Enable the DB query logger: bin/magento dev:query-log:enable 1. Execute the following GraphQL query: { products( search: \"bundle\" pageSize: 2000, sort: { relevance: DESC } ) { total_count items { name sku } } } 1. Check var/log/db.log for requests to the catalog_product_bundle_selection table.","introducedInQpt":"1.1.30","createdFor":["2.4.4-p2"],"documentedRange":"2.4.4 - 2.4.4-p3","scheduledFixRelease":null},"files":[{"package":"magento/magento2-base","constraint":">=2.4.4 <2.4.5","path":"patches/os/ACSD-49973_2.4.4-p2.patch","blobSha":"230850dda93f3fb36ad9aea96912e9377538bf51","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-49973_2.4.4-p2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-bundle/Model/Product/SelectionProductsDisabledRequired.php","change":"deleted","package":"magento/module-bundle"},{"path":"vendor/magento/module-bundle/Model/ResourceModel/Indexer/Price/DisabledProductOptionPriceModifier.php","change":"deleted","package":"magento/module-bundle"},{"path":"vendor/magento/module-bundle/Plugin/Catalog/Helper/Product.php","change":"deleted","package":"magento/module-bundle"},{"path":"vendor/magento/module-bundle/etc/di.xml","change":"modified","package":"magento/module-bundle"},{"path":"vendor/magento/module-bundle/etc/frontend/di.xml","change":"modified","package":"magento/module-bundle"},{"path":"vendor/magento/module-bundle-graph-ql/Model/Resolver/Products/DataProvider/Product/DisabledProductOptionPostProcessor.php","change":"deleted","package":"magento/module-bundle-graph-ql"},{"path":"vendor/magento/module-bundle-graph-ql/etc/di.xml","change":"modified","package":"magento/module-bundle-graph-ql"},{"path":"vendor/magento/module-catalog-inventory/Model/ResourceModel/Stock/Status.php","change":"modified","package":"magento/module-catalog-inventory"}],"packages":["magento/module-bundle","magento/module-bundle-graph-ql","magento/module-catalog-inventory"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false},{"package":"magento/inventory-metapackage","constraint":">=1.2.4 <1.2.5","path":"patches/os/ACSD-49973_1.2.4-p2.patch","blobSha":"a916d41926b61dcbd91f564d773bc322125cc185","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-49973_1.2.4-p2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-inventory-catalog/Model/ResourceModel/AddStockStatusToSelect.php","change":"modified","package":"magento/module-inventory-catalog"},{"path":"vendor/magento/module-inventory-catalog-search/Model/Indexer/FilterProductByStock.php","change":"modified","package":"magento/module-inventory-catalog-search"},{"path":"vendor/magento/module-inventory-catalog-search/Model/Indexer/SelectModifierInterface.php","change":"modified","package":"magento/module-inventory-catalog-search"},{"path":"vendor/magento/module-inventory-catalog-search-bundle-product/Model/CatalogSearch/Indexer/BundleChildStockStatusModifier.php","change":"modified","package":"magento/module-inventory-catalog-search-bundle-product"},{"path":"vendor/magento/module-inventory-catalog-search-configurable-product/Model/CatalogSearch/Indexer/ConfigurableChildStockStatusModifier.php","change":"modified","package":"magento/module-inventory-catalog-search-configurable-product"}],"packages":["magento/module-inventory-catalog","magento/module-inventory-catalog-search","magento/module-inventory-catalog-search-bundle-product","magento/module-inventory-catalog-search-configurable-product"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"mage-os":[]},"unknownVersions":["2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6","2.3.5-p2","2.3.5-p1","2.3.5","2.3.4-p2","2.3.4-p1","2.3.4","2.3.3-p2","2.3.3","2.3.2-p2","2.3.2-p1","2.3.2","2.3.1","2.3.0"],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"magento-commerce":["2.4.4-p18","2.4.4-p17","2.4.4-p16","2.4.4-p15","2.4.4-p14","2.4.4-p13","2.4.4-p12","2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-49973 details"}