Что за обращения к базе данных в Wordpress? SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON?

Что-то странное с wordpress блогами происходит. Они работают чисто по товарам - там на каждом сайте около 50-100 тыс товаров, а может и больше.
раньше все было хорошо , довольно долго - более 6 месяцев. сегодня обнаружил просто огромную нагрузку ... в чем тут может быть проблема? причем однотипные какие-то запросы идут с разных сайтов - не понимаю что произошло вообще?
привожу примеры запросов (несколько раз скопировал их с веста панели - помогите, в чем тут дело? и возможно ли исправить?

+-----+------------------+-----------+------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
| Id  | User             | Host      | db               | Command | Time | State               | Info                                                                                                 |
+-----+------------------+-----------+------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
| 15  | admin_opttols    | localhost | admin_opttols    | Query   | 33   | Sending data        | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 135 | admin_labirint   | localhost | admin_labirint   | Query   | 18   | Creating sort index | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 166 | admin_opttols    | localhost | admin_opttols    | Query   | 20   | Sending data        | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 190 | admin_svet-shop  | localhost | admin_svet-shop  | Query   | 1    | Sending data        | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 196 | admin_svet-shop  | localhost | admin_svet-shop  | Query   | 1    | updating            | UPDATE wp_yuzoviews  SET views =views+1,last_viewed = '2019-10-03 18:10:34',modified=1570127684 WHER |
| 197 | admin_literatura | localhost | admin_literatura | Query   | 2    | Sending data        | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 200 | admin_literatura | localhost | admin_literatura | Query   | 3    | Sending data        | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 214 | admin_zhens_odez | localhost | admin_zhens_odez | Query   | 0    | updating            | UPDATE wp_yuzoviews  SET views =views+1,last_viewed = '2019-10-03 18:10:34',modified=1570127685 WHER |
| 217 | admin_svet-shop  | localhost | admin_svet-shop  | Query   | 1    | Sending data        | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 221 | admin_literatura | localhost | admin_literatura | Query   | 0    | updating            | UPDATE wp_yuzoviews  SET views =views+1,last_viewed = '2019-10-03 18:10:34',modified=1570127685 WHER |
| 222 | admin_chasy      | localhost | admin_chasy      | Query   | 1    | Sending data        | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 224 | admin_stroy-mat  | localhost | admin_stroy-mat  | Query   | 0    | statistics          | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (65913,80245,80278) ORDER BY  |
| 225 | admin_default    | localhost | admin_default    | Sleep   | 0    |                     |                                                                                                      |
| 226 | admin_literatura | localhost | admin_literatura | Sleep   | 0    |                     |                                                                                                      |
| 228 | root             | localhost |                  | Query   | 0    | starting            | show processlist                                                                                     |
+-----+------------------+-----------+------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+
+----+------------------+-----------+------------------+---------+------+---------------------------+------------------------------------------------------------------------------------------------------+
| Id | User             | Host      | db               | Command | Time | State                     | Info                                                                                                 |
+----+------------------+-----------+------------------+---------+------+---------------------------+------------------------------------------------------------------------------------------------------+
| 2  | admin_literatura | localhost | admin_literatura | Query   | 3    | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 5  | admin_opttols    | localhost | admin_opttols    | Query   | 24   | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 10 | admin_labirint   | localhost | admin_labirint   | Query   | 4    | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 11 | admin_opttols    | localhost | admin_opttols    | Query   | 24   | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 13 | admin_opttols    | localhost | admin_opttols    | Query   | 24   | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 14 | admin_opttols    | localhost | admin_opttols    | Query   | 24   | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 15 | admin_opttols    | localhost | admin_opttols    | Query   | 24   | converting HEAP to ondisk | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 20 | admin_opttols    | localhost | admin_opttols    | Query   | 20   | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 22 | admin_opttols    | localhost | admin_opttols    | Query   | 17   | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 27 | admin_svet-shop  | localhost | admin_svet-shop  | Query   | 2    | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 32 | admin_knigi-shop | localhost | admin_knigi-shop | Query   | 2    | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 33 | admin_stroy-mat  | localhost | admin_stroy-mat  | Query   | 0    | updating                  | UPDATE wp_yuzoviews  SET views =views+1,last_viewed = '2019-10-03 18:10:37',modified=1570127834 WHER |
| 35 | admin_chasy      | localhost | admin_chasy      | Query   | 1    | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 36 | admin_stroy-mat  | localhost | admin_stroy-mat  | Query   | 1    | Sending data              | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts. |
| 38 | root             | localhost |                  | Query   | 0    | starting                  | show processlist                                                                                     |
+----+------------------+-----------+------------------+---------+------+---------------------------+------------------------------------------------------------------------------------------------------+
  • Вопрос задан
  • 53 просмотра
Пригласить эксперта
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Войти через центр авторизации
Похожие вопросы