mark/application/logs/201805/31_sql.log

---------------------------------------------------------------
[2018-05-31T10:49:43+08:00] 127.0.0.1 GET /admin/dashboard?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.007337s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.017298s ]
[ 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.008349s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003043s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.001831s ]
---------------------------------------------------------------
[2018-05-31T10:49:43+08:00] 127.0.0.1 GET /admin/index/index
[ 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.002241s ]
[ 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.000417s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002293s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000655s ]
---------------------------------------------------------------
[2018-05-31T10:49:43+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000704s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.004062s ]
[ 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.000689s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003708s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000825s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.001030s ]
---------------------------------------------------------------
[2018-05-31T10:49:46+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000572s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.004155s ]
[ 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.000799s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003168s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000753s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000397s ]
---------------------------------------------------------------
[2018-05-31T10:49:46+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000467s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003238s ]
[ 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.000697s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.003333s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000481s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000489s ]
---------------------------------------------------------------
[2018-05-31T10:49:46+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527734986642
[ sql ] [ DB ] CONNECT:[ UseTime:0.000541s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002463s ]
[ 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.000492s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002451s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000737s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.003122s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001511s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ]
---------------------------------------------------------------
[2018-05-31T15:17:45+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000605s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003068s ]
[ 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.000416s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002135s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000659s ]
---------------------------------------------------------------
[2018-05-31T15:17:46+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000643s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002692s ]
[ 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_rule` [ RunTime:0.002575s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000649s ]
---------------------------------------------------------------
[2018-05-31T15:17:46+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000631s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002196s ]
[ 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.000467s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002297s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000965s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000374s ]
---------------------------------------------------------------
[2018-05-31T15:17:46+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.003651s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003062s ]
[ 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.000423s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003243s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000780s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000367s ]
---------------------------------------------------------------
[2018-05-31T15:17:46+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003648s ]
[ 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.000649s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.004217s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000825s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.001028s ]
---------------------------------------------------------------
[2018-05-31T15:17:46+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527751066534
[ 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.002634s ]
[ 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.000388s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002425s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000590s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002111s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000430s ]
---------------------------------------------------------------
[2018-05-31T15:19:27+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000380s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002668s ]
[ 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.000598s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003112s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000668s ]
---------------------------------------------------------------
[2018-05-31T15:19:27+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000487s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002096s ]
[ 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.002057s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000575s ]
---------------------------------------------------------------
[2018-05-31T15:19:27+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ 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.003417s ]
[ 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.000674s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002362s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000750s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000347s ]
---------------------------------------------------------------
[2018-05-31T15:19:27+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000359s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002114s ]
[ 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.000524s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001961s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000730s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000641s ]
---------------------------------------------------------------
[2018-05-31T15:19:27+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ 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.003020s ]
[ 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.002881s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000429s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000404s ]
---------------------------------------------------------------
[2018-05-31T15:19: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&_=1527751167564
[ sql ] [ DB ] CONNECT:[ UseTime:0.000413s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003095s ]
[ 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.003321s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.002002s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002857s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000408s ]
---------------------------------------------------------------
[2018-05-31T15:19:51+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000558s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002226s ]
[ 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.000410s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002196s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000934s ]
---------------------------------------------------------------
[2018-05-31T15:19:51+08:00] 127.0.0.1 GET /admin/index/index
[ 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.001977s ]
[ 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.000416s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002115s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000648s ]
---------------------------------------------------------------
[2018-05-31T15:19:51+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000394s ] 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.000530s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002469s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000682s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000456s ]
---------------------------------------------------------------
[2018-05-31T15:19:51+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000378s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001906s ]
[ 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_rule` [ RunTime:0.002603s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000639s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000292s ]
---------------------------------------------------------------
[2018-05-31T15:19:52+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000459s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003507s ]
[ 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.000558s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.003497s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.002790s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.001508s ]
---------------------------------------------------------------
[2018-05-31T15:19:52+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527751191691
[ sql ] [ DB ] CONNECT:[ UseTime:0.002685s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003458s ]
[ 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.001463s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003270s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000874s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002590s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000400s ]
---------------------------------------------------------------
[2018-05-31T15:20:00+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000612s ] 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.000485s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002297s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000800s ]
---------------------------------------------------------------
[2018-05-31T15:20:01+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000357s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001856s ]
[ 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.002020s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000580s ]
---------------------------------------------------------------
[2018-05-31T15:20:01+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000459s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002827s ]
[ 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.000487s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003134s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000710s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000730s ]
---------------------------------------------------------------
[2018-05-31T15:20:01+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000350s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002903s ]
[ 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_rule` [ RunTime:0.002024s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000614s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000399s ]
---------------------------------------------------------------
[2018-05-31T15:20:01+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.002161s ]
[ 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.000484s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.003138s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000432s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000404s ]
---------------------------------------------------------------
[2018-05-31T15:20:01+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527751201467
[ sql ] [ DB ] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002523s ]
[ 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.000404s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002472s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000783s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002765s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000254s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000436s ]
---------------------------------------------------------------
[2018-05-31T15:20:58+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ sql ] [ DB ] CONNECT:[ UseTime:0.000388s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002223s ]
[ 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.002406s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000566s ]
---------------------------------------------------------------
[2018-05-31T15:20:58+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000537s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002017s ]
[ 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.000467s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002335s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000572s ]
---------------------------------------------------------------
[2018-05-31T15:20:59+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ 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.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.000419s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002113s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000577s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000446s ]
---------------------------------------------------------------
[2018-05-31T15:20:59+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ 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.002925s ]
[ 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.000529s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003424s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000547s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000294s ]
---------------------------------------------------------------
[2018-05-31T15:20:59+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000646s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003627s ]
[ 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.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.003518s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000529s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000438s ]
---------------------------------------------------------------
[2018-05-31T15:20:59+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527751259370
[ 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.003219s ]
[ 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.002856s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000833s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002951s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000407s ]
---------------------------------------------------------------
[2018-05-31T15:21:09+08:00] 127.0.0.1 GET /admin/intention?ref=addtabs
[ 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.002145s ]
[ 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.000423s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001988s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000535s ]
---------------------------------------------------------------
[2018-05-31T15:21:09+08:00] 127.0.0.1 GET /admin/index/index
[ sql ] [ DB ] CONNECT:[ UseTime:0.000347s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001793s ]
[ 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.000341s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.001885s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000522s ]
---------------------------------------------------------------
[2018-05-31T15:21:10+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000494s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.004354s ]
[ 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.001246s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.004571s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.001544s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'dashboard' LIMIT 1 [ RunTime:0.000582s ]
---------------------------------------------------------------
[2018-05-31T15:21:10+08:00] 127.0.0.1 GET /admin/intention?addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000418s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002860s ]
[ 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.002947s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000952s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'intention' LIMIT 1 [ RunTime:0.000428s ]
---------------------------------------------------------------
[2018-05-31T15:21:10+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000413s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002256s ]
[ 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_group` [ RunTime:0.002344s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000400s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000371s ]
---------------------------------------------------------------
[2018-05-31T15:21:10+08:00] 127.0.0.1 GET /admin/intention/index?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527751270170
[ 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.002903s ]
[ 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.000460s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002531s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000783s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `intention` [ RunTime:0.002767s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `intention` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000302s ]
[ sql ] [ SQL ] SELECT * FROM `intention` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000396s ]
---------------------------------------------------------------
[2018-05-31T15:39:00+08:00] 127.0.0.1 GET /admin/protector/index?status=protect&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000452s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002605s ]
[ 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.000470s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002540s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000689s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000382s ]
---------------------------------------------------------------
[2018-05-31T15:39:00+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000418s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002611s ]
[ 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.002496s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000429s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000437s ]
---------------------------------------------------------------
[2018-05-31T15:39:00+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&_=1527752340343
[ sql ] [ DB ] CONNECT:[ UseTime:0.000379s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.001954s ]
[ 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.002852s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002868s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001744s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000433s ]
---------------------------------------------------------------
[2018-05-31T15:39:02+08:00] 127.0.0.1 GET /admin/protector/index?status=overdue&addtabs=1
[ 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.003103s ]
[ 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.000578s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003535s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000647s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000344s ]
---------------------------------------------------------------
[2018-05-31T15:39:02+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ 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.002371s ]
[ 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_group` [ RunTime:0.002221s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000370s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000404s ]
---------------------------------------------------------------
[2018-05-31T15:39:02+08:00] 127.0.0.1 GET /admin/protector/index/status/overdue?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527752342544
[ sql ] [ DB ] CONNECT:[ UseTime:0.000378s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002370s ]
[ 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.000470s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002634s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000776s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002269s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 1  AND `usr_id` = 1 OR `status` = 4 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 1  AND `usr_id` = 1 OR `status` = 4 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000642s ]
---------------------------------------------------------------
[2018-05-31T15:39:03+08:00] 127.0.0.1 GET /admin/protector/index?status=contract&addtabs=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002824s ]
[ 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.000470s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002553s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000752s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000389s ]
---------------------------------------------------------------
[2018-05-31T15:39:03+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.001937s ]
[ 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.000417s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group` [ RunTime:0.002120s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000407s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000459s ]
---------------------------------------------------------------
[2018-05-31T15:39:03+08:00] 127.0.0.1 GET /admin/protector/index/status/contract?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527752343464
[ 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.002133s ]
[ 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.000451s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002349s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000571s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002406s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 2  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 2  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000466s ]
---------------------------------------------------------------
[2018-05-31T15:39:05+08:00] 127.0.0.1 GET /admin/protector/add?dialog=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.003004s ]
[ 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.000506s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002641s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000786s ]
---------------------------------------------------------------
[2018-05-31T15:39:05+08:00] 127.0.0.1 POST /admin/intention/unitTypeList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000534s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `unit_type` [ RunTime:0.003959s ]
[ sql ] [ SQL ] SELECT * FROM `unit_type` [ RunTime:0.001267s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.005439s ]
[ 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/66.0.3359.181 Safari/537.36' , '127.0.0.1' , 1527752345) [ RunTime:0.007785s ]
---------------------------------------------------------------
[2018-05-31T15:39:35+08:00] 127.0.0.1 POST /admin/protector/add?dialog=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.000616s ] 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.000477s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003176s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000799s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002212s ]
[ sql ] [ SQL ] SELECT `unit_name` FROM `protector` WHERE  `unit_name` = 'adasd' LIMIT 1 [ RunTime:0.000326s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `usr_id` = 1  AND `status` = 0 LIMIT 1 [ RunTime:0.000348s ]
[ 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 ('adasd' , 'asd' , '18110029660' , '18110029660' , 'asd' , '董事长' , '私营企业' , 123 , 21 , '21212' , 1 , 'Admin' , '2018-05-31' , 'Admin group' , 1 , '2018-08-29' , '2018-09-28') [ RunTime:0.000975s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.003023s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('保护客户 添加' , '{\"dialog\":\"1\",\"row\":{\"unit_name\":\"adasd\",\"contacts\":\"asd\",\"phone\":\"18110029660\",\"fixed_phone\":\"18110029660\",\"address\":\"asd\",\"con_position\":\"\\u8463\\u4e8b\\u957f\",\"unit_type\":\"\\u79c1\\u8425\\u4f01\\u4e1a\",\"number\":\"123\",\"price\":\"21\",\"remark\":\"21212\"}}' , '/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/66.0.3359.181 Safari/537.36' , '127.0.0.1' , 1527752375) [ RunTime:0.000689s ]
---------------------------------------------------------------
[2018-05-31T15:39:35+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&_=1527752340344
[ 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.002224s ]
[ 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.002250s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000618s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002449s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000587s ]
---------------------------------------------------------------
[2018-05-31T15:40:03+08:00] 127.0.0.1 GET /admin/protector/index?status=giveup&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.003066s ]
[ 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.000797s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002818s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000651s ]
[ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE  `name` = 'protector' LIMIT 1 [ RunTime:0.000404s ]
---------------------------------------------------------------
[2018-05-31T15:40:03+08:00] 127.0.0.1 GET /admin/auth/group/departList
[ sql ] [ DB ] CONNECT:[ UseTime:0.000435s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002424s ]
[ 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_group` [ RunTime:0.002614s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `status` = 'normal' [ RunTime:0.000399s ]
[ sql ] [ SQL ] SELECT * FROM `auth_group` WHERE  `id` IN (1,2,3,6) [ RunTime:0.000407s ]
---------------------------------------------------------------
[2018-05-31T15:40:03+08:00] 127.0.0.1 GET /admin/protector/index/status/giveup?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527752403361
[ 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.002394s ]
[ 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.002204s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000935s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002118s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 4  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 4  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000486s ]
---------------------------------------------------------------
[2018-05-31T15:40:06+08:00] 127.0.0.1 GET /admin/protector/index/status/contract?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527752343465
[ sql ] [ DB ] CONNECT:[ UseTime:0.000561s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003266s ]
[ 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.003019s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000622s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.003128s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 2  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 2  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000499s ]
---------------------------------------------------------------
[2018-05-31T15:40:08+08:00] 127.0.0.1 GET /admin/protector/index/status/overdue?sort=id&order=desc&offset=0&limit=10&filter=%7B%7D&op=%7B%7D&_=1527752342545
[ 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.002437s ]
[ 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.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002895s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000781s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.002579s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 1  AND `usr_id` = 1 OR `status` = 4 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 1  AND `usr_id` = 1 OR `status` = 4 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000419s ]
---------------------------------------------------------------
[2018-05-31T15:40:09+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&_=1527752340345
[ sql ] [ DB ] CONNECT:[ UseTime:0.000459s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002066s ]
[ 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.002353s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000758s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `protector` [ RunTime:0.003206s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
[ sql ] [ SQL ] SELECT * FROM `protector` WHERE  `status` = 0  AND `usr_id` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000531s ]
---------------------------------------------------------------
[2018-05-31T15:40:11+08:00] 127.0.0.1 POST /admin/protector/showFollow
[ 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.002772s ]
[ 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.000556s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.003196s ]
[ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE  `status` = 'normal' [ RunTime:0.000678s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `follow` [ RunTime:0.002474s ]
[ sql ] [ SQL ] SELECT * FROM `follow` WHERE  `protect_id` = 9 [ RunTime:0.001002s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002459s ]
[ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('' , '{\"id\":\"9\"}' , '/admin/protector/showFollow' , 1 , 'admin' , 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36' , '127.0.0.1' , 1527752411) [ RunTime:0.000640s ]