[2021-09-25T09:22:13+08:00][debug] middleware/Authorise: handle | request path = user.UserLogin/login [2021-09-25T09:22:14+08:00][sql] CONNECT:[ UseTime:0.000561s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.009477s ] [2021-09-25T09:22:14+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' and t5.years='2021' ) LIMIT 1 [ RunTime:0.042600s ] [2021-09-25T09:22:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001104s ] [2021-09-25T09:22:14+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.006109s ] [2021-09-25T09:22:14+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 2104976563 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='2' ) [ RunTime:0.000659s ] [2021-09-25T09:22:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001133s ] [2021-09-25T09:22:14+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '4c8f125cd4334b248dceed93ee330685' , `sign_ip` = 125 , `ua` = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.008055s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000604s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001009s ] [2021-09-25T09:22:15+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.003396s ] [2021-09-25T09:22:15+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000703s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000862s ] [2021-09-25T09:22:15+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000388s ] [2021-09-25T09:22:15+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000294s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000675s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.002536s ] [2021-09-25T09:22: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") = 2021 ) [ RunTime:0.003091s ] [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000932s ] [2021-09-25T09:22:15+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 16 GROUP BY `status` [ RunTime:0.008848s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000552s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000931s ] [2021-09-25T09:22: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") = 2021 ) [ RunTime:0.000504s ] [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000619s ] [2021-09-25T09:22:15+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (11,15,24,25) GROUP BY `status` [ RunTime:0.002739s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000537s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001174s ] [2021-09-25T09:22: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") = 2021 ) [ RunTime:0.000522s ] [2021-09-25T09:22: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") = 2021 ) [ RunTime:0.000597s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000904s ] [2021-09-25T09:22: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") = 2021 ) [ RunTime:0.000499s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000527s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000937s ] [2021-09-25T09:22: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") = 2021 ) [ RunTime:0.000666s ] [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000785s ] [2021-09-25T09:22:15+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (12,14,19,20,21,22) GROUP BY `status` [ RunTime:0.001935s ] [2021-09-25T09:22:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration [2021-09-25T09:22:15+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000737s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001307s ] [2021-09-25T09:22: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") = 2021 ) [ RunTime:0.000606s ] [2021-09-25T09:22:16+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail [2021-09-25T09:22:16+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:16+08:00][sql] CONNECT:[ UseTime:0.000656s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000920s ] [2021-09-25T09:22:16+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") = 2021 ) [ RunTime:0.000330s ] [2021-09-25T09:22:16+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") = 2021 ) [ RunTime:0.000292s ] [2021-09-25T09:22:18+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T09:22:18+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:18+08:00][sql] CONNECT:[ UseTime:0.000597s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001086s ] [2021-09-25T09:22:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000745s ] [2021-09-25T09:22:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000482s ] [2021-09-25T09:22:18+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000725s ] [2021-09-25T09:22:18+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T09:22:18+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:18+08:00][sql] CONNECT:[ UseTime:0.000639s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001138s ] [2021-09-25T09:22:18+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.000763s ] [2021-09-25T09:22:18+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:22:18+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:18+08:00][sql] CONNECT:[ UseTime:0.000417s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000841s ] [2021-09-25T09:22:18+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000299s ] [2021-09-25T09:22:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.002005s ] [2021-09-25T09:22:18+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.006423s ] [2021-09-25T09:22:21+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:22:21+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:21+08:00][sql] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001161s ] [2021-09-25T09:22:21+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` WHERE `plan_id` <> 41 [ RunTime:0.000683s ] [2021-09-25T09:22:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000821s ] [2021-09-25T09:22:21+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25') ORDER BY `a`.`ctime` DESC [ RunTime:0.000898s ] [2021-09-25T09:22:22+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:22:22+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:23+08:00][sql] CONNECT:[ UseTime:0.000588s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.001052s ] [2021-09-25T09:22:23+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.004791s ] [2021-09-25T09:22:25+08:00][debug] middleware/Authorise: handle | request path = vote.VoteRule/read [2021-09-25T09:22:25+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:25+08:00][sql] CONNECT:[ UseTime:0.000456s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_vote_rule` [ RunTime:0.003160s ] [2021-09-25T09:22:25+08:00][sql] SELECT `id`,`rule`,`anon` FROM `yl_vote_rule` WHERE `table_name` = 'vote' AND `table_id` = 61 LIMIT 1 [ RunTime:0.003340s ] [2021-09-25T09:22:25+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:22:25+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:22:25+08:00][sql] CONNECT:[ UseTime:0.000410s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:22:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000759s ] [2021-09-25T09:22:25+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000282s ] [2021-09-25T09:23:47+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:23:47+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:47+08:00][sql] CONNECT:[ UseTime:0.000481s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000905s ] [2021-09-25T09:23:47+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000361s ] [2021-09-25T09:23:47+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000540s ] [2021-09-25T09:23:47+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T09:23:47+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:47+08:00][sql] CONNECT:[ UseTime:0.000465s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001001s ] [2021-09-25T09:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000629s ] [2021-09-25T09:23:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000237s ] [2021-09-25T09:23:47+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000324s ] [2021-09-25T09:23:47+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T09:23:47+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:47+08:00][sql] CONNECT:[ UseTime:0.000534s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001071s ] [2021-09-25T09:23:47+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.000380s ] [2021-09-25T09:23:47+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:23:47+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:47+08:00][sql] CONNECT:[ UseTime:0.000569s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000841s ] [2021-09-25T09:23:47+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000254s ] [2021-09-25T09:23:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000515s ] [2021-09-25T09:23:47+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.000383s ] [2021-09-25T09:23:50+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:23:50+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:50+08:00][sql] CONNECT:[ UseTime:0.000621s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000868s ] [2021-09-25T09:23:50+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` WHERE `plan_id` <> 41 [ RunTime:0.000290s ] [2021-09-25T09:23:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000533s ] [2021-09-25T09:23:50+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25') ORDER BY `a`.`ctime` DESC [ RunTime:0.000485s ] [2021-09-25T09:23:52+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:23:52+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:52+08:00][sql] CONNECT:[ UseTime:0.000551s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000774s ] [2021-09-25T09:23:52+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000291s ] [2021-09-25T09:23:55+08:00][debug] middleware/Authorise: handle | request path = vote.VoteRule/read [2021-09-25T09:23:55+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:55+08:00][sql] CONNECT:[ UseTime:0.000564s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_vote_rule` [ RunTime:0.000974s ] [2021-09-25T09:23:55+08:00][sql] SELECT `id`,`rule`,`anon` FROM `yl_vote_rule` WHERE `table_name` = 'consult' AND `table_id` = 61 LIMIT 1 [ RunTime:0.000469s ] [2021-09-25T09:23:55+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:23:55+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:55+08:00][sql] CONNECT:[ UseTime:0.000551s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000802s ] [2021-09-25T09:23:55+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000294s ] [2021-09-25T09:23:57+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:23:57+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:57+08:00][sql] CONNECT:[ UseTime:0.000521s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.001789s ] [2021-09-25T09:23:57+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000318s ] [2021-09-25T09:23:57+08:00][debug] middleware/Authorise: handle | request path = vote.VoteRule/read [2021-09-25T09:23:57+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:23:57+08:00][sql] CONNECT:[ UseTime:0.000437s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:23:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_vote_rule` [ RunTime:0.000899s ] [2021-09-25T09:23:57+08:00][sql] SELECT `id`,`rule`,`anon` FROM `yl_vote_rule` WHERE `table_name` = 'vote' AND `table_id` = 61 LIMIT 1 [ RunTime:0.000324s ] [2021-09-25T09:24:49+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:24:49+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:49+08:00][sql] CONNECT:[ UseTime:0.000441s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000835s ] [2021-09-25T09:24:49+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000633s ] [2021-09-25T09:24:49+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000551s ] [2021-09-25T09:24:50+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T09:24:50+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:50+08:00][sql] CONNECT:[ UseTime:0.000646s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001187s ] [2021-09-25T09:24:50+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.000498s ] [2021-09-25T09:24:50+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T09:24:50+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:50+08:00][sql] CONNECT:[ UseTime:0.000643s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001134s ] [2021-09-25T09:24:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000772s ] [2021-09-25T09:24:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000382s ] [2021-09-25T09:24:50+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000346s ] [2021-09-25T09:24:50+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:24:50+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:50+08:00][sql] CONNECT:[ UseTime:0.000494s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000866s ] [2021-09-25T09:24:50+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000368s ] [2021-09-25T09:24:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000877s ] [2021-09-25T09:24:50+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.000530s ] [2021-09-25T09:24:52+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:24:52+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:52+08:00][sql] CONNECT:[ UseTime:0.000494s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000896s ] [2021-09-25T09:24:52+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` WHERE `plan_id` <> 41 [ RunTime:0.000250s ] [2021-09-25T09:24:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000747s ] [2021-09-25T09:24:52+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25') ORDER BY `a`.`ctime` DESC [ RunTime:0.000421s ] [2021-09-25T09:24:53+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:24:53+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:53+08:00][sql] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000944s ] [2021-09-25T09:24:53+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000362s ] [2021-09-25T09:24:56+08:00][debug] middleware/Authorise: handle | request path = vote.VoteRule/read [2021-09-25T09:24:56+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:56+08:00][sql] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_vote_rule` [ RunTime:0.000807s ] [2021-09-25T09:24:56+08:00][sql] SELECT `id`,`rule`,`anon` FROM `yl_vote_rule` WHERE `table_name` = 'vote' AND `table_id` = 61 LIMIT 1 [ RunTime:0.000279s ] [2021-09-25T09:24:56+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:24:56+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:24:56+08:00][sql] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:24:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000767s ] [2021-09-25T09:24:56+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000473s ] [2021-09-25T09:29:43+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:29:43+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:29:43+08:00][sql] CONNECT:[ UseTime:0.000656s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:29:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000884s ] [2021-09-25T09:29:43+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000332s ] [2021-09-25T09:29:43+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000524s ] [2021-09-25T09:29:43+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T09:29:43+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:29:43+08:00][sql] CONNECT:[ UseTime:0.000619s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:29:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001168s ] [2021-09-25T09:29:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001087s ] [2021-09-25T09:29:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000770s ] [2021-09-25T09:29:43+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000352s ] [2021-09-25T09:29:43+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T09:29:43+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:29:43+08:00][sql] CONNECT:[ UseTime:0.000488s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:29:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000909s ] [2021-09-25T09:29:43+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.000378s ] [2021-09-25T09:29:43+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:29:43+08:00][debug] ---$rediskey---pc:jwt:HbpxHVGCH7ldYKciNGVDWjfY1nuIoTDbo3BjeG57Bdk [2021-09-25T09:29:43+08:00][sql] CONNECT:[ UseTime:0.000608s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:29:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000936s ] [2021-09-25T09:29:43+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000382s ] [2021-09-25T09:29:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000784s ] [2021-09-25T09:29:43+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.000433s ] [2021-09-25T09:58:44+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:58:48+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:58:48+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T09:58:48+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:59:00+08:00][debug] middleware/Authorise: handle | request path = user.UserLogin/login [2021-09-25T09:59:00+08:00][sql] CONNECT:[ UseTime:0.000618s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001524s ] [2021-09-25T09:59:00+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' and t5.years='2021' ) LIMIT 1 [ RunTime:0.001508s ] [2021-09-25T09:59:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001028s ] [2021-09-25T09:59:00+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000350s ] [2021-09-25T09:59:00+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 2104976563 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='2' ) [ RunTime:0.000422s ] [2021-09-25T09:59:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000704s ] [2021-09-25T09:59:00+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '4c8f125cd4334b248dceed93ee330685' , `sign_ip` = 125 , `ua` = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000346s ] [2021-09-25T09:59:01+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:59:01+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:01+08:00][sql] CONNECT:[ UseTime:0.000616s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000984s ] [2021-09-25T09:59:01+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000361s ] [2021-09-25T09:59:01+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000324s ] [2021-09-25T09:59:01+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T09:59:01+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:01+08:00][sql] CONNECT:[ UseTime:0.000481s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001236s ] [2021-09-25T09:59:01+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000399s ] [2021-09-25T09:59:01+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000341s ] [2021-09-25T09:59:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration [2021-09-25T09:59:01+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:01+08:00][sql] CONNECT:[ UseTime:0.000548s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001046s ] [2021-09-25T09:59:01+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") = 2021 ) [ RunTime:0.000487s ] [2021-09-25T09:59:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople [2021-09-25T09:59:01+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:01+08:00][sql] CONNECT:[ UseTime:0.000494s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000900s ] [2021-09-25T09:59:01+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") = 2021 ) [ RunTime:0.000494s ] [2021-09-25T09:59:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000930s ] [2021-09-25T09:59:01+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (11,15,24,25) GROUP BY `status` [ RunTime:0.000792s ] [2021-09-25T09:59:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration [2021-09-25T09:59:02+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:02+08:00][sql] CONNECT:[ UseTime:0.000599s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001026s ] [2021-09-25T09:59:02+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") = 2021 ) [ RunTime:0.000557s ] [2021-09-25T09:59:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople [2021-09-25T09:59:02+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:02+08:00][sql] CONNECT:[ UseTime:0.000490s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001352s ] [2021-09-25T09:59:02+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") = 2021 ) [ RunTime:0.000657s ] [2021-09-25T09:59:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000652s ] [2021-09-25T09:59:02+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 16 GROUP BY `status` [ RunTime:0.000504s ] [2021-09-25T09:59:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail [2021-09-25T09:59:02+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:02+08:00][sql] CONNECT:[ UseTime:0.000607s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001002s ] [2021-09-25T09:59:02+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") = 2021 ) [ RunTime:0.000465s ] [2021-09-25T09:59:02+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") = 2021 ) [ RunTime:0.000402s ] [2021-09-25T09:59:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail [2021-09-25T09:59:02+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:02+08:00][sql] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001094s ] [2021-09-25T09:59:02+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") = 2021 ) [ RunTime:0.000467s ] [2021-09-25T09:59:02+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") = 2021 ) [ RunTime:0.000382s ] [2021-09-25T09:59:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople [2021-09-25T09:59:02+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:02+08:00][sql] CONNECT:[ UseTime:0.000538s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001210s ] [2021-09-25T09:59:02+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") = 2021 ) [ RunTime:0.000577s ] [2021-09-25T09:59:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000683s ] [2021-09-25T09:59:02+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (12,14,19,20,21,22) GROUP BY `status` [ RunTime:0.000629s ] [2021-09-25T09:59:06+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T09:59:06+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:06+08:00][sql] CONNECT:[ UseTime:0.000460s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000979s ] [2021-09-25T09:59:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000627s ] [2021-09-25T09:59:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000252s ] [2021-09-25T09:59:06+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000311s ] [2021-09-25T09:59:06+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T09:59:06+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:06+08:00][sql] CONNECT:[ UseTime:0.000549s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000965s ] [2021-09-25T09:59:06+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.000588s ] [2021-09-25T09:59:06+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:59:06+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:06+08:00][sql] CONNECT:[ UseTime:0.000480s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000998s ] [2021-09-25T09:59:06+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000275s ] [2021-09-25T09:59:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000926s ] [2021-09-25T09:59:06+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.000511s ] [2021-09-25T09:59:08+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T09:59:08+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:08+08:00][sql] CONNECT:[ UseTime:0.000493s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000949s ] [2021-09-25T09:59:08+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` WHERE `plan_id` <> 41 [ RunTime:0.000428s ] [2021-09-25T09:59:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000585s ] [2021-09-25T09:59:08+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25') ORDER BY `a`.`ctime` DESC [ RunTime:0.000759s ] [2021-09-25T09:59:09+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:59:09+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:09+08:00][sql] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.001003s ] [2021-09-25T09:59:09+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000456s ] [2021-09-25T09:59:12+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBookVote/read [2021-09-25T09:59:12+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:12+08:00][sql] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000824s ] [2021-09-25T09:59:12+08:00][sql] SELECT `id`,`standing_book_id`,`vote_id`,`consult_id`,`is_open` FROM `yl_standing_book_vote` WHERE ( standing_book_id='61' ) LIMIT 1 [ RunTime:0.000285s ] [2021-09-25T09:59:12+08:00][debug] middleware/Authorise: handle | request path = vote.VoteRule/read [2021-09-25T09:59:12+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T09:59:12+08:00][sql] CONNECT:[ UseTime:0.000463s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T09:59:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_vote_rule` [ RunTime:0.001155s ] [2021-09-25T09:59:12+08:00][sql] SELECT `id`,`rule`,`anon` FROM `yl_vote_rule` WHERE `table_name` = 'vote' AND `table_id` = 61 LIMIT 1 [ RunTime:0.001835s ] [2021-09-25T09:59:17+08:00][debug] middleware/Authorise: handle | request path = Upload/pic [2021-09-25T09:59:17+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:02:51+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T10:02:51+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:02:51+08:00][sql] CONNECT:[ UseTime:0.000604s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:02:51+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000812s ] [2021-09-25T10:02:51+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000437s ] [2021-09-25T10:02:51+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000415s ] [2021-09-25T10:02:52+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T10:02:52+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:02:52+08:00][sql] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:02:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001071s ] [2021-09-25T10:02:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000701s ] [2021-09-25T10:02:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000333s ] [2021-09-25T10:02:52+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000413s ] [2021-09-25T10:02:52+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T10:02:52+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:02:52+08:00][sql] CONNECT:[ UseTime:0.000479s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:02:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001344s ] [2021-09-25T10:02:52+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000264s ] [2021-09-25T10:02:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000625s ] [2021-09-25T10:02:52+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.001827s ] [2021-09-25T10:02:52+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T10:02:52+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:02:52+08:00][sql] CONNECT:[ UseTime:0.000466s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:02:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000987s ] [2021-09-25T10:02:52+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.000414s ] [2021-09-25T10:20:17+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T10:20:17+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:20:17+08:00][sql] CONNECT:[ UseTime:0.000484s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:20:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001041s ] [2021-09-25T10:20:17+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000369s ] [2021-09-25T10:20:17+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000472s ] [2021-09-25T10:20:17+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T10:20:17+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:20:17+08:00][sql] CONNECT:[ UseTime:0.000823s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:20:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001167s ] [2021-09-25T10:20:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000927s ] [2021-09-25T10:20:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000421s ] [2021-09-25T10:20:17+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000405s ] [2021-09-25T10:20:17+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T10:20:17+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:20:17+08:00][sql] CONNECT:[ UseTime:0.000490s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:20:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001162s ] [2021-09-25T10:20:17+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.000485s ] [2021-09-25T10:20:17+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T10:20:17+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:20:18+08:00][sql] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:20:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001076s ] [2021-09-25T10:20:18+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000386s ] [2021-09-25T10:20:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000858s ] [2021-09-25T10:20:18+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.000591s ] [2021-09-25T10:25:50+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-09-25T10:25:50+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:25:50+08:00][sql] CONNECT:[ UseTime:0.000614s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:25:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001390s ] [2021-09-25T10:25:50+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000350s ] [2021-09-25T10:25:50+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000346s ] [2021-09-25T10:25:50+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/index [2021-09-25T10:25:50+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:25:50+08:00][sql] CONNECT:[ UseTime:0.000574s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:25:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001074s ] [2021-09-25T10:25:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000837s ] [2021-09-25T10:25:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000416s ] [2021-09-25T10:25:50+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_standing_book` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000370s ] [2021-09-25T10:25:50+08:00][debug] middleware/Authorise: handle | request path = party.PartyReport/persons [2021-09-25T10:25:50+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:25:50+08:00][sql] CONNECT:[ UseTime:0.000602s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:25:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001008s ] [2021-09-25T10:25:50+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.000412s ] [2021-09-25T10:25:51+08:00][debug] middleware/Authorise: handle | request path = standing_book.StandingBook/plans [2021-09-25T10:25:51+08:00][debug] ---$rediskey---pc:jwt:YjUWpgVqdgwmPpyq4U51X0Qy-xC0DUw7kXhWwKxMIps [2021-09-25T10:25:51+08:00][sql] CONNECT:[ UseTime:0.000664s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-09-25T10:25:51+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000940s ] [2021-09-25T10:25:51+08:00][sql] SELECT `plan_id` FROM `yl_standing_book` [ RunTime:0.000252s ] [2021-09-25T10:25:51+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.000829s ] [2021-09-25T10:25:51+08:00][sql] SELECT `a`.`id`,`a`.`icon`,a.theme as name,a.plan_type as type,`a`.`agenda`,`a`.`address`,`a`.`scope`,`a`.`plan_start_time`,`a`.`organ_id`,`b`.`organ_name` FROM `yl_plan` `a` INNER JOIN `yl_party_organ` `b` ON `a`.`organ_id`=`b`.`id` WHERE `a`.`id` NOT IN ('8','11','12','9','13','10','14','15','16','17','18','19','20','24','25','41') ORDER BY `a`.`ctime` DESC [ RunTime:0.000593s ] [2021-09-25T13:31:14+08:00][debug] middleware/Authorise: handle | request path = Nmap/folder [2021-09-25T13:31:14+08:00][debug] middleware/Authorise: handle | request path = evox/about