[2021-03-17T15:49:58+08:00][sql] CONNECT:[ UseTime:0.002000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:49:58+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.042000s ]
[2021-03-17T15:49:58+08:00][sql] SELECT * FROM `user` WHERE (  `name` = '1018205040' ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:49:58+08:00][sql] SHOW FULL COLUMNS FROM `log` [ RunTime:0.069000s ]
[2021-03-17T15:49:58+08:00][sql] INSERT INTO `log` SET `user_id` = 1 , `action` = '登录' , `url` = '/admin/auth/login' , `ip` = '::1' , `user_agent` = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36' , `create_time` = 1615967398 , `update_time` = 1615967398 [ RunTime:0.001000s ]
[2021-03-17T15:49:59+08:00][sql] CONNECT:[ UseTime:0.002000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:49:59+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.008000s ]
[2021-03-17T15:49:59+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:49:59+08:00][sql] SHOW FULL COLUMNS FROM `permission` [ RunTime:0.061000s ]
[2021-03-17T15:49:59+08:00][sql] SELECT * FROM `permission` WHERE (  `status` = 1 ) AND `permission`.`delete_time` = 0 ORDER BY `pid` ASC [ RunTime:0.001000s ]
[2021-03-17T15:49:59+08:00][sql] SELECT * FROM `permission` WHERE (  `type` <> 'action'  AND `status` = 1 ) AND `permission`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:05+08:00][sql] CONNECT:[ UseTime:0.011000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:05+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.010000s ]
[2021-03-17T15:50:05+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:05+08:00][sql] SHOW FULL COLUMNS FROM `permission` [ RunTime:0.009000s ]
[2021-03-17T15:50:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `permission` WHERE (  `type` <> 'action' ) AND `permission`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:05+08:00][sql] SELECT * FROM `permission` WHERE (  `type` = 'action' ) AND `permission`.`delete_time` = 0 [ RunTime:0.000000s ]
[2021-03-17T15:50:05+08:00][sql] SELECT * FROM `permission` `m` WHERE (  `type` <> 'action' ) AND `m`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:05+08:00][sql] SELECT * FROM `permission` WHERE (  `type` <> 'action'  AND `status` = 1 ) AND `permission`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:12+08:00][sql] CONNECT:[ UseTime:0.002000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:12+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.008000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:12+08:00][sql] SHOW FULL COLUMNS FROM `role` [ RunTime:0.075000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `role` WHERE (  `id` <> 1 ) AND `role`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT * FROM `role` WHERE (  `id` <> 1 ) AND `role`.`delete_time` = 0 LIMIT 0,10 [ RunTime:0.001000s ]
[2021-03-17T15:50:12+08:00][sql] SHOW FULL COLUMNS FROM `role_permission_access` [ RunTime:0.039000s ]
[2021-03-17T15:50:12+08:00][sql] SHOW FULL COLUMNS FROM `permission` [ RunTime:0.008000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT `permission`.*,`pivot`.`role_id` AS `pivot__role_id`,`pivot`.`permission_id` AS `pivot__permission_id` FROM `permission` INNER JOIN `role_permission_access` `pivot` ON `pivot`.`permission_id`=`permission`.`id` WHERE (  `pivot`.`role_id` = 3 ) AND `permission`.`delete_time` = 0 [ RunTime:0.020000s ]
[2021-03-17T15:50:12+08:00][sql] SHOW FULL COLUMNS FROM `role_dept_access` [ RunTime:0.032000s ]
[2021-03-17T15:50:12+08:00][sql] SHOW FULL COLUMNS FROM `dept` [ RunTime:0.063000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT `dept`.*,`pivot`.`role_id` AS `pivot__role_id`,`pivot`.`dept_id` AS `pivot__dept_id` FROM `dept` INNER JOIN `role_dept_access` `pivot` ON `pivot`.`dept_id`=`dept`.`id` WHERE (  `pivot`.`role_id` = 3 ) AND `dept`.`delete_time` = 0 [ RunTime:0.027000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT * FROM `role` WHERE `role`.`delete_time` = 0 [ RunTime:0.000000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT `id`,`title`,`pid`,`type` FROM `permission` WHERE `permission`.`delete_time` = 0 ORDER BY `pid` ASC [ RunTime:0.001000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT * FROM `dept` WHERE `dept`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:12+08:00][sql] SELECT * FROM `permission` WHERE (  `type` <> 'action'  AND `status` = 1 ) AND `permission`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:17+08:00][sql] CONNECT:[ UseTime:0.002000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.009000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `user` `u` WHERE `u`.`delete_time` = 0 [ RunTime:0.000000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT `u`.*,`d`.`name` FROM `user` `u` INNER JOIN `dept` `d` ON `d`.`id`=`u`.`dept_id` WHERE `u`.`delete_time` = 0 LIMIT 0,10 [ RunTime:0.000000s ]
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `user_post_access` [ RunTime:0.029000s ]
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `post` [ RunTime:0.061000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT `post`.*,`pivot`.`user_id` AS `pivot__user_id`,`pivot`.`post_id` AS `pivot__post_id` FROM `post` INNER JOIN `user_post_access` `pivot` ON `pivot`.`post_id`=`post`.`id` WHERE (  `pivot`.`user_id` = 3 ) AND `post`.`delete_time` = 0 [ RunTime:0.017000s ]
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `user_role_access` [ RunTime:0.052000s ]
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `role` [ RunTime:0.008000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT `role`.*,`pivot`.`user_id` AS `pivot__user_id`,`pivot`.`role_id` AS `pivot__role_id` FROM `role` INNER JOIN `user_role_access` `pivot` ON `pivot`.`role_id`=`role`.`id` WHERE (  `pivot`.`user_id` = 3 ) AND `role`.`delete_time` = 0 [ RunTime:0.002000s ]
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `role_permission_access` [ RunTime:0.009000s ]
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `permission` [ RunTime:0.009000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT `permission`.*,`pivot`.`role_id` AS `pivot__role_id`,`pivot`.`permission_id` AS `pivot__permission_id` FROM `permission` INNER JOIN `role_permission_access` `pivot` ON `pivot`.`permission_id`=`permission`.`id` WHERE (  `pivot`.`role_id` = 3 ) AND `permission`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT * FROM `permission` WHERE  `name` IN ('InfoAnalysis','InfoWorkspace','FetchPermission','FetchRole','FetchAccount','FetchDept','FetchPost','FetchLogAccount','FetchLogDb','FetchArticle','FetchArticleCategory') [ RunTime:0.001000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT `id`,`title`,`pid`,`type` FROM `permission` WHERE `permission`.`delete_time` = 0 ORDER BY `pid` ASC [ RunTime:0.000000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT * FROM `role` WHERE `role`.`delete_time` = 0 [ RunTime:0.000000s ]
[2021-03-17T15:50:17+08:00][sql] SHOW FULL COLUMNS FROM `dept` [ RunTime:0.009000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT * FROM `dept` WHERE `dept`.`delete_time` = 0 [ RunTime:0.000000s ]
[2021-03-17T15:50:17+08:00][sql] SELECT * FROM `post` WHERE `post`.`delete_time` = 0 ORDER BY `sort` DESC [ RunTime:0.001000s ]
[2021-03-17T15:50:19+08:00][sql] CONNECT:[ UseTime:0.001000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:19+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.009000s ]
[2021-03-17T15:50:19+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:19+08:00][sql] SHOW FULL COLUMNS FROM `dept` [ RunTime:0.008000s ]
[2021-03-17T15:50:19+08:00][sql] SELECT * FROM `dept` WHERE `dept`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:21+08:00][sql] CONNECT:[ UseTime:0.002000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:21+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.009000s ]
[2021-03-17T15:50:21+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:21+08:00][sql] SHOW FULL COLUMNS FROM `post` [ RunTime:0.008000s ]
[2021-03-17T15:50:21+08:00][sql] SELECT * FROM `post` WHERE `post`.`delete_time` = 0 ORDER BY `sort` DESC [ RunTime:0.001000s ]
[2021-03-17T15:50:23+08:00][sql] CONNECT:[ UseTime:0.020000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:23+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.007000s ]
[2021-03-17T15:50:23+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000000s ]
[2021-03-17T15:50:23+08:00][sql] SHOW FULL COLUMNS FROM `log` [ RunTime:0.008000s ]
[2021-03-17T15:50:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `log` `l` INNER JOIN `user` `u` ON `u`.`id`=`l`.`user_id` WHERE `l`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:23+08:00][sql] SELECT `l`.*,`u`.`nickname` FROM `log` `l` INNER JOIN `user` `u` ON `u`.`id`=`l`.`user_id` WHERE `l`.`delete_time` = 0 ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.001000s ]
[2021-03-17T15:50:25+08:00][sql] CONNECT:[ UseTime:0.001000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:25+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.007000s ]
[2021-03-17T15:50:25+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:25+08:00][sql] SHOW FULL COLUMNS FROM `db_log` [ RunTime:0.075000s ]
[2021-03-17T15:50:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `db_log` WHERE `db_log`.`delete_time` = 0 [ RunTime:0.001000s ]
[2021-03-17T15:50:25+08:00][sql] SELECT `d`.*,`u`.`nickname` FROM `db_log` `d` INNER JOIN `user` `u` ON `d`.`user_id`=`u`.`id` WHERE `d`.`delete_time` = 0 ORDER BY `d`.`create_time` DESC LIMIT 0,10 [ RunTime:0.000000s ]
[2021-03-17T15:50:28+08:00][sql] CONNECT:[ UseTime:0.001000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:28+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.008000s ]
[2021-03-17T15:50:28+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:32+08:00][sql] CONNECT:[ UseTime:0.011000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:32+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.008000s ]
[2021-03-17T15:50:32+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:32+08:00][sql] SHOW FULL COLUMNS FROM `article` [ RunTime:0.076000s ]
[2021-03-17T15:50:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `article` `a` INNER JOIN `article_category` `c` ON `a`.`category_id`=`c`.`id` WHERE `a`.`delete_time` = 0 [ RunTime:0.044000s ]
[2021-03-17T15:50:32+08:00][sql] SELECT `a`.`id`,`a`.`image`,`a`.`title`,`a`.`top`,`a`.`sort`,`a`.`create_time`,`a`.`update_time`,`a`.`status`,c.name as category_name FROM `article` `a` INNER JOIN `article_category` `c` ON `a`.`category_id`=`c`.`id` WHERE `a`.`delete_time` = 0 ORDER BY `top` DESC,`a`.`id` DESC LIMIT 0,10 [ RunTime:0.001000s ]
[2021-03-17T15:50:34+08:00][sql] CONNECT:[ UseTime:0.011000s ] mysql:host=localhost;port=3306;dbname=antvue;charset=utf8mb4
[2021-03-17T15:50:34+08:00][sql] SHOW FULL COLUMNS FROM `user` [ RunTime:0.009000s ]
[2021-03-17T15:50:34+08:00][sql] SELECT * FROM `user` WHERE (  `id` = 1 ) AND `user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001000s ]
[2021-03-17T15:50:34+08:00][sql] SHOW FULL COLUMNS FROM `article_category` [ RunTime:0.008000s ]
[2021-03-17T15:50:34+08:00][sql] SELECT * FROM `article_category` WHERE `article_category`.`delete_time` = 0 ORDER BY `pid` ASC [ RunTime:0.000000s ]