{"data":{"id":"ACSD-50858","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Improves performance for loading banners contents.","categories":["Performance","Content"],"components":["magento/module-banner"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-31/acsd-50858-improved-performance-for-loading-banners-content","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-31/acsd-50858-improved-performance-for-loading-banners-content.md","blobSha":"b0271879ce2219cb040dbbeb0dd4287d02067ed0","description":"Banner performance is impacted in the cart/checkout page due to excessive DB queries and increased page loading time. This was fixed by refactoring the way banners' contents are loaded, which reduced the number of DB queries by 99.99% and the page loading time by ~99%.","stepsToReproduce":"1. Log in to Admin and create a simple product. 1. Create a customer, either from Admin or from the frontend, and add a shipping address for it. 1. Move banners.php to the magento_root/pub/ folder. 1. Generate banners using the php pub/banners.php command. It will generate 10,000 simple banners and 1,000 banners with sales rules. 1. Log in to the customer created previously on the frontend. 1. Add the product created previously to the cart. 1. Go to the checkout page (checkout/cart). 1. Monitor the banner/ajax/load request loading time: * Without bin/magento dev:query-log:enable * With bin/magento dev:query-log:enable grep 'magento_banner_content' var/debug/db.log | wc -l","introducedInQpt":"1.1.31","createdFor":["2.4.5-p1"],"documentedRange":"2.4.4 - 2.4.6","scheduledFixRelease":"2.4.7"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.4 <2.4.7","path":"patches/commerce/ACSD-50858_2.4.5-p1.patch","blobSha":"43b5332314ee58c72126003beeed5b7f97bcdca2","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-50858_2.4.5-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-banner/Model/Banner/Data.php","change":"modified","package":"magento/module-banner"},{"path":"vendor/magento/module-banner/Model/ResourceModel/BannersByStore.php","change":"added","package":"magento/module-banner"}],"packages":["magento/module-banner"],"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}],"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":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-50858 details"}