master

分支 (1)

管理

管理

master

data-permission
/
spy.log

1652424580839|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652424580855|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652424580856|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652424580858|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652429095722|24|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = NULL)
1652429346838|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = NULL)
1652429365789|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = NULL)
1652429424769|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = NULL)
1652429470195|33|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652429474341|3|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652429474344|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652429474346|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652429474353|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652429474356|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652429474357|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652429474358|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652429474372|11|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id={userId}|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id={userId}
1652429575487|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652429575497|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652429575501|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652429575503|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652429575508|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652429575511|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652429575513|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652429575514|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652429575516|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652430313023|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652430313032|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652430313035|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652430313037|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652430313043|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652430313045|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652430313047|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652430313048|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652430313050|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652430378367|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652430514924|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652430583754|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652430583765|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652430583767|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652430583769|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652430583775|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652430583778|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652430583779|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652430583780|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652430583782|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652430703968|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652430703978|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652430703981|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652430703982|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652430703987|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652430703990|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652430703992|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652430703993|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652430703995|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652430753317|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652431015118|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652431023313|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652431023316|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652431023319|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652431023320|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652431023325|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652431023329|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652431023330|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652431023333|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652431023334|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652431449796|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652431449806|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652431449809|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652431449810|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652431449815|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652431449819|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652431449820|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652431449821|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652431449823|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652431601337|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652431677159|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652431677169|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652431677172|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652431677174|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652431677179|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652431677182|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652431677184|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652431677185|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652431677187|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652431909710|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652431909720|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652431909723|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652431909724|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652431909729|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652431909733|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652431909734|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652431909735|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652431909737|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652432152330|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652432152341|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652432152344|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652432152345|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652432152350|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652432152354|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652432152355|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652432152357|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652432152359|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652432442569|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652432442580|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652432442583|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652432442584|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652432442590|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652432442593|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652432442595|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652432442597|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652432442599|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652432471310|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652432549597|108|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652433263439|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652433273632|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652433273634|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652433273637|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652433273638|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652433273644|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652433273647|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652433273649|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652433273650|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652433273651|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652433291584|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652433291586|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652433291588|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652433291589|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652433291592|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652433291594|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652433291595|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652433291596|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652433291597|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652433326169|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652433326171|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652433326172|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652433326174|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652433326174|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652433326176|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652433326177|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652433326178|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652433326179|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652433351981|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652433351982|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652433351984|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652433351985|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652433351986|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652433351987|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652433351989|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652433351990|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652433351991|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652433498335|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652433498344|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652433498348|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652433498349|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652433498354|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652433498357|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652433498359|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652433498360|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652433498362|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652433559525|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652433644598|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652433649301|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652433649303|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652433649305|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652433649307|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652433649309|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652433649310|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652433649311|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652433649311|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652433649312|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652433772218|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652433772228|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652433772231|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652433772233|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652433772238|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652433772241|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652433772243|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652433772244|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652433772246|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652433803457|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652434034263|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652434034274|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652434034277|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652434034278|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652434034283|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652434034287|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652434034288|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652434034289|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652434034293|3|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652434047346|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652435043366|9|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, last_modify_time )  VALUES  ( ?, ?, ?, ?, ?, ?, ? )|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, last_modify_time )  VALUES  ( '77b8e9ff2a4ef87289da1157efe74aea', 'user5', '123', 'user5', '123456', '2022-05-13T17:44:02.954+0800', '2022-05-13T17:44:02.958+0800' )
1652435083847|2|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username )  VALUES  ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username )  VALUES  ( '7dcc00ace1cdb6b7088182b24459a0ed', 'user5', '123', 'user5', '123456', '2022-05-13T17:44:43.828+0800', '1', 'user1', '"1","2","3"', '1', '2022-05-13T17:44:43.843+0800', '1', 'user1' )
1652435786846|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652435982846|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='login'
1652436008223|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652436008232|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT 10
1652436180655|9|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652436180669|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT 10
1652436223433|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652436223447|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT 10
1652663582487|12|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username )  VALUES  ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username )  VALUES  ( 'a920e6e6fc7c8138920a8c6bdaf49e09', 'user5', '123', 'user5', '123456', '2022-05-16T09:13:02.034+0800', '1', 'user1', '"1","2","3"', '1', '2022-05-16T09:13:02.050+0800', '1', 'user1' )
1652663857347|5|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username )  VALUES  ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )|INSERT INTO user  ( id, name, tenant_id, username, password, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username )  VALUES  ( '6d19d741bbfc71b60b4bb6dffc0bdbf1', 'user5', '123', 'user5', '123456', '2022-05-16T09:17:36.936+0800', '1', 'user1', '"1","2","3"', '1', '2022-05-16T09:17:36.951+0800', '1', 'user1' )
1652664094302|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='6d19d741bbfc71b60b4bb6dffc0bdbf1'
1652664691546|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='6d19d741bbfc71b60b4bb6dffc0bdbf1'
1652664884930|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='6d19d741bbfc71b60b4bb6dffc0bdbf1'
1652664967001|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='6d19d741bbfc71b60b4bb6dffc0bdbf1'
1652665104429|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='6d19d741bbfc71b60b4bb6dffc0bdbf1'
1652665301389|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='6d19d741bbfc71b60b4bb6dffc0bdbf1'
1652665318219|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='1'
1652665332681|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652665458645|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652665483757|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652665559340|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652666189160|13|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652666363204|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652666363216|2|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652666363223|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652666363227|2|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652666363234|2|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652666363238|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652666363239|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652666363240|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652666363245|3|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652666389742|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652667936934|11|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652668058137|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652668058140|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652668058143|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652668058145|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652668058150|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652668058154|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652668058155|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652668058157|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652668058159|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652668068963|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652668093427|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652668141804|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652668141805|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652668141807|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652668141810|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652668141811|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652668141812|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652668141813|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652668141814|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652668141815|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652668185286|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652668233977|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652668233978|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652668233981|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652668233982|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652668233983|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652668233984|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652668233985|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652668233985|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652668233986|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652668281181|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND 1 = 1|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND 1 = 1
1652668344957|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND 1 = 1|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND 1 = 1
1652668369062|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND 1 = 2|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND 1 = 2
1652669256711|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND 1 = 2|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND 1 = 2
1652673796968|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND 1 = 2|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND 1 = 2
1652680473847|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652680473860|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652680473863|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652680473865|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652680473870|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652680473873|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652680473875|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652680473876|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652680473879|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652680487617|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND tenant_id = 1 OR create_user_organization_id = 1|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND tenant_id = 1 OR create_user_organization_id = 1
1652680720899|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND tenant_id = 1 OR create_user_organization_id = 1|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND tenant_id = 1 OR create_user_organization_id = 1
1652680869504|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND tenant_id = 1 OR create_user_organization_id = 1|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND tenant_id = 1 OR create_user_organization_id = 1
1652680947250|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 OR create_user_organization_id = 1|SELECT COUNT(1) FROM user WHERE tenant_id = 1 OR create_user_organization_id = 1
1652680947256|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 OR create_user_organization_id = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 OR create_user_organization_id = 1 LIMIT 10
1652681039558|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1
1652681079406|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1
1652681079414|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT 10
1652681114893|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1
1652681114895|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT 10
1652682836494|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1
1652682836508|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT 10
1652682863591|9|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652682864088|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT 10
1652682905596|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652682945036|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 AND create_user_organization_id = 1 LIMIT 10
1652683141986|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = ? AND tenant_id = 1 AND create_user_organization_id = 1|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE id = '2' AND tenant_id = 1 AND create_user_organization_id = 1
1652683163794|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652683716018|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652683716021|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652683716024|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652683716026|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652683716031|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652683716034|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652683716036|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652683716037|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652683716039|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652683729550|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652683729564|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 OR user.create_user_organization_id IN (1, 2, 5, 3) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 OR user.create_user_organization_id IN (1, 2, 5, 3) LIMIT 10
1652688964445|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652688964455|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652688964459|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652688964460|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652688964465|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652688964468|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652688964469|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652688964470|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652688964472|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652689012439|2|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652689124976|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652689282020|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652689613448|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652689613974|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 LIMIT ? where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% )|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 LIMIT 10 where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% )
1652690260722|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690281123|6|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|LIMIT ? where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT ?|LIMIT 10 where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT NULL
1652690305537|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690368520|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|LIMIT ? where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT ?|LIMIT 10 where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT NULL
1652690378220|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690421334|9|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  where (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT 10
1652690478156|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690485908|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  and (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  and (user.create_user_post_id like %1% or user.create_user_post_id like %2% or user.create_user_post_id like %3% ) LIMIT 10
1652690530173|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690533126|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 10
1652690754356|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690765752|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1  and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 10
1652690831788|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690831803|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT 10
1652690851482|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652690851485|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT 10
1652691077811|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user|SELECT COUNT(1) FROM user
1652691077813|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user LIMIT 10
1652691763830|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652691763844|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 10
1652691779528|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652691779530|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 10
1652691788240|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652691793867|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652691793869|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 10
1652691797106|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652691797108|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 5
1652693019046|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652693202038|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652693202051|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE tenant_id = 1 and (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 5
1652693208177|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652693406237|11|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652694157851|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652694157874|10|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user where (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user where (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 5
1652694203024|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652694203047|9|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user where (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user where (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 5
1652694224036|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652694224038|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user where (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT ?|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user where (user.create_user_post_id like '%1%' or user.create_user_post_id like '%2%' or user.create_user_post_id like '%3%' ) LIMIT 5
1652694324083|11|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')|SELECT COUNT(1) FROM user WHERE tenant_id = 1 AND (user.create_user_post_id LIKE '%1%' OR user.create_user_post_id LIKE '%2%' OR user.create_user_post_id LIKE '%3%')
1652695015501|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652695015513|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652695015516|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652695015517|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652695015522|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652695015526|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652695015527|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652695015528|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652695015529|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652695031276|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE user.tenant_id = 1 OR user.create_user = 1|SELECT COUNT(1) FROM user WHERE user.tenant_id = 1 OR user.create_user = 1
1652695031283|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE user.tenant_id = 1 OR user.create_user = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE user.tenant_id = 1 OR user.create_user = 1 LIMIT 5
1652695087876|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE user.tenant_id = 1 OR user.create_user = 1|SELECT COUNT(1) FROM user WHERE user.tenant_id = 1 OR user.create_user = 1
1652695087878|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE user.tenant_id = 1 OR user.create_user = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE user.tenant_id = 1 OR user.create_user = 1 LIMIT 10
1652750285003|15|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652750287661|0|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652750301904|1|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id=? |SELECT id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username FROM user WHERE id='2'
1652750318953|0|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM user WHERE user.tenant_id = 1 OR user.create_user = 1|SELECT COUNT(1) FROM user WHERE user.tenant_id = 1 OR user.create_user = 1
1652750318959|1|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE user.tenant_id = 1 OR user.create_user = 1 LIMIT ?|SELECT id, name, tenant_id, username, password, organization_id, create_time, create_user, create_username, create_user_post_id, create_user_organization_id, last_modify_time, last_modify_user, last_modify_username FROM user WHERE user.tenant_id = 1 OR user.create_user = 1 LIMIT 10
1652750324147|0|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652750324152|4|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652750324157|2|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652750324160|2|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652750324167|2|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652750324171|0|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652750324172|0|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652750324172|0|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652750324177|4|statement|connection 13|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652750788443|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description )  VALUES  ( ?, ?, ? )|INSERT INTO permission_test  ( id, name, description )  VALUES  ( 'f433ae2edeba91f681482707ae9e1965', 'test1', '描述1' )
1652750813683|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description )  VALUES  ( ?, ?, ? )|INSERT INTO permission_test  ( id, name, description )  VALUES  ( 'f0b458901015c99d4a7a906210dc6ba1', 'test2', '描述2' )
1652750867812|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id,name,description FROM permission_test WHERE id=? |SELECT id,name,description FROM permission_test WHERE id='f0b458901015c99d4a7a906210dc6ba1'
1652750950099|3|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|UPDATE permission_test  SET name=?, description=?  WHERE id=?|UPDATE permission_test  SET name='test2', description='test2到test3'  WHERE id='f0b458901015c99d4a7a906210dc6ba1'
1652750967078|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|UPDATE permission_test  SET name=?, description=?  WHERE id=?|UPDATE permission_test  SET name='test2', description='test2到test3'  WHERE id='f0b458901015c99d4a7a906210dc6ba1'
1652752464193|5|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|DELETE FROM permission_test WHERE id=?|DELETE FROM permission_test WHERE id='f0b458901015c99d4a7a906210dc6ba1'
1652753472221|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description )  VALUES  ( ?, ?, ? )|INSERT INTO permission_test  ( id, name, description )  VALUES  ( '5df3b0d100b656394080c51693cdf146', 'test2', 'test2到test3' )
1652753573532|9|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user = 1|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user = 1
1652756859372|31|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652756877549|5|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user'
1652756881922|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test|SELECT COUNT(1) FROM permission_test
1652756881929|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,description  FROM permission_test LIMIT ?|SELECT  id,name,description  FROM permission_test LIMIT 10
1652758024252|3|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652758024256|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652758024260|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652758024262|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652758024268|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652758024270|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652758024271|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652758024273|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652758024276|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652758047422|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description )  VALUES  ( ?, ?, ? )|INSERT INTO permission_test  ( id, name, description )  VALUES  ( 'a460e06957388a9381bc2f78371ff59d', 'test1', 'test1' )
1652758149281|11|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( ?, ?, ?, ? )|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( 'f7cb97fcac00857a3bd6aa8b1c1fae61', 'test1', 'test1', '1' )
1652758158143|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( ?, ?, ?, ? )|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( '3f639a005d6059143ef68868de4da0d7', 'test2', 'test2', '1' )
1652758163960|7|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user2')
1652758163970|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='2'
1652758163974|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '2')
1652758163976|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='2'
1652758163981|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652758163984|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652758163987|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='2'
1652758184782|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( ?, ?, ?, ? )|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( 'ed4bde917110bc9e2b2a6bab6ca2d6f2', 'test3', 'test3', '2' )
1652758194341|4|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( ?, ?, ?, ? )|INSERT INTO permission_test  ( id, name, description, create_user_organization_id )  VALUES  ( '0c6159749d641a7475e77af6a6c1adeb', 'test4', 'test4', '2' )
1652758219241|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758219243|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758219247|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test|SELECT COUNT(1) FROM permission_test
1652758219253|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,description,create_user_organization_id  FROM permission_test LIMIT ?|SELECT  id,name,description,create_user_organization_id  FROM permission_test LIMIT 10
1652758347068|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758369723|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758392214|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test|SELECT COUNT(1) FROM permission_test
1652758392215|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,description,create_user_organization_id  FROM permission_test LIMIT ?|SELECT  id,name,description,create_user_organization_id  FROM permission_test LIMIT 10
1652758427646|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758427656|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758427663|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1
1652758427670|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 1 LIMIT ?|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 1 LIMIT 10
1652758496294|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758496296|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758496299|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 2|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 2
1652758496300|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 2 LIMIT ?|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 2 LIMIT 10
1652758546204|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652758546209|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652758546212|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652758546214|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652758546220|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652758546221|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652758546223|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652758546226|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652758546231|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652758560916|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758560920|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758560922|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id IN (1, 2, 5, 3)|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id IN (1, 2, 5, 3)
1652758560924|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT ?|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT 10
1652758583682|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user2')
1652758583685|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='2'
1652758583688|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '2')
1652758583689|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='2'
1652758583691|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652758583692|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652758583695|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='2'
1652758593646|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758593648|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758593649|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id IN (2, 3)|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id IN (2, 3)
1652758593651|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id IN (2, 3) LIMIT ?|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id IN (2, 3) LIMIT 10
1652758699441|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = ?)|SELECT  id,name,tenant_id,username,password,organization_id,create_time,create_user,create_username,create_user_post_id,create_user_organization_id,last_modify_time,last_modify_user,last_modify_username  FROM user     WHERE (username = 'user1')
1652758699443|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id=?|SELECT r.name,r.id,r.code from role r         JOIN user_role ur on r.id=ur.role_id         WHERE ur.user_id='1'
1652758699446|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = ?)|SELECT  user_id,dept_id  FROM user_dept     WHERE (user_id = '1')
1652758699447|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT post_id  from  user_post         WHERE user_id=?|SELECT post_id  from  user_post         WHERE user_id='1'
1652758699448|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='1'
1652758699449|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='2'
1652758699450|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='3'
1652758699451|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id  from  department         WHERE parent_id =?|SELECT id  from  department         WHERE parent_id ='5'
1652758699453|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id=?|SELECT dp.date_permission_type         from data_permission dp         JOIN role_data_permission rdp on dp.id=rdp.data_permission_id         JOIN user_role ur on rdp.role_id=ur.role_id         WHERE ur.user_id='1'
1652758710803|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758710806|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758710808|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 AND permission_test.create_user_organization_id IN (1, 2, 5, 3)|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 AND permission_test.create_user_organization_id IN (1, 2, 5, 3)
1652758710810|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 1 AND permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT ?|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 1 AND permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT 10
1652758792719|9|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652758792728|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652758792739|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)
1652758792746|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT ?|SELECT id, name, description, create_user_organization_id FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT 10
1652759120547|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652759120557|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652759120567|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)
1652759120573|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT ?|SELECT id, name, description FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT 10
1652759200227|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652759200236|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652759200246|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)
1652759200252|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT ?|SELECT id, name, description FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT 10
1652759320113|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'tenant_id'
1652759320122|1|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|select count(1) from information_schema.columns where table_name = ? and column_name = ?|select count(1) from information_schema.columns where table_name = 'permission_test' and column_name = 'create_user_organization_id'
1652759320132|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)|SELECT COUNT(1) FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3)
1652759320138|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT id, name, description FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT ?|SELECT id, name, description FROM permission_test WHERE permission_test.create_user_organization_id = 1 OR permission_test.create_user_organization_id IN (1, 2, 5, 3) LIMIT 10
1652759358494|8|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT COUNT(1) FROM permission_test|SELECT COUNT(1) FROM permission_test
1652759358507|0|statement|connection 0|url jdbc:p6spy:mysql://127.0.0.1:3306/data_permission_demo?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC|SELECT  id,name,description  FROM permission_test LIMIT ?|SELECT  id,name,description  FROM permission_test LIMIT 10