Queries causing issues in the performance

I´m having critical issues with the performance of the site.
APM stack traces show me the issue is with td_flex_block_4.php and td_flex_block_5.php
Also it says within those there are queries under performing.
From what we can see a slow SQL query generated by the Newspaper/TagDiv theme

I´ve some suggestions, whiling to hear from you:
Remove SQL_CALC_FOUND_ROWS from the Query
Avoid NOT IN (…) in the Query

What do you think?

Hola @anamaria!

Thanks for the info, unfortunately this doesn´t answer my questions and the comment is different.

Main concern is that based on logs and APM reports, the slowest transaction from my site’s database transactions.

Please, pay specific attention to the fact that the slow performance is caused by tagDiv’s Newspaper theme’s

– APM stack traces show me the issue is with td_flex_block_4.php and td_flex_block_5.php

Also, it says within those there are queries under performing.
From what we can see a slow SQL query generated by the Newspaper/TagDiv theme

I´ve some suggestions, whiling to hear from you:
Remove SQL_CALC_FOUND_ROWS from the Query
Avoid NOT IN (…) in the Query

Our site is
Infocielo.com