Heavy mysql load

Hi, for some reason the theme is generating a heavy load on mysql I have a 16core dedicated server with 65gb mem for just 1 site. and it hits 4000% the cpu load

here is the query thats doing the problem any input from you guys will be highly appreciate it.

| 53 | gsvunyrkkt | localhost:44776 | gsvunyrkkt | Query | 0 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘_banner_campaign_id’ AND wp_postmeta.meta_value = ‘29577’ )
) AND wp_posts.post_type = ‘banners’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC | 0.000 |
| 54 | gsvunyrkkt | localhost:45626 | gsvunyrkkt | Query | 1 | Copying to tmp table | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
( wp_postmeta.meta_key = ‘_banner_campaign_id’ AND wp_postmeta.meta_value = ‘37086’ )
) AND wp_posts.post_type = ‘banners’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC | 0.000 |

I have similar problem, watching this

Same issue with my site after updating to wordpress 5.

I’m having the same problem, very slow site since Friday. When I change to another theme the site is fast. I lowered the subject again and nothing improved. Can you help us?