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)      |