MySQL slow query | CyberSEO Pro | Support Forum

Hello,

I received few notices from my hosting provider that I run plenty of slow queries like that:

# Query_time: 2.024816 Lock_time: 0.000051 Rows_sent: 5 Rows_examined: 341525 
use bmwshper_abcd; 
SET timestamp=1511332396; 
SELECT ID FROM wp_2_posts as posts, wp_2_postmeta as postmeta WHERE posts.ID = postmeta.post_id AND (((postmeta.meta_key = 'cyberseo_post_name' AND postmeta.meta_value = 'in-the-news-altschool-to-close-elementary-school-in-manhattans-east-village-by-education-next') OR (posts.post_name = 'in-the-news-altschool-to-close-elementary-school-in-manhattans-east-village-by-education-next')) OR (posts.guid = 'Login to see this link)) AND posts.post_status NOT IN ('trash') AND posts.post_type NOT IN ('attachment', 'revision', 'nav_menu_item');

I suppose this is the duplicate post checking query. Is there a way to optimize this?