[2021-03-26T16:21:52+08:00][sql] CONNECT:[ UseTime:0.000605s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:21:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001474s ]
[2021-03-26T16:21:52+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.001123s ]
[2021-03-26T16:21:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001505s ]
[2021-03-26T16:21:52+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000467s ]
[2021-03-26T16:21:52+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 1942832775 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id=2 ) [ RunTime:0.000786s ]
[2021-03-26T16:21:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001381s ]
[2021-03-26T16:21:52+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.000388s ]
[2021-03-26T16:21:54+08:00][sql] CONNECT:[ UseTime:0.000483s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:21:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001224s ]
[2021-03-26T16:21:54+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000395s ]
[2021-03-26T16:21:54+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.000643s ]
[2021-03-26T16:21:54+08:00][sql] CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:21:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000899s ]
[2021-03-26T16:21:54+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000419s ]
[2021-03-26T16:21:54+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.000542s ]
[2021-03-26T16:21:54+08:00][sql] CONNECT:[ UseTime:0.000656s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:21:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001142s ]
[2021-03-26T16:21:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000334s ]
[2021-03-26T16:21:54+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000367s ]
[2021-03-26T16:21:54+08:00][sql] CONNECT:[ UseTime:0.000870s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:21:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.001153s ]
[2021-03-26T16:21:54+08:00][sql] SELECT `id`,`pid`,`title`,`routing` FROM `yl_node_function` [ RunTime:0.000499s ]
[2021-03-26T16:21:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_function` [ RunTime:0.001717s ]
[2021-03-26T16:21:54+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.000437s ]
[2021-03-26T16:21:59+08:00][sql] CONNECT:[ UseTime:0.000648s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:21:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.002985s ]
[2021-03-26T16:21:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 27 [ RunTime:0.000392s ]
[2021-03-26T16:21:59+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 27 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000422s ]
[2021-03-26T16:21:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001088s ]
[2021-03-26T16:21:59+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='' ) LIMIT 1 [ RunTime:0.000332s ]
[2021-03-26T16:22:00+08:00][sql] CONNECT:[ UseTime:0.000706s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:22:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001131s ]
[2021-03-26T16:22:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 28 [ RunTime:0.000280s ]
[2021-03-26T16:22:00+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 28 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000459s ]
[2021-03-26T16:22:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000782s ]
[2021-03-26T16:22:04+08:00][sql] CONNECT:[ UseTime:0.000629s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:22:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000964s ]
[2021-03-26T16:22:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 25 [ RunTime:0.000342s ]
[2021-03-26T16:22:04+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000459s ]
[2021-03-26T16:22:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001017s ]
[2021-03-26T16:22:05+08:00][sql] CONNECT:[ UseTime:0.000599s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:22:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001310s ]
[2021-03-26T16:22:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 24 [ RunTime:0.000505s ]
[2021-03-26T16:22:05+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 24 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000791s ]
[2021-03-26T16:22:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001219s ]
[2021-03-26T16:22:10+08:00][sql] CONNECT:[ UseTime:0.000517s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:22:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000982s ]
[2021-03-26T16:22:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000263s ]
[2021-03-26T16:22:10+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000417s ]
[2021-03-26T16:22:12+08:00][sql] CONNECT:[ UseTime:0.000791s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:22:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001365s ]
[2021-03-26T16:22:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000275s ]
[2021-03-26T16:22:12+08:00][sql] SELECT * FROM `yl_user` LIMIT 10,10 [ RunTime:0.000655s ]
[2021-03-26T16:23:03+08:00][sql] CONNECT:[ UseTime:0.000614s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001296s ]
[2021-03-26T16:23:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` `a` LEFT JOIN `yl_user` `b` ON `b`.`uuid`=`a`.`uuid` LEFT JOIN `yl_party_organ` `c` ON `c`.`id`=`a`.`organ_id` [ RunTime:0.010050s ]
[2021-03-26T16:23:03+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone`,`c`.`organ_name` FROM `yl_user_party` `a` LEFT JOIN `yl_user` `b` ON `b`.`uuid`=`a`.`uuid` LEFT JOIN `yl_party_organ` `c` ON `c`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.001060s ]
[2021-03-26T16:23:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position_relation` [ RunTime:0.001058s ]
[2021-03-26T16:23:03+08:00][sql] SELECT * FROM `yl_party_position_relation` WHERE  `uuid` IN ('b5d2e5683d314980934a5fbacf97673c','51330f3c2c9849d186be38983898ba69','41d2bdd8dfd2496881eff72bb79c1684','6c7060ac30d744759a11a45a82276114','c9de18c5992f424ca0c2bfbfc7001234','9435e7d9193f4662b51c7fe8c6907369','f9b9cc0a9f6a4df491401d57ed830a0f','3fc7ec61c43840beb73c29863c414bf4','1a8340ec19e14853940889cb7753937d','f7721013e39a4306a0dd96b9ae9589a3') [ RunTime:0.000291s ]
[2021-03-26T16:23:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.000863s ]
[2021-03-26T16:23:03+08:00][sql] SELECT `id`,`name` FROM `yl_party_bd_resource` WHERE  `id` IN (9,8,1,6,7) [ RunTime:0.000499s ]
[2021-03-26T16:23:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.001212s ]
[2021-03-26T16:23:03+08:00][sql] CONNECT:[ UseTime:0.000641s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.001073s ]
[2021-03-26T16:23:03+08:00][sql] SELECT code as id,`name`,`level` FROM `yl_region` WHERE  `pid` = 0 [ RunTime:0.000407s ]
[2021-03-26T16:23:04+08:00][sql] CONNECT:[ UseTime:0.001137s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position` [ RunTime:0.001654s ]
[2021-03-26T16:23:04+08:00][sql] SELECT `id`,`name` FROM `yl_party_position` ORDER BY `organ_id` DESC [ RunTime:0.000306s ]
[2021-03-26T16:23:04+08:00][sql] CONNECT:[ UseTime:0.000429s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001043s ]
[2021-03-26T16:23:04+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `status` = 1 [ RunTime:0.000488s ]
[2021-03-26T16:23:04+08:00][sql] CONNECT:[ UseTime:0.000544s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.001234s ]
[2021-03-26T16:23:04+08:00][sql] SELECT `id`,`name` FROM `yl_party_bd_resource` ORDER BY `id` DESC [ RunTime:0.000436s ]
[2021-03-26T16:23:04+08:00][sql] CONNECT:[ UseTime:0.000548s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position` [ RunTime:0.001245s ]
[2021-03-26T16:23:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_position` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.003373s ]
[2021-03-26T16:23:04+08:00][sql] CONNECT:[ UseTime:0.000479s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000914s ]
[2021-03-26T16:23:04+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `status` = 1 [ RunTime:0.000318s ]
[2021-03-26T16:23:05+08:00][sql] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000998s ]
[2021-03-26T16:23:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_organ` [ RunTime:0.000255s ]
[2021-03-26T16:23:05+08:00][sql] SELECT * FROM `yl_party_organ` ORDER BY `id` ASC [ RunTime:0.000341s ]
[2021-03-26T16:23:07+08:00][sql] CONNECT:[ UseTime:0.000716s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues_detail` [ RunTime:0.001291s ]
[2021-03-26T16:23:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_dues_detail` `a` LEFT JOIN `yl_party_dues` `b` ON `b`.`id`=`a`.`party_dues_id` [ RunTime:0.006722s ]
[2021-03-26T16:23:07+08:00][sql] SELECT `a`.*,`b`.`uuid`,`b`.`years` FROM `yl_party_dues_detail` `a` LEFT JOIN `yl_party_dues` `b` ON `b`.`id`=`a`.`party_dues_id` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002444s ]
[2021-03-26T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001467s ]
[2021-03-26T16:23:07+08:00][sql] CONNECT:[ UseTime:0.000810s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001054s ]
[2021-03-26T16:23:07+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.000492s ]
[2021-03-26T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001046s ]
[2021-03-26T16:23:07+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='b5d2e5683d314980934a5fbacf97673c' ) LIMIT 1 [ RunTime:0.000523s ]
[2021-03-26T16:23:07+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='51330f3c2c9849d186be38983898ba69' ) LIMIT 1 [ RunTime:0.000424s ]
[2021-03-26T16:23:07+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='41d2bdd8dfd2496881eff72bb79c1684' ) LIMIT 1 [ RunTime:0.000357s ]
[2021-03-26T16:23:07+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='6c7060ac30d744759a11a45a82276114' ) LIMIT 1 [ RunTime:0.000786s ]
[2021-03-26T16:23:07+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='9435e7d9193f4662b51c7fe8c6907369' ) LIMIT 1 [ RunTime:0.000354s ]
[2021-03-26T16:23:18+08:00][sql] CONNECT:[ UseTime:0.000801s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues_detail` [ RunTime:0.001247s ]
[2021-03-26T16:23:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_dues_detail` `a` LEFT JOIN `yl_party_dues` `b` ON `b`.`id`=`a`.`party_dues_id` [ RunTime:0.000403s ]
[2021-03-26T16:23:18+08:00][sql] SELECT `a`.*,`b`.`uuid`,`b`.`years` FROM `yl_party_dues_detail` `a` LEFT JOIN `yl_party_dues` `b` ON `b`.`id`=`a`.`party_dues_id` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000760s ]
[2021-03-26T16:23:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001397s ]
[2021-03-26T16:23:25+08:00][sql] CONNECT:[ UseTime:0.000751s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001083s ]
[2021-03-26T16:23:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000417s ]
[2021-03-26T16:23:25+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000263s ]
[2021-03-26T16:23:26+08:00][sql] CONNECT:[ UseTime:0.000677s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001049s ]
[2021-03-26T16:23:26+08:00][sql] SELECT `id`,`pid`,`title`,`level` FROM `yl_node_column` ORDER BY `sort` [ RunTime:0.003440s ]
[2021-03-26T16:23:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_column` [ RunTime:0.000866s ]
[2021-03-26T16:23:26+08:00][sql] SELECT `t2`.`id`,`t1`.`node_id`,`t1`.`status` FROM `yl_role_access_column` `t1` LEFT JOIN `yl_role` `t2` ON `t1`.`role_id`=`t2`.`id` [ RunTime:0.006375s ]
[2021-03-26T16:23:26+08:00][sql] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.000803s ]
[2021-03-26T16:23:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000287s ]
[2021-03-26T16:23:26+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000242s ]
[2021-03-26T16:23:26+08:00][sql] CONNECT:[ UseTime:0.000521s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.000895s ]
[2021-03-26T16:23:26+08:00][sql] SELECT `id`,`pid`,`title`,`routing` FROM `yl_node_function` [ RunTime:0.000380s ]
[2021-03-26T16:23:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_function` [ RunTime:0.000732s ]
[2021-03-26T16:23:26+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.000318s ]
[2021-03-26T16:23:27+08:00][sql] CONNECT:[ UseTime:0.000666s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000983s ]
[2021-03-26T16:23:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` WHERE  `is_advance` = 'n' [ RunTime:0.003210s ]
[2021-03-26T16:23:27+08:00][sql] SELECT a.*,b.organ_name,DATE_FORMAT(a.start_time, "%Y-%m-%d %H:%i") as start_time, DATE_FORMAT(a.end_time, "%Y-%m-%d %H:%i") as end_time FROM `yl_meeting` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` WHERE  `is_advance` = 'n' ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000833s ]
[2021-03-26T16:23:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001402s ]
[2021-03-26T16:23:28+08:00][sql] CONNECT:[ UseTime:0.000621s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000889s ]
[2021-03-26T16:23:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` WHERE  `is_advance` = 'y' [ RunTime:0.000937s ]
[2021-03-26T16:23:28+08:00][sql] SELECT a.*,b.organ_name,DATE_FORMAT(a.start_time, "%Y-%m-%d %H:%i") as start_time, DATE_FORMAT(a.end_time, "%Y-%m-%d %H:%i") as end_time FROM `yl_meeting` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` WHERE  `is_advance` = 'y' ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000511s ]
[2021-03-26T16:23:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000763s ]
[2021-03-26T16:23:30+08:00][sql] CONNECT:[ UseTime:0.000607s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:23:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.000926s ]
[2021-03-26T16:23:30+08:00][sql] SELECT `pid`,code id,`name`,`level` FROM `yl_region` [ RunTime:0.018390s ]
[2021-03-26T16:26:01+08:00][sql] CONNECT:[ UseTime:0.000616s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.003784s ]
[2021-03-26T16:26:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_vod_type` [ RunTime:0.000380s ]
[2021-03-26T16:26:01+08:00][sql] SELECT * FROM `yl_vod_type` ORDER BY `ctime` DESC LIMIT 0,10 [ RunTime:0.000442s ]
[2021-03-26T16:26:01+08:00][sql] CONNECT:[ UseTime:0.000658s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001705s ]
[2021-03-26T16:26:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000653s ]
[2021-03-26T16:26:01+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000721s ]
[2021-03-26T16:26:02+08:00][sql] CONNECT:[ UseTime:0.000906s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001098s ]
[2021-03-26T16:26:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000390s ]
[2021-03-26T16:26:02+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000454s ]
[2021-03-26T16:26:03+08:00][sql] CONNECT:[ UseTime:0.000578s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001132s ]
[2021-03-26T16:26:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000467s ]
[2021-03-26T16:26:03+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000277s ]
[2021-03-26T16:26:03+08:00][sql] CONNECT:[ UseTime:0.000635s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.000942s ]
[2021-03-26T16:26:03+08:00][sql] SELECT * FROM `yl_node_function` [ RunTime:0.003734s ]
[2021-03-26T16:26:04+08:00][sql] CONNECT:[ UseTime:0.000595s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_documents_category` [ RunTime:0.001246s ]
[2021-03-26T16:26:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_documents_category` [ RunTime:0.003462s ]
[2021-03-26T16:26:04+08:00][sql] SELECT * FROM `yl_documents_category` ORDER BY `ctime` DESC LIMIT 0,10 [ RunTime:0.000393s ]
[2021-03-26T16:26:06+08:00][sql] CONNECT:[ UseTime:0.000667s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001095s ]
[2021-03-26T16:26:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 25 [ RunTime:0.000283s ]
[2021-03-26T16:26:06+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000451s ]
[2021-03-26T16:26:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000826s ]
[2021-03-26T16:26:08+08:00][sql] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity` [ RunTime:0.001420s ]
[2021-03-26T16:26:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_activity` `a` LEFT JOIN `yl_activity_form` `b` ON `b`.`id`=`a`.`form_id` [ RunTime:0.000454s ]
[2021-03-26T16:26:08+08:00][sql] CONNECT:[ UseTime:0.000602s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.000935s ]
[2021-03-26T16:26:08+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000368s ]
[2021-03-26T16:26:09+08:00][sql] CONNECT:[ UseTime:0.000712s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.000998s ]
[2021-03-26T16:26:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000369s ]
[2021-03-26T16:26:09+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000326s ]
[2021-03-26T16:26:09+08:00][sql] CONNECT:[ UseTime:0.000595s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.000955s ]
[2021-03-26T16:26:09+08:00][sql] SELECT `id`,`pid`,`title`,`routing` FROM `yl_node_function` [ RunTime:0.000425s ]
[2021-03-26T16:26:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_function` [ RunTime:0.000729s ]
[2021-03-26T16:26:09+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.000448s ]
[2021-03-26T16:26:09+08:00][sql] CONNECT:[ UseTime:0.000647s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.000961s ]
[2021-03-26T16:26:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000471s ]
[2021-03-26T16:26:09+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000322s ]
[2021-03-26T16:26:10+08:00][sql] CONNECT:[ UseTime:0.000647s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001008s ]
[2021-03-26T16:26:10+08:00][sql] SELECT `id`,`pid`,`title`,`level` FROM `yl_node_column` ORDER BY `sort` [ RunTime:0.000458s ]
[2021-03-26T16:26:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_column` [ RunTime:0.000634s ]
[2021-03-26T16:26:10+08:00][sql] SELECT `t2`.`id`,`t1`.`node_id`,`t1`.`status` FROM `yl_role_access_column` `t1` LEFT JOIN `yl_role` `t2` ON `t1`.`role_id`=`t2`.`id` [ RunTime:0.000399s ]
[2021-03-26T16:26:33+08:00][sql] CONNECT:[ UseTime:0.000789s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.001024s ]
[2021-03-26T16:26:33+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE  `display` = 1 [ RunTime:0.000563s ]
[2021-03-26T16:26:33+08:00][sql] CONNECT:[ UseTime:0.000504s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.000949s ]
[2021-03-26T16:26:33+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE  `display` = 1 [ RunTime:0.000347s ]
[2021-03-26T16:26:33+08:00][sql] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.001008s ]
[2021-03-26T16:26:33+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE  `display` = 1 [ RunTime:0.000335s ]
[2021-03-26T16:26:33+08:00][sql] CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod` [ RunTime:0.001726s ]
[2021-03-26T16:26:33+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.000400s ]
[2021-03-26T16:26:33+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.000552s ]
[2021-03-26T16:26:34+08:00][sql] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_receive` [ RunTime:0.001138s ]
[2021-03-26T16:26:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_receive` `tr` INNER JOIN `yl_task` `t` ON `t`.`id`=`tr`.`task_id` WHERE  `t`.`is_back` = 'n'  AND `tr`.`status` = '已处理'  AND (  tr.receiver_uuid="4c8f125cd4334b248dceed93ee330685" OR t.sender_uuid="4c8f125cd4334b248dceed93ee330685" ) [ RunTime:0.004348s ]
[2021-03-26T16:26:34+08:00][sql] CONNECT:[ UseTime:0.000482s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.000814s ]
[2021-03-26T16:26:34+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000485s ]
[2021-03-26T16:26:34+08:00][sql] CONNECT:[ UseTime:0.000528s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_receive` [ RunTime:0.000952s ]
[2021-03-26T16:26:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_receive` `tr` INNER JOIN `yl_task` `t` ON `t`.`id`=`tr`.`task_id` WHERE  `t`.`is_back` = 'n'  AND `t`.`deadline` < '2021-03-26'  AND `tr`.`status` = '待处理'  AND (  tr.receiver_uuid="4c8f125cd4334b248dceed93ee330685" OR t.sender_uuid="4c8f125cd4334b248dceed93ee330685" ) [ RunTime:0.005619s ]
[2021-03-26T16:26:34+08:00][sql] CONNECT:[ UseTime:0.000610s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:26:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.000851s ]
[2021-03-26T16:26:34+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.001085s ]
[2021-03-26T16:27:44+08:00][sql] CONNECT:[ UseTime:0.000598s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:27:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.000909s ]
[2021-03-26T16:27:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_vod_type` [ RunTime:0.000282s ]
[2021-03-26T16:27:44+08:00][sql] SELECT * FROM `yl_vod_type` ORDER BY `ctime` DESC LIMIT 0,10 [ RunTime:0.000290s ]
[2021-03-26T16:27:44+08:00][sql] CONNECT:[ UseTime:0.000719s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:27:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.001078s ]
[2021-03-26T16:27:44+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE  `display` = 1 [ RunTime:0.000346s ]
[2021-03-26T16:27:45+08:00][sql] CONNECT:[ UseTime:0.000533s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:27:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.000866s ]
[2021-03-26T16:27:45+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE  `display` = 1 [ RunTime:0.000452s ]
[2021-03-26T16:27:45+08:00][sql] CONNECT:[ UseTime:0.000509s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:27:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.001159s ]
[2021-03-26T16:27:45+08:00][sql] SELECT type_id AS id,type_name AS name FROM `yl_vod_type` WHERE  `display` = 1 [ RunTime:0.000568s ]
[2021-03-26T16:27:45+08:00][sql] CONNECT:[ UseTime:0.000623s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:27:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod` [ RunTime:0.000997s ]
[2021-03-26T16:27: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.000386s ]
[2021-03-26T16:27: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.000377s ]
[2021-03-26T16:28:27+08:00][sql] CONNECT:[ UseTime:0.000498s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_receive` [ RunTime:0.001484s ]
[2021-03-26T16:28:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_receive` `tr` INNER JOIN `yl_task` `t` ON `t`.`id`=`tr`.`task_id` WHERE  `t`.`is_back` = 'n'  AND `tr`.`status` = '已处理'  AND (  tr.receiver_uuid="4c8f125cd4334b248dceed93ee330685" OR t.sender_uuid="4c8f125cd4334b248dceed93ee330685" ) [ RunTime:0.000649s ]
[2021-03-26T16:28:27+08:00][sql] CONNECT:[ UseTime:0.000925s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.001305s ]
[2021-03-26T16:28:27+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000341s ]
[2021-03-26T16:28:28+08:00][sql] CONNECT:[ UseTime:0.000451s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_receive` [ RunTime:0.000717s ]
[2021-03-26T16:28:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_receive` `tr` INNER JOIN `yl_task` `t` ON `t`.`id`=`tr`.`task_id` WHERE  `t`.`is_back` = 'n'  AND `t`.`deadline` >= '2021-03-26'  AND `tr`.`status` = '待处理'  AND `tr`.`handler_uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000439s ]
[2021-03-26T16:28:28+08:00][sql] CONNECT:[ UseTime:0.000533s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.001091s ]
[2021-03-26T16:28:28+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000298s ]
[2021-03-26T16:28:29+08:00][sql] CONNECT:[ UseTime:0.000706s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_documents_category` [ RunTime:0.000903s ]
[2021-03-26T16:28:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_documents_category` [ RunTime:0.000204s ]
[2021-03-26T16:28:29+08:00][sql] SELECT * FROM `yl_documents_category` ORDER BY `ctime` DESC LIMIT 0,10 [ RunTime:0.000228s ]
[2021-03-26T16:28:30+08:00][sql] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.001103s ]
[2021-03-26T16:28:30+08:00][sql] SELECT * FROM `yl_node_function` [ RunTime:0.000563s ]
[2021-03-26T16:28:33+08:00][sql] CONNECT:[ UseTime:0.000749s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000942s ]
[2021-03-26T16:28:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000410s ]
[2021-03-26T16:28:33+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000408s ]
[2021-03-26T16:28:34+08:00][sql] CONNECT:[ UseTime:0.000527s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001268s ]
[2021-03-26T16:28:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000375s ]
[2021-03-26T16:28:34+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000375s ]
[2021-03-26T16:28:39+08:00][sql] CONNECT:[ UseTime:0.000584s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000930s ]
[2021-03-26T16:28:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000409s ]
[2021-03-26T16:28:39+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000483s ]
[2021-03-26T16:28:39+08:00][sql] CONNECT:[ UseTime:0.000593s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.001011s ]
[2021-03-26T16:28:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_bd_resource` [ RunTime:0.000272s ]
[2021-03-26T16:28:39+08:00][sql] SELECT * FROM `yl_party_bd_resource` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000324s ]
[2021-03-26T16:28:40+08:00][sql] CONNECT:[ UseTime:0.000583s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001062s ]
[2021-03-26T16:28:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000448s ]
[2021-03-26T16:28:40+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000463s ]
[2021-03-26T16:28:40+08:00][sql] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000978s ]
[2021-03-26T16:28:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000293s ]
[2021-03-26T16:28:40+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000375s ]
[2021-03-26T16:28:40+08:00][sql] CONNECT:[ UseTime:0.000864s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000947s ]
[2021-03-26T16:28:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_organ` [ RunTime:0.000309s ]
[2021-03-26T16:28:40+08:00][sql] SELECT * FROM `yl_party_organ` ORDER BY `id` ASC [ RunTime:0.000405s ]
[2021-03-26T16:28:41+08:00][sql] CONNECT:[ UseTime:0.000579s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues_detail` [ RunTime:0.001261s ]
[2021-03-26T16:28:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_dues_detail` `a` LEFT JOIN `yl_party_dues` `b` ON `b`.`id`=`a`.`party_dues_id` [ RunTime:0.000484s ]
[2021-03-26T16:28:41+08:00][sql] SELECT `a`.*,`b`.`uuid`,`b`.`years` FROM `yl_party_dues_detail` `a` LEFT JOIN `yl_party_dues` `b` ON `b`.`id`=`a`.`party_dues_id` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000494s ]
[2021-03-26T16:28:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001088s ]
[2021-03-26T16:28:41+08:00][sql] CONNECT:[ UseTime:0.000655s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001114s ]
[2021-03-26T16:28:41+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.000363s ]
[2021-03-26T16:28:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001317s ]
[2021-03-26T16:28:47+08:00][sql] CONNECT:[ UseTime:0.000526s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001061s ]
[2021-03-26T16:28:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 27 [ RunTime:0.000292s ]
[2021-03-26T16:28:47+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 27 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000350s ]
[2021-03-26T16:28:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001116s ]
[2021-03-26T16:28:47+08:00][sql] CONNECT:[ UseTime:0.000732s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001382s ]
[2021-03-26T16:28:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 25 [ RunTime:0.000304s ]
[2021-03-26T16:28:47+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000364s ]
[2021-03-26T16:28:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001140s ]
[2021-03-26T16:28:48+08:00][sql] CONNECT:[ UseTime:0.000845s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001053s ]
[2021-03-26T16:28:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 24 [ RunTime:0.000428s ]
[2021-03-26T16:28:48+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 24 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000593s ]
[2021-03-26T16:28:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000828s ]
[2021-03-26T16:28:50+08:00][sql] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:28:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001412s ]
[2021-03-26T16:28:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 24 [ RunTime:0.000416s ]
[2021-03-26T16:28:50+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 24 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.006690s ]
[2021-03-26T16:28:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000924s ]
[2021-03-26T16:29:08+08:00][sql] CONNECT:[ UseTime:0.000732s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.001131s ]
[2021-03-26T16:29:08+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000365s ]
[2021-03-26T16:29:08+08:00][sql] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity` [ RunTime:0.001062s ]
[2021-03-26T16:29:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_activity` `a` LEFT JOIN `yl_activity_form` `b` ON `b`.`id`=`a`.`form_id` [ RunTime:0.000315s ]
[2021-03-26T16:29:09+08:00][sql] CONNECT:[ UseTime:0.000718s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001033s ]
[2021-03-26T16:29:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000337s ]
[2021-03-26T16:29:09+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000313s ]
[2021-03-26T16:29:09+08:00][sql] CONNECT:[ UseTime:0.000617s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001080s ]
[2021-03-26T16:29:09+08:00][sql] SELECT `id`,`pid`,`title`,`level` FROM `yl_node_column` ORDER BY `sort` [ RunTime:0.000483s ]
[2021-03-26T16:29:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_column` [ RunTime:0.001332s ]
[2021-03-26T16:29:09+08:00][sql] SELECT `t2`.`id`,`t1`.`node_id`,`t1`.`status` FROM `yl_role_access_column` `t1` LEFT JOIN `yl_role` `t2` ON `t1`.`role_id`=`t2`.`id` [ RunTime:0.000415s ]
[2021-03-26T16:29:09+08:00][sql] CONNECT:[ UseTime:0.000600s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.000853s ]
[2021-03-26T16:29:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000351s ]
[2021-03-26T16:29:09+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000293s ]
[2021-03-26T16:29:09+08:00][sql] CONNECT:[ UseTime:0.000629s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.001281s ]
[2021-03-26T16:29:09+08:00][sql] SELECT `id`,`pid`,`title`,`routing` FROM `yl_node_function` [ RunTime:0.000621s ]
[2021-03-26T16:29:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_function` [ RunTime:0.000860s ]
[2021-03-26T16:29:09+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.000500s ]
[2021-03-26T16:29:10+08:00][sql] CONNECT:[ UseTime:0.000771s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001061s ]
[2021-03-26T16:29:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000454s ]
[2021-03-26T16:29:10+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 LIMIT 0,10 [ RunTime:0.000400s ]
[2021-03-26T16:29:11+08:00][sql] CONNECT:[ UseTime:0.000706s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.001044s ]
[2021-03-26T16:29:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_bd_resource` [ RunTime:0.000372s ]
[2021-03-26T16:29:11+08:00][sql] SELECT * FROM `yl_party_bd_resource` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000322s ]
[2021-03-26T16:29:35+08:00][sql] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001237s ]
[2021-03-26T16:29:35+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `type` <> '党小组'  AND `status` = 1 [ RunTime:0.000551s ]
[2021-03-26T16:29:35+08:00][sql] CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.000903s ]
[2021-03-26T16:29:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000431s ]
[2021-03-26T16:29:35+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000360s ]
[2021-03-26T16:29:35+08:00][sql] CONNECT:[ UseTime:0.000623s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001151s ]
[2021-03-26T16:29:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_role` `t1` WHERE  `t1`.`role_id` = '5' [ RunTime:0.005368s ]
[2021-03-26T16:29:35+08:00][sql] SELECT `t2`.`uuid`,`t2`.`name`,`t2`.`sex`,`t2`.`birthday`,`t2`.`political`,`t2`.`cardid`,`t2`.`peopletype`,`t2`.`telephone` FROM `yl_user_role` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` WHERE  `t1`.`role_id` = '5' LIMIT 0,10 [ RunTime:0.002189s ]
[2021-03-26T16:29:49+08:00][sql] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T16:29:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001217s ]
[2021-03-26T16:29:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = 25 [ RunTime:0.000483s ]
[2021-03-26T16:29:49+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = 25 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000513s ]
[2021-03-26T16:29:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000797s ]
[2021-03-26T17:05:50+08:00][sql] CONNECT:[ UseTime:0.000593s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_vod_type` [ RunTime:0.000997s ]
[2021-03-26T17:05:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_vod_type` [ RunTime:0.000228s ]
[2021-03-26T17:05:50+08:00][sql] SELECT * FROM `yl_vod_type` ORDER BY `ctime` DESC LIMIT 0,10 [ RunTime:0.000299s ]
[2021-03-26T17:05:51+08:00][sql] CONNECT:[ UseTime:0.000455s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:51+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_function` [ RunTime:0.001110s ]
[2021-03-26T17:05:51+08:00][sql] SELECT * FROM `yl_node_function` [ RunTime:0.000443s ]
[2021-03-26T17:05:52+08:00][sql] CONNECT:[ UseTime:0.000638s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001226s ]
[2021-03-26T17:05:52+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000402s ]
[2021-03-26T17:05:54+08:00][sql] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001254s ]
[2021-03-26T17:05:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_talk` [ RunTime:0.000820s ]
[2021-03-26T17:05:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_talk` [ RunTime:0.003006s ]
[2021-03-26T17:05:54+08:00][sql] CONNECT:[ UseTime:0.000646s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001307s ]
[2021-03-26T17:05:54+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.000401s ]
[2021-03-26T17:05:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000970s ]
[2021-03-26T17:05:57+08:00][sql] CONNECT:[ UseTime:0.000617s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001183s ]
[2021-03-26T17:05:57+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `type` <> '党小组'  AND `status` = 1 [ RunTime:0.000461s ]
[2021-03-26T17:05:57+08:00][sql] CONNECT:[ UseTime:0.000630s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001039s ]
[2021-03-26T17:05:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000393s ]
[2021-03-26T17:05:57+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000363s ]
[2021-03-26T17:05:57+08:00][sql] CONNECT:[ UseTime:0.000768s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001233s ]
[2021-03-26T17:05:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_role` `t1` WHERE  `t1`.`role_id` = '5' [ RunTime:0.000325s ]
[2021-03-26T17:05:57+08:00][sql] SELECT `t2`.`uuid`,`t2`.`name`,`t2`.`sex`,`t2`.`birthday`,`t2`.`political`,`t2`.`cardid`,`t2`.`peopletype`,`t2`.`telephone` FROM `yl_user_role` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` WHERE  `t1`.`role_id` = '5' LIMIT 0,10 [ RunTime:0.000362s ]
[2021-03-26T17:05:58+08:00][sql] CONNECT:[ UseTime:0.000581s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001115s ]
[2021-03-26T17:05:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000226s ]
[2021-03-26T17:05:58+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000346s ]
[2021-03-26T17:10:45+08:00][sql] CONNECT:[ UseTime:0.000696s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:10:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001163s ]
[2021-03-26T17:10:45+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `type` <> '党小组'  AND `status` = 1 [ RunTime:0.000491s ]
[2021-03-26T17:10:45+08:00][sql] CONNECT:[ UseTime:0.000706s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:10:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.000984s ]
[2021-03-26T17:10:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000341s ]
[2021-03-26T17:10:45+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000423s ]
[2021-03-26T17:10:45+08:00][sql] CONNECT:[ UseTime:0.000806s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:10:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000983s ]
[2021-03-26T17:10:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_role` `t1` WHERE  `t1`.`role_id` = '5' [ RunTime:0.000322s ]
[2021-03-26T17:10:45+08:00][sql] SELECT `t2`.`uuid`,`t2`.`name`,`t2`.`sex`,`t2`.`birthday`,`t2`.`political`,`t2`.`cardid`,`t2`.`peopletype`,`t2`.`telephone` FROM `yl_user_role` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` WHERE  `t1`.`role_id` = '5' LIMIT 0,10 [ RunTime:0.000537s ]
[2021-03-26T17:10:46+08:00][sql] CONNECT:[ UseTime:0.000699s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-03-26T17:10:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001296s ]
[2021-03-26T17:10:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000294s ]
[2021-03-26T17:10:46+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000405s ]