The MDVA-34847 Magento patch solves the issue where slow queries occur on the
This patch is available when the Magento Quality Patch (MQP) tool 1.0.16 is installed. Please note that the issue is scheduled to be fixed in Magento version 2.4.3.
Affected products and versions
The patch is created for Magento version:
Magento Commerce Cloud 2.3.3
Compatible with Magento versions:
Magento Commerce Cloud and Magento Commerce 2.3.0 - 2.4.2
Note: the patch can be applicable to other versions. To check if the patch is compatible with your Magento version, run
Steps to reproduce:
- Create an Admin user with a Custom scope (Example: Set GWS = 0, and choose the existing default website with ID = 1).
- Create any product and category items.
- Place an order from the frontend.
- Login to the Admin with a new user.
- Go to the Sales grid (Sales > Orders).
- Check that the SQL query has been sent to DB (database).
The Admin GWS extension should use
int values of
website_id in SQL conditions, as expected, like:
main_table.website_id IN (1)
The Admin GWS extension added a condition with
website_id value as
main_table.website_id IN ('1')
Apply the patch
To apply individual patches use the following links depending on your Magento product:
- Magento Commerce: DevDocs Software Update Guide > Apply Patches.
- Magento Commerce Cloud: DevDocs Upgrades and Patches > Apply Patches.
To learn more about Magento Quality Patches, refer to:
- Magento Quality Patches released: a new tool to self-serve quality patches.
- Check patch for Magento issue with Magento Quality Patches.
For info about other patches available in MQP tool, refer to the Patches available in MQP tool section.