問：SQL:set sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION'Time:0. SQL: us.`user` as UID, us.`groupstructure` as GSID, us.`role` AS RID, u.`flag` AS FLAG, u.`name` AS NAME, u.`headimg` AS from `usersession` us join `user` u on u.`id`=us.`user` us.`session`=? and us.`activetime`>=date_sub(now(),interval ? minute)PARAM:Array( [0] => umus8duopdck0udlbn2ermg4u4 [1] => 120) Time:0. SQL: * from `circles` `state`=9 by `createtime` :0. SQL: `usersession` set `activetime`=now(),`user`=? `session`=?PARAM:Array( [0] => [1] => umus8duopdck0udlbn2ermg4u4) Time:5. SQL: ma.`id` as action_id,ma.`action` as action_name,m.*,g.id as ,gst.id as groupstructuretreeid from `role` r join `userrole` ur on ur.`role`=r.`id` join `usergroupstructuretree` ugst on ugst.`id`=ur.`usergroupstructuretree` join `groupstructuretree` gst on gst.`id`=ugst.`groupstructuretree` join `group` g on g.`id`=gst.`groupid` join `rolestructure` rs on rs.`role`=r.`id` join `moduleaction` ma on ma.`id`=rs.`moduleaction` join `module` m on m.`id`=ma.`module` join `user` u on u.`id`=ugst.`user` m.`upid`<=>? and ma.`action`=? and u.`id`=? and r.`state`=9 and gst.`state`=9 and m.`state`=6 by m.`order` :Array( [0] => [1] => 訪問 [2] => Time:0. SQL: ma.`id` as action_id,ma.`action` as action_name,m.*,gst.id as groupstructuretreeid from `role` r join `userrole` ur on ur.`role`=r.`id` join `usergroupstructuretree` ugst on ugst.`id`=ur.`usergroupstructuretree` join `groupstructuretree` gst on gst.`id`=ugst.`groupstructuretree` join `rolestructure` rs on rs.`role`=r.`id` join `moduleaction` ma on ma.`id`=rs.`moduleaction` join `module` m on m.`id`=ma.`module` join `user` u on u.`id`=ugst.`user` u.`id`=? and r.`state`=9 and gst.`state`=9 and m.`state`=7 by m.`order` :Array( [0] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: gst.`id` as gst_id, gst.`groupid` as gst_groupid, gst.`upgroupid` as gst_upgroupid, gst.`groupstructure` as gst_groupstructure, gst.`order` as gst_order, gst.`state` as gst_state, g.`id` as g_id, g.`name` as g_name, g.`state` as g_state, g.`dn_group` as g_dn_group, g.`has_user` as g_has_user, g.`has_role` as g_has_role, (select count(r.id) from role r r.groupstructure=gst.groupstructure and r.groupstructuretree=gst.id) as , (select count(ug.id) from usergroupstructuretree ug ug.groupstructuretree=gst.id) as , (select count(low.id) from groupstructuretree low low.upgroupid=gst.groupid) as low from groupstructuretree gst join `group` g on g.id=gst.groupid and g.state=9 gst.circles<=>? and gst.upgroupid<=>? by gst.`order` asc, gst.`id` :Array( [0] => [1] => Time:0. SQL: u.`id` as `userid`,u.`name` as `username` ,gst.`groupid`,g.`name` as `groupname` ,gst.id as groupstructuretreeid from`user` u join `usergroupstructuretree` ugst on ugst.`user`=u.`id` join `groupstructuretree` gst on gst.`id`=ugst.`groupstructuretree` join `group` g on g.`id`=gst.`groupid` join `circles` cr on cr.id=gst.circles u.`id`=? and cr.`id`=?PARAM:Array( [0] => [1] => Time:0. SQL: m.* from `module` m m.`state`=8 and m.`groupstructure` is null and m.`upid` is null by m.`order` :0.
