30_sql.log 3.4 KB

12345678910111213141516171819202122232425262728293031
  1. ---------------------------------------------------------------
  2. [2018-05-30T14:52:52+08:00] 127.0.0.1 GET /admin/index/logout
  3. [ sql ] [ DB ] CONNECT:[ UseTime:0.005620s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
  4. [ sql ] [ SQL ] SHOW COLUMNS FROM `admin` [ RunTime:0.015619s ]
  5. [ sql ] [ SQL ] SELECT * FROM `admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.003540s ]
  6. [ sql ] [ SQL ] UPDATE `admin` SET `token`='',`updatetime`=1527663172 WHERE `id` = 1 [ RunTime:0.002726s ]
  7. ---------------------------------------------------------------
  8. [2018-05-30T14:53:15+08:00] 127.0.0.1 POST /admin/index/login
  9. [ sql ] [ DB ] CONNECT:[ UseTime:0.000546s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
  10. [ sql ] [ SQL ] SHOW COLUMNS FROM `admin` [ RunTime:0.002283s ]
  11. [ sql ] [ SQL ] SELECT * FROM `admin` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000545s ]
  12. [ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002278s ]
  13. [ 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.001218s ]
  14. [ sql ] [ SQL ] UPDATE `admin` SET `logintime`=1527663195,`token`='d56ca615-5899-426e-9904-a4862bef23d5',`updatetime`=1527663195 WHERE `id` = 1 [ RunTime:0.001308s ]
  15. [ sql ] [ SQL ] SHOW COLUMNS FROM `admin_log` [ RunTime:0.002441s ]
  16. [ sql ] [ SQL ] INSERT INTO `admin_log` (`title` , `content` , `url` , `admin_id` , `username` , `useragent` , `ip` , `createtime`) VALUES ('登录' , '{\"__token__\":\"8684924d36175216b46de9b4861218d7\",\"username\":\"admin\"}' , '/admin/index/login' , 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' , 1527663195) [ RunTime:0.000939s ]
  17. ---------------------------------------------------------------
  18. [2018-05-30T14:53:15+08:00] 127.0.0.1 GET /admin/index/index
  19. [ sql ] [ DB ] CONNECT:[ UseTime:0.000567s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
  20. [ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.003164s ]
  21. [ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE ( aga.uid='1' and ag.status='normal' ) [ RunTime:0.000953s ]
  22. [ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002994s ]
  23. [ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE `status` = 'normal' [ RunTime:0.000859s ]
  24. ---------------------------------------------------------------
  25. [2018-05-30T14:53:15+08:00] 127.0.0.1 GET /admin/dashboard?addtabs=1
  26. [ sql ] [ DB ] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;dbname=promote;charset=utf8
  27. [ sql ] [ SQL ] SHOW COLUMNS FROM `auth_group_access` [ RunTime:0.002118s ]
  28. [ sql ] [ SQL ] SELECT `aga`.`uid`,`aga`.`group_id`,`ag`.`id`,`ag`.`pid`,`ag`.`name`,`ag`.`rules` FROM `auth_group_access` `aga` LEFT JOIN `auth_group` `ag` ON `aga`.`group_id`=`ag`.`id` WHERE ( aga.uid='1' and ag.status='normal' ) [ RunTime:0.000476s ]
  29. [ sql ] [ SQL ] SHOW COLUMNS FROM `auth_rule` [ RunTime:0.002541s ]
  30. [ sql ] [ SQL ] SELECT `id`,`pid`,`condition`,`icon`,`name`,`title`,`ismenu` FROM `auth_rule` WHERE `status` = 'normal' [ RunTime:0.000680s ]
  31. [ sql ] [ SQL ] SELECT `title`,`remark` FROM `auth_rule` WHERE `name` = 'dashboard' LIMIT 1 [ RunTime:0.000441s ]