[2026-01-05T01:55:00+08:00][sql] CONNECT:[ UseTime:0.019925s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T01:55:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.032962s ] [2026-01-05T01:55:00+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.002638s ] [2026-01-05T01:55:00+08:00][error] [8]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T01:56:10+08:00][sql] CONNECT:[ UseTime:0.004339s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T01:56:10+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.019655s ] [2026-01-05T01:56:10+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.001119s ] [2026-01-05T01:56:10+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T01:56:14+08:00][sql] CONNECT:[ UseTime:0.024959s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T01:56:14+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.039549s ] [2026-01-05T01:56:14+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.002468s ] [2026-01-05T01:56:14+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T01:57:58+08:00][sql] CONNECT:[ UseTime:0.016597s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T01:57:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.021368s ] [2026-01-05T01:57:59+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.000827s ] [2026-01-05T01:57:59+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T02:00:50+08:00][sql] CONNECT:[ UseTime:0.001040s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:00:50+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.017716s ] [2026-01-05T02:00:50+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.000774s ] [2026-01-05T02:00:50+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T02:01:25+08:00][sql] CONNECT:[ UseTime:0.001113s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:01:25+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.016441s ] [2026-01-05T02:01:25+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.000699s ] [2026-01-05T02:01:25+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T02:01:45+08:00][sql] CONNECT:[ UseTime:0.024586s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:01:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.016189s ] [2026-01-05T02:01:45+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.001007s ] [2026-01-05T02:01:45+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T02:02:09+08:00][sql] CONNECT:[ UseTime:0.013232s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:02:09+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.023976s ] [2026-01-05T02:02:09+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.001627s ] [2026-01-05T02:02:09+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T02:02:10+08:00][sql] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:02:10+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.017662s ] [2026-01-05T02:02:10+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.000605s ] [2026-01-05T02:02:10+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T02:02:27+08:00][sql] CONNECT:[ UseTime:0.001748s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:02:27+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.025880s ] [2026-01-05T02:02:27+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.001022s ] [2026-01-05T02:02:27+08:00][error] [2]unserialize(): Error at offset 56 of 424 bytes [2026-01-05T02:05:22+08:00][sql] CONNECT:[ UseTime:0.013216s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:05:22+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.016143s ] [2026-01-05T02:05:22+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.000905s ] [2026-01-05T02:05:22+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'system' LIMIT 1 [ RunTime:0.001290s ] [2026-01-05T02:17:56+08:00][sql] CONNECT:[ UseTime:0.037782s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:17:56+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.074786s ] [2026-01-05T02:17:56+08:00][sql] SELECT * FROM `oa_admin` WHERE `username` = 'ggoa' AND `delete_time` = '0' LIMIT 1 [ RunTime:0.010263s ] [2026-01-05T02:17:56+08:00][sql] UPDATE `oa_admin` SET `is_lock` = 0 , `last_login_time` = '1767550676' , `last_login_ip` = '127.0.0.1' , `login_num` = 1 WHERE `id` = 1 [ RunTime:0.009053s ] [2026-01-05T02:17:57+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.025299s ] [2026-01-05T02:17:57+08:00][sql] INSERT INTO `oa_admin_log` SET `uid` = 1 , `type` = 'login' , `action` = 'Login' , `subject` = 'System' , `param_id` = 1 , `param` = '[]' , `ip` = '127.0.0.1' , `create_time` = '1767550677' [ RunTime:0.007624s ] [2026-01-05T02:17:58+08:00][sql] CONNECT:[ UseTime:0.012527s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:17:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.032865s ] [2026-01-05T02:17:58+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.021051s ] [2026-01-05T02:17:58+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001003s ] [2026-01-05T02:17:58+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550678' WHERE `id` = 1 [ RunTime:0.005509s ] [2026-01-05T02:17:58+08:00][sql] SELECT * FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001246s ] [2026-01-05T02:17:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.026187s ] [2026-01-05T02:17:58+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.002407s ] [2026-01-05T02:17:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.028124s ] [2026-01-05T02:17:58+08:00][sql] SELECT `rules` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.001296s ] [2026-01-05T02:17:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_rule` [ RunTime:0.026007s ] [2026-01-05T02:17:58+08:00][sql] SELECT * FROM `oa_admin_rule` WHERE `menu` = 1 AND `status` = 1 AND `id` IN (1,2,3,4,5,6,7,8,9,10,11,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,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,0,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013207s ] [2026-01-05T02:18:01+08:00][sql] CONNECT:[ UseTime:0.002572s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.040234s ] [2026-01-05T02:18:01+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002016s ] [2026-01-05T02:18:01+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001347s ] [2026-01-05T02:18:01+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550681' WHERE `id` = 1 [ RunTime:0.007237s ] [2026-01-05T02:18:01+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002017s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.030755s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.006264s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.033739s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001394s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.033901s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001724s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.033064s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.003441s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.031816s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001445s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.029006s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001764s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.029411s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001472s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001105s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001114s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000891s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.029054s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001333s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.027484s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001275s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001089s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001154s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.027463s ] [2026-01-05T02:18:01+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001173s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.026658s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001326s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001494s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.029782s ] [2026-01-05T02:18:01+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001351s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770142681' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001252s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770142681' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.002010s ] [2026-01-05T02:18:01+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.001361s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767809881' ) [ RunTime:0.001172s ] [2026-01-05T02:18:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767809881' ) [ RunTime:0.001072s ] [2026-01-05T02:18:01+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000974s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.018080s ] [2026-01-05T02:18:01+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001174s ] [2026-01-05T02:18:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.017376s ] [2026-01-05T02:18:01+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.001219s ] [2026-01-05T02:18:03+08:00][sql] CONNECT:[ UseTime:0.002340s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:03+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.055222s ] [2026-01-05T02:18:03+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'token' LIMIT 1 [ RunTime:0.001459s ] [2026-01-05T02:18:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.052759s ] [2026-01-05T02:18:04+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.004472s ] [2026-01-05T02:18:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.040098s ] [2026-01-05T02:18:04+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.012772s ] [2026-01-05T02:18:05+08:00][sql] CONNECT:[ UseTime:0.014322s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.019472s ] [2026-01-05T02:18:05+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001979s ] [2026-01-05T02:18:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018303s ] [2026-01-05T02:18:05+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.004047s ] [2026-01-05T02:18:05+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001254s ] [2026-01-05T02:18:05+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001427s ] [2026-01-05T02:18:05+08:00][sql] CONNECT:[ UseTime:0.023732s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.026922s ] [2026-01-05T02:18:05+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002041s ] [2026-01-05T02:18:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.025204s ] [2026-01-05T02:18:05+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764958685' ) [ RunTime:0.001336s ] [2026-01-05T02:18:06+08:00][sql] CONNECT:[ UseTime:0.002012s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.044988s ] [2026-01-05T02:18:06+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002017s ] [2026-01-05T02:18:06+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001237s ] [2026-01-05T02:18:06+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550686' WHERE `id` = 1 [ RunTime:0.007485s ] [2026-01-05T02:18:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018294s ] [2026-01-05T02:18:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.002001s ] [2026-01-05T02:18:06+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001274s ] [2026-01-05T02:18:06+08:00][sql] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.019495s ] [2026-01-05T02:18:06+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001887s ] [2026-01-05T02:18:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.020634s ] [2026-01-05T02:18:06+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001143s ] [2026-01-05T02:18:06+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001428s ] [2026-01-05T02:18:06+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000970s ] [2026-01-05T02:18:19+08:00][sql] CONNECT:[ UseTime:0.002580s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.045434s ] [2026-01-05T02:18:19+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001965s ] [2026-01-05T02:18:19+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001416s ] [2026-01-05T02:18:19+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550699' WHERE `id` = 1 [ RunTime:0.004828s ] [2026-01-05T02:18:19+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001461s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.022427s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002164s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.028522s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001586s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.028469s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001627s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.027734s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001385s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.022874s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001476s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.022321s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001251s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.020177s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002424s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001553s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001303s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001674s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.022251s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001607s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.028124s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001652s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.004233s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.002938s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.030503s ] [2026-01-05T02:18:19+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001500s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.033563s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001780s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.002183s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.028246s ] [2026-01-05T02:18:19+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001795s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770142699' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001585s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770142699' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001552s ] [2026-01-05T02:18:19+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.001379s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767809899' ) [ RunTime:0.001543s ] [2026-01-05T02:18:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767809899' ) [ RunTime:0.001387s ] [2026-01-05T02:18:19+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001234s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.025403s ] [2026-01-05T02:18:19+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.002131s ] [2026-01-05T02:18:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.021920s ] [2026-01-05T02:18:19+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.001303s ] [2026-01-05T02:18:20+08:00][sql] CONNECT:[ UseTime:0.002241s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:20+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.050600s ] [2026-01-05T02:18:20+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002360s ] [2026-01-05T02:18:20+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.028550s ] [2026-01-05T02:18:20+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.002123s ] [2026-01-05T02:18:21+08:00][sql] CONNECT:[ UseTime:0.026515s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:21+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.020187s ] [2026-01-05T02:18:21+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001608s ] [2026-01-05T02:18:21+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018273s ] [2026-01-05T02:18:21+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001788s ] [2026-01-05T02:18:21+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001265s ] [2026-01-05T02:18:21+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001010s ] [2026-01-05T02:18:22+08:00][sql] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:22+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.039377s ] [2026-01-05T02:18:22+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002091s ] [2026-01-05T02:18:22+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.019324s ] [2026-01-05T02:18:22+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764958702' ) [ RunTime:0.001418s ] [2026-01-05T02:18:22+08:00][sql] CONNECT:[ UseTime:0.002405s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:22+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.030705s ] [2026-01-05T02:18:22+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.003164s ] [2026-01-05T02:18:22+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001330s ] [2026-01-05T02:18:22+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550702' WHERE `id` = 1 [ RunTime:0.005867s ] [2026-01-05T02:18:22+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.030619s ] [2026-01-05T02:18:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001576s ] [2026-01-05T02:18:22+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001697s ] [2026-01-05T02:18:22+08:00][sql] CONNECT:[ UseTime:0.012451s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:22+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.022868s ] [2026-01-05T02:18:22+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002234s ] [2026-01-05T02:18:22+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.025811s ] [2026-01-05T02:18:22+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001488s ] [2026-01-05T02:18:22+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001819s ] [2026-01-05T02:18:22+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001180s ] [2026-01-05T02:18:29+08:00][sql] CONNECT:[ UseTime:0.001742s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:29+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.019590s ] [2026-01-05T02:18:29+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001059s ] [2026-01-05T02:18:29+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000679s ] [2026-01-05T02:18:29+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550709' WHERE `id` = 1 [ RunTime:0.005926s ] [2026-01-05T02:18:29+08:00][sql] SHOW FULL COLUMNS FROM `oa_template` [ RunTime:0.013852s ] [2026-01-05T02:18:30+08:00][sql] CONNECT:[ UseTime:0.014011s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:30+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.022746s ] [2026-01-05T02:18:30+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001082s ] [2026-01-05T02:18:30+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000531s ] [2026-01-05T02:18:30+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550710' WHERE `id` = 1 [ RunTime:0.005184s ] [2026-01-05T02:18:30+08:00][sql] SHOW FULL COLUMNS FROM `oa_template` [ RunTime:0.012072s ] [2026-01-05T02:18:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_template` WHERE ( `delete_time` = '0' ) [ RunTime:0.001118s ] [2026-01-05T02:18:30+08:00][sql] SELECT * FROM `oa_template` WHERE ( `delete_time` = '0' ) ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.000904s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000705s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000720s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000719s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000773s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000675s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000758s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000695s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000749s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000831s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000545s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000679s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000692s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000638s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000652s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000528s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000639s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000466s ] [2026-01-05T02:18:30+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000509s ] [2026-01-05T02:18:36+08:00][sql] CONNECT:[ UseTime:0.017252s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:36+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.023335s ] [2026-01-05T02:18:36+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001252s ] [2026-01-05T02:18:36+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000777s ] [2026-01-05T02:18:36+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550716' WHERE `id` = 1 [ RunTime:0.004638s ] [2026-01-05T02:18:36+08:00][sql] SHOW FULL COLUMNS FROM `oa_template` [ RunTime:0.011329s ] [2026-01-05T02:18:36+08:00][sql] CONNECT:[ UseTime:0.013955s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:18:36+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.015625s ] [2026-01-05T02:18:36+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001469s ] [2026-01-05T02:18:36+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000791s ] [2026-01-05T02:18:36+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767550716' WHERE `id` = 1 [ RunTime:0.000954s ] [2026-01-05T02:18:36+08:00][sql] SHOW FULL COLUMNS FROM `oa_template` [ RunTime:0.015116s ] [2026-01-05T02:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_template` WHERE ( `delete_time` = '0' ) [ RunTime:0.000949s ] [2026-01-05T02:18:37+08:00][sql] SELECT * FROM `oa_template` WHERE ( `delete_time` = '0' ) ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.002773s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000843s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000646s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000617s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001042s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000876s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001420s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000997s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000822s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001120s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000901s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001152s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000782s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000750s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000664s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000943s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000917s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001894s ] [2026-01-05T02:18:37+08:00][sql] SELECT `name` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001054s ] [2026-01-05T02:26:14+08:00][sql] CONNECT:[ UseTime:0.002286s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:26:14+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.058584s ] [2026-01-05T02:26:14+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001985s ] [2026-01-05T02:26:14+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001129s ] [2026-01-05T02:26:14+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551174' WHERE `id` = 1 [ RunTime:0.006827s ] [2026-01-05T02:26:14+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001456s ] [2026-01-05T02:26:14+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.035641s ] [2026-01-05T02:26:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001400s ] [2026-01-05T02:26:14+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.024325s ] [2026-01-05T02:26:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001755s ] [2026-01-05T02:26:14+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.027099s ] [2026-01-05T02:26:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001586s ] [2026-01-05T02:26:14+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.023499s ] [2026-01-05T02:26:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001552s ] [2026-01-05T02:26:14+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.024811s ] [2026-01-05T02:26:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001606s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.045334s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001505s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.020392s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001443s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001041s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001470s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001632s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.019467s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001439s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.019168s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001298s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001147s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001231s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.019633s ] [2026-01-05T02:26:15+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001138s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.020231s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001344s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001619s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.021044s ] [2026-01-05T02:26:15+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001325s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143175' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001198s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143175' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001133s ] [2026-01-05T02:26:15+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.001073s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767810375' ) [ RunTime:0.000897s ] [2026-01-05T02:26:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767810375' ) [ RunTime:0.001016s ] [2026-01-05T02:26:15+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000842s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.018282s ] [2026-01-05T02:26:15+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001252s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.019266s ] [2026-01-05T02:26:15+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.001220s ] [2026-01-05T02:26:15+08:00][sql] CONNECT:[ UseTime:0.025979s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.017545s ] [2026-01-05T02:26:15+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001737s ] [2026-01-05T02:26:15+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.016857s ] [2026-01-05T02:26:15+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.001425s ] [2026-01-05T02:26:16+08:00][sql] CONNECT:[ UseTime:0.001934s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:26:16+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.017218s ] [2026-01-05T02:26:16+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002694s ] [2026-01-05T02:26:16+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.021255s ] [2026-01-05T02:26:16+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001171s ] [2026-01-05T02:26:16+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001175s ] [2026-01-05T02:26:16+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000970s ] [2026-01-05T02:26:17+08:00][sql] CONNECT:[ UseTime:0.001785s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:26:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.042400s ] [2026-01-05T02:26:17+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001808s ] [2026-01-05T02:26:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.019519s ] [2026-01-05T02:26:17+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764959177' ) [ RunTime:0.001137s ] [2026-01-05T02:26:17+08:00][sql] CONNECT:[ UseTime:0.024516s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:26:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.020761s ] [2026-01-05T02:26:17+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002131s ] [2026-01-05T02:26:17+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001362s ] [2026-01-05T02:26:17+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551177' WHERE `id` = 1 [ RunTime:0.006993s ] [2026-01-05T02:26:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.023837s ] [2026-01-05T02:26:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001427s ] [2026-01-05T02:26:17+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001499s ] [2026-01-05T02:26:17+08:00][sql] CONNECT:[ UseTime:0.002524s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:26:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.030797s ] [2026-01-05T02:26:17+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002404s ] [2026-01-05T02:26:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.026150s ] [2026-01-05T02:26:17+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001687s ] [2026-01-05T02:26:17+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001391s ] [2026-01-05T02:26:17+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001515s ] [2026-01-05T02:33:51+08:00][sql] CONNECT:[ UseTime:0.022128s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:51+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.030397s ] [2026-01-05T02:33:51+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.000990s ] [2026-01-05T02:33:51+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000768s ] [2026-01-05T02:33:51+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551631' WHERE `id` = 1 [ RunTime:0.005186s ] [2026-01-05T02:33:51+08:00][sql] UPDATE `oa_admin` SET `theme` = 'black' WHERE `id` = 1 [ RunTime:0.005843s ] [2026-01-05T02:33:53+08:00][sql] CONNECT:[ UseTime:0.017619s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.038648s ] [2026-01-05T02:33:53+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001428s ] [2026-01-05T02:33:53+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001004s ] [2026-01-05T02:33:53+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551633' WHERE `id` = 1 [ RunTime:0.006251s ] [2026-01-05T02:33:53+08:00][sql] SELECT * FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001476s ] [2026-01-05T02:33:53+08:00][sql] CONNECT:[ UseTime:0.021043s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.024068s ] [2026-01-05T02:33:53+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001973s ] [2026-01-05T02:33:53+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001127s ] [2026-01-05T02:33:53+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551633' WHERE `id` = 1 [ RunTime:0.001050s ] [2026-01-05T02:33:53+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002130s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.019777s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001213s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.019929s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001470s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.019164s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001519s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.020723s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001256s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.019567s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001335s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.023724s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001650s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.023928s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001925s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001514s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001278s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001339s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.025832s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001256s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.020107s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001360s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001238s ] [2026-01-05T02:33:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001379s ] [2026-01-05T02:33:53+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.019774s ] [2026-01-05T02:33:53+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001270s ] [2026-01-05T02:33:54+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.026104s ] [2026-01-05T02:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001355s ] [2026-01-05T02:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001212s ] [2026-01-05T02:33:54+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.041493s ] [2026-01-05T02:33:54+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001244s ] [2026-01-05T02:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143634' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001168s ] [2026-01-05T02:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143634' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001132s ] [2026-01-05T02:33:54+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000995s ] [2026-01-05T02:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767810834' ) [ RunTime:0.000946s ] [2026-01-05T02:33:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767810834' ) [ RunTime:0.001257s ] [2026-01-05T02:33:54+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001422s ] [2026-01-05T02:33:54+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.020992s ] [2026-01-05T02:33:54+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001399s ] [2026-01-05T02:33:54+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.041975s ] [2026-01-05T02:33:54+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.002882s ] [2026-01-05T02:33:55+08:00][sql] CONNECT:[ UseTime:0.002895s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:55+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.084668s ] [2026-01-05T02:33:55+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.003766s ] [2026-01-05T02:33:55+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.059900s ] [2026-01-05T02:33:55+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.002406s ] [2026-01-05T02:33:56+08:00][sql] CONNECT:[ UseTime:0.024181s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:56+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.029352s ] [2026-01-05T02:33:56+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002583s ] [2026-01-05T02:33:56+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.056114s ] [2026-01-05T02:33:56+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.014182s ] [2026-01-05T02:33:56+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.008484s ] [2026-01-05T02:33:56+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.008218s ] [2026-01-05T02:33:57+08:00][sql] CONNECT:[ UseTime:0.002088s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:57+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.037348s ] [2026-01-05T02:33:57+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001740s ] [2026-01-05T02:33:57+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.021273s ] [2026-01-05T02:33:57+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764959637' ) [ RunTime:0.001304s ] [2026-01-05T02:33:57+08:00][sql] CONNECT:[ UseTime:0.018811s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:57+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.018182s ] [2026-01-05T02:33:57+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001500s ] [2026-01-05T02:33:57+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001397s ] [2026-01-05T02:33:57+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551637' WHERE `id` = 1 [ RunTime:0.006031s ] [2026-01-05T02:33:57+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.020967s ] [2026-01-05T02:33:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001433s ] [2026-01-05T02:33:57+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001510s ] [2026-01-05T02:33:57+08:00][sql] CONNECT:[ UseTime:0.002083s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:57+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.020503s ] [2026-01-05T02:33:57+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001769s ] [2026-01-05T02:33:57+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001186s ] [2026-01-05T02:33:57+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551637' WHERE `id` = 1 [ RunTime:0.001178s ] [2026-01-05T02:33:57+08:00][sql] UPDATE `oa_admin` SET `theme` = 'blue' WHERE `id` = 1 [ RunTime:0.005894s ] [2026-01-05T02:33:58+08:00][sql] CONNECT:[ UseTime:0.012828s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.036920s ] [2026-01-05T02:33:58+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001472s ] [2026-01-05T02:33:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.021396s ] [2026-01-05T02:33:58+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001160s ] [2026-01-05T02:33:58+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001910s ] [2026-01-05T02:33:58+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001684s ] [2026-01-05T02:33:59+08:00][sql] CONNECT:[ UseTime:0.021980s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.027935s ] [2026-01-05T02:33:59+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001390s ] [2026-01-05T02:33:59+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000766s ] [2026-01-05T02:33:59+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551639' WHERE `id` = 1 [ RunTime:0.005331s ] [2026-01-05T02:33:59+08:00][sql] SELECT * FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001295s ] [2026-01-05T02:33:59+08:00][sql] CONNECT:[ UseTime:0.002641s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.018004s ] [2026-01-05T02:33:59+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001491s ] [2026-01-05T02:33:59+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001172s ] [2026-01-05T02:33:59+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551639' WHERE `id` = 1 [ RunTime:0.001066s ] [2026-01-05T02:33:59+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001098s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.017731s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001009s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.016236s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001093s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.016954s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001104s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.017507s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001352s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.017948s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001147s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.020058s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001035s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.018408s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001108s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000988s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000918s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000873s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.021640s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001099s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.016196s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001052s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001139s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000936s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.016795s ] [2026-01-05T02:33:59+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001032s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.017344s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.000919s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001184s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.019364s ] [2026-01-05T02:33:59+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001123s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143639' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001279s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143639' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001120s ] [2026-01-05T02:33:59+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.001014s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767810839' ) [ RunTime:0.000890s ] [2026-01-05T02:33:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767810839' ) [ RunTime:0.000951s ] [2026-01-05T02:33:59+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000905s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.035112s ] [2026-01-05T02:33:59+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001476s ] [2026-01-05T02:33:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.017533s ] [2026-01-05T02:33:59+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.000962s ] [2026-01-05T02:34:00+08:00][sql] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.044886s ] [2026-01-05T02:34:00+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001774s ] [2026-01-05T02:34:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.020625s ] [2026-01-05T02:34:00+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.001519s ] [2026-01-05T02:34:01+08:00][sql] CONNECT:[ UseTime:0.001889s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.019478s ] [2026-01-05T02:34:01+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001361s ] [2026-01-05T02:34:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018287s ] [2026-01-05T02:34:01+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001159s ] [2026-01-05T02:34:01+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.002999s ] [2026-01-05T02:34:01+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001059s ] [2026-01-05T02:34:01+08:00][sql] CONNECT:[ UseTime:0.026202s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.017572s ] [2026-01-05T02:34:01+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001557s ] [2026-01-05T02:34:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.016806s ] [2026-01-05T02:34:01+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764959641' ) [ RunTime:0.001022s ] [2026-01-05T02:34:01+08:00][sql] CONNECT:[ UseTime:0.012276s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.017178s ] [2026-01-05T02:34:01+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001301s ] [2026-01-05T02:34:01+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000830s ] [2026-01-05T02:34:01+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551641' WHERE `id` = 1 [ RunTime:0.005809s ] [2026-01-05T02:34:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.017985s ] [2026-01-05T02:34:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001251s ] [2026-01-05T02:34:01+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001214s ] [2026-01-05T02:34:02+08:00][sql] CONNECT:[ UseTime:0.021900s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.034233s ] [2026-01-05T02:34:02+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001440s ] [2026-01-05T02:34:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.017084s ] [2026-01-05T02:34:02+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.000961s ] [2026-01-05T02:34:02+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001201s ] [2026-01-05T02:34:02+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001379s ] [2026-01-05T02:34:02+08:00][sql] CONNECT:[ UseTime:0.021537s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.013707s ] [2026-01-05T02:34:02+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001418s ] [2026-01-05T02:34:02+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001115s ] [2026-01-05T02:34:02+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551642' WHERE `id` = 1 [ RunTime:0.005444s ] [2026-01-05T02:34:02+08:00][sql] UPDATE `oa_admin` SET `theme` = 'black' WHERE `id` = 1 [ RunTime:0.007526s ] [2026-01-05T02:34:03+08:00][sql] CONNECT:[ UseTime:0.020958s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:03+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.018525s ] [2026-01-05T02:34:03+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001006s ] [2026-01-05T02:34:03+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000720s ] [2026-01-05T02:34:03+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551643' WHERE `id` = 1 [ RunTime:0.005513s ] [2026-01-05T02:34:03+08:00][sql] SELECT * FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000877s ] [2026-01-05T02:34:03+08:00][sql] CONNECT:[ UseTime:0.024350s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:03+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.010045s ] [2026-01-05T02:34:03+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.000946s ] [2026-01-05T02:34:03+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000607s ] [2026-01-05T02:34:03+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551643' WHERE `id` = 1 [ RunTime:0.000683s ] [2026-01-05T02:34:04+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000738s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.023001s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000773s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.012026s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000868s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.012318s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000902s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.010846s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000749s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.010511s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000777s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.010458s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000814s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.010068s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000773s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000791s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001222s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000921s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.011205s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.000984s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.011413s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000802s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000813s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000763s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.010446s ] [2026-01-05T02:34:04+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.000898s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.012325s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.000728s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.000797s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.011124s ] [2026-01-05T02:34:04+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.000915s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143644' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000885s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143644' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000882s ] [2026-01-05T02:34:04+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000733s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767810844' ) [ RunTime:0.000597s ] [2026-01-05T02:34:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767810844' ) [ RunTime:0.000709s ] [2026-01-05T02:34:04+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000670s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.011189s ] [2026-01-05T02:34:04+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001002s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.010056s ] [2026-01-05T02:34:04+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.000825s ] [2026-01-05T02:34:04+08:00][sql] CONNECT:[ UseTime:0.001820s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.028208s ] [2026-01-05T02:34:04+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002106s ] [2026-01-05T02:34:04+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.026383s ] [2026-01-05T02:34:04+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.001779s ] [2026-01-05T02:34:05+08:00][sql] CONNECT:[ UseTime:0.001851s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.025723s ] [2026-01-05T02:34:05+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002171s ] [2026-01-05T02:34:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.022799s ] [2026-01-05T02:34:05+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001614s ] [2026-01-05T02:34:05+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001472s ] [2026-01-05T02:34:05+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001031s ] [2026-01-05T02:34:05+08:00][sql] CONNECT:[ UseTime:0.002164s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.019548s ] [2026-01-05T02:34:05+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001807s ] [2026-01-05T02:34:05+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.017458s ] [2026-01-05T02:34:05+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764959645' ) [ RunTime:0.001241s ] [2026-01-05T02:34:06+08:00][sql] CONNECT:[ UseTime:0.001986s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.035223s ] [2026-01-05T02:34:06+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001727s ] [2026-01-05T02:34:06+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001031s ] [2026-01-05T02:34:06+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551646' WHERE `id` = 1 [ RunTime:0.005560s ] [2026-01-05T02:34:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.016299s ] [2026-01-05T02:34:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001288s ] [2026-01-05T02:34:06+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001612s ] [2026-01-05T02:34:06+08:00][sql] CONNECT:[ UseTime:0.025940s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:34:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.017667s ] [2026-01-05T02:34:06+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001630s ] [2026-01-05T02:34:06+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.017259s ] [2026-01-05T02:34:06+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.000981s ] [2026-01-05T02:34:06+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001202s ] [2026-01-05T02:34:06+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001037s ] [2026-01-05T02:35:44+08:00][sql] CONNECT:[ UseTime:0.002052s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:35:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.039523s ] [2026-01-05T02:35:44+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001875s ] [2026-01-05T02:35:44+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001065s ] [2026-01-05T02:35:44+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551744' WHERE `id` = 1 [ RunTime:0.005407s ] [2026-01-05T02:35:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.017823s ] [2026-01-05T02:35:44+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'web' LIMIT 1 [ RunTime:0.001231s ] [2026-01-05T02:35:44+08:00][sql] SELECT * FROM `oa_config` WHERE `name` = 'system' LIMIT 1 [ RunTime:0.002238s ] [2026-01-05T02:35:45+08:00][sql] CONNECT:[ UseTime:0.010893s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:35:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.042290s ] [2026-01-05T02:35:45+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001827s ] [2026-01-05T02:35:45+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001650s ] [2026-01-05T02:35:45+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551745' WHERE `id` = 1 [ RunTime:0.006841s ] [2026-01-05T02:35:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.021681s ] [2026-01-05T02:35:45+08:00][sql] SELECT * FROM `oa_config` WHERE ( `status` >= 0 ) [ RunTime:0.001504s ] [2026-01-05T02:36:31+08:00][sql] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:31+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.026043s ] [2026-01-05T02:36:31+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001146s ] [2026-01-05T02:36:31+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000730s ] [2026-01-05T02:36:31+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551791' WHERE `id` = 1 [ RunTime:0.004715s ] [2026-01-05T02:36:31+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.011556s ] [2026-01-05T02:36:31+08:00][sql] SELECT * FROM `oa_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000736s ] [2026-01-05T02:36:36+08:00][sql] CONNECT:[ UseTime:0.016475s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:36+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.018248s ] [2026-01-05T02:36:36+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001324s ] [2026-01-05T02:36:36+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000683s ] [2026-01-05T02:36:36+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551796' WHERE `id` = 1 [ RunTime:0.005670s ] [2026-01-05T02:36:36+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.010608s ] [2026-01-05T02:36:36+08:00][sql] SELECT `id` FROM `oa_config` WHERE ( `title` = 'Item' AND `id` <> 2 ) LIMIT 1 [ RunTime:0.002420s ] [2026-01-05T02:36:41+08:00][sql] CONNECT:[ UseTime:0.001547s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:41+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.017855s ] [2026-01-05T02:36:41+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002765s ] [2026-01-05T02:36:41+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000493s ] [2026-01-05T02:36:41+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551801' WHERE `id` = 1 [ RunTime:0.005186s ] [2026-01-05T02:36:41+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.008818s ] [2026-01-05T02:36:41+08:00][sql] SELECT `id` FROM `oa_config` WHERE ( `title` = 'Items' AND `id` <> 2 ) LIMIT 1 [ RunTime:0.000725s ] [2026-01-05T02:36:41+08:00][sql] SELECT `id` FROM `oa_config` WHERE ( `name` = 'system' AND `id` <> 2 ) LIMIT 1 [ RunTime:0.000950s ] [2026-01-05T02:36:41+08:00][sql] UPDATE `oa_config` SET `title` = 'Items' , `status` = 0 , `name` = 'system' , `update_time` = '1767551801' WHERE `id` = 2 [ RunTime:0.006226s ] [2026-01-05T02:36:41+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_rule` [ RunTime:0.009913s ] [2026-01-05T02:36:41+08:00][sql] SELECT * FROM `oa_admin_rule` WHERE `src` = 'home/conf/add' LIMIT 1 [ RunTime:0.000964s ] [2026-01-05T02:36:41+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.009925s ] [2026-01-05T02:36:41+08:00][sql] INSERT INTO `oa_admin_log` SET `uid` = 1 , `type` = 'edit' , `action` = 'Edit' , `param_id` = 2 , `param` = '{\"id\":\"2\",\"title\":\"Items\",\"status\":\"0\",\"name\":\"system\",\"update_time\":1767551801}' , `module` = 'home' , `controller` = 'conf' , `function` = 'add' , `ip` = '127.0.0.1' , `create_time` = '1767551801' , `subject` = 'Config Item' [ RunTime:0.004885s ] [2026-01-05T02:36:41+08:00][sql] CONNECT:[ UseTime:0.000951s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:41+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.008743s ] [2026-01-05T02:36:41+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001172s ] [2026-01-05T02:36:41+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000528s ] [2026-01-05T02:36:41+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551801' WHERE `id` = 1 [ RunTime:0.000448s ] [2026-01-05T02:36:41+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.008558s ] [2026-01-05T02:36:41+08:00][sql] SELECT * FROM `oa_config` WHERE ( `status` >= 0 ) [ RunTime:0.000796s ] [2026-01-05T02:36:44+08:00][sql] CONNECT:[ UseTime:0.001143s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.017329s ] [2026-01-05T02:36:44+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001988s ] [2026-01-05T02:36:44+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000496s ] [2026-01-05T02:36:44+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551804' WHERE `id` = 1 [ RunTime:0.005835s ] [2026-01-05T02:36:44+08:00][sql] SELECT * FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001672s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.009231s ] [2026-01-05T02:36:44+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.000877s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.008783s ] [2026-01-05T02:36:44+08:00][sql] SELECT `rules` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.000884s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_rule` [ RunTime:0.009170s ] [2026-01-05T02:36:44+08:00][sql] SELECT * FROM `oa_admin_rule` WHERE `menu` = 1 AND `status` = 1 AND `id` IN (1,2,3,4,5,6,7,8,9,10,11,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,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,0,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002597s ] [2026-01-05T02:36:44+08:00][sql] CONNECT:[ UseTime:0.000922s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.009664s ] [2026-01-05T02:36:44+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.000879s ] [2026-01-05T02:36:44+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000561s ] [2026-01-05T02:36:44+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551804' WHERE `id` = 1 [ RunTime:0.000519s ] [2026-01-05T02:36:44+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000827s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.009324s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001978s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.008795s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002372s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.011077s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002406s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.010850s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001966s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.010142s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001574s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.008949s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000652s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.009393s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000637s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000427s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000521s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000454s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.009680s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.000793s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.008171s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000637s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000605s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001114s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.009053s ] [2026-01-05T02:36:44+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.000573s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.008803s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.000814s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.000681s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.008979s ] [2026-01-05T02:36:44+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.000664s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143804' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000587s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143804' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000740s ] [2026-01-05T02:36:44+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000472s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767811004' ) [ RunTime:0.000540s ] [2026-01-05T02:36:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767811004' ) [ RunTime:0.000526s ] [2026-01-05T02:36:44+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000423s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.008382s ] [2026-01-05T02:36:44+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.000629s ] [2026-01-05T02:36:44+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.008353s ] [2026-01-05T02:36:44+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.001506s ] [2026-01-05T02:36:45+08:00][sql] CONNECT:[ UseTime:0.001123s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.018184s ] [2026-01-05T02:36:45+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001007s ] [2026-01-05T02:36:45+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000646s ] [2026-01-05T02:36:45+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551805' WHERE `id` = 1 [ RunTime:0.004849s ] [2026-01-05T02:36:45+08:00][sql] CONNECT:[ UseTime:0.001810s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.013239s ] [2026-01-05T02:36:45+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001290s ] [2026-01-05T02:36:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.013272s ] [2026-01-05T02:36:45+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.001178s ] [2026-01-05T02:36:45+08:00][sql] CONNECT:[ UseTime:0.001680s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.013985s ] [2026-01-05T02:36:45+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001409s ] [2026-01-05T02:36:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.015072s ] [2026-01-05T02:36:46+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.002365s ] [2026-01-05T02:36:46+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001050s ] [2026-01-05T02:36:46+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000894s ] [2026-01-05T02:36:46+08:00][sql] CONNECT:[ UseTime:0.001847s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.037034s ] [2026-01-05T02:36:46+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001932s ] [2026-01-05T02:36:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.019243s ] [2026-01-05T02:36:46+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764959806' ) [ RunTime:0.001196s ] [2026-01-05T02:36:46+08:00][sql] CONNECT:[ UseTime:0.027222s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.019794s ] [2026-01-05T02:36:46+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001638s ] [2026-01-05T02:36:46+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000931s ] [2026-01-05T02:36:46+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551806' WHERE `id` = 1 [ RunTime:0.004813s ] [2026-01-05T02:36:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.019173s ] [2026-01-05T02:36:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001645s ] [2026-01-05T02:36:46+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001222s ] [2026-01-05T02:36:46+08:00][sql] CONNECT:[ UseTime:0.026563s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.024713s ] [2026-01-05T02:36:46+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001668s ] [2026-01-05T02:36:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.019101s ] [2026-01-05T02:36:46+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001276s ] [2026-01-05T02:36:46+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001313s ] [2026-01-05T02:36:46+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001319s ] [2026-01-05T02:36:47+08:00][sql] CONNECT:[ UseTime:0.026467s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:47+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.036300s ] [2026-01-05T02:36:47+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001908s ] [2026-01-05T02:36:47+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001050s ] [2026-01-05T02:36:47+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551807' WHERE `id` = 1 [ RunTime:0.005230s ] [2026-01-05T02:36:47+08:00][sql] SHOW FULL COLUMNS FROM `oa_config` [ RunTime:0.018316s ] [2026-01-05T02:36:47+08:00][sql] SELECT * FROM `oa_config` WHERE ( `status` >= 0 ) [ RunTime:0.001392s ] [2026-01-05T02:36:58+08:00][sql] CONNECT:[ UseTime:0.019374s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.023524s ] [2026-01-05T02:36:58+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001205s ] [2026-01-05T02:36:58+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000589s ] [2026-01-05T02:36:58+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551818' WHERE `id` = 1 [ RunTime:0.005125s ] [2026-01-05T02:36:58+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001072s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.011119s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000701s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.011565s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000792s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.010838s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000819s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.009081s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001247s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.010393s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000640s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.010232s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002589s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.009870s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.003061s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001044s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000794s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000716s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.011626s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001164s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.010977s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.002586s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001003s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000690s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.018324s ] [2026-01-05T02:36:58+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.002205s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.012190s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.000730s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.000605s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.009708s ] [2026-01-05T02:36:58+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.002572s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143818' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000752s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143818' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000732s ] [2026-01-05T02:36:58+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000543s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767811018' ) [ RunTime:0.000761s ] [2026-01-05T02:36:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767811018' ) [ RunTime:0.000725s ] [2026-01-05T02:36:58+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000611s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.011512s ] [2026-01-05T02:36:58+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001700s ] [2026-01-05T02:36:58+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.009804s ] [2026-01-05T02:36:58+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.002128s ] [2026-01-05T02:36:59+08:00][sql] CONNECT:[ UseTime:0.010908s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.019169s ] [2026-01-05T02:36:59+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001017s ] [2026-01-05T02:36:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.010926s ] [2026-01-05T02:36:59+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.000997s ] [2026-01-05T02:36:59+08:00][sql] CONNECT:[ UseTime:0.001457s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.010253s ] [2026-01-05T02:36:59+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001007s ] [2026-01-05T02:36:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.011314s ] [2026-01-05T02:36:59+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.000826s ] [2026-01-05T02:36:59+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.000519s ] [2026-01-05T02:36:59+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000635s ] [2026-01-05T02:36:59+08:00][sql] CONNECT:[ UseTime:0.024274s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:36:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.012327s ] [2026-01-05T02:36:59+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.000934s ] [2026-01-05T02:36:59+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.011447s ] [2026-01-05T02:36:59+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764959819' ) [ RunTime:0.001202s ] [2026-01-05T02:37:00+08:00][sql] CONNECT:[ UseTime:0.022998s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:37:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.022777s ] [2026-01-05T02:37:00+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001146s ] [2026-01-05T02:37:00+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000915s ] [2026-01-05T02:37:00+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551820' WHERE `id` = 1 [ RunTime:0.005156s ] [2026-01-05T02:37:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.012851s ] [2026-01-05T02:37:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.000854s ] [2026-01-05T02:37:00+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.000922s ] [2026-01-05T02:37:00+08:00][sql] CONNECT:[ UseTime:0.002175s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:37:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.012623s ] [2026-01-05T02:37:00+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001478s ] [2026-01-05T02:37:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.012269s ] [2026-01-05T02:37:00+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.000833s ] [2026-01-05T02:37:00+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.000959s ] [2026-01-05T02:37:00+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000624s ] [2026-01-05T02:38:00+08:00][sql] CONNECT:[ UseTime:0.026694s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.029697s ] [2026-01-05T02:38:00+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001542s ] [2026-01-05T02:38:00+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000876s ] [2026-01-05T02:38:00+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551880' WHERE `id` = 1 [ RunTime:0.022242s ] [2026-01-05T02:38:00+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000866s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.035398s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001091s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.019906s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001045s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.016424s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000969s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.016540s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000958s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.017516s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000856s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.018609s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001055s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.018167s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001398s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000898s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000940s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000943s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.017538s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.000892s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.026879s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001147s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000943s ] [2026-01-05T02:38:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001126s ] [2026-01-05T02:38:00+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.049710s ] [2026-01-05T02:38:00+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001095s ] [2026-01-05T02:38:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.047880s ] [2026-01-05T02:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.000806s ] [2026-01-05T02:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001024s ] [2026-01-05T02:38:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.034190s ] [2026-01-05T02:38:01+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.000850s ] [2026-01-05T02:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143881' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000922s ] [2026-01-05T02:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770143881' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000910s ] [2026-01-05T02:38:01+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000921s ] [2026-01-05T02:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767811081' ) [ RunTime:0.000626s ] [2026-01-05T02:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767811081' ) [ RunTime:0.001091s ] [2026-01-05T02:38:01+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001384s ] [2026-01-05T02:38:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.030143s ] [2026-01-05T02:38:01+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001044s ] [2026-01-05T02:38:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.039624s ] [2026-01-05T02:38:01+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.000981s ] [2026-01-05T02:38:01+08:00][sql] CONNECT:[ UseTime:0.002678s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:38:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.020475s ] [2026-01-05T02:38:01+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001391s ] [2026-01-05T02:38:01+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.017375s ] [2026-01-05T02:38:01+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.001405s ] [2026-01-05T02:38:02+08:00][sql] CONNECT:[ UseTime:0.014907s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:38:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.015292s ] [2026-01-05T02:38:02+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001367s ] [2026-01-05T02:38:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.012603s ] [2026-01-05T02:38:02+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.000976s ] [2026-01-05T02:38:02+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.000924s ] [2026-01-05T02:38:02+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000895s ] [2026-01-05T02:38:02+08:00][sql] CONNECT:[ UseTime:0.023501s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:38:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.013872s ] [2026-01-05T02:38:02+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001373s ] [2026-01-05T02:38:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018019s ] [2026-01-05T02:38:02+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764959882' ) [ RunTime:0.001040s ] [2026-01-05T02:38:02+08:00][sql] CONNECT:[ UseTime:0.018988s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:38:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.014885s ] [2026-01-05T02:38:02+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001232s ] [2026-01-05T02:38:02+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000883s ] [2026-01-05T02:38:02+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767551882' WHERE `id` = 1 [ RunTime:0.044178s ] [2026-01-05T02:38:02+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.015460s ] [2026-01-05T02:38:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.000975s ] [2026-01-05T02:38:02+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.000899s ] [2026-01-05T02:38:03+08:00][sql] CONNECT:[ UseTime:0.001227s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:38:03+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.030230s ] [2026-01-05T02:38:03+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002016s ] [2026-01-05T02:38:03+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.014312s ] [2026-01-05T02:38:03+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.000785s ] [2026-01-05T02:38:03+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.000757s ] [2026-01-05T02:38:03+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000827s ] [2026-01-05T02:50:16+08:00][sql] CONNECT:[ UseTime:0.021713s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:50:16+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.013571s ] [2026-01-05T02:50:16+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001330s ] [2026-01-05T02:50:16+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001336s ] [2026-01-05T02:50:16+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552616' WHERE `id` = 1 [ RunTime:0.015937s ] [2026-01-05T02:50:16+08:00][sql] SELECT * FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001177s ] [2026-01-05T02:50:17+08:00][sql] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.029591s ] [2026-01-05T02:50:17+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001238s ] [2026-01-05T02:50:17+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000761s ] [2026-01-05T02:50:17+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552617' WHERE `id` = 1 [ RunTime:0.005385s ] [2026-01-05T02:50:17+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001294s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.014591s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001645s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.013992s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001084s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.013350s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000839s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.013850s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002762s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.011426s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000851s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.012930s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000883s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.014156s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000918s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000890s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001428s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.000778s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.014197s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001085s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.013091s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001860s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000904s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000937s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.013921s ] [2026-01-05T02:50:17+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.000891s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.014910s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.000813s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.000868s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.014127s ] [2026-01-05T02:50:17+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001029s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770144617' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000895s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770144617' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000756s ] [2026-01-05T02:50:17+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000677s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767811817' ) [ RunTime:0.000582s ] [2026-01-05T02:50:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767811817' ) [ RunTime:0.000688s ] [2026-01-05T02:50:17+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000582s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.013506s ] [2026-01-05T02:50:17+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001230s ] [2026-01-05T02:50:17+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.015804s ] [2026-01-05T02:50:17+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.002672s ] [2026-01-05T02:50:18+08:00][sql] CONNECT:[ UseTime:0.002381s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:50:18+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.041100s ] [2026-01-05T02:50:18+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.003868s ] [2026-01-05T02:50:18+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.022503s ] [2026-01-05T02:50:18+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.003758s ] [2026-01-05T02:50:18+08:00][sql] CONNECT:[ UseTime:0.025225s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:50:18+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.014678s ] [2026-01-05T02:50:18+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001317s ] [2026-01-05T02:50:18+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.012944s ] [2026-01-05T02:50:18+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.002510s ] [2026-01-05T02:50:18+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.000983s ] [2026-01-05T02:50:18+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000912s ] [2026-01-05T02:50:19+08:00][sql] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:50:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.028036s ] [2026-01-05T02:50:19+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001597s ] [2026-01-05T02:50:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.014887s ] [2026-01-05T02:50:19+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764960619' ) [ RunTime:0.001238s ] [2026-01-05T02:50:19+08:00][sql] CONNECT:[ UseTime:0.016117s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:50:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.015900s ] [2026-01-05T02:50:19+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001640s ] [2026-01-05T02:50:19+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001133s ] [2026-01-05T02:50:19+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552619' WHERE `id` = 1 [ RunTime:0.006324s ] [2026-01-05T02:50:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.017357s ] [2026-01-05T02:50:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.002516s ] [2026-01-05T02:50:19+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001365s ] [2026-01-05T02:50:19+08:00][sql] CONNECT:[ UseTime:0.002590s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:50:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.034811s ] [2026-01-05T02:50:19+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.003201s ] [2026-01-05T02:50:19+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.079771s ] [2026-01-05T02:50:19+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.002062s ] [2026-01-05T02:50:19+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001420s ] [2026-01-05T02:50:19+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001476s ] [2026-01-05T02:55:34+08:00][sql] CONNECT:[ UseTime:0.001780s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:34+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.039891s ] [2026-01-05T02:55:34+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002202s ] [2026-01-05T02:55:34+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.003132s ] [2026-01-05T02:55:34+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552934' WHERE `id` = 1 [ RunTime:0.030457s ] [2026-01-05T02:55:34+08:00][sql] SELECT * FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001898s ] [2026-01-05T02:55:37+08:00][sql] CONNECT:[ UseTime:0.022557s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.035317s ] [2026-01-05T02:55:37+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001719s ] [2026-01-05T02:55:37+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001088s ] [2026-01-05T02:55:37+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552937' WHERE `id` = 1 [ RunTime:0.005854s ] [2026-01-05T02:55:37+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001302s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.019591s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.003885s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.018972s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002622s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.017447s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002520s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.018176s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.005887s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.017346s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002418s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.016788s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002174s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.018172s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002288s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001029s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001390s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001399s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.017924s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.002002s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.018122s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.002634s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001013s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.000985s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.016339s ] [2026-01-05T02:55:37+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.002535s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.017920s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001133s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001346s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.021406s ] [2026-01-05T02:55:37+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.003325s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770144937' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001696s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770144937' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001677s ] [2026-01-05T02:55:37+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.001064s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767812137' ) [ RunTime:0.000852s ] [2026-01-05T02:55:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767812137' ) [ RunTime:0.001249s ] [2026-01-05T02:55:37+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000888s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.019177s ] [2026-01-05T02:55:37+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.006736s ] [2026-01-05T02:55:37+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.020085s ] [2026-01-05T02:55:37+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.001332s ] [2026-01-05T02:55:38+08:00][sql] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:38+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.062520s ] [2026-01-05T02:55:38+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001866s ] [2026-01-05T02:55:38+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.030312s ] [2026-01-05T02:55:38+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.007926s ] [2026-01-05T02:55:39+08:00][sql] CONNECT:[ UseTime:0.001844s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:39+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.020194s ] [2026-01-05T02:55:39+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001544s ] [2026-01-05T02:55:39+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.020579s ] [2026-01-05T02:55:39+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.002228s ] [2026-01-05T02:55:39+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001889s ] [2026-01-05T02:55:39+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.002284s ] [2026-01-05T02:55:39+08:00][sql] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:39+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.041636s ] [2026-01-05T02:55:39+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001871s ] [2026-01-05T02:55:39+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.021092s ] [2026-01-05T02:55:39+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764960939' ) [ RunTime:0.003405s ] [2026-01-05T02:55:40+08:00][sql] CONNECT:[ UseTime:0.001906s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:40+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.039304s ] [2026-01-05T02:55:40+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001815s ] [2026-01-05T02:55:40+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001408s ] [2026-01-05T02:55:40+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552940' WHERE `id` = 1 [ RunTime:0.005498s ] [2026-01-05T02:55:40+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018298s ] [2026-01-05T02:55:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001279s ] [2026-01-05T02:55:40+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001756s ] [2026-01-05T02:55:40+08:00][sql] CONNECT:[ UseTime:0.002179s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:40+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.033029s ] [2026-01-05T02:55:40+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002190s ] [2026-01-05T02:55:40+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.030033s ] [2026-01-05T02:55:40+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001450s ] [2026-01-05T02:55:40+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.004219s ] [2026-01-05T02:55:40+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.002121s ] [2026-01-05T02:55:45+08:00][sql] CONNECT:[ UseTime:0.003185s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.070666s ] [2026-01-05T02:55:45+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.007354s ] [2026-01-05T02:55:45+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002316s ] [2026-01-05T02:55:45+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552945' WHERE `id` = 1 [ RunTime:0.008036s ] [2026-01-05T02:55:45+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002354s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.038604s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.009638s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.047951s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002203s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.050076s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001405s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.031372s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002055s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.032344s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002956s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.028123s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002748s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.030089s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.003290s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.003376s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001980s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.002125s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.040179s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.002924s ] [2026-01-05T02:55:45+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.049683s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.002372s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001957s ] [2026-01-05T02:55:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.002548s ] [2026-01-05T02:55:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.055910s ] [2026-01-05T02:55:46+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.002086s ] [2026-01-05T02:55:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.030924s ] [2026-01-05T02:55:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001978s ] [2026-01-05T02:55:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.002349s ] [2026-01-05T02:55:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.028063s ] [2026-01-05T02:55:46+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001736s ] [2026-01-05T02:55:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770144946' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.002381s ] [2026-01-05T02:55:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770144946' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.003288s ] [2026-01-05T02:55:46+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.002105s ] [2026-01-05T02:55:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767812146' ) [ RunTime:0.001703s ] [2026-01-05T02:55:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767812146' ) [ RunTime:0.001897s ] [2026-01-05T02:55:46+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001799s ] [2026-01-05T02:55:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.027798s ] [2026-01-05T02:55:46+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.001804s ] [2026-01-05T02:55:46+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.027974s ] [2026-01-05T02:55:46+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.001854s ] [2026-01-05T02:55:47+08:00][sql] CONNECT:[ UseTime:0.014939s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:47+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.098311s ] [2026-01-05T02:55:47+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.012161s ] [2026-01-05T02:55:47+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.108607s ] [2026-01-05T02:55:47+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.008233s ] [2026-01-05T02:55:48+08:00][sql] CONNECT:[ UseTime:0.015297s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:48+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.020259s ] [2026-01-05T02:55:48+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001937s ] [2026-01-05T02:55:48+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018166s ] [2026-01-05T02:55:48+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001199s ] [2026-01-05T02:55:48+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001318s ] [2026-01-05T02:55:48+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000968s ] [2026-01-05T02:55:49+08:00][sql] CONNECT:[ UseTime:0.012212s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:49+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.038375s ] [2026-01-05T02:55:49+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002323s ] [2026-01-05T02:55:49+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.027658s ] [2026-01-05T02:55:49+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764960949' ) [ RunTime:0.001385s ] [2026-01-05T02:55:49+08:00][sql] CONNECT:[ UseTime:0.021510s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:49+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.021595s ] [2026-01-05T02:55:49+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001698s ] [2026-01-05T02:55:49+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001280s ] [2026-01-05T02:55:49+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767552949' WHERE `id` = 1 [ RunTime:0.006313s ] [2026-01-05T02:55:49+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.021623s ] [2026-01-05T02:55:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.002228s ] [2026-01-05T02:55:49+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001428s ] [2026-01-05T02:55:50+08:00][sql] CONNECT:[ UseTime:0.022141s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:55:50+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.041113s ] [2026-01-05T02:55:50+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002269s ] [2026-01-05T02:55:50+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.021087s ] [2026-01-05T02:55:50+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001496s ] [2026-01-05T02:55:50+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001364s ] [2026-01-05T02:55:50+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.001297s ] [2026-01-05T02:59:32+08:00][sql] CONNECT:[ UseTime:0.009248s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.025710s ] [2026-01-05T02:59:32+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.000942s ] [2026-01-05T02:59:32+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000616s ] [2026-01-05T02:59:32+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767553172' WHERE `id` = 1 [ RunTime:0.005060s ] [2026-01-05T02:59:32+08:00][sql] SELECT `auth_dids` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000827s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_expense` [ RunTime:0.009766s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000951s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_invoice` [ RunTime:0.011069s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000892s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_ticket` [ RunTime:0.013159s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.000919s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_official_docs` [ RunTime:0.011680s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000801s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_seal` [ RunTime:0.013188s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.000928s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_contract` [ RunTime:0.013147s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001069s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_purchase` [ RunTime:0.016178s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001620s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001292s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001285s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001177s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_task` [ RunTime:0.014987s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001244s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_customer` [ RunTime:0.015081s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001142s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001242s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) OR ( FIND_IN_SET('1',check_uids) ) OR ( FIND_IN_SET('1',check_history_uids) ) ) ) [ RunTime:0.001645s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_project_user` [ RunTime:0.011862s ] [2026-01-05T02:59:32+08:00][sql] SELECT `project_id` FROM `oa_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.000679s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_project` [ RunTime:0.012345s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.000892s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.000783s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_data_auth` [ RunTime:0.011720s ] [2026-01-05T02:59:32+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.000745s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770145172' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000826s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1770145172' ) AND ( ( ( `admin_id` = 1 OR `prepared_uid` = 1 OR `sign_uid` = 1 OR `keeper_uid` = 1 ) OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.000691s ] [2026-01-05T02:59:32+08:00][sql] SELECT `conf_10` FROM `oa_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000662s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1767812372' ) [ RunTime:0.000512s ] [2026-01-05T02:59:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' AND `status` < 3 AND `end_time` < '1767812372' ) [ RunTime:0.000744s ] [2026-01-05T02:59:32+08:00][sql] SELECT `position_id` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000742s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_position_group` [ RunTime:0.012576s ] [2026-01-05T02:59:32+08:00][sql] SELECT `group_id` FROM `oa_position_group` WHERE `pid` = 1 [ RunTime:0.000742s ] [2026-01-05T02:59:32+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_group` [ RunTime:0.011609s ] [2026-01-05T02:59:32+08:00][sql] SELECT `layouts` FROM `oa_admin_group` WHERE `id` = 1 [ RunTime:0.000746s ] [2026-01-05T02:59:33+08:00][sql] CONNECT:[ UseTime:0.013963s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:59:33+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.029127s ] [2026-01-05T02:59:33+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001402s ] [2026-01-05T02:59:33+08:00][sql] SHOW FULL COLUMNS FROM `oa_note` [ RunTime:0.014296s ] [2026-01-05T02:59:33+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `oa_note` `a` INNER JOIN `oa_note_cate` `c` ON `a`.`cate_id`=`c`.`id` WHERE `a`.`status` = '1' AND `a`.`delete_time` = '0' ORDER BY `a`.`end_time` DESC,`a`.`sort` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.001419s ] [2026-01-05T02:59:33+08:00][sql] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:59:33+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.020218s ] [2026-01-05T02:59:33+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001579s ] [2026-01-05T02:59:33+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.028024s ] [2026-01-05T02:59:33+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001444s ] [2026-01-05T02:59:33+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001901s ] [2026-01-05T02:59:33+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.002257s ] [2026-01-05T02:59:34+08:00][sql] CONNECT:[ UseTime:0.002095s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:59:34+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.050113s ] [2026-01-05T02:59:34+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002534s ] [2026-01-05T02:59:34+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.022673s ] [2026-01-05T02:59:34+08:00][sql] SELECT `id`,`uid` FROM `oa_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1764961174' ) [ RunTime:0.001371s ] [2026-01-05T02:59:34+08:00][sql] CONNECT:[ UseTime:0.019539s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:59:34+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.018879s ] [2026-01-05T02:59:34+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001930s ] [2026-01-05T02:59:34+08:00][sql] SELECT `last_login_time` FROM `oa_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000914s ] [2026-01-05T02:59:34+08:00][sql] UPDATE `oa_admin` SET `last_login_time` = '1767553174' WHERE `id` = 1 [ RunTime:0.004850s ] [2026-01-05T02:59:34+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.018406s ] [2026-01-05T02:59:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001164s ] [2026-01-05T02:59:34+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `oa_admin_log` `a` INNER JOIN `oa_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001061s ] [2026-01-05T02:59:34+08:00][sql] CONNECT:[ UseTime:0.011949s ] mysql:host=127.0.0.1;port=3306;dbname=oa;charset=utf8mb4 [2026-01-05T02:59:34+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin` [ RunTime:0.015534s ] [2026-01-05T02:59:34+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `oa_admin` `a` LEFT JOIN `oa_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `oa_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001666s ] [2026-01-05T02:59:34+08:00][sql] SHOW FULL COLUMNS FROM `oa_admin_log` [ RunTime:0.014979s ] [2026-01-05T02:59:34+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767542400' AND '1767628799' [ RunTime:0.001043s ] [2026-01-05T02:59:34+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1767456000' AND '1767542399' [ RunTime:0.001058s ] [2026-01-05T02:59:34+08:00][sql] SELECT `create_time` FROM `oa_admin_log` WHERE `create_time` BETWEEN '1736006400' AND '1767628799' [ RunTime:0.000827s ]