[2021-02-25T09:47:40+08:00][sql] CONNECT:[ UseTime:0.000519s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:47:40+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001074s ]
[2021-02-25T09:47:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '27'  AND `status` = '上线' [ RunTime:0.000327s ]
[2021-02-25T09:47:40+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment` FROM `yl_content` WHERE  `node_id` = '27'  AND `status` = '上线' ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000368s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000530s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001041s ]
[2021-02-25T09:53:43+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '支委会'  AND `status` = '已完成'  AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.001663s ]
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000727s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` = 2 GROUP BY `status` [ RunTime:0.000283s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000488s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000984s ]
[2021-02-25T09:53:43+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党员大会'  AND `status` = '已完成'  AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000342s ]
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.001003s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` IN (1,3,6) GROUP BY `status` [ RunTime:0.000285s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000502s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000978s ]
[2021-02-25T09:53:43+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000350s ]
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000745s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` = 4 GROUP BY `status` [ RunTime:0.000269s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001064s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000301s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, t2.sex FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` GROUP BY `t2`.`sex` [ RunTime:0.000387s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, t2.education FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` GROUP BY `t2`.`education` [ RunTime:0.000263s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, date_format(t2.birthday, "%Y") age FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` GROUP BY date_format(t2.birthday,"%Y") [ RunTime:0.000238s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000991s ]
[2021-02-25T09:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` [ RunTime:0.000264s ]
[2021-02-25T09:53:43+08:00][sql] SELECT `t1`.`id`,`t1`.`uuid`,`t1`.`points`,`t1`.`join_time`,`t1`.`photo`,`t1`.`position`,`t2`.`name`,`t2`.`sex`,`t2`.`birthday`,`t2`.`cardid` FROM `yl_user_party` `t1` LEFT JOIN `yl_user` `t2` ON `t2`.`uuid`=`t1`.`uuid` ORDER BY `t1`.`points` DESC LIMIT 0,3 [ RunTime:0.000362s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000502s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000971s ]
[2021-02-25T09:53:43+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党小组会'  AND `status` = '已完成'  AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000353s ]
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000721s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` IN ('') GROUP BY `status` [ RunTime:0.000257s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000475s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000961s ]
[2021-02-25T09:53:43+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '主题党日'  AND `status` = '已完成'  AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000344s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000484s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001024s ]
[2021-02-25T09:53:43+08:00][sql] SELECT date_format(start_time, "%c") month, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` IN ('党员大会','支委会','党小组会','党课')  AND `status` = '已完成'  AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000374s ]
[2021-02-25T09:53:43+08:00][sql] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001004s ]
[2021-02-25T09:53:43+08:00][sql] SELECT id, (unix_timestamp(end_time) - unix_timestamp(start_time)) duration FROM `yl_standing_book` WHERE  `type` = '党课'  AND `status` = '已完成'  AND ( date_format(start_time, "%Y") = 2021 ) [ RunTime:0.000505s ]
[2021-02-25T09:53:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000853s ]
[2021-02-25T09:53:43+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE  `standing_book_id` = 10 GROUP BY `status` [ RunTime:0.000301s ]
[2021-02-25T10:08:20+08:00][sql] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T10:08:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001064s ]
[2021-02-25T10:08:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线' [ RunTime:0.000336s ]
[2021-02-25T10:08:20+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment` FROM `yl_content` WHERE  `node_id` = '24'  AND `status` = '上线' ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000422s ]
[2021-02-25T11:54:37+08:00][sql] CONNECT:[ UseTime:0.000527s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:54:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login` [ RunTime:0.001180s ]
[2021-02-25T11:54:37+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`.`pics`,`t2`.`cardid`,`t2`.`name`,`t2`.`uuid` FROM `yl_user_login` `t1` LEFT JOIN `yl_user` `t2` ON `t1`.`uuid`=`t2`.`uuid` WHERE  ( account='18999999999' ) LIMIT 1 [ RunTime:0.000732s ]
[2021-02-25T11:54:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_role` [ RunTime:0.001054s ]
[2021-02-25T11:54:37+08:00][sql] SELECT `role_id` FROM `yl_user_role` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000287s ]
[2021-02-25T11:54:37+08:00][sql] UPDATE `yl_user_login`  SET `is_on` = 'no' , `sign_ip` = 2104976154 , `errtime` = 0 , `errtimes` = 0  WHERE  ( id=2 ) [ RunTime:0.000513s ]
[2021-02-25T11:54:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_login_logs` [ RunTime:0.000952s ]
[2021-02-25T11:54:37+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/83.0.4103.116 Safari/537.36' , `imei` = '' , `seriesnumber` = '' [ RunTime:0.000425s ]
[2021-02-25T11:54:38+08:00][sql] CONNECT:[ UseTime:0.000483s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:54:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000930s ]
[2021-02-25T11:54:38+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000587s ]
[2021-02-25T11:54:38+08:00][sql] CONNECT:[ UseTime:0.000506s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:54:38+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.001058s ]
[2021-02-25T11:54:38+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000418s ]
[2021-02-25T11:54:39+08:00][sql] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:54:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity` [ RunTime:0.001321s ]
[2021-02-25T11:54:39+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.000583s ]
[2021-02-25T11:54:39+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.000456s ]
[2021-02-25T11:54:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000807s ]
[2021-02-25T11:54:39+08:00][sql] SELECT `uuid`,`name` FROM `yl_user` WHERE  `uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000260s ]
[2021-02-25T11:54:39+08:00][sql] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:54:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_activity_form` [ RunTime:0.000893s ]
[2021-02-25T11:54:39+08:00][sql] SELECT `id`,`name` FROM `yl_activity_form` [ RunTime:0.000302s ]
[2021-02-25T11:54:44+08:00][sql] CONNECT:[ UseTime:0.000503s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:54:44+08:00][error] [10501]SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dangjian.yl_meeting_advance' doesn't exist[/home/htdocs/dangjian/vendor/topthink/think-orm/src/db/PDOConnection.php:768]
[2021-02-25T11:54:47+08:00][sql] CONNECT:[ UseTime:0.000483s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:54:47+08:00][error] [10501]SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dangjian.yl_meeting_advance' doesn't exist[/home/htdocs/dangjian/vendor/topthink/think-orm/src/db/PDOConnection.php:768]
[2021-02-25T11:55:33+08:00][sql] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:55:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000899s ]
[2021-02-25T11:55:33+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000389s ]
[2021-02-25T11:55:33+08:00][sql] CONNECT:[ UseTime:0.000525s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:55:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting_advance` [ RunTime:0.000923s ]
[2021-02-25T11:55:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting_advance` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000913s ]
[2021-02-25T11:55:37+08:00][sql] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:55:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001050s ]
[2021-02-25T11:55:37+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `status` = 1 [ RunTime:0.000324s ]
[2021-02-25T11:56:25+08:00][sql] CONNECT:[ UseTime:0.000553s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:56:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting_advance` [ RunTime:0.000925s ]
[2021-02-25T11:56:25+08:00][sql] INSERT INTO `yl_meeting_advance` SET `organ_id` = 3 , `title` = '会议预告' , `description` = '会议简介' , `start_time` = '2021-02-26 08:00' , `end_time` = '2021-02-26 10:00' , `address` = '会议地点' , `scope` = '参与范围' , `hoster` = '主持人' , `uuid` = '4c8f125cd4334b248dceed93ee330685' , `ctime` = '2021-02-25 11:56:25' [ RunTime:0.000452s ]
[2021-02-25T11:56:27+08:00][sql] CONNECT:[ UseTime:0.000509s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:56:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting_advance` [ RunTime:0.000963s ]
[2021-02-25T11:56:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_meeting_advance` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` [ RunTime:0.000471s ]
[2021-02-25T11:56:27+08:00][sql] SELECT `a`.*,`b`.`organ_name` FROM `yl_meeting_advance` `a` LEFT JOIN `yl_party_organ` `b` ON `b`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000483s ]
[2021-02-25T11:56:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000904s ]
[2021-02-25T11:57:00+08:00][sql] CONNECT:[ UseTime:0.000495s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001158s ]
[2021-02-25T11:57:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000472s ]
[2021-02-25T11:57:05+08:00][sql] CONNECT:[ UseTime:0.000531s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001121s ]
[2021-02-25T11:57:05+08:00][sql] SELECT `a`.`uuid`,`a`.`name`,`a`.`telephone`,`b`.`role_id` FROM `yl_user` `a` LEFT JOIN `yl_user_role` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`telephone` LIKE '%18267839955%' LIMIT 1 [ RunTime:0.000575s ]
[2021-02-25T11:57:13+08:00][sql] CONNECT:[ UseTime:0.000519s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001327s ]
[2021-02-25T11:57:13+08:00][sql] SELECT `a`.`uuid`,`a`.`name`,`a`.`telephone`,`b`.`role_id` FROM `yl_user` `a` LEFT JOIN `yl_user_role` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`telephone` LIKE '%18999999999%' LIMIT 1 [ RunTime:0.000578s ]
[2021-02-25T11:57:18+08:00][sql] CONNECT:[ UseTime:0.000509s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:18+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000880s ]
[2021-02-25T11:57:18+08:00][sql] INSERT INTO `yl_user_card` SET `caid` = '123456' , `uuid` = '4c8f125cd4334b248dceed93ee330685' , `status` = '未激活' , `ctime` = '2021-02-25 11:57:18' [ RunTime:0.000387s ]
[2021-02-25T11:57:21+08:00][sql] CONNECT:[ UseTime:0.000514s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000947s ]
[2021-02-25T11:57:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000453s ]
[2021-02-25T11:57:21+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000510s ]
[2021-02-25T11:57:36+08:00][sql] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001149s ]
[2021-02-25T11:57:36+08:00][sql] SELECT `a`.`uuid`,`a`.`name`,`a`.`telephone`,`b`.`role_id` FROM `yl_user` `a` LEFT JOIN `yl_user_role` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`telephone` LIKE '%15161531512%' LIMIT 1 [ RunTime:0.000582s ]
[2021-02-25T11:57:37+08:00][sql] CONNECT:[ UseTime:0.000475s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000964s ]
[2021-02-25T11:57:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000308s ]
[2021-02-25T11:57:37+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000329s ]
[2021-02-25T11:57:37+08:00][sql] CONNECT:[ UseTime:0.000496s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000931s ]
[2021-02-25T11:57:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000322s ]
[2021-02-25T11:57:37+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000358s ]
[2021-02-25T11:57:44+08:00][sql] CONNECT:[ UseTime:0.000480s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000952s ]
[2021-02-25T11:57:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` `a` LEFT JOIN `yl_user` `b` ON `b`.`uuid`=`a`.`uuid` LEFT JOIN `yl_party_organ` `c` ON `c`.`id`=`a`.`organ_id` [ RunTime:0.000403s ]
[2021-02-25T11:57:44+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone`,`c`.`organ_name` FROM `yl_user_party` `a` LEFT JOIN `yl_user` `b` ON `b`.`uuid`=`a`.`uuid` LEFT JOIN `yl_party_organ` `c` ON `c`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000414s ]
[2021-02-25T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position_relation` [ RunTime:0.000975s ]
[2021-02-25T11:57:44+08:00][sql] SELECT * FROM `yl_party_position_relation` WHERE  `uuid` IN ('766824f501de45cf97486d1c95939ace','feb5db5a3bab40b39e1e2ca1fbe0a485','ad7077b6fef0426bb6fd14d26afe535f','3fc7ec61c43840beb73c29863c414bf4','57ac4d52a64041838e2f2a67c617c088','c845765990724681b9acbf465bd8329b') [ RunTime:0.000303s ]
[2021-02-25T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position` [ RunTime:0.000868s ]
[2021-02-25T11:57:44+08:00][sql] SELECT `id`,`name` FROM `yl_party_position` WHERE  `id` IN (1,2) [ RunTime:0.000254s ]
[2021-02-25T11:57:44+08:00][sql] CONNECT:[ UseTime:0.000572s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001347s ]
[2021-02-25T11:57:44+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `status` = 1 [ RunTime:0.000412s ]
[2021-02-25T11:57:44+08:00][sql] CONNECT:[ UseTime:0.000458s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:44+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position` [ RunTime:0.000941s ]
[2021-02-25T11:57:44+08:00][sql] SELECT `id`,`name` FROM `yl_party_position` ORDER BY `organ_id` DESC [ RunTime:0.000284s ]
[2021-02-25T11:57:49+08:00][sql] CONNECT:[ UseTime:0.000503s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_node_column` [ RunTime:0.000816s ]
[2021-02-25T11:57:49+08:00][sql] SELECT * FROM `yl_node_column` ORDER BY `sort` ASC [ RunTime:0.000379s ]
[2021-02-25T11:57:50+08:00][sql] CONNECT:[ UseTime:0.000468s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000996s ]
[2021-02-25T11:57:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` `a` LEFT JOIN `yl_user` `b` ON `b`.`uuid`=`a`.`uuid` LEFT JOIN `yl_party_organ` `c` ON `c`.`id`=`a`.`organ_id` [ RunTime:0.000362s ]
[2021-02-25T11:57:50+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone`,`c`.`organ_name` FROM `yl_user_party` `a` LEFT JOIN `yl_user` `b` ON `b`.`uuid`=`a`.`uuid` LEFT JOIN `yl_party_organ` `c` ON `c`.`id`=`a`.`organ_id` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000420s ]
[2021-02-25T11:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position_relation` [ RunTime:0.000665s ]
[2021-02-25T11:57:50+08:00][sql] SELECT * FROM `yl_party_position_relation` WHERE  `uuid` IN ('766824f501de45cf97486d1c95939ace','feb5db5a3bab40b39e1e2ca1fbe0a485','ad7077b6fef0426bb6fd14d26afe535f','3fc7ec61c43840beb73c29863c414bf4','57ac4d52a64041838e2f2a67c617c088','c845765990724681b9acbf465bd8329b') [ RunTime:0.000299s ]
[2021-02-25T11:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position` [ RunTime:0.000622s ]
[2021-02-25T11:57:50+08:00][sql] SELECT `id`,`name` FROM `yl_party_position` WHERE  `id` IN (1,2) [ RunTime:0.000242s ]
[2021-02-25T11:57:50+08:00][sql] CONNECT:[ UseTime:0.000483s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.000990s ]
[2021-02-25T11:57:50+08:00][sql] SELECT `id`,organ_pid AS pid,organ_name AS name FROM `yl_party_organ` WHERE  `status` = 1 [ RunTime:0.000335s ]
[2021-02-25T11:57:50+08:00][sql] CONNECT:[ UseTime:0.000476s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_position` [ RunTime:0.000886s ]
[2021-02-25T11:57:50+08:00][sql] SELECT `id`,`name` FROM `yl_party_position` ORDER BY `organ_id` DESC [ RunTime:0.000290s ]
[2021-02-25T11:58:00+08:00][sql] CONNECT:[ UseTime:0.000496s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000875s ]
[2021-02-25T11:58:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000406s ]
[2021-02-25T11:58:00+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000373s ]
[2021-02-25T11:58:03+08:00][sql] CONNECT:[ UseTime:0.000498s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001089s ]
[2021-02-25T11:58:03+08:00][sql] SELECT `a`.`uuid`,`a`.`name`,`a`.`telephone`,`b`.`role_id` FROM `yl_user` `a` LEFT JOIN `yl_user_role` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`telephone` LIKE '%15489897878%' LIMIT 1 [ RunTime:0.000627s ]
[2021-02-25T11:58:13+08:00][sql] CONNECT:[ UseTime:0.000525s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001016s ]
[2021-02-25T11:58:13+08:00][sql] INSERT INTO `yl_user_card` SET `caid` = '654321' , `uuid` = '3fc7ec61c43840beb73c29863c414bf4' , `status` = '有效' , `ctime` = '2021-02-25 11:58:13' [ RunTime:0.000432s ]
[2021-02-25T11:58:16+08:00][sql] CONNECT:[ UseTime:0.000556s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000936s ]
[2021-02-25T11:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000451s ]
[2021-02-25T11:58:16+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000480s ]
[2021-02-25T11:58:28+08:00][sql] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000952s ]
[2021-02-25T11:58:28+08:00][sql] UPDATE `yl_user_card`  SET `id` = 1170 , `caid` = '123456' , `uuid` = '4c8f125cd4334b248dceed93ee330685' , `status` = '有效' , `ctime` = '2021-02-25 11:58:28'  WHERE  `id` = 1170 [ RunTime:0.000532s ]
[2021-02-25T11:58:30+08:00][sql] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000872s ]
[2021-02-25T11:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000446s ]
[2021-02-25T11:58:30+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000518s ]
[2021-02-25T11:58:48+08:00][sql] CONNECT:[ UseTime:0.000469s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000920s ]
[2021-02-25T11:58:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `b`.`name` LIKE '%施伟军%' [ RunTime:0.000510s ]
[2021-02-25T11:58:48+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `b`.`name` LIKE '%施伟军%' ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000778s ]
[2021-02-25T11:58:55+08:00][sql] CONNECT:[ UseTime:0.000517s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:58:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000834s ]
[2021-02-25T11:58:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`caid` LIKE '%12345%' [ RunTime:0.000515s ]
[2021-02-25T11:58:55+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`caid` LIKE '%12345%' ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000499s ]
[2021-02-25T11:59:01+08:00][sql] CONNECT:[ UseTime:0.000569s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:59:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000862s ]
[2021-02-25T11:59:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`caid` LIKE '%4%' [ RunTime:0.000533s ]
[2021-02-25T11:59:01+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`caid` LIKE '%4%' ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000547s ]
[2021-02-25T11:59:08+08:00][sql] CONNECT:[ UseTime:0.000482s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:59:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001073s ]
[2021-02-25T11:59:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user` [ RunTime:0.000262s ]
[2021-02-25T11:59:08+08:00][sql] SELECT * FROM `yl_user` LIMIT 0,10 [ RunTime:0.000499s ]
[2021-02-25T11:59:09+08:00][sql] CONNECT:[ UseTime:0.000466s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:59:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000900s ]
[2021-02-25T11:59:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`caid` LIKE '%4%' [ RunTime:0.000373s ]
[2021-02-25T11:59:09+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` WHERE  `a`.`caid` LIKE '%4%' ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000347s ]
[2021-02-25T11:59:09+08:00][sql] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:59:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.000959s ]
[2021-02-25T11:59:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000345s ]
[2021-02-25T11:59:09+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000341s ]
[2021-02-25T11:59:21+08:00][sql] CONNECT:[ UseTime:0.000477s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:59:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.001093s ]
[2021-02-25T11:59:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` [ RunTime:0.000327s ]
[2021-02-25T11:59:21+08:00][sql] SELECT `a`.*,`b`.`name`,`b`.`telephone` FROM `yl_user_card` `a` INNER JOIN `yl_user` `b` ON `a`.`uuid`=`b`.`uuid` ORDER BY `a`.`ctime` DESC LIMIT 0,10 [ RunTime:0.000330s ]
[2021-02-25T11:59:21+08:00][sql] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:59:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.001190s ]
[2021-02-25T11:59:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task` WHERE  `sender_uuid` = '4c8f125cd4334b248dceed93ee330685' [ RunTime:0.000472s ]
[2021-02-25T11:59:21+08:00][sql] SELECT * FROM `yl_task` WHERE  `sender_uuid` = '4c8f125cd4334b248dceed93ee330685' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000460s ]
[2021-02-25T11:59:21+08:00][sql] CONNECT:[ UseTime:0.000491s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4
[2021-02-25T11:59:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000972s ]
[2021-02-25T11:59:21+08:00][sql] SELECT uuid as id,`photo`,`type` FROM `yl_user_party` ORDER BY `ctime` DESC [ RunTime:0.000313s ]
[2021-02-25T11:59:21+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000898s ]