問：數據庫執行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`= ;
請反復執行這個語句
答：您好，我們已優化調整的寫入性能，請測試,非常感謝您長期對我司的支持!
