masc on "Mysql slow queries issue"

ساخت وبلاگ

My hosting provider wants to suspend website due to slow queries. Here are they:

Time running : 34
Query : SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type LIKE 'post_%' LEFT JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND (((wp_posts.post_title LIKE '%Europe%') OR (wp_posts.post_excerpt LIKE '%Europe%') OR (wp_posts.post_content LIKE '%Europe%'))) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'slides', 'careers', 'partners', 'team', 'news', 'casestudies') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') AND (t.language_code='en' OR t.language_code IS NULL ) ORDER BY wp_posts.post_title LIKE '%Europe%' DESC, wp_posts.post_date DESC LIMIT 0, 10

Time running : 50
Query : SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type LIKE 'post_%' LEFT JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND (((wp_posts.post_title LIKE '%1%') OR (wp_posts.post_excerpt LIKE '%1%') OR (wp_posts.post_content LIKE '%1%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment', 'slides', 'careers', 'partners', 'team', 'news', 'casestudies', 'privatearea') AND (wp_posts.post_status = 'publish') AND (t.language_code='en' OR t.language_code IS NULL ) ORDER BY wp_posts.post_title LIKE '%1%' DESC, wp_posts.post_date DESC LIMIT 0, 10

Is there someone who knows how can I solve this issue ? How I see this query had been executed after using search form in website, right ?

WordPress ...
ما را در سایت WordPress دنبال می کنید

برچسب : نویسنده : استخدام کار wpss بازدید : 93 تاريخ : جمعه 17 ارديبهشت 1395 ساعت: 8:01