Slow query

[moove_avatar-150x150.png]

October 10, 2022 @ 10:43 am

Hellow, we have performance problems, and we are investigating what’s happening…

MySql Monitor, informs that we have one slow query. Can you help us?

SELECT SQL_CALC_FOUND_ROWS bb_posts.ID
FROM bb_posts INNER JOIN bb_postmeta ON (
bb_posts.ID = bb_postmeta.post_id )
WHERE 1=1
AND (
( bb_postmeta.meta_key = ‘gdpr_uvid’ AND bb_postmeta.meta_value = ‘cc4de32ba6de3bb28824a223a054effc’ )
)
AND bb_posts.post_type = ‘gdpr_analytics’
AND ((bb_posts.post_status = ‘publish’))
GROUP BY bb_posts.ID
ORDER BY bb_posts.post_date DESC
LIMIT 0, 1;