问：数据库执行SQL消耗时间过长，出现此情况的时机有随机性，但在数据库连接后的前几条SQL的发生机率比较高。数据量不大，表里不过只有几百条数据。管理地址：http://wyxt.zgzx.gov.cn/_xbls/系统账号：验证码填：管理账号：相关测试账号请妥善保存，谢谢,系统响应慢，请协助检查数据库问题
答：您好，这边后台操作响应速度正常的，麻烦提供下详细的操作步骤，并将sql执行的语句复制到工单里，以便我司核实，非常感谢您长期对我司的支持！
问：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.
答：您好，测试了几个语句查询时间都很快的，可以在进行测试下，非常感谢您长期对我司的支持！
问： `site_msg` set content=cast(repeat(char(floor(rand()*26) 65),rand()*1000 1000) as char) `id`= ;
请反复执行这个语句
答：您好，我们已优化调整的写入性能，请测试,非常感谢您长期对我司的支持!
