<select id="statisticsByRule"  resultType="com.jd.platform.hotkey.dashboard.model.Statistics">
    select  count(1) as count, app_name as app, val as keyName, rule
    from  hk_key_record
    where type = 0
    <if test="app !=null and app !=''">
      and app_name = #{app}
    </if >
    <if test="key !=null and key !=''">
      and key_name = #{key}
    </if >
    <if test="startTime != null">
      <![CDATA[ and create_time >= #{startTime} and create_time < #{endTime}]]>
    </if>
    GROUP BY app_name, val order by null
  </select>