{"data":{"id":"ACSD-54018","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the performance issues with the Product List Widget that uses a non-global attribute in the widget condition.","categories":["Catalog/Product","Performance"],"components":["magento/module-catalog-widget","magento/module-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-38/acsd-54018-performance-issue-with-catalog-widget-product-list","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-38/acsd-54018-performance-issue-with-catalog-widget-product-list.md","blobSha":"82e0adfe87678b71a8a74c62fac96ce47b810b26","description":"The page loads slowly when adding a catalog widget product list with condition and attribute type boolean.","stepsToReproduce":"1. Generate 100k products. 1. Create a bool attribute with the scope set to Store View. 1. Assign attribute to all attribute sets. * Assign the attribute value Yes to all products. 1. Now go to Catalog > Products, and select all 100k products. * Choose Actions > Update Attribute. * Set the bool attribute to Yes and save it. * If you logged out on this step, check the Notes. 1. Go to CLI and run php bin/magento queue:con:start product_action_attribute.update. * Make sure the attributes for all products are updated. 1. Now go to Content > Pages and create a new page. 1. Open Page Builder > Add row > Add Content > Products. 1. Choose Select Products By = Condition. 1. Set the condition Created attribute to Yes and save it. 1. Go to the frontend and open the created page. 1. Disable full page cache and block html cache. 1. Check the page loading speed. 1. Reload the page a few times and calculate the average loading time.","introducedInQpt":"1.1.38","createdFor":["2.4.4-p2"],"documentedRange":"2.3.7 - 2.4.5-p4","scheduledFixRelease":null},"files":[{"package":"magento/magento2-base","constraint":">=2.3.7 <2.4.6","path":"patches/os/ACSD-54018_2.4.4-p2.patch","blobSha":"96178fe0caa9709b7beb296b9274aa3254d2c2b0","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-54018_2.4.4-p2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-widget/Model/Rule/Condition/Product.php","change":"modified","package":"magento/module-catalog-widget"},{"path":"vendor/magento/module-rule/Model/Condition/Sql/Builder.php","change":"modified","package":"magento/module-rule"}],"packages":["magento/module-catalog-widget","magento/module-rule"],"hasTests":false,"applicableVersions":{"magento-community":["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","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7"],"magento-commerce":["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","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["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","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7"],"magento-commerce":["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","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.4.0-p1","2.4.0","2.3.7-p4","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-54018 details"}