1) <select id="countMapByModuleIds" resultType="map">
SELECT module_id as moduleId,count(0) as cnt
FROM doc_module_favorite
WHERE module_id in
<foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
#{item}
</foreach>
group by module_id
</select>
@MapKey("moduleId")
Map<Long, Object> countMapByModuleIds(List<Long> moduleIds);
2)<select id="countMapByProject" resultType="com.alibaba.fastjson.JSONObject">
SELECT project_id projectId, count(0) as cnt
FROM project_favorite
where project_id in
<foreach collection="ids" item="id" open="(" separator="," close=")">
#{id}
</foreach>
group by project_id
</select>