MySQL is query very slow MySQL query taking huge time

[gayanpriyankara]

hello i am facing a problem after the launch of my web MySQL is query very slow
MySQL query taking huge time
with the two queries being used to fetch products

mysql cpu usge goes up to 1000%

[devansh-webkul]

Hi @gayanpriyankara,

Can you share me your website?

[gayanpriyankara]

can you help me to solve this matter

[devansh-webkul]

As per the communication, the issue updated i.e. https://github.com/bagisto/bagisto/issues/4216.