[2025-08-21T12:23:11+08:00][sql] CONNECT:[ UseTime:0.010710s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T12:23:11+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.016710s ] [2025-08-21T12:23:11+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000822s ] [2025-08-21T12:23:11+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000562s ] [2025-08-21T12:23:11+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.013193s ] [2025-08-21T12:23:11+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000466s ] [2025-08-21T12:23:11+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.014368s ] [2025-08-21T12:23:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/index' or a.route = '/admin/Index') ) [ RunTime:0.006075s ] [2025-08-21T12:23:11+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.011385s ] [2025-08-21T12:23:11+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000352s ] [2025-08-21T12:23:11+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000287s ] [2025-08-21T12:23:12+08:00][sql] CONNECT:[ UseTime:0.000764s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T12:23:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006316s ] [2025-08-21T12:23:12+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000246s ] [2025-08-21T12:23:12+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000269s ] [2025-08-21T12:23:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.007490s ] [2025-08-21T12:23:12+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000263s ] [2025-08-21T12:23:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005974s ] [2025-08-21T12:23:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/menu' or a.route = '/admin/Index') ) [ RunTime:0.001857s ] [2025-08-21T12:23:12+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000334s ] [2025-08-21T12:23:12+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000317s ] [2025-08-21T12:23:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role_menu` [ RunTime:0.018835s ] [2025-08-21T12:23:12+08:00][sql] SELECT `menuid` FROM `yide_admin_role_menu` WHERE `roleid` = 1 [ RunTime:0.000371s ] [2025-08-21T12:23:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_menu` [ RunTime:0.021255s ] [2025-08-21T12:23:12+08:00][sql] SELECT `id`,`parent_id`,name as title,url as href,`icon` FROM `yide_admin_menu` WHERE `status` = 1 AND 1 = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000442s ] [2025-08-21T12:23:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.010305s ] [2025-08-21T12:23:12+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000281s ] [2025-08-21T12:23:13+08:00][sql] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T12:23:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006771s ] [2025-08-21T12:23:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000296s ] [2025-08-21T12:23:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000821s ] [2025-08-21T12:23:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.012373s ] [2025-08-21T12:23:13+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000211s ] [2025-08-21T12:23:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.007032s ] [2025-08-21T12:23:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/index' or a.route = '/admin/Column') ) [ RunTime:0.001874s ] [2025-08-21T12:23:15+08:00][sql] CONNECT:[ UseTime:0.000565s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T12:23:15+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006105s ] [2025-08-21T12:23:15+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000333s ] [2025-08-21T12:23:15+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000357s ] [2025-08-21T12:23:15+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006736s ] [2025-08-21T12:23:15+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000352s ] [2025-08-21T12:23:15+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.008760s ] [2025-08-21T12:23:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/menus' or a.route = '/admin/Column') ) [ RunTime:0.004721s ] [2025-08-21T12:23:15+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.008926s ] [2025-08-21T12:23:15+08:00][sql] SELECT * FROM `yide_column` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002470s ] [2025-08-21T13:05:47+08:00][sql] CONNECT:[ UseTime:0.011700s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:05:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005890s ] [2025-08-21T13:05:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000288s ] [2025-08-21T13:05:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000467s ] [2025-08-21T13:05:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.008746s ] [2025-08-21T13:05:47+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000233s ] [2025-08-21T13:05:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.008679s ] [2025-08-21T13:05:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/index' or a.route = '/admin/Index') ) [ RunTime:0.000551s ] [2025-08-21T13:05:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.005855s ] [2025-08-21T13:05:47+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000216s ] [2025-08-21T13:05:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000313s ] [2025-08-21T13:05:48+08:00][sql] CONNECT:[ UseTime:0.000702s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:05:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.008421s ] [2025-08-21T13:05:48+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000252s ] [2025-08-21T13:05:48+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000325s ] [2025-08-21T13:05:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006322s ] [2025-08-21T13:05:48+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000283s ] [2025-08-21T13:05:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.006423s ] [2025-08-21T13:05:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/menu' or a.route = '/admin/Index') ) [ RunTime:0.000207s ] [2025-08-21T13:05:48+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000163s ] [2025-08-21T13:05:48+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000277s ] [2025-08-21T13:05:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role_menu` [ RunTime:0.005943s ] [2025-08-21T13:05:48+08:00][sql] SELECT `menuid` FROM `yide_admin_role_menu` WHERE `roleid` = 1 [ RunTime:0.000183s ] [2025-08-21T13:05:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_menu` [ RunTime:0.006280s ] [2025-08-21T13:05:48+08:00][sql] SELECT `id`,`parent_id`,name as title,url as href,`icon` FROM `yide_admin_menu` WHERE `status` = 1 AND 1 = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000265s ] [2025-08-21T13:05:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.010670s ] [2025-08-21T13:05:48+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000187s ] [2025-08-21T13:05:49+08:00][sql] CONNECT:[ UseTime:0.012098s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:05:49+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006530s ] [2025-08-21T13:05:49+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000353s ] [2025-08-21T13:05:49+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000330s ] [2025-08-21T13:05:49+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.009423s ] [2025-08-21T13:05:49+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000222s ] [2025-08-21T13:05:49+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.007374s ] [2025-08-21T13:05:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/index' or a.route = '/admin/Column') ) [ RunTime:0.000300s ] [2025-08-21T13:05:51+08:00][sql] CONNECT:[ UseTime:0.011186s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:05:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.011217s ] [2025-08-21T13:05:51+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000284s ] [2025-08-21T13:05:51+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000269s ] [2025-08-21T13:05:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.018545s ] [2025-08-21T13:05:51+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000305s ] [2025-08-21T13:05:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005943s ] [2025-08-21T13:05:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/menus' or a.route = '/admin/Column') ) [ RunTime:0.000286s ] [2025-08-21T13:05:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.008409s ] [2025-08-21T13:05:51+08:00][sql] SELECT * FROM `yide_column` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000331s ] [2025-08-21T13:05:53+08:00][sql] CONNECT:[ UseTime:0.010643s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005873s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000302s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000290s ] [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.008208s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000354s ] [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.006932s ] [2025-08-21T13:05:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/index' or a.route = '/admin/Article') ) [ RunTime:0.001292s ] [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.006749s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_column` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001502s ] [2025-08-21T13:05:53+08:00][sql] CONNECT:[ UseTime:0.012176s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.008692s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000269s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000304s ] [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.008558s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000356s ] [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005961s ] [2025-08-21T13:05:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/json' or a.route = '/admin/Article') ) [ RunTime:0.002225s ] [2025-08-21T13:05:53+08:00][sql] SHOW FULL COLUMNS FROM `yide_article` [ RunTime:0.009627s ] [2025-08-21T13:05:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_article` [ RunTime:0.007534s ] [2025-08-21T13:05:53+08:00][sql] SELECT * FROM `yide_article` ORDER BY `sort` DESC,`id` DESC LIMIT 0,15 [ RunTime:0.005206s ] [2025-08-21T13:06:46+08:00][sql] CONNECT:[ UseTime:0.003094s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:06:46+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005840s ] [2025-08-21T13:06:46+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000345s ] [2025-08-21T13:06:46+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000301s ] [2025-08-21T13:06:46+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006057s ] [2025-08-21T13:06:46+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000429s ] [2025-08-21T13:06:46+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005641s ] [2025-08-21T13:06:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/index' or a.route = '/admin/Index') ) [ RunTime:0.000267s ] [2025-08-21T13:06:46+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.005286s ] [2025-08-21T13:06:46+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000227s ] [2025-08-21T13:06:46+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000250s ] [2025-08-21T13:06:47+08:00][sql] CONNECT:[ UseTime:0.000588s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005580s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000351s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000348s ] [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005439s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000200s ] [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005663s ] [2025-08-21T13:06:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/menu' or a.route = '/admin/Index') ) [ RunTime:0.000266s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000203s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000243s ] [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role_menu` [ RunTime:0.005339s ] [2025-08-21T13:06:47+08:00][sql] SELECT `menuid` FROM `yide_admin_role_menu` WHERE `roleid` = 1 [ RunTime:0.000263s ] [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_menu` [ RunTime:0.005530s ] [2025-08-21T13:06:47+08:00][sql] SELECT `id`,`parent_id`,name as title,url as href,`icon` FROM `yide_admin_menu` WHERE `status` = 1 AND 1 = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000276s ] [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.006695s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000295s ] [2025-08-21T13:06:47+08:00][sql] CONNECT:[ UseTime:0.000613s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006048s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000303s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000247s ] [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005963s ] [2025-08-21T13:06:47+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000186s ] [2025-08-21T13:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005984s ] [2025-08-21T13:06:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/index' or a.route = '/admin/Column') ) [ RunTime:0.000235s ] [2025-08-21T13:06:48+08:00][sql] CONNECT:[ UseTime:0.000642s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:06:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006486s ] [2025-08-21T13:06:48+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000267s ] [2025-08-21T13:06:48+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000246s ] [2025-08-21T13:06:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006496s ] [2025-08-21T13:06:48+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000292s ] [2025-08-21T13:06:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005714s ] [2025-08-21T13:06:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/menus' or a.route = '/admin/Column') ) [ RunTime:0.000253s ] [2025-08-21T13:06:48+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.005795s ] [2025-08-21T13:06:48+08:00][sql] SELECT * FROM `yide_column` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000251s ] [2025-08-21T13:06:51+08:00][sql] CONNECT:[ UseTime:0.000644s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005955s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000330s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000304s ] [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005360s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000245s ] [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005624s ] [2025-08-21T13:06:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/index' or a.route = '/admin/Article') ) [ RunTime:0.000212s ] [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.005216s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_column` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000310s ] [2025-08-21T13:06:51+08:00][sql] CONNECT:[ UseTime:0.011145s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005950s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000261s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000212s ] [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005067s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000195s ] [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005024s ] [2025-08-21T13:06:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/json' or a.route = '/admin/Article') ) [ RunTime:0.000216s ] [2025-08-21T13:06:51+08:00][sql] SHOW FULL COLUMNS FROM `yide_article` [ RunTime:0.006614s ] [2025-08-21T13:06:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_article` [ RunTime:0.000175s ] [2025-08-21T13:06:51+08:00][sql] SELECT * FROM `yide_article` ORDER BY `sort` DESC,`id` DESC LIMIT 0,15 [ RunTime:0.000294s ] [2025-08-21T13:07:12+08:00][sql] CONNECT:[ UseTime:0.010584s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:07:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005945s ] [2025-08-21T13:07:12+08:00][sql] SELECT `id`,`username`,`password` FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.001864s ] [2025-08-21T13:07:12+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_login_log` [ RunTime:0.018761s ] [2025-08-21T13:07:12+08:00][sql] INSERT INTO `yide_admin_login_log` SET `user_id` = 1 , `ip_address` = '119.135.35.60' , `login_time` = '2025-08-21 13:07:12' [ RunTime:0.008315s ] [2025-08-21T13:07:13+08:00][sql] CONNECT:[ UseTime:0.010993s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.007213s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000256s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000433s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006050s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000329s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.006343s ] [2025-08-21T13:07:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/index' or a.route = '/admin/Index') ) [ RunTime:0.000271s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.005153s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000205s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000227s ] [2025-08-21T13:07:13+08:00][sql] CONNECT:[ UseTime:0.010931s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005159s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000272s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000254s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005232s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000194s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.004780s ] [2025-08-21T13:07:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/menu' or a.route = '/admin/Index') ) [ RunTime:0.000306s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000193s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000177s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role_menu` [ RunTime:0.005582s ] [2025-08-21T13:07:13+08:00][sql] SELECT `menuid` FROM `yide_admin_role_menu` WHERE `roleid` = 1 [ RunTime:0.000186s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_menu` [ RunTime:0.005758s ] [2025-08-21T13:07:13+08:00][sql] SELECT `id`,`parent_id`,name as title,url as href,`icon` FROM `yide_admin_menu` WHERE `status` = 1 AND 1 = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000199s ] [2025-08-21T13:07:13+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.005133s ] [2025-08-21T13:07:13+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000215s ] [2025-08-21T13:07:16+08:00][sql] CONNECT:[ UseTime:0.010870s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.007479s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000305s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000409s ] [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005979s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000157s ] [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.006100s ] [2025-08-21T13:07:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/index' or a.route = '/admin/Article') ) [ RunTime:0.000282s ] [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.005972s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_column` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000276s ] [2025-08-21T13:07:16+08:00][sql] CONNECT:[ UseTime:0.011163s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006052s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000218s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000251s ] [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.007697s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000295s ] [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.008775s ] [2025-08-21T13:07:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/json' or a.route = '/admin/Article') ) [ RunTime:0.000276s ] [2025-08-21T13:07:16+08:00][sql] SHOW FULL COLUMNS FROM `yide_article` [ RunTime:0.005796s ] [2025-08-21T13:07:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_article` [ RunTime:0.000174s ] [2025-08-21T13:07:16+08:00][sql] SELECT * FROM `yide_article` ORDER BY `sort` DESC,`id` DESC LIMIT 0,15 [ RunTime:0.000474s ] [2025-08-21T13:07:18+08:00][sql] CONNECT:[ UseTime:0.000562s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:07:18+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005908s ] [2025-08-21T13:07:18+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000319s ] [2025-08-21T13:07:18+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000315s ] [2025-08-21T13:07:18+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005215s ] [2025-08-21T13:07:18+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000261s ] [2025-08-21T13:07:18+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005130s ] [2025-08-21T13:07:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/index' or a.route = '/admin/Column') ) [ RunTime:0.000217s ] [2025-08-21T13:07:18+08:00][sql] CONNECT:[ UseTime:0.010504s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:07:18+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006299s ] [2025-08-21T13:07:18+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000209s ] [2025-08-21T13:07:18+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000534s ] [2025-08-21T13:07:18+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006365s ] [2025-08-21T13:07:18+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000186s ] [2025-08-21T13:07:18+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.007100s ] [2025-08-21T13:07:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/menus' or a.route = '/admin/Column') ) [ RunTime:0.000460s ] [2025-08-21T13:07:18+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.007853s ] [2025-08-21T13:07:18+08:00][sql] SELECT * FROM `yide_column` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000236s ] [2025-08-21T13:11:21+08:00][sql] CONNECT:[ UseTime:0.010647s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006192s ] [2025-08-21T13:11:21+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000307s ] [2025-08-21T13:11:21+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000319s ] [2025-08-21T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.007034s ] [2025-08-21T13:11:21+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000265s ] [2025-08-21T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005241s ] [2025-08-21T13:11:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/index' or a.route = '/admin/Index') ) [ RunTime:0.000239s ] [2025-08-21T13:11:21+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.006258s ] [2025-08-21T13:11:21+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000209s ] [2025-08-21T13:11:21+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000220s ] [2025-08-21T13:11:22+08:00][sql] CONNECT:[ UseTime:0.000761s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:22+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005449s ] [2025-08-21T13:11:22+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000259s ] [2025-08-21T13:11:22+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000258s ] [2025-08-21T13:11:22+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006215s ] [2025-08-21T13:11:22+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000232s ] [2025-08-21T13:11:22+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.008051s ] [2025-08-21T13:11:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/menu' or a.route = '/admin/Index') ) [ RunTime:0.000324s ] [2025-08-21T13:11:22+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000227s ] [2025-08-21T13:11:22+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000250s ] [2025-08-21T13:11:22+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role_menu` [ RunTime:0.006023s ] [2025-08-21T13:11:22+08:00][sql] SELECT `menuid` FROM `yide_admin_role_menu` WHERE `roleid` = 1 [ RunTime:0.000158s ] [2025-08-21T13:11:22+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_menu` [ RunTime:0.006861s ] [2025-08-21T13:11:22+08:00][sql] SELECT `id`,`parent_id`,name as title,url as href,`icon` FROM `yide_admin_menu` WHERE `status` = 1 AND 1 = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000290s ] [2025-08-21T13:11:22+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.007099s ] [2025-08-21T13:11:22+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000699s ] [2025-08-21T13:11:23+08:00][sql] CONNECT:[ UseTime:0.000681s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:23+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006031s ] [2025-08-21T13:11:23+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000318s ] [2025-08-21T13:11:23+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000290s ] [2025-08-21T13:11:23+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005748s ] [2025-08-21T13:11:23+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000247s ] [2025-08-21T13:11:23+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005871s ] [2025-08-21T13:11:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/index' or a.route = '/admin/Column') ) [ RunTime:0.000349s ] [2025-08-21T13:11:24+08:00][sql] CONNECT:[ UseTime:0.010582s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:24+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.008255s ] [2025-08-21T13:11:24+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000294s ] [2025-08-21T13:11:24+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000227s ] [2025-08-21T13:11:24+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.006539s ] [2025-08-21T13:11:24+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000197s ] [2025-08-21T13:11:24+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005923s ] [2025-08-21T13:11:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/menus' or a.route = '/admin/Column') ) [ RunTime:0.000233s ] [2025-08-21T13:11:24+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.005258s ] [2025-08-21T13:11:24+08:00][sql] SELECT * FROM `yide_column` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000220s ] [2025-08-21T13:11:27+08:00][sql] CONNECT:[ UseTime:0.011148s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:27+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005661s ] [2025-08-21T13:11:27+08:00][sql] SELECT `id`,`username`,`password` FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000235s ] [2025-08-21T13:11:27+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_login_log` [ RunTime:0.005536s ] [2025-08-21T13:11:27+08:00][sql] INSERT INTO `yide_admin_login_log` SET `user_id` = 1 , `ip_address` = '119.135.35.60' , `login_time` = '2025-08-21 13:11:27' [ RunTime:0.010909s ] [2025-08-21T13:11:28+08:00][sql] CONNECT:[ UseTime:0.011178s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.012426s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000436s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000321s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005764s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000292s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005332s ] [2025-08-21T13:11:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/index' or a.route = '/admin/Index') ) [ RunTime:0.000207s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.004943s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000203s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000211s ] [2025-08-21T13:11:28+08:00][sql] CONNECT:[ UseTime:0.000630s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006034s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000361s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000260s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005352s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000192s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005166s ] [2025-08-21T13:11:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Index/menu' or a.route = '/admin/Index') ) [ RunTime:0.000211s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000189s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000205s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role_menu` [ RunTime:0.004963s ] [2025-08-21T13:11:28+08:00][sql] SELECT `menuid` FROM `yide_admin_role_menu` WHERE `roleid` = 1 [ RunTime:0.000197s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_menu` [ RunTime:0.004908s ] [2025-08-21T13:11:28+08:00][sql] SELECT `id`,`parent_id`,name as title,url as href,`icon` FROM `yide_admin_menu` WHERE `status` = 1 AND 1 = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000219s ] [2025-08-21T13:11:28+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_system` [ RunTime:0.005546s ] [2025-08-21T13:11:28+08:00][sql] SELECT * FROM `yide_admin_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000236s ] [2025-08-21T13:11:31+08:00][sql] CONNECT:[ UseTime:0.010953s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005390s ] [2025-08-21T13:11:31+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000255s ] [2025-08-21T13:11:31+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000231s ] [2025-08-21T13:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005233s ] [2025-08-21T13:11:31+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000206s ] [2025-08-21T13:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.006340s ] [2025-08-21T13:11:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/index' or a.route = '/admin/Column') ) [ RunTime:0.000261s ] [2025-08-21T13:11:32+08:00][sql] CONNECT:[ UseTime:0.000626s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:32+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.006347s ] [2025-08-21T13:11:32+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000245s ] [2025-08-21T13:11:32+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000274s ] [2025-08-21T13:11:32+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005606s ] [2025-08-21T13:11:32+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000202s ] [2025-08-21T13:11:32+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005517s ] [2025-08-21T13:11:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Column/menus' or a.route = '/admin/Column') ) [ RunTime:0.000273s ] [2025-08-21T13:11:32+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.005756s ] [2025-08-21T13:11:32+08:00][sql] SELECT * FROM `yide_column` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000225s ] [2025-08-21T13:11:33+08:00][sql] CONNECT:[ UseTime:0.010880s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:33+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005168s ] [2025-08-21T13:11:33+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000246s ] [2025-08-21T13:11:33+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000280s ] [2025-08-21T13:11:33+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005141s ] [2025-08-21T13:11:33+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000216s ] [2025-08-21T13:11:33+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005161s ] [2025-08-21T13:11:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/index' or a.route = '/admin/Article') ) [ RunTime:0.000227s ] [2025-08-21T13:11:33+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.005271s ] [2025-08-21T13:11:33+08:00][sql] SELECT * FROM `yide_column` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000314s ] [2025-08-21T13:11:34+08:00][sql] CONNECT:[ UseTime:0.011187s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:34+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005420s ] [2025-08-21T13:11:34+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000313s ] [2025-08-21T13:11:34+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000228s ] [2025-08-21T13:11:34+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.004767s ] [2025-08-21T13:11:34+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000228s ] [2025-08-21T13:11:34+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.005458s ] [2025-08-21T13:11:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/json' or a.route = '/admin/Article') ) [ RunTime:0.000224s ] [2025-08-21T13:11:34+08:00][sql] SHOW FULL COLUMNS FROM `yide_article` [ RunTime:0.004909s ] [2025-08-21T13:11:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_article` [ RunTime:0.000167s ] [2025-08-21T13:11:34+08:00][sql] SELECT * FROM `yide_article` ORDER BY `sort` DESC,`id` DESC LIMIT 0,15 [ RunTime:0.000315s ] [2025-08-21T13:11:37+08:00][sql] CONNECT:[ UseTime:0.010803s ] mysql:host=127.0.0.1;port=3306;dbname=gzh_580980_com;charset=utf8 [2025-08-21T13:11:37+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_user` [ RunTime:0.005619s ] [2025-08-21T13:11:37+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000284s ] [2025-08-21T13:11:37+08:00][sql] SELECT * FROM `yide_admin_user` WHERE `username` = 'admin' LIMIT 1 [ RunTime:0.000305s ] [2025-08-21T13:11:37+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_role` [ RunTime:0.005949s ] [2025-08-21T13:11:37+08:00][sql] SELECT * FROM `yide_admin_role` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000199s ] [2025-08-21T13:11:37+08:00][sql] SHOW FULL COLUMNS FROM `yide_admin_permission` [ RunTime:0.007834s ] [2025-08-21T13:11:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `yide_admin_permission` `a` LEFT JOIN `yide_admin_role_permission` `b` ON `a`.`id`=`b`.`permissionid` WHERE ( a.status = 1 and b.roleid = 1 and (a.route = '/admin/Article/edit' or a.route = '/admin/Article') ) [ RunTime:0.003025s ] [2025-08-21T13:11:37+08:00][sql] SHOW FULL COLUMNS FROM `yide_article` [ RunTime:0.006125s ] [2025-08-21T13:11:37+08:00][sql] SELECT * FROM `yide_article` WHERE `id` = 13 LIMIT 1 [ RunTime:0.001875s ] [2025-08-21T13:11:37+08:00][sql] SHOW FULL COLUMNS FROM `yide_column` [ RunTime:0.005545s ] [2025-08-21T13:11:37+08:00][sql] SELECT * FROM `yide_column` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000305s ] [2025-08-21T13:11:37+08:00][sql] SELECT * FROM `yide_admin_user` ORDER BY `id` ASC [ RunTime:0.001171s ]