NutzCN Logo
问答 使用listpage查询出来的字段不一致
发布于 1858天前 作者 qq_856b85c9 1497 次浏览 复制 上一个帖子 下一个帖子
标签:
        Object caseList = caiCaseService.listPage(1,20,Cnd.where("id","=",id).desc("readNum").desc("collectNum").desc("downloadNum"),"^(id|name|caseTime|scale|type|img|info)");

[DEBUG] 20:46:06.261 com.alibaba.dubbo.remoting.transport.DecodeHandler.decode(DecodeHandler.java:59) -  [DUBBO] Decode decodeable message com.alibaba.dubbo.rpc.protocol.dubbo.DecodeableRpcInvocation, dubbo version: 2.6.5, current host: 192.168.10.213
[DEBUG] 20:46:06.262 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - SELECT id,name,img,info,type,typeCategory FROM Cai_case  WHERE id=? ORDER BY readNum DESC, collectNum DESC, downloadNum DESC   LIMIT 0, 20 
    |                                1 |
    |----------------------------------|
    | e4c1f5d71cb54bc986154b11124ad76e |
  For example:> "SELECT id,name,img,info,type,typeCategory FROM Cai_case  WHERE id='e4c1f5d71cb54bc986154b11124ad76e' ORDER BY readNum DESC, collectNum DESC, downloadNum DESC   LIMIT 0, 20 "
[DEBUG] 20:46:06.285 org.nutz.dao.impl.interceptor.DaoTimeInterceptor.filter(DaoTimeInterceptor.java:28) - time=23ms, sql=SELECT id,name,img,info,type,typeCategory FROM Cai_case  WHERE id='e4c1f5d71cb54bc986154b11124ad76e' ORDER BY readNum DESC, collectNum DESC, downloadNum DESC   LIMIT 0, 20 
[DEBUG] 20:46:06.285 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - SELECT COUNT(*) FROM Cai_case  WHERE id=?
    |                                1 |
    |----------------------------------|
    | e4c1f5d71cb54bc986154b11124ad76e |
  For example:> "SELECT COUNT(*) FROM Cai_case  WHERE id='e4c1f5d71cb54bc986154b11124ad76e'"
1 回复

哪里不一致了?

添加回复
请先登陆
回到顶部