High CPU usage

These queries are very CPU intensive.

SELECT post_type, MAX( GREATEST( p.post_modified_gmt, p.post_date_gmt ) ) AS date
FROM wp_posts as p
LEFT JOIN wp_postmeta AS pm ON ( p.ID = pm.post_id AND pm.meta_key = 'rank_math_robots')
WHERE (
( pm.meta_key = 'rank_math_robots' AND pm.meta_value NOT LIKE '%noindex%' ) OR
pm.post_id IS NULL
)
AND p.post_status IN ( 'publish','inherit' )
AND p.post_type IN ('post','page','attachment','guest-author','anew','article','yellow','archive')
GROUP BY p.post_type
ORDER BY p.post_modified_gmt DESC"

SELECT l.ID, post_title, post_name, post_parent, post_date, post_type, l.post_modified
FROM (
SELECT DISTINCT p.ID, p.post_modified FROM wp_posts as p
LEFT JOIN wp_postmeta AS pm ON ( p.ID = pm.post_id AND pm.meta_key = 'rank_math_robots' )
WHERE (
( pm.meta_key = 'rank_math_robots' AND pm.meta_value NOT LIKE '%noindex%' ) OR
pm.post_id IS NULL
)
AND p.post_type IN AND p.post_type IN ('post','page','attachment','guest-author','anew','article','yellow','archive') AND p.post_status IN ( "publish" )
ORDER BY p.post_modified DESC
)

Wordpress 6.5.2
Rank Math SEO with AI Best SEO Tools 1.0.218
mariadb Ver 15.1 Distrib 10.6.17-MariaDB, for Linux (x86_64) using readline 5.1