[2024-08-14T18:49:53+08:00][sql] CONNECT:[ UseTime:0.017049s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.029445s ] [2024-08-14T18:49:53+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 118 [ RunTime:0.005848s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.004684s ] [2024-08-14T18:49:53+08:00][sql] SELECT `rules` FROM `cp_admin_group` WHERE `id` = 67 [ RunTime:0.000792s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_rule` [ RunTime:0.004520s ] [2024-08-14T18:49:53+08:00][sql] SELECT * FROM `cp_admin_rule` WHERE `menu` = 1 AND `status` = 1 AND `id` IN (167,282,283,284,350,377,349,192,194,257,407,408,409,258,410,411,412,319,458,459,234,249,250,303,251,291,358,368,271,256,267,268,269,270,273,275,371,372,373,374,253,254,285,288,326,347,286,334,335,336,337,338,375,376,196,198,442,199,443,444,445,446,447,448,449,450,451,452,453,200,378,379,381,382,389,390,391,406,392,393,394,434,1,247,20,21,22,23,24,25,29,30,31,32,413,414) ORDER BY `sort` ASC [ RunTime:0.002119s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.005098s ] [2024-08-14T18:49:53+08:00][sql] SELECT `title` FROM `cp_department` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000953s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.004612s ] [2024-08-14T18:49:53+08:00][sql] SELECT `theme` FROM `cp_admin` WHERE `id` = 118 LIMIT 1 [ RunTime:0.000645s ] [2024-08-14T18:49:53+08:00][sql] SELECT `type` FROM `cp_department` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000237s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_new_msg` [ RunTime:0.003958s ] [2024-08-14T18:49:53+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `uid` = 118 [ RunTime:0.002911s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_audit` [ RunTime:0.004922s ] [2024-08-14T18:49:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_project_audit` WHERE `audit_status` = 1 AND `approver` = 118 LIMIT 1 [ RunTime:0.003290s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_appropriation` [ RunTime:0.004986s ] [2024-08-14T18:49:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_appropriation` WHERE `status` = 1 AND `entrust_unit` = 111 LIMIT 1 [ RunTime:0.000358s ] [2024-08-14T18:49:53+08:00][sql] SELECT `unread` FROM `cp_admin` WHERE `id` = 118 LIMIT 1 [ RunTime:0.000608s ] [2024-08-14T18:49:53+08:00][sql] SHOW FULL COLUMNS FROM `cp_config` [ RunTime:0.005152s ] [2024-08-14T18:49:53+08:00][sql] SELECT * FROM `cp_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.000373s ] [2024-08-14T18:49:54+08:00][sql] CONNECT:[ UseTime:0.000965s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:54+08:00][sql] SHOW FULL COLUMNS FROM `cp_cost_project` [ RunTime:0.005400s ] [2024-08-14T18:49:54+08:00][sql] SELECT `sent_review_amount`,`sent_review_cost`,`review_add_reduce_rate`,`authorize_amount`,`engineering_type1` FROM `cp_cost_project` WHERE `entrust_unit` = '111' AND `delete_time` = 0 AND `project_status` > 2 AND `project_status` <> 9 [ RunTime:0.001782s ] [2024-08-14T18:49:54+08:00][sql] SELECT `sent_review_cost` FROM `cp_cost_project` WHERE `delete_time` = 0 AND `project_status` > 2 AND `project_status` <> 9 AND `entrust_unit` = '111' AND `create_time` BETWEEN 1704038400 AND 1719763199 [ RunTime:0.001663s ] [2024-08-14T18:49:54+08:00][sql] SELECT `sent_review_cost` FROM `cp_cost_project` WHERE `delete_time` = 0 AND `project_status` > 2 AND `project_status` <> 9 AND `entrust_unit` = '111' AND `create_time` BETWEEN 1719763200 AND 1735660799 [ RunTime:0.000302s ] [2024-08-14T18:49:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_cost_project` WHERE `entrust_unit` = '111' AND `delete_time` = 0 AND `project_status` > 0 LIMIT 1 [ RunTime:0.000265s ] [2024-08-14T18:49:54+08:00][sql] SELECT * FROM `cp_cost_project` WHERE `entrust_unit` = '111' AND `delete_time` = 0 AND `project_status` > 0 [ RunTime:0.001018s ] [2024-08-14T18:49:54+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_rule` [ RunTime:0.002856s ] [2024-08-14T18:49:54+08:00][sql] SELECT `id`,`name` FROM `cp_admin_rule` WHERE `name` = '待审核任务' OR `name` = '临期项目-财政局' OR `name` = '逾期项目-财政局' OR `name` = '项目列表-财政局' OR `name` = '通讯录-财政局' [ RunTime:0.000469s ] [2024-08-14T18:49:54+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002153s ] [2024-08-14T18:49:54+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 118 LIMIT 1 [ RunTime:0.000212s ] [2024-08-14T18:49:54+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.002018s ] [2024-08-14T18:49:54+08:00][sql] SELECT `rules` FROM `cp_admin_group` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000192s ] [2024-08-14T18:49:55+08:00][sql] CONNECT:[ UseTime:0.001504s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002386s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_cost_project` [ RunTime:0.003220s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_audit` [ RunTime:0.002633s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_msg` [ RunTime:0.006929s ] [2024-08-14T18:49:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_project_audit` `a` LEFT JOIN `cp_cost_project` `c` ON `a`.`project_id`=`c`.`id` WHERE `a`.`approver` = '118' AND `a`.`audit_type` < '4' AND `a`.`audit_status` = '1' LIMIT 1 [ RunTime:0.001465s ] [2024-08-14T18:49:55+08:00][sql] SELECT `a`.*,`c`.`project_status`,`c`.`sent_review_amount`,`c`.`engineering_type`,`c`.`review_unit_name` FROM `cp_project_audit` `a` LEFT JOIN `cp_cost_project` `c` ON `a`.`project_id`=`c`.`id` WHERE `a`.`approver` = '118' AND `a`.`audit_type` < '4' AND `a`.`audit_status` = '1' ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.001156s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_contact` [ RunTime:0.004357s ] [2024-08-14T18:49:55+08:00][sql] SELECT `title`,`status` FROM `cp_contact` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000641s ] [2024-08-14T18:49:55+08:00][sql] SELECT `title`,`status` FROM `cp_contact` WHERE `id` = 60 LIMIT 1 [ RunTime:0.000236s ] [2024-08-14T18:49:55+08:00][sql] SELECT `title`,`status` FROM `cp_contact` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000190s ] [2024-08-14T18:49:55+08:00][sql] SELECT `title`,`status` FROM `cp_contact` WHERE `id` = 56 LIMIT 1 [ RunTime:0.000163s ] [2024-08-14T18:49:55+08:00][sql] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002852s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_cost_project` [ RunTime:0.002585s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_msg` [ RunTime:0.003246s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_file` [ RunTime:0.002158s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.003187s ] [2024-08-14T18:49:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 118 LIMIT 1 [ RunTime:0.000296s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_field_rules` [ RunTime:0.002981s ] [2024-08-14T18:49:55+08:00][sql] SELECT `field_rules` FROM `cp_field_rules` WHERE `group_id` = 67 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003094s ] [2024-08-14T18:49:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_cost_project` WHERE ( `delete_time` = 0 AND `project_end_time` < 1724928595 AND `project_end_time` > 1723632595 AND `project_status` < 7 AND `entrust_unit` = '111' ) OR ( `delete_time` = 0 AND `project_end_time` < 1724928595 AND `project_end_time` > 1723632595 AND `project_status` < 7 AND `entrust_unit` = '111' ) LIMIT 1 [ RunTime:0.000575s ] [2024-08-14T18:49:55+08:00][sql] CONNECT:[ UseTime:0.001315s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.003780s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_cost_project` [ RunTime:0.003363s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_msg` [ RunTime:0.002455s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_file` [ RunTime:0.004559s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002676s ] [2024-08-14T18:49:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 118 LIMIT 1 [ RunTime:0.000365s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_field_rules` [ RunTime:0.004543s ] [2024-08-14T18:49:55+08:00][sql] SELECT `field_rules` FROM `cp_field_rules` WHERE `group_id` = 67 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003198s ] [2024-08-14T18:49:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_cost_project` WHERE ( `delete_time` = 0 AND `project_end_time` < 1723632595 AND `project_status` < 7 AND `entrust_unit` = '111' ) OR ( `delete_time` = 0 AND `project_end_time` < 1723632595 AND `project_status` < 7 AND `entrust_unit` = '111' ) LIMIT 1 [ RunTime:0.000559s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_cost_project` WHERE ( `delete_time` = 0 AND `project_end_time` < 1723632595 AND `project_status` < 7 AND `entrust_unit` = '111' ) OR ( `delete_time` = 0 AND `project_end_time` < 1723632595 AND `project_status` < 7 AND `entrust_unit` = '111' ) ORDER BY `id` DESC LIMIT 0,9999 [ RunTime:0.001099s ] [2024-08-14T18:49:55+08:00][sql] CONNECT:[ UseTime:0.001429s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.003108s ] [2024-08-14T18:49:55+08:00][sql] SELECT `d`.`id`,`d`.`title`,`a`.`nickname`,`a`.`mobile`,`a`.`email` FROM `cp_department` `d` INNER JOIN `cp_admin` `a` ON `d`.`leader_id`=`a`.`id` WHERE `d`.`type` = '2' AND `pid` = 0 AND `d`.`status` = '1' [ RunTime:0.003958s ] [2024-08-14T18:49:55+08:00][sql] CONNECT:[ UseTime:0.018780s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002811s ] [2024-08-14T18:49:55+08:00][sql] SELECT `a`.*,`d`.`title` FROM `cp_admin` `a` LEFT JOIN `cp_department` `d` ON `a`.`unit_name`=`d`.`id` WHERE `a`.`unit_name` = '111' AND `a`.`status` = '1' [ RunTime:0.002527s ] [2024-08-14T18:49:55+08:00][sql] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.003056s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_cost_project` [ RunTime:0.003066s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_msg` [ RunTime:0.002348s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_project_file` [ RunTime:0.002494s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.003063s ] [2024-08-14T18:49:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 118 LIMIT 1 [ RunTime:0.000387s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_field_rules` [ RunTime:0.002238s ] [2024-08-14T18:49:55+08:00][sql] SELECT `field_rules` FROM `cp_field_rules` WHERE `group_id` = 67 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ] [2024-08-14T18:49:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_cost_project` WHERE `entrust_unit` = '111' AND ( ( `delete_time` = 0 AND `project_status` > 0 ) OR ( `delete_time` = 0 AND `project_status` > 0 ) ) LIMIT 1 [ RunTime:0.000491s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_cost_project` WHERE `entrust_unit` = '111' AND ( ( `delete_time` = 0 AND `project_status` > 0 ) OR ( `delete_time` = 0 AND `project_status` > 0 ) ) ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000984s ] [2024-08-14T18:49:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_new_msg` [ RunTime:0.002625s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 511 AND `uid` = 118 LIMIT 1 [ RunTime:0.000358s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000176s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000159s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 510 AND `uid` = 118 LIMIT 1 [ RunTime:0.000222s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000123s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000141s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 509 AND `uid` = 118 LIMIT 1 [ RunTime:0.000226s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000117s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 121 LIMIT 1 [ RunTime:0.000148s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 503 AND `uid` = 118 LIMIT 1 [ RunTime:0.000593s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000161s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000169s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 502 AND `uid` = 118 LIMIT 1 [ RunTime:0.000530s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000211s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000203s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 490 AND `uid` = 118 LIMIT 1 [ RunTime:0.000368s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000188s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 152 LIMIT 1 [ RunTime:0.000180s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 487 AND `uid` = 118 LIMIT 1 [ RunTime:0.000336s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000130s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000146s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 477 AND `uid` = 118 LIMIT 1 [ RunTime:0.000351s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000232s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000140s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 476 AND `uid` = 118 LIMIT 1 [ RunTime:0.000199s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000120s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000148s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 121 LIMIT 1 [ RunTime:0.000140s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 475 AND `uid` = 118 LIMIT 1 [ RunTime:0.000204s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000121s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000146s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 474 AND `uid` = 118 LIMIT 1 [ RunTime:0.000202s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000121s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000131s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 473 AND `uid` = 118 LIMIT 1 [ RunTime:0.000202s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000118s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000211s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 471 AND `uid` = 118 LIMIT 1 [ RunTime:0.000347s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000229s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000277s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 470 AND `uid` = 118 LIMIT 1 [ RunTime:0.000299s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000171s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000204s ] [2024-08-14T18:49:55+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `project_id` = 469 AND `uid` = 118 LIMIT 1 [ RunTime:0.000247s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000143s ] [2024-08-14T18:49:55+08:00][sql] SELECT `nickname` FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000145s ] [2024-08-14T18:50:19+08:00][sql] CONNECT:[ UseTime:0.018449s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:19+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002017s ] [2024-08-14T18:50:19+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000239s ] [2024-08-14T18:50:19+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.001719s ] [2024-08-14T18:50:19+08:00][sql] SELECT `rules` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000180s ] [2024-08-14T18:50:19+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_rule` [ RunTime:0.001709s ] [2024-08-14T18:50:19+08:00][sql] SELECT * FROM `cp_admin_rule` WHERE `menu` = 1 AND `status` = 1 AND `id` IN (167,282,283,284,350,377,349,190,351,352,353,354,355,330,180,187,289,240,281,136,138,183,184,185,139,362,363,364,225,365,366,367,160,195,259,261,161,262,263,264,265,360,361,436,439,440,469,401,404,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,454,455,456,457,301,304,305,306,307,308,309,310,311,312,356,475,313,314,316,317,329,348,369,370,437,441,318,339,340,341,357,342,343,433,192,194,257,407,408,409,258,410,411,412,319,458,459,234,249,250,303,251,291,358,368,271,256,267,268,269,270,273,275,371,372,373,374,253,254,285,288,326,347,286,334,335,336,337,338,375,376,478,245,246,320,463,464,465,460,461,462,327,321,322,323,324,325,328,344,345,346,196,198,442,473,199,443,444,445,446,447,448,449,450,451,452,453,470,474,476,477,200,378,379,382,389,390,406,380,383,386,387,384,385,388,405,392,393,394,434,467,435,468,2,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,1,247,466,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,395,396,399,400,413,414) ORDER BY `sort` ASC [ RunTime:0.001164s ] [2024-08-14T18:50:19+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002304s ] [2024-08-14T18:50:19+08:00][sql] SELECT `title` FROM `cp_department` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000254s ] [2024-08-14T18:50:19+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002016s ] [2024-08-14T18:50:19+08:00][sql] SELECT `theme` FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000242s ] [2024-08-14T18:50:19+08:00][sql] SELECT `type` FROM `cp_department` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000154s ] [2024-08-14T18:50:19+08:00][sql] SHOW FULL COLUMNS FROM `cp_new_msg` [ RunTime:0.001824s ] [2024-08-14T18:50:19+08:00][sql] SELECT * FROM `cp_new_msg` WHERE `uid` = 93 [ RunTime:0.000374s ] [2024-08-14T18:50:19+08:00][sql] SELECT `unread` FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000160s ] [2024-08-14T18:50:28+08:00][sql] CONNECT:[ UseTime:0.012890s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:28+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002042s ] [2024-08-14T18:50:28+08:00][sql] CONNECT:[ UseTime:0.001424s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:28+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002495s ] [2024-08-14T18:50:28+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002015s ] [2024-08-14T18:50:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000352s ] [2024-08-14T18:50:33+08:00][sql] CONNECT:[ UseTime:0.017070s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:33+08:00][sql] SHOW FULL COLUMNS FROM `cp_push_message` [ RunTime:0.004622s ] [2024-08-14T18:50:33+08:00][sql] CONNECT:[ UseTime:0.001021s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:33+08:00][sql] SHOW FULL COLUMNS FROM `cp_push_message` [ RunTime:0.002060s ] [2024-08-14T18:50:33+08:00][sql] SELECT * FROM `cp_push_message` [ RunTime:0.000390s ] [2024-08-14T18:50:33+08:00][sql] SHOW FULL COLUMNS FROM `cp_push_member` [ RunTime:0.003975s ] [2024-08-14T18:50:33+08:00][sql] SELECT * FROM `cp_push_member` WHERE `message_id` IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,70,71,72,73,75,76,77,78,80,81,82,83,86,87,88,89,90,91,92,93,94,96,97) [ RunTime:0.000381s ] [2024-08-14T18:50:35+08:00][sql] CONNECT:[ UseTime:0.001061s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:35+08:00][sql] SHOW FULL COLUMNS FROM `cp_push_message` [ RunTime:0.002272s ] [2024-08-14T18:50:35+08:00][sql] SELECT * FROM `cp_push_message` WHERE `user_type` = -1 [ RunTime:0.000492s ] [2024-08-14T18:50:41+08:00][sql] CONNECT:[ UseTime:0.000919s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:41+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002407s ] [2024-08-14T18:50:41+08:00][sql] SELECT `unit_name` FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000294s ] [2024-08-14T18:50:41+08:00][sql] SELECT `permission` FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000198s ] [2024-08-14T18:50:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin` WHERE `status` >= 0 LIMIT 1 [ RunTime:0.000292s ] [2024-08-14T18:50:41+08:00][sql] SELECT * FROM `cp_admin` WHERE `status` >= 0 ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000399s ] [2024-08-14T18:50:41+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.001939s ] [2024-08-14T18:50:41+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (172,162,169,161,159) [ RunTime:0.000447s ] [2024-08-14T18:50:41+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000569s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 256 [ RunTime:0.000249s ] [2024-08-14T18:50:41+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.000521s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 125 [ RunTime:0.000182s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 257 [ RunTime:0.000163s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 123 [ RunTime:0.000138s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 258 [ RunTime:0.000147s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 125 [ RunTime:0.000137s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 259 [ RunTime:0.000144s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 125 [ RunTime:0.000135s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 260 [ RunTime:0.000143s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 124 [ RunTime:0.000134s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 261 [ RunTime:0.000151s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 124 [ RunTime:0.000135s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 262 [ RunTime:0.000143s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000135s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 263 [ RunTime:0.000142s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 125 [ RunTime:0.000136s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 264 [ RunTime:0.000140s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 125 [ RunTime:0.000133s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 265 [ RunTime:0.000144s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 125 [ RunTime:0.000134s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 266 [ RunTime:0.000144s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 131 [ RunTime:0.000224s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 267 [ RunTime:0.000256s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 128 [ RunTime:0.000227s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 268 [ RunTime:0.000240s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 128 [ RunTime:0.000170s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 269 [ RunTime:0.000198s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 132 [ RunTime:0.000147s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 270 [ RunTime:0.000152s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000146s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 271 [ RunTime:0.000150s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 128 [ RunTime:0.000135s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 272 [ RunTime:0.000143s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 128 [ RunTime:0.000134s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 273 [ RunTime:0.000142s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000132s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 274 [ RunTime:0.000142s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000132s ] [2024-08-14T18:50:41+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 275 [ RunTime:0.000141s ] [2024-08-14T18:50:41+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000133s ] [2024-08-14T18:50:44+08:00][sql] CONNECT:[ UseTime:0.001327s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:44+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002209s ] [2024-08-14T18:50:44+08:00][sql] SELECT `d`.*,a.nickname as leader FROM `cp_department` `d` LEFT JOIN `cp_admin` `a` ON `a`.`id`=`d`.`leader_id` WHERE `d`.`status` = '1' AND `d`.`delete_time` = '0' ORDER BY `d`.`id` ASC [ RunTime:0.000967s ] [2024-08-14T18:50:45+08:00][sql] CONNECT:[ UseTime:0.000880s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:45+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000549s ] [2024-08-14T18:50:45+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 LIMIT 1 [ RunTime:0.000225s ] [2024-08-14T18:50:45+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.001810s ] [2024-08-14T18:50:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin_group` WHERE ( `pid` = 50 ) LIMIT 1 [ RunTime:0.000212s ] [2024-08-14T18:50:45+08:00][sql] SELECT * FROM `cp_admin_group` WHERE ( `pid` = 50 ) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000239s ] [2024-08-14T18:50:45+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002293s ] [2024-08-14T18:50:45+08:00][sql] SELECT * FROM `cp_department` WHERE `id` = 102 [ RunTime:0.000268s ] [2024-08-14T18:50:45+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000600s ] [2024-08-14T18:50:45+08:00][sql] SELECT * FROM `cp_admin` WHERE `admin_group_id` IN (60,63,88,139,164,165,166) [ RunTime:0.000533s ] [2024-08-14T18:50:45+08:00][sql] SELECT * FROM `cp_admin_group` WHERE `id` = 50 LIMIT 1 [ RunTime:0.000370s ] [2024-08-14T18:50:45+08:00][sql] SELECT * FROM `cp_department` WHERE `id` = 102 [ RunTime:0.000217s ] [2024-08-14T18:50:45+08:00][sql] SELECT * FROM `cp_admin` WHERE `admin_group_id` = 50 [ RunTime:0.000584s ] [2024-08-14T18:50:46+08:00][sql] CONNECT:[ UseTime:0.001008s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:46+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_rule` [ RunTime:0.002331s ] [2024-08-14T18:50:46+08:00][sql] SELECT * FROM `cp_admin_rule` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000650s ] [2024-08-14T18:50:57+08:00][sql] CONNECT:[ UseTime:0.001369s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:50:57+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_module` [ RunTime:0.004659s ] [2024-08-14T18:50:57+08:00][sql] SELECT * FROM `cp_admin_module` [ RunTime:0.000245s ] [2024-08-14T18:51:00+08:00][sql] CONNECT:[ UseTime:0.000871s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:51:00+08:00][sql] SHOW FULL COLUMNS FROM `cp_config` [ RunTime:0.002030s ] [2024-08-14T18:51:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_config` WHERE `status` >= 0 LIMIT 1 [ RunTime:0.000245s ] [2024-08-14T18:51:00+08:00][sql] SELECT * FROM `cp_config` WHERE `status` >= 0 LIMIT 0,20 [ RunTime:0.000228s ] [2024-08-14T18:51:03+08:00][sql] CONNECT:[ UseTime:0.001315s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:51:03+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002708s ] [2024-08-14T18:51:03+08:00][sql] SELECT `type` FROM `cp_department` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000365s ] [2024-08-14T18:51:03+08:00][sql] SELECT * FROM `cp_department` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000261s ] [2024-08-14T18:51:05+08:00][sql] CONNECT:[ UseTime:0.000960s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:51:05+08:00][sql] SHOW FULL COLUMNS FROM `cp_config` [ RunTime:0.002265s ] [2024-08-14T18:51:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_config` WHERE `status` >= 0 LIMIT 1 [ RunTime:0.000234s ] [2024-08-14T18:51:05+08:00][sql] SELECT * FROM `cp_config` WHERE `status` >= 0 LIMIT 0,20 [ RunTime:0.000241s ] [2024-08-14T18:51:21+08:00][sql] CONNECT:[ UseTime:0.001221s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:51:21+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_rule` [ RunTime:0.000645s ] [2024-08-14T18:51:21+08:00][sql] SELECT * FROM `cp_admin_rule` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000820s ] [2024-08-14T18:52:29+08:00][sql] CONNECT:[ UseTime:0.001110s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:29+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_module` [ RunTime:0.002676s ] [2024-08-14T18:52:29+08:00][sql] SELECT * FROM `cp_admin_module` [ RunTime:0.000325s ] [2024-08-14T18:52:38+08:00][sql] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:38+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000677s ] [2024-08-14T18:52:38+08:00][sql] SELECT `type` FROM `cp_department` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000262s ] [2024-08-14T18:52:38+08:00][sql] SELECT * FROM `cp_department` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000241s ] [2024-08-14T18:52:40+08:00][sql] CONNECT:[ UseTime:0.000874s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:40+08:00][sql] SHOW FULL COLUMNS FROM `cp_config` [ RunTime:0.002414s ] [2024-08-14T18:52:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_config` WHERE `status` >= 0 LIMIT 1 [ RunTime:0.000260s ] [2024-08-14T18:52:40+08:00][sql] SELECT * FROM `cp_config` WHERE `status` >= 0 LIMIT 0,20 [ RunTime:0.000198s ] [2024-08-14T18:52:48+08:00][sql] CONNECT:[ UseTime:0.000971s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:48+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000853s ] [2024-08-14T18:52:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 0 LIMIT 1 [ RunTime:0.000523s ] [2024-08-14T18:52:48+08:00][sql] SELECT `id`,`title`,`leader_id`,`phone`,`landline`,`address`,`company_type`,`authorization_module` FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000361s ] [2024-08-14T18:52:48+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000618s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 206 LIMIT 1 [ RunTime:0.000272s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000208s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000196s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 212 LIMIT 1 [ RunTime:0.000202s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 210 LIMIT 1 [ RunTime:0.000168s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 213 LIMIT 1 [ RunTime:0.000167s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 211 LIMIT 1 [ RunTime:0.000167s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 207 LIMIT 1 [ RunTime:0.000168s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 208 LIMIT 1 [ RunTime:0.000208s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 209 LIMIT 1 [ RunTime:0.000166s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 214 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 238 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 215 LIMIT 1 [ RunTime:0.000170s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 216 LIMIT 1 [ RunTime:0.000174s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 217 LIMIT 1 [ RunTime:0.000276s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 218 LIMIT 1 [ RunTime:0.000305s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 219 LIMIT 1 [ RunTime:0.000281s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 220 LIMIT 1 [ RunTime:0.000205s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000245s ] [2024-08-14T18:52:48+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 222 LIMIT 1 [ RunTime:0.000203s ] [2024-08-14T18:52:50+08:00][sql] CONNECT:[ UseTime:0.001025s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:50+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002321s ] [2024-08-14T18:52:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 2 LIMIT 1 [ RunTime:0.000550s ] [2024-08-14T18:52:50+08:00][sql] SELECT `id`,`title`,`leader_id`,`phone`,`landline`,`address`,`company_type`,`authorization_module`,`status`,`create_time` FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 2 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000502s ] [2024-08-14T18:52:50+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002494s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 178 LIMIT 1 [ RunTime:0.000307s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 179 LIMIT 1 [ RunTime:0.000215s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000202s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 181 LIMIT 1 [ RunTime:0.000195s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 183 LIMIT 1 [ RunTime:0.000193s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 254 LIMIT 1 [ RunTime:0.000273s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 180 LIMIT 1 [ RunTime:0.000278s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 184 LIMIT 1 [ RunTime:0.000226s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 172 LIMIT 1 [ RunTime:0.000250s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 170 LIMIT 1 [ RunTime:0.000182s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 173 LIMIT 1 [ RunTime:0.000198s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 168 LIMIT 1 [ RunTime:0.000175s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 177 LIMIT 1 [ RunTime:0.000170s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 182 LIMIT 1 [ RunTime:0.000168s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 282 LIMIT 1 [ RunTime:0.000168s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 176 LIMIT 1 [ RunTime:0.000188s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 270 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000166s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 169 LIMIT 1 [ RunTime:0.000164s ] [2024-08-14T18:52:50+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 174 LIMIT 1 [ RunTime:0.000171s ] [2024-08-14T18:52:51+08:00][sql] CONNECT:[ UseTime:0.001000s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:51+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002634s ] [2024-08-14T18:52:52+08:00][sql] CONNECT:[ UseTime:0.000878s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:52+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000806s ] [2024-08-14T18:52:52+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000395s ] [2024-08-14T18:52:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000274s ] [2024-08-14T18:52:55+08:00][sql] CONNECT:[ UseTime:0.001055s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:52:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000817s ] [2024-08-14T18:53:11+08:00][sql] CONNECT:[ UseTime:0.017721s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000696s ] [2024-08-14T18:53:12+08:00][sql] CONNECT:[ UseTime:0.001100s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:53:12+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000748s ] [2024-08-14T18:53:12+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000449s ] [2024-08-14T18:53:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000273s ] [2024-08-14T18:53:13+08:00][sql] CONNECT:[ UseTime:0.001365s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:53:13+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002175s ] [2024-08-14T18:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 2 LIMIT 1 [ RunTime:0.000291s ] [2024-08-14T18:53:13+08:00][sql] SELECT `id`,`title`,`leader_id`,`phone`,`landline`,`address`,`company_type`,`authorization_module`,`status`,`create_time` FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 2 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000300s ] [2024-08-14T18:53:13+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000614s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 178 LIMIT 1 [ RunTime:0.000294s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 179 LIMIT 1 [ RunTime:0.000224s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000228s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 181 LIMIT 1 [ RunTime:0.000262s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 183 LIMIT 1 [ RunTime:0.000188s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 254 LIMIT 1 [ RunTime:0.000172s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 180 LIMIT 1 [ RunTime:0.000169s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 184 LIMIT 1 [ RunTime:0.000166s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 172 LIMIT 1 [ RunTime:0.000168s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 170 LIMIT 1 [ RunTime:0.000167s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 173 LIMIT 1 [ RunTime:0.000167s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 168 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 177 LIMIT 1 [ RunTime:0.000176s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 182 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 282 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 176 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 270 LIMIT 1 [ RunTime:0.000187s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000262s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 169 LIMIT 1 [ RunTime:0.000183s ] [2024-08-14T18:53:13+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 174 LIMIT 1 [ RunTime:0.000168s ] [2024-08-14T18:53:17+08:00][sql] CONNECT:[ UseTime:0.000877s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:53:17+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000621s ] [2024-08-14T18:53:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 0 LIMIT 1 [ RunTime:0.000262s ] [2024-08-14T18:53:17+08:00][sql] SELECT `id`,`title`,`leader_id`,`phone`,`landline`,`address`,`company_type`,`authorization_module` FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000221s ] [2024-08-14T18:53:17+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000469s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 206 LIMIT 1 [ RunTime:0.000254s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000210s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000271s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 212 LIMIT 1 [ RunTime:0.000222s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 210 LIMIT 1 [ RunTime:0.000289s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 213 LIMIT 1 [ RunTime:0.000223s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 211 LIMIT 1 [ RunTime:0.000174s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 207 LIMIT 1 [ RunTime:0.000172s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 208 LIMIT 1 [ RunTime:0.000169s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 209 LIMIT 1 [ RunTime:0.000166s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 214 LIMIT 1 [ RunTime:0.000164s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 238 LIMIT 1 [ RunTime:0.000167s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 215 LIMIT 1 [ RunTime:0.000165s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 216 LIMIT 1 [ RunTime:0.000164s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 217 LIMIT 1 [ RunTime:0.000162s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 218 LIMIT 1 [ RunTime:0.000191s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 219 LIMIT 1 [ RunTime:0.000163s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 220 LIMIT 1 [ RunTime:0.000163s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000162s ] [2024-08-14T18:53:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 222 LIMIT 1 [ RunTime:0.000162s ] [2024-08-14T18:53:23+08:00][sql] CONNECT:[ UseTime:0.001203s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:53:23+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000730s ] [2024-08-14T18:53:24+08:00][sql] CONNECT:[ UseTime:0.011625s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4 [2024-08-14T18:53:24+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000739s ] [2024-08-14T18:53:24+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000620s ] [2024-08-14T18:53:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_department` WHERE `delete_time` = 0 AND `pid` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000311s ]