[2021-08-02T09:21:33+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-08-02T09:21:34+08:00][sql] CONNECT:[ UseTime:0.000625s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001539s ] [2021-08-02T09:21: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='db1dcb1d0fcccffa' ) LIMIT 1 [ RunTime:0.000836s ] [2021-08-02T09:21:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-08-02T09:21:34+08:00][sql] CONNECT:[ UseTime:0.000664s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000994s ] [2021-08-02T09:21:34+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-08-02 09:21:34' AND `status` = '已审核' [ RunTime:0.000558s ] [2021-08-02T09:21:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000915s ] [2021-08-02T09:21:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000307s ] [2021-08-02T09:21:34+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.000491s ] [2021-08-02T09:21:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001033s ] [2021-08-02T09:21:34+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000284s ] [2021-08-02T09:21:34+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 60 LIMIT 1 [ RunTime:0.000486s ] [2021-08-02T09:21:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001073s ] [2021-08-02T09:21:34+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000283s ] [2021-08-02T09:21:34+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000426s ] [2021-08-02T09:21:34+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000360s ] [2021-08-02T09:21:34+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000256s ] [2021-08-02T09:21:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update [2021-08-02T09:21:34+08:00][sql] CONNECT:[ UseTime:0.000593s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.002991s ] [2021-08-02T09:21:34+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwhPeople [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000459s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001026s ] [2021-08-02T09:21:43+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.000529s ] [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001020s ] [2021-08-02T09:21:43+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.000306s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydhPeople [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000506s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000932s ] [2021-08-02T09:21:43+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.000388s ] [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001213s ] [2021-08-02T09:21:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 17 GROUP BY `status` [ RunTime:0.000338s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000520s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000896s ] [2021-08-02T09:21:43+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.000422s ] [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000697s ] [2021-08-02T09:21:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 16 GROUP BY `status` [ RunTime:0.000285s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerList [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000576s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000937s ] [2021-08-02T09:21:43+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.000750s ] [2021-08-02T09:21:43+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.000433s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000640s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000973s ] [2021-08-02T09:21:43+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.000369s ] [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000723s ] [2021-08-02T09:21:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (11,15) GROUP BY `status` [ RunTime:0.000282s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000588s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001263s ] [2021-08-02T09:21:43+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.000438s ] [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001062s ] [2021-08-02T09:21:43+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.000322s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000669s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001194s ] [2021-08-02T09:21:43+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.000443s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000565s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001084s ] [2021-08-02T09:21:43+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.000517s ] [2021-08-02T09:21:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerAnalyze [2021-08-02T09:21:43+08:00][sql] CONNECT:[ UseTime:0.000496s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001005s ] [2021-08-02T09:21:43+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000386s ] [2021-08-02T09:21:43+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.000350s ] [2021-08-02T09:21:43+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.000229s ] [2021-08-02T09:21:43+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.000279s ] [2021-08-02T09:21:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerAnalyze [2021-08-02T09:21:56+08:00][sql] CONNECT:[ UseTime:0.000575s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000927s ] [2021-08-02T09:21:56+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000249s ] [2021-08-02T09:21:56+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.000555s ] [2021-08-02T09:21:56+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.000305s ] [2021-08-02T09:21:56+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.000371s ] [2021-08-02T09:21:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration [2021-08-02T09:21:56+08:00][sql] CONNECT:[ UseTime:0.000698s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001019s ] [2021-08-02T09:21:56+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.000441s ] [2021-08-02T09:21:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydhPeople [2021-08-02T09:21:56+08:00][sql] CONNECT:[ UseTime:0.000664s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001152s ] [2021-08-02T09:21:56+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.000530s ] [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000748s ] [2021-08-02T09:21:56+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 17 GROUP BY `status` [ RunTime:0.000312s ] [2021-08-02T09:21:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerList [2021-08-02T09:21:56+08:00][sql] CONNECT:[ UseTime:0.000454s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001034s ] [2021-08-02T09:21:56+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.000498s ] [2021-08-02T09:21:56+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.000566s ] [2021-08-02T09:21:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration [2021-08-02T09:21:56+08:00][sql] CONNECT:[ UseTime:0.000652s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001177s ] [2021-08-02T09:21:56+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.000559s ] [2021-08-02T09:21:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople [2021-08-02T09:21:56+08:00][sql] CONNECT:[ UseTime:0.000723s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001121s ] [2021-08-02T09:21:56+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.000424s ] [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000741s ] [2021-08-02T09:21:56+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 16 GROUP BY `status` [ RunTime:0.000274s ] [2021-08-02T09:21:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwhPeople [2021-08-02T09:21:56+08:00][sql] CONNECT:[ UseTime:0.000460s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000850s ] [2021-08-02T09:21:56+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.000354s ] [2021-08-02T09:21:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001004s ] [2021-08-02T09:21:56+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.000952s ] [2021-08-02T09:21:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople [2021-08-02T09:21:57+08:00][sql] CONNECT:[ UseTime:0.000806s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001147s ] [2021-08-02T09:21: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.000459s ] [2021-08-02T09:21:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001063s ] [2021-08-02T09:21:57+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (11,15) GROUP BY `status` [ RunTime:0.000557s ] [2021-08-02T09:21:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople [2021-08-02T09:21:57+08:00][sql] CONNECT:[ UseTime:0.000780s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:21:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001006s ] [2021-08-02T09:21: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.001137s ] [2021-08-02T09:21:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000749s ] [2021-08-02T09:21: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.000453s ] [2021-08-02T09:22:05+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index [2021-08-02T09:22:05+08:00][sql] CONNECT:[ UseTime:0.000637s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001005s ] [2021-08-02T09:22:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE `organ_id` = 2 [ RunTime:0.000278s ] [2021-08-02T09:22:05+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.000254s ] [2021-08-02T09:22:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydh [2021-08-02T09:22:15+08:00][sql] CONNECT:[ UseTime:0.000646s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001090s ] [2021-08-02T09:22:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' AND `organ_id` = 2 [ RunTime:0.000330s ] [2021-08-02T09:22:15+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.000456s ] [2021-08-02T09:22:17+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwh [2021-08-02T09:22:17+08:00][sql] CONNECT:[ UseTime:0.000697s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001039s ] [2021-08-02T09:22:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' AND `organ_id` = 2 [ RunTime:0.000308s ] [2021-08-02T09:22:17+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.000483s ] [2021-08-02T09:22:19+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzh [2021-08-02T09:22:19+08:00][sql] CONNECT:[ UseTime:0.000636s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001508s ] [2021-08-02T09:22:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' AND `organ_id` = 2 [ RunTime:0.000467s ] [2021-08-02T09:22:19+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.000416s ] [2021-08-02T09:22:21+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwh [2021-08-02T09:22:21+08:00][sql] CONNECT:[ UseTime:0.000536s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000981s ] [2021-08-02T09:22:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' AND `organ_id` = 2 [ RunTime:0.000377s ] [2021-08-02T09:22:21+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.000286s ] [2021-08-02T09:22:22+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydh [2021-08-02T09:22:22+08:00][sql] CONNECT:[ UseTime:0.000627s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001155s ] [2021-08-02T09:22:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' AND `organ_id` = 2 [ RunTime:0.000406s ] [2021-08-02T09:22: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.000450s ] [2021-08-02T09:22:22+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwh [2021-08-02T09:22:22+08:00][sql] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001060s ] [2021-08-02T09:22:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' AND `organ_id` = 2 [ RunTime:0.000374s ] [2021-08-02T09:22: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.000347s ] [2021-08-02T09:22:23+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzh [2021-08-02T09:22:23+08:00][sql] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000928s ] [2021-08-02T09:22:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' AND `organ_id` = 2 [ RunTime:0.000381s ] [2021-08-02T09:22:23+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.000407s ] [2021-08-02T09:22:23+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dk [2021-08-02T09:22:23+08:00][sql] CONNECT:[ UseTime:0.000649s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001240s ] [2021-08-02T09:22:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党课' AND `organ_id` = 2 [ RunTime:0.000474s ] [2021-08-02T09:22:23+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.000463s ] [2021-08-02T09:22:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk [2021-08-02T09:22:26+08:00][sql] CONNECT:[ UseTime:0.000648s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001005s ] [2021-08-02T09:22:26+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` = 24 [ RunTime:0.000410s ] [2021-08-02T09:22:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap [2021-08-02T09:22:31+08:00][sql] CONNECT:[ UseTime:0.000634s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001342s ] [2021-08-02T09:22:31+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000407s ] [2021-08-02T09:22:32+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dzwd [2021-08-02T09:22:32+08:00][sql] CONNECT:[ UseTime:0.000503s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_documents` [ RunTime:0.000996s ] [2021-08-02T09:22:32+08:00][sql] SELECT `t2`.`name`,`t2`.`ctime`,`t3`.`pic_path`,`t2`.`extension` FROM `yl_standing_book_documents` `t1` LEFT JOIN `yl_documents` `t2` ON `t2`.`id`=`t1`.`documents_id` LEFT JOIN `yl_documents_trans` `t3` ON `t3`.`documents_id`=`t1`.`documents_id` WHERE `t1`.`standing_book_id` = '24' [ RunTime:0.000662s ] [2021-08-02T09:22:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zxcs [2021-08-02T09:22:34+08:00][sql] CONNECT:[ UseTime:0.000582s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_test` [ RunTime:0.000988s ] [2021-08-02T09:22:34+08:00][sql] SELECT `online_test_id` FROM `yl_standing_book_test` WHERE `standing_book_id` = 24 LIMIT 1 [ RunTime:0.000367s ] [2021-08-02T09:22:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_question` [ RunTime:0.000956s ] [2021-08-02T09:22:34+08:00][sql] SELECT `id`,`type`,`ques_title`,`ques_content` FROM `yl_question` WHERE `online_test_id` IS NULL [ RunTime:0.000487s ] [2021-08-02T09:22:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_question_option` [ RunTime:0.001638s ] [2021-08-02T09:22:34+08:00][sql] SELECT `id`,`question_id`,`option_name`,`option_value` FROM `yl_question_option` WHERE `online_test_id` IS NULL [ RunTime:0.000305s ] [2021-08-02T09:22:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdr [2021-08-02T09:22:43+08:00][sql] CONNECT:[ UseTime:0.000700s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001477s ] [2021-08-02T09:22:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '主题党日' AND `organ_id` = 2 [ RunTime:0.000417s ] [2021-08-02T09:22:43+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.000496s ] [2021-08-02T09:22:44+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap [2021-08-02T09:22:44+08:00][sql] CONNECT:[ UseTime:0.000746s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001164s ] [2021-08-02T09:22:44+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000520s ] [2021-08-02T09:22:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zbcy [2021-08-02T09:22:57+08:00][sql] CONNECT:[ UseTime:0.000618s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001005s ] [2021-08-02T09:22:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE `position` <> '无' AND `organ_id` = 2 [ RunTime:0.000379s ] [2021-08-02T09:22:57+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`position`,`t1`.`introduce`,`t1`.`photo`,`t2`.`name`,`t2`.`sex`,`t2`.`cardid` FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` WHERE `position` <> '无' AND `organ_id` = 2 LIMIT 0,10 [ RunTime:0.000548s ] [2021-08-02T09:22:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zzjg [2021-08-02T09:22:59+08:00][sql] CONNECT:[ UseTime:0.000588s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-02T09:22:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000956s ] [2021-08-02T09:22:59+08:00][sql] SELECT `pics` FROM `yl_party_organ` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000313s ]