Query monitor is showing many slow queries that look to be counting a download item’s count. It looks like it might be related to some type of sorting (which is not needed for our purposes).
Is there a filter/way to disable these queries?
Thanks,
Example query —
SELECT wp_posts.*, wp_dlm_downloads.download_count, ( IFNULL( wp_dlm_downloads.download_count, 0 ) + IFNULL( meta_downloads.meta_value, 0 ) ) total_downloads, wp_dlm_downloads.download_versions as download_versions
FROM wp_posts
LEFT JOIN wp_dlm_downloads
ON (wp_posts.ID = wp_dlm_downloads.download_id)
LEFT JOIN (
SELECT wp_postmeta.meta_value, wp_postmeta.post_id
FROM wp_postmeta
WHERE wp_postmeta.meta_key = ‘_download_count’
GROUP BY wp_postmeta.post_id ) as meta_downloads
ON ( meta_downloads.post_id = wp_posts.ID )
WHERE 1=1
AND wp_posts.ID = 83497
AND wp_posts.post_type = ‘dlm_download’
ORDER BY wp_posts.post_date DESC
.
