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/202104/ |
[2021-04-13T13:22:12+08:00][sql] CONNECT:[ UseTime:0.008028s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:12+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_user` [ RunTime:0.040309s ] [2021-04-13T13:22:12+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`login_num`,`is_disable` FROM `ya_admin_user` WHERE `username` = 'admin' AND `password` = 'e10adc3949ba59abbe56e057f20f883e' AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004292s ] [2021-04-13T13:22:12+08:00][sql] UPDATE `ya_admin_user` SET `login_ip` = '127.0.0.1' , `login_region` = 'XXXX内网IP' , `login_time` = '2021-04-13 13:22:11' , `login_num` = 236 WHERE `admin_user_id` = 1 [ RunTime:0.006171s ] [2021-04-13T13:22:12+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.005590s ] [2021-04-13T13:22:12+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminLogin/login' LIMIT 1 [ RunTime:0.000715s ] [2021-04-13T13:22:12+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.013933s ] [2021-04-13T13:22:12+08:00][sql] INSERT INTO `ya_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` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:3:{s:8:\"username\";s:5:\"admin\";s:9:\"verify_id\";s:32:\"8f25517c0123505b9b1c45d839dccb3a\";s:11:\"verify_code\";s:4:\"6714\";}' , `request_method` = 'POST' , `create_time` = '2021-04-13 13:22:11' [ RunTime:0.001089s ] [2021-04-13T13:22:12+08:00][sql] SELECT * FROM `ya_admin_user` WHERE `admin_user_id` = 1 LIMIT 1 [ RunTime:0.000419s ] [2021-04-13T13:22:12+08:00][sql] SELECT `admin_menu_id`,`menu_url` FROM `ya_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC [ RunTime:0.002171s ] [2021-04-13T13:22:12+08:00][sql] CONNECT:[ UseTime:0.000608s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:12+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.001455s ] [2021-04-13T13:22:12+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminMy/myInfo' LIMIT 1 [ RunTime:0.000514s ] [2021-04-13T13:22:12+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000828s ] [2021-04-13T13:22:12+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 45 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:1:{s:13:\"admin_user_id\";s:1:\"1\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:22:12' [ RunTime:0.001245s ] [2021-04-13T13:22:12+08:00][sql] CONNECT:[ UseTime:0.000572s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:12+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.000983s ] [2021-04-13T13:22:12+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 `ya_admin_menu` WHERE `is_delete` = 0 ORDER BY `menu_sort` DESC,`admin_menu_id` ASC [ RunTime:0.000493s ] [2021-04-13T13:22:12+08:00][sql] SELECT `admin_menu_id`,`menu_pid`,`menu_url`,`menu_name`,`vue_path`,`vue_component`,`vue_name`,`vue_hidden`,`vue_icon` FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `is_disable` = 0 AND `level` < 3 AND `admin_menu_id` IN (174,88,173,13,17,158,29,15,16,14,18,19,20,22,23,24,25,176,175,46,3,169,168,33,115,122,42,43,44,45,178,47,48,49,121,120,117,54,73,116,85,5,4,75,51,27,52,31,28,113,41,32,118,114,30,12,53,119,35,111,1) ORDER BY `menu_sort` DESC [ RunTime:0.002390s ] [2021-04-13T13:22:12+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminUser/userAuthMenu' LIMIT 1 [ RunTime:0.000519s ] [2021-04-13T13:22:12+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.001061s ] [2021-04-13T13:22:12+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = NULL , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:0:{}' , `request_method` = 'POST' , `create_time` = '2021-04-13 13:22:12' [ RunTime:0.001706s ] [2021-04-13T13:22:22+08:00][sql] CONNECT:[ UseTime:0.000659s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:22+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.002449s ] [2021-04-13T13:22:22+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminMenu/menuList' LIMIT 1 [ RunTime:0.001503s ] [2021-04-13T13:22:22+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.002795s ] [2021-04-13T13:22:22+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 3 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:0:{}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:22:22' [ RunTime:0.001531s ] [2021-04-13T13:22:22+08:00][sql] CONNECT:[ UseTime:0.000602s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:22+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_role` [ RunTime:0.003782s ] [2021-04-13T13:22:22+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `ya_admin_role` WHERE `is_delete` = 0 [ RunTime:0.002992s ] [2021-04-13T13:22:22+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `ya_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000571s ] [2021-04-13T13:22:22+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.001819s ] [2021-04-13T13:22:22+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminRole/roleList' LIMIT 1 [ RunTime:0.000615s ] [2021-04-13T13:22:22+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000789s ] [2021-04-13T13:22:22+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 22 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:2:{s:4:\"page\";s:1:\"1\";s:5:\"limit\";s:2:\"13\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:22:22' [ RunTime:0.000606s ] [2021-04-13T13:22:24+08:00][sql] CONNECT:[ UseTime:0.000463s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:24+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_user` [ RunTime:0.000780s ] [2021-04-13T13:22:24+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `ya_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000415s ] [2021-04-13T13:22:24+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `ya_admin_user` WHERE `is_delete` = 0 ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,13 [ RunTime:0.000324s ] [2021-04-13T13:22:24+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.000681s ] [2021-04-13T13:22:24+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminUser/userList' LIMIT 1 [ RunTime:0.000361s ] [2021-04-13T13:22:24+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000612s ] [2021-04-13T13:22:24+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 17 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:2:{s:4:\"page\";s:1:\"1\";s:5:\"limit\";s:2:\"13\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:22:24' [ RunTime:0.000627s ] [2021-04-13T13:22:27+08:00][sql] CONNECT:[ UseTime:0.000498s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:27+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_role` [ RunTime:0.000633s ] [2021-04-13T13:22:27+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `ya_admin_role` WHERE `is_delete` = 0 [ RunTime:0.000305s ] [2021-04-13T13:22:27+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `ya_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000324s ] [2021-04-13T13:22:27+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000782s ] [2021-04-13T13:22:27+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 22 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:2:{s:4:\"page\";s:1:\"1\";s:5:\"limit\";s:2:\"13\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:22:27' [ RunTime:0.000835s ] [2021-04-13T13:22:28+08:00][sql] CONNECT:[ UseTime:0.000571s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:22:28+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_user` [ RunTime:0.000780s ] [2021-04-13T13:22:28+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `ya_admin_user` WHERE `is_delete` = 0 [ RunTime:0.000307s ] [2021-04-13T13:22:28+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `ya_admin_user` WHERE `is_delete` = 0 ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,13 [ RunTime:0.000309s ] [2021-04-13T13:22:28+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000713s ] [2021-04-13T13:22:28+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 17 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:2:{s:4:\"page\";s:1:\"1\";s:5:\"limit\";s:2:\"13\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:22:28' [ RunTime:0.000663s ] [2021-04-13T13:23:23+08:00][sql] CONNECT:[ UseTime:0.000615s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:23:23+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_role` [ RunTime:0.000840s ] [2021-04-13T13:23:23+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `ya_admin_role` WHERE `is_delete` = 0 [ RunTime:0.000383s ] [2021-04-13T13:23:23+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `ya_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,999 [ RunTime:0.000415s ] [2021-04-13T13:23:23+08:00][sql] SELECT * FROM `ya_admin_role` WHERE `admin_role_id` = 1 LIMIT 1 [ RunTime:0.000430s ] [2021-04-13T13:23:23+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.000848s ] [2021-04-13T13:23:23+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminUser/userRule' LIMIT 1 [ RunTime:0.000455s ] [2021-04-13T13:23:23+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000623s ] [2021-04-13T13:23:23+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 31 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:1:{s:13:\"admin_user_id\";s:1:\"1\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:23:23' [ RunTime:0.001411s ] [2021-04-13T13:23:26+08:00][sql] CONNECT:[ UseTime:0.000491s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:23:26+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_role` [ RunTime:0.000623s ] [2021-04-13T13:23:26+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `ya_admin_role` WHERE `is_delete` = 0 [ RunTime:0.000310s ] [2021-04-13T13:23:26+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `ya_admin_role` WHERE `is_delete` = 0 ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000362s ] [2021-04-13T13:23:26+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000785s ] [2021-04-13T13:23:26+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 22 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:2:{s:4:\"page\";s:1:\"1\";s:5:\"limit\";s:2:\"13\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:23:26' [ RunTime:0.000646s ] [2021-04-13T13:23:28+08:00][sql] CONNECT:[ UseTime:0.001578s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:23:28+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_user` [ RunTime:0.002237s ] [2021-04-13T13:23:28+08:00][sql] SELECT COUNT(`admin_user_id`) AS think_count FROM `ya_admin_user` WHERE ( `admin_role_ids` LIKE '1' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '1,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,1,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,1' AND `is_delete` = 0 ) [ RunTime:0.003810s ] [2021-04-13T13:23:28+08:00][sql] SELECT `admin_user_id`,`username`,`nickname`,`email`,`sort`,`is_disable`,`is_admin`,`login_num`,`login_ip`,`login_time` FROM `ya_admin_user` WHERE ( `admin_role_ids` LIKE '1' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '1,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,1,%' AND `is_delete` = 0 ) OR ( `admin_role_ids` LIKE '%,1' AND `is_delete` = 0 ) ORDER BY `sort` DESC,`admin_user_id` DESC LIMIT 0,10 [ RunTime:0.001955s ] [2021-04-13T13:23:28+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.002486s ] [2021-04-13T13:23:28+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminRole/roleUser' LIMIT 1 [ RunTime:0.001277s ] [2021-04-13T13:23:28+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.001165s ] [2021-04-13T13:23:28+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 115 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:1:{s:13:\"admin_role_id\";s:1:\"1\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:23:28' [ RunTime:0.000829s ] [2021-04-13T13:23:33+08:00][sql] CONNECT:[ UseTime:0.001309s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T13:23:33+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_role` [ RunTime:0.003921s ] [2021-04-13T13:23:33+08:00][sql] SELECT * FROM `ya_admin_role` WHERE `admin_role_id` = 4 LIMIT 1 [ RunTime:0.001174s ] [2021-04-13T13:23:33+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.002784s ] [2021-04-13T13:23:33+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminRole/roleEdit' LIMIT 1 [ RunTime:0.001245s ] [2021-04-13T13:23:33+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.003571s ] [2021-04-13T13:23:33+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 24 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:1:{s:13:\"admin_role_id\";s:1:\"4\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 13:23:33' [ RunTime:0.004423s ] [2021-04-13T15:38:15+08:00][sql] CONNECT:[ UseTime:0.005723s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T15:38:15+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_menu` [ RunTime:0.020400s ] [2021-04-13T15:38:15+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `admin_menu_id` = 88 LIMIT 1 [ RunTime:0.005410s ] [2021-04-13T15:38:15+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_role` [ RunTime:0.001818s ] [2021-04-13T15:38:15+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `ya_admin_role` WHERE ( `admin_menu_ids` LIKE '88' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88' AND `is_delete` = 0 ) [ RunTime:0.003721s ] [2021-04-13T15:38:15+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `ya_admin_role` WHERE ( `admin_menu_ids` LIKE '88' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88' AND `is_delete` = 0 ) ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.001732s ] [2021-04-13T15:38:15+08:00][sql] SELECT * FROM `ya_admin_menu` WHERE `is_delete` = 0 AND `menu_url` = 'admin/AdminMenu/menuRole' LIMIT 1 [ RunTime:0.001490s ] [2021-04-13T15:38:15+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.000751s ] [2021-04-13T15:38:15+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 113 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:3:{s:4:\"page\";s:1:\"1\";s:5:\"limit\";s:2:\"13\";s:13:\"admin_menu_id\";s:2:\"88\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 15:38:15' [ RunTime:0.005454s ] [2021-04-13T15:38:18+08:00][sql] CONNECT:[ UseTime:0.000755s ] mysql:host=127.0.0.1;port=3306;dbname=yyladmin_demo;charset=utf8 [2021-04-13T15:38:18+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_role` [ RunTime:0.007804s ] [2021-04-13T15:38:18+08:00][sql] SELECT COUNT(`admin_role_id`) AS think_count FROM `ya_admin_role` WHERE ( `admin_menu_ids` LIKE '88' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88' AND `is_delete` = 0 ) [ RunTime:0.001002s ] [2021-04-13T15:38:18+08:00][sql] SELECT `admin_role_id`,`role_name`,`role_desc`,`role_sort`,`is_disable`,`create_time`,`update_time` FROM `ya_admin_role` WHERE ( `admin_menu_ids` LIKE '88' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88,%' AND `is_delete` = 0 ) OR ( `admin_menu_ids` LIKE '%,88' AND `is_delete` = 0 ) ORDER BY `role_sort` DESC,`admin_role_id` DESC LIMIT 0,13 [ RunTime:0.000554s ] [2021-04-13T15:38:18+08:00][sql] SHOW FULL COLUMNS FROM `ya_admin_log` [ RunTime:0.002666s ] [2021-04-13T15:38:18+08:00][sql] INSERT INTO `ya_admin_log` SET `response_code` = 200 , `response_msg` = '操作成功' , `admin_user_id` = 1 , `admin_menu_id` = 113 , `request_ip` = '127.0.0.1' , `request_country` = 'XX' , `request_province` = 'XX' , `request_city` = '内网IP' , `request_area` = '' , `request_region` = 'XXXX内网IP' , `request_isp` = '内网IP' , `request_param` = 'a:3:{s:4:\"page\";s:1:\"1\";s:5:\"limit\";s:2:\"13\";s:13:\"admin_menu_id\";s:2:\"88\";}' , `request_method` = 'GET' , `create_time` = '2021-04-13 15:38:18' [ RunTime:0.002368s ]