[2021-07-03T06:23:45+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T06:23:45+08:00][sql] CONNECT:[ UseTime:0.000643s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T06:23:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.005372s ] [2021-07-03T06:23:45+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='8765432101234567' ) LIMIT 1 [ RunTime:0.001180s ] [2021-07-03T06:23:45+08:00][sql] INSERT INTO `yl_user_card` SET `stbid` = '8765432101234567' , `uuid` = 'c845765990724681b9acbf465bd8329b' , `status` = '有效' [ RunTime:0.000471s ] [2021-07-03T06:23:45+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='8765432101234567' ) LIMIT 1 [ RunTime:0.005100s ] [2021-07-03T06:23:46+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T06:23:46+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T06:23:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001251s ] [2021-07-03T06:23:46+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 06:23:46' AND `status` = '已审核' [ RunTime:0.000485s ] [2021-07-03T06:23:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001092s ] [2021-07-03T06:23:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000398s ] [2021-07-03T06:23:46+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.000456s ] [2021-07-03T06:23:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000919s ] [2021-07-03T06:23:46+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000484s ] [2021-07-03T06:23:46+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000403s ] [2021-07-03T06:23:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000879s ] [2021-07-03T06:23:46+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000292s ] [2021-07-03T06:23:46+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000356s ] [2021-07-03T06:23:46+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update [2021-07-03T06:23:46+08:00][sql] CONNECT:[ UseTime:0.000682s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T06:23:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.003270s ] [2021-07-03T06:23:46+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ] [2021-07-03T06:23:53+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/dangwei [2021-07-03T06:23:53+08:00][sql] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T06:23:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.001064s ] [2021-07-03T06:23:53+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE `node_id` = 27 [ RunTime:0.000463s ] [2021-07-03T06:23:54+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-07-03T06:23:54+08:00][sql] CONNECT:[ UseTime:0.000670s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T06:23:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001218s ] [2021-07-03T06:23:54+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.000420s ] [2021-07-03T06:23:54+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.000366s ] [2021-07-03T06:24:08+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangjianzixun [2021-07-03T06:24:08+08:00][sql] CONNECT:[ UseTime:0.000652s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T06:24:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001316s ] [2021-07-03T06:24:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000378s ] [2021-07-03T06:24:08+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.000437s ] [2021-07-03T07:40:04+08:00][debug] middleware/Authorise: handle | request path = Nmap/folder [2021-07-03T07:40:04+08:00][debug] middleware/Authorise: handle | request path = evox/about [2021-07-03T09:19:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T09:19:34+08:00][sql] CONNECT:[ UseTime:0.001278s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:19:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000921s ] [2021-07-03T09:19:34+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.001009s ] [2021-07-03T09:19:35+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T09:19:35+08:00][sql] CONNECT:[ UseTime:0.000690s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:19:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001207s ] [2021-07-03T09:19:35+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 09:19:35' AND `status` = '已审核' [ RunTime:0.000499s ] [2021-07-03T09:19:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000698s ] [2021-07-03T09:19:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000368s ] [2021-07-03T09:19:35+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.000508s ] [2021-07-03T09:19:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001143s ] [2021-07-03T09:19:35+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000346s ] [2021-07-03T09:19:35+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000448s ] [2021-07-03T09:19:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001024s ] [2021-07-03T09:19:35+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000394s ] [2021-07-03T09:19:35+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000307s ] [2021-07-03T09:19:35+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update [2021-07-03T09:19:35+08:00][sql] CONNECT:[ UseTime:0.000744s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:19:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.001233s ] [2021-07-03T09:19:35+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ] [2021-07-03T09:33:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T09:33:30+08:00][sql] CONNECT:[ UseTime:0.000739s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:33:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000965s ] [2021-07-03T09:33: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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000541s ] [2021-07-03T09:33:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T09:33:31+08:00][sql] CONNECT:[ UseTime:0.000688s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:33:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000964s ] [2021-07-03T09:33:31+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 09:33:31' AND `status` = '已审核' [ RunTime:0.000641s ] [2021-07-03T09:33:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001056s ] [2021-07-03T09:33:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000411s ] [2021-07-03T09:33: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.000396s ] [2021-07-03T09:33:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000781s ] [2021-07-03T09:33:31+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000337s ] [2021-07-03T09:33:31+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000529s ] [2021-07-03T09:33:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000848s ] [2021-07-03T09:33:31+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000398s ] [2021-07-03T09:33:31+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000355s ] [2021-07-03T09:33:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update [2021-07-03T09:33:31+08:00][sql] CONNECT:[ UseTime:0.000629s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:33:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.001013s ] [2021-07-03T09:33: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.000413s ] [2021-07-03T09:41:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T09:41:59+08:00][sql] CONNECT:[ UseTime:0.000509s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:41:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000889s ] [2021-07-03T09:41: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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000619s ] [2021-07-03T09:42:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T09:42:00+08:00][sql] CONNECT:[ UseTime:0.000699s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:42:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001478s ] [2021-07-03T09:42:00+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 09:42:00' AND `status` = '已审核' [ RunTime:0.000591s ] [2021-07-03T09:42:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000770s ] [2021-07-03T09:42:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000374s ] [2021-07-03T09:42:00+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.000572s ] [2021-07-03T09:42:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001192s ] [2021-07-03T09:42:00+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000353s ] [2021-07-03T09:42:00+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000517s ] [2021-07-03T09:42:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000975s ] [2021-07-03T09:42:00+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000316s ] [2021-07-03T09:42:00+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000307s ] [2021-07-03T09:42:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update [2021-07-03T09:42:00+08:00][sql] CONNECT:[ UseTime:0.000639s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:42:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.000991s ] [2021-07-03T09:42:00+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ] [2021-07-03T09:49:53+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T09:49:53+08:00][sql] CONNECT:[ UseTime:0.000616s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:49:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000968s ] [2021-07-03T09:49:53+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000389s ] [2021-07-03T09:49:54+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T09:49:54+08:00][sql] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000907s ] [2021-07-03T09:49:54+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 09:49:54' AND `status` = '已审核' [ RunTime:0.000505s ] [2021-07-03T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000603s ] [2021-07-03T09:49:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000251s ] [2021-07-03T09:49:54+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.000315s ] [2021-07-03T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000790s ] [2021-07-03T09:49:54+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000352s ] [2021-07-03T09:49:54+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000447s ] [2021-07-03T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000875s ] [2021-07-03T09:49:54+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000341s ] [2021-07-03T09:49:54+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000432s ] [2021-07-03T10:31:25+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T10:31:25+08:00][sql] CONNECT:[ UseTime:0.000645s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T10:31:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000967s ] [2021-07-03T10:31:25+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.000791s ] [2021-07-03T10:31:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T10:31:26+08:00][sql] CONNECT:[ UseTime:0.000590s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T10:31:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000879s ] [2021-07-03T10:31:26+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 10:31:26' AND `status` = '已审核' [ RunTime:0.000635s ] [2021-07-03T10:31:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000707s ] [2021-07-03T10:31:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000402s ] [2021-07-03T10:31:26+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.000363s ] [2021-07-03T10:31:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000699s ] [2021-07-03T10:31:26+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000402s ] [2021-07-03T10:31:26+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000415s ] [2021-07-03T10:31:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000706s ] [2021-07-03T10:31:26+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000218s ] [2021-07-03T10:31:26+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000252s ] [2021-07-03T10:31:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update [2021-07-03T10:31:26+08:00][sql] CONNECT:[ UseTime:0.000519s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T10:31:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.000868s ] [2021-07-03T10:31:26+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ] [2021-07-03T11:05:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T11:05:15+08:00][sql] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:05:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000890s ] [2021-07-03T11:05:15+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000672s ] [2021-07-03T11:05:16+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T11:05:16+08:00][sql] CONNECT:[ UseTime:0.000833s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:05:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001304s ] [2021-07-03T11:05:16+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 11:05:16' AND `status` = '已审核' [ RunTime:0.000567s ] [2021-07-03T11:05:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000766s ] [2021-07-03T11:05:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000313s ] [2021-07-03T11:05:16+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.000307s ] [2021-07-03T11:05:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001034s ] [2021-07-03T11:05:16+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000350s ] [2021-07-03T11:05:16+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000593s ] [2021-07-03T11:05:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000960s ] [2021-07-03T11:05:16+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000249s ] [2021-07-03T11:05:16+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000261s ] [2021-07-03T11:15:55+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T11:15:55+08:00][sql] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:15:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000894s ] [2021-07-03T11:15:55+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000355s ] [2021-07-03T11:15:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T11:15:56+08:00][sql] CONNECT:[ UseTime:0.000716s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:15:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000950s ] [2021-07-03T11:15:56+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 11:15:56' AND `status` = '已审核' [ RunTime:0.000490s ] [2021-07-03T11:15:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001013s ] [2021-07-03T11:15:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000395s ] [2021-07-03T11:15:56+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.000559s ] [2021-07-03T11:15:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001312s ] [2021-07-03T11:15:56+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000413s ] [2021-07-03T11:15:56+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000445s ] [2021-07-03T11:15:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000924s ] [2021-07-03T11:15:56+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000276s ] [2021-07-03T11:15:56+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000344s ] [2021-07-03T11:19:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T11:19:43+08:00][sql] CONNECT:[ UseTime:0.000521s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:19:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000783s ] [2021-07-03T11:19:43+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000326s ] [2021-07-03T11:19:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T11:19:43+08:00][sql] CONNECT:[ UseTime:0.000609s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:19:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000939s ] [2021-07-03T11:19:43+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 11:19:43' AND `status` = '已审核' [ RunTime:0.000454s ] [2021-07-03T11:19:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000609s ] [2021-07-03T11:19:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000256s ] [2021-07-03T11:19:43+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.000436s ] [2021-07-03T11:19:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000694s ] [2021-07-03T11:19:43+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000281s ] [2021-07-03T11:19:43+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000478s ] [2021-07-03T11:19:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000836s ] [2021-07-03T11:19:43+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000311s ] [2021-07-03T11:19:43+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000260s ] [2021-07-03T11:21:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T11:21:02+08:00][sql] CONNECT:[ UseTime:0.000738s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000957s ] [2021-07-03T11:21:02+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000423s ] [2021-07-03T11:21:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T11:21:02+08:00][sql] CONNECT:[ UseTime:0.000570s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000884s ] [2021-07-03T11:21:02+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 11:21:02' AND `status` = '已审核' [ RunTime:0.000778s ] [2021-07-03T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000707s ] [2021-07-03T11:21:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000288s ] [2021-07-03T11:21:02+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.000335s ] [2021-07-03T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000835s ] [2021-07-03T11:21:02+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000340s ] [2021-07-03T11:21:02+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000597s ] [2021-07-03T11:21:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000944s ] [2021-07-03T11:21:02+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000309s ] [2021-07-03T11:21:02+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000769s ] [2021-07-03T11:43:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T11:43:29+08:00][sql] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:43:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000830s ] [2021-07-03T11:43:29+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000468s ] [2021-07-03T11:43:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T11:43:29+08:00][sql] CONNECT:[ UseTime:0.000630s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:43:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001002s ] [2021-07-03T11:43:29+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 11:43:29' AND `status` = '已审核' [ RunTime:0.000534s ] [2021-07-03T11:43:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000705s ] [2021-07-03T11:43:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000296s ] [2021-07-03T11:43:29+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.000353s ] [2021-07-03T11:43:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000807s ] [2021-07-03T11:43:29+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000288s ] [2021-07-03T11:43:29+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000436s ] [2021-07-03T11:43:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000797s ] [2021-07-03T11:43:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000510s ] [2021-07-03T11:43:29+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000424s ] [2021-07-03T11:56:41+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T11:56:41+08:00][sql] CONNECT:[ UseTime:0.000635s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:56:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001031s ] [2021-07-03T11:56:41+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000408s ] [2021-07-03T11:56:42+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T11:56:42+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T11:56:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001324s ] [2021-07-03T11:56:42+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 11:56:42' AND `status` = '已审核' [ RunTime:0.000525s ] [2021-07-03T11:56:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000645s ] [2021-07-03T11:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000323s ] [2021-07-03T11:56:42+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.000402s ] [2021-07-03T11:56:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000646s ] [2021-07-03T11:56:42+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000568s ] [2021-07-03T11:56:42+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000618s ] [2021-07-03T11:56:42+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000918s ] [2021-07-03T11:56:42+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000278s ] [2021-07-03T11:56:42+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000510s ] [2021-07-03T13:29:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T13:29:15+08:00][sql] CONNECT:[ UseTime:0.000455s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T13:29:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000910s ] [2021-07-03T13:29:15+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000503s ] [2021-07-03T13:29:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T13:29:15+08:00][sql] CONNECT:[ UseTime:0.000688s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T13:29:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000981s ] [2021-07-03T13:29:15+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 13:29:15' AND `status` = '已审核' [ RunTime:0.000490s ] [2021-07-03T13:29:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000638s ] [2021-07-03T13:29:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000468s ] [2021-07-03T13:29:15+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.000336s ] [2021-07-03T13:29:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000922s ] [2021-07-03T13:29:15+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000359s ] [2021-07-03T13:29:15+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000447s ] [2021-07-03T13:29:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000806s ] [2021-07-03T13:29:15+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000402s ] [2021-07-03T13:29:15+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000355s ] [2021-07-03T13:32:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T13:32:01+08:00][sql] CONNECT:[ UseTime:0.000977s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T13:32:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001136s ] [2021-07-03T13:32:01+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000493s ] [2021-07-03T13:32:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T13:32:02+08:00][sql] CONNECT:[ UseTime:0.000679s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T13:32:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001002s ] [2021-07-03T13:32:02+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 13:32:02' AND `status` = '已审核' [ RunTime:0.000468s ] [2021-07-03T13:32:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000645s ] [2021-07-03T13:32:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000436s ] [2021-07-03T13:32:02+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.000470s ] [2021-07-03T13:32:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.000939s ] [2021-07-03T13:32:02+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000318s ] [2021-07-03T13:32:02+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000410s ] [2021-07-03T13:32:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000837s ] [2021-07-03T13:32:02+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000288s ] [2021-07-03T13:32:02+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000231s ] [2021-07-03T17:06:27+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-07-03T17:06:28+08:00][sql] CONNECT:[ UseTime:0.000625s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T17:06:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001082s ] [2021-07-03T17:06:28+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='51af430fe28a733d' ) LIMIT 1 [ RunTime:0.000570s ] [2021-07-03T17:06:28+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-07-03T17:06:28+08:00][sql] CONNECT:[ UseTime:0.000829s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-07-03T17:06:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001009s ] [2021-07-03T17:06:28+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-07-03 17:06:28' AND `status` = '已审核' [ RunTime:0.000689s ] [2021-07-03T17:06:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001018s ] [2021-07-03T17:06:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000392s ] [2021-07-03T17:06:28+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.000509s ] [2021-07-03T17:06:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001142s ] [2021-07-03T17:06:28+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000299s ] [2021-07-03T17:06:28+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000466s ] [2021-07-03T17:06:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001140s ] [2021-07-03T17:06:28+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000306s ] [2021-07-03T17:06:28+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000252s ]