--------------------------------------------------------------- [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 ]