123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380 |
- [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 ]
|