• tianbo's avatar
    refactor(jg): 优化设备过滤查询性能 · b2781bea
    tianbo authored
    - 重构设备过滤查询逻辑,使用预过滤设备列表的方式提高查询效率
    - 新增 pre_filtered_equipment CTE进行设备表过滤
    - 使用 EXISTS 子查询替代原来的 IN子查询,减少不必要的数据扫描
    b2781bea
Name
Last commit
Last update
..
amos-boot-module-96333 Loading commit data...
amos-boot-module-app Loading commit data...
amos-boot-module-common Loading commit data...
amos-boot-module-cylinder Loading commit data...
amos-boot-module-jczs Loading commit data...
amos-boot-module-jg Loading commit data...
amos-boot-module-jyjc Loading commit data...
amos-boot-module-statistics Loading commit data...
amos-boot-module-tcm Loading commit data...
amos-boot-module-tzspatrol Loading commit data...
amos-boot-module-ymt Loading commit data...
amos-boot-module-ys Loading commit data...
.factorypath Loading commit data...
README.md Loading commit data...
pom.xml Loading commit data...