NutzCN Logo
问答 debug日志模式下sql解析日志疑惑
发布于 2189天前 作者 qq_d6c9c504 1887 次浏览 复制 上一个帖子 下一个帖子
标签:

Exception when parser SQL sql, skip cac
he detect!! SQL=RUN 这个日志是正常的吗?

2018-04-18 11:13:23,336 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'weixinController'<class cn.wizzer.modules.open.wx.WeixinController>
2018-04-18 11:13:23,336 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wx_config  WHERE id=?
    |                                1 |
    |----------------------------------|
    | 0825757ddd404c8caa7ac2d2d55a360b |
  For example:> "SELECT * FROM wx_config  WHERE id='0825757ddd404c8caa7ac2d2d55a360b'"
2018-04-18 11:13:23,338 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wx_config  WHERE id=? LIMIT 0, 1
    |                                1 |
    |----------------------------------|
    | 0825757ddd404c8caa7ac2d2d55a360b |
  For example:> "SELECT * FROM wx_config  WHERE id='0825757ddd404c8caa7ac2d2d55a360b' LIMIT 0, 1 "
2018-04-18 11:13:23,341 org.nutz.weixin.util.Wxs.convert(Wxs.java:225) DEBUG - Income >>
{
   "toUserName": "gh_70aba5691d5e",
   "fromUserName": "odYUC0qBe9nedJcNBJe3rDlXHmlQ",
   "createTime": "1524021203",
   "msgType": "text",
   "content": "小姐好白",
   "msgId": "6545621225745669142"
}
2018-04-18 11:13:23,342 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wx_config  WHERE id=?
    |                                1 |
    |----------------------------------|
    | 0825757ddd404c8caa7ac2d2d55a360b |
  For example:> "SELECT * FROM wx_config  WHERE id='0825757ddd404c8caa7ac2d2d55a360b'"
2018-04-18 11:13:23,344 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wx_user  WHERE openid=? LIMIT 0, 1

    |                            1 |
    |------------------------------|
    | odYUC0qBe9nedJcNBJe3rDlXHmlQ |
  For example:> "SELECT * FROM wx_user  WHERE openid='odYUC0qBe9nedJcNBJe3rDlXHmlQ' LIMIT 0, 1 "
2018-04-18 11:13:23,347 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - // NOT SQL // ElFieldMacro=uuid()
2018-04-18 11:13:23,347 org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:110) DEBUG - Exception when parser SQL sql, skip cac
he detect!! SQL=RUN
2018-04-18 11:13:23,348 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - // NOT SQL // ElFieldMacro=$me.uid()
2018-04-18 11:13:23,348 org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:110) DEBUG - Exception when parser SQL sql, skip cac
he detect!! SQL=RUN
2018-04-18 11:13:23,348 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - // NOT SQL // ElFieldMacro=$me.now()
2018-04-18 11:13:23,348 org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:110) DEBUG - Exception when parser SQL sql, skip cac
he detect!! SQL=RUN
2018-04-18 11:13:23,348 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - // NOT SQL // ElFieldMacro=$me.flag()
2018-04-18 11:13:23,349 org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:110) DEBUG - Exception when parser SQL sql, skip cac
he detect!! SQL=RUN
2018-04-18 11:13:23,349 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - INSERT INTO wx_msg(id,openid,nickname,type,conte
nt,replyId,wxid,opBy,opAt,delFlag) VALUES(?,?,?,?,?,?,?,?,?,?)
    |                                1 |                            2 |    3 |   4 |    5 |    6 |                                7 | 8 |          9 |    1
0 |
    |----------------------------------|------------------------------|------|-----|------|------|----------------------------------|--|------------|------
-|
    | c52eedb3ac41498dba89322bb4f06332 | odYUC0qBe9nedJcNBJe3rDlXHmlQ | NULL | txt | 小姐好白 | NULL | 0825757ddd404c8caa7ac2d2d55a360b |  | 1524021203 | f
alse |
  For example:> "INSERT INTO wx_msg(id,openid,nickname,type,content,replyId,wxid,opBy,opAt,delFlag) VALUES('c52eedb3ac41498dba89322bb4f06332','odYUC0qBe9ne
dJcNBJe3rDlXHmlQ','NULL','txt','小姐好白','NULL','0825757ddd404c8caa7ac2d2d55a360b','',1524021203,false) "
2018-04-18 11:13:23,355 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wx_reply  WHERE wxid=? AND type=?
AND keyword=? LIMIT 0, 1
    |                                1 |       2 |    3 |
    |----------------------------------|---------|------|
    | 0825757ddd404c8caa7ac2d2d55a360b | keyword | 小姐好白 |
  For example:> "SELECT * FROM wx_reply  WHERE wxid='0825757ddd404c8caa7ac2d2d55a360b' AND type='keyword' AND keyword='小姐好白' LIMIT 0, 1 "
2018-04-18 11:13:23,357 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM movie_keyword  WHERE keyWord=?
    |    1 |
    |------|
    | 小姐好白 |
  For example:> "SELECT * FROM movie_keyword  WHERE keyWord='小姐好白'"
2018-04-18 11:13:23,359 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM movie  WHERE id IN (2684) AND onLi
ne=?
    | 1 |
    |---|
    | 1 |
  For example:> "SELECT * FROM movie  WHERE id IN (2684) AND onLine=1"
2018-04-18 11:13:23,362 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT COUNT(*) FROM wx_msg  WHERE openid=? AND
replyId IS NOT NULL  AND opAt>?
    |                            1 |          2 |
    |------------------------------|------------|
    | odYUC0qBe9nedJcNBJe3rDlXHmlQ | 1523980800 |
  For example:> "SELECT COUNT(*) FROM wx_msg  WHERE openid='odYUC0qBe9nedJcNBJe3rDlXHmlQ' AND replyId IS NOT NULL  AND opAt>1523980800"
2 回复

那是daocache的日志,跳过sql解析和缓存检测

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