[2021-08-31T16:14:43+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:14:59+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:17:25+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:18:14+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:18:30+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:22:28+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:23:14+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:25:09+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:25:50+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:52:33+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:52:33+08:00][error] [0]openssl_pkcs12_export_to_file() expects at least 4 parameters, 3 given[/home/htdocs/dangjian/app/common/OpenSSL.php:37] [2021-08-31T16:53:21+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:53:33+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:55:37+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:55:37+08:00][error] [2]openssl_private_encrypt(): key param is not a valid private key[/home/htdocs/dangjian/app/common/OpenSSL.php:54] [2021-08-31T16:58:47+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:58:47+08:00][error] [2]openssl_private_encrypt(): key param is not a valid private key[/home/htdocs/dangjian/app/common/OpenSSL.php:54] [2021-08-31T16:59:22+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:59:22+08:00][error] [2]openssl_private_decrypt(): key array must be of the form array(0 => key, 1 => phrase)[/home/htdocs/dangjian/app/common/OpenSSL.php:97] [2021-08-31T16:59:56+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T16:59:56+08:00][error] [2]openssl_private_decrypt(): key parameter is not a valid private key[/home/htdocs/dangjian/app/common/OpenSSL.php:97] [2021-08-31T17:00:35+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T17:00:35+08:00][error] [2]openssl_private_decrypt(): key array must be of the form array(0 => key, 1 => phrase)[/home/htdocs/dangjian/app/common/OpenSSL.php:98] [2021-08-31T17:01:14+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T17:01:14+08:00][error] [2]openssl_private_decrypt(): key array must be of the form array(0 => key, 1 => phrase)[/home/htdocs/dangjian/app/common/OpenSSL.php:99] [2021-08-31T17:01:30+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T17:12:18+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T17:44:44+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T17:44:44+08:00][debug] middleware/Authorise: handle | login verify failed | login info = jwt header HTTP_AUTHORIZATION empty! [2021-08-31T17:44:45+08:00][debug] middleware/Authorise: handle | request path = CallBack/test [2021-08-31T17:44:45+08:00][debug] middleware/Authorise: handle | login verify failed | login info = jwt header HTTP_AUTHORIZATION empty! [2021-08-31T22:20:14+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-08-31T22:20:14+08:00][sql] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:20:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.008780s ] [2021-08-31T22:20:14+08:00][sql] SELECT `t3`.`organ_name`,`t2`.`organ_id`,`t1`.`uuid` FROM `yl_user_card` `t1` LEFT JOIN `yl_user_party` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_organ` `t3` ON `t2`.`organ_id`=`t3`.`id` WHERE ( stbid='3a95e60211d5b78d' ) LIMIT 1 [ RunTime:0.019911s ] [2021-08-31T22:20:14+08:00][debug] middleware/Authorise: handle | request path = api.tv.Task/index [2021-08-31T22:20:15+08:00][sql] CONNECT:[ UseTime:0.000605s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:20:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.004883s ] [2021-08-31T22:20:15+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-08-31 22:20:14' AND `status` = '已审核' [ RunTime:0.003748s ] [2021-08-31T22:20:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.001097s ] [2021-08-31T22:20:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.003784s ] [2021-08-31T22:20:15+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime`,`organ_type` FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' ORDER BY field(organ_type,'上级党委或党工委','党委','党总支','党支部','其他'),`ctime` DESC [ RunTime:0.003864s ] [2021-08-31T22:20:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.005549s ] [2021-08-31T22:20:15+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 18 LIMIT 1 [ RunTime:0.003252s ] [2021-08-31T22:20:15+08:00][sql] SELECT `icon`,`agenda` FROM `yl_standing_book` WHERE `id` = 61 LIMIT 1 [ RunTime:0.000545s ] [2021-08-31T22:20:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.001130s ] [2021-08-31T22:20:15+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 17 LIMIT 1 [ RunTime:0.004068s ] [2021-08-31T22:20:15+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000420s ] [2021-08-31T22:20:15+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000582s ] [2021-08-31T22:20:15+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000353s ] [2021-08-31T22:20:15+08:00][debug] middleware/Authorise: handle | request path = api.tv.AppEdition/update [2021-08-31T22:20:15+08:00][sql] CONNECT:[ UseTime:0.000642s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:20:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_app_edition` [ RunTime:0.003160s ] [2021-08-31T22:20:15+08:00][sql] SELECT `app_number`,`app_urls` FROM `yl_app_edition` WHERE ( app_type="tv" ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003631s ] [2021-08-31T22:20:50+08:00][debug] middleware/Authorise: handle | request path = api.tv.Meeting/index [2021-08-31T22:20:50+08:00][sql] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:20:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.000868s ] [2021-08-31T22:20:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting` WHERE `organ_id` = 2 [ RunTime:0.000383s ] [2021-08-31T22:20:50+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.000385s ] [2021-08-31T22:21:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerAnalyze [2021-08-31T22:21:29+08:00][sql] CONNECT:[ UseTime:0.002615s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001227s ] [2021-08-31T22:21:29+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000701s ] [2021-08-31T22:21:29+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.005103s ] [2021-08-31T22:21:29+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.000512s ] [2021-08-31T22:21:29+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.000525s ] [2021-08-31T22:21:29+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zwhPeople [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000467s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000854s ] [2021-08-31T22:21:30+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.000490s ] [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000890s ] [2021-08-31T22:21:30+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.025661s ] [2021-08-31T22:21:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000727s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001013s ] [2021-08-31T22:21:30+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.000556s ] [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000719s ] [2021-08-31T22:21:30+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (11,15,24,25) GROUP BY `status` [ RunTime:0.001473s ] [2021-08-31T22:21:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000558s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001172s ] [2021-08-31T22:21:30+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.000643s ] [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000914s ] [2021-08-31T22:21:30+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.000671s ] [2021-08-31T22:21:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000961s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000948s ] [2021-08-31T22:21:30+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.000567s ] [2021-08-31T22:21:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000645s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000961s ] [2021-08-31T22:21:30+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.000488s ] [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000583s ] [2021-08-31T22:21:30+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 16 GROUP BY `status` [ RunTime:0.000619s ] [2021-08-31T22:21:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/partnerList [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000533s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000955s ] [2021-08-31T22:21:30+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.005193s ] [2021-08-31T22:21:30+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.001357s ] [2021-08-31T22:21:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001196s ] [2021-08-31T22:21:30+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.000691s ] [2021-08-31T22:21:30+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydhPeople [2021-08-31T22:21:30+08:00][sql] CONNECT:[ UseTime:0.000614s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000926s ] [2021-08-31T22:21:30+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.000555s ] [2021-08-31T22:21:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001089s ] [2021-08-31T22:21:30+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 17 GROUP BY `status` [ RunTime:0.001146s ] [2021-08-31T22:21:36+08:00][debug] middleware/Authorise: handle | request path = api.tv.UserParty/zbcy [2021-08-31T22:21:36+08:00][sql] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001191s ] [2021-08-31T22:21:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE `position` <> '无' AND `organ_id` = 2 [ RunTime:0.000488s ] [2021-08-31T22:21: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.000594s ] [2021-08-31T22:21:41+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangjianzixun [2021-08-31T22:21:41+08:00][sql] CONNECT:[ UseTime:0.000472s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:41+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.004483s ] [2021-08-31T22:21:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.008051s ] [2021-08-31T22:21:41+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.001099s ] [2021-08-31T22:21:54+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dydh [2021-08-31T22:21:54+08:00][sql] CONNECT:[ UseTime:0.000745s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:21:54+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001075s ] [2021-08-31T22:21:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' AND `organ_id` = 2 [ RunTime:0.000445s ] [2021-08-31T22:21: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.000488s ] [2021-08-31T22:22:01+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdr [2021-08-31T22:22:01+08:00][sql] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000897s ] [2021-08-31T22:22:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '主题党日' AND `organ_id` = 2 [ RunTime:0.000381s ] [2021-08-31T22:22:01+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 ] [2021-08-31T22:22:04+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/dangwei [2021-08-31T22:22:04+08:00][sql] CONNECT:[ UseTime:0.000730s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.001252s ] [2021-08-31T22:22:04+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE `node_id` = 27 [ RunTime:0.003489s ] [2021-08-31T22:22:05+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:05+08:00][sql] CONNECT:[ UseTime:0.000476s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000984s ] [2021-08-31T22:22:05+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.000784s ] [2021-08-31T22:22:05+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.000554s ] [2021-08-31T22:22:08+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:08+08:00][sql] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000946s ] [2021-08-31T22:22:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `tag_ids` = '2' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000465s ] [2021-08-31T22:22:08+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` = '2' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000468s ] [2021-08-31T22:22:11+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:11+08:00][sql] CONNECT:[ UseTime:0.000676s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000980s ] [2021-08-31T22:22:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `tag_ids` = '3' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000505s ] [2021-08-31T22:22:11+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` = '3' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000508s ] [2021-08-31T22:22:17+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:17+08:00][sql] CONNECT:[ UseTime:0.000715s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001395s ] [2021-08-31T22:22:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `tag_ids` = '7' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000662s ] [2021-08-31T22:22:17+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` = '7' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000595s ] [2021-08-31T22:22:24+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:24+08:00][sql] CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:24+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000966s ] [2021-08-31T22:22:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `tag_ids` = '3' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000401s ] [2021-08-31T22:22:24+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` = '3' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000371s ] [2021-08-31T22:22:25+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:25+08:00][sql] CONNECT:[ UseTime:0.000440s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000921s ] [2021-08-31T22:22:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `tag_ids` = '2' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000597s ] [2021-08-31T22:22:25+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` = '2' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000460s ] [2021-08-31T22:22:25+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:25+08:00][sql] CONNECT:[ UseTime:0.000613s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001032s ] [2021-08-31T22:22:25+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.000383s ] [2021-08-31T22:22:25+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.000392s ] [2021-08-31T22:22:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/zhibu [2021-08-31T22:22:26+08:00][sql] CONNECT:[ UseTime:0.000580s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.001493s ] [2021-08-31T22:22:26+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE `node_id` = 28 [ RunTime:0.000390s ] [2021-08-31T22:22:26+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/zhibu [2021-08-31T22:22:26+08:00][sql] CONNECT:[ UseTime:0.000641s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:26+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001120s ] [2021-08-31T22:22:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '28' AND `tag_ids` = '5' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000515s ] [2021-08-31T22:22:26+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE `node_id` = '28' AND `tag_ids` = '5' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000946s ] [2021-08-31T22:22:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.Tag/dangwei [2021-08-31T22:22:43+08:00][sql] CONNECT:[ UseTime:0.000723s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.001305s ] [2021-08-31T22:22:43+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE `node_id` = 27 [ RunTime:0.000406s ] [2021-08-31T22:22:43+08:00][debug] middleware/Authorise: handle | request path = api.tv.Content/dangwei [2021-08-31T22:22:44+08:00][sql] CONNECT:[ UseTime:0.000599s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:22:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000981s ] [2021-08-31T22:22:44+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.000354s ] [2021-08-31T22:22:44+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE `node_id` = '27' AND `tag_ids` = '1' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000441s ] [2021-08-31T22:44:49+08:00][debug] middleware/Authorise: handle | request path = api.tv.User/login [2021-08-31T22:44:49+08:00][sql] CONNECT:[ UseTime:0.000565s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-31T22:44:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001044s ] [2021-08-31T22:44: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='3a95e60211d5b78d' ) LIMIT 1 [ RunTime:0.000682s ]