Bucle infinito que consume memoria y provoca la caída del sitio

Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos.

A continuación, copio la query que genera el problema (ver captura para más información):

SELECT SQL_CALC_FOUND_ROWS Vsnucam_posts.id from vsnucam_posts left join vsnucam_term_relationships on (vsnucam_posts.ID = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on (vsnucam_posts.Id = tt1.object_id) left join vsnucam_term_relationships as tt2 on (vsnucam_posts.Id = tt2.object_id) left join vsnucam_term_relationships as tt3 on (vsnucam_posts.Id = tt3.object_id) left join vsnucam_term_relationships as tt4 on (vsnucam_posts.Id = tt4.object_id) where 1=1 and ( vsnucam_term_relationships.Term_taxonomy_id in (55,1263,1265,1266,1268,1282,1284,1285,1289,1296,1297,1308,1317,1330,1331,1333,1345,1353,1354,1355,1359,1360,1369,1383,1384,1517,1518,1519,1533,1537,1542,1547,1556,1559,1583,1595,1596,1597,1598,1599,1601,1605,1622,1641,1670,1675,1682,1696,1697,1700,1702) and tt1.Term_taxonomy_id in (75,1271,1278,1303,1323,1324,1332,1337,1338,1341,1346,1382,1386,1499,1500,1520,1540,1544,1546,1552,1554,1555,1560,1562,1586,1588,1589,1592,1619,1644,1651,1653,1678,1688,1694,1695) and tt2.Term_taxonomy_id in (62,1279,1295,1307,1310,1315,1321,1322,1328,1329,1377,1504,1505,1506,1507,1526,1534,1539,1563,1564,1570,1584,1587,1590,1606,1652,1656,1674,1687,1692,1701,1704,1711,1718) and tt3.Term_taxonomy_id in (91,661,1140,1277,1293,1327,1343,1358,1378,1379,1380,1381,1388,1512,1513,1514,1515,1516,1521,1522,1524,1525,1529,1535,1536,1538,1541,1558,1582,1604,1608,1611,1621,1626,1630,1632,1634,1635,1637,1645,1654,1669,1672,1673,1676,1684,1686,1690,1703,1705,1706,1712,1714,1715,1716) and tt4.Term_taxonomy_id in (49,1272,1273,1274,1275,1276,1283,1286,1287,1288,1290,1291,1294,1298,1301,1302,1309,1311,1316,1318,1319,1325,1326,1334,1335,1344,1347,1348,1349,1351,1356,1357,1370,1371,1372,1373,1374,1375,1376,1387,1501,1508,1530,1549,1561,1565,1579,1631,1650,1679) ) and ((vsnucam_posts.post_type = 'post' AND (Vsnucam_posts.post_status = 'publish'))) group by vsnucam_posts.Id order by vsnucam_posts.post_date DESC LIMIT 0, 10