[2021-02-24T09:12:37+08:00][sql] CONNECT:[ UseTime:0.001828s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T09:12:37+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.005165s ] [2021-02-24T09:12:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000384s ] [2021-02-24T09:12:37+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.000536s ] [2021-02-24T09:56:08+08:00][sql] CONNECT:[ UseTime:0.000556s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T09:56:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001096s ] [2021-02-24T09:56:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000373s ] [2021-02-24T09:56:08+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.000469s ] [2021-02-24T10:13:23+08:00][sql] CONNECT:[ UseTime:0.000525s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:13:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001101s ] [2021-02-24T10:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000383s ] [2021-02-24T10:13:23+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.000494s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000550s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.002447s ] [2021-02-24T10:17:52+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.000443s ] [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.002454s ] [2021-02-24T10:17:52+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 2 GROUP BY `status` [ RunTime:0.000321s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000993s ] [2021-02-24T10:17:52+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.000372s ] [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000749s ] [2021-02-24T10:17:52+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.000279s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000486s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001242s ] [2021-02-24T10:17:52+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000292s ] [2021-02-24T10:17:52+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.000523s ] [2021-02-24T10:17:52+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.000249s ] [2021-02-24T10:17:52+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.000278s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000534s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000977s ] [2021-02-24T10:17:52+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.000384s ] [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000750s ] [2021-02-24T10:17:52+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN ('') GROUP BY `status` [ RunTime:0.000276s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000521s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000946s ] [2021-02-24T10:17:52+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.000378s ] [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000761s ] [2021-02-24T10:17:52+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 4 GROUP BY `status` [ RunTime:0.000283s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000534s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001127s ] [2021-02-24T10:17:52+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.000456s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000469s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001001s ] [2021-02-24T10:17:52+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.000373s ] [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000762s ] [2021-02-24T10:17:52+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 10 GROUP BY `status` [ RunTime:0.000274s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000534s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000999s ] [2021-02-24T10:17:52+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.000380s ] [2021-02-24T10:17:52+08:00][sql] CONNECT:[ UseTime:0.000512s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000984s ] [2021-02-24T10:17:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` [ RunTime:0.000283s ] [2021-02-24T10:17:52+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.000426s ] [2021-02-24T10:38:10+08:00][sql] CONNECT:[ UseTime:0.000552s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T10:38:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001204s ] [2021-02-24T10:38:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000330s ] [2021-02-24T10:38:10+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.000483s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001132s ] [2021-02-24T13:28:13+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.000356s ] [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000863s ] [2021-02-24T13:28:13+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 10 GROUP BY `status` [ RunTime:0.000268s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001147s ] [2021-02-24T13:28:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` [ RunTime:0.000305s ] [2021-02-24T13:28:13+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.000560s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000957s ] [2021-02-24T13:28:13+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.000336s ] [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000719s ] [2021-02-24T13:28:13+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 4 GROUP BY `status` [ RunTime:0.000274s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000501s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000987s ] [2021-02-24T13:28:13+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.000366s ] [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000733s ] [2021-02-24T13:28:13+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.000294s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000494s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000999s ] [2021-02-24T13:28:13+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000285s ] [2021-02-24T13:28:13+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.000341s ] [2021-02-24T13:28:13+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.000242s ] [2021-02-24T13:28:13+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.000236s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000493s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001019s ] [2021-02-24T13:28:13+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.000379s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000562s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000944s ] [2021-02-24T13:28:13+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.000405s ] [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000732s ] [2021-02-24T13:28:13+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 2 GROUP BY `status` [ RunTime:0.000280s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000478s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000982s ] [2021-02-24T13:28:13+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.000339s ] [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000726s ] [2021-02-24T13:28:13+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN ('') GROUP BY `status` [ RunTime:0.000256s ] [2021-02-24T13:28:13+08:00][sql] CONNECT:[ UseTime:0.000464s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T13:28:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001000s ] [2021-02-24T13:28:13+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.000400s ] [2021-02-24T14:00:55+08:00][sql] CONNECT:[ UseTime:0.000539s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:00:55+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001094s ] [2021-02-24T14:00:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000318s ] [2021-02-24T14:00:55+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000291s ] [2021-02-24T14:00:57+08:00][sql] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:00:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000984s ] [2021-02-24T14:00:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000301s ] [2021-02-24T14:00:57+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000296s ] [2021-02-24T14:00:57+08:00][sql] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:00:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000996s ] [2021-02-24T14:00:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000294s ] [2021-02-24T14:00:58+08:00][sql] CONNECT:[ UseTime:0.000539s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:00:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000933s ] [2021-02-24T14:00:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党课' [ RunTime:0.000365s ] [2021-02-24T14:00:58+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党课' LIMIT 0,10 [ RunTime:0.000291s ] [2021-02-24T14:00:59+08:00][sql] CONNECT:[ UseTime:0.000547s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:00:59+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000939s ] [2021-02-24T14:00:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000311s ] [2021-02-24T14:01:00+08:00][sql] CONNECT:[ UseTime:0.000521s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000932s ] [2021-02-24T14:01:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000311s ] [2021-02-24T14:01:00+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000295s ] [2021-02-24T14:01:00+08:00][sql] CONNECT:[ UseTime:0.000581s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001009s ] [2021-02-24T14:01:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000311s ] [2021-02-24T14:01:00+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000303s ] [2021-02-24T14:01:02+08:00][sql] CONNECT:[ UseTime:0.000518s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001084s ] [2021-02-24T14:01:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000315s ] [2021-02-24T14:01:02+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000292s ] [2021-02-24T14:01:02+08:00][sql] CONNECT:[ UseTime:0.000479s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:02+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000969s ] [2021-02-24T14:01:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000378s ] [2021-02-24T14:01:03+08:00][sql] CONNECT:[ UseTime:0.000599s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:03+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000934s ] [2021-02-24T14:01:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党课' [ RunTime:0.000289s ] [2021-02-24T14:01:03+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党课' LIMIT 0,10 [ RunTime:0.000286s ] [2021-02-24T14:01:04+08:00][sql] CONNECT:[ UseTime:0.000522s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:04+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000954s ] [2021-02-24T14:01:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000392s ] [2021-02-24T14:01:05+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000957s ] [2021-02-24T14:01:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000309s ] [2021-02-24T14:01:05+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000456s ] [2021-02-24T14:01:05+08:00][sql] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:05+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000996s ] [2021-02-24T14:01:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000290s ] [2021-02-24T14:01:05+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000305s ] [2021-02-24T14:01:06+08:00][sql] CONNECT:[ UseTime:0.000545s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:06+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001039s ] [2021-02-24T14:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000415s ] [2021-02-24T14:01:06+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000307s ] [2021-02-24T14:01:07+08:00][sql] CONNECT:[ UseTime:0.000507s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001048s ] [2021-02-24T14:01:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000392s ] [2021-02-24T14:01:07+08:00][sql] CONNECT:[ UseTime:0.000585s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:07+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001058s ] [2021-02-24T14:01:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党课' [ RunTime:0.000285s ] [2021-02-24T14:01:07+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党课' LIMIT 0,10 [ RunTime:0.000278s ] [2021-02-24T14:01:08+08:00][sql] CONNECT:[ UseTime:0.000491s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000982s ] [2021-02-24T14:01:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000344s ] [2021-02-24T14:01:09+08:00][sql] CONNECT:[ UseTime:0.000633s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001044s ] [2021-02-24T14:01:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000280s ] [2021-02-24T14:01:09+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000291s ] [2021-02-24T14:01:09+08:00][sql] CONNECT:[ UseTime:0.000521s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:09+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000992s ] [2021-02-24T14:01:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000305s ] [2021-02-24T14:01:09+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000282s ] [2021-02-24T14:01:10+08:00][sql] CONNECT:[ UseTime:0.000493s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000938s ] [2021-02-24T14:01:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000287s ] [2021-02-24T14:01:10+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000415s ] [2021-02-24T14:01:10+08:00][sql] CONNECT:[ UseTime:0.000540s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:10+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001007s ] [2021-02-24T14:01:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000404s ] [2021-02-24T14:01:11+08:00][sql] CONNECT:[ UseTime:0.000676s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000943s ] [2021-02-24T14:01:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党课' [ RunTime:0.000283s ] [2021-02-24T14:01:11+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党课' LIMIT 0,10 [ RunTime:0.000283s ] [2021-02-24T14:01:12+08:00][sql] CONNECT:[ UseTime:0.000649s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000923s ] [2021-02-24T14:01:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000287s ] [2021-02-24T14:01:12+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000289s ] [2021-02-24T14:01:13+08:00][sql] CONNECT:[ UseTime:0.000530s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001086s ] [2021-02-24T14:01:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000305s ] [2021-02-24T14:01:13+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000320s ] [2021-02-24T14:01:13+08:00][sql] CONNECT:[ UseTime:0.000518s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000969s ] [2021-02-24T14:01:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000286s ] [2021-02-24T14:01:14+08:00][sql] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000956s ] [2021-02-24T14:01:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000289s ] [2021-02-24T14:01:14+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000278s ] [2021-02-24T14:01:14+08:00][sql] CONNECT:[ UseTime:0.000531s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000938s ] [2021-02-24T14:01:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000307s ] [2021-02-24T14:01:14+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000291s ] [2021-02-24T14:01:15+08:00][sql] CONNECT:[ UseTime:0.000519s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000906s ] [2021-02-24T14:01:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000293s ] [2021-02-24T14:01:15+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000328s ] [2021-02-24T14:01:15+08:00][sql] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000967s ] [2021-02-24T14:01:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000281s ] [2021-02-24T14:01:16+08:00][sql] CONNECT:[ UseTime:0.000488s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001079s ] [2021-02-24T14:01:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党课' [ RunTime:0.000295s ] [2021-02-24T14:01:16+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党课' LIMIT 0,10 [ RunTime:0.000286s ] [2021-02-24T14:01:16+08:00][sql] CONNECT:[ UseTime:0.000541s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:16+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000924s ] [2021-02-24T14:01:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000303s ] [2021-02-24T14:01:17+08:00][sql] CONNECT:[ UseTime:0.000553s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000897s ] [2021-02-24T14:01:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000293s ] [2021-02-24T14:01:17+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000281s ] [2021-02-24T14:01:17+08:00][sql] CONNECT:[ UseTime:0.000510s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:01:17+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001004s ] [2021-02-24T14:01:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000305s ] [2021-02-24T14:01:17+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000282s ] [2021-02-24T14:35:20+08:00][sql] CONNECT:[ UseTime:0.000554s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:35:20+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001093s ] [2021-02-24T14:35:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000325s ] [2021-02-24T14:35:20+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000291s ] [2021-02-24T14:35:25+08:00][sql] CONNECT:[ UseTime:0.000519s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:35:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000994s ] [2021-02-24T14:35:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000363s ] [2021-02-24T14:35:25+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000313s ] [2021-02-24T14:35:25+08:00][sql] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:35:25+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001065s ] [2021-02-24T14:35:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党小组会' [ RunTime:0.000318s ] [2021-02-24T14:35:27+08:00][sql] CONNECT:[ UseTime:0.000516s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:35:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001007s ] [2021-02-24T14:35:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '支委会' [ RunTime:0.000298s ] [2021-02-24T14:35:27+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '支委会' LIMIT 0,10 [ RunTime:0.000279s ] [2021-02-24T14:35:27+08:00][sql] CONNECT:[ UseTime:0.000614s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:35:27+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001000s ] [2021-02-24T14:35:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_standing_book` WHERE `type` = '党员大会' [ RunTime:0.000320s ] [2021-02-24T14:35:27+08:00][sql] SELECT `id`,`theme`,`start_time`,`address`,`status` FROM `yl_standing_book` WHERE `type` = '党员大会' LIMIT 0,10 [ RunTime:0.000298s ] [2021-02-24T14:37:31+08:00][sql] CONNECT:[ UseTime:0.000679s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:37:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001098s ] [2021-02-24T14:37:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE `position` <> '无' AND `organ_id` = 6 [ RunTime:0.000338s ] [2021-02-24T14:37:31+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` = 6 LIMIT 0,10 [ RunTime:0.000670s ] [2021-02-24T14:37:33+08:00][sql] CONNECT:[ UseTime:0.000505s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:37:33+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000965s ] [2021-02-24T14:37:33+08:00][sql] SELECT `t1`.`photo`,`t1`.`join_time`,`t1`.`work_time`,`t1`.`points`,`t1`.`introduce`,`t2`.`name`,`t2`.`sex`,`t2`.`cardid`,`t2`.`nativeplace`,t3.name education,t4.name national 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` WHERE `t1`.`uuid` = 'c845765990724681b9acbf465bd8329b' LIMIT 1 [ RunTime:0.000843s ] [2021-02-24T14:39:28+08:00][sql] CONNECT:[ UseTime:0.000515s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:39:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_organ` [ RunTime:0.001195s ] [2021-02-24T14:39:28+08:00][sql] SELECT `pics` FROM `yl_party_organ` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000315s ] [2021-02-24T14:39:29+08:00][sql] CONNECT:[ UseTime:0.000561s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:39:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000982s ] [2021-02-24T14:39:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE `organ_id` = 6 [ RunTime:0.000293s ] [2021-02-24T14:39:29+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 `organ_id` = 6 LIMIT 0,10 [ RunTime:0.000410s ] [2021-02-24T14:39:30+08:00][sql] CONNECT:[ UseTime:0.000513s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:39:30+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001176s ] [2021-02-24T14:39:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '25' AND `status` = '上线' [ RunTime:0.000654s ] [2021-02-24T14:39:30+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment` FROM `yl_content` WHERE `node_id` = '25' AND `status` = '上线' ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000522s ] [2021-02-24T14:39:31+08:00][sql] CONNECT:[ UseTime:0.000598s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:39:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001138s ] [2021-02-24T14:39:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues` [ RunTime:0.000875s ] [2021-02-24T14:39:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_dues` WHERE `years` = '2021' [ RunTime:0.000270s ] [2021-02-24T14:39:31+08:00][sql] SELECT `id`,`uuid`,`years` FROM `yl_party_dues` WHERE `years` = '2021' LIMIT 0,10 [ RunTime:0.000306s ] [2021-02-24T14:39:31+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues_detail` [ RunTime:0.000889s ] [2021-02-24T14:39:31+08:00][sql] SELECT `party_dues_id`,`pay_amount`,`pay_real`,`month` FROM `yl_party_dues_detail` WHERE `party_dues_id` IN (1,2,3,4,5,6,7,8,9,10) ORDER BY `month` [ RunTime:0.000352s ] [2021-02-24T14:39:32+08:00][sql] CONNECT:[ UseTime:0.000532s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:39:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.001008s ] [2021-02-24T14:39:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` WHERE `type` = '入党积极分子' AND `organ_id` = 6 [ RunTime:0.000332s ] [2021-02-24T14:39:35+08:00][sql] CONNECT:[ UseTime:0.000497s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T14:39:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001116s ] [2021-02-24T14:39:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues` [ RunTime:0.000682s ] [2021-02-24T14:39:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_party_dues` WHERE `years` = '2021' [ RunTime:0.000278s ] [2021-02-24T14:39:35+08:00][sql] SELECT `id`,`uuid`,`years` FROM `yl_party_dues` WHERE `years` = '2021' LIMIT 0,10 [ RunTime:0.000286s ] [2021-02-24T14:39:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_party_dues_detail` [ RunTime:0.000750s ] [2021-02-24T14:39:35+08:00][sql] SELECT `party_dues_id`,`pay_amount`,`pay_real`,`month` FROM `yl_party_dues_detail` WHERE `party_dues_id` IN (1,2,3,4,5,6,7,8,9,10) ORDER BY `month` [ RunTime:0.000348s ] [2021-02-24T15:15:01+08:00][sql] CONNECT:[ UseTime:0.000560s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:15:01+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.002604s ] [2021-02-24T15:15:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000329s ] [2021-02-24T15:15:01+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.000475s ] [2021-02-24T15:18:14+08:00][sql] CONNECT:[ UseTime:0.000503s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.001147s ] [2021-02-24T15:18:14+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.000351s ] [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000960s ] [2021-02-24T15:18:14+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` IN ('') GROUP BY `status` [ RunTime:0.000290s ] [2021-02-24T15:18:14+08:00][sql] CONNECT:[ UseTime:0.000492s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.003709s ] [2021-02-24T15:18:14+08:00][sql] SELECT count(*) cnt, type FROM `yl_user_party` GROUP BY `type` [ RunTime:0.000311s ] [2021-02-24T15:18:14+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.000524s ] [2021-02-24T15:18:14+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.000240s ] [2021-02-24T15:18:14+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.000244s ] [2021-02-24T15:18:14+08:00][sql] CONNECT:[ UseTime:0.000484s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000992s ] [2021-02-24T15:18:14+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.000346s ] [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000733s ] [2021-02-24T15:18:14+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 4 GROUP BY `status` [ RunTime:0.000289s ] [2021-02-24T15:18:14+08:00][sql] CONNECT:[ UseTime:0.000493s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000949s ] [2021-02-24T15:18:14+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.000334s ] [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000738s ] [2021-02-24T15:18:14+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 2 GROUP BY `status` [ RunTime:0.000269s ] [2021-02-24T15:18:14+08:00][sql] CONNECT:[ UseTime:0.000524s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:14+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000936s ] [2021-02-24T15:18:14+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.000374s ] [2021-02-24T15:18:15+08:00][sql] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_party` [ RunTime:0.000958s ] [2021-02-24T15:18:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_user_party` [ RunTime:0.000267s ] [2021-02-24T15:18:15+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.000418s ] [2021-02-24T15:18:15+08:00][sql] CONNECT:[ UseTime:0.000494s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000955s ] [2021-02-24T15:18:15+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.000395s ] [2021-02-24T15:18:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000742s ] [2021-02-24T15:18:15+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.000327s ] [2021-02-24T15:18:15+08:00][sql] CONNECT:[ UseTime:0.000478s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000964s ] [2021-02-24T15:18:15+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.000355s ] [2021-02-24T15:18:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book_sign_in` [ RunTime:0.000842s ] [2021-02-24T15:18:15+08:00][sql] SELECT count(*) cnt, status FROM `yl_standing_book_sign_in` WHERE `standing_book_id` = 10 GROUP BY `status` [ RunTime:0.000286s ] [2021-02-24T15:18:15+08:00][sql] CONNECT:[ UseTime:0.000502s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T15:18:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.000978s ] [2021-02-24T15:18:15+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.000389s ] [2021-02-24T16:08:08+08:00][sql] CONNECT:[ UseTime:0.000542s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T16:08:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001060s ] [2021-02-24T16:08:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000336s ] [2021-02-24T16:08:08+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.000464s ] [2021-02-24T16:08:11+08:00][sql] CONNECT:[ UseTime:0.000579s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T16:08:11+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001092s ] [2021-02-24T16:08:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000337s ] [2021-02-24T16:08:11+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.000462s ] [2021-02-24T16:42:45+08:00][sql] CONNECT:[ UseTime:0.000489s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T16:42:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001064s ] [2021-02-24T16:42:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000322s ] [2021-02-24T16:42:45+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.000565s ] [2021-02-24T16:47:00+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T16:47:00+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001067s ] [2021-02-24T16:47:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000329s ] [2021-02-24T16:47:00+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.000657s ] [2021-02-24T16:49:32+08:00][sql] CONNECT:[ UseTime:0.000637s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T16:49:32+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001063s ] [2021-02-24T16:49:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000331s ] [2021-02-24T16:49:32+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.000489s ] [2021-02-24T16:50:48+08:00][sql] CONNECT:[ UseTime:0.000529s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T16:50:48+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001104s ] [2021-02-24T16:50:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000360s ] [2021-02-24T16:50:48+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.000489s ] [2021-02-24T17:06:47+08:00][sql] CONNECT:[ UseTime:0.000525s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-02-24T17:06:47+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001151s ] [2021-02-24T17:06:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' [ RunTime:0.000348s ] [2021-02-24T17:06:47+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.000526s ]