Problem with slow query

Posted in: Newspaper
Post count: 7
codigoqro
#448624
Jul 27, 2022 at 8:43 pm

Do you know where, where or why this query is performed?

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (44) ) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 5;

This slow query produces all the time 185% CPU usage with very low ram consumption.

thanks

Post count: 35449
Calin
#448653
Jul 28, 2022 at 9:30 am

Hi,
Normally a query like that is related to the elements set with tagDiv Composer. For example, if you set a block, the limit of articles, offset, filter that will be applied to that block is set…all these are included in a query of that kind.
Thank you!

Viewing 2 posts - 1 through 2 (of 2 total)
The forum ‘Newspaper’ is closed to new topics and replies.