优化SQLSELECT wccID wccUSER_ID USER_NAME wccCONTENT wccREPLY_USER_ID wccREPLY_USER_NAME wccCONTENT_ID wccCREATION_

优化后的SQL如下：

SELECT c.ID, c.USER_ID, u.USER_NAME, c.CONTENT, c.REPLY_USER_ID, c.REPLY_USER_NAME, c.CONTENT_ID, c.CREATION_DATE, COALESCE(f.url, f.VIDEO_COVER) AS url, ct.TYPE, u.PHOTO AS userPhoto, IFNULL(NULL, 0) AS isLikeOrComment FROM work_cicrle_comment c LEFT JOIN work_cicrle_file f ON f.CONTENT_ID = c.CONTENT_ID LEFT JOIN work_cicrle_content ct ON ct.ID = c.CONTENT_ID LEFT JOIN sys_user u ON u.ID = c.USER_ID WHERE c.DEL_FLAG = 0 AND (ct.CREATED_BY = #{params.userId} OR c.REPLY_USER_ID = #{params.userId}) UNION ALL SELECT p.ID, p.USER_ID, u.USER_NAME, NULL AS CONTENT, NULL AS REPLY_USER_ID, NULL AS REPLY_USER_NAME, p.CONTENT_ID, p.CREATION_DATE, COALESCE(f.url, f.VIDEO_COVER) AS url, ct.TYPE, u.PHOTO AS userPhoto, IFNULL(NULL, 1) AS isLikeOrComment FROM work_cicrle_praise p LEFT JOIN work_cicrle_file f ON f.CONTENT_ID = p.CONTENT_ID LEFT JOIN work_cicrle_content ct ON ct.ID = p.CONTENT_ID LEFT JOIN sys_user u ON u.ID = p.USER_ID WHERE p.DEL_FLAG = 0 AND ct.CREATED_BY = #{params.userId} ORDER BY CREATION_DATE DES