使用mybatis 在xml 动态分页查询sqlserver 需要8秒,为啥这么慢
星澄码帝 2018-05-22 06:38:30 <select id="listIMEIInfo" parameterType="com.seamax.salesearch.query.Criteria" resultMap="BaseResultMap">
select top(<![CDATA[ #{mysqlLength} ]]>)
<include refid="Base_Column_List"/>
FROM IMEIInfo as im
WHERE
im.id not in(select top(<![CDATA[ #{mysqlOffset} ]]>) im2.id from IMEIInfo as im2
where 1 = 1
<if test="condition.startYear != null">
and YEAR (im2.create_time) > YEAR (#{condition.startYear}) and YEAR (im2.create_time) < YEAR
(#{condition.endYear})
</if>
and im2.channelId in ( select channelId FROM [PhoneModelConfigSimple] where
1=1
<if test="condition.custId != null and condition.custId!='' ">
and custId = #{condition.custId}
</if>
)
<if test="condition.searchValue != null">
and im2.imei LIKE #{condition.searchValue} or im2.phone_no LIKE #{condition.searchValue} or im2.phone_model LIKE
#{condition.searchValue}
</if>
<if test="orderByClause != null">
order by ${orderByClause}
</if>)
<if test="condition.startYear != null">
and YEAR (im.create_time) > YEAR (#{condition.startYear}) and YEAR (im.create_time) < YEAR
(#{condition.endYear})
</if>
and im.channelId in ( select channelId FROM [PhoneModelConfigSimple] where 1=1
<if test="condition.custId != null and condition.custId != '' ">
and custId = #{condition.custId}
</if>)
<if test="condition.searchValue != null">
and im.imei LIKE #{condition.searchValue} or im.phone_no LIKE #{condition.searchValue} or im.phone_model LIKE
#{condition.searchValue}
</if>
<if test="orderByClause != null">
order by ${orderByClause}
</if>
</select>