select count(1) select m.* ` ` from message m ` and ( m.title like concat('%',#{param.filter_text},'%') or m.content like concat('%',#{param.filter_text},'%') ) ` ` and m.level = #{param.level} ` ` order by m.id desc ` ` limit ${page_no},${page_size} ` SELECT IFNULL(SUM(CASE WHEN level = 'Info' THEN 1 ELSE 0 END), 0) as info, IFNULL(SUM(CASE WHEN level = 'Warn' THEN 1 ELSE 0 END), 0) as warn, IFNULL(SUM(CASE WHEN level = 'Error' THEN 1 ELSE 0 END), 0) as error FROM message WHERE read_status = 'Unread'