[2021-03-23T09:11:27+08:00][sql] CONNECT:[ UseTime:0.000615s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.003791s ]
[2021-03-23T09:11:27+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid` FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` WHERE  ( account='18999999999' ) LIMIT 1 [ RunTime:0.002200s ]
[2021-03-23T09:11:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001114s ]
[2021-03-23T09:11:27+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.003645s ]
[2021-03-23T09:11:27+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 1942832775 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id=2 ) [ RunTime:0.000638s ]
[2021-03-23T09:11:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001094s ]
[2021-03-23T09:11:27+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '4c8f125cd4334b248dceed93ee330685' , `sign_ip` = 115 , `ua` = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.190 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000459s ]
[2021-03-23T09:11:29+08:00][sql] CONNECT:[ UseTime:0.000726s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.018555s ]
[2021-03-23T09:11:29+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000455s ]
[2021-03-23T09:11:29+08:00][sql] SELECT `a`.* FROM `yl_node_column` `a` INNER JOIN `yl_role_access_column` `b` ON `a`.`id`=`b`.`node_id` INNER JOIN `yl_user_role` `c` ON `c`.`role_id`=`b`.`role_id` GROUP BY `a`.`id` ORDER BY `a`.`sort` ASC [ RunTime:0.000741s ]
[2021-03-23T09:11:29+08:00][sql] CONNECT:[ UseTime:0.000652s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000923s ]
[2021-03-23T09:11:29+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000346s ]
[2021-03-23T09:11:29+08:00][sql] SELECT `a`.* FROM `yl_node_column` `a` INNER JOIN `yl_role_access_column` `b` ON `a`.`id`=`b`.`node_id` INNER JOIN `yl_user_role` `c` ON `c`.`role_id`=`b`.`role_id` GROUP BY `a`.`id` ORDER BY `a`.`sort` ASC [ RunTime:0.000623s ]
[2021-03-23T09:11:29+08:00][sql] CONNECT:[ UseTime:0.000630s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001194s ]
[2021-03-23T09:11:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000355s ]
[2021-03-23T09:11:29+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000346s ]
[2021-03-23T09:11:29+08:00][sql] CONNECT:[ UseTime:0.000645s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.001638s ]
[2021-03-23T09:11:29+08:00][sql] SELECT `id`,`pid`,`title`,`routing` FROM `yl_node_function` [ RunTime:0.000439s ]
[2021-03-23T09:11:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_function` [ RunTime:0.001338s ]
[2021-03-23T09:11:29+08:00][sql] SELECT `t2`.`id`,`t1`.`routing`,`t1`.`status` FROM `yl_role_access_function` `t1` LEFT JOIN `yl_role` `t2` ON `t1`.`role_id`=`t2`.`id` [ RunTime:0.000343s ]
[2021-03-23T09:11:34+08:00][sql] CONNECT:[ UseTime:0.000666s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001312s ]
[2021-03-23T09:11:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 27 [ RunTime:0.000406s ]
[2021-03-23T09:11:34+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 27 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000359s ]
[2021-03-23T09:11:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000981s ]
[2021-03-23T09:11:34+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='' ) LIMIT 1 [ RunTime:0.000577s ]
[2021-03-23T09:11:37+08:00][sql] CONNECT:[ UseTime:0.000670s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001139s ]
[2021-03-23T09:11:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 25 [ RunTime:0.000470s ]
[2021-03-23T09:11:37+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000564s ]
[2021-03-23T09:11:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000951s ]
[2021-03-23T09:11:40+08:00][sql] CONNECT:[ UseTime:0.000533s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-23T09:11:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000986s ]
[2021-03-23T09:11:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 24 [ RunTime:0.000376s ]
[2021-03-23T09:11:40+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 24 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000601s ]
[2021-03-23T09:11:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001053s ]