天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件

 找回密码
 注册成为天翎用户
查看: 957|回复: 1

为什么一个简单的查询表单和设计模式的视图,会触发大量的重复数据查询

[复制链接]
云南腾俊 发表于 2012-6-18 09:44:04 | 显示全部楼层 |阅读模式
本帖最后由 purple 于 2012-6-18 18:21 编辑



并且里面带很多"line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree"这样的错误。

详见附带的log文件

09:29:33,458  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_DISPATCHTYPE
d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,458  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,458  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_INSTANCYDEGRE
E d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,458  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_INSTANCY
DEGREE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,474  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,474  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_SECRETLE
VEL d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,474  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT * FROM (SELECT * FROM (SELECT d.*
FROM TLK_FM_DISPATCH d WHERE 1 = 1) table_orderby WHERE DOMAINID ='11e1-ae18-d04ada40-a3b2-4960a74a
b202' ORDER BY table_orderby.ID ) AS TB LIMIT 0,10
09:29:33,489  INFO AbstractDocStaticTblDAO:1060 - MY SQL: SELECT COUNT(*)  FROM (SELECT d.* FROM TL
K_FM_DISPATCH d WHERE 1 = 1) doc WHERE doc.DOMAINID ='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,505  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_DISPATCHTYPE
d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,505  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,505  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_INSTANCYDEGRE
E d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,505  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_INSTANCY
DEGREE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,505  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,505  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_SECRETLE
VEL d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,520  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_DISPATCHTYPE
d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,520  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,520  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,520  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_SECRETLE
VEL d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,520  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_INSTANCYDEGRE
E d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,520  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_INSTANCY
DEGREE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,520  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_DISPATCHTYPE
d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,520  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,536  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,536  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_SECRETLE
VEL d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,536  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_INSTANCYDEGRE
E d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,536  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_INSTANCY
DEGREE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,536  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_DISPATCHTYPE
d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,536  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,536  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,536  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_SECRETLE
VEL d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,536  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_INSTANCYDEGRE
E d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,536  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_INSTANCY
DEGREE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,536  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_DISPATCHTYPE
d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,536  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,552  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,552  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_SECRETLE
VEL d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,552  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_INSTANCY
DEGREE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,552  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,552  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,552  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_INSTANCYDEGRE
E d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,552  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_DISPATCHTYPE
d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null
<AST>:0:0: unexpected end of subtree
09:29:33,567  INFO AbstractDocStaticTblDAO:982 - MY SQL: SELECT COUNT(*)  FROM OBPM.TLK_FM_DISPATCH
TYPE d WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
09:29:33,567  INFO AbstractDocStaticTblDAO:1228 - MY SQL: SELECT d.* FROM OBPM.TLK_FM_SECRETLEVEL d
WHERE d.ISTMP=0 AND d.DOMAINID='11e1-ae18-d04ada40-a3b2-4960a74ab202'
line 1:1: unexpected token: null

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册成为天翎用户

x
purple 发表于 2012-6-18 10:04:26 | 显示全部楼层
您好,我这边测试并不会出现您反馈的问题,请提供您的使用环境(数据库、版本号、浏览器、操作系统),以便我们这边按照您的环境测试,方便的话,请将您的使用环境作为签名档,谢谢。

本版积分规则

QQ|手机版|天翎MyApps技术社区 ( 粤ICP备11093750号 )

GMT+8, 2026-8-13 04:48

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表