[2021-03-19T09:52:15+08:00][sql] CONNECT:[ UseTime:0.000497s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T09:52:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001538s ] [2021-03-19T09:52:15+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE `organ_id` = 2 [ RunTime:0.000538s ] [2021-03-19T09:52:19+08:00][sql] CONNECT:[ UseTime:0.000445s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T09:52:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000849s ] [2021-03-19T09:52:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000958s ] [2021-03-19T09:52:19+08:00][sql] SELECT `organ_name` FROM `yl_party_organ` WHERE ( id='2' ) LIMIT 1 [ RunTime:0.000393s ] [2021-03-19T09:52:19+08:00][sql] INSERT INTO `yl_meeting` SET `title` = '第一支部2021-03-19会议' , `organ_id` = 2 , `start_time` = '2021-03-19 09:52:19' , `address` = '临时会议' , `identifier` = 296196 [ RunTime:0.000382s ] [2021-03-19T09:52:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000922s ] [2021-03-19T09:52:19+08:00][sql] INSERT INTO `yl_task_queue` SET `organ_id` = 2 , `title` = '第一支部2021-03-19会议' , `type` = '视频会议' , `status` = '待办' , `table_name` = 'meeting' , `table_id` = 15 [ RunTime:0.000388s ] [2021-03-19T09:55:29+08:00][sql] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T09:55:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001353s ] [2021-03-19T09:55:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000667s ] [2021-03-19T09:55:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000758s ] [2021-03-19T09:55:29+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime` FROM `yl_task_queue` WHERE `status` = '待办' AND `id` = 22 LIMIT 1 [ RunTime:0.000737s ] [2021-03-19T09:55:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001048s ] [2021-03-19T09:55:29+08:00][sql] SELECT `id`,`title`,`desc`,`type`,`deadline`,`sender_uuid`,`send_time`,`organ_id`,`vid` FROM `yl_task` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000575s ] [2021-03-19T15:54:02+08:00][sql] CONNECT:[ UseTime:0.000723s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001641s ] [2021-03-19T15:54:02+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.000951s ] [2021-03-19T15:54:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001354s ] [2021-03-19T15:54:02+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000399s ] [2021-03-19T15:54:02+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 1942832059 , `errtime` = 0 , `errtimes` = 0 WHERE ( id=2 ) [ RunTime:0.000864s ] [2021-03-19T15:54:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001498s ] [2021-03-19T15:54:02+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.000629s ] [2021-03-19T15:54:03+08:00][sql] CONNECT:[ UseTime:0.000619s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000972s ] [2021-03-19T15:54:03+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000308s ] [2021-03-19T15:54:03+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.000708s ] [2021-03-19T15:54:03+08:00][sql] CONNECT:[ UseTime:0.000515s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000929s ] [2021-03-19T15:54:03+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000375s ] [2021-03-19T15:54:03+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.000759s ] [2021-03-19T15:54:03+08:00][sql] CONNECT:[ UseTime:0.000650s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001354s ] [2021-03-19T15:54:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE `id` <> 1 [ RunTime:0.000366s ] [2021-03-19T15:54:03+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE `id` <> 1 [ RunTime:0.000602s ] [2021-03-19T15:54:04+08:00][sql] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.001265s ] [2021-03-19T15:54:04+08:00][sql] SELECT `id`,`pid`,`title`,`routing` FROM `yl_node_function` [ RunTime:0.000389s ] [2021-03-19T15:54:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_function` [ RunTime:0.001323s ] [2021-03-19T15:54:04+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.000444s ] [2021-03-19T15:54:21+08:00][sql] CONNECT:[ UseTime:0.000887s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001318s ] [2021-03-19T15:54:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 25 [ RunTime:0.000439s ] [2021-03-19T15:54:21+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000636s ] [2021-03-19T15:54:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001050s ] [2021-03-19T15:54:21+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE ( uuid='' ) LIMIT 1 [ RunTime:0.000361s ] [2021-03-19T15:54:22+08:00][sql] CONNECT:[ UseTime:0.000609s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001084s ] [2021-03-19T15:54:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 24 [ RunTime:0.000660s ] [2021-03-19T15:54:22+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 24 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000855s ] [2021-03-19T15:54:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001010s ] [2021-03-19T15:54:32+08:00][sql] CONNECT:[ UseTime:0.000819s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001074s ] [2021-03-19T15:54:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 24 [ RunTime:0.000259s ] [2021-03-19T15:54:32+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 24 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000499s ] [2021-03-19T15:54:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000782s ] [2021-03-19T15:54:39+08:00][sql] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001128s ] [2021-03-19T15:54:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 27 [ RunTime:0.000661s ] [2021-03-19T15:54:39+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 27 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000744s ] [2021-03-19T15:54:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000841s ] [2021-03-19T15:54:40+08:00][sql] CONNECT:[ UseTime:0.000525s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001230s ] [2021-03-19T15:54:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 28 [ RunTime:0.000319s ] [2021-03-19T15:54:40+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 28 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000392s ] [2021-03-19T15:54:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000823s ] [2021-03-19T15:54:44+08:00][sql] CONNECT:[ UseTime:0.000641s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.001262s ] [2021-03-19T15:54:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_vod_type` [ RunTime:0.001021s ] [2021-03-19T15:54:44+08:00][sql] SELECT * FROM `yl_vod_type` ORDER BY `ctime` DESC LIMIT 0,10 [ RunTime:0.000364s ] [2021-03-19T15:54:45+08:00][sql] CONNECT:[ UseTime:0.000668s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.001080s ] [2021-03-19T15:54:45+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE `display` = 1 [ RunTime:0.000291s ] [2021-03-19T15:54:45+08:00][sql] CONNECT:[ UseTime:0.000719s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod` [ RunTime:0.001032s ] [2021-03-19T15:54:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_vod` `a` LEFT JOIN `yl_vod_type` `b` ON `a`.`type_id`=`b`.`type_id` WHERE `a`.`type_id` = '104479984' [ RunTime:0.000348s ] [2021-03-19T15:54:45+08:00][sql] SELECT `a`.`id`,`vid`,`a`.`type_id`,`initialsize`,vod_name as title,`snapshoturl`,`status`,`a`.`ctime`,`a`.`man_id`,`a`.`type`,`b`.`type_name` FROM `yl_vod` `a` LEFT JOIN `yl_vod_type` `b` ON `a`.`type_id`=`b`.`type_id` WHERE `a`.`type_id` = '104479984' ORDER BY `ctime` DESC LIMIT 0,10 [ RunTime:0.000391s ] [2021-03-19T15:54:45+08:00][sql] CONNECT:[ UseTime:0.000506s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.000819s ] [2021-03-19T15:54:45+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE `display` = 1 [ RunTime:0.000512s ] [2021-03-19T15:54:45+08:00][sql] CONNECT:[ UseTime:0.000437s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T15:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.000810s ] [2021-03-19T15:54:45+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE `display` = 1 [ RunTime:0.000282s ] [2021-03-19T16:00:54+08:00][sql] CONNECT:[ UseTime:0.000634s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T16:00:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001014s ] [2021-03-19T16:00:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 25 [ RunTime:0.000378s ] [2021-03-19T16:00:54+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000427s ] [2021-03-19T16:00:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001432s ] [2021-03-19T16:17:02+08:00][sql] CONNECT:[ UseTime:0.000570s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T16:17:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001398s ] [2021-03-19T16:17:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 24 [ RunTime:0.000528s ] [2021-03-19T16:17:02+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 24 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000684s ] [2021-03-19T16:17:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001221s ] [2021-03-19T16:17:02+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE ( uuid='' ) LIMIT 1 [ RunTime:0.000502s ] [2021-03-19T16:22:17+08:00][sql] CONNECT:[ UseTime:0.000593s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T16:22:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001020s ] [2021-03-19T16:22:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 25 [ RunTime:0.000376s ] [2021-03-19T16:22:17+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000608s ] [2021-03-19T16:22:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001083s ] [2021-03-19T16:22:19+08:00][sql] CONNECT:[ UseTime:0.000467s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-03-19T16:22:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001033s ] [2021-03-19T16:22:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = 24 [ RunTime:0.000321s ] [2021-03-19T16:22:19+08:00][sql] SELECT * FROM `yl_content` WHERE `node_id` = 24 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000509s ] [2021-03-19T16:22:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000911s ]