{"data":{"id":"ACSD-61756","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Improves performance of AdvancedSalesRule filters.","categories":["Shopping Cart","Performance"],"components":["magento/module-advanced-sales-rule"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-54/acsd-61756-boosting-advanced-sales-rule-filter","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-54/acsd-61756-boosting-advanced-sales-rule-filter.md","blobSha":"af9c396034892c8d984a5e6d59b15f8db639b76d","description":"The magento_salesrule_filter query performs a full table scan without utilizing indexes, leading to performance degradation of the AdvancedSalesRule filters when there are many records in the table.","stepsToReproduce":"1. Checkout with multiple active sales rules.","introducedInQpt":"1.1.54","createdFor":["2.4.4-p9"],"documentedRange":"2.4.4 - 2.4.6-p8","scheduledFixRelease":"2.4.8"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.4 <2.4.7","path":"patches/commerce/ACSD-61756_2.4.4-p9.patch","blobSha":"ceaf11b62959226d12216f26f2c7292cd10e2b8f","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-61756_2.4.4-p9.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-advanced-sales-rule/Model/ResourceModel/Rule/Condition/Filter.php","change":"modified","package":"magento/module-advanced-sales-rule"},{"path":"vendor/magento/module-advanced-sales-rule/etc/db_schema.xml","change":"modified","package":"magento/module-advanced-sales-rule"},{"path":"vendor/magento/module-advanced-sales-rule/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-advanced-sales-rule"}],"packages":["magento/module-advanced-sales-rule"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","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/magento2-ee-base","constraint":">=2.4.7 <2.4.8","path":"patches/commerce/ACP2E-4679_2.4.7-p8.patch","blobSha":"d795553fea458140bff4ee0592cd4d58f959fa9c","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACP2E-4679_2.4.7-p8.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-advanced-sales-rule/Model/ResourceModel/Rule/Condition/Filter.php","change":"modified","package":"magento/module-advanced-sales-rule"},{"path":"vendor/magento/module-advanced-sales-rule/etc/db_schema.xml","change":"modified","package":"magento/module-advanced-sales-rule"},{"path":"vendor/magento/module-advanced-sales-rule/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-advanced-sales-rule"}],"packages":["magento/module-advanced-sales-rule"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6","2.4.5-p17","2.4.5-p16","2.4.5-p15","2.4.5-p14","2.4.5-p13","2.4.5-p12","2.4.5-p11","2.4.5-p10","2.4.5-p9","2.4.5-p8","2.4.5-p7","2.4.5-p6","2.4.5-p5","2.4.5-p4","2.4.5-p3","2.4.5-p2","2.4.5-p1","2.4.5","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-61756 details"}