Ускорить работу сайта на Wordpress
Sites
Бюджет: 1500 руб.
Здравствуйте!Имеется сайт - https://library-poems.com/ и создано уже более 12 тисяч записей, начал плохо работать, очень редко выскакивает ошибка что не может подключиться к базе даных. Установил плагин Query Monitor и заметил что есть медленные запросы к базе данных:Запрос: (Ядро WordPress)SELECT wpzc_posts.IDFROM wpzc_postsLEFT JOIN wpzc_term_relationshipsON (wpzc_posts.ID = wpzc_term_relationships.object_id)INNER JOIN wpzc_postmetaON ( wpzc_posts.ID = wpzc_postmeta.post_id )WHERE 1=1AND ( wpzc_term_relationships.term_taxonomy_id IN (31) )AND ( wpzc_postmeta.meta_key = '_thumbnail_id' )AND wpzc_posts.post_type = 'post'AND ((wpzc_posts.post_status = 'publish'))GROUP BY wpzc_posts.IDORDER BY RAND()LIMIT 0, 6Вызывающий:WP_Query->get_posts()wp-includes/class-wp-query.php:3357WP_Query->query()wp-includes/class-wp-query.php:3852get_posts()wp-includes/post.php:2541load_template('wp-content/themes/root/template-parts/slider-posts.php')wp-includes/template.php:812locate_template()wp-includes/template.php:745get_template_part('template-parts/slider','posts')wp-includes/general-template.php:206Запрос: (Тема)SELECT wpzc_posts.IDFROM wpzc_postsINNER JOIN wpzc_postmetaON ( wpzc_posts.ID = wpzc_postmeta.post_id )WHERE 1=1AND ( wpzc_posts.ID NOT IN (SELECT object_idFROM wpzc_term_relationshipsWHERE term_taxonomy_id IN (31,374,618,910,1059) ) )AND ( wpzc_postmeta.meta_key = 'views' )AND wpzc_posts.post_type = 'post'AND ((wpzc_posts.post_status = 'publish'))GROUP BY wpzc_posts.IDORDER BY wpzc_postmeta.meta_value+0 DESCLIMIT 0, 5Вызывающий: WP_Query->get_posts()wp-includes/class-wp-query.php:3357WP_Query->query()wp-includes/class-wp-query.php:3852get_posts()wp-includes/post.php:2541Wpshop_Widget_Articles->widget()wp-content/themes/root/inc/widgets/widget-articles.php:163WP_Widget->display_callback()wp-includes/class-wp-widget.php:394dynamic_sidebar('sidebar-1')wp-includes/widgets.php:845load_template('wp-content/themes/root/sidebar.php')wp-includes/template.php:810locate_template()wp-includes/template.php:745get_sidebar()wp-includes/general-template.php:136Запрос: (Тема)SELECT wpzc_posts.IDFROM wpzc_postsLEFT JOIN wpzc_term_relationshipsON (wpzc_posts.ID = wpzc_term_relationships.object_id)INNER JOIN wpzc_postmetaON ( wpzc_posts.ID = wpzc_postmeta.post_id )WHERE 1=1AND ( wpzc_term_relationships.term_taxonomy_id IN (31,374,618,910,1059) )AND ( wpzc_postmeta.meta_key = 'views' )AND wpzc_posts.post_type = 'post'AND ((wpzc_posts.post_status = 'publish'))GROUP BY wpzc_posts.IDORDER BY wpzc_postmeta.meta_value+0 DESCLIMIT 0, 5Вызывающий: WP_Query->get_posts()wp-includes/class-wp-query.php:3357WP_Query->query()wp-includes/class-wp-query.php:3852get_posts()wp-includes/post.php:2541Wpshop_Widget_Articles->widget()wp-content/themes/root/inc/widgets/widget-articles.php:163WP_Widget->display_callback()wp-includes/class-wp-widget.php:394dynamic_sidebar('sidebar-1')wp-includes/widgets.php:845load_template('wp-content/themes/root/sidebar.php')wp-includes/template.php:810locate_template()wp-includes/template.php:745get_sidebar()wp-includes/general-template.php:136Иногда бывает больше, иногда бывает меньше медленных запросов, но все связаны из wpzc_postsТема на форуме где пытались мне помочь - https://qna.habr.com/q/1385542
