Improve performance of slow label query

select label1_.LABELID AS x0_?_, customcont2_.TITLE AS x1_?_, labelling0_.LASTMODDATE AS x2_?_ FROM CONTENT_LABEL labelling0_, LABEL label1_, CONTENT customcont2_ WHERE customcont2_.CONTENTTYPE=? AND ((labelling0_.CONTENTID=customcont2_.CONTENTID )AND(customcont2_.PLUGINKEY=? )AND(customcont2_.CONTENT_STATUS=? )AND(label1_.LABELID=labelling0_.LABELID )AND(label1_.LABELID IN(? , ? , ? , ? , ? , ? , ? , ? , ?))AND(labelling0_.LASTMODDATE=(select max(labelling3_.LASTMODDATE) FROM CONTENT_LABEL labelling3_, LABEL label4_, CONTENT customcont5_ WHERE customcont5_.CONTENTTYPE=? AND ((labelling3_.CONTENTID=customcont5_.CONTENTID )AND(customcont5_.CONTENT_STATUS=? )AND(customcont5_.PLUGINKEY=? )AND(label4_.LABELID=labelling3_.LABELID )AND(labelling3_.LABELID=labelling0_.LABELID )) GROUP by  label4_.LABELID , label4_.NAMESPACE , label4_.OWNER , label4_.NAME , label4_.LASTMODDATE , label4_.CREATIONDATE))) ORDER by  label1_.LABELID DESC