[2021-07-13T10:12:05+08:00][sql] CONNECT:[ UseTime:0.000637s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:12:05+08:00][sql] select table_name from information_schema.tables where table_schema='dangjian_pudong' and table_name like 'yl_data%' [ RunTime:0.004908s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_bloodtype` [ RunTime:0.008743s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_bloodtype` [ RunTime:0.000522s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_country` [ RunTime:0.004479s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_country` [ RunTime:0.000851s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_education` [ RunTime:0.025191s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_education` [ RunTime:0.000410s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_gender` [ RunTime:0.005702s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_gender` [ RunTime:0.000595s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_health` [ RunTime:0.003960s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_health` [ RunTime:0.000442s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_idtype` [ RunTime:0.005851s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_idtype` [ RunTime:0.000447s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_intoreason` [ RunTime:0.003856s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_intoreason` [ RunTime:0.000620s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_marital` [ RunTime:0.004032s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_marital` [ RunTime:0.000386s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_military` [ RunTime:0.003996s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_military` [ RunTime:0.000449s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_national` [ RunTime:0.004424s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_national` [ RunTime:0.000514s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_peopletype` [ RunTime:0.003577s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_peopletype` [ RunTime:0.000380s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_political` [ RunTime:0.004956s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_political` [ RunTime:0.000539s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_relationship` [ RunTime:0.004385s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_relationship` [ RunTime:0.000876s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_religious` [ RunTime:0.004097s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_religious` [ RunTime:0.000544s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_unit_type` [ RunTime:0.003957s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_unit_type` [ RunTime:0.000387s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_data_visit_type` [ RunTime:0.004442s ]
[2021-07-13T10:12:05+08:00][sql] SELECT code as id,`name` FROM `yl_data_visit_type` [ RunTime:0.000436s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.020167s ]
[2021-07-13T10:12:05+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.006503s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.006707s ]
[2021-07-13T10:12:05+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000661s ]
[2021-07-13T10:12:05+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 1942069938 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id=2 ) [ RunTime:0.000686s ]
[2021-07-13T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.008136s ]
[2021-07-13T10:12:05+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/90.0.4430.212 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000444s ]
[2021-07-13T10:12:07+08:00][sql] CONNECT:[ UseTime:0.001213s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:12:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_function` [ RunTime:0.031540s ]
[2021-07-13T10:12:07+08:00][sql] SELECT concat_ws("/", t1.role_id, t2.routing) as role, t1.status FROM `yl_role_access_function` `t1` LEFT JOIN `yl_node_function` `t2` ON `t2`.`routing`=`t1`.`routing` [ RunTime:0.013342s ]
[2021-07-13T10:12:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.013839s ]
[2021-07-13T10:12:07+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000566s ]
[2021-07-13T10:12:07+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.015237s ]
[2021-07-13T10:12:07+08:00][sql] CONNECT:[ UseTime:0.000451s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:12:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000860s ]
[2021-07-13T10:12:07+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000361s ]
[2021-07-13T10:12:07+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.000724s ]
[2021-07-13T10:12:07+08:00][sql] CONNECT:[ UseTime:0.000659s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:12:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.034090s ]
[2021-07-13T10:12:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000848s ]
[2021-07-13T10:12:07+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000704s ]
[2021-07-13T10:12:08+08:00][sql] CONNECT:[ UseTime:0.000631s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:12:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001123s ]
[2021-07-13T10:12:08+08:00][sql] SELECT `id`,`pid`,`title`,`level` FROM `yl_node_column` ORDER BY `sort` [ RunTime:0.000812s ]
[2021-07-13T10:12:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_column` [ RunTime:0.000978s ]
[2021-07-13T10:12:08+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.000837s ]
[2021-07-13T10:16:29+08:00][sql] CONNECT:[ UseTime:0.000560s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:16:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001040s ]
[2021-07-13T10:16:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_report` [ RunTime:0.027682s ]
[2021-07-13T10:16:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_report` [ RunTime:0.000616s ]
[2021-07-13T10:16:29+08:00][sql] SELECT * FROM `yl_party_report` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000793s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='4c8f125cd4334b248dceed93ee330685' ) LIMIT 1 [ RunTime:0.000675s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='766824f501de45cf97486d1c95939ace' ) LIMIT 1 [ RunTime:0.000646s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='feb5db5a3bab40b39e1e2ca1fbe0a485' ) LIMIT 1 [ RunTime:0.000532s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='ad7077b6fef0426bb6fd14d26afe535f' ) LIMIT 1 [ RunTime:0.000519s ]
[2021-07-13T10:16:29+08:00][sql] CONNECT:[ UseTime:0.000763s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:16:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.003088s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `id`,theme as name FROM `yl_standing_book` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.004603s ]
[2021-07-13T10:16:29+08:00][sql] CONNECT:[ UseTime:0.000763s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:16:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.005354s ]
[2021-07-13T10:16:29+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.003407s ]
[2021-07-13T10:16:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001199s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='b5d2e5683d314980934a5fbacf97673c' ) LIMIT 1 [ RunTime:0.000635s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='51330f3c2c9849d186be38983898ba69' ) LIMIT 1 [ RunTime:0.000424s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='41d2bdd8dfd2496881eff72bb79c1684' ) LIMIT 1 [ RunTime:0.000545s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='6c7060ac30d744759a11a45a82276114' ) LIMIT 1 [ RunTime:0.000390s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='c9de18c5992f424ca0c2bfbfc7001234' ) LIMIT 1 [ RunTime:0.000446s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='9435e7d9193f4662b51c7fe8c6907369' ) LIMIT 1 [ RunTime:0.000374s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='f9b9cc0a9f6a4df491401d57ed830a0f' ) LIMIT 1 [ RunTime:0.000398s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='3fc7ec61c43840beb73c29863c414bf4' ) LIMIT 1 [ RunTime:0.000436s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='1a8340ec19e14853940889cb7753937d' ) LIMIT 1 [ RunTime:0.000330s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='f7721013e39a4306a0dd96b9ae9589a3' ) LIMIT 1 [ RunTime:0.000398s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='57ac4d52a64041838e2f2a67c617c088' ) LIMIT 1 [ RunTime:0.000389s ]
[2021-07-13T10:16:29+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='c845765990724681b9acbf465bd8329b' ) LIMIT 1 [ RunTime:0.000506s ]
[2021-07-13T10:16:30+08:00][sql] CONNECT:[ UseTime:0.000668s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:16:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.004117s ]
[2021-07-13T10:16:30+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.010725s ]
[2021-07-13T10:16:30+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.000870s ]
[2021-07-13T10:16:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000991s ]
[2021-07-13T10:16:30+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='' ) LIMIT 1 [ RunTime:0.000353s ]
[2021-07-13T10:24:52+08:00][sql] CONNECT:[ UseTime:0.000760s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:24:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000968s ]
[2021-07-13T10:24:52+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000341s ]
[2021-07-13T10:24:52+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.000688s ]
[2021-07-13T10:24:53+08:00][sql] CONNECT:[ UseTime:0.000699s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:24:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001061s ]
[2021-07-13T10:24:53+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.000584s ]
[2021-07-13T10:24:53+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.000467s ]
[2021-07-13T10:24:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001000s ]
[2021-07-13T10:25:01+08:00][sql] CONNECT:[ UseTime:0.000742s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001169s ]
[2021-07-13T10:25:01+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.000688s ]
[2021-07-13T10:25:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001718s ]
[2021-07-13T10:25:01+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000278s ]
[2021-07-13T10:25:01+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 1942069938 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id=2 ) [ RunTime:0.000536s ]
[2021-07-13T10:25:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000829s ]
[2021-07-13T10:25:01+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/90.0.4430.212 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000353s ]
[2021-07-13T10:25:02+08:00][sql] CONNECT:[ UseTime:0.000621s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000812s ]
[2021-07-13T10:25:02+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000369s ]
[2021-07-13T10:25:02+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.000657s ]
[2021-07-13T10:25:02+08:00][sql] CONNECT:[ UseTime:0.000561s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000915s ]
[2021-07-13T10:25:02+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000313s ]
[2021-07-13T10:25:02+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.000604s ]
[2021-07-13T10:25:02+08:00][sql] CONNECT:[ UseTime:0.000593s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.000897s ]
[2021-07-13T10:25:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000455s ]
[2021-07-13T10:25:02+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000320s ]
[2021-07-13T10:25:03+08:00][sql] CONNECT:[ UseTime:0.000739s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001203s ]
[2021-07-13T10:25:03+08:00][sql] SELECT `id`,`pid`,`title`,`level` FROM `yl_node_column` ORDER BY `sort` [ RunTime:0.000455s ]
[2021-07-13T10:25:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_role_access_column` [ RunTime:0.000998s ]
[2021-07-13T10:25:03+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.000561s ]
[2021-07-13T10:25:10+08:00][sql] CONNECT:[ UseTime:0.000556s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000929s ]
[2021-07-13T10:25:10+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.000276s ]
[2021-07-13T10:25:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000858s ]
[2021-07-13T10:25:10+08:00][sql] CONNECT:[ UseTime:0.000867s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001254s ]
[2021-07-13T10:25:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_evaluate` [ RunTime:0.004073s ]
[2021-07-13T10:25:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_evaluate` [ RunTime:0.000483s ]
[2021-07-13T10:25:10+08:00][sql] SELECT * FROM `yl_party_evaluate` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000593s ]
[2021-07-13T10:25:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_evaluate_self` [ RunTime:0.005076s ]
[2021-07-13T10:25:10+08:00][sql] SELECT GROUP_CONCAT(uuid) AS uuids FROM `yl_party_evaluate_self` WHERE  `party_evaluate_id` = 3 LIMIT 1 [ RunTime:0.000525s ]
[2021-07-13T10:25:10+08:00][sql] SELECT GROUP_CONCAT(uuid) AS uuids FROM `yl_party_evaluate_self` WHERE  `party_evaluate_id` = 2 LIMIT 1 [ RunTime:0.000339s ]
[2021-07-13T10:25:10+08:00][sql] CONNECT:[ UseTime:0.000671s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001454s ]
[2021-07-13T10:25:10+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `status` = 1 [ RunTime:0.000687s ]
[2021-07-13T10:25:11+08:00][sql] CONNECT:[ UseTime:0.000605s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001280s ]
[2021-07-13T10:25:11+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.000473s ]
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001048s ]
[2021-07-13T10:25:11+08:00][sql] CONNECT:[ UseTime:0.000618s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001250s ]
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_talk` [ RunTime:0.023023s ]
[2021-07-13T10:25:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_talk` [ RunTime:0.000842s ]
[2021-07-13T10:25:11+08:00][sql] CONNECT:[ UseTime:0.000701s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001117s ]
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_report` [ RunTime:0.001273s ]
[2021-07-13T10:25:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_report` [ RunTime:0.000386s ]
[2021-07-13T10:25:11+08:00][sql] SELECT * FROM `yl_party_report` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000433s ]
[2021-07-13T10:25:11+08:00][sql] CONNECT:[ UseTime:0.000537s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001059s ]
[2021-07-13T10:25:11+08:00][sql] SELECT `id`,theme as name FROM `yl_standing_book` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000589s ]
[2021-07-13T10:25:11+08:00][sql] CONNECT:[ UseTime:0.000528s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000937s ]
[2021-07-13T10:25:11+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.000288s ]
[2021-07-13T10:25:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000935s ]
[2021-07-13T10:25:15+08:00][sql] CONNECT:[ UseTime:0.000693s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000999s ]
[2021-07-13T10:25:15+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `type` <> '党小组'  AND `status` = 1 [ RunTime:0.000602s ]
[2021-07-13T10:25:15+08:00][sql] CONNECT:[ UseTime:0.000732s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_role` [ RunTime:0.001037s ]
[2021-07-13T10:25:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000501s ]
[2021-07-13T10:25:15+08:00][sql] SELECT `id`,`name`,`descs`,`status` FROM `yl_role` WHERE  `id` <> 1 [ RunTime:0.000481s ]
[2021-07-13T10:25:15+08:00][sql] CONNECT:[ UseTime:0.000606s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000896s ]
[2021-07-13T10:25:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_role` `t1` WHERE  `t1`.`role_id` = '5' [ RunTime:0.000756s ]
[2021-07-13T10:25:15+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.000747s ]
[2021-07-13T10:25:16+08:00][sql] CONNECT:[ UseTime:0.000622s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.003160s ]
[2021-07-13T10:25:16+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.003391s ]
[2021-07-13T10:25:16+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.000632s ]
[2021-07-13T10:25:26+08:00][sql] CONNECT:[ UseTime:0.000658s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001171s ]
[2021-07-13T10:25:26+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.000392s ]
[2021-07-13T10:25:26+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.000379s ]
[2021-07-13T10:25:27+08:00][sql] CONNECT:[ UseTime:0.000538s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001117s ]
[2021-07-13T10:25:27+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.000402s ]
[2021-07-13T10:25:27+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.000374s ]
[2021-07-13T10:25:35+08:00][sql] CONNECT:[ UseTime:0.000739s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001157s ]
[2021-07-13T10:25:35+08:00][sql] SELECT `a`.`uuid`,`a`.`name`,`a`.`telephone`,`b`.`role_id` FROM `yl_user` `a` LEFT JOIN `yl_user_role` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`telephone` LIKE '%13757687309%' LIMIT 1 [ RunTime:0.000542s ]
[2021-07-13T10:25:54+08:00][sql] CONNECT:[ UseTime:0.000625s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000986s ]
[2021-07-13T10:25:54+08:00][sql] INSERT INTO `yl_user_card` SET `stbid` = '51af430fe28a733d' , `uuid` = 'c845765990724681b9acbf465bd8329b' , `status` = '有效' , `ctime` = '2021-07-13 10:25:54' [ RunTime:0.002048s ]
[2021-07-13T10:25:56+08:00][sql] CONNECT:[ UseTime:0.000603s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:25:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000846s ]
[2021-07-13T10:25:56+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.000491s ]
[2021-07-13T10:25:56+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.001089s ]
[2021-07-13T10:27:06+08:00][sql] CONNECT:[ UseTime:0.000696s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:27:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000955s ]
[2021-07-13T10:27:06+08:00][sql] UPDATE `yl_user_card`  SET `id` = 1185 , `stbid` = '51af430fe28a733d' , `uuid` = 'c845765990724681b9acbf465bd8329b' , `status` = '有效' , `ctime` = '2021-07-13 10:27:06'  WHERE  `id` = 1185 [ RunTime:0.000541s ]
[2021-07-13T10:27:09+08:00][sql] CONNECT:[ UseTime:0.000627s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:27:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000944s ]
[2021-07-13T10:27:09+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.000601s ]
[2021-07-13T10:27:09+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.000491s ]
[2021-07-13T10:28:18+08:00][sql] CONNECT:[ UseTime:0.000731s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:28:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000954s ]
[2021-07-13T10:28:18+08:00][sql] UPDATE `yl_user_card`  SET `id` = 1185 , `stbid` = '51af430fe28a733d' , `uuid` = 'c845765990724681b9acbf465bd8329b' , `status` = '有效' , `ctime` = '2021-07-13 10:28:18'  WHERE  `id` = 1185 [ RunTime:0.000688s ]
[2021-07-13T10:28:20+08:00][sql] CONNECT:[ UseTime:0.000602s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4
[2021-07-13T10:28:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000882s ]
[2021-07-13T10:28:20+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.000445s ]
[2021-07-13T10:28:20+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.000564s ]