Bug: SQL Query takes too much time to return the response and it is affecting site performance

[umangsuthar]

Describe the bug This query is being called when homepage is loaded for our website. It is taking too much time and that is affecting the site performance significantly. Currently our site is taking around 10 seconds to load where almost 90% time taken by the below queries:

SELECT *
FROM wp_as3cf_items
WHERE (path LIKE '%wp-content/uploads/2024/10/11105620/cropped-cropped-logo-black.svg_.png'
OR original_path LIKE '%wp-content/uploads/2024/10/11105620/cropped-cropped-logo-black.svg_.png');

Please check above image for reference. This query is called for all the images which are at our home page.

To Reproduce Steps to reproduce the behavior:

1. Go to 'https://fxis.ai/edu'
2. Click on 'Home Page'
3. Scroll down to '....'
4. See error

Expected behavior Ideally query should not take this much time to return the response data.

Screenshots If applicable, add screenshots to help explain your problem.

debug.log Capturing errors to debug.log and attaching to this issue will help immensely!

https://deliciousbrains.com/why-use-wp-debug-log-wordpress-development/

Diagnostic Info (from plugin's "Support" tab): Attach file to issue (preferred) or paste here.

Additional context Add any other context about the problem here.

[umangsuthar]

We found this LINK where other developer updated the query which improves the performance of the site significantly: https://wordpress.org/support/topic/offload-media-adds-6-seconds-of-mysql-queries/