[2021-08-03T00:52:26+08:00][debug] middleware/Authorise: handle | request path = /start [2021-08-03T00:52:26+08:00][debug] middleware/Authorise: handle | request path = php/explicit_not_exist_path [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/ [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/explicit_not_exist_path [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/4e5e5d7364f443e28fbf0d3ae744a59a [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpMyAdmin/?c=4e5e5d7364f443e28fbf0d3ae744a59a [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/ [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/explicit_not_exist_path [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/4e5e5d7364f443e28fbf0d3ae744a59a [2021-08-03T00:52:27+08:00][debug] middleware/Authorise: handle | request path = phpmyadmin/?c=4e5e5d7364f443e28fbf0d3ae744a59a [2021-08-03T00:52:28+08:00][debug] middleware/Authorise: handle | request path = wcm/ [2021-08-03T00:52:28+08:00][debug] middleware/Authorise: handle | request path = wcm/explicit_not_exist_path [2021-08-03T00:52:28+08:00][debug] middleware/Authorise: handle | request path = wcm/4e5e5d7364f443e28fbf0d3ae744a59a [2021-08-03T00:52:28+08:00][debug] middleware/Authorise: handle | request path = wcm/?c=4e5e5d7364f443e28fbf0d3ae744a59a [2021-08-03T17:30:55+08:00][debug] middleware/Authorise: handle | request path = user.UserLogin/login [2021-08-03T17:30:55+08:00][sql] CONNECT:[ UseTime:0.000495s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001193s ] [2021-08-03T17:30:55+08:00][sql] SELECT `t1`.`id`,`t1`.`passwd`,`t1`.`first_login`,`t1`.`is_on`,`t1`.`errtime`,`t1`.`errtimes`,`t1`.`sign_ip`,`t1`.`ban_time`,`t1`.`reason`,`t2`.`manage_organ_id`,`t2`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid`,`t3`.`organ_id`,`t3`.`photo`,`t3`.`position`,`t4`.`organ_name`,t5.account points FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` LEFT JOIN `yl_user_party` `t3` ON `t1`.`uuid`=`t3`.`uuid` LEFT JOIN `yl_party_organ` `t4` ON `t3`.`organ_id`=`t4`.`id` LEFT JOIN `yl_party_point` `t5` ON `t5`.`uuid`=`t1`.`uuid` WHERE ( t1.account='18999999999' and t5.years='2021' ) LIMIT 1 [ RunTime:0.005115s ] [2021-08-03T17:30:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001322s ] [2021-08-03T17:30:55+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000454s ] [2021-08-03T17:30:55+08:00][sql] UPDATE `yl_user_login` SET `is_on` = 'no' , `sign_ip` = 2104976657 , `errtime` = 0 , `errtimes` = 0 WHERE ( id='2' ) [ RunTime:0.000899s ] [2021-08-03T17:30:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.001001s ] [2021-08-03T17:30:55+08:00][sql] INSERT INTO `yl_user_login_logs` SET `uuid` = '4c8f125cd4334b248dceed93ee330685' , `sign_ip` = 125 , `ua` = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000447s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000948s ] [2021-08-03T17:30:57+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000283s ] [2021-08-03T17:30:57+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000285s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = node.NodeColumn/index [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000658s ] [2021-08-03T17:30:57+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000291s ] [2021-08-03T17:30:57+08:00][sql] SELECT * FROM `yl_node_column` `a` ORDER BY `a`.`sort` ASC [ RunTime:0.000376s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/shykDuration [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000523s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001627s ] [2021-08-03T17:30:57+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE `type` IN ('党员大会','支委会','党小组会','党课') AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000605s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dxzhPeople [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000617s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001187s ] [2021-08-03T17:30:57+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE `type` = '党小组会' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000405s ] [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001086s ] [2021-08-03T17:30:57+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 16 GROUP BY `status` [ RunTime:0.000317s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrPeople [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000653s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001332s ] [2021-08-03T17:30:57+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE `type` = '主题党日' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000459s ] [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000729s ] [2021-08-03T17:30:57+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (12,14,19,20,21,22) GROUP BY `status` [ RunTime:0.000296s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000415s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000835s ] [2021-08-03T17:30:57+08:00][sql] SELECT date_format(start_time, "%c") month, theme FROM `yl_standing_book` WHERE `type` = '支委会' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000715s ] [2021-08-03T17:30:57+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE `type` = '支委会' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000464s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/ztdrDuration [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000705s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000943s ] [2021-08-03T17:30:57+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE `type` = '主题党日' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000790s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/dkPeople [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000512s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001069s ] [2021-08-03T17:30:57+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE `type` = '党课' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000419s ] [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000812s ] [2021-08-03T17:30:57+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN (11,15) GROUP BY `status` [ RunTime:0.000561s ] [2021-08-03T17:30:57+08:00][debug] middleware/Authorise: handle | request path = api.tv.StandingBook/zbhDurationDetail [2021-08-03T17:30:57+08:00][sql] CONNECT:[ UseTime:0.000756s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:30:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001239s ] [2021-08-03T17:30:57+08:00][sql] SELECT date_format(start_time, "%c") month, theme FROM `yl_standing_book` WHERE `type` = '支委会' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000411s ] [2021-08-03T17:30:57+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE `type` = '支委会' AND `status` = '已完成' AND `organ_id` = 2 AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000350s ] [2021-08-03T17:31:02+08:00][debug] middleware/Authorise: handle | request path = activity.Activity/index [2021-08-03T17:31:02+08:00][sql] CONNECT:[ UseTime:0.000641s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:31:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity` [ RunTime:0.001321s ] [2021-08-03T17:31:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_activity` `a` LEFT JOIN `yl_activity_form` `b` ON `b`.`id`=`a`.`form_id` [ RunTime:0.000636s ] [2021-08-03T17:31:02+08:00][sql] SELECT `a`.*,b.name AS form_name FROM `yl_activity` `a` LEFT JOIN `yl_activity_form` `b` ON `b`.`id`=`a`.`form_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.001055s ] [2021-08-03T17:31:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001011s ] [2021-08-03T17:31:02+08:00][sql] SELECT `name`,`uuid` FROM `yl_user` WHERE `uuid` IN ('c845765990724681b9acbf465bd8329b','f7721013e39a4306a0dd96b9ae9589a3','4c8f125cd4334b248dceed93ee330685') [ RunTime:0.000494s ] [2021-08-03T17:31:02+08:00][debug] middleware/Authorise: handle | request path = activity.Activity/forms [2021-08-03T17:31:02+08:00][sql] CONNECT:[ UseTime:0.000536s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:31:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.001032s ] [2021-08-03T17:31:02+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000445s ] [2021-08-03T17:31:06+08:00][debug] middleware/Authorise: handle | request path = user.User/index [2021-08-03T17:31:06+08:00][sql] CONNECT:[ UseTime:0.000552s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:31:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001271s ] [2021-08-03T17:31:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000386s ] [2021-08-03T17:31:06+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000488s ] [2021-08-03T17:31:29+08:00][debug] middleware/Authorise: handle | request path = user.User/index [2021-08-03T17:31:29+08:00][sql] CONNECT:[ UseTime:0.000674s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:31:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001083s ] [2021-08-03T17:31:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000417s ] [2021-08-03T17:31:29+08:00][sql] SELECT * FROM `yl_user` LIMIT 10,10 [ RunTime:0.000847s ] [2021-08-03T17:31:30+08:00][debug] middleware/Authorise: handle | request path = user.User/index [2021-08-03T17:31:30+08:00][sql] CONNECT:[ UseTime:0.000518s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:31:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001236s ] [2021-08-03T17:31:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000376s ] [2021-08-03T17:31:30+08:00][sql] SELECT * FROM `yl_user` LIMIT 20,10 [ RunTime:0.000640s ] [2021-08-03T17:31:56+08:00][debug] middleware/Authorise: handle | request path = user.User/index [2021-08-03T17:31:56+08:00][sql] CONNECT:[ UseTime:0.000702s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:31:56+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001419s ] [2021-08-03T17:31:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000406s ] [2021-08-03T17:31:56+08:00][sql] SELECT * FROM `yl_user` LIMIT 10,10 [ RunTime:0.000518s ] [2021-08-03T17:31:58+08:00][debug] middleware/Authorise: handle | request path = user.User/index [2021-08-03T17:31:58+08:00][sql] CONNECT:[ UseTime:0.000580s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:31:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001089s ] [2021-08-03T17:31:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000251s ] [2021-08-03T17:31:58+08:00][sql] SELECT * FROM `yl_user` LIMIT 20,10 [ RunTime:0.000303s ] [2021-08-03T17:32:00+08:00][debug] middleware/Authorise: handle | request path = user.User/index [2021-08-03T17:32:00+08:00][sql] CONNECT:[ UseTime:0.000581s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:32:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000986s ] [2021-08-03T17:32:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000232s ] [2021-08-03T17:32:00+08:00][sql] SELECT * FROM `yl_user` LIMIT 10,10 [ RunTime:0.000635s ] [2021-08-03T17:32:03+08:00][debug] middleware/Authorise: handle | request path = user.User/index [2021-08-03T17:32:03+08:00][sql] CONNECT:[ UseTime:0.000532s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-03T17:32:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000956s ] [2021-08-03T17:32:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000192s ] [2021-08-03T17:32:03+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000324s ]