Hello folks

We have a serious problem with a joomla site with K", The hosting provider says there is a problem with the DB

The main reason for high resource usage is:

- Database queries that take a long time to execute, for example:
Time: 241223 11:38:01
# User@Host: ic2017[ic2017] @ localhost []
# Thread_id: 1886650 Schema: newinfocamp QC_hit: No
# Query_time: 2.055796 Lock_time: 0.000639 Rows_sent: 14 Rows_examined: 38917
# Rows_affected: 0 Bytes_sent: 123388
SET timestamp=1734950281;
/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ SQL_CALC_FOUND_ROWS i.*, , , , (idx_category) ON = 1 AND (1,5) AND = 1 AND (1,5) AND ('0000-00-00 00:00:00' OR <= '2024-12-23 10:38:01') AND ('0000-00-00 00:00:00' OR >= '2024-12-23 10:38:01') AND (SELECT itemID FROM nnmzc_k2_tags_xref WHERE tagID=219) GROUP BY , 14;
# Time: 241223 11:39:00
# User@Host: ic2017[ic2017] @ localhost []
# Thread_id: 1886701 Schema: newinfocamp QC_hit: No
# Query_time: 2.576140 Lock_time: 0.000261 Rows_sent: 0 Rows_examined: 44396
# Rows_affected: 0 Bytes_sent: 2851
SET timestamp=1734950340;
/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ SQL_CALC_FOUND_ROWS i.*, , , , (idx_category) ON = 1 AND (1,5) AND = 1 AND (1,5) AND ('0000-00-00 00:00:00' OR <= '2024-12-23 10:39:00') AND ('0000-00-00 00:00:00' OR >= '2024-12-23 10:39:00') AND ='' ORDER BY , 10;
# Time: 241223 11:47:07
# User@Host: ic2017[ic2017] @ localhost []
# Thread_id: 1886931 Schema: newinfocamp QC_hit: No
# Query_time: 3.249267 Lock_time: 0.000284 Rows_sent: 10 Rows_examined: 40531
# Rows_affected: 0 Bytes_sent: 94596
SET timestamp=1734950827;
/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ SQL_CALC_FOUND_ROWS i.*, , , , (idx_category) ON = 1 AND (1,5) AND = 1 AND (1,5) AND ('0000-00-00 00:00:00' OR <= '2024-12-23 10:47:07') AND ('0000-00-00 00:00:00' OR >= '2024-12-23 10:47:07') AND ='' ORDER BY , 10;

We've been unable to find the problem, please, any of tou can provide some help???

Thank you and Merry xmas