Merge pull request Tencent#403 from github291406933/master

TommyLemon · web-flow · commit 1f0af2db4dad · 2022-06-06T15:15:51.000+08:00
fix: 修复多字段参与join时，没有命中缓存而出现的1+N查询性能问题
diff --git a/APIJSONORM/src/main/java/apijson/orm/AbstractSQLExecutor.java b/APIJSONORM/src/main/java/apijson/orm/AbstractSQLExecutor.java
@@ -23,6 +23,7 @@
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.Collection;
+import java.util.Collections;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
@@ -519,6 +520,7 @@ else if (config.isClickHouse() && (sqlTable.startsWith("`") || sqlTable.startsWi
 							if (viceConfig != null) {  //FIXME 只有和主表关联才能用 item，否则应该从 childMap 查其它副表数据
 								List<On> onList = curJoin.getOnList();
 								if (onList != null) {
+									Collections.reverse(onList);
 									for (On on : onList) {
 										if (on != null) {
 											String ok = on.getOriginKey();
