substring(index); } // 计算执行 SQL 耗时 long start = SystemClock.now(); Object result = invocation.proceed(); long timing = SystemClock.now() - start; // 格式化 SQL 打印执行结果 Object target = PluginUtils.realTarget(invocation.getTarget()); MetaObject metaObject = SystemMetaObject.for...
SUBSTRING_INDEX(t.task_no, '-', 1) original_task_no, CAST(SUBSTRING_INDEX(t.task_no, '-', -1) as SIGNED) sequence 2、解决办法 在Mapper接口上添加@SqlParser(filter = true)即可。 @SqlParser(filter = true) IPage<TaskVO> page(Page page, @Param("query") TaskDto taskDto);发布...
1、根据sql的select查询语句字段来在VO包中创建对应的VO类 例如sql语句: SELECTSUBSTRING_INDEX(CONCAT(SUBSTRING_INDEX(city,'市',1),'市'),'省',-1)as'city',bod51as'inBod5',bod52as'outBod5'from(SELECTa.regionas'city',bod51,bod52fromsewage_plant aJOIN(selectfactory_name,SUM(bod51)as'b...
*超过设定的最大执行时长异常提示! */ privatebooleanwriteInLog=false; @Override publicObjectintercept(Invocationinvocation)throwsThrowable{ Statementstatement; ObjectfirstArg=invocation.getArgs()[0]; if(Proxy.isProxyClass(firstArg.getClass())){ statement=(Statement)SystemMetaObject.forObject(firstArg).g...
QueryWrapper<VCzInsuranceEntity> queryWrapper = new QueryWrapper<>(); String customOrderSql = "CASE WHEN gate_no LIKE '天-%' THEN 2 ELSE 1 END, " + "CAST(SUBSTRING_INDEX(gate_no, '-', 1) AS UNSIGNED), " + "CAST(SUBSTRING_INDEX(gate_no, '-', -1) AS UNSIGNED)"...
{int index=6;if(loweredString.startsWith("select distinct")){distinctStr="DISTINCT ";index=15;}sqlPartString=originalSql.substring(index);}pagingBuilder.append(sqlPartString);if(StringUtils.isEmpty(orderby)){orderby="ORDER BY CURRENT_TIMESTAMP";}StringBuilder sql=newStringBuilder();sql.append("...
substring_index(group_concat(ifnull(rizhi1.shourushuliang1,0)order by rizhi2.createtime desc ),',',1) as shourushuliang, substring_index(group_concat(ifnull(rizhi1.fachushuliang1,0)order by rizhi2.createtime desc ),',',1) as ...
ifnull(substring_index(group_concat(rizhi1.createtimeorderbyrizhi1.createtimedesc),',',1), substring_index(group_concat(rizhi2.createtimeorderbyrizhi2.createtimedesc),',',1) )ascreatetime, ifnull(substring_index(group_concat(rizhi1.jiagongyigongorderbyrizhi1.createtimedesc),',',1), ...
if (index > 0) { originalSql = originalSql.substring(index); } long start = SystemClock.now(); Object result = invocation.proceed(); long timing = SystemClock.now() - start; Object target = PluginUtils.realTarget(invocation.getTarget()); ...
originalSql = originalSql.substring(index); } // 计算执行 SQL 耗时 longstart = SystemClock.now; Object result = invocation.proceed; longtiming = SystemClock.now - start; // 格式化 SQL 打印执行结果 Object target = PluginUtils.realTarget(invocation.getTarget); ...