性能优化之mybatis实现接口的批量查询，减少数据库的查询消耗

= #{userId} AND eventType IN <foreach collection="eventTypeList" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> AND createTime &gt;= #{beginTime} AND createTime &lt;= #{endTime} ORDER BY createTime </select>

 

    <select id="findActivityInfoListByCategoryId" resultMap="BaseResultMap" >
        SELECT
            a.*
        FROM  t_activity_info a
        WHERE
        a.categoryId in
        <foreach collection="list" item="categoryId" open="(" close=")"
            separator=",">
            #{categoryId}
        </foreach>
        and a.isDelete = 0
        and a.`endTime` > now()
        <if test="organizationId != null and organizationId != 3">
            AND a.organizationId = #{organizationId,jdbcType=INTEGER}
        </if>
        ORDER BY a.createTime DESC
    </select>

 

  <select id="selectOneByRewardType" resultMap="BaseResultMap">
    select w.* 
      from t_lucky_winning w 
     inner join t_lucky_activity a 
        on w.luckyId = a.luckyId and a.activityId = #{activityId,jdbcType=INTEGER}
     inner join t_lucky_reward r on w.rewardId = r.id
     where r.rewardId in(
     <foreach collection="rewardIds" item="rewardId" separator=",">
         #{rewardId,jdbcType=INTEGER}
     </foreach>)
     order by w.luckytime desc
     limit 1
  </select>

 

性能优化之mybatis实现接口的批量查询，减少数据库的查询消耗

标签：sel   mybatis   接口   tty   upd   activity   create   find   status