|
Server : nginx/1.20.1 System : Linux iZ2ze9ojcl78uluczwag69Z 4.18.0-240.22.1.el8_3.x86_64 #1 SMP Thu Apr 8 19:01:30 UTC 2021 x86_64 User : www ( 1000) PHP Version : 7.3.28 Disable Function : passthru,exec,system,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/0531yanglao.com/runtime/admin/log/202209/ |
[2022-09-12T09:14:53+08:00][error] [401]账号登录状态已过期[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T09:15:08+08:00][sql] CONNECT:[ UseTime:0.011147s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:15:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.039433s ]
[2022-09-12T09:15:08+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'admin' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.026131s ]
[2022-09-12T09:15:08+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 09:15:08' , `login_num` = 262 WHERE `admin_user_id` = 1 [ RunTime:0.051096s ]
[2022-09-12T09:15:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.012622s ]
[2022-09-12T09:15:08+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 1 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"admin\";s:9:\"verify_id\";s:32:\"e3caf585fe36b77199194422200df87e\";s:11:\"verify_code\";s:4:\"9985\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 09:15:08' [ RunTime:0.025687s ]
[2022-09-12T09:15:08+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.001593s ]
[2022-09-12T09:15:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005455s ]
[2022-09-12T09:15:08+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.009360s ]
[2022-09-12T09:15:08+08:00][sql] CONNECT:[ UseTime:0.002053s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:15:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.011081s ]
[2022-09-12T09:15:08+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.005681s ]
[2022-09-12T09:15:44+08:00][sql] CONNECT:[ UseTime:0.004020s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:15:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.031924s ]
[2022-09-12T09:15:44+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.013537s ]
[2022-09-12T09:15:44+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.004457s ]
[2022-09-12T09:15:46+08:00][sql] CONNECT:[ UseTime:0.002079s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:15:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.012145s ]
[2022-09-12T09:15:46+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000874s ]
[2022-09-12T09:15:46+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `dg_admin_user` WHERE `is_delete` = 0 ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,13 [ RunTime:0.002205s ]
[2022-09-12T09:15:54+08:00][sql] CONNECT:[ UseTime:0.001875s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:15:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.018104s ]
[2022-09-12T09:15:54+08:00][sql] SELECT `admin_user_id` FROM `dg_admin_user` WHERE `username` = 'aaron' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006613s ]
[2022-09-12T09:15:54+08:00][sql] SELECT `admin_user_id` FROM `dg_admin_user` WHERE `nickname` = 'aaron' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.011573s ]
[2022-09-12T09:15:54+08:00][sql] INSERT INTO `dg_admin_user` SET `username` = 'aaron' , `nickname` = 'aaron' , `password` = 'e10adc3949ba59abbe56e057f20f883e' , `email` = '' , `remark` = '' , `sort` = 200 , `create_time` = '2022-09-12 09:15:54' [ RunTime:0.005042s ]
[2022-09-12T09:15:54+08:00][sql] CONNECT:[ UseTime:0.001734s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:15:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.005676s ]
[2022-09-12T09:15:54+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.004139s ]
[2022-09-12T09:15:54+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `dg_admin_user` WHERE `is_delete` = 0 ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,13 [ RunTime:0.001194s ]
[2022-09-12T09:15:59+08:00][sql] CONNECT:[ UseTime:0.001036s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:15:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.006220s ]
[2022-09-12T09:15:59+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.001975s ]
[2022-09-12T09:15:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.003002s ]
[2022-09-12T09:15:59+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 0 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.002722s ]
[2022-09-12T09:15:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001474s ]
[2022-09-12T09:15:59+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( 0 = 1 AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.002616s ]
[2022-09-12T09:15:59+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.000369s ]
[2022-09-12T09:15:59+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,999 [ RunTime:0.000297s ]
[2022-09-12T09:16:05+08:00][sql] CONNECT:[ UseTime:0.000652s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.008639s ]
[2022-09-12T09:16:05+08:00][sql] UPDATE `dg_admin_user` SET `admin_role_ids` = '4' , `admin_menu_ids` = '' , `update_time` = '2022-09-12 09:16:05' WHERE `admin_user_id` = 2 [ RunTime:0.007440s ]
[2022-09-12T09:16:05+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.001838s ]
[2022-09-12T09:16:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.002142s ]
[2022-09-12T09:16:05+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.001363s ]
[2022-09-12T09:16:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001433s ]
[2022-09-12T09:16:05+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.007427s ]
[2022-09-12T09:16:05+08:00][sql] CONNECT:[ UseTime:0.016517s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.023542s ]
[2022-09-12T09:16:05+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.006978s ]
[2022-09-12T09:16:05+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `dg_admin_user` WHERE `is_delete` = 0 ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,13 [ RunTime:0.008661s ]
[2022-09-12T09:16:08+08:00][sql] CONNECT:[ UseTime:0.001417s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.004243s ]
[2022-09-12T09:16:08+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.001772s ]
[2022-09-12T09:16:08+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000354s ]
[2022-09-12T09:16:10+08:00][sql] CONNECT:[ UseTime:0.001160s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.006155s ]
[2022-09-12T09:16:10+08:00][sql] SELECT * FROM `dg_admin_role` WHERE `admin_role_id` = 4 LIMIT 1 [ RunTime:0.000919s ]
[2022-09-12T09:16:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.004949s ]
[2022-09-12T09:16:10+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `dg_admin_user` WHERE ( `admin_role_ids` LIKE '4' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4' AND `is_delete` = 0 ) [ RunTime:0.005950s ]
[2022-09-12T09:16:10+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `dg_admin_user` WHERE ( `admin_role_ids` LIKE '4' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4' AND `is_delete` = 0 ) ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,10 [ RunTime:0.000975s ]
[2022-09-12T09:16:22+08:00][sql] CONNECT:[ UseTime:0.002196s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.005421s ]
[2022-09-12T09:16:22+08:00][sql] SELECT `admin_role_id` FROM `dg_admin_role` WHERE `admin_role_id` <> 4 AND `role_name` = '用户组' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004136s ]
[2022-09-12T09:16:22+08:00][sql] UPDATE `dg_admin_role` SET `role_name` = '用户组' , `role_desc` = '' , `role_sort` = 200 , `admin_menu_ids` = '12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194' , `update_time` = '2022-09-12 09:16:22' WHERE `admin_role_id` = 4 [ RunTime:0.004016s ]
[2022-09-12T09:16:23+08:00][sql] CONNECT:[ UseTime:0.002885s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:23+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.010421s ]
[2022-09-12T09:16:23+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.003929s ]
[2022-09-12T09:16:23+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001692s ]
[2022-09-12T09:16:39+08:00][sql] CONNECT:[ UseTime:0.001384s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.008184s ]
[2022-09-12T09:16:39+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'aaron' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003285s ]
[2022-09-12T09:16:39+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 09:16:39' , `login_num` = 1 WHERE `admin_user_id` = 2 [ RunTime:0.004496s ]
[2022-09-12T09:16:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.003070s ]
[2022-09-12T09:16:39+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 2 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"aaron\";s:9:\"verify_id\";s:32:\"ab9084c917387fdcba511cbb41675d17\";s:11:\"verify_code\";s:4:\"7160\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 09:16:39' [ RunTime:0.010109s ]
[2022-09-12T09:16:39+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.001063s ]
[2022-09-12T09:16:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.003668s ]
[2022-09-12T09:16:39+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.004902s ]
[2022-09-12T09:16:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003037s ]
[2022-09-12T09:16:39+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.004047s ]
[2022-09-12T09:16:39+08:00][sql] CONNECT:[ UseTime:0.000593s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:16:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004079s ]
[2022-09-12T09:16:39+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminUser/userAuthMenu' LIMIT 1 [ RunTime:0.001525s ]
[2022-09-12T09:16:39+08:00][error] [403]你没有权限操作：管理员授权菜单[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T09:18:04+08:00][sql] CONNECT:[ UseTime:0.006258s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.027289s ]
[2022-09-12T09:18:04+08:00][sql] SELECT `admin_menu_id` FROM `dg_admin_menu` WHERE `admin_menu_id` <> 0 AND `menu_pid` = 12 AND `menu_name` = '管理员授权菜单' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.012133s ]
[2022-09-12T09:18:04+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 12 LIMIT 1 [ RunTime:0.006837s ]
[2022-09-12T09:18:04+08:00][sql] INSERT INTO `dg_admin_menu` SET `menu_pid` = 12 , `menu_name` = '管理员授权菜单' , `menu_url` = 'admin/AdminUser/userAuthMenu' , `menu_sort` = 200 , `menu_request` = '<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>参数</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>field_name</td><td>string</td><td>选填</td><td>请求参数示例字段</td><td>示例值</td></tr></tbody></table>' , `menu_response` = '<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>参数</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>code</td><td>integer</td><td>必返</td><td>返回码，200成功，401登录失效，404接口地址错误，500服务器错误，其它失败</td><td>200</td></tr><tr><td>msg</td><td>string</td><td>必返</td><td>返回描述</td><td>成功</td></tr><tr><td>data</td><td>array</td><td>必返</td><td>返回数据</td><td></td></tr></tbody></table><p>返回数据data：</p><table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>字段</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>field_name</td><td>string</td><td>选返</td><td>返回数据示例字段</td><td>示例值</td></tr></tbody></table>' , `menu_explain` = '' , `vue_component` = '' , `vue_hidden` = 0 , `vue_path` = '' , `vue_name` = '' , `vue_icon` = 'el-icon-platform-eleme' , `level` = 3 , `create_time` = '2022-09-12 09:18:04' [ RunTime:0.028121s ]
[2022-09-12T09:18:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.003610s ]
[2022-09-12T09:18:04+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.007328s ]
[2022-09-12T09:18:04+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.002647s ]
[2022-09-12T09:18:04+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.004095s ]
[2022-09-12T09:18:04+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000579s ]
[2022-09-12T09:18:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.003347s ]
[2022-09-12T09:18:04+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.010110s ]
[2022-09-12T09:18:04+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001656s ]
[2022-09-12T09:18:04+08:00][sql] CONNECT:[ UseTime:0.000971s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.008620s ]
[2022-09-12T09:18:04+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_name`,`menu_url`,`menu_sort`,`is_disable`,`is_unauth`,`create_time`,`update_time`,`vue_component`,`vue_path` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC,`admin_menu_id` ASC [ RunTime:0.002642s ]
[2022-09-12T09:18:08+08:00][sql] CONNECT:[ UseTime:0.001476s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.009932s ]
[2022-09-12T09:18:08+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.003287s ]
[2022-09-12T09:18:08+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000865s ]
[2022-09-12T09:18:10+08:00][sql] CONNECT:[ UseTime:0.000660s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.002890s ]
[2022-09-12T09:18:10+08:00][sql] SELECT * FROM `dg_admin_role` WHERE `admin_role_id` = 4 LIMIT 1 [ RunTime:0.000492s ]
[2022-09-12T09:18:14+08:00][sql] CONNECT:[ UseTime:0.001927s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.004045s ]
[2022-09-12T09:18:14+08:00][sql] SELECT `admin_role_id` FROM `dg_admin_role` WHERE `admin_role_id` <> 4 AND `role_name` = '用户组' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004647s ]
[2022-09-12T09:18:14+08:00][sql] UPDATE `dg_admin_role` SET `role_name` = '用户组' , `role_desc` = '' , `role_sort` = 200 , `admin_menu_ids` = '12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195' , `update_time` = '2022-09-12 09:18:14' WHERE `admin_role_id` = 4 [ RunTime:0.002491s ]
[2022-09-12T09:18:14+08:00][sql] CONNECT:[ UseTime:0.007139s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.038874s ]
[2022-09-12T09:18:14+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.006582s ]
[2022-09-12T09:18:14+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000784s ]
[2022-09-12T09:18:24+08:00][sql] CONNECT:[ UseTime:0.001195s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.007118s ]
[2022-09-12T09:18:24+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'aaron' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001091s ]
[2022-09-12T09:18:24+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 09:18:24' , `login_num` = 2 WHERE `admin_user_id` = 2 [ RunTime:0.011153s ]
[2022-09-12T09:18:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.002474s ]
[2022-09-12T09:18:24+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 2 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"aaron\";s:9:\"verify_id\";s:32:\"80929df73883be6c8935e8d0653d244c\";s:11:\"verify_code\";s:4:\"1257\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 09:18:24' [ RunTime:0.009939s ]
[2022-09-12T09:18:24+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000991s ]
[2022-09-12T09:18:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.001963s ]
[2022-09-12T09:18:24+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.003838s ]
[2022-09-12T09:18:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004330s ]
[2022-09-12T09:18:24+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.004084s ]
[2022-09-12T09:18:27+08:00][sql] CONNECT:[ UseTime:0.001189s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002758s ]
[2022-09-12T09:18:27+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.003290s ]
[2022-09-12T09:18:42+08:00][sql] CONNECT:[ UseTime:0.000647s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001975s ]
[2022-09-12T09:18:42+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.000508s ]
[2022-09-12T09:18:50+08:00][sql] CONNECT:[ UseTime:0.001593s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:18:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.004216s ]
[2022-09-12T09:18:50+08:00][sql] SELECT COUNT(`admin_log_id`) AS think_count FROM `dg_admin_log` WHERE `admin_user_id` = 2 AND `is_delete` = 0 [ RunTime:0.004424s ]
[2022-09-12T09:18:50+08:00][sql] SELECT `admin_log_id`,`admin_user_id`,`admin_menu_id`,`request_method`,`request_ip`,`request_region`,`request_isp`,`response_code`,`response_msg`,`create_time` FROM `dg_admin_log` WHERE `admin_user_id` = 2 AND `is_delete` = 0 ORDER BY `admin_log_id` DESC LIMIT 0,13 [ RunTime:0.002921s ]
[2022-09-12T09:18:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004500s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 51 LIMIT 1 [ RunTime:0.001891s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 52 LIMIT 1 [ RunTime:0.000307s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 17 LIMIT 1 [ RunTime:0.000567s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 22 LIMIT 1 [ RunTime:0.000957s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 13 LIMIT 1 [ RunTime:0.000974s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 154 LIMIT 1 [ RunTime:0.000252s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 151 LIMIT 1 [ RunTime:0.000819s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 126 LIMIT 1 [ RunTime:0.000315s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 126 LIMIT 1 [ RunTime:0.000413s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 133 LIMIT 1 [ RunTime:0.001246s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 141 LIMIT 1 [ RunTime:0.000317s ]
[2022-09-12T09:18:50+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 124 LIMIT 1 [ RunTime:0.000224s ]
[2022-09-12T09:41:00+08:00][sql] CONNECT:[ UseTime:0.003435s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:41:00+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.007495s ]
[2022-09-12T09:41:00+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002692s ]
[2022-09-12T09:41:42+08:00][sql] CONNECT:[ UseTime:0.001171s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:41:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.012601s ]
[2022-09-12T09:41:42+08:00][sql] UPDATE `dg_admin_user` SET `logout_time` = '2022-09-12 09:41:42' WHERE `admin_user_id` = 2 [ RunTime:0.007636s ]
[2022-09-12T09:41:48+08:00][sql] CONNECT:[ UseTime:0.001432s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:41:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.012141s ]
[2022-09-12T09:41:48+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'aaron' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001373s ]
[2022-09-12T09:41:48+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 09:41:48' , `login_num` = 3 WHERE `admin_user_id` = 2 [ RunTime:0.004636s ]
[2022-09-12T09:41:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.007683s ]
[2022-09-12T09:41:48+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 2 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"aaron\";s:9:\"verify_id\";s:32:\"3ab2bd2417d66d36a244117cde6dcf70\";s:11:\"verify_code\";s:4:\"1216\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 09:41:48' [ RunTime:0.007196s ]
[2022-09-12T09:41:48+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000846s ]
[2022-09-12T09:41:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.003373s ]
[2022-09-12T09:41:48+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.001948s ]
[2022-09-12T09:41:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002470s ]
[2022-09-12T09:41:48+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.003534s ]
[2022-09-12T09:41:48+08:00][sql] CONNECT:[ UseTime:0.001315s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:41:48+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004019s ]
[2022-09-12T09:41:48+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.001182s ]
[2022-09-12T09:41:51+08:00][sql] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:41:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004342s ]
[2022-09-12T09:41:51+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.000864s ]
[2022-09-12T09:42:05+08:00][sql] CONNECT:[ UseTime:0.001157s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:42:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.003733s ]
[2022-09-12T09:42:05+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.005140s ]
[2022-09-12T09:42:05+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.003185s ]
[2022-09-12T09:42:07+08:00][sql] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T09:42:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.005389s ]
[2022-09-12T09:42:07+08:00][sql] SELECT * FROM `dg_admin_role` WHERE `admin_role_id` = 4 LIMIT 1 [ RunTime:0.000616s ]
[2022-09-12T14:08:59+08:00][sql] CONNECT:[ UseTime:0.005999s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:08:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.026034s ]
[2022-09-12T14:08:59+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.013488s ]
[2022-09-12T14:08:59+08:00][sql] CONNECT:[ UseTime:0.001514s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:08:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.009109s ]
[2022-09-12T14:08:59+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.007028s ]
[2022-09-12T14:08:59+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.009690s ]
[2022-09-12T14:09:29+08:00][sql] CONNECT:[ UseTime:0.002264s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:09:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.013854s ]
[2022-09-12T14:09:29+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.007088s ]
[2022-09-12T14:09:29+08:00][sql] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:09:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001857s ]
[2022-09-12T14:09:29+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.001754s ]
[2022-09-12T14:09:30+08:00][sql] CONNECT:[ UseTime:0.001211s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:09:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.002349s ]
[2022-09-12T14:09:30+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.000395s ]
[2022-09-12T14:09:30+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001076s ]
[2022-09-12T14:11:31+08:00][sql] CONNECT:[ UseTime:0.005124s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.022107s ]
[2022-09-12T14:11:31+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.007545s ]
[2022-09-12T14:11:31+08:00][sql] CONNECT:[ UseTime:0.005124s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.022106s ]
[2022-09-12T14:11:31+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.007118s ]
[2022-09-12T14:11:31+08:00][sql] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.009781s ]
[2022-09-12T14:11:31+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.005758s ]
[2022-09-12T14:11:31+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.002739s ]
[2022-09-12T14:11:35+08:00][sql] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:11:35+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005568s ]
[2022-09-12T14:11:35+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.013260s ]
[2022-09-12T14:11:57+08:00][sql] CONNECT:[ UseTime:0.001130s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:11:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005236s ]
[2022-09-12T14:11:57+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002517s ]
[2022-09-12T14:11:57+08:00][sql] CONNECT:[ UseTime:0.001271s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:11:57+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.007514s ]
[2022-09-12T14:11:57+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.001852s ]
[2022-09-12T14:11:57+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001284s ]
[2022-09-12T14:13:01+08:00][sql] CONNECT:[ UseTime:0.003671s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:13:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.009320s ]
[2022-09-12T14:13:01+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.007161s ]
[2022-09-12T14:13:02+08:00][sql] CONNECT:[ UseTime:0.001849s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:13:02+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005079s ]
[2022-09-12T14:13:02+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.000995s ]
[2022-09-12T14:13:02+08:00][sql] CONNECT:[ UseTime:0.012794s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:13:02+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.011000s ]
[2022-09-12T14:13:02+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.008082s ]
[2022-09-12T14:13:02+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.006002s ]
[2022-09-12T14:13:04+08:00][sql] CONNECT:[ UseTime:0.001321s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:13:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003174s ]
[2022-09-12T14:13:04+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.003600s ]
[2022-09-12T14:13:04+08:00][sql] CONNECT:[ UseTime:0.003943s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:13:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.004861s ]
[2022-09-12T14:13:04+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.001164s ]
[2022-09-12T14:13:04+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000461s ]
[2022-09-12T14:13:04+08:00][sql] CONNECT:[ UseTime:0.000690s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:13:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002492s ]
[2022-09-12T14:13:04+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.001893s ]
[2022-09-12T14:13:08+08:00][sql] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:13:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002830s ]
[2022-09-12T14:13:08+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.004043s ]
[2022-09-12T14:14:01+08:00][sql] CONNECT:[ UseTime:0.002387s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:14:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005052s ]
[2022-09-12T14:14:01+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.001559s ]
[2022-09-12T14:14:01+08:00][sql] CONNECT:[ UseTime:0.000818s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:14:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003370s ]
[2022-09-12T14:14:01+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.001635s ]
[2022-09-12T14:14:01+08:00][sql] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:14:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.003587s ]
[2022-09-12T14:14:01+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.002640s ]
[2022-09-12T14:14:01+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001201s ]
[2022-09-12T14:14:14+08:00][sql] CONNECT:[ UseTime:0.002088s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:14:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.006844s ]
[2022-09-12T14:14:14+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.004522s ]
[2022-09-12T14:14:14+08:00][sql] CONNECT:[ UseTime:0.004306s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:14:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.004951s ]
[2022-09-12T14:14:14+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.002401s ]
[2022-09-12T14:14:14+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001384s ]
[2022-09-12T14:14:30+08:00][error] [404]接口地址错误：admin/admin/AdminMy/myAvatar[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T14:14:37+08:00][error] [404]接口地址错误：admin/admin/AdminMy/myAvatar[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T14:15:53+08:00][sql] CONNECT:[ UseTime:0.002802s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:15:53+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.006087s ]
[2022-09-12T14:15:53+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.015356s ]
[2022-09-12T14:16:05+08:00][sql] CONNECT:[ UseTime:0.002666s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:16:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.015017s ]
[2022-09-12T14:16:05+08:00][sql] UPDATE `dg_admin_user` SET `avatar` = 'storage/admin_user/1/1_avatar.jpg?t=20220912141605' , `update_time` = '2022-09-12 14:16:05' WHERE `admin_user_id` = 1 [ RunTime:0.028183s ]
[2022-09-12T14:16:05+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.001961s ]
[2022-09-12T14:16:05+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002490s ]
[2022-09-12T14:16:05+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.002041s ]
[2022-09-12T14:16:14+08:00][sql] CONNECT:[ UseTime:0.000714s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:16:14+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005201s ]
[2022-09-12T14:16:14+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,194,193,192,190,189,188,33,187,185,42,43,44,45,46,47,48,195,169,5,54,73,168,85,3,122,121,120,115,116,117,4,75,27,51,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002019s ]
[2022-09-12T14:16:33+08:00][sql] CONNECT:[ UseTime:0.001454s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:16:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003651s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 185 LIMIT 1 [ RunTime:0.005116s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_id` FROM `dg_admin_menu` WHERE `menu_pid` = 185 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006904s ]
[2022-09-12T14:16:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.004724s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_role_id` FROM `dg_admin_role` WHERE ( `admin_menu_ids` LIKE '185' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '185,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,185,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,185' AND `is_delete` = 0 ) LIMIT 1 [ RunTime:0.004895s ]
[2022-09-12T14:16:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.003172s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_user_id` FROM `dg_admin_user` WHERE ( `admin_menu_ids` LIKE '185' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '185,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,185,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,185' AND `is_delete` = 0 ) LIMIT 1 [ RunTime:0.004029s ]
[2022-09-12T14:16:33+08:00][sql] DELETE FROM `dg_admin_menu` WHERE `admin_menu_id` = 185 [ RunTime:0.011344s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000887s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.001087s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.000944s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.001389s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.002564s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001273s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000543s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000559s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.000421s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000487s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000293s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001673s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000364s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000377s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.002065s ]
[2022-09-12T14:16:33+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000467s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000236s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.000440s ]
[2022-09-12T14:16:33+08:00][sql] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:16:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002199s ]
[2022-09-12T14:16:33+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_name`,`menu_url`,`menu_sort`,`is_disable`,`is_unauth`,`create_time`,`update_time`,`vue_component`,`vue_path` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC,`admin_menu_id` ASC [ RunTime:0.002754s ]
[2022-09-12T14:16:50+08:00][error] [404]接口地址错误：admin/dictionary/index[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T14:17:39+08:00][sql] CONNECT:[ UseTime:0.001247s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:17:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002436s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/unit/getAll' LIMIT 1 [ RunTime:0.004360s ]
[2022-09-12T14:17:39+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T14:17:39+08:00][sql] CONNECT:[ UseTime:0.001485s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:17:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.016312s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/category/getCategory' LIMIT 1 [ RunTime:0.002957s ]
[2022-09-12T14:17:39+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T14:17:39+08:00][sql] CONNECT:[ UseTime:0.002348s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:17:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.013970s ]
[2022-09-12T14:17:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` [ RunTime:0.018896s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_materials` ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.002493s ]
[2022-09-12T14:17:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003511s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.006846s ]
[2022-09-12T14:17:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.002860s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.012662s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.001335s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.001286s ]
[2022-09-12T14:17:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000573s ]
[2022-09-12T14:17:42+08:00][sql] CONNECT:[ UseTime:0.001743s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005331s ]
[2022-09-12T14:17:42+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.001932s ]
[2022-09-12T14:17:42+08:00][sql] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004791s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/unit/getAll' LIMIT 1 [ RunTime:0.002472s ]
[2022-09-12T14:17:42+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T14:17:42+08:00][sql] CONNECT:[ UseTime:0.002623s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.008031s ]
[2022-09-12T14:17:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` [ RunTime:0.006151s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_materials` ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001706s ]
[2022-09-12T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002752s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.002920s ]
[2022-09-12T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.003868s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.002297s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000264s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000333s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000270s ]
[2022-09-12T14:17:42+08:00][sql] CONNECT:[ UseTime:0.000578s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002587s ]
[2022-09-12T14:17:42+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/category/getCategory' LIMIT 1 [ RunTime:0.001037s ]
[2022-09-12T14:17:42+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T14:38:30+08:00][sql] CONNECT:[ UseTime:0.004479s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:38:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.011968s ]
[2022-09-12T14:38:30+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.011654s ]
[2022-09-12T14:38:37+08:00][sql] CONNECT:[ UseTime:0.001310s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:38:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.006349s ]
[2022-09-12T14:38:37+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.002865s ]
[2022-09-12T14:38:37+08:00][sql] CONNECT:[ UseTime:0.001095s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:38:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003203s ]
[2022-09-12T14:38:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.005118s ]
[2022-09-12T14:38:37+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001082s ]
[2022-09-12T14:38:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001406s ]
[2022-09-12T14:38:37+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.004976s ]
[2022-09-12T14:38:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.002061s ]
[2022-09-12T14:38:37+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.003927s ]
[2022-09-12T14:38:37+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000310s ]
[2022-09-12T14:38:37+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000270s ]
[2022-09-12T14:38:37+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000263s ]
[2022-09-12T14:39:18+08:00][sql] CONNECT:[ UseTime:0.001810s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005302s ]
[2022-09-12T14:39:18+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.004488s ]
[2022-09-12T14:39:19+08:00][sql] CONNECT:[ UseTime:0.002419s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.004624s ]
[2022-09-12T14:39:19+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.003648s ]
[2022-09-12T14:39:19+08:00][sql] CONNECT:[ UseTime:0.007099s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.006242s ]
[2022-09-12T14:39:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.001194s ]
[2022-09-12T14:39:19+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001768s ]
[2022-09-12T14:39:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001926s ]
[2022-09-12T14:39:19+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.003777s ]
[2022-09-12T14:39:19+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.007068s ]
[2022-09-12T14:39:19+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.004772s ]
[2022-09-12T14:39:19+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000663s ]
[2022-09-12T14:39:19+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000428s ]
[2022-09-12T14:39:19+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000491s ]
[2022-09-12T14:39:25+08:00][sql] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005536s ]
[2022-09-12T14:39:25+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002859s ]
[2022-09-12T14:39:25+08:00][sql] CONNECT:[ UseTime:0.000837s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003860s ]
[2022-09-12T14:39:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.003459s ]
[2022-09-12T14:39:25+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001692s ]
[2022-09-12T14:39:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001238s ]
[2022-09-12T14:39:25+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.002142s ]
[2022-09-12T14:39:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001244s ]
[2022-09-12T14:39:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.003018s ]
[2022-09-12T14:39:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000673s ]
[2022-09-12T14:39:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000486s ]
[2022-09-12T14:39:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000296s ]
[2022-09-12T14:39:25+08:00][sql] CONNECT:[ UseTime:0.000876s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002163s ]
[2022-09-12T14:39:25+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.001198s ]
[2022-09-12T14:39:54+08:00][sql] CONNECT:[ UseTime:0.002002s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004406s ]
[2022-09-12T14:39:54+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002880s ]
[2022-09-12T14:39:54+08:00][sql] CONNECT:[ UseTime:0.001401s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003268s ]
[2022-09-12T14:39:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.000579s ]
[2022-09-12T14:39:54+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.000962s ]
[2022-09-12T14:39:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003497s ]
[2022-09-12T14:39:54+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.000779s ]
[2022-09-12T14:39:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001501s ]
[2022-09-12T14:39:54+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.001357s ]
[2022-09-12T14:39:54+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.001080s ]
[2022-09-12T14:39:54+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.001166s ]
[2022-09-12T14:39:54+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000521s ]
[2022-09-12T14:39:54+08:00][sql] CONNECT:[ UseTime:0.001322s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:39:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002455s ]
[2022-09-12T14:39:54+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.002381s ]
[2022-09-12T14:40:25+08:00][sql] CONNECT:[ UseTime:0.003188s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:40:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.007299s ]
[2022-09-12T14:40:25+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002307s ]
[2022-09-12T14:40:26+08:00][sql] CONNECT:[ UseTime:0.011222s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:40:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004516s ]
[2022-09-12T14:40:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.002323s ]
[2022-09-12T14:40:26+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001656s ]
[2022-09-12T14:40:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001776s ]
[2022-09-12T14:40:26+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.001591s ]
[2022-09-12T14:40:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001578s ]
[2022-09-12T14:40:26+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.001313s ]
[2022-09-12T14:40:26+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000539s ]
[2022-09-12T14:40:26+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000530s ]
[2022-09-12T14:40:26+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.001521s ]
[2022-09-12T14:40:26+08:00][sql] CONNECT:[ UseTime:0.000913s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:40:26+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.004134s ]
[2022-09-12T14:40:26+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000455s ]
[2022-09-12T14:40:29+08:00][sql] CONNECT:[ UseTime:0.001295s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:40:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004867s ]
[2022-09-12T14:40:29+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 2 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001033s ]
[2022-09-12T14:40:29+08:00][sql] SELECT * FROM `dg_materials` WHERE `materials_id` = 2 [ RunTime:0.000350s ]
[2022-09-12T14:40:29+08:00][sql] UPDATE `dg_materials` SET `delete_time` = 1662964829 , `update_time` = 1662964829 WHERE ( `materials_id` = 2 ) AND `dg_materials`.`delete_time` IS NULL [ RunTime:0.004806s ]
[2022-09-12T14:40:29+08:00][sql] CONNECT:[ UseTime:0.000638s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:40:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002075s ]
[2022-09-12T14:40:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.003599s ]
[2022-09-12T14:40:29+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001168s ]
[2022-09-12T14:40:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002234s ]
[2022-09-12T14:40:29+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` = 2 [ RunTime:0.002626s ]
[2022-09-12T14:40:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001790s ]
[2022-09-12T14:40:29+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.003582s ]
[2022-09-12T14:40:29+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000335s ]
[2022-09-12T14:41:15+08:00][sql] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:41:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003281s ]
[2022-09-12T14:41:15+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.002420s ]
[2022-09-12T14:41:15+08:00][sql] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:41:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_equipment` [ RunTime:0.008919s ]
[2022-09-12T14:41:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_equipment` [ RunTime:0.011324s ]
[2022-09-12T14:41:15+08:00][sql] SELECT * FROM `dg_equipment` ORDER BY `eid` ASC LIMIT 0,20 [ RunTime:0.001516s ]
[2022-09-12T14:41:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002213s ]
[2022-09-12T14:41:15+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` = 2 [ RunTime:0.002301s ]
[2022-09-12T14:41:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.003113s ]
[2022-09-12T14:41:15+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.001304s ]
[2022-09-12T14:41:15+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.001802s ]
[2022-09-12T14:41:22+08:00][sql] CONNECT:[ UseTime:0.000726s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:41:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_equipment` [ RunTime:0.001492s ]
[2022-09-12T14:41:22+08:00][sql] SELECT * FROM `dg_equipment` WHERE `eid` = 1 LIMIT 1 [ RunTime:0.003902s ]
[2022-09-12T14:41:22+08:00][sql] SELECT * FROM `dg_equipment` WHERE `eid` = 1 [ RunTime:0.001530s ]
[2022-09-12T14:41:22+08:00][sql] DELETE FROM `dg_equipment` WHERE `eid` = 1 [ RunTime:0.002434s ]
[2022-09-12T14:41:22+08:00][sql] CONNECT:[ UseTime:0.000639s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:41:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_equipment` [ RunTime:0.004468s ]
[2022-09-12T14:41:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_equipment` [ RunTime:0.000910s ]
[2022-09-12T14:41:22+08:00][sql] SELECT * FROM `dg_equipment` ORDER BY `eid` ASC LIMIT 0,20 [ RunTime:0.001004s ]
[2022-09-12T14:44:17+08:00][sql] CONNECT:[ UseTime:0.001366s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:44:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_attachment` [ RunTime:0.006761s ]
[2022-09-12T14:44:17+08:00][sql] INSERT INTO `dg_attachment` SET `name` = 'src=http _5b0988e595225.cdn.sohucs.com_images_20200417_478ad028059c4656bd7d312a098488ef.jpeg&refer=http _5b0988e595225.cdn.sohucs.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg.jpg' , `filename` = '/storage/20220912/9be2d8d09cc7c546b7dfefe7e470001d.jpg' , `url` = 'http://host-9:8000/storage/20220912/9be2d8d09cc7c546b7dfefe7e470001d.jpg' , `hash` = 'c4fd45b092fc0b3583d00d4cd6aceaa8' [ RunTime:0.003781s ]
[2022-09-12T14:44:20+08:00][sql] CONNECT:[ UseTime:0.000707s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:44:20+08:00][sql] SHOW FULL COLUMNS FROM `dg_attachment` [ RunTime:0.001336s ]
[2022-09-12T14:44:20+08:00][sql] INSERT INTO `dg_attachment` SET `name` = 'src=http _hbimg.b0.upaiyun.com_deab990c471fedcfc8f90d9cf59518bfe06d228a43b7b-qaXVu8_fw658&refer=http _hbimg.b0.upaiyun.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg.jpg' , `filename` = '/storage/20220912/1355c53a64c6ad8dc25e7619011a67fe.jpg' , `url` = 'http://host-9:8000/storage/20220912/1355c53a64c6ad8dc25e7619011a67fe.jpg' , `hash` = '4a9d899ce25592b3b0f0eda6922f14ba' [ RunTime:0.001989s ]
[2022-09-12T14:45:03+08:00][sql] CONNECT:[ UseTime:0.003591s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_equipment` [ RunTime:0.009071s ]
[2022-09-12T14:45:03+08:00][sql] INSERT INTO `dg_equipment` SET `city_id` = 1 , `category_id` = 4 , `unit_id` = 2 , `manufacturer` = '1212' , `purchase_price` = '122' , `quantity` = 1 , `delivery_person` = '122' , `receiptr_img` = 'http://host-9:8000/storage/20220912/9be2d8d09cc7c546b7dfefe7e470001d.jpg' , `equipment_img` = 'http://host-9:8000/storage/20220912/1355c53a64c6ad8dc25e7619011a67fe.jpg' , `remark` = '22' , `user_id` = 1 , `create_time` = 1662965103 , `update_time` = 1662965103 [ RunTime:0.004164s ]
[2022-09-12T14:45:03+08:00][sql] CONNECT:[ UseTime:0.003470s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_equipment` [ RunTime:0.009964s ]
[2022-09-12T14:45:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_equipment` [ RunTime:0.001521s ]
[2022-09-12T14:45:03+08:00][sql] SELECT * FROM `dg_equipment` ORDER BY `eid` ASC LIMIT 0,20 [ RunTime:0.002624s ]
[2022-09-12T14:45:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002746s ]
[2022-09-12T14:45:03+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` = 2 [ RunTime:0.002923s ]
[2022-09-12T14:45:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001585s ]
[2022-09-12T14:45:03+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.003313s ]
[2022-09-12T14:45:03+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.001047s ]
[2022-09-12T14:45:28+08:00][sql] CONNECT:[ UseTime:0.001048s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_attachment` [ RunTime:0.002020s ]
[2022-09-12T14:45:28+08:00][sql] INSERT INTO `dg_attachment` SET `name` = 'src=http _b-ssl.duitang.com_uploads_item_201708_25_20170825162754_xrv2i.thumb.700_0.jpeg&refer=http _b-ssl.duitang.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg.jpg' , `filename` = '/storage/20220912/472680a9ee49f3e925fbbcb39b11ab2d.jpg' , `url` = 'http://host-9:8000/storage/20220912/472680a9ee49f3e925fbbcb39b11ab2d.jpg' , `hash` = 'e1ebbe1adef2a2ee7b75d7b4764a7be6' [ RunTime:0.001843s ]
[2022-09-12T14:45:30+08:00][sql] CONNECT:[ UseTime:0.001285s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_attachment` [ RunTime:0.004471s ]
[2022-09-12T14:45:30+08:00][sql] INSERT INTO `dg_attachment` SET `name` = 'src=http _b-ssl.duitang.com_uploads_item_201708_25_20170825162754_xrv2i.thumb.700_0.jpeg&refer=http _b-ssl.duitang.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg.jpg' , `filename` = '/storage/20220912/0e2b8adee90a8c22c645a9734fa9e792.jpg' , `url` = 'http://host-9:8000/storage/20220912/0e2b8adee90a8c22c645a9734fa9e792.jpg' , `hash` = 'a6bdc7548f2a1a2d6b912cf2b19d83eb' [ RunTime:0.001838s ]
[2022-09-12T14:45:32+08:00][sql] CONNECT:[ UseTime:0.000813s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:32+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003582s ]
[2022-09-12T14:45:32+08:00][sql] INSERT INTO `dg_materials` SET `materials_id` = 0 , `city_id` = 1 , `category_id` = 4 , `unit_id` = 1 , `purchase_price` = '1212' , `quantity` = 1 , `delivery_person` = '211' , `receiptr_img` = 'http://host-9:8000/storage/20220912/472680a9ee49f3e925fbbcb39b11ab2d.jpg' , `materials_img` = 'http://host-9:8000/storage/20220912/0e2b8adee90a8c22c645a9734fa9e792.jpg' , `remark` = '212' , `user_id` = 1 , `create_time` = 1662965132 , `update_time` = 1662965132 [ RunTime:0.002198s ]
[2022-09-12T14:45:32+08:00][sql] CONNECT:[ UseTime:0.021956s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:32+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.012837s ]
[2022-09-12T14:45:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.001191s ]
[2022-09-12T14:45:32+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.002824s ]
[2022-09-12T14:45:32+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002780s ]
[2022-09-12T14:45:32+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.000966s ]
[2022-09-12T14:45:32+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.004897s ]
[2022-09-12T14:45:32+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.001208s ]
[2022-09-12T14:45:32+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000617s ]
[2022-09-12T14:45:32+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.001127s ]
[2022-09-12T14:45:32+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000749s ]
[2022-09-12T14:45:35+08:00][sql] CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:35+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002625s ]
[2022-09-12T14:45:35+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 3 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000647s ]
[2022-09-12T14:45:39+08:00][sql] CONNECT:[ UseTime:0.001413s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:45:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004175s ]
[2022-09-12T14:45:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.000460s ]
[2022-09-12T14:45:39+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,13 [ RunTime:0.000357s ]
[2022-09-12T14:45:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002642s ]
[2022-09-12T14:45:39+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (1,2) [ RunTime:0.001165s ]
[2022-09-12T14:45:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.002352s ]
[2022-09-12T14:45:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.001367s ]
[2022-09-12T14:45:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000388s ]
[2022-09-12T14:45:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.001348s ]
[2022-09-12T14:45:39+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000321s ]
[2022-09-12T14:47:21+08:00][sql] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:47:21+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002386s ]
[2022-09-12T14:47:21+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 3 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000505s ]
[2022-09-12T14:47:29+08:00][sql] CONNECT:[ UseTime:0.001781s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:47:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004174s ]
[2022-09-12T14:47:29+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 3 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001353s ]
[2022-09-12T14:47:29+08:00][sql] UPDATE `dg_materials` SET `delivery_person` = '2111' , `delete_time` = 0 , `update_time` = 1662965249 WHERE ( `materials_id` = 3 ) AND `dg_materials`.`delete_time` IS NULL [ RunTime:0.002429s ]
[2022-09-12T14:48:36+08:00][sql] CONNECT:[ UseTime:0.002756s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:48:36+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.006583s ]
[2022-09-12T14:48:36+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 3 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000624s ]
[2022-09-12T14:48:36+08:00][error] [10501]SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'dg_materials.PRIMARY'[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/PDOConnection.php:795]
[2022-09-12T14:50:09+08:00][sql] CONNECT:[ UseTime:0.002884s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:50:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.006208s ]
[2022-09-12T14:50:09+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 3 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001074s ]
[2022-09-12T14:50:09+08:00][error] [10501]SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'dg_materials.PRIMARY'[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/PDOConnection.php:795]
[2022-09-12T14:51:06+08:00][sql] CONNECT:[ UseTime:0.001001s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:06+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003680s ]
[2022-09-12T14:51:06+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 3 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002071s ]
[2022-09-12T14:51:06+08:00][error] [10501]SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'dg_materials.PRIMARY'[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/PDOConnection.php:795]
[2022-09-12T14:51:10+08:00][sql] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002159s ]
[2022-09-12T14:51:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.002248s ]
[2022-09-12T14:51:10+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,13 [ RunTime:0.000554s ]
[2022-09-12T14:51:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.005489s ]
[2022-09-12T14:51:10+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` = 2 [ RunTime:0.002669s ]
[2022-09-12T14:51:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001311s ]
[2022-09-12T14:51:10+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.002514s ]
[2022-09-12T14:51:10+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000702s ]
[2022-09-12T14:51:12+08:00][sql] CONNECT:[ UseTime:0.001388s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:12+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003248s ]
[2022-09-12T14:51:12+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001407s ]
[2022-09-12T14:51:22+08:00][sql] CONNECT:[ UseTime:0.001430s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004015s ]
[2022-09-12T14:51:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.001582s ]
[2022-09-12T14:51:22+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,13 [ RunTime:0.000360s ]
[2022-09-12T14:51:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001768s ]
[2022-09-12T14:51:22+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` = 2 [ RunTime:0.000484s ]
[2022-09-12T14:51:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.002691s ]
[2022-09-12T14:51:22+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.001320s ]
[2022-09-12T14:51:22+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000505s ]
[2022-09-12T14:51:28+08:00][sql] CONNECT:[ UseTime:0.000613s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002914s ]
[2022-09-12T14:51:28+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.006820s ]
[2022-09-12T14:51:28+08:00][sql] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002149s ]
[2022-09-12T14:51:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.001499s ]
[2022-09-12T14:51:28+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.000522s ]
[2022-09-12T14:51:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001171s ]
[2022-09-12T14:51:28+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` = 2 [ RunTime:0.001649s ]
[2022-09-12T14:51:28+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.003944s ]
[2022-09-12T14:51:28+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000983s ]
[2022-09-12T14:51:28+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000598s ]
[2022-09-12T14:51:29+08:00][sql] CONNECT:[ UseTime:0.000712s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.004915s ]
[2022-09-12T14:51:29+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000497s ]
[2022-09-12T14:51:30+08:00][sql] CONNECT:[ UseTime:0.000558s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:30+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.001820s ]
[2022-09-12T14:51:30+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000435s ]
[2022-09-12T14:51:37+08:00][sql] CONNECT:[ UseTime:0.001725s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:51:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.001817s ]
[2022-09-12T14:51:37+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001186s ]
[2022-09-12T14:51:37+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `remark` = 'dfsdf123' , `delete_time` = 0 , `update_time` = 1662965497 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` IS NULL [ RunTime:0.002973s ]
[2022-09-12T14:53:00+08:00][sql] CONNECT:[ UseTime:0.001285s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:53:00+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.006903s ]
[2022-09-12T14:53:00+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000628s ]
[2022-09-12T14:53:00+08:00][error] [10501]SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'dg_materials.PRIMARY'[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/PDOConnection.php:795]
[2022-09-12T14:53:50+08:00][sql] CONNECT:[ UseTime:0.004983s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:53:50+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.005764s ]
[2022-09-12T14:53:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.000693s ]
[2022-09-12T14:53:50+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,13 [ RunTime:0.000427s ]
[2022-09-12T14:53:54+08:00][sql] CONNECT:[ UseTime:0.000990s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:53:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002360s ]
[2022-09-12T14:53:54+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002578s ]
[2022-09-12T14:53:54+08:00][sql] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:53:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.011688s ]
[2022-09-12T14:53:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.003445s ]
[2022-09-12T14:53:54+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001619s ]
[2022-09-12T14:53:54+08:00][sql] CONNECT:[ UseTime:0.009085s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:53:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.004807s ]
[2022-09-12T14:53:54+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.001819s ]
[2022-09-12T14:54:25+08:00][sql] CONNECT:[ UseTime:0.001203s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:54:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004723s ]
[2022-09-12T14:54:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.000549s ]
[2022-09-12T14:54:25+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,13 [ RunTime:0.000411s ]
[2022-09-12T14:54:29+08:00][sql] CONNECT:[ UseTime:0.000696s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:54:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003298s ]
[2022-09-12T14:54:29+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002952s ]
[2022-09-12T14:54:29+08:00][sql] CONNECT:[ UseTime:0.002934s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:54:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002674s ]
[2022-09-12T14:54:29+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.001778s ]
[2022-09-12T14:54:29+08:00][sql] CONNECT:[ UseTime:0.002909s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:54:29+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003100s ]
[2022-09-12T14:54:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.001213s ]
[2022-09-12T14:54:29+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001151s ]
[2022-09-12T14:55:01+08:00][sql] CONNECT:[ UseTime:0.001374s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001814s ]
[2022-09-12T14:55:01+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.003826s ]
[2022-09-12T14:55:01+08:00][sql] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.004065s ]
[2022-09-12T14:55:01+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000895s ]
[2022-09-12T14:55:01+08:00][sql] CONNECT:[ UseTime:0.002021s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004808s ]
[2022-09-12T14:55:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.000494s ]
[2022-09-12T14:55:01+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.000526s ]
[2022-09-12T14:55:06+08:00][sql] CONNECT:[ UseTime:0.000585s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:06+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004416s ]
[2022-09-12T14:55:06+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.003023s ]
[2022-09-12T14:55:07+08:00][sql] CONNECT:[ UseTime:0.001526s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003054s ]
[2022-09-12T14:55:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.001220s ]
[2022-09-12T14:55:07+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.000849s ]
[2022-09-12T14:55:07+08:00][sql] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003316s ]
[2022-09-12T14:55:07+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000570s ]
[2022-09-12T14:55:24+08:00][sql] CONNECT:[ UseTime:0.001049s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003362s ]
[2022-09-12T14:55:24+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.001097s ]
[2022-09-12T14:55:25+08:00][sql] CONNECT:[ UseTime:0.002180s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003630s ]
[2022-09-12T14:55:25+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.001146s ]
[2022-09-12T14:55:25+08:00][sql] CONNECT:[ UseTime:0.002771s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004165s ]
[2022-09-12T14:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL [ RunTime:0.001243s ]
[2022-09-12T14:55:25+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` IS NULL ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.000457s ]
[2022-09-12T14:56:51+08:00][sql] CONNECT:[ UseTime:0.003192s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:56:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.007150s ]
[2022-09-12T14:56:51+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.007926s ]
[2022-09-12T14:56:51+08:00][sql] CONNECT:[ UseTime:0.001905s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:56:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002579s ]
[2022-09-12T14:56:51+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.004053s ]
[2022-09-12T14:56:51+08:00][sql] CONNECT:[ UseTime:0.001782s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:56:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004732s ]
[2022-09-12T14:56:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' [ RunTime:0.000963s ]
[2022-09-12T14:56:51+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.001148s ]
[2022-09-12T14:56:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.004714s ]
[2022-09-12T14:56:51+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (2,1) [ RunTime:0.002678s ]
[2022-09-12T14:56:51+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001836s ]
[2022-09-12T14:56:51+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.004324s ]
[2022-09-12T14:56:51+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000501s ]
[2022-09-12T14:56:51+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.000408s ]
[2022-09-12T14:56:51+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000910s ]
[2022-09-12T14:57:07+08:00][sql] CONNECT:[ UseTime:0.001155s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:57:07+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003450s ]
[2022-09-12T14:57:07+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.001498s ]
[2022-09-12T14:57:08+08:00][sql] CONNECT:[ UseTime:0.000747s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:57:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.001764s ]
[2022-09-12T14:57:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' [ RunTime:0.000480s ]
[2022-09-12T14:57:08+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.000965s ]
[2022-09-12T14:57:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001655s ]
[2022-09-12T14:57:08+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (2,1) [ RunTime:0.001113s ]
[2022-09-12T14:57:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001630s ]
[2022-09-12T14:57:08+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.002035s ]
[2022-09-12T14:57:08+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.002298s ]
[2022-09-12T14:57:08+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.000905s ]
[2022-09-12T14:57:08+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000270s ]
[2022-09-12T14:57:08+08:00][sql] CONNECT:[ UseTime:0.001348s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:57:08+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.005140s ]
[2022-09-12T14:57:08+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000575s ]
[2022-09-12T14:57:10+08:00][sql] CONNECT:[ UseTime:0.001737s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:57:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004172s ]
[2022-09-12T14:57:10+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.002802s ]
[2022-09-12T14:57:23+08:00][sql] CONNECT:[ UseTime:0.001117s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:57:23+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004691s ]
[2022-09-12T14:57:23+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001689s ]
[2022-09-12T14:57:23+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `remark` = 'dfsdf1234' , `delete_time` = 0 , `update_time` = 1662965843 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.004216s ]
[2022-09-12T14:57:23+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000701s ]
[2022-09-12T14:57:52+08:00][sql] CONNECT:[ UseTime:0.001567s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:57:52+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.001727s ]
[2022-09-12T14:57:52+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.002059s ]
[2022-09-12T14:57:52+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.002037s ]
[2022-09-12T14:57:52+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `delete_time` = 0 , `update_time` = 1662965872 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.001692s ]
[2022-09-12T14:57:59+08:00][sql] CONNECT:[ UseTime:0.000674s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:57:59+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004274s ]
[2022-09-12T14:57:59+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.002078s ]
[2022-09-12T14:57:59+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.002168s ]
[2022-09-12T14:57:59+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `remark` = 'dfsdf12345' , `delete_time` = 0 , `update_time` = 1662965879 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.003331s ]
[2022-09-12T14:58:49+08:00][sql] CONNECT:[ UseTime:0.002814s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T14:58:49+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004244s ]
[2022-09-12T14:58:49+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001155s ]
[2022-09-12T14:58:49+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `remark` = 'dfsdf123456' , `delete_time` = 0 , `update_time` = 1662965929 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.003562s ]
[2022-09-12T15:02:24+08:00][sql] CONNECT:[ UseTime:0.003836s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:02:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.012629s ]
[2022-09-12T15:02:24+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001390s ]
[2022-09-12T15:02:24+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000833s ]
[2022-09-12T15:02:24+08:00][sql] SHOW FULL COLUMNS FROM `dg_delete_record` [ RunTime:0.001797s ]
[2022-09-12T15:02:24+08:00][error] [8]未定义数组下标: 0[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/Builder.php:168]
[2022-09-12T15:04:44+08:00][sql] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:04:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002847s ]
[2022-09-12T15:04:44+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001077s ]
[2022-09-12T15:04:44+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000287s ]
[2022-09-12T15:04:44+08:00][sql] SHOW FULL COLUMNS FROM `dg_delete_record` [ RunTime:0.002155s ]
[2022-09-12T15:04:44+08:00][error] [8]未定义数组下标: 0[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/Builder.php:168]
[2022-09-12T15:06:15+08:00][sql] CONNECT:[ UseTime:0.000787s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:06:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002186s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000897s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001541s ]
[2022-09-12T15:06:15+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `remark` = 'dfsdf1234567' , `delete_time` = 0 , `update_time` = 1662966375 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.002063s ]
[2022-09-12T15:06:15+08:00][sql] CONNECT:[ UseTime:0.001480s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:06:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.004022s ]
[2022-09-12T15:06:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' [ RunTime:0.001164s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.000979s ]
[2022-09-12T15:06:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003084s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (2,1) [ RunTime:0.001558s ]
[2022-09-12T15:06:15+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001943s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.001698s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000389s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.001127s ]
[2022-09-12T15:06:15+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.001499s ]
[2022-09-12T15:06:18+08:00][sql] CONNECT:[ UseTime:0.000613s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:06:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002541s ]
[2022-09-12T15:06:18+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000439s ]
[2022-09-12T15:06:27+08:00][sql] CONNECT:[ UseTime:0.001386s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:06:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.001997s ]
[2022-09-12T15:06:27+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001300s ]
[2022-09-12T15:06:27+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000418s ]
[2022-09-12T15:06:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_delete_record` [ RunTime:0.004409s ]
[2022-09-12T15:06:27+08:00][error] [8]未定义数组下标: 0[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/Builder.php:168]
[2022-09-12T15:06:36+08:00][sql] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:06:36+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003051s ]
[2022-09-12T15:06:36+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001897s ]
[2022-09-12T15:06:36+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001004s ]
[2022-09-12T15:06:36+08:00][sql] SHOW FULL COLUMNS FROM `dg_delete_record` [ RunTime:0.004010s ]
[2022-09-12T15:06:36+08:00][error] [8]未定义数组下标: 0[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/Builder.php:168]
[2022-09-12T15:07:01+08:00][sql] CONNECT:[ UseTime:0.000550s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:07:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.005124s ]
[2022-09-12T15:07:01+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000431s ]
[2022-09-12T15:07:01+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001503s ]
[2022-09-12T15:07:01+08:00][sql] SHOW FULL COLUMNS FROM `dg_delete_record` [ RunTime:0.001639s ]
[2022-09-12T15:07:01+08:00][sql] INSERT INTO `dg_delete_record` SET `user_id` = 1 , `origion_data` = 'array (
\'materials_id\' => 1,
\'user_id\' => 0,
\'city_id\' => 2,
\'category_id\' => 5,
\'unit_id\' => 2,
\'purchase_price\' => 1200.0,
\'quantity\' => 100,
\'delivery_person\' => \'aaron\',
\'receiptr_img\' => \'http://host-9:8000/storage/20220911/f9bf9d218d065b3224caeb596ce370fe.jpg\',
\'materials_img\' => \'http://host-9:8000/storage/20220911/50675173b7a201aaadb5876e47bea579.jpg\',
\'remark\' => \'dfsdf1234567\',
\'delete_time\' => 0,
\'create_time\' => 1662886621,
\'update_time\' => 1662966375,
)' , `update_data` = 'array (
\'materials_id\' => \'1\',
\'user_id\' => \'0\',
\'city_id\' => \'2\',
\'category_id\' => \'5\',
\'unit_id\' => \'2\',
\'purchase_price\' => \'1200\',
\'quantity\' => \'100\',
\'delivery_person\' => \'aaron\',
\'receiptr_img\' => \'http://host-9:8000/storage/20220911/f9bf9d218d065b3224caeb596ce370fe.jpg\',
\'materials_img\' => \'http://host-9:8000/storage/20220911/50675173b7a201aaadb5876e47bea579.jpg\',
\'remark\' => \'dfsdf12345678\',
\'delete_time\' => \'0\',
\'create_time\' => \'1662886621\',
\'update_time\' => \'1662966375\',
\'type\' => \'default\',
)' , `create_time` = 1662966421 [ RunTime:0.003209s ]
[2022-09-12T15:07:01+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `remark` = 'dfsdf12345678' , `delete_time` = 0 , `update_time` = 1662966421 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.001593s ]
[2022-09-12T15:07:18+08:00][sql] CONNECT:[ UseTime:0.000763s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:07:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.001924s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.002961s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' LIMIT 1 [ RunTime:0.001156s ]
[2022-09-12T15:07:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_delete_record` [ RunTime:0.003161s ]
[2022-09-12T15:07:18+08:00][sql] INSERT INTO `dg_delete_record` SET `user_id` = 1 , `origion_data` = 'array (
\'materials_id\' => 1,
\'user_id\' => 0,
\'city_id\' => 2,
\'category_id\' => 5,
\'unit_id\' => 2,
\'purchase_price\' => 1200.0,
\'quantity\' => 100,
\'delivery_person\' => \'aaron\',
\'receiptr_img\' => \'http://host-9:8000/storage/20220911/f9bf9d218d065b3224caeb596ce370fe.jpg\',
\'materials_img\' => \'http://host-9:8000/storage/20220911/50675173b7a201aaadb5876e47bea579.jpg\',
\'remark\' => \'dfsdf12345678\',
\'delete_time\' => 0,
\'create_time\' => 1662886621,
\'update_time\' => 1662966421,
)' , `update_data` = 'array (
\'materials_id\' => \'1\',
\'user_id\' => \'0\',
\'city_id\' => \'2\',
\'category_id\' => \'5\',
\'unit_id\' => \'2\',
\'purchase_price\' => \'1200\',
\'quantity\' => \'100\',
\'delivery_person\' => \'aaron\',
\'receiptr_img\' => \'http://host-9:8000/storage/20220911/f9bf9d218d065b3224caeb596ce370fe.jpg\',
\'materials_img\' => \'http://host-9:8000/storage/20220911/50675173b7a201aaadb5876e47bea579.jpg\',
\'remark\' => \'dfsdf12345678\',
\'delete_time\' => \'0\',
\'create_time\' => \'1662886621\',
\'update_time\' => \'1662966375\',
\'type\' => \'default\',
)' , `create_time` = 1662966438 [ RunTime:0.003797s ]
[2022-09-12T15:07:18+08:00][sql] UPDATE `dg_materials` SET `user_id` = 0 , `delete_time` = 0 , `update_time` = 1662966438 WHERE ( `materials_id` = 1 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.000880s ]
[2022-09-12T15:07:18+08:00][sql] CONNECT:[ UseTime:0.001355s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:07:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.010580s ]
[2022-09-12T15:07:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' [ RunTime:0.001130s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.001050s ]
[2022-09-12T15:07:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003745s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (2,1) [ RunTime:0.001805s ]
[2022-09-12T15:07:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001906s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000879s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000339s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.002815s ]
[2022-09-12T15:07:18+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.002435s ]
[2022-09-12T15:11:25+08:00][sql] CONNECT:[ UseTime:0.003003s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:11:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.014050s ]
[2022-09-12T15:11:25+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.007149s ]
[2022-09-12T15:11:25+08:00][sql] CONNECT:[ UseTime:0.001833s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:11:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.002547s ]
[2022-09-12T15:11:25+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000772s ]
[2022-09-12T15:11:25+08:00][sql] CONNECT:[ UseTime:0.001079s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:11:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.005120s ]
[2022-09-12T15:11:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' [ RunTime:0.002250s ]
[2022-09-12T15:11:25+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.001165s ]
[2022-09-12T15:11:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.005227s ]
[2022-09-12T15:11:25+08:00][sql] SELECT * FROM `dg_unit` WHERE `unit_id` IN (2,1) [ RunTime:0.001591s ]
[2022-09-12T15:11:25+08:00][sql] SHOW FULL COLUMNS FROM `dg_category` [ RunTime:0.001492s ]
[2022-09-12T15:11:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 5 LIMIT 1 [ RunTime:0.000956s ]
[2022-09-12T15:11:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 2 LIMIT 1 [ RunTime:0.000394s ]
[2022-09-12T15:11:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 4 LIMIT 1 [ RunTime:0.002174s ]
[2022-09-12T15:11:25+08:00][sql] SELECT * FROM `dg_category` WHERE `cid` = 1 LIMIT 1 [ RunTime:0.000534s ]
[2022-09-12T15:11:54+08:00][sql] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:11:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003780s ]
[2022-09-12T15:11:54+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.003481s ]
[2022-09-12T15:11:54+08:00][sql] CONNECT:[ UseTime:0.000579s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:11:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003421s ]
[2022-09-12T15:11:54+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/unit/getAll' LIMIT 1 [ RunTime:0.004337s ]
[2022-09-12T15:11:54+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T15:11:54+08:00][sql] CONNECT:[ UseTime:0.001301s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:11:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.005276s ]
[2022-09-12T15:11:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE ( `user_id` = 2 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.000796s ]
[2022-09-12T15:11:54+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `user_id` = 2 ) AND `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.004378s ]
[2022-09-12T15:11:54+08:00][sql] CONNECT:[ UseTime:0.001631s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:11:54+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001836s ]
[2022-09-12T15:11:54+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/category/getCategory' LIMIT 1 [ RunTime:0.002660s ]
[2022-09-12T15:11:54+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T15:12:09+08:00][sql] CONNECT:[ UseTime:0.000637s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.002876s ]
[2022-09-12T15:12:09+08:00][sql] UPDATE `dg_admin_user` SET `logout_time` = '2022-09-12 15:12:09' WHERE `admin_user_id` = 2 [ RunTime:0.008182s ]
[2022-09-12T15:12:16+08:00][sql] CONNECT:[ UseTime:0.000586s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.001652s ]
[2022-09-12T15:12:16+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'aaron' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001785s ]
[2022-09-12T15:12:16+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 15:12:16' , `login_num` = 4 WHERE `admin_user_id` = 2 [ RunTime:0.004771s ]
[2022-09-12T15:12:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004873s ]
[2022-09-12T15:12:16+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminLogin/login' LIMIT 1 [ RunTime:0.001426s ]
[2022-09-12T15:12:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.005959s ]
[2022-09-12T15:12:16+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 2 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"aaron\";s:9:\"verify_id\";s:32:\"c1bb6706ee8b9651b4f0352935e85983\";s:11:\"verify_code\";s:4:\"2910\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 15:12:16' [ RunTime:0.013356s ]
[2022-09-12T15:12:16+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.001375s ]
[2022-09-12T15:12:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.001863s ]
[2022-09-12T15:12:16+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 4 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.002628s ]
[2022-09-12T15:12:16+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.002364s ]
[2022-09-12T15:12:16+08:00][sql] CONNECT:[ UseTime:0.000563s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:16+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001501s ]
[2022-09-12T15:12:16+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195) ORDER BY `menu_sort` DESC [ RunTime:0.002729s ]
[2022-09-12T15:12:17+08:00][sql] CONNECT:[ UseTime:0.000888s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004003s ]
[2022-09-12T15:12:17+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/unit/getAll' LIMIT 1 [ RunTime:0.003499s ]
[2022-09-12T15:12:17+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T15:12:17+08:00][sql] CONNECT:[ UseTime:0.001546s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.001934s ]
[2022-09-12T15:12:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE ( `user_id` = 2 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.000404s ]
[2022-09-12T15:12:17+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `user_id` = 2 ) AND `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.000920s ]
[2022-09-12T15:12:17+08:00][sql] CONNECT:[ UseTime:0.000559s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:17+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003436s ]
[2022-09-12T15:12:17+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/category/getCategory' LIMIT 1 [ RunTime:0.004766s ]
[2022-09-12T15:12:17+08:00][error] [403]你没有权限操作：[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T15:12:36+08:00][sql] CONNECT:[ UseTime:0.002408s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:36+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003161s ]
[2022-09-12T15:12:36+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,195,194,193,192,190,189,33,188,187,42,43,44,45,46,47,48,169,168,5,54,73,3,85,122,121,120,117,115,116,4,75,51,27,52,31,28,113,41,32,118,114,30,12,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002666s ]
[2022-09-12T15:12:41+08:00][sql] CONNECT:[ UseTime:0.000601s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:41+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.003115s ]
[2022-09-12T15:12:41+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.003005s ]
[2022-09-12T15:12:41+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001138s ]
[2022-09-12T15:12:42+08:00][sql] CONNECT:[ UseTime:0.001119s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:12:42+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.003064s ]
[2022-09-12T15:12:42+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `dg_admin_user` WHERE ( `admin_role_ids` LIKE '4' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4' AND `is_delete` = 0 ) [ RunTime:0.004435s ]
[2022-09-12T15:12:42+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `dg_admin_user` WHERE ( `admin_role_ids` LIKE '4' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,4' AND `is_delete` = 0 ) ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,10 [ RunTime:0.003937s ]
[2022-09-12T15:13:38+08:00][sql] CONNECT:[ UseTime:0.000998s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:13:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003917s ]
[2022-09-12T15:13:38+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 53 LIMIT 1 [ RunTime:0.004989s ]
[2022-09-12T15:13:40+08:00][sql] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:13:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.005121s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_id` FROM `dg_admin_menu` WHERE `admin_menu_id` <> 53 AND `menu_pid` = 0 AND `menu_name` = '系统管理' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000992s ]
[2022-09-12T15:13:40+08:00][sql] UPDATE `dg_admin_menu` SET `menu_pid` = 0 , `menu_name` = '系统管理' , `menu_url` = '' , `menu_sort` = 300 , `menu_request` = '' , `menu_response` = '' , `menu_explain` = '' , `vue_component` = '' , `vue_hidden` = 0 , `vue_path` = '' , `vue_name` = '' , `vue_icon` = 'el-icon-setting' , `level` = 1 , `update_time` = '2022-09-12 15:13:40' WHERE `admin_menu_id` = 53 [ RunTime:0.002196s ]
[2022-09-12T15:13:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.004376s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.002005s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.007200s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.001629s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.003563s ]
[2022-09-12T15:13:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.002037s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.003752s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001944s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 3 LIMIT 1 [ RunTime:0.000757s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.001297s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.002859s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 3 LIMIT 1 [ RunTime:0.000906s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000657s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.002129s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 4 LIMIT 1 [ RunTime:0.000947s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 0 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000434s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( 0 = 1 AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.004659s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 4 LIMIT 1 [ RunTime:0.001058s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 0 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000846s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( 0 = 1 AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001396s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000661s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000349s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.000574s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000754s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000881s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.003114s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 3 LIMIT 1 [ RunTime:0.003472s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.001545s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.003413s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 4 LIMIT 1 [ RunTime:0.000850s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 0 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000541s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( 0 = 1 AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001240s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000698s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000754s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.000545s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000442s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000305s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001015s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 3 LIMIT 1 [ RunTime:0.000588s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000278s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.000610s ]
[2022-09-12T15:13:40+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 4 LIMIT 1 [ RunTime:0.000668s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 0 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.001790s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( 0 = 1 AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.002921s ]
[2022-09-12T15:13:40+08:00][sql] CONNECT:[ UseTime:0.000673s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:13:40+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003183s ]
[2022-09-12T15:13:40+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_name`,`menu_url`,`menu_sort`,`is_disable`,`is_unauth`,`create_time`,`update_time`,`vue_component`,`vue_path` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC,`admin_menu_id` ASC [ RunTime:0.001165s ]
[2022-09-12T15:13:45+08:00][sql] CONNECT:[ UseTime:0.000564s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:13:45+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.001358s ]
[2022-09-12T15:13:45+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.000445s ]
[2022-09-12T15:13:45+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001015s ]
[2022-09-12T15:13:46+08:00][sql] CONNECT:[ UseTime:0.000636s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:13:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.002023s ]
[2022-09-12T15:13:46+08:00][sql] SELECT * FROM `dg_admin_role` WHERE `admin_role_id` = 6 LIMIT 1 [ RunTime:0.001141s ]
[2022-09-12T15:13:58+08:00][sql] CONNECT:[ UseTime:0.000526s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:13:58+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.001404s ]
[2022-09-12T15:13:58+08:00][sql] SELECT `admin_role_id` FROM `dg_admin_role` WHERE `admin_role_id` <> 6 AND `role_name` = '库房管理员二' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000555s ]
[2022-09-12T15:13:58+08:00][sql] UPDATE `dg_admin_role` SET `role_name` = '库房管理员二' , `role_desc` = '' , `role_sort` = 200 , `admin_menu_ids` = '12,45,46,47,48,51,52,54,75,88,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209' , `update_time` = '2022-09-12 15:13:58' WHERE `admin_role_id` = 6 [ RunTime:0.003534s ]
[2022-09-12T15:13:58+08:00][sql] CONNECT:[ UseTime:0.008973s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:13:58+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.040371s ]
[2022-09-12T15:13:58+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `dg_admin_role` WHERE `is_delete` = 0 [ RunTime:0.001013s ]
[2022-09-12T15:13:58+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `dg_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001690s ]
[2022-09-12T15:14:04+08:00][sql] CONNECT:[ UseTime:0.000606s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:04+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.001399s ]
[2022-09-12T15:14:04+08:00][sql] UPDATE `dg_admin_user` SET `logout_time` = '2022-09-12 15:14:04' WHERE `admin_user_id` = 2 [ RunTime:0.003100s ]
[2022-09-12T15:14:18+08:00][sql] CONNECT:[ UseTime:0.000596s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.001631s ]
[2022-09-12T15:14:18+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'admin' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001129s ]
[2022-09-12T15:14:18+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 15:14:18' , `login_num` = 275 WHERE `admin_user_id` = 1 [ RunTime:0.008069s ]
[2022-09-12T15:14:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.002143s ]
[2022-09-12T15:14:18+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 1 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"admin\";s:9:\"verify_id\";s:32:\"a368fe346f8c19842fc4779cc246ebfd\";s:11:\"verify_code\";s:4:\"6011\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 15:14:18' [ RunTime:0.004245s ]
[2022-09-12T15:14:18+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000531s ]
[2022-09-12T15:14:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002386s ]
[2022-09-12T15:14:18+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.002076s ]
[2022-09-12T15:14:18+08:00][sql] CONNECT:[ UseTime:0.001333s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:18+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001692s ]
[2022-09-12T15:14:18+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,208,207,206,205,204,203,33,202,201,42,43,44,45,46,47,48,200,199,5,54,73,198,85,197,196,195,209,115,116,117,194,193,120,121,122,3,168,169,192,187,188,189,190,4,75,51,27,52,31,28,113,41,32,118,30,12,114,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002164s ]
[2022-09-12T15:14:22+08:00][sql] CONNECT:[ UseTime:0.000896s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.001644s ]
[2022-09-12T15:14:22+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.001919s ]
[2022-09-12T15:14:22+08:00][sql] CONNECT:[ UseTime:0.001353s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:22+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.002112s ]
[2022-09-12T15:14:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' [ RunTime:0.000973s ]
[2022-09-12T15:14:22+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.000930s ]
[2022-09-12T15:14:38+08:00][sql] CONNECT:[ UseTime:0.000587s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:38+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.002825s ]
[2022-09-12T15:14:38+08:00][sql] UPDATE `dg_admin_user` SET `logout_time` = '2022-09-12 15:14:38' WHERE `admin_user_id` = 1 [ RunTime:0.001456s ]
[2022-09-12T15:14:46+08:00][sql] CONNECT:[ UseTime:0.000734s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.002841s ]
[2022-09-12T15:14:46+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'aaron' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ]
[2022-09-12T15:14:46+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 15:14:46' , `login_num` = 9 WHERE `admin_user_id` = 3 [ RunTime:0.001776s ]
[2022-09-12T15:14:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.001364s ]
[2022-09-12T15:14:46+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 3 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"aaron\";s:9:\"verify_id\";s:32:\"4ddae7f49f6edd1101e9726901d05b78\";s:11:\"verify_code\";s:4:\"8199\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 15:14:46' [ RunTime:0.002307s ]
[2022-09-12T15:14:46+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 3 LIMIT 1 [ RunTime:0.000400s ]
[2022-09-12T15:14:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.002483s ]
[2022-09-12T15:14:46+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000533s ]
[2022-09-12T15:14:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001719s ]
[2022-09-12T15:14:46+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.005241s ]
[2022-09-12T15:14:46+08:00][sql] CONNECT:[ UseTime:0.000567s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002510s ]
[2022-09-12T15:14:46+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) ORDER BY `menu_sort` DESC [ RunTime:0.001936s ]
[2022-09-12T15:14:46+08:00][sql] CONNECT:[ UseTime:0.001344s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003160s ]
[2022-09-12T15:14:46+08:00][error] [10501]SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_id' in 'where clause'[/Users/aaron/Documents/website/degao.cn/erp/vendor/topthink/think-orm/src/db/PDOConnection.php:795]
[2022-09-12T15:14:46+08:00][sql] CONNECT:[ UseTime:0.000869s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:14:46+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.003044s ]
[2022-09-12T15:14:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE ( `user_id` = 3 ) AND `dg_materials`.`delete_time` = '0' [ RunTime:0.001835s ]
[2022-09-12T15:14:46+08:00][sql] SELECT * FROM `dg_materials` WHERE ( `user_id` = 3 ) AND `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.003258s ]
[2022-09-12T15:15:33+08:00][sql] CONNECT:[ UseTime:0.004375s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:15:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.009370s ]
[2022-09-12T15:15:33+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) ORDER BY `menu_sort` DESC [ RunTime:0.001682s ]
[2022-09-12T15:15:33+08:00][sql] CONNECT:[ UseTime:0.001920s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:15:33+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003689s ]
[2022-09-12T15:15:33+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.001065s ]
[2022-09-12T15:15:34+08:00][sql] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:15:34+08:00][sql] SHOW FULL COLUMNS FROM `dg_materials` [ RunTime:0.009142s ]
[2022-09-12T15:15:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' [ RunTime:0.001648s ]
[2022-09-12T15:15:34+08:00][sql] SELECT * FROM `dg_materials` WHERE `dg_materials`.`delete_time` = '0' ORDER BY `materials_id` ASC LIMIT 0,20 [ RunTime:0.001438s ]
[2022-09-12T15:15:37+08:00][sql] CONNECT:[ UseTime:0.003854s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:15:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_equipment` [ RunTime:0.004242s ]
[2022-09-12T15:15:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_equipment` WHERE `dg_equipment`.`delete_time` = '0' [ RunTime:0.004889s ]
[2022-09-12T15:15:37+08:00][sql] SELECT * FROM `dg_equipment` WHERE `dg_equipment`.`delete_time` = '0' ORDER BY `eid` ASC LIMIT 0,20 [ RunTime:0.000665s ]
[2022-09-12T15:15:37+08:00][sql] CONNECT:[ UseTime:0.003140s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:15:37+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.006774s ]
[2022-09-12T15:15:37+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000872s ]
[2022-09-12T15:15:39+08:00][sql] CONNECT:[ UseTime:0.001229s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:15:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003667s ]
[2022-09-12T15:15:39+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `create_time` DESC [ RunTime:0.000673s ]
[2022-09-12T15:15:39+08:00][sql] CONNECT:[ UseTime:0.000606s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:15:39+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.006469s ]
[2022-09-12T15:15:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_unit` [ RunTime:0.000513s ]
[2022-09-12T15:15:39+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.000810s ]
[2022-09-12T15:17:58+08:00][sql] CONNECT:[ UseTime:0.000532s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:17:58+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001986s ]
[2022-09-12T15:17:58+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) ORDER BY `menu_sort` DESC [ RunTime:0.001227s ]
[2022-09-12T15:17:58+08:00][sql] CONNECT:[ UseTime:0.000643s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:17:58+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.003395s ]
[2022-09-12T15:17:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_unit` [ RunTime:0.001384s ]
[2022-09-12T15:17:58+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.001490s ]
[2022-09-12T15:18:03+08:00][sql] CONNECT:[ UseTime:0.000644s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:18:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002765s ]
[2022-09-12T15:18:03+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) ORDER BY `menu_sort` DESC [ RunTime:0.000773s ]
[2022-09-12T15:18:03+08:00][sql] CONNECT:[ UseTime:0.000603s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:18:03+08:00][sql] SHOW FULL COLUMNS FROM `dg_unit` [ RunTime:0.005435s ]
[2022-09-12T15:18:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `dg_unit` [ RunTime:0.000574s ]
[2022-09-12T15:18:03+08:00][sql] SELECT * FROM `dg_unit` ORDER BY `unit_id` ASC LIMIT 0,20 [ RunTime:0.000407s ]
[2022-09-12T15:19:56+08:00][error] [401]账号登录状态失效[/Users/aaron/Documents/website/degao.cn/erp/app/common.php:61]
[2022-09-12T15:20:10+08:00][sql] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:20:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.004627s ]
[2022-09-12T15:20:10+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `dg_admin_user` WHERE `username` = 'admin' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001460s ]
[2022-09-12T15:20:10+08:00][sql] UPDATE `dg_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = '' , `login_time` = '2022-09-12 15:20:10' , `login_num` = 276 WHERE `admin_user_id` = 1 [ RunTime:0.007117s ]
[2022-09-12T15:20:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_log` [ RunTime:0.002838s ]
[2022-09-12T15:20:10+08:00][sql] INSERT INTO `dg_admin_log` SET `admin_user_id` = 1 , `log_type` = 1 , `response_code` = 200 , `response_msg` = '登录成功' , `admin_menu_id` = 51 , `request_ip` = '127.0.0.1' , `request_country` = '' , `request_province` = '' , `request_city` = '' , `request_area` = '' , `request_region` = '' , `request_isp` = '' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"admin\";s:9:\"verify_id\";s:32:\"c378f4e378097d705a0f66786ec9403f\";s:11:\"verify_code\";s:4:\"8013\";}' , `request_method` = 'POST' , `create_time` = '2022-09-12 15:20:10' [ RunTime:0.002249s ]
[2022-09-12T15:20:10+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000540s ]
[2022-09-12T15:20:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.001552s ]
[2022-09-12T15:20:10+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.002072s ]
[2022-09-12T15:20:10+08:00][sql] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:20:10+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003073s ]
[2022-09-12T15:20:10+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `dg_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (53,88,13,17,158,29,15,16,14,18,19,20,22,23,24,25,208,207,206,205,204,203,33,202,201,42,43,44,45,46,47,48,200,199,5,54,73,198,85,197,196,195,209,115,116,117,194,193,120,121,122,3,168,169,192,187,188,189,190,4,75,51,27,52,31,28,113,41,32,118,30,12,114,119,35,183,111) ORDER BY `menu_sort` DESC [ RunTime:0.002355s ]
[2022-09-12T15:20:27+08:00][sql] CONNECT:[ UseTime:0.001053s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:20:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.008636s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `admin_menu_id` FROM `dg_admin_menu` WHERE `admin_menu_id` <> 0 AND `menu_pid` = 0 AND `menu_name` = '操作日志' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000718s ]
[2022-09-12T15:20:27+08:00][sql] INSERT INTO `dg_admin_menu` SET `menu_pid` = 0 , `menu_name` = '操作日志' , `menu_url` = '' , `menu_sort` = 200 , `menu_request` = '<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>参数</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>field_name</td><td>string</td><td>选填</td><td>请求参数示例字段</td><td>示例值</td></tr></tbody></table>' , `menu_response` = '<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>参数</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>code</td><td>integer</td><td>必返</td><td>返回码，200成功，401登录失效，404接口地址错误，500服务器错误，其它失败</td><td>200</td></tr><tr><td>msg</td><td>string</td><td>必返</td><td>返回描述</td><td>成功</td></tr><tr><td>data</td><td>array</td><td>必返</td><td>返回数据</td><td></td></tr></tbody></table><p>返回数据data：</p><table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>字段</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>field_name</td><td>string</td><td>选返</td><td>返回数据示例字段</td><td>示例值</td></tr></tbody></table>' , `menu_explain` = '' , `vue_component` = '' , `vue_hidden` = 0 , `vue_path` = '' , `vue_name` = '' , `vue_icon` = 'el-icon-platform-eleme' , `level` = 1 , `create_time` = '2022-09-12 15:20:27' [ RunTime:0.003761s ]
[2022-09-12T15:20:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.003854s ]
[2022-09-12T15:20:27+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.001167s ]
[2022-09-12T15:20:27+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000547s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.000411s ]
[2022-09-12T15:20:27+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.000463s ]
[2022-09-12T15:20:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.001289s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.001523s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001271s ]
[2022-09-12T15:20:27+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.001587s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000416s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.000692s ]
[2022-09-12T15:20:27+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 3 LIMIT 1 [ RunTime:0.001714s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000833s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001750s ]
[2022-09-12T15:20:27+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 4 LIMIT 1 [ RunTime:0.000479s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 0 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000263s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( 0 = 1 AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001095s ]
[2022-09-12T15:20:27+08:00][sql] CONNECT:[ UseTime:0.001886s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:20:27+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.004973s ]
[2022-09-12T15:20:27+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_name`,`menu_url`,`menu_sort`,`is_disable`,`is_unauth`,`create_time`,`update_time`,`vue_component`,`vue_path` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC,`admin_menu_id` ASC [ RunTime:0.001581s ]
[2022-09-12T15:21:09+08:00][sql] CONNECT:[ UseTime:0.001931s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:21:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.003219s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `admin_menu_id` FROM `dg_admin_menu` WHERE `admin_menu_id` <> 0 AND `menu_pid` = 210 AND `menu_name` = '材料/设备操作日志' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001268s ]
[2022-09-12T15:21:09+08:00][sql] SELECT * FROM `dg_admin_menu` WHERE `admin_menu_id` = 210 LIMIT 1 [ RunTime:0.002539s ]
[2022-09-12T15:21:09+08:00][sql] INSERT INTO `dg_admin_menu` SET `menu_pid` = 210 , `menu_name` = '材料/设备操作日志' , `menu_url` = 'admin/deleteRecord/index' , `menu_sort` = 200 , `menu_request` = '<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>参数</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>field_name</td><td>string</td><td>选填</td><td>请求参数示例字段</td><td>示例值</td></tr></tbody></table>' , `menu_response` = '<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>参数</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>code</td><td>integer</td><td>必返</td><td>返回码，200成功，401登录失效，404接口地址错误，500服务器错误，其它失败</td><td>200</td></tr><tr><td>msg</td><td>string</td><td>必返</td><td>返回描述</td><td>成功</td></tr><tr><td>data</td><td>array</td><td>必返</td><td>返回数据</td><td></td></tr></tbody></table><p>返回数据data：</p><table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align:center;\"><tbody><tr><th>字段</th><th>类型</th><th>属性</th><th>说明</th><th>示例</th></tr><tr><td>field_name</td><td>string</td><td>选返</td><td>返回数据示例字段</td><td>示例值</td></tr></tbody></table>' , `menu_explain` = '' , `vue_component` = 'deleteRecord' , `vue_hidden` = 0 , `vue_path` = 'deleteRecord' , `vue_name` = 'deleteRecord' , `vue_icon` = 'el-icon-platform-eleme' , `level` = 2 , `create_time` = '2022-09-12 15:21:09' [ RunTime:0.004132s ]
[2022-09-12T15:21:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_user` [ RunTime:0.003409s ]
[2022-09-12T15:21:09+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000630s ]
[2022-09-12T15:21:09+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.002200s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.001945s ]
[2022-09-12T15:21:09+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 2 LIMIT 1 [ RunTime:0.006596s ]
[2022-09-12T15:21:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_role` [ RunTime:0.013365s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.002453s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.002056s ]
[2022-09-12T15:21:09+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 3 LIMIT 1 [ RunTime:0.003937s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 5 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.002014s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( `admin_menu_id` IN (12,45,46,47,48,51,52,54,75,111,117,187,188,189,190,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,183) AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001923s ]
[2022-09-12T15:21:09+08:00][sql] SELECT * FROM `dg_admin_user` WHERE `admin_user_id` = 4 LIMIT 1 [ RunTime:0.001208s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `admin_menu_ids` FROM `dg_admin_role` WHERE `admin_role_id` = 0 AND `is_delete` = 0 AND `is_disable` = 0 [ RunTime:0.000425s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `menu_url` FROM `dg_admin_menu` WHERE ( 0 = 1 AND `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' ) OR ( `is_delete` = 0 AND `is_disable` = 0 AND `menu_url` <> '' AND `is_unauth` = 1 ) [ RunTime:0.001830s ]
[2022-09-12T15:21:09+08:00][sql] CONNECT:[ UseTime:0.000983s ] mysql:host=127.0.0.1;port=3306;dbname=degao_erp;charset=utf8
[2022-09-12T15:21:09+08:00][sql] SHOW FULL COLUMNS FROM `dg_admin_menu` [ RunTime:0.002271s ]
[2022-09-12T15:21:09+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_name`,`menu_url`,`menu_sort`,`is_disable`,`is_unauth`,`create_time`,`update_time`,`vue_component`,`vue_path` FROM `dg_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC,`admin_menu_id` ASC [ RunTime:0.000680s ]