[2021-04-16T10:45:28+08:00][sql] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-04-16T10:45:28+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_card` [ RunTime:0.009313s ] [2021-04-16T10:45:28+08:00][sql] SELECT `t3`.`organ_name`,`t2`.`organ_id`,`t1`.`uuid` FROM `yl_user_card` `t1` LEFT JOIN `yl_user_party` `t2` ON `t2`.`uuid`=`t1`.`uuid` LEFT JOIN `yl_party_organ` `t3` ON `t2`.`organ_id`=`t3`.`id` WHERE ( stbid='8c561cc6421d314a' ) LIMIT 1 [ RunTime:0.023562s ] [2021-04-16T10:45:29+08:00][sql] CONNECT:[ UseTime:0.000459s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-04-16T10:45:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_standing_book` [ RunTime:0.005548s ] [2021-04-16T10:45:29+08:00][sql] SELECT `id` FROM `yl_standing_book` WHERE `organ_id` = 2 AND `end_time` <= '2021-04-16 10:45:29' AND `status` = '已审核' [ RunTime:0.003219s ] [2021-04-16T10:45:29+08:00][sql] UPDATE `yl_standing_book` SET `status` = '已完成' WHERE `organ_id` = 2 AND `end_time` <= '2021-04-16 10:45:29' AND `status` = '已审核' [ RunTime:0.001961s ] [2021-04-16T10:45:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_task_queue` [ RunTime:0.002714s ] [2021-04-16T10:45:29+08:00][sql] UPDATE `yl_task_queue` SET `status` = '已办' WHERE `status` = '待办' AND `organ_id` = 2 AND `table_name` = 'standing_book' AND `table_id` IN (15,19) [ RunTime:0.003257s ] [2021-04-16T10:45:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' [ RunTime:0.000445s ] [2021-04-16T10:45:29+08:00][sql] SELECT `id`,`title`,`type`,`table_name`,`table_id`,`ctime`,`organ_type` FROM `yl_task_queue` WHERE `organ_id` = 2 AND `status` = '待办' ORDER BY field(organ_type,'上级党委或党工委','党委','党总支','党支部','其他'),`ctime` DESC [ RunTime:0.000519s ] [2021-04-16T10:45:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_task` [ RunTime:0.002521s ] [2021-04-16T10:45:29+08:00][sql] SELECT `vid`,`desc` FROM `yl_task` WHERE `id` = 28 LIMIT 1 [ RunTime:0.003070s ] [2021-04-16T10:45:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_meeting` [ RunTime:0.011002s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 15 LIMIT 1 [ RunTime:0.003704s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000540s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000363s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000390s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000424s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000426s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000296s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000387s ] [2021-04-16T10:45:29+08:00][sql] SHOW FULL COLUMNS FROM `yl_plan` [ RunTime:0.011953s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`agenda` FROM `yl_plan` WHERE `id` = 18 LIMIT 1 [ RunTime:0.003266s ] [2021-04-16T10:45:29+08:00][sql] SELECT `icon`,`description` FROM `yl_meeting` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000558s ] [2021-04-16T10:47:12+08:00][sql] CONNECT:[ UseTime:0.000743s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-04-16T10:47:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_tag` [ RunTime:0.002726s ] [2021-04-16T10:47:12+08:00][sql] SELECT `name`,`id` FROM `yl_tag` WHERE `node_id` = 27 [ RunTime:0.003265s ] [2021-04-16T10:47:13+08:00][sql] CONNECT:[ UseTime:0.000632s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-04-16T10:47:13+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.049125s ] [2021-04-16T10:47:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `status` = '上线' AND `tag_ids` = '1' [ RunTime:0.007630s ] [2021-04-16T10:47:13+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE `node_id` = '27' AND `status` = '上线' AND `tag_ids` = '1' ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000806s ] [2021-04-16T10:47:15+08:00][sql] CONNECT:[ UseTime:0.000614s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-04-16T10:47:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001194s ] [2021-04-16T10:47:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `status` = '上线' AND `tag_ids` = '2' [ RunTime:0.000456s ] [2021-04-16T10:47:15+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE `node_id` = '27' AND `status` = '上线' AND `tag_ids` = '2' ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000519s ] [2021-04-16T10:47:15+08:00][sql] CONNECT:[ UseTime:0.000603s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian_pudong;charset=utf8mb4 [2021-04-16T10:47:15+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000937s ] [2021-04-16T10:47:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '27' AND `status` = '上线' AND `tag_ids` = '3' [ RunTime:0.000659s ] [2021-04-16T10:47:15+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid` FROM `yl_content` WHERE `node_id` = '27' AND `status` = '上线' AND `tag_ids` = '3' ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000535s ]