[Closed] There some SQL queries those are running continuously that slows our serve

Hi,

The site mentioned (naturalleadership) is running very slow and a query is consuming a lot of CPU on our server.

The query that is reponsible is:
```SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) INNER JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) INNER JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id ) INNER JOIN wp_postmeta AS mt6 ON ( wp_posts.ID = mt6.post_id ) INNER JOIN wp_postmeta AS mt7 ON ( wp_posts.ID = mt7.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND (
wp_postmeta.meta_key = 'date_start'
AND
(
(
(
( mt1.meta_key = 'date_start' AND mt1.meta_value >= '20221101' )
AND
( mt2.meta_key = 'date_start' AND mt2.meta_value <= '20221131' )
)
OR
(
( mt3.meta_key = 'date_start' AND mt3.meta_value >= '20221201' )
AND
( mt4.meta_key = 'date_start' AND mt4.meta_value <= '20221231' )
)
OR
(
( mt5.meta_key = 'date_start' AND mt5.meta_value >= '20230101' )
AND
( mt6.meta_key = 'date_start' AND mt6.meta_value <= '20230131' )
)
)
AND
(
( mt7.meta_key = 'filter_service' AND mt7.meta_value LIKE '%\"5966\"%' )
OR
( mt7.meta_key = 'filter_service' AND mt7.meta_value LIKE '%\"5887\"%' )
OR
( mt7.meta_key = 'filter_service' AND mt7.meta_value LIKE '%\"6568\"%' )
)
)
) AND wp_posts.post_type = 'agenda' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','agenda','quotes','partners','case','service','team' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','agenda','quotes','partners','case','service','team' ) )
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 ASC, wp_posts.post_name ASC
LIMIT 0, 6 | 0.000 |```

Googling i find a lot of the same posts, but never an answer.

The query we're running is:
```$args = [
'post_type' => 'agenda',
'orderby' => ['meta_value_num' => 'ASC', 'name' => 'ASC'],
'meta_key' => 'date_start',
'posts_per_page' => $fields['posts_per_page'],
'meta_query' => [
'relation' => 'AND',
[
'key' => 'date_start',
'value' => date('Ymd'),
'compare' => '>=',
],
[
'key' => 'filter_' . $post_type,
'value' => '"' . $post_id . '"',
'compare' => 'LIKE',
]
],
'tax_query' => ['relation' => 'AND']
];

$filter_taxonomies = apply_filters('proteus_agenda_filter_taxonomies', []);

if( !empty($filter_taxonomies) ) {
foreach ($filter_taxonomies as $taxonomy => $title) {

//if( !isset() )
$taxonomy_terms = $fields['filter_taxonomy_' . $taxonomy];
if( !empty($taxonomy_terms) ) {
$args['tax_query'][] = [
'taxonomy' => $taxonomy,
'field' => 'term_id',
'terms' => $taxonomy_terms,
];
}
}
}

$agenda = new \WP_Query($args);```

What is wrong and how can we fix this?