Optimize Query

Hi Team,

We couldn't determine the source of the query below. Could you provide suggestions on how we can identify and optimize the mentioned query?

Query#1: Time: 2023-11-28T18:27:14.108304+05:30 User@Host: itgd_VS_write[itgd_VS_write] @ ip-10-6-100-149.ap-south-1.compute.internal [10.6.100.149] Id: 4548821 Query_time: 1.070314 Lock_time: 0.000168 Rows_sent: 50 Rows_examined: 514055

SET timestamp=1701176233;
SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID
FROM wp_2_posts
WHERE 1=1 AND (
(
wp_2_posts.ID NOT IN (
SELECT object_id
FROM wp_2_term_relationships
WHERE term_taxonomy_id IN (16,3,7,5)
)
)
) AND (wp_2_posts.post_mime_type = 'image/webp' OR wp_2_posts.post_mime_type = 'image/png' OR wp_2_posts.post_mime_type = 'image/jpeg' OR wp_2_posts.post_mime_type = 'image/gif' OR wp_2_posts.post_mime_type = 'video/mp4' OR wp_2_posts.post_mime_type = 'video/webm') AND wp_2_posts.post_type = 'attachment' AND ((wp_2_posts.post_status = 'inherit'))
GROUP BY wp_2_posts.ID
ORDER BY wp_2_posts.post_date DESC
LIMIT 0, 50;

Query #2: Time: 2023-11-28T18:27:15.289480+05:30 User@Host: itgd_VS_write[itgd_VS_write] @ ip-10-6-100-149.ap-south-1.compute.internal [10.6.100.149] Id: 4548821 Query_time: 1.050797 Lock_time: 0.000264 Rows_sent: 10 Rows_examined: 514055

SET timestamp=1701176234;
SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID
FROM wp_2_posts
WHERE 1=1 AND (
(
wp_2_posts.ID NOT IN (
SELECT object_id
FROM wp_2_term_relationships
WHERE term_taxonomy_id IN (16,3,7,5)
)
)
) AND (wp_2_posts.post_mime_type = 'image/webp' OR wp_2_posts.post_mime_type = 'image/png' OR wp_2_posts.post_mime_type = 'image/jpeg' OR wp_2_posts.post_mime_type = 'image/gif' OR wp_2_posts.post_mime_type = 'video/mp4' OR wp_2_posts.post_mime_type = 'video/webm') AND wp_2_posts.post_type = 'attachment' AND ((wp_2_posts.post_status = 'inherit'))
GROUP BY wp_2_posts.ID
ORDER BY wp_2_posts.post_date DESC
LIMIT 0, 10;

Query#3: Time: 2023-11-28T18:30:05.543965+05:30 User@Host: itgd_VS_write[itgd_VS_write] @ ip-10-6-101-212.ap-south-1.compute.internal [10.6.101.212] Id: 4553148 Query_time: 1.188332 Lock_time: 0.000156 Rows_sent: 25 Rows_examined: 514055

SET timestamp=1701176404;
SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID
FROM wp_2_posts
WHERE 1=1 AND (
(
wp_2_posts.ID NOT IN (
SELECT object_id
FROM wp_2_term_relationships
WHERE term_taxonomy_id IN (16,3,7,5)
)
)
) AND (wp_2_posts.post_mime_type = 'image/webp' OR wp_2_posts.post_mime_type = 'image/png' OR wp_2_posts.post_mime_type = 'image/jpeg' OR wp_2_posts.post_mime_type = 'image/gif' OR wp_2_posts.post_mime_type = 'video/mp4' OR wp_2_posts.post_mime_type = 'video/webm') AND wp_2_posts.post_type = 'attachment' AND ((wp_2_posts.post_status = 'inherit'))
GROUP BY wp_2_posts.ID
ORDER BY wp_2_posts.post_date DESC
LIMIT 0, 25;

The page I need help with: [log in to see the link]