[2022-06-14T04:51:09+08:00][debug] middleware/Authorise: handle | request path = Nmap/folder
[2022-06-14T04:51:09+08:00][debug] middleware/Authorise: handle | request path = evox/about
[2022-06-14T08:55:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login
[2022-06-14T08:55:26+08:00][sql] CONNECT:[ UseTime:0.000584s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000985s ]
[2022-06-14T08:55:26+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='4ced539131f2e271' ) LIMIT 1 [ RunTime:0.001162s ]
[2022-06-14T08:55:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index
[2022-06-14T08:55:26+08:00][sql] CONNECT:[ UseTime:0.000438s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000949s ]
[2022-06-14T08:55:26+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE  `organ_id` = 2  AND `end_time` <= '2022-06-14 08:55:26'  AND `status` = '已审核' [ RunTime:0.000428s ]
[2022-06-14T08:55:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000642s ]
[2022-06-14T08:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' [ RunTime:0.000346s ]
[2022-06-14T08:55: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.000379s ]
[2022-06-14T08:55:26+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000321s ]
[2022-06-14T08:55:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update
[2022-06-14T08:55:26+08:00][sql] CONNECT:[ UseTime:0.000506s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.001072s ]
[2022-06-14T08:55: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.000431s ]
[2022-06-14T08:55:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/dangwei
[2022-06-14T08:55:34+08:00][sql] CONNECT:[ UseTime:0.000399s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.001126s ]
[2022-06-14T08:55:34+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE  `node_id` = 27 [ RunTime:0.000564s ]
[2022-06-14T08:55:34+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei
[2022-06-14T08:55:34+08:00][sql] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:34+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001068s ]
[2022-06-14T08:55: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.000519s ]
[2022-06-14T08:55: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.000514s ]
[2022-06-14T08:55:36+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdr
[2022-06-14T08:55:36+08:00][sql] CONNECT:[ UseTime:0.000901s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000781s ]
[2022-06-14T08:55:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `organ_id` = 2 [ RunTime:0.000566s ]
[2022-06-14T08:55:36+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.000431s ]
[2022-06-14T08:55:38+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:55:38+08:00][sql] CONNECT:[ UseTime:0.000443s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000749s ]
[2022-06-14T08:55:38+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 21 LIMIT 1 [ RunTime:0.000474s ]
[2022-06-14T08:55:39+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2022-06-14T08:55:39+08:00][sql] CONNECT:[ UseTime:0.000445s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.000818s ]
[2022-06-14T08:55:39+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 21 [ RunTime:0.000400s ]
[2022-06-14T08:55:40+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:55:40+08:00][sql] CONNECT:[ UseTime:0.000451s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000732s ]
[2022-06-14T08:55:40+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 21 LIMIT 1 [ RunTime:0.000264s ]
[2022-06-14T08:55:44+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2022-06-14T08:55:45+08:00][sql] CONNECT:[ UseTime:0.000453s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.000656s ]
[2022-06-14T08:55:45+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 21 [ RunTime:0.000263s ]
[2022-06-14T08:55:45+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:55:46+08:00][sql] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:46+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000771s ]
[2022-06-14T08:55:46+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 21 LIMIT 1 [ RunTime:0.000359s ]
[2022-06-14T08:55:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2022-06-14T08:55:56+08:00][sql] CONNECT:[ UseTime:0.000642s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.000761s ]
[2022-06-14T08:55:56+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 21 [ RunTime:0.000342s ]
[2022-06-14T08:55:58+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hysp
[2022-06-14T08:55:58+08:00][sql] CONNECT:[ UseTime:0.000633s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:55:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_material` [ RunTime:0.001467s ]
[2022-06-14T08:55:58+08:00][sql] SELECT `vid` FROM `yl_standing_book_material` WHERE  `standing_book_id` = 21 [ RunTime:0.000406s ]
[2022-06-14T08:56:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:56:00+08:00][sql] CONNECT:[ UseTime:0.000598s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000785s ]
[2022-06-14T08:56:00+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 21 LIMIT 1 [ RunTime:0.000284s ]
[2022-06-14T08:56:02+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:56:02+08:00][sql] CONNECT:[ UseTime:0.000498s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000766s ]
[2022-06-14T08:56:02+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 20 LIMIT 1 [ RunTime:0.000362s ]
[2022-06-14T08:56:03+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2022-06-14T08:56:03+08:00][sql] CONNECT:[ UseTime:0.000529s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.000905s ]
[2022-06-14T08:56:03+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 20 [ RunTime:0.000398s ]
[2022-06-14T08:56:04+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hysp
[2022-06-14T08:56:04+08:00][sql] CONNECT:[ UseTime:0.000552s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_material` [ RunTime:0.000735s ]
[2022-06-14T08:56:04+08:00][sql] SELECT `vid` FROM `yl_standing_book_material` WHERE  `standing_book_id` = 20 [ RunTime:0.000390s ]
[2022-06-14T08:56:04+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2022-06-14T08:56:04+08:00][sql] CONNECT:[ UseTime:0.000429s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.000663s ]
[2022-06-14T08:56:04+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 20 [ RunTime:0.000295s ]
[2022-06-14T08:56:05+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hysp
[2022-06-14T08:56:05+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_material` [ RunTime:0.001012s ]
[2022-06-14T08:56:05+08:00][sql] SELECT `vid` FROM `yl_standing_book_material` WHERE  `standing_book_id` = 20 [ RunTime:0.000463s ]
[2022-06-14T08:56:07+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:56:07+08:00][sql] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000712s ]
[2022-06-14T08:56:07+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 19 LIMIT 1 [ RunTime:0.000342s ]
[2022-06-14T08:56:08+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2022-06-14T08:56:08+08:00][sql] CONNECT:[ UseTime:0.000466s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.000660s ]
[2022-06-14T08:56:08+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 19 [ RunTime:0.000532s ]
[2022-06-14T08:56:09+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hysp
[2022-06-14T08:56:09+08:00][sql] CONNECT:[ UseTime:0.000444s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_material` [ RunTime:0.000663s ]
[2022-06-14T08:56:09+08:00][sql] SELECT `vid` FROM `yl_standing_book_material` WHERE  `standing_book_id` = 19 [ RunTime:0.000348s ]
[2022-06-14T08:56:11+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:56:11+08:00][sql] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000902s ]
[2022-06-14T08:56:11+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 12 LIMIT 1 [ RunTime:0.000442s ]
[2022-06-14T08:56:12+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/drxc
[2022-06-14T08:56:12+08:00][sql] CONNECT:[ UseTime:0.000506s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_photo` [ RunTime:0.000665s ]
[2022-06-14T08:56:12+08:00][sql] SELECT `title`,`path` FROM `yl_standing_book_photo` WHERE  `standing_book_id` = 12 [ RunTime:0.000387s ]
[2022-06-14T08:56:14+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hysp
[2022-06-14T08:56:14+08:00][sql] CONNECT:[ UseTime:0.000516s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_material` [ RunTime:0.000825s ]
[2022-06-14T08:56:14+08:00][sql] SELECT `vid` FROM `yl_standing_book_material` WHERE  `standing_book_id` = 12 [ RunTime:0.000403s ]
[2022-06-14T08:56:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydh
[2022-06-14T08:56:31+08:00][sql] CONNECT:[ UseTime:0.000587s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000790s ]
[2022-06-14T08:56:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '党员大会'  AND `organ_id` = 2 [ RunTime:0.000376s ]
[2022-06-14T08:56:31+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.000426s ]
[2022-06-14T08:56:32+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T08:56:32+08:00][sql] CONNECT:[ UseTime:0.000548s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001113s ]
[2022-06-14T08:56:32+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` = 61 [ RunTime:0.001097s ]
[2022-06-14T08:56:36+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:56:36+08:00][sql] CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000695s ]
[2022-06-14T08:56:36+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000342s ]
[2022-06-14T08:56:52+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dzwd
[2022-06-14T08:56:52+08:00][sql] CONNECT:[ UseTime:0.000416s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_documents` [ RunTime:0.000790s ]
[2022-06-14T08:56:52+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` = '61' [ RunTime:0.000653s ]
[2022-06-14T08:56:52+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hyjl
[2022-06-14T08:56:52+08:00][sql] CONNECT:[ UseTime:0.000446s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_note` [ RunTime:0.000774s ]
[2022-06-14T08:56:52+08:00][sql] SELECT `person`,`content` FROM `yl_standing_book_note` WHERE  `standing_book_id` = 61 LIMIT 1 [ RunTime:0.000403s ]
[2022-06-14T08:56:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/bjqk
[2022-06-14T08:56:57+08:00][sql] CONNECT:[ UseTime:0.000561s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000923s ]
[2022-06-14T08:56:57+08:00][sql] SELECT `consult_id`,`vote_id` FROM `yl_standing_book_vote` WHERE  `standing_book_id` = 61 LIMIT 1 [ RunTime:0.000422s ]
[2022-06-14T08:56:58+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hyjl
[2022-06-14T08:56:58+08:00][sql] CONNECT:[ UseTime:0.000446s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_note` [ RunTime:0.000596s ]
[2022-06-14T08:56:58+08:00][sql] SELECT `person`,`content` FROM `yl_standing_book_note` WHERE  `standing_book_id` = 61 LIMIT 1 [ RunTime:0.000212s ]
[2022-06-14T08:56:58+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dzwd
[2022-06-14T08:56:58+08:00][sql] CONNECT:[ UseTime:0.000371s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_documents` [ RunTime:0.000556s ]
[2022-06-14T08:56:58+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` = '61' [ RunTime:0.000449s ]
[2022-06-14T08:56:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:56:59+08:00][sql] CONNECT:[ UseTime:0.000537s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:56:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000878s ]
[2022-06-14T08:56:59+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000303s ]
[2022-06-14T08:57:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T08:57:00+08:00][sql] CONNECT:[ UseTime:0.000705s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001070s ]
[2022-06-14T08:57:00+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` = 61 [ RunTime:0.000644s ]
[2022-06-14T08:57:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T08:57:01+08:00][sql] CONNECT:[ UseTime:0.000453s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001123s ]
[2022-06-14T08:57:01+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` = 17 [ RunTime:0.001134s ]
[2022-06-14T08:57:04+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:57:04+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000797s ]
[2022-06-14T08:57:04+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 17 LIMIT 1 [ RunTime:0.000411s ]
[2022-06-14T08:57:06+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T08:57:06+08:00][sql] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000763s ]
[2022-06-14T08:57:06+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` = 17 [ RunTime:0.000489s ]
[2022-06-14T08:57:08+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T08:57:08+08:00][sql] CONNECT:[ UseTime:0.000577s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000824s ]
[2022-06-14T08:57:08+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 17 LIMIT 1 [ RunTime:0.000355s ]
[2022-06-14T08:57:11+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dzwd
[2022-06-14T08:57:11+08:00][sql] CONNECT:[ UseTime:0.000472s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_documents` [ RunTime:0.000715s ]
[2022-06-14T08:57:11+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` = '17' [ RunTime:0.000703s ]
[2022-06-14T08:57:12+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hyjl
[2022-06-14T08:57:12+08:00][sql] CONNECT:[ UseTime:0.000454s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_note` [ RunTime:0.000721s ]
[2022-06-14T08:57:12+08:00][sql] SELECT `person`,`content` FROM `yl_standing_book_note` WHERE  `standing_book_id` = 17 LIMIT 1 [ RunTime:0.000389s ]
[2022-06-14T08:57:24+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/bjqk
[2022-06-14T08:57:24+08:00][sql] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_vote` [ RunTime:0.000726s ]
[2022-06-14T08:57:24+08:00][sql] SELECT `consult_id`,`vote_id` FROM `yl_standing_book_vote` WHERE  `standing_book_id` = 17 LIMIT 1 [ RunTime:0.000399s ]
[2022-06-14T08:57:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_vote` [ RunTime:0.000633s ]
[2022-06-14T08:57:24+08:00][sql] SELECT `id`,`title` FROM `yl_vote` WHERE  `id` = 6 LIMIT 1 [ RunTime:0.000500s ]
[2022-06-14T08:57:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_vote_option` [ RunTime:0.000964s ]
[2022-06-14T08:57:24+08:00][sql] SELECT vote_id id,`title`,vote_number + vote_adj cnt FROM `yl_vote_option` WHERE  `vote_id` = 6 [ RunTime:0.000389s ]
[2022-06-14T08:57:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2022-06-14T08:57:29+08:00][sql] CONNECT:[ UseTime:0.000668s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001001s ]
[2022-06-14T08:57:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000496s ]
[2022-06-14T08:57:29+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.000364s ]
[2022-06-14T08:57:52+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/create
[2022-06-14T08:57:52+08:00][sql] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:57:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001105s ]
[2022-06-14T08:57:52+08:00][sql] SELECT `organ_name` FROM `yl_party_organ` WHERE  ( id='2' ) LIMIT 1 [ RunTime:0.000553s ]
[2022-06-14T08:57:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000673s ]
[2022-06-14T08:57:52+08:00][sql] INSERT INTO `yl_meeting` SET `title` = '裕隆党总支2022-06-14会议' , `organ_id` = 2 , `start_time` = '2022-06-14 08:57:52' , `address` = '线上会议' , `identifier` = 343565 , `uuid` = '2' [ RunTime:0.000466s ]
[2022-06-14T08:58:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login
[2022-06-14T08:58:29+08:00][sql] CONNECT:[ UseTime:0.000586s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000743s ]
[2022-06-14T08:58: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='4ced539131f2e271' ) LIMIT 1 [ RunTime:0.000408s ]
[2022-06-14T08:58:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index
[2022-06-14T08:58:29+08:00][sql] CONNECT:[ UseTime:0.000355s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000724s ]
[2022-06-14T08:58:29+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE  `organ_id` = 2  AND `end_time` <= '2022-06-14 08:58:29'  AND `status` = '已审核' [ RunTime:0.000404s ]
[2022-06-14T08:58:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000521s ]
[2022-06-14T08:58:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' [ RunTime:0.000224s ]
[2022-06-14T08:58: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.000221s ]
[2022-06-14T08:58:29+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000197s ]
[2022-06-14T08:58:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update
[2022-06-14T08:58:29+08:00][sql] CONNECT:[ UseTime:0.000725s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.000796s ]
[2022-06-14T08:58:29+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE  ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000277s ]
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.000439s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001273s ]
[2022-06-14T08:58:31+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党小组会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000519s ]
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000601s ]
[2022-06-14T08:58:31+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000254s ]
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.000348s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000959s ]
[2022-06-14T08:58:31+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党课'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000696s ]
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000592s ]
[2022-06-14T08:58:31+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000575s ]
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwhPeople
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydhPeople
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.000406s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000807s ]
[2022-06-14T08:58:31+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000439s ]
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000593s ]
[2022-06-14T08:58:31+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000188s ]
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.011386s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000734s ]
[2022-06-14T08:58:31+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000430s ]
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000571s ]
[2022-06-14T08:58:31+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000190s ]
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.011818s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000769s ]
[2022-06-14T08:58:31+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党员大会'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000726s ]
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000576s ]
[2022-06-14T08:58:31+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000194s ]
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerList
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.000414s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000678s ]
[2022-06-14T08:58:31+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` IN ('党员大会','支委会','党小组会','党课')  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000446s ]
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerAnalyze
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.000348s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000802s ]
[2022-06-14T08:58:31+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000372s ]
[2022-06-14T08:58:31+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.000487s ]
[2022-06-14T08:58:31+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.000427s ]
[2022-06-14T08:58:31+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.000418s ]
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.000338s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000741s ]
[2022-06-14T08:58:31+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` = '2022' [ RunTime:0.000615s ]
[2022-06-14T08:58:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration
[2022-06-14T08:58:31+08:00][sql] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000829s ]
[2022-06-14T08:58:31+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND `organ_id` = 2  AND ( date_format(start_time, "%Y") = 2022 ) [ RunTime:0.000413s ]
[2022-06-14T08:58:36+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zbcy
[2022-06-14T08:58:36+08:00][sql] CONNECT:[ UseTime:0.000481s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000911s ]
[2022-06-14T08:58:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE  `position` <> '无'  AND `organ_id` = 2 [ RunTime:0.000403s ]
[2022-06-14T08:58:36+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.000577s ]
[2022-06-14T08:58:39+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerListDetail
[2022-06-14T08:58:39+08:00][sql] CONNECT:[ UseTime:0.000528s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000782s ]
[2022-06-14T08:58:39+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 and t5.years=2022 WHERE  `t1`.`uuid` = 'f7721013e39a4306a0dd96b9ae9589a3' LIMIT 1 [ RunTime:0.001046s ]
[2022-06-14T08:58:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.000673s ]
[2022-06-14T08:58:39+08:00][sql] SELECT `pid` FROM `yl_region` WHERE  `code` = '330102001051' LIMIT 1 [ RunTime:0.000393s ]
[2022-06-14T08:58:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.000555s ]
[2022-06-14T08:58:39+08:00][sql] SELECT GROUP_CONCAT(name) as name FROM `yl_party_bd_resource` WHERE  `id` IN (8,7) LIMIT 1 [ RunTime:0.000473s ]
[2022-06-14T08:58:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerListDetail
[2022-06-14T08:58:43+08:00][sql] CONNECT:[ UseTime:0.000473s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000747s ]
[2022-06-14T08:58:43+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 and t5.years=2022 WHERE  `t1`.`uuid` = '1a8340ec19e14853940889cb7753937d' LIMIT 1 [ RunTime:0.000751s ]
[2022-06-14T08:58:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.000497s ]
[2022-06-14T08:58:43+08:00][sql] SELECT `pid` FROM `yl_region` WHERE  `code` = '330102001051' LIMIT 1 [ RunTime:0.000392s ]
[2022-06-14T08:58:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.000513s ]
[2022-06-14T08:58:43+08:00][sql] SELECT GROUP_CONCAT(name) as name FROM `yl_party_bd_resource` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000371s ]
[2022-06-14T08:58:48+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerListDetail
[2022-06-14T08:58:48+08:00][sql] CONNECT:[ UseTime:0.000444s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000761s ]
[2022-06-14T08:58:48+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 and t5.years=2022 WHERE  `t1`.`uuid` = 'c845765990724681b9acbf465bd8329b' LIMIT 1 [ RunTime:0.000834s ]
[2022-06-14T08:58:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.000567s ]
[2022-06-14T08:58:48+08:00][sql] SELECT `pid` FROM `yl_region` WHERE  `code` = '330102001051' LIMIT 1 [ RunTime:0.000294s ]
[2022-06-14T08:58:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.000621s ]
[2022-06-14T08:58:48+08:00][sql] SELECT GROUP_CONCAT(name) as name FROM `yl_party_bd_resource` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000298s ]
[2022-06-14T08:58:51+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zzjg
[2022-06-14T08:58:52+08:00][sql] CONNECT:[ UseTime:0.000478s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000874s ]
[2022-06-14T08:58:52+08:00][sql] SELECT `pics` FROM `yl_party_organ` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000383s ]
[2022-06-14T08:58:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/dyfc
[2022-06-14T08:58:56+08:00][sql] CONNECT:[ UseTime:0.000696s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:58:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000800s ]
[2022-06-14T08:58:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE  `type` = '正式党员'  AND `organ_id` = 2 [ RunTime:0.000395s ]
[2022-06-14T08:58:56+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  `type` = '正式党员'  AND `organ_id` = 2 LIMIT 0,10 [ RunTime:0.000559s ]
[2022-06-14T08:59:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/zhibudongtai
[2022-06-14T08:59:01+08:00][sql] CONNECT:[ UseTime:0.000635s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:59:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000951s ]
[2022-06-14T08:59:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '25'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000735s ]
[2022-06-14T08:59:01+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE  `node_id` = '25'  AND `status` = '上线'  AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000658s ]
[2022-06-14T08:59:20+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/dfjn
[2022-06-14T08:59:20+08:00][sql] CONNECT:[ UseTime:0.000453s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:59:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000812s ]
[2022-06-14T08:59:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues` [ RunTime:0.000841s ]
[2022-06-14T08:59:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_dues` WHERE  `years` = '2022' [ RunTime:0.000379s ]
[2022-06-14T08:59:21+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/dyfz
[2022-06-14T08:59:21+08:00][sql] CONNECT:[ UseTime:0.000541s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:59:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000771s ]
[2022-06-14T08:59:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE  `type` IN ('预备党员','入党积极分子')  AND `organ_id` = 2 [ RunTime:0.000580s ]
[2022-06-14T08:59:21+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  `type` IN ('预备党员','入党积极分子')  AND `organ_id` = 2 LIMIT 0,10 [ RunTime:0.000604s ]
[2022-06-14T08:59:23+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerListDetail
[2022-06-14T08:59:23+08:00][sql] CONNECT:[ UseTime:0.000483s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:59:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000722s ]
[2022-06-14T08:59:23+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 and t5.years=2022 WHERE  `t1`.`uuid` = '41d2bdd8dfd2496881eff72bb79c1684' LIMIT 1 [ RunTime:0.000725s ]
[2022-06-14T08:59:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.000449s ]
[2022-06-14T08:59:23+08:00][sql] SELECT `pid` FROM `yl_region` WHERE  `code` = '330102001051' LIMIT 1 [ RunTime:0.000175s ]
[2022-06-14T08:59:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.000603s ]
[2022-06-14T08:59:23+08:00][sql] SELECT GROUP_CONCAT(name) as name FROM `yl_party_bd_resource` WHERE  `id` = 6 LIMIT 1 [ RunTime:0.000465s ]
[2022-06-14T08:59:28+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zbcy
[2022-06-14T08:59:28+08:00][sql] CONNECT:[ UseTime:0.000622s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:59:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001044s ]
[2022-06-14T08:59:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE  `position` <> '无'  AND `organ_id` = 2 [ RunTime:0.000384s ]
[2022-06-14T08:59:28+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.000382s ]
[2022-06-14T08:59:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangjianzixun
[2022-06-14T08:59:29+08:00][sql] CONNECT:[ UseTime:0.000564s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:59:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000798s ]
[2022-06-14T08:59:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000426s ]
[2022-06-14T08:59:29+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.000745s ]
[2022-06-14T08:59:53+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zbcy
[2022-06-14T08:59:53+08:00][sql] CONNECT:[ UseTime:0.000440s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T08:59:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000745s ]
[2022-06-14T08:59:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE  `position` <> '无'  AND `organ_id` = 2 [ RunTime:0.000327s ]
[2022-06-14T08:59:53+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.000325s ]
[2022-06-14T09:47:49+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login
[2022-06-14T09:47:49+08:00][sql] CONNECT:[ UseTime:0.000423s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:47:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000876s ]
[2022-06-14T09:47:49+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='4ced539131f2e271' ) LIMIT 1 [ RunTime:0.000467s ]
[2022-06-14T09:47:49+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index
[2022-06-14T09:47:49+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update
[2022-06-14T09:47:49+08:00][sql] CONNECT:[ UseTime:0.000384s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:47:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000897s ]
[2022-06-14T09:47:49+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE  `organ_id` = 2  AND `end_time` <= '2022-06-14 09:47:49'  AND `status` = '已审核' [ RunTime:0.000409s ]
[2022-06-14T09:47:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000582s ]
[2022-06-14T09:47:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE  `organ_id` = 2  AND `status` = '待办' [ RunTime:0.000201s ]
[2022-06-14T09:47:49+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.000217s ]
[2022-06-14T09:47:49+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000205s ]
[2022-06-14T09:47:49+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:47:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.000886s ]
[2022-06-14T09:47:49+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE  ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
[2022-06-14T09:48:16+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/dangwei
[2022-06-14T09:48:16+08:00][sql] CONNECT:[ UseTime:0.000435s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.000846s ]
[2022-06-14T09:48:16+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE  `node_id` = 27 [ RunTime:0.000343s ]
[2022-06-14T09:48:16+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei
[2022-06-14T09:48:16+08:00][sql] CONNECT:[ UseTime:0.000415s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000880s ]
[2022-06-14T09:48:16+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.000247s ]
[2022-06-14T09:48:16+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.000414s ]
[2022-06-14T09:48:19+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/read
[2022-06-14T09:48:19+08:00][sql] CONNECT:[ UseTime:0.000617s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001105s ]
[2022-06-14T09:48:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000612s ]
[2022-06-14T09:48:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.000483s ]
[2022-06-14T09:48:19+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime` FROM `yl_task_queue` WHERE  `status` = '待办'  AND `id` = 45  AND `organ_id` = 2 LIMIT 1 [ RunTime:0.000547s ]
[2022-06-14T09:48:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000813s ]
[2022-06-14T09:48:19+08:00][sql] SELECT `id`,`icon`,`theme`,`type`,`start_time`,`end_time`,`agenda`,`hoster`,`address`,`scope`,`organ_id`,`uuid`,`ctime`,`sign_qrcode` FROM `yl_standing_book` WHERE  `id` = 61 LIMIT 1 [ RunTime:0.000505s ]
[2022-06-14T09:48:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_documents` [ RunTime:0.000967s ]
[2022-06-14T09:48:19+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` = '61' [ RunTime:0.000600s ]
[2022-06-14T09:48:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000834s ]
[2022-06-14T09:48:19+08:00][sql] SELECT `id`,`uuid` FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` = 61 [ RunTime:0.000497s ]
[2022-06-14T09:48:19+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:48:19+08:00][sql] CONNECT:[ UseTime:0.000456s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000826s ]
[2022-06-14T09:48:19+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` = 61 [ RunTime:0.000380s ]
[2022-06-14T09:48:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:48:29+08:00][sql] CONNECT:[ UseTime:0.000586s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000791s ]
[2022-06-14T09:48:29+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` = 61 [ RunTime:0.000411s ]
[2022-06-14T09:48:39+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:48:39+08:00][sql] CONNECT:[ UseTime:0.000565s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000769s ]
[2022-06-14T09:48:39+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` = 61 [ RunTime:0.000568s ]
[2022-06-14T09:48:49+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:48:49+08:00][sql] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001003s ]
[2022-06-14T09:48:49+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` = 61 [ RunTime:0.000451s ]
[2022-06-14T09:48:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:48:59+08:00][sql] CONNECT:[ UseTime:0.000504s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:48:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000765s ]
[2022-06-14T09:48:59+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` = 61 [ RunTime:0.000409s ]
[2022-06-14T09:49:09+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:49:09+08:00][sql] CONNECT:[ UseTime:0.000551s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:49:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000815s ]
[2022-06-14T09:49:09+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` = 61 [ RunTime:0.000356s ]
[2022-06-14T09:49:19+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:49:19+08:00][sql] CONNECT:[ UseTime:0.000445s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:49:19+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000800s ]
[2022-06-14T09:49:19+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` = 61 [ RunTime:0.000424s ]
[2022-06-14T09:49:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:49:29+08:00][sql] CONNECT:[ UseTime:0.000592s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:49:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000737s ]
[2022-06-14T09:49:29+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` = 61 [ RunTime:0.000466s ]
[2022-06-14T09:49:39+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:49:39+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:49:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000746s ]
[2022-06-14T09:49:39+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` = 61 [ RunTime:0.000378s ]
[2022-06-14T09:49:49+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:49:49+08:00][sql] CONNECT:[ UseTime:0.000422s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:49:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000691s ]
[2022-06-14T09:49:49+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` = 61 [ RunTime:0.000354s ]
[2022-06-14T09:49:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:49:59+08:00][sql] CONNECT:[ UseTime:0.000627s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:49:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001011s ]
[2022-06-14T09:49:59+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` = 61 [ RunTime:0.000532s ]
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerAnalyze
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydhPeople
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwhPeople
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.000276s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000947s ]
[2022-06-14T09:53:56+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000342s ]
[2022-06-14T09:53: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.000444s ]
[2022-06-14T09:53: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.000208s ]
[2022-06-14T09:53: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.000212s ]
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.011693s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001089s ]
[2022-06-14T09:53: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") = 2022 ) [ RunTime:0.000314s ]
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000604s ]
[2022-06-14T09:53:56+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000209s ]
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.011453s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000903s ]
[2022-06-14T09:53: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") = 2022 ) [ RunTime:0.000340s ]
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000640s ]
[2022-06-14T09:53:56+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000210s ]
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.010537s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000823s ]
[2022-06-14T09:53: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") = 2022 ) [ RunTime:0.000302s ]
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001050s ]
[2022-06-14T09:53:56+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000212s ]
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerList
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.006100s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000697s ]
[2022-06-14T09:53: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") = 2022 ) [ RunTime:0.011006s ]
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000842s ]
[2022-06-14T09:53:56+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.000239s ]
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.003625s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000917s ]
[2022-06-14T09:53: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") = 2022 ) [ RunTime:0.000403s ]
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.005150s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000780s ]
[2022-06-14T09:53: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") = 2022 ) [ RunTime:0.000335s ]
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000802s ]
[2022-06-14T09:53:56+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  0 = 1 GROUP BY `status` [ RunTime:0.001098s ]
[2022-06-14T09:53:56+08:00][sql] CONNECT:[ UseTime:0.000542s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000846s ]
[2022-06-14T09:53: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` = '2022' [ RunTime:0.000503s ]
[2022-06-14T09:53:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration
[2022-06-14T09:53:57+08:00][sql] CONNECT:[ UseTime:0.000546s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:53:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000834s ]
[2022-06-14T09:53: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") = 2022 ) [ RunTime:0.000406s ]
[2022-06-14T09:54:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index
[2022-06-14T09:54:01+08:00][sql] CONNECT:[ UseTime:0.000546s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000980s ]
[2022-06-14T09:54:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE  `organ_id` = 2 [ RunTime:0.000484s ]
[2022-06-14T09:54: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.000496s ]
[2022-06-14T09:54:11+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangjianzixun
[2022-06-14T09:54:12+08:00][sql] CONNECT:[ UseTime:0.000489s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000936s ]
[2022-06-14T09:54:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线'  AND `organ_id` = 2 [ RunTime:0.000299s ]
[2022-06-14T09:54:12+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.000327s ]
[2022-06-14T09:54:35+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydh
[2022-06-14T09:54:35+08:00][sql] CONNECT:[ UseTime:0.000435s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000766s ]
[2022-06-14T09:54:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '党员大会'  AND `organ_id` = 2 [ RunTime:0.000480s ]
[2022-06-14T09:54:35+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.000269s ]
[2022-06-14T09:54:36+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwh
[2022-06-14T09:54:36+08:00][sql] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000906s ]
[2022-06-14T09:54:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `organ_id` = 2 [ RunTime:0.000596s ]
[2022-06-14T09:54:36+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.000515s ]
[2022-06-14T09:54:36+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzh
[2022-06-14T09:54:36+08:00][sql] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000795s ]
[2022-06-14T09:54:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '党小组会'  AND `organ_id` = 2 [ RunTime:0.000523s ]
[2022-06-14T09:54:36+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 ]
[2022-06-14T09:54:38+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:54:38+08:00][sql] CONNECT:[ UseTime:0.000497s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000831s ]
[2022-06-14T09:54:38+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` = 16 [ RunTime:0.000938s ]
[2022-06-14T09:54:39+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T09:54:39+08:00][sql] CONNECT:[ UseTime:0.000495s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000818s ]
[2022-06-14T09:54:39+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 16 LIMIT 1 [ RunTime:0.000456s ]
[2022-06-14T09:54:40+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dzwd
[2022-06-14T09:54:40+08:00][sql] CONNECT:[ UseTime:0.000456s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_documents` [ RunTime:0.000772s ]
[2022-06-14T09:54:40+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` = '16' [ RunTime:0.007610s ]
[2022-06-14T09:54:40+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hyjl
[2022-06-14T09:54:40+08:00][sql] CONNECT:[ UseTime:0.000424s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_note` [ RunTime:0.000787s ]
[2022-06-14T09:54:40+08:00][sql] SELECT `person`,`content` FROM `yl_standing_book_note` WHERE  `standing_book_id` = 16 LIMIT 1 [ RunTime:0.000584s ]
[2022-06-14T09:54:54+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwh
[2022-06-14T09:54:54+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000788s ]
[2022-06-14T09:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `organ_id` = 2 [ RunTime:0.000310s ]
[2022-06-14T09:54:54+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.000230s ]
[2022-06-14T09:54:56+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzh
[2022-06-14T09:54:56+08:00][sql] CONNECT:[ UseTime:0.000588s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000859s ]
[2022-06-14T09:54:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '党小组会'  AND `organ_id` = 2 [ RunTime:0.000328s ]
[2022-06-14T09:54:56+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.000233s ]
[2022-06-14T09:54:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwh
[2022-06-14T09:54:57+08:00][sql] CONNECT:[ UseTime:0.000465s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001134s ]
[2022-06-14T09:54:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `organ_id` = 2 [ RunTime:0.000394s ]
[2022-06-14T09:54:57+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.000327s ]
[2022-06-14T09:54:59+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkqk
[2022-06-14T09:54:59+08:00][sql] CONNECT:[ UseTime:0.000488s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:54:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000759s ]
[2022-06-14T09:54:59+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` = 18 [ RunTime:0.000874s ]
[2022-06-14T09:55:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/xxap
[2022-06-14T09:55:00+08:00][sql] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:55:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000919s ]
[2022-06-14T09:55:00+08:00][sql] SELECT `theme`,`start_time`,`hoster`,`agenda`,`scope` FROM `yl_standing_book` WHERE  `id` = 18 LIMIT 1 [ RunTime:0.000400s ]
[2022-06-14T09:55:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dzwd
[2022-06-14T09:55:00+08:00][sql] CONNECT:[ UseTime:0.000496s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:55:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_documents` [ RunTime:0.000675s ]
[2022-06-14T09:55:00+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` = '18' [ RunTime:0.000880s ]
[2022-06-14T09:55:00+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/hyjl
[2022-06-14T09:55:00+08:00][sql] CONNECT:[ UseTime:0.000574s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T09:55:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_note` [ RunTime:0.000747s ]
[2022-06-14T09:55:00+08:00][sql] SELECT `person`,`content` FROM `yl_standing_book_note` WHERE  `standing_book_id` = 18 LIMIT 1 [ RunTime:0.000681s ]
[2022-06-14T10:00:53+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zbcy
[2022-06-14T10:00:53+08:00][sql] CONNECT:[ UseTime:0.000533s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T10:00:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000808s ]
[2022-06-14T10:00:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE  `position` <> '无'  AND `organ_id` = 2 [ RunTime:0.000331s ]
[2022-06-14T10:00:53+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.000420s ]
[2022-06-14T10:01:31+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerListDetail
[2022-06-14T10:01:31+08:00][sql] CONNECT:[ UseTime:0.000518s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2022-06-14T10:01:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001030s ]
[2022-06-14T10:01:31+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 and t5.years=2022 WHERE  `t1`.`uuid` = 'f7721013e39a4306a0dd96b9ae9589a3' LIMIT 1 [ RunTime:0.000914s ]
[2022-06-14T10:01:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_region` [ RunTime:0.001025s ]
[2022-06-14T10:01:31+08:00][sql] SELECT `pid` FROM `yl_region` WHERE  `code` = '330102001051' LIMIT 1 [ RunTime:0.000702s ]
[2022-06-14T10:01:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_bd_resource` [ RunTime:0.000762s ]
[2022-06-14T10:01:31+08:00][sql] SELECT GROUP_CONCAT(name) as name FROM `yl_party_bd_resource` WHERE  `id` IN (8,7) LIMIT 1 [ RunTime:0.000309s ]