如何优化这条SQL，在线等急

如以下所示：<这条sql每次执行都需要太久时间了，不达标需调优。万能的CSDN的米拉帮帮我把QAQ>

insert into tb_cuserinsurances


cInsuranceId,


customerUserID,


merchantId,


payType,


insuranceNo,


insuranceAmount,


currencyCode,


applicantName,


applicantIDCard,


applicantIDCardNO,


insuranceProtocolFPage,


insuranceProtocolLPage,


insuranceInstructions,


withholdFile,


taxPaidProof,


payRemark,


insuranceType,


renewalInsuranceFile,


addDateTime,


status,


auditStatus,


remark,




#{cInsuranceId,jdbcType=VARCHAR},


#{customerUserID,jdbcType=VARCHAR},


#{merchantId,jdbcType=VARCHAR},


#{payType,jdbcType=INTEGER},


#{insuranceNo,jdbcType=VARCHAR},


#{insuranceAmount,jdbcType=DOUBLE},


#{currencyCode,jdbcType=VARCHAR},


#{applicantName,jdbcType=VARCHAR},


#{applicantIDCard,jdbcType=VARCHAR},


#{applicantIDCardNO,jdbcType=VARCHAR},


#{insuranceProtocolFPage,jdbcType=VARCHAR},


#{insuranceProtocolLPage,jdbcType=VARCHAR},


#{insuranceInstructions,jdbcType=VARCHAR},


#{withholdFile,jdbcType=VARCHAR},


#{taxPaidProof,jdbcType=VARCHAR},


#{payRemark,jdbcType=VARCHAR},


#{insuranceType,jdbcType=INTEGER},


#{renewalInsuranceFile,jdbcType=VARCHAR},


#{addDateTime,jdbcType=TIMESTAMP},


#{status,jdbcType=INTEGER},


#{auditStatus,jdbcType=INTEGER},


#{remark,jdbcType=VARCHAR},

这都不全，你在线也等不到结果了

    <insert id="insertInsuranceInfo" parameterType="com.smartpay.bean.pojo.CrelateaInfoMgt.CuserInsurances" >
insert into tb_cuserinsurances
<trim prefix="(" suffix=")" suffixOverrides="," >
  <if test="cInsuranceId != null" >
    cInsuranceId,
  </if>
  <if test="customerUserID != null" >
    customerUserID,
  </if>
  <if test="merchantId != null" >
    merchantId,
  </if>
  <if test="payType != null" >
    payType,
  </if>
  <if test="insuranceNo != null" >
    insuranceNo,
  </if>
  <if test="insuranceAmount != null" >
    insuranceAmount,
  </if>
  <if test="currencyCode != null" >
    currencyCode,
  </if>
  <if test="applicantName != null" >
    applicantName,
  </if>
  <if test="applicantIDCard != null" >
    applicantIDCard,
  </if>
  <if test="applicantIDCardNO != null" >
    applicantIDCardNO,
  </if>
  <if test="insuranceProtocolFPage != null" >
    insuranceProtocolFPage,
  </if>
  <if test="insuranceProtocolLPage != null" >
    insuranceProtocolLPage,
  </if>
  <if test="insuranceInstructions != null" >
    insuranceInstructions,
  </if>
  <if test="withholdFile != null" >
    withholdFile,
  </if>
  <if test="taxPaidProof != null" >
    taxPaidProof,
  </if>
  <if test="payRemark != null" >
    payRemark,
  </if>
  <if test="insuranceType != null" >
    insuranceType,
  </if>
  <if test="renewalInsuranceFile != null" >
    renewalInsuranceFile,
  </if>
  <if test="addDateTime != null" >
    addDateTime,
  </if>
  <if test="status != null" >
    status,
  </if>
  <if test="auditStatus != null" >
    auditStatus,
  </if>
  <if test="remark != null" >
    remark,
  </if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
  <if test="cInsuranceId != null" >
    #{cInsuranceId,jdbcType=VARCHAR},
  </if>
  <if test="customerUserID != null" >
    #{customerUserID,jdbcType=VARCHAR},
  </if>
  <if test="merchantId != null" >
    #{merchantId,jdbcType=VARCHAR},
  </if>
  <if test="payType != null" >
    #{payType,jdbcType=INTEGER},
  </if>
  <if test="insuranceNo != null" >
    #{insuranceNo,jdbcType=VARCHAR},
  </if>
  <if test="insuranceAmount != null" >
    #{insuranceAmount,jdbcType=DOUBLE},
  </if>
  <if test="currencyCode != null" >
    #{currencyCode,jdbcType=VARCHAR},
  </if>
  <if test="applicantName != null" >
    #{applicantName,jdbcType=VARCHAR},
  </if>
  <if test="applicantIDCard != null" >
    #{applicantIDCard,jdbcType=VARCHAR},
  </if>
  <if test="applicantIDCardNO != null" >
    #{applicantIDCardNO,jdbcType=VARCHAR},
  </if>
  <if test="insuranceProtocolFPage != null" >
    #{insuranceProtocolFPage,jdbcType=VARCHAR},
  </if>
  <if test="insuranceProtocolLPage != null" >
    #{insuranceProtocolLPage,jdbcType=VARCHAR},
  </if>
  <if test="insuranceInstructions != null" >
    #{insuranceInstructions,jdbcType=VARCHAR},
  </if>
  <if test="withholdFile != null" >
    #{withholdFile,jdbcType=VARCHAR},
  </if>
  <if test="taxPaidProof != null" >
    #{taxPaidProof,jdbcType=VARCHAR},
  </if>
  <if test="payRemark != null" >
    #{payRemark,jdbcType=VARCHAR},
  </if>
  <if test="insuranceType != null" >
    #{insuranceType,jdbcType=INTEGER},
  </if>
  <if test="renewalInsuranceFile != null" >
    #{renewalInsuranceFile,jdbcType=VARCHAR},
  </if>
  <if test="addDateTime != null" >
    #{addDateTime,jdbcType=TIMESTAMP},
  </if>
  <if test="status != null" >
    #{status,jdbcType=INTEGER},
  </if>
  <if test="auditStatus != null" >
    #{auditStatus,jdbcType=INTEGER},
  </if>
  <if test="remark != null" >
    #{remark,jdbcType=VARCHAR},
  </if>
</trim>

我在发一下。。

求帮忙啊。在线等。。。急

所有的if test判断都没必要

然后呢、?如果没有这判断能提供一定的效率吗？？？急呀。兄弟继续啊