select count(*) as totalCount,police_level as level from police_incidents where police_status=0 #{item} group by police_level update police_incidents set processed_user_id=#{processorId},processed_user_name=#{processorName}, processed_time=current_timestamp,action_taken='调度处理sos' where id=#{id} select count(1) as amount, DATE_FORMAT(a.created_time, '%Y%m') AS yearMonth from dispatch.police_incidents a where a.extend_json_info->'$.regionName'=#{regionName} and a.created_time>=#{beginDate} GROUP BY yearMonth