Запросы к mysql нагружают cpu 100%

Вот такие запросы без остановки генерирует WordPress к бд, само собой идёт огроменная нагрузка. Как быть?

SELECT object_id, term_taxonomy_id
FROM wp_term_relationships
INNER JOIN wp_posts
ON object_id = ID
WHERE term_taxonomy_id IN (25714,15887,15906,15907,15969,15981,16139,16168,19069,19070,19222,19223,19269,19272,19273,19322,19323,19392,19393,19394,19395,19396,19397,19398,19399,19400,19413,19420,19422,19423,19424,19425,19426,19472,19506,25698,25699,25713,25715,25716,25717,25718,25719,25720,25721,25722,25723,25724,25725,25726,25727,25728,25729,25730,25731,26024,26036,26132,26156,26226,26699,27108,27351,27448,27449,27702,28272,28845,29075,29270,133,162,134,135,141,140,142,5227,5228,123,5229,124,50,149,145,163,152,51,109,153,110,111,144,148,143,119,112,127,151,150,147,155,156,115,113,114,154,146,136,164,165,138,139,137,116,159,161,160,117,118,157,125,131,130,132,129,126,128,158,120,121,15)
AND post_type IN ('product')
AND post_status = 'publish

_pad_term_counts()
wp-includes/taxonomy.php:3615
WP_Term_Query->get_terms()
wp-includes/class-wp-term-query.php:746
WP_Term_Query->query()
wp-includes/class-wp-term-query.php:288
get_terms()
wp-includes/taxonomy.php:1182
get_categories()
wp-includes/category.php:54
wp_list_categories()
wp-includes/category-template.php:572
woodmart_product_categories_nav()
wp-content/themes/woodmart/inc/integrations/woocommerce/template-tags.php:707
woodmart_page_title()
wp-content/themes/woodmart/inc/template-tags.php:1023
do_action('woodmart_after_header')
wp-includes/plugin.php:478
woodmart_page_top_part()
wp-content/themes/woodmart/inc/template-tags.php:549
load_template('wp-content/themes/woodmart/header.php')
wp-includes/template.php:723
locate_template()
wp-includes/template.php:672
get_header('shop')
wp-includes/general-template.php:41
wc_get_template()
wp-content/plugins/woocommerce/includes/wc-core-functions.php:251

SELECT user_id, meta_key, meta_value
FROM wp_usermeta
WHERE user_id IN (1)
ORDER BY umeta_id ASC	+
update_meta_cache()
Plugin: revslider	70	0,0519
SELECT object_id, term_taxonomy_id
FROM wp_term_relationships
INNER JOIN wp_posts
ON object_id = ID
WHERE term_taxonomy_id IN (141,124,149,153,110,111,144)
AND post_type IN ('product')
AND post_status = 'publish'	+
_pad_term_counts()
Plugin: js_composer	5886	0,1958
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND ( wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (7,9) ) )
AND ( wp_postmeta.meta_key = 'total_sales' )
AND wp_posts.post_type = 'product'
AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC
LIMIT 0, 8	+
WP_Query->get_posts()
Plugin: js_composer	8	1,6038
SELECT t.*, tt.*, tr.object_id
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('product_type', 'product_visibility', 'product_cat', 'product_tag', 'product_shipping_class', 'pa_brand', 'pa_brend', 'pa_color', 'pa_cvet', 'pa_cvet-armatury', 'pa_cvet-plafonov', 'pa_cvetovaya-temperatura-k', 'pa_diametr-mm', 'pa_diametr-vrezn-otverst-mm', 'pa_diametr-vrezn-otverstiya-mm', 'pa_dlina-cepi-mm', 'pa_dlina-mm', 'pa_dlina-upakovki-sm', 'pa_forma-lampochki', 'pa_forma-plafona', 'pa_garantiya', 'pa_glubina-mm', 'pa_h-vstraivaemoj-chasti-mm', 'pa_interer', 'pa_kolichestvo-lamp', 'pa_kollekciya', 'pa_kratnost-otgruzki-sht', 'pa_lampy-v-komplekte', 'pa_material-armatury', 'pa_material-plafonov', 'pa_mesto-ustanovki', 'pa_moshhnost-lampy-w', 'pa_nalichie-datchika-dvizh', 'pa_nalichie-dimmera', 'pa_napryazhenie-v', 'pa_obshhaya-moshhnost-w', 'pa_ploshhad-osveshheniya-m', 'pa_ploshhad-osveshheniya-m10', 'pa_ploshhad-osveshheniya-m11', 'pa_ploshhad-osveshheniya-m2', 'pa_ploshhad-osveshheniya-m2179', 'pa_ploshhad-osveshheniya-m3', 'pa_ploshhad-osveshheniya-m4', 'pa_ploshhad-osveshheniya-m5', 'pa_ploshhad-osveshheniya-m6', 'pa_ploshhad-osveshheniya-m7', 'pa_ploshhad-osveshheniya-m769', 'pa_ploshhad-osveshheniya-m8', 'pa_ploshhad-osveshheniya-m9', 'pa_podx-dlya-nizk-potolk', 'pa_podxodit-dlya-nizkix-potol', 'pa_podxodit-dlya-nizkix-potolk', 'pa_proizvoditel', 'pa_pult-du', 'pa_sfera-primeneniya', 'pa_shirina-mm', 'pa_shirina-upakovki-sm', 'pa_srok-sluzhby-ch', 'pa_stepen-zashhity-ip', 'pa_stil', 'pa_strana', 'pa_svetovaya-temperatura-k', 'pa_svetovoj-potok-lm', 'pa_tip-cokolya', 'pa_tip-lampochki-dop', 'pa_tip-lampochki-dopolnitelnyj', 'pa_tip-lampochki-osnovnoj', 'pa_ves-kg', 'pa_vidy-materialov', 'pa_vysota-mm', 'pa_vysota-upakovki-sm', 'pa_vysota-vstraiv-chasti-mm', 'pa_vysota-vstraivaem-chasti-mm')
AND tr.object_id IN (870, 27868, 107062, 107954, 131344, 179134, 179225, 186457)
ORDER BY t.name ASC	+
WP_Term_Query->get_terms()
Plugin: js_composer	196	0,0545
SELECT object_id, term_taxonomy_id
FROM wp_term_relationships
INNER JOIN wp_posts
ON object_id = ID
WHERE term_taxonomy_id IN (25714,15887,15906,15907,15969,15981,16139,16168,19069,19070,19222,19223,19269,19272,19273,19322,19323,19392,19393,19394,19395,19396,19397,19398,19399,19400,19413,19420,19422,19423,19424,19425,19426,19472,19506,25698,25699,25713,25715,25716,25717,25718,25719,25720,25721,25722,25723,25724,25725,25726,25727,25728,25729,25730,25731,26024,26036,26132,26156,26226,26699,27108,27351,27448,27449,27702,28272,28845,29075,29270,133,162,134,135,141,140,142,5227,5228,123,5229,124,50,149,145,163,152,51,109,153,110,111,144,148,143,119,112,127,151,150,147,155,156,115,113,114,154,146,136,164,165,138,139,137,116,159,161,160,117,118,157,125,131,130,132,129,126,128,158,120,121,15)
AND post_type IN ('product')
AND post_status = 'publish'

_pad_term_counts()
wp-includes/taxonomy.php:3615
WP_Term_Query->get_terms()
wp-includes/class-wp-term-query.php:746
WP_Term_Query->query()
wp-includes/class-wp-term-query.php:288
get_terms()
wp-includes/taxonomy.php:1182
wp_dropdown_categories()
wp-includes/category-template.php:387
wc_product_dropdown_categories()
wp-content/plugins/woocommerce/includes/wc-term-functions.php:248
WC_Widget_Product_Categories->widget()
wp-content/plugins/woocommerce/includes/widgets/class-wc-widget-product-categories.php:237
WP_Widget->display_callback()
wp-includes/class-wp-widget.php:380
dynamic_sidebar('footer-4')
wp-includes/widgets.php:805
load_template('wp-content/themes/woodmart/sidebar-footer.php')
wp-includes/template.php:723
locate_template()
wp-includes/template.php:672
get_sidebar('footer')
wp-includes/general-template.php:111
load_template('wp-content/themes/woodmart/footer.php')
wp-includes/template.php:723
locate_template()
wp-includes/template.php:672
get_footer()
wp-includes/general-template.php:76

• Тема изменена 3 года, 11 месяцев назад пользователем Yui. Причина: please use CODE button for code formatting