[2021-09-02T02:22:30+08:00][debug] middleware/Authorise: handle | request path = php/explicit_not_exist_path
[2021-09-02T02:22:30+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/
[2021-09-02T02:22:30+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/explicit_not_exist_path
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/4e5e5d7364f443e28fbf0d3ae744a59a
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/?c=4e5e5d7364f443e28fbf0d3ae744a59a
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/explicit_not_exist_path
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/4e5e5d7364f443e28fbf0d3ae744a59a
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/?c=4e5e5d7364f443e28fbf0d3ae744a59a
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = wcm/
[2021-09-02T02:22:31+08:00][debug] middleware/Authorise: handle | request path = wcm/explicit_not_exist_path
[2021-09-02T02:22:32+08:00][debug] middleware/Authorise: handle | request path = wcm/4e5e5d7364f443e28fbf0d3ae744a59a
[2021-09-02T02:22:32+08:00][debug] middleware/Authorise: handle | request path = wcm/?c=4e5e5d7364f443e28fbf0d3ae744a59a
[2021-09-02T06:46:41+08:00][debug] middleware/Authorise: handle | request path = Nmap/folder
[2021-09-02T06:46:42+08:00][debug] middleware/Authorise: handle | request path = evox/about
[2021-09-02T12:11:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login
[2021-09-02T12:11:30+08:00][sql] CONNECT:[ UseTime:0.000665s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:11:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.004159s ]
[2021-09-02T12:11:30+08:00][sql] SELECT `t3`.`organ_name`,`t2`.`organ_id`,`t1`.`uuid` FROM `yl_user_card` `t1` LEFT JOIN `yl_user_party` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_organ` `t3` ON `t2`.`organ_id`=`t3`.`id` WHERE  ( stbid='d950fd023385e3a2' ) LIMIT 1 [ RunTime:0.015560s ]
[2021-09-02T12:11:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index
[2021-09-02T12:11:31+08:00][sql] CONNECT:[ UseTime:0.000675s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.002701s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE  `organ_id` = 2  AND `end_time` <= '2021-09-02 12:11:31'  AND `status` = '已审核' [ RunTime:0.003137s ]
[2021-09-02T12:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000849s ]
[2021-09-02T12:11:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' [ RunTime:0.003190s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime`,`organ_type` FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' ORDER BY field(organ_type,'上级党委或党工委','党委','党总支','党支部','其他'),`ctime` DESC [ RunTime:0.000575s ]
[2021-09-02T12:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001407s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE  `id` = 18 LIMIT 1 [ RunTime:0.003236s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000620s ]
[2021-09-02T12:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001046s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 17 LIMIT 1 [ RunTime:0.003012s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 16 LIMIT 1 [ RunTime:0.000810s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 15 LIMIT 1 [ RunTime:0.000301s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 14 LIMIT 1 [ RunTime:0.000271s ]
[2021-09-02T12:11:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update
[2021-09-02T12:11:31+08:00][sql] CONNECT:[ UseTime:0.000567s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:11:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.004299s ]
[2021-09-02T12:11:31+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE  ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003390s ]
[2021-09-02T12:13:09+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login
[2021-09-02T12:13:09+08:00][sql] CONNECT:[ UseTime:0.000579s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:13:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000916s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `t3`.`organ_name`,`t2`.`organ_id`,`t1`.`uuid` FROM `yl_user_card` `t1` LEFT JOIN `yl_user_party` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_organ` `t3` ON `t2`.`organ_id`=`t3`.`id` WHERE  ( stbid='d950fd023385e3a2' ) LIMIT 1 [ RunTime:0.000661s ]
[2021-09-02T12:13:09+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index
[2021-09-02T12:13:09+08:00][sql] CONNECT:[ UseTime:0.000611s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:13:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001033s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE  `organ_id` = 2  AND `end_time` <= '2021-09-02 12:13:09'  AND `status` = '已审核' [ RunTime:0.000501s ]
[2021-09-02T12:13:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000768s ]
[2021-09-02T12:13:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' [ RunTime:0.000543s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime`,`organ_type` FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' ORDER BY field(organ_type,'上级党委或党工委','党委','党总支','党支部','其他'),`ctime` DESC [ RunTime:0.000421s ]
[2021-09-02T12:13:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001182s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE  `id` = 18 LIMIT 1 [ RunTime:0.000325s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000548s ]
[2021-09-02T12:13:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001230s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 17 LIMIT 1 [ RunTime:0.000295s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 16 LIMIT 1 [ RunTime:0.000333s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 15 LIMIT 1 [ RunTime:0.000259s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 14 LIMIT 1 [ RunTime:0.000240s ]
[2021-09-02T12:13:09+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update
[2021-09-02T12:13:09+08:00][sql] CONNECT:[ UseTime:0.000682s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:13:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.001424s ]
[2021-09-02T12:13:09+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE  ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
[2021-09-02T12:13:28+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2021-09-02T12:13:28+08:00][sql] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:13:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001291s ]
[2021-09-02T12:13:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000527s ]
[2021-09-02T12:13:28+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000486s ]
[2021-09-02T12:15:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login
[2021-09-02T12:15:59+08:00][sql] CONNECT:[ UseTime:0.000624s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:15:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001074s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `t3`.`organ_name`,`t2`.`organ_id`,`t1`.`uuid` FROM `yl_user_card` `t1` LEFT JOIN `yl_user_party` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_organ` `t3` ON `t2`.`organ_id`=`t3`.`id` WHERE  ( stbid='3a95e60211d5b78d' ) LIMIT 1 [ RunTime:0.000966s ]
[2021-09-02T12:15:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index
[2021-09-02T12:15:59+08:00][sql] CONNECT:[ UseTime:0.000717s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:15:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001144s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE  `organ_id` = 2  AND `end_time` <= '2021-09-02 12:15:59'  AND `status` = '已审核' [ RunTime:0.000705s ]
[2021-09-02T12:15:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001145s ]
[2021-09-02T12:15:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' [ RunTime:0.000311s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime`,`organ_type` FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' ORDER BY field(organ_type,'上级党委或党工委','党委','党总支','党支部','其他'),`ctime` DESC [ RunTime:0.000344s ]
[2021-09-02T12:15:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001030s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE  `id` = 18 LIMIT 1 [ RunTime:0.000253s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000446s ]
[2021-09-02T12:15:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001193s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 17 LIMIT 1 [ RunTime:0.000293s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 16 LIMIT 1 [ RunTime:0.000242s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 15 LIMIT 1 [ RunTime:0.000324s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 14 LIMIT 1 [ RunTime:0.000354s ]
[2021-09-02T12:15:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update
[2021-09-02T12:15:59+08:00][sql] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:15:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.001006s ]
[2021-09-02T12:15:59+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE  ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
[2021-09-02T12:16:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2021-09-02T12:16:01+08:00][sql] CONNECT:[ UseTime:0.001016s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T12:16:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.002325s ]
[2021-09-02T12:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.001017s ]
[2021-09-02T12:16:01+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000592s ]
[2021-09-02T20:37:31+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:31+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:31+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:31+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:31+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:31+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:31+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in
[2021-09-02T20:37:32+08:00][sql] CONNECT:[ UseTime:0.000539s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.008393s ]
[2021-09-02T20:37:32+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='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.026922s ]
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001114s ]
[2021-09-02T20:37:32+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.006817s ]
[2021-09-02T20:37:32+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 605173632 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id='31' ) [ RunTime:0.000830s ]
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001523s ]
[2021-09-02T20:37:32+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 36 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.008599s ]
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in
[2021-09-02T20:37:32+08:00][sql] CONNECT:[ UseTime:0.000533s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000981s ]
[2021-09-02T20:37:32+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='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000918s ]
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000947s ]
[2021-09-02T20:37:32+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000324s ]
[2021-09-02T20:37:32+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 605173632 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id='31' ) [ RunTime:0.000567s ]
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000765s ]
[2021-09-02T20:37:32+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 36 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000610s ]
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in
[2021-09-02T20:37:32+08:00][sql] CONNECT:[ UseTime:0.000571s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000888s ]
[2021-09-02T20:37:32+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='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000598s ]
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001008s ]
[2021-09-02T20:37:32+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000384s ]
[2021-09-02T20:37:32+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 605173632 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id='31' ) [ RunTime:0.000580s ]
[2021-09-02T20:37:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000718s ]
[2021-09-02T20:37:32+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 36 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000474s ]
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:32+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:33+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:33+08:00][debug] middleware/Authorise: handle | login verify failed | login info = 
[2021-09-02T20:37:40+08:00][debug] middleware/Authorise: handle | request path = api.app.Sign/in
[2021-09-02T20:37:40+08:00][sql] CONNECT:[ UseTime:0.000575s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:37:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.000892s ]
[2021-09-02T20:37:40+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='18357747058' and t5.years='2021' ) LIMIT 1 [ RunTime:0.000576s ]
[2021-09-02T20:37:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.000986s ]
[2021-09-02T20:37:40+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' [ RunTime:0.000390s ]
[2021-09-02T20:37:40+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 605173632 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id='31' ) [ RunTime:0.000567s ]
[2021-09-02T20:37:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000883s ]
[2021-09-02T20:37:40+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '6dd1c92c6e32475fa090e704941cf7d1' , `sign_ip` = 36 , `ua` = 'okhttp/3.11.0' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000450s ]
[2021-09-02T20:37:42+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops
[2021-09-02T20:37:42+08:00][debug] ---$rediskey---app:jwt:mq9sehlqj8PoEj31i7RpU0H6u_U2Pjga_rE_LosqEi4
[2021-09-02T20:37:42+08:00][sql] CONNECT:[ UseTime:0.000534s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.004570s ]
[2021-09-02T20:37:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `top_status` = 'y'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.007568s ]
[2021-09-02T20:37:42+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE  `top_status` = 'y'  AND `status` = '上线'  AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000961s ]
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000955s ]
[2021-09-02T20:37:42+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE  `c_id` IN (37,36)  AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.010924s ]
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001105s ]
[2021-09-02T20:37:42+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE  `c_id` IN (37,36)  AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000819s ]
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.001090s ]
[2021-09-02T20:37:42+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE  `content_id` IN (37,36) GROUP BY `content_id` [ RunTime:0.003162s ]
[2021-09-02T20:37:42+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun
[2021-09-02T20:37:42+08:00][debug] ---$rediskey---app:jwt:mq9sehlqj8PoEj31i7RpU0H6u_U2Pjga_rE_LosqEi4
[2021-09-02T20:37:42+08:00][sql] CONNECT:[ UseTime:0.000615s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001058s ]
[2021-09-02T20:37:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000487s ]
[2021-09-02T20:37:42+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000562s ]
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000622s ]
[2021-09-02T20:37:42+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE  `c_id` IN (57,62,60)  AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000771s ]
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000724s ]
[2021-09-02T20:37:42+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE  `c_id` IN (57,62,60)  AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000930s ]
[2021-09-02T20:37:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000731s ]
[2021-09-02T20:37:42+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE  `content_id` IN (57,62,60) GROUP BY `content_id` [ RunTime:0.000428s ]
[2021-09-02T20:37:45+08:00][debug] middleware/Authorise: handle | request path = api.app.Meeting/index
[2021-09-02T20:37:45+08:00][debug] ---$rediskey---app:jwt:mq9sehlqj8PoEj31i7RpU0H6u_U2Pjga_rE_LosqEi4
[2021-09-02T20:37:45+08:00][sql] CONNECT:[ UseTime:0.000884s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:37:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001087s ]
[2021-09-02T20:37:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.003510s ]
[2021-09-02T20:37:45+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000542s ]
[2021-09-02T20:38:03+08:00][debug] middleware/Authorise: handle | request path = api.app.Meeting/index
[2021-09-02T20:38:03+08:00][debug] ---$rediskey---app:jwt:mq9sehlqj8PoEj31i7RpU0H6u_U2Pjga_rE_LosqEi4
[2021-09-02T20:38:03+08:00][sql] CONNECT:[ UseTime:0.000507s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:38:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001162s ]
[2021-09-02T20:38:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000476s ]
[2021-09-02T20:38:03+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000359s ]
[2021-09-02T20:38:19+08:00][debug] middleware/Authorise: handle | request path = api.app.Meeting/index
[2021-09-02T20:38:19+08:00][debug] ---$rediskey---app:jwt:mq9sehlqj8PoEj31i7RpU0H6u_U2Pjga_rE_LosqEi4
[2021-09-02T20:38:19+08:00][sql] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:38:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000940s ]
[2021-09-02T20:38:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000315s ]
[2021-09-02T20:38:19+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000266s ]
[2021-09-02T20:40:24+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login
[2021-09-02T20:40:24+08:00][sql] CONNECT:[ UseTime:0.000471s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001052s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `t3`.`organ_name`,`t2`.`organ_id`,`t1`.`uuid` FROM `yl_user_card` `t1` LEFT JOIN `yl_user_party` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_organ` `t3` ON `t2`.`organ_id`=`t3`.`id` WHERE  ( stbid='3a95e60211d5b78d' ) LIMIT 1 [ RunTime:0.005077s ]
[2021-09-02T20:40:24+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index
[2021-09-02T20:40:24+08:00][sql] CONNECT:[ UseTime:0.000430s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.002510s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE  `organ_id` = 2  AND `end_time` <= '2021-09-02 20:40:24'  AND `status` = '已审核' [ RunTime:0.003131s ]
[2021-09-02T20:40:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001126s ]
[2021-09-02T20:40:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' [ RunTime:0.003057s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime`,`organ_type` FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' ORDER BY field(organ_type,'上级党委或党工委','党委','党总支','党支部','其他'),`ctime` DESC [ RunTime:0.000630s ]
[2021-09-02T20:40:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001009s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE  `id` = 18 LIMIT 1 [ RunTime:0.003101s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000570s ]
[2021-09-02T20:40:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001114s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 17 LIMIT 1 [ RunTime:0.000415s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 16 LIMIT 1 [ RunTime:0.000267s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 15 LIMIT 1 [ RunTime:0.000443s ]
[2021-09-02T20:40:24+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE  `id` = 14 LIMIT 1 [ RunTime:0.000403s ]
[2021-09-02T20:40:24+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update
[2021-09-02T20:40:25+08:00][sql] CONNECT:[ UseTime:0.000651s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.001047s ]
[2021-09-02T20:40:25+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE  ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003318s ]
[2021-09-02T20:40:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/dangwei
[2021-09-02T20:40:34+08:00][sql] CONNECT:[ UseTime:0.000713s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.001453s ]
[2021-09-02T20:40:34+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE  `node_id` = 27 [ RunTime:0.003523s ]
[2021-09-02T20:40:35+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei
[2021-09-02T20:40:35+08:00][sql] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000925s ]
[2021-09-02T20:40:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '27'  AND `tag_ids` = '1'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000497s ]
[2021-09-02T20:40:35+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE  `node_id` = '27'  AND `tag_ids` = '1'  AND `status` = '上线'  AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000560s ]
[2021-09-02T20:40:51+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdr
[2021-09-02T20:40:51+08:00][sql] CONNECT:[ UseTime:0.000494s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:51+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001126s ]
[2021-09-02T20:40:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `organ_id` = 2 [ RunTime:0.000467s ]
[2021-09-02T20:40:51+08:00][sql] SELECT id, theme, DATE_FORMAT(start_time,"%Y-%m-%d %H:%i") AS start_time, address, status FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000574s ]
[2021-09-02T20:40:54+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2021-09-02T20:40:54+08:00][sql] CONNECT:[ UseTime:0.000448s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000876s ]
[2021-09-02T20:40:54+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 22 LIMIT 1 [ RunTime:0.000392s ]
[2021-09-02T20:40:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2021-09-02T20:40:59+08:00][sql] CONNECT:[ UseTime:0.000638s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:40:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.001041s ]
[2021-09-02T20:40:59+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 22 [ RunTime:0.004565s ]
[2021-09-02T20:41:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hysp
[2021-09-02T20:41:01+08:00][sql] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_material` [ RunTime:0.001001s ]
[2021-09-02T20:41:01+08:00][sql] SELECT `vid` FROM `yl_standing_book_material` WHERE  `standing_book_id` = 22 [ RunTime:0.004494s ]
[2021-09-02T20:41:22+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydh
[2021-09-02T20:41:22+08:00][sql] CONNECT:[ UseTime:0.000565s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001154s ]
[2021-09-02T20:41:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '党员大会'  AND `organ_id` = 2 [ RunTime:0.000420s ]
[2021-09-02T20:41:22+08:00][sql] SELECT id, theme, DATE_FORMAT(start_time,"%Y-%m-%d %H:%i") AS start_time, address, status FROM `yl_standing_book` WHERE  `type` = '党员大会'  AND `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000481s ]
[2021-09-02T20:41:25+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwh
[2021-09-02T20:41:25+08:00][sql] CONNECT:[ UseTime:0.000537s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001032s ]
[2021-09-02T20:41:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `organ_id` = 2 [ RunTime:0.000417s ]
[2021-09-02T20:41:25+08:00][sql] SELECT id, theme, DATE_FORMAT(start_time,"%Y-%m-%d %H:%i") AS start_time, address, status FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000680s ]
[2021-09-02T20:41:27+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2021-09-02T20:41:27+08:00][sql] CONNECT:[ UseTime:0.000426s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001284s ]
[2021-09-02T20:41:27+08:00][sql] SELECT `t3`.`name`,t2.photo as pics,`t1`.`status` FROM `yl_standing_book_sign_in` `t1` LEFT JOIN `yl_user_party` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_user` `t3` ON `t3`.`uuid`=`t1`.`uuid` WHERE  `standing_book_id` = 32 [ RunTime:0.009188s ]
[2021-09-02T20:41:41+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/read
[2021-09-02T20:41:41+08:00][sql] CONNECT:[ UseTime:0.000461s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000996s ]
[2021-09-02T20:41:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001150s ]
[2021-09-02T20:41:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001101s ]
[2021-09-02T20:41:41+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime` FROM `yl_task_queue` WHERE  `status` = '待办'  AND `id` = 38  AND `organ_id` = 2 LIMIT 1 [ RunTime:0.000570s ]
[2021-09-02T20:41:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.002700s ]
[2021-09-02T20:41:41+08:00][sql] SELECT `id`,`icon`,`title`,`description`,`start_time`,`end_time`,`address`,`scope`,`hoster`,`organ_id`,`uuid`,`ctime`,`identifier` FROM `yl_meeting` WHERE  `id` = 17 LIMIT 1 [ RunTime:0.000409s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerAnalyze
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000568s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001236s ]
[2021-09-02T20:41:57+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000470s ]
[2021-09-02T20:41:57+08:00][sql] SELECT count(*) cnt, t2.sex FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` GROUP BY `t2`.`sex` [ RunTime:0.000540s ]
[2021-09-02T20:41:57+08:00][sql] SELECT count(*) cnt, t2.education FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` GROUP BY `t2`.`education` [ RunTime:0.000405s ]
[2021-09-02T20:41:57+08:00][sql] SELECT count(*) cnt, date_format(t2.birthday, "%Y") age FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` GROUP BY date_format(t2.birthday,"%Y") [ RunTime:0.000500s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwhPeople
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000731s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001002s ]
[2021-09-02T20:41:57+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.006048s ]
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000945s ]
[2021-09-02T20:41:57+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` IN (18,32) GROUP BY `status` [ RunTime:0.002346s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000467s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001138s ]
[2021-09-02T20:41:57+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.000655s ]
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000937s ]
[2021-09-02T20:41:57+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.000839s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.001114s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000980s ]
[2021-09-02T20:41:57+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.000544s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000539s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000970s ]
[2021-09-02T20:41:57+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.000593s ]
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000641s ]
[2021-09-02T20:41:57+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.000593s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerList
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000591s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000985s ]
[2021-09-02T20:41:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` `t1` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  `t5`.`years` = '2021' [ RunTime:0.000975s ]
[2021-09-02T20:41:57+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`join_time`,`t1`.`photo`,`t1`.`position`,`t2`.`name`,`t2`.`sex`,`t2`.`birthday`,`t2`.`cardid`,t5.account points FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  `t5`.`years` = '2021' ORDER BY `t5`.`account` DESC LIMIT 0,3 [ RunTime:0.000817s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000628s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001062s ]
[2021-09-02T20:41:57+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.000573s ]
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000838s ]
[2021-09-02T20:41:57+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` = 16 GROUP BY `status` [ RunTime:0.000494s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydhPeople
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000466s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000950s ]
[2021-09-02T20:41:57+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.000449s ]
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000618s ]
[2021-09-02T20:41:57+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` = 17 GROUP BY `status` [ RunTime:0.000503s ]
[2021-09-02T20:41:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration
[2021-09-02T20:41:57+08:00][sql] CONNECT:[ UseTime:0.000418s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:41:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000895s ]
[2021-09-02T20:41:57+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.000621s ]
[2021-09-02T20:42:06+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerList
[2021-09-02T20:42:06+08:00][sql] CONNECT:[ UseTime:0.000559s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:42:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000905s ]
[2021-09-02T20:42:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` `t1` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  `t5`.`years` = '2021' [ RunTime:0.000373s ]
[2021-09-02T20:42:06+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`join_time`,`t1`.`photo`,`t1`.`position`,`t2`.`name`,`t2`.`sex`,`t2`.`birthday`,`t2`.`cardid`,t5.account points FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  `t5`.`years` = '2021' ORDER BY `t5`.`account` DESC LIMIT 0,10 [ RunTime:0.000758s ]
[2021-09-02T20:42:11+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerDataDetail
[2021-09-02T20:42:11+08:00][sql] CONNECT:[ UseTime:0.000694s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:42:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001307s ]
[2021-09-02T20:42:11+08:00][sql] SELECT `t1`.`photo`,`t1`.`join_time`,`t1`.`work_time`,`t1`.`introduce`,`t1`.`bd_region`,`t1`.`bd_resource`,`t2`.`name`,`t2`.`sex`,`t2`.`cardid`,`t2`.`nativeplace`,t3.name education,t4.name national,t5.account points FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_data_education` `t3` ON `t3`.`code`=`t2`.`education` LEFT JOIN `yl_data_national` `t4` ON `t4`.`code`=`t2`.`national` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  `t1`.`uuid` = '3fc7ec61c43840beb73c29863c414bf4'  AND `t5`.`years` = '2021' LIMIT 1 [ RunTime:0.008357s ]
[2021-09-02T20:42:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.003278s ]
[2021-09-02T20:42:11+08:00][sql] SELECT `pid` FROM `yl_region` WHERE  `code` = '330102001051' LIMIT 1 [ RunTime:0.061138s ]
[2021-09-02T20:42:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.001336s ]
[2021-09-02T20:42:11+08:00][sql] SELECT GROUP_CONCAT(name) as name FROM `yl_party_bd_resource` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.004145s ]
[2021-09-02T20:42:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001002s ]
[2021-09-02T20:42:11+08:00][sql] SELECT `t1`.`status`,`t2`.`start_time`,`t2`.`end_time`,`t2`.`type` FROM `yl_standing_book_sign_in` `t1` LEFT JOIN `yl_standing_book` `t2` ON `t2`.`id`=`t1`.`standing_book_id` WHERE  `t1`.`uuid` = '3fc7ec61c43840beb73c29863c414bf4'  AND `start_time` BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59' [ RunTime:0.000917s ]
[2021-09-02T20:42:18+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerDataDetail
[2021-09-02T20:42:19+08:00][sql] CONNECT:[ UseTime:0.000622s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:42:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000966s ]
[2021-09-02T20:42:19+08:00][sql] SELECT `t1`.`photo`,`t1`.`join_time`,`t1`.`work_time`,`t1`.`introduce`,`t1`.`bd_region`,`t1`.`bd_resource`,`t2`.`name`,`t2`.`sex`,`t2`.`cardid`,`t2`.`nativeplace`,t3.name education,t4.name national,t5.account points FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_data_education` `t3` ON `t3`.`code`=`t2`.`education` LEFT JOIN `yl_data_national` `t4` ON `t4`.`code`=`t2`.`national` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE  `t1`.`uuid` = 'c9de18c5992f424ca0c2bfbfc7001234'  AND `t5`.`years` = '2021' LIMIT 1 [ RunTime:0.000872s ]
[2021-09-02T20:42:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.000995s ]
[2021-09-02T20:42:19+08:00][sql] SELECT `pid` FROM `yl_region` WHERE  `code` = '330102001051' LIMIT 1 [ RunTime:0.000280s ]
[2021-09-02T20:42:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.000859s ]
[2021-09-02T20:42:19+08:00][sql] SELECT GROUP_CONCAT(name) as name FROM `yl_party_bd_resource` WHERE  `id` = 8 LIMIT 1 [ RunTime:0.000566s ]
[2021-09-02T20:42:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001072s ]
[2021-09-02T20:42:19+08:00][sql] SELECT `t1`.`status`,`t2`.`start_time`,`t2`.`end_time`,`t2`.`type` FROM `yl_standing_book_sign_in` `t1` LEFT JOIN `yl_standing_book` `t2` ON `t2`.`id`=`t1`.`standing_book_id` WHERE  `t1`.`uuid` = 'c9de18c5992f424ca0c2bfbfc7001234'  AND `start_time` BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59' [ RunTime:0.000911s ]
[2021-09-02T20:42:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangjianzixun
[2021-09-02T20:42:34+08:00][sql] CONNECT:[ UseTime:0.000568s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:42:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001174s ]
[2021-09-02T20:42:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000619s ]
[2021-09-02T20:42:34+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000592s ]
[2021-09-02T20:42:42+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2021-09-02T20:42:42+08:00][sql] CONNECT:[ UseTime:0.000578s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:42:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001178s ]
[2021-09-02T20:42:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000412s ]
[2021-09-02T20:42:42+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000650s ]
[2021-09-02T20:43:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangjianzixun
[2021-09-02T20:43:59+08:00][sql] CONNECT:[ UseTime:0.000487s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:43:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000915s ]
[2021-09-02T20:43:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000318s ]
[2021-09-02T20:43:59+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000439s ]
[2021-09-02T20:45:10+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2021-09-02T20:45:10+08:00][sql] CONNECT:[ UseTime:0.000691s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:45:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001052s ]
[2021-09-02T20:45:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000341s ]
[2021-09-02T20:45:10+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000397s ]
[2021-09-02T20:48:09+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/read
[2021-09-02T20:48:09+08:00][sql] CONNECT:[ UseTime:0.000468s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:48:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001059s ]
[2021-09-02T20:48:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000884s ]
[2021-09-02T20:48:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000886s ]
[2021-09-02T20:48:09+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime` FROM `yl_task_queue` WHERE  `status` = '待办'  AND `id` = 43  AND `organ_id` = 2 LIMIT 1 [ RunTime:0.000489s ]
[2021-09-02T20:48:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000790s ]
[2021-09-02T20:48:09+08:00][sql] SELECT `id`,`title`,`desc`,`type`,`deadline`,`sender_uuid`,`send_time`,`organ_id`,`vid` FROM `yl_task` WHERE  `id` = 18 LIMIT 1 [ RunTime:0.000468s ]
[2021-09-02T20:48:24+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/update
[2021-09-02T20:48:24+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:48:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001932s ]
[2021-09-02T20:48:24+08:00][sql] SELECT * FROM `yl_task_queue` WHERE  `status` = '待办'  AND `type` <> '扫码签到'  AND `id` = 43  AND `organ_id` = 2 LIMIT 1 [ RunTime:0.000723s ]
[2021-09-02T20:48:24+08:00][sql] UPDATE `yl_task_queue`  SET `status` = '已办'  WHERE  `status` = '待办'  AND `type` <> '扫码签到'  AND `id` = 43  AND `organ_id` = 2 [ RunTime:0.000877s ]
[2021-09-02T20:48:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001124s ]
[2021-09-02T20:48:24+08:00][sql] SELECT `a`.`uuid` FROM `yl_user` `a` INNER JOIN `yl_user_role` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`manage_organ_id` = '2'  AND `b`.`role_id` = '25' [ RunTime:0.002589s ]
[2021-09-02T20:48:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/dangwei
[2021-09-02T20:48:34+08:00][sql] CONNECT:[ UseTime:0.000545s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:48:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.000962s ]
[2021-09-02T20:48:34+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE  `node_id` = 27 [ RunTime:0.000344s ]
[2021-09-02T20:48:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei
[2021-09-02T20:48:34+08:00][sql] CONNECT:[ UseTime:0.000656s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:48:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001094s ]
[2021-09-02T20:48:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '27'  AND `tag_ids` = '1'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000399s ]
[2021-09-02T20:48:34+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE  `node_id` = '27'  AND `tag_ids` = '1'  AND `status` = '上线'  AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000441s ]
[2021-09-02T20:48:37+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdr
[2021-09-02T20:48:37+08:00][sql] CONNECT:[ UseTime:0.000751s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:48:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000983s ]
[2021-09-02T20:48:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `organ_id` = 2 [ RunTime:0.000328s ]
[2021-09-02T20:48:37+08:00][sql] SELECT id, theme, DATE_FORMAT(start_time,"%Y-%m-%d %H:%i") AS start_time, address, status FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000297s ]
[2021-09-02T20:48:42+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2021-09-02T20:48:42+08:00][sql] CONNECT:[ UseTime:0.000617s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:48:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000990s ]
[2021-09-02T20:48:42+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 21 LIMIT 1 [ RunTime:0.000591s ]
[2021-09-02T20:48:52+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2021-09-02T20:48:52+08:00][sql] CONNECT:[ UseTime:0.000591s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:48:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.001308s ]
[2021-09-02T20:48:52+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 21 [ RunTime:0.000597s ]
[2021-09-02T20:49:11+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2021-09-02T20:49:11+08:00][sql] CONNECT:[ UseTime:0.000663s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:49:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001001s ]
[2021-09-02T20:49:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000330s ]
[2021-09-02T20:49:11+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000379s ]
[2021-09-02T20:50:03+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2021-09-02T20:50:03+08:00][sql] CONNECT:[ UseTime:0.000631s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:50:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000903s ]
[2021-09-02T20:50:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000280s ]
[2021-09-02T20:50:03+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000249s ]
[2021-09-02T20:50:14+08:00][debug] middleware/Authorise: handle | request path = api.app.Meeting/index
[2021-09-02T20:50:14+08:00][debug] ---$rediskey---app:jwt:mq9sehlqj8PoEj31i7RpU0H6u_U2Pjga_rE_LosqEi4
[2021-09-02T20:50:14+08:00][sql] CONNECT:[ UseTime:0.000688s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:50:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000955s ]
[2021-09-02T20:50:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000276s ]
[2021-09-02T20:50:14+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000256s ]
[2021-09-02T20:53:39+08:00][debug] middleware/Authorise: handle | request path = api.app.Meeting/index
[2021-09-02T20:53:39+08:00][debug] ---$rediskey---app:jwt:mq9sehlqj8PoEj31i7RpU0H6u_U2Pjga_rE_LosqEi4
[2021-09-02T20:53:39+08:00][sql] CONNECT:[ UseTime:0.000673s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-09-02T20:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000950s ]
[2021-09-02T20:53:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000538s ]
[2021-09-02T20:53:39+08:00][sql] SELECT `id`,`title`,`icon`,`start_time`,`end_time`,`address`,`identifier` FROM `yl_meeting` WHERE  `organ_id` = 2 ORDER BY `start_time` DESC LIMIT 0,10 [ RunTime:0.000430s ]