Java 写的一个接口， CPU 满载下只有 12 并发量......，如何改善

SQL贴上来吧，总共有

SELECT A.*,B.headIcon from `comt_like`AS A left join (select userCode,headIcon FROM user_info) as B on A.userCode = B.userCode where commentCode in ( select commentCode FROM `comt_parent` where disType = #{disType} ) ORDER BY commentCode,operationTime select * FROM `comt_parent_image` where commentCode in ( select commentCode FROM `comt_parent` where disType = #{disType} ) select * from (select DISTINCT A.*,C.nickName,C.headIcon,IFNULL(b.num,0) as childReplyCount from `comt_child` as A left join (select parentCode,count(1) as num from `comt_child` where parentCode is not null group by parentCode) as B on A.childCode = B.parentCode left join (select userCode,headIcon,nickName FROM user_info) as C on A.userCode = C.userCode where commentCode in ( select commentCode FROM `comt_parent` where disType = #{disType}) ORDER BY commentCode,childReplyCount DESC,createTime DESC) T GROUP BY T.commentCode select A.*,D.nickName,D.headIcon,E.themeName, ifnull(B.childCount,0) as childCount,ifnull(C.likeCount,0) as likeCount, childCount+likeCount as sumCount, (select userCode from `comt_like` where userCode = #{loginUserCode} and commentCode = A.commentCode) as isLike from comt_parent as A left join (select commentCode,count(commentCode) as childCount,parentCode from comt_child group by commentCode) AS B on A.commentCode = B.commentCode left join (select commentCode,count(commentCode) as likeCount from comt_like group by commentCode) AS C on A.commentCode = C.commentCode left join (select nickName,userCode,headIcon from user_info) as D on A.userCode = D.userCode left join (select id,themeName from comt_theme) as E on A.themeId = E.id where A.disType = #{disType} and A.commentType = 2 order by sumCount DESC 

一共这几条，谢谢

表的结构在这儿

mysql> desc comt_like; +------------- | Field +---------------+----------- | id | bigint(20) | commentCode | varchar(255) | userCode | varchar(255) | | operationTime | datetime mysql> desc comt_parent; +--------------------+------------- | Field | Type +--------------------+------------ | id | bigint(20) | commentCode | varchar(255) | userCode | varchar(255) | createTime | datetime | text | longtext | disType | int(11) | indexCode | varchar(255) | themeId | varchar(255) | detailedName | varchar(255) | productDescription | varchar(255) | isPrize | int(11) unsigned | commentType | int(11) mysql> desc comt_parent_image; +-------------+-------- | Field | Type +-------------+----------- | id | bigint(20) | imageCode | varchar(255) | commentCode | varchar(255) | imageUrl | varchar(255) | | imageIndex | varchar(255) | mysql> desc comt_child; +----------------+----------- | Field | Type +----------------+-------------- | id | bigint(20) | | childCode | varchar(255) | | parentCode | varchar(255) | | commentCode | varchar(255) | | userCode | varchar(255) | | text | varchar(999) | | createTime | datetime | parentIsDelete | int(11) | | childIsDelete | int(11) | | parentIsRead | int(11) | | childIsRead | int(11) |