Skip to content

A
amos-boot-biz
Switch branch/tag
History Find file
  • tianbo's avatar
    refactor(jg): 优化设备过滤查询性能 · b2781bea
    tianbo authored 
    - 重构设备过滤查询逻辑，使用预过滤设备列表的方式提高查询效率
- 新增 pre_filtered_equipment CTE进行设备表过滤
- 使用 EXISTS 子查询替代原来的 IN子查询，减少不必要的数据扫描
    b2781bea
Name
Last commit
 Last update
..
CommonMapper.xml Loading commit data...
IdxBizJgPipelineDeleteHistoryMapper.xml Loading commit data...
JgBizChangeLogMapper.xml Loading commit data...
JgCertificateChangeRecordEqMapper.xml Loading commit data...
JgCertificateChangeRecordMapper.xml Loading commit data...
JgCertificateReplenishEqMapper.xml Loading commit data...
JgCertificateReplenishMapper.xml Loading commit data...
JgChangeRegistrationNameEqMapper.xml Loading commit data...
JgChangeRegistrationNameMapper.xml Loading commit data...
JgChangeRegistrationReformEqMapper.xml Loading commit data...
JgChangeRegistrationReformMapper.xml Loading commit data...
JgChangeRegistrationTransferEqMapper.xml Loading commit data...
JgChangeRegistrationTransferMapper.xml Loading commit data...
JgChangeRegistrationUnitEqMapper.xml Loading commit data...
JgChangeRegistrationUnitMapper.xml Loading commit data...
JgChangeVehicleRegistrationUnitEqMapper.xml Loading commit data...
JgChangeVehicleRegistrationUnitMapper.xml Loading commit data...
JgEnableDisableEqMapper.xml Loading commit data...
JgEnableDisableMapper.xml Loading commit data...
JgEquipInsuranceMapper.xml Loading commit data...
JgEquipTransferEqMapper.xml Loading commit data...
JgEquipTransferMapper.xml Loading commit data...
JgInstallationNoticeEqMapper.xml Loading commit data...
JgInstallationNoticeMapper.xml Loading commit data...
JgMaintainNoticeEqMapper.xml Loading commit data...
JgMaintainNoticeMapper.xml Loading commit data...
JgMaintenanceContractEqMapper.xml Loading commit data...
JgMaintenanceContractMapper.xml Loading commit data...
JgOperateLogMapper.xml Loading commit data...
JgOverDesignServiceLifeEqMapper.xml Loading commit data...
JgOverDesignServiceLifeMapper.xml Loading commit data...
JgReformNoticeEqMapper.xml Loading commit data...
JgReformNoticeMapper.xml Loading commit data...
JgRegistrationHistoryMapper.xml Loading commit data...
JgRelationEquipMapper.xml Loading commit data...
JgResumeInfoMapper.xml Loading commit data...
JgScrapCancelEqMapper.xml Loading commit data...
JgScrapCancelMapper.xml Loading commit data...
JgTransferNoticeEqMapper.xml Loading commit data...
JgTransferNoticeMapper.xml Loading commit data...
JgUseRegistrationEqMapper.xml Loading commit data...
JgUseRegistrationManageMapper.xml Loading commit data...
JgUseRegistrationMapper.xml Loading commit data...
JgVehicleInformationEqMapper.xml Loading commit data...
JgVehicleInformationMapper.xml Loading commit data...
SafetyProblemTracingMapper.xml Loading commit data...
ShCarEquMapper.xml Loading commit data...
ShCarMapper.xml Loading commit data...
TzsJgColumnReminderRuleMapper.xml Loading commit data...