[2022-03-07T09:09:05+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index
[2022-03-07T09:09:05+08:00][debug] middleware/Authorise: handle | request path = task.TaskReceive/dealed
[2022-03-07T09:09:05+08:00][debug] middleware/Authorise: handle | request path = activity.Activity/forms
[2022-03-07T09:09:08+08:00][debug] middleware/Authorise: handle | request path = user.UserLogin/login
[2022-03-07T09:09:08+08:00][sql] CONNECT:[ UseTime:0.000606s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.036721s ]
[2022-03-07T09:09:08+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`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  ( t1.account='18999999999' ) LIMIT 1 [ RunTime:0.021234s ]
[2022-03-07T09:09:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001023s ]
[2022-03-07T09:09:08+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.005677s ]
[2022-03-07T09:09:08+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 1942073694 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id='2' ) [ RunTime:0.000593s ]
[2022-03-07T09:09:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001715s ]
[2022-03-07T09:09:08+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '4c8f125cd4334b248dceed93ee330685' , `sign_ip` = 115 , `ua` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36 Edg/98.0.1108.62' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.007766s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000497s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000999s ]
[2022-03-07T09:09:10+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.005414s ]
[2022-03-07T09:09:10+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000519s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000588s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001188s ]
[2022-03-07T09:09:10+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000410s ]
[2022-03-07T09:09:10+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000449s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000617s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.002539s ]
[2022-03-07T09:09:10+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` IN ('党员大会','支委会','党小组会','党课')  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.006679s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000483s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000940s ]
[2022-03-07T09:09:10+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000499s ]
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000783s ]
[2022-03-07T09:09:10+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000304s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000654s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000986s ]
[2022-03-07T09:09:10+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000647s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000645s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001138s ]
[2022-03-07T09:09:10+08:00][sql] SELECT date_format(start_time, "%c") month, theme FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000510s ]
[2022-03-07T09:09:10+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000391s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000623s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001485s ]
[2022-03-07T09:09:10+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党课'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000758s ]
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000823s ]
[2022-03-07T09:09:10+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000464s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001290s ]
[2022-03-07T09:09:10+08:00][sql] SELECT date_format(start_time, "%c") month, theme FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000375s ]
[2022-03-07T09:09:10+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000276s ]
[2022-03-07T09:09:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople
[2022-03-07T09:09:10+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:10+08:00][sql] CONNECT:[ UseTime:0.000484s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000896s ]
[2022-03-07T09:09:10+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党小组会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000494s ]
[2022-03-07T09:09:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000645s ]
[2022-03-07T09:09:10+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000285s ]
[2022-03-07T09:09:14+08:00][debug] middleware/Authorise: handle | request path = task.TaskReceive/dealing
[2022-03-07T09:09:14+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:14+08:00][sql] CONNECT:[ UseTime:0.000570s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_receive` [ RunTime:0.001018s ]
[2022-03-07T09:09:14+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` >= '2022-03-07 09:09:14'  AND `tr`.`status` = '待处理'  AND `tr`.`handler_uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.003434s ]
[2022-03-07T09:09:14+08:00][debug] middleware/Authorise: handle | request path = activity.Activity/forms
[2022-03-07T09:09:14+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:14+08:00][sql] CONNECT:[ UseTime:0.000444s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.002350s ]
[2022-03-07T09:09:14+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.002935s ]
[2022-03-07T09:09:15+08:00][debug] middleware/Authorise: handle | request path = task.TaskReceive/deadline
[2022-03-07T09:09:15+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:15+08:00][sql] CONNECT:[ UseTime:0.000552s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_receive` [ RunTime:0.000896s ]
[2022-03-07T09:09:15+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` < '2022-03-07 09:09:15'  AND `tr`.`status` = '待处理'  AND (  tr.receiver_uuid="4c8f125cd4334b248dceed93ee330685" OR t.sender_uuid="4c8f125cd4334b248dceed93ee330685" ) [ RunTime:0.004889s ]
[2022-03-07T09:09:15+08:00][sql] SELECT `t`.*,`tr`.`id`,`tr`.`task_id`,`tr`.`receiver_uuid`,`tr`.`status`,`tr`.`finish_time`,`tr`.`handler_uuid` FROM `yl_task_receive` `tr` INNER JOIN `yl_task` `t` ON `t`.`id`=`tr`.`task_id` WHERE  `t`.`is_back` = 'n'  AND `t`.`deadline` < '2022-03-07 09:09:15'  AND `tr`.`status` = '待处理'  AND (  tr.receiver_uuid="4c8f125cd4334b248dceed93ee330685" OR t.sender_uuid="4c8f125cd4334b248dceed93ee330685" ) LIMIT 0,10 [ RunTime:0.000939s ]
[2022-03-07T09:09:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001005s ]
[2022-03-07T09:09:15+08:00][debug] middleware/Authorise: handle | request path = activity.Activity/forms
[2022-03-07T09:09:15+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:15+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.000863s ]
[2022-03-07T09:09:15+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000289s ]
[2022-03-07T09:09:16+08:00][debug] middleware/Authorise: handle | request path = party.PartyPosition/index
[2022-03-07T09:09:16+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:16+08:00][sql] CONNECT:[ UseTime:0.000445s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position` [ RunTime:0.002226s ]
[2022-03-07T09:09:16+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.003687s ]
[2022-03-07T09:09:16+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_party_position` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000449s ]
[2022-03-07T09:09:16+08:00][debug] middleware/Authorise: handle | request path = user.UserParty/organs
[2022-03-07T09:09:16+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:16+08:00][sql] CONNECT:[ UseTime:0.000457s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001207s ]
[2022-03-07T09:09:16+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `type` = '党支部'  AND `status` = '1' [ RunTime:0.000488s ]
[2022-03-07T09:09:20+08:00][debug] middleware/Authorise: handle | request path = party.PartyDues/users
[2022-03-07T09:09:20+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:20+08:00][sql] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000942s ]
[2022-03-07T09:09:20+08:00][sql] SELECT t1.uuid as id,`t1`.`photo`,`t1`.`type`,`t2`.`name` FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` WHERE  `t2`.`name` <> '' ORDER BY `t1`.`ctime` DESC [ RunTime:0.000678s ]
[2022-03-07T09:09:20+08:00][debug] middleware/Authorise: handle | request path = party.PartyRewards/index
[2022-03-07T09:09:20+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:20+08:00][sql] CONNECT:[ UseTime:0.000679s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_rewards` [ RunTime:0.001013s ]
[2022-03-07T09:09:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_rewards` [ RunTime:0.002946s ]
[2022-03-07T09:09:20+08:00][sql] SELECT * FROM `yl_party_rewards` `a` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000318s ]
[2022-03-07T09:09:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000712s ]
[2022-03-07T09:09:20+08:00][debug] middleware/Authorise: handle | request path = user.UserParty/organs
[2022-03-07T09:09:20+08:00][debug] ---$rediskey---pc:jwt:G4EDAOxJkSj7Bbkid523Wkx7mJjI4F8R01hModSZiWA
[2022-03-07T09:09:20+08:00][sql] CONNECT:[ UseTime:0.000581s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T09:09:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000983s ]
[2022-03-07T09:09:20+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `type` = '党支部'  AND `status` = '1' [ RunTime:0.000345s ]
[2022-03-07T10:03:06+08:00][debug] middleware/Authorise: handle | request path = AppEdition/index
[2022-03-07T10:03:11+08:00][debug] middleware/Authorise: handle | request path = region.Region/index
[2022-03-07T10:03:13+08:00][debug] middleware/Authorise: handle | request path = user.UserLogin/login
[2022-03-07T10:03:13+08:00][sql] CONNECT:[ UseTime:0.000537s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.006025s ]
[2022-03-07T10:03:13+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`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  ( t1.account='18999999999' ) LIMIT 1 [ RunTime:0.019383s ]
[2022-03-07T10:03:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001169s ]
[2022-03-07T10:03:13+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.006669s ]
[2022-03-07T10:03:13+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 1942073694 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id='2' ) [ RunTime:0.000525s ]
[2022-03-07T10:03:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001193s ]
[2022-03-07T10:03:13+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '4c8f125cd4334b248dceed93ee330685' , `sign_ip` = 115 , `ua` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36 Edg/98.0.1108.62' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.005535s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001410s ]
[2022-03-07T10:03:15+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.003272s ]
[2022-03-07T10:03:15+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000462s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000409s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000852s ]
[2022-03-07T10:03:15+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000322s ]
[2022-03-07T10:03:15+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000385s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.002695s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.002507s ]
[2022-03-07T10:03:15+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党小组会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.004367s ]
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001029s ]
[2022-03-07T10:03:15+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000350s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000439s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000911s ]
[2022-03-07T10:03:15+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.002034s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000381s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000854s ]
[2022-03-07T10:03:15+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000462s ]
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000776s ]
[2022-03-07T10:03:15+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000472s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000867s ]
[2022-03-07T10:03:15+08:00][sql] SELECT date_format(start_time, "%c") month, theme FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000438s ]
[2022-03-07T10:03:15+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000452s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000409s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000969s ]
[2022-03-07T10:03:15+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党课'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000544s ]
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000670s ]
[2022-03-07T10:03:15+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000231s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000520s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001246s ]
[2022-03-07T10:03:15+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` IN ('党员大会','支委会','党小组会','党课')  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000573s ]
[2022-03-07T10:03:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail
[2022-03-07T10:03:15+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:15+08:00][sql] CONNECT:[ UseTime:0.000462s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000921s ]
[2022-03-07T10:03:15+08:00][sql] SELECT date_format(start_time, "%c") month, theme FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000334s ]
[2022-03-07T10:03:15+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000240s ]
[2022-03-07T10:03:20+08:00][debug] middleware/Authorise: handle | request path = Content/index
[2022-03-07T10:03:20+08:00][debug] ---$rediskey---pc:jwt:CdsgkIffau0q5TXj4MRzyGaWTWEzeFDpKvomlxwIOG4
[2022-03-07T10:03:20+08:00][sql] CONNECT:[ UseTime:0.000591s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-03-07T10:03:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.011797s ]
[2022-03-07T10:03:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '27' [ RunTime:0.011193s ]
[2022-03-07T10:03:20+08:00][sql] SELECT * FROM `yl_content` WHERE  `node_id` = '27' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002907s ]
[2022-03-07T10:03:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000992s ]
[2022-03-07T10:03:20+08:00][sql] SELECT `peopletype`,telephone phone,`name`,`pics` FROM `yl_user` WHERE  ( uuid='' ) LIMIT 1 [ RunTime:0.000481s ]