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