mark/application/logs/201806/06_sql.log

---------------------------------------------------------------
[2018-06-06T14:37:40+08:00] 127.0.0.1 POST /admin/index/login?url=%2Fadmin%2Fintention%3Fref%3Daddtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000926s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin` [ RunTime:0.007692s ]
[ sql ] [ SQL ] SELECT * FROM `admin` WHERE  `username` = 'admin' LIMIT 1 [ RunTime:0.001422s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002924s ]
[ sql ] [ SQL ] SELECT `g`.`name`,`g`.`id` FROM `auth_group_access` `a` INNER JOIN `auth_group` `g` ON `a`.`group_id`=`g`.`id` WHERE  `a`.`uid` = 1 LIMIT 1 [ RunTime:0.001213s ]
[ sql ] [ SQL ] UPDATE `admin`  SET `logintime`=1528267060,`token`='02cc53e1-bb73-45e3-967e-d775f9d8a458',`updatetime`=1528267060  WHERE  `id` = 1 [ RunTime:0.000616s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002746s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('登录' , '{\"url\":\"\\/admin\\/intention?ref=addtabs\",\"__token__\":\"f49bb403b5e816d0fd32bb7de1783f09\",\"username\":\"admin\"}' , '/admin/index/login?url=%2Fadmin%2Fintention%3Fref%3Daddtabs' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528267060) [ RunTime:0.000690s ]
---------------------------------------------------------------
[2018-06-06T14:37:40+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000550s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003628s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000833s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002674s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000560s ]
---------------------------------------------------------------
[2018-06-06T14:37:40+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000403s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001982s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000356s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002139s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000537s ]
---------------------------------------------------------------
[2018-06-06T14:37:40+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000697s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003938s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000609s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002407s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000773s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000362s ]
---------------------------------------------------------------
[2018-06-06T14:37:40+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001974s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000394s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002024s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000725s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000385s ]
---------------------------------------------------------------
[2018-06-06T14:37:41+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000464s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002576s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000582s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002538s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000355s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000376s ]
---------------------------------------------------------------
[2018-06-06T14:37:41+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528267061012
[ sql ] [ DB ] CONNECT:[ UseTime:0.000469s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002535s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000459s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002322s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000566s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002535s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000747s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000549s ]
---------------------------------------------------------------
[2018-06-06T14:37:43+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000613s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002995s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000442s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001811s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000570s ]
---------------------------------------------------------------
[2018-06-06T14:37:43+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000527s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001987s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000458s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001932s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000585s ]
---------------------------------------------------------------
[2018-06-06T14:37:43+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000428s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002252s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000493s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002497s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000584s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000365s ]
---------------------------------------------------------------
[2018-06-06T14:37:43+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000421s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002793s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000695s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002276s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000693s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000349s ]
---------------------------------------------------------------
[2018-06-06T14:37:44+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000421s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002073s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000496s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002233s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000381s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000370s ]
---------------------------------------------------------------
[2018-06-06T14:37:44+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528267063984
[ sql ] [ DB ] CONNECT:[ UseTime:0.000493s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001909s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000434s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002192s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000579s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002231s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000398s ]
---------------------------------------------------------------
[2018-06-06T14:42:35+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000976s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002698s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000454s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002528s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000639s ]
---------------------------------------------------------------
[2018-06-06T14:42:35+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000542s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002074s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000479s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002036s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000621s ]
---------------------------------------------------------------
[2018-06-06T14:42:35+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000482s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002306s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000448s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002348s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000637s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000369s ]
---------------------------------------------------------------
[2018-06-06T14:42:35+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002284s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000471s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002043s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000548s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000428s ]
---------------------------------------------------------------
[2018-06-06T14:42:36+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002184s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000466s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002081s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000377s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000385s ]
---------------------------------------------------------------
[2018-06-06T14:42:36+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528267355769
[ sql ] [ DB ] CONNECT:[ UseTime:0.000481s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002398s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000528s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002983s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000887s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002081s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000291s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000408s ]
---------------------------------------------------------------
[2018-06-06T14:43:43+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000422s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002509s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000733s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002263s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000524s ]
---------------------------------------------------------------
[2018-06-06T14:43:43+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000547s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002662s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000516s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002075s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000583s ]
---------------------------------------------------------------
[2018-06-06T14:43:43+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000484s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003662s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000443s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002234s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000556s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000392s ]
---------------------------------------------------------------
[2018-06-06T14:43:43+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000460s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002846s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000402s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001921s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000316s ]
---------------------------------------------------------------
[2018-06-06T14:43:44+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000630s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003341s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000486s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002808s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000460s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000378s ]
---------------------------------------------------------------
[2018-06-06T14:43:44+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528267423874
[ sql ] [ DB ] CONNECT:[ UseTime:0.000354s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002247s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000747s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002677s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000708s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002224s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000414s ]
---------------------------------------------------------------
[2018-06-06T14:43:52+08:00] 127.0.0.1 GET /admin/auth/rule?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000507s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002139s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000459s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002002s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.001031s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'auth/rule' LIMIT 1 [ RunTime:0.000344s ]
---------------------------------------------------------------
[2018-06-06T14:43:52+08:00] 127.0.0.1 GET /admin/auth/rule/index?sort=weigh&order=desc&_=1528267432705
[ sql ] [ DB ] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002003s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000452s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002089s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000682s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000747s ]
---------------------------------------------------------------
[2018-06-06T14:43:55+08:00] 127.0.0.1 POST /admin/auth/rule/multi/ids/1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000532s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002227s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000418s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001966s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000582s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000879s ]
[ sql ] [ SQL ] UPDATE `auth_rule`  SET `ismenu`=0,`updatetime`=1528267435  WHERE  `id` IN (1) [ RunTime:0.000937s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.001939s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '{\"action\":\"\",\"ids\":\"1\",\"params\":\"ismenu=0\"}' , '/admin/auth/rule/multi/ids/1' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528267435) [ RunTime:0.000526s ]
---------------------------------------------------------------
[2018-06-06T14:43:55+08:00] 127.0.0.1 POST /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000415s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002086s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000428s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002364s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000708s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` WHERE  `status` = 'normal'  AND `ismenu` = 1 ORDER BY `weigh` DESC [ RunTime:0.000494s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002440s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '{\"action\":\"refreshmenu\"}' , '/admin/index/index' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528267435) [ RunTime:0.000553s ]
---------------------------------------------------------------
[2018-06-06T14:43:55+08:00] 127.0.0.1 GET /admin/auth/rule/index?sort=weigh&order=desc&_=1528267432706
[ sql ] [ DB ] CONNECT:[ UseTime:0.000712s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002669s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000491s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003533s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000909s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.001135s ]
---------------------------------------------------------------
[2018-06-06T14:43:57+08:00] 127.0.0.1 GET /admin/auth/rule?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001951s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000355s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002068s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000971s ]
---------------------------------------------------------------
[2018-06-06T14:43:57+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000515s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002393s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000445s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001820s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000565s ]
---------------------------------------------------------------
[2018-06-06T14:43:58+08:00] 127.0.0.1 GET /admin/general/profile?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000502s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.004990s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000818s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003446s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000615s ]
---------------------------------------------------------------
[2018-06-06T14:43:58+08:00] 127.0.0.1 GET /admin/auth/rule?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000365s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001981s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000396s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001833s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000608s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000790s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'auth/rule' LIMIT 1 [ RunTime:0.000334s ]
---------------------------------------------------------------
[2018-06-06T14:43:58+08:00] 127.0.0.1 GET /admin/auth/rule/index?sort=weigh&order=desc&_=1528267438346
[ sql ] [ DB ] CONNECT:[ UseTime:0.000444s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002051s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000419s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002331s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000623s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000731s ]
---------------------------------------------------------------
[2018-06-06T14:43:58+08:00] 127.0.0.1 GET /admin/general/profile/index?sort=id&order=desc&offset=0&limit=10&_=1528267438356
[ sql ] [ DB ] CONNECT:[ UseTime:0.000390s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001888s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000397s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001934s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000585s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.001971s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001098s ]
[ sql ] [ SQL ] SELECT * FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000480s ]
---------------------------------------------------------------
[2018-06-06T14:44:45+08:00] 127.0.0.1 GET /admin/auth/rule/edit/ids/2?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002727s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000429s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002681s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000758s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000733s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000377s ]
---------------------------------------------------------------
[2018-06-06T14:44:56+08:00] 127.0.0.1 GET /admin/auth/rule/edit/ids/91?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000568s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002141s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000435s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002331s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000604s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000714s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` WHERE  `id` = 91 LIMIT 1 [ RunTime:0.000386s ]
---------------------------------------------------------------
[2018-06-06T14:44:58+08:00] 127.0.0.1 POST /admin/auth/rule/edit/ids/91?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000512s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002234s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000468s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002350s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000621s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000902s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` WHERE  `id` = 91 LIMIT 1 [ RunTime:0.000365s ]
[ sql ] [ SQL ] SELECT `id` FROM `auth_rule` WHERE  `name` = 'protector'  AND `id` <> 91 LIMIT 1 [ RunTime:0.000303s ]
[ sql ] [ SQL ] UPDATE `auth_rule`  SET `pid`=0,`weigh`=1,`updatetime`=1528267498  WHERE  `id` = 91 [ RunTime:0.000818s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.001880s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('权限管理 菜单规则 编辑' , '{\"dialog\":\"1\",\"row\":{\"ismenu\":\"1\",\"pid\":\"0\",\"name\":\"protector\",\"title\":\"\\u4fdd\\u62a4\\u5ba2\\u6237\",\"icon\":\"fa fa-user-secret\",\"weigh\":\"1\",\"condition\":\"\",\"remark\":\"\",\"status\":\"normal\"},\"ids\":\"91\"}' , '/admin/auth/rule/edit/ids/91?dialog=1' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528267498) [ RunTime:0.000471s ]
---------------------------------------------------------------
[2018-06-06T14:44:59+08:00] 127.0.0.1 POST /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000436s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002008s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000513s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002435s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000730s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` WHERE  `status` = 'normal'  AND `ismenu` = 1 ORDER BY `weigh` DESC [ RunTime:0.000521s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002072s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '{\"action\":\"refreshmenu\"}' , '/admin/index/index' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528267499) [ RunTime:0.000456s ]
---------------------------------------------------------------
[2018-06-06T14:44:59+08:00] 127.0.0.1 GET /admin/auth/rule/index?sort=weigh&order=desc&_=1528267438347
[ sql ] [ DB ] CONNECT:[ UseTime:0.000502s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003006s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000687s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002468s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.001019s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000962s ]
---------------------------------------------------------------
[2018-06-06T14:45:01+08:00] 127.0.0.1 GET /admin/auth/rule?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000535s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002085s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000466s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002129s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000798s ]
---------------------------------------------------------------
[2018-06-06T14:45:01+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000476s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002034s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000459s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002357s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000612s ]
---------------------------------------------------------------
[2018-06-06T14:45:02+08:00] 127.0.0.1 GET /admin/general/profile?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003220s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000511s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002574s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000631s ]
---------------------------------------------------------------
[2018-06-06T14:45:02+08:00] 127.0.0.1 GET /admin/auth/rule?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002191s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000368s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003025s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000629s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000873s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'auth/rule' LIMIT 1 [ RunTime:0.000328s ]
---------------------------------------------------------------
[2018-06-06T14:45:02+08:00] 127.0.0.1 GET /admin/general/profile/index?sort=id&order=desc&offset=0&limit=10&_=1528267502199
[ sql ] [ DB ] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002293s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000441s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002110s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000624s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002530s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
[ sql ] [ SQL ] SELECT * FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000352s ]
---------------------------------------------------------------
[2018-06-06T14:45:02+08:00] 127.0.0.1 GET /admin/auth/rule/index?sort=weigh&order=desc&_=1528267502189
[ sql ] [ DB ] CONNECT:[ UseTime:0.000512s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002089s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000444s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002376s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000594s ]
[ sql ] [ SQL ] SELECT * FROM `auth_rule` ORDER BY `weigh` DESC [ RunTime:0.000917s ]
---------------------------------------------------------------
[2018-06-06T14:50:26+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002209s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000462s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002152s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000691s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000332s ]
---------------------------------------------------------------
[2018-06-06T14:50:27+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002392s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000514s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002506s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000392s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000430s ]
---------------------------------------------------------------
[2018-06-06T14:50:27+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528267826970
[ sql ] [ DB ] CONNECT:[ UseTime:0.000409s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002049s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000500s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002305s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000826s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.001993s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000415s ]
---------------------------------------------------------------
[2018-06-06T14:50:28+08:00] 127.0.0.1 GET /admin/intention/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002393s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000532s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002137s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000712s ]
---------------------------------------------------------------
[2018-06-06T14:50:28+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000575s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.002997s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.000335s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.003143s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '[]' , '/admin/intention/unitTypeList' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528267828) [ RunTime:0.000504s ]
---------------------------------------------------------------
[2018-06-06T14:50:33+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000449s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002028s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000413s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002206s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000579s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000419s ]
---------------------------------------------------------------
[2018-06-06T14:50:33+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000455s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002118s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000449s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002412s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000414s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000398s ]
---------------------------------------------------------------
[2018-06-06T14:50:33+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528267833134
[ sql ] [ DB ] CONNECT:[ UseTime:0.000420s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002072s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000400s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002128s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000648s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002567s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000466s ]
---------------------------------------------------------------
[2018-06-06T14:50:33+08:00] 127.0.0.1 GET /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000591s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002549s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000452s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002264s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000583s ]
---------------------------------------------------------------
[2018-06-06T14:50:34+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000556s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.002341s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.000375s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002076s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '[]' , '/admin/intention/unitTypeList' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528267833) [ RunTime:0.000543s ]
---------------------------------------------------------------
[2018-06-06T14:56:02+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002338s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000450s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002031s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000605s ]
---------------------------------------------------------------
[2018-06-06T14:56:02+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000446s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002136s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000424s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002481s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.001392s ]
---------------------------------------------------------------
[2018-06-06T14:56:02+08:00] 127.0.0.1 GET /admin/general/profile?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000481s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003293s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000602s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002877s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000570s ]
---------------------------------------------------------------
[2018-06-06T14:56:02+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000377s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002038s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000606s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002407s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000555s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000383s ]
---------------------------------------------------------------
[2018-06-06T14:56:02+08:00] 127.0.0.1 GET /admin/general/profile/index?sort=id&order=desc&offset=0&limit=10&_=1528268162685
[ sql ] [ DB ] CONNECT:[ UseTime:0.000463s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002155s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000407s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002268s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000574s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002586s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
[ sql ] [ SQL ] SELECT * FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000350s ]
---------------------------------------------------------------
[2018-06-06T14:56:02+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000429s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003341s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000488s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.003187s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000433s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000389s ]
---------------------------------------------------------------
[2018-06-06T14:56:02+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528268162698
[ sql ] [ DB ] CONNECT:[ UseTime:0.000438s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002137s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000482s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002000s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000548s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002660s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000820s ]
---------------------------------------------------------------
[2018-06-06T14:56:03+08:00] 127.0.0.1 GET /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000580s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002541s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000454s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001971s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000617s ]
---------------------------------------------------------------
[2018-06-06T14:56:03+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000453s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.002356s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.000305s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002129s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '[]' , '/admin/intention/unitTypeList' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528268163) [ RunTime:0.000551s ]
---------------------------------------------------------------
[2018-06-06T14:56:43+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002340s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000407s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002040s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000545s ]
---------------------------------------------------------------
[2018-06-06T14:56:43+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000453s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001984s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000426s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002746s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000777s ]
---------------------------------------------------------------
[2018-06-06T14:56:43+08:00] 127.0.0.1 GET /admin/general/profile?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000438s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003140s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000513s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003354s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000850s ]
---------------------------------------------------------------
[2018-06-06T14:56:43+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000434s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002676s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000402s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002653s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000687s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000412s ]
---------------------------------------------------------------
[2018-06-06T14:56:44+08:00] 127.0.0.1 GET /admin/general/profile/index?sort=id&order=desc&offset=0&limit=10&_=1528268203901
[ sql ] [ DB ] CONNECT:[ UseTime:0.000430s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002008s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000419s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002080s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000559s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002327s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
[ sql ] [ SQL ] SELECT * FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000384s ]
---------------------------------------------------------------
[2018-06-06T14:56:44+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000434s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002215s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000503s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.001980s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000397s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000365s ]
---------------------------------------------------------------
[2018-06-06T14:56:44+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528268203961
[ sql ] [ DB ] CONNECT:[ UseTime:0.000565s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002249s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000523s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002228s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000603s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.003208s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000383s ]
---------------------------------------------------------------
[2018-06-06T14:56:45+08:00] 127.0.0.1 GET /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002284s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000458s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002694s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000750s ]
---------------------------------------------------------------
[2018-06-06T14:56:46+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000484s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.001992s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.000286s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002597s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '[]' , '/admin/intention/unitTypeList' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528268206) [ RunTime:0.000734s ]
---------------------------------------------------------------
[2018-06-06T14:58:02+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000439s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002407s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000414s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002263s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000625s ]
---------------------------------------------------------------
[2018-06-06T14:58:03+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000531s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001979s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000599s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003006s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000585s ]
---------------------------------------------------------------
[2018-06-06T14:58:03+08:00] 127.0.0.1 GET /admin/general/profile?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000479s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002050s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000480s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002484s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000781s ]
---------------------------------------------------------------
[2018-06-06T14:58:03+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000440s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002305s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000540s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003204s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000854s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000391s ]
---------------------------------------------------------------
[2018-06-06T14:58:04+08:00] 127.0.0.1 GET /admin/general/profile/index?sort=id&order=desc&offset=0&limit=10&_=1528268283669
[ sql ] [ DB ] CONNECT:[ UseTime:0.000436s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001943s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000421s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002389s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000750s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002857s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
[ sql ] [ SQL ] SELECT * FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000377s ]
---------------------------------------------------------------
[2018-06-06T14:58:04+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000365s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001878s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000403s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002044s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000337s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000321s ]
---------------------------------------------------------------
[2018-06-06T14:58:04+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528268283648
[ sql ] [ DB ] CONNECT:[ UseTime:0.000358s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002298s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000391s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001980s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000627s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002149s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000307s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000332s ]
---------------------------------------------------------------
[2018-06-06T14:58:05+08:00] 127.0.0.1 GET /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002047s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000455s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002092s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000552s ]
---------------------------------------------------------------
[2018-06-06T14:58:05+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000465s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.002676s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.000356s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002362s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '[]' , '/admin/intention/unitTypeList' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528268285) [ RunTime:0.000596s ]
---------------------------------------------------------------
[2018-06-06T14:59:24+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000387s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002044s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000498s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002059s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000528s ]
---------------------------------------------------------------
[2018-06-06T14:59:24+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000470s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002167s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000380s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002001s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000664s ]
---------------------------------------------------------------
[2018-06-06T14:59:25+08:00] 127.0.0.1 GET /admin/general/profile?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000439s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002527s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000543s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003320s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000743s ]
---------------------------------------------------------------
[2018-06-06T14:59:25+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002885s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000633s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002355s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000769s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000402s ]
---------------------------------------------------------------
[2018-06-06T14:59:25+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000437s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001943s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000409s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002032s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000383s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000414s ]
---------------------------------------------------------------
[2018-06-06T14:59:25+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528268365512
[ sql ] [ DB ] CONNECT:[ UseTime:0.000447s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002117s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000438s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002186s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000549s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002445s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000488s ]
---------------------------------------------------------------
[2018-06-06T14:59:25+08:00] 127.0.0.1 GET /admin/general/profile/index?sort=id&order=desc&offset=0&limit=10&_=1528268365526
[ sql ] [ DB ] CONNECT:[ UseTime:0.000471s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002415s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000521s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002686s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000591s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.001989s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
[ sql ] [ SQL ] SELECT * FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000366s ]
---------------------------------------------------------------
[2018-06-06T15:02:54+08:00] 127.0.0.1 GET /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000405s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003631s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000664s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002111s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000560s ]
---------------------------------------------------------------
[2018-06-06T15:02:54+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000601s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.002539s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.000313s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002795s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '[]' , '/admin/intention/unitTypeList' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528268574) [ RunTime:0.000551s ]
---------------------------------------------------------------
[2018-06-06T15:03:23+08:00] 127.0.0.1 POST /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002338s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000469s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001888s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000563s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002011s ]
[ sql ] [ SQL ] SELECT `unit_name` FROM `protector` WHERE  `unit_name` = 'fad' LIMIT 1 [ RunTime:0.000257s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `usr_id` = 1  AND `status` = 0 LIMIT 1 [ RunTime:0.000323s ]
[ sql ] [ SQL ] INSERT INTO `protector` (`unit_name` , `contacts` , `phone` , `fixed_phone` , `address` , `con_position` , `unit_type` , `number` , `price` , `remark` , `usr_id` , `usr_nickname` , `pro_date` , `usr_depart` , `depart_id` , `ex_date` , `free_date`) VALUES ('fad' , 'asd' , '18110029660' , 'dsadsa' , 'asd' , 'asd' , '互联网' , 11 , 10 , '1dsa' , 1 , 'Admin' , '2018-06-06' , 'Admin group' , 1 , '2018-09-04' , '2018-10-04') [ RunTime:0.000466s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.001848s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('保护客户 添加' , '{\"dialog\":\"1\",\"row\":{\"unit_name\":\"fad\",\"contacts\":\"asd\",\"phone\":\"18110029660\",\"fixed_phone\":\"dsadsa\",\"address\":\"asd\",\"con_position\":\"asd\",\"unit_type\":\"\\u4e92\\u8054\\u7f51\",\"number\":\"11\",\"price\":\"10\",\"remark\":\"1dsa\"}}' , '/admin/protector/add?dialog=1' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528268603) [ RunTime:0.000482s ]
---------------------------------------------------------------
[2018-06-06T15:03:23+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528268365513
[ sql ] [ DB ] CONNECT:[ UseTime:0.000431s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002408s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000508s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002458s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000783s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002612s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000546s ]
---------------------------------------------------------------
[2018-06-06T15:05:12+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000451s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001986s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000398s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001909s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000532s ]
---------------------------------------------------------------
[2018-06-06T15:05:12+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000547s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002110s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000431s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002027s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000564s ]
---------------------------------------------------------------
[2018-06-06T15:05:12+08:00] 127.0.0.1 GET /admin/general/profile?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000457s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002031s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000464s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001937s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000609s ]
---------------------------------------------------------------
[2018-06-06T15:05:12+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000370s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001797s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000376s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002074s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000529s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000578s ]
---------------------------------------------------------------
[2018-06-06T15:05:12+08:00] 127.0.0.1 GET /admin/general/profile/index?sort=id&order=desc&offset=0&limit=10&_=1528268712571
[ sql ] [ DB ] CONNECT:[ UseTime:0.000476s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002506s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000447s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002738s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000870s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002700s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
[ sql ] [ SQL ] SELECT * FROM `admin_log` WHERE  `admin_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000431s ]
---------------------------------------------------------------
[2018-06-06T15:05:12+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000506s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002227s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000491s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002649s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000452s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000398s ]
---------------------------------------------------------------
[2018-06-06T15:05:12+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528268712581
[ sql ] [ DB ] CONNECT:[ UseTime:0.000411s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002001s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000468s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002263s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000624s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002998s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000456s ]
---------------------------------------------------------------
[2018-06-06T15:05:14+08:00] 127.0.0.1 GET /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000493s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002046s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000435s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002568s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000785s ]
---------------------------------------------------------------
[2018-06-06T15:05:14+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000447s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.002313s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.000288s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002272s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '[]' , '/admin/intention/unitTypeList' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528268714) [ RunTime:0.000480s ]
---------------------------------------------------------------
[2018-06-06T15:05:28+08:00] 127.0.0.1 POST /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000551s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001930s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000554s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002279s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002021s ]
[ sql ] [ SQL ] SELECT `unit_name` FROM `protector` WHERE  `unit_name` = '123ras' LIMIT 1 [ RunTime:0.000265s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `usr_id` = 1  AND `status` = 0 LIMIT 1 [ RunTime:0.000280s ]
[ sql ] [ SQL ] INSERT INTO `protector` (`unit_name` , `contacts` , `phone` , `fixed_phone` , `address` , `con_position` , `unit_type` , `number` , `price` , `remark` , `usr_id` , `usr_nickname` , `pro_date` , `total` , `usr_depart` , `depart_id` , `ex_date` , `free_date`) VALUES ('123ras' , 'sadafasd' , '18110029660' , 'adfas' , 'dasdad' , '董事长' , '国有企业' , 3 , 298 , 'asdasd' , 1 , 'Admin' , '2018-06-06' , 894 , 'Admin group' , 1 , '2018-09-04' , '2018-10-04') [ RunTime:0.000537s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.001888s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('保护客户 添加' , '{\"dialog\":\"1\",\"row\":{\"unit_name\":\"123ras\",\"contacts\":\"sadafasd\",\"phone\":\"18110029660\",\"fixed_phone\":\"adfas\",\"address\":\"dasdad\",\"con_position\":\"\\u8463\\u4e8b\\u957f\",\"unit_type\":\"\\u56fd\\u6709\\u4f01\\u4e1a\",\"number\":\"3\",\"price\":\"298\",\"remark\":\"asdasd\"}}' , '/admin/protector/add?dialog=1' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36' , '127.0.0.1' , 1528268728) [ RunTime:0.000406s ]
---------------------------------------------------------------
[2018-06-06T15:05:28+08:00] 127.0.0.1 GET /admin/protector/index/status/protect?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1528268712582
[ sql ] [ DB ] CONNECT:[ UseTime:0.000461s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002553s ]
[ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE  (  aga.uid='1' and ag.status='normal' ) [ RunTime:0.000430s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002323s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000666s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002443s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000591s ]