[2026-04-28T22:56:02+08:00][sql] CONNECT:[ UseTime:0.026082s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:02+08:00][sql] SHOW FULL COLUMNS FROM `erp_config` [ RunTime:0.047046s ] [2026-04-28T22:56:02+08:00][sql] SELECT * FROM `erp_config` WHERE `name` = 'system' LIMIT 1 [ RunTime:0.001713s ] [2026-04-28T22:56:24+08:00][sql] CONNECT:[ UseTime:0.015013s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:24+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.043068s ] [2026-04-28T22:56:24+08:00][sql] SELECT * FROM `erp_admin` WHERE `username` = 'admin' AND `delete_time` = '0' LIMIT 1 [ RunTime:0.003911s ] [2026-04-28T22:56:24+08:00][sql] UPDATE `erp_admin` SET `is_lock` = 0 , `last_login_time` = '1777388184' , `last_login_ip` = '127.0.0.1' , `login_num` = 1 WHERE `id` = 1 [ RunTime:0.004287s ] [2026-04-28T22:56:24+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.025509s ] [2026-04-28T22:56:24+08:00][sql] INSERT INTO `erp_admin_log` SET `uid` = 1 , `type` = 'login' , `action` = 'Login' , `subject` = 'System' , `param_id` = 1 , `param` = '[]' , `ip` = '127.0.0.1' , `create_time` = '1777388184' [ RunTime:0.003783s ] [2026-04-28T22:56:25+08:00][sql] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:25+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.045811s ] [2026-04-28T22:56:25+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.004471s ] [2026-04-28T22:56:25+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001557s ] [2026-04-28T22:56:25+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777388185' WHERE `id` = 1 [ RunTime:0.002857s ] [2026-04-28T22:56:25+08:00][sql] SELECT * FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001415s ] [2026-04-28T22:56:25+08:00][sql] SHOW FULL COLUMNS FROM `erp_position_group` [ RunTime:0.022001s ] [2026-04-28T22:56:25+08:00][sql] SELECT `group_id` FROM `erp_position_group` WHERE `pid` = 1 [ RunTime:0.003006s ] [2026-04-28T22:56:25+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_group` [ RunTime:0.021550s ] [2026-04-28T22:56:25+08:00][sql] SELECT `rules` FROM `erp_admin_group` WHERE `id` = 1 [ RunTime:0.001620s ] [2026-04-28T22:56:25+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_rule` [ RunTime:0.025070s ] [2026-04-28T22:56:26+08:00][sql] SELECT * FROM `erp_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.011144s ] [2026-04-28T22:56:28+08:00][sql] CONNECT:[ UseTime:0.024928s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.033770s ] [2026-04-28T22:56:28+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001455s ] [2026-04-28T22:56:28+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001268s ] [2026-04-28T22:56:28+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777388188' WHERE `id` = 1 [ RunTime:0.002248s ] [2026-04-28T22:56:28+08:00][sql] SELECT `auth_dids` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000860s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_expense` [ RunTime:0.015370s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001666s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_invoice` [ RunTime:0.015300s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001570s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_ticket` [ RunTime:0.015985s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001702s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_official_docs` [ RunTime:0.012601s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001356s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_seal` [ RunTime:0.015952s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002666s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_contract` [ RunTime:0.018825s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002367s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_purchase` [ RunTime:0.021066s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002992s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001368s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001164s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001266s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_project_task` [ RunTime:0.022345s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001410s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_customer` [ RunTime:0.022919s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.003257s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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.001411s ] [2026-04-28T22:56:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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.001410s ] [2026-04-28T22:56:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_project_user` [ RunTime:0.023804s ] [2026-04-28T22:56:28+08:00][sql] SELECT `project_id` FROM `erp_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001419s ] [2026-04-28T22:56:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_project` [ RunTime:0.025725s ] [2026-04-28T22:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001396s ] [2026-04-28T22:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001718s ] [2026-04-28T22:56:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_data_auth` [ RunTime:0.033004s ] [2026-04-28T22:56:29+08:00][sql] SELECT `conf_10` FROM `erp_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.002800s ] [2026-04-28T22:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1779980189' ) 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.001632s ] [2026-04-28T22:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1779980189' ) 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.000874s ] [2026-04-28T22:56:29+08:00][sql] SELECT `conf_10` FROM `erp_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.001279s ] [2026-04-28T22:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1777647389' ) [ RunTime:0.001263s ] [2026-04-28T22:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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` < '1777647389' ) [ RunTime:0.001269s ] [2026-04-28T22:56:29+08:00][sql] SELECT `position_id` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001334s ] [2026-04-28T22:56:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_position_group` [ RunTime:0.020547s ] [2026-04-28T22:56:29+08:00][sql] SELECT `group_id` FROM `erp_position_group` WHERE `pid` = 1 [ RunTime:0.001424s ] [2026-04-28T22:56:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_group` [ RunTime:0.018182s ] [2026-04-28T22:56:29+08:00][sql] SELECT `layouts` FROM `erp_admin_group` WHERE `id` = 1 [ RunTime:0.001232s ] [2026-04-28T22:56:41+08:00][sql] CONNECT:[ UseTime:0.019965s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_config` [ RunTime:0.043123s ] [2026-04-28T22:56:41+08:00][sql] SELECT * FROM `erp_config` WHERE `name` = 'token' LIMIT 1 [ RunTime:0.001508s ] [2026-04-28T22:56:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.028533s ] [2026-04-28T22:56:41+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.012517s ] [2026-04-28T22:56:42+08:00][sql] SHOW FULL COLUMNS FROM `erp_note` [ RunTime:0.034118s ] [2026-04-28T22:56:42+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `erp_note` `a` INNER JOIN `erp_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.002695s ] [2026-04-28T22:56:43+08:00][sql] CONNECT:[ UseTime:0.026170s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.026604s ] [2026-04-28T22:56:43+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001522s ] [2026-04-28T22:56:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.021359s ] [2026-04-28T22:56:43+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777305600' AND '1777391999' [ RunTime:0.001426s ] [2026-04-28T22:56:43+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777219200' AND '1777305599' [ RunTime:0.001687s ] [2026-04-28T22:56:43+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1745769600' AND '1777391999' [ RunTime:0.001135s ] [2026-04-28T22:56:43+08:00][sql] CONNECT:[ UseTime:0.002563s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.026220s ] [2026-04-28T22:56:43+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002637s ] [2026-04-28T22:56:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.020856s ] [2026-04-28T22:56:43+08:00][sql] SELECT `id`,`uid` FROM `erp_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1774796203' ) [ RunTime:0.001495s ] [2026-04-28T22:56:43+08:00][sql] CONNECT:[ UseTime:0.001947s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.019504s ] [2026-04-28T22:56:43+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002946s ] [2026-04-28T22:56:43+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001123s ] [2026-04-28T22:56:43+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777388203' WHERE `id` = 1 [ RunTime:0.003549s ] [2026-04-28T22:56:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.019246s ] [2026-04-28T22:56:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001702s ] [2026-04-28T22:56:43+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001537s ] [2026-04-28T22:56:44+08:00][sql] CONNECT:[ UseTime:0.011960s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T22:56:44+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.035095s ] [2026-04-28T22:56:44+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001706s ] [2026-04-28T22:56:44+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.017431s ] [2026-04-28T22:56:44+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777305600' AND '1777391999' [ RunTime:0.001568s ] [2026-04-28T22:56:44+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777219200' AND '1777305599' [ RunTime:0.001422s ] [2026-04-28T22:56:44+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1745769600' AND '1777391999' [ RunTime:0.001285s ] [2026-04-28T23:12:51+08:00][sql] CONNECT:[ UseTime:0.018316s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:12:51+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.025409s ] [2026-04-28T23:12:52+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002374s ] [2026-04-28T23:12:52+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001315s ] [2026-04-28T23:12:52+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777389172' WHERE `id` = 1 [ RunTime:0.002737s ] [2026-04-28T23:12:52+08:00][sql] SELECT `auth_dids` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000865s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_expense` [ RunTime:0.046036s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002886s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_invoice` [ RunTime:0.028079s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002806s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_ticket` [ RunTime:0.029657s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002295s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_official_docs` [ RunTime:0.038037s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002908s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_seal` [ RunTime:0.030742s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001858s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_contract` [ RunTime:0.028064s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002966s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_purchase` [ RunTime:0.022040s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002232s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.002389s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001517s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001303s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_project_task` [ RunTime:0.020811s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.002333s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_customer` [ RunTime:0.042111s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001546s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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.001522s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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.000891s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_project_user` [ RunTime:0.026251s ] [2026-04-28T23:12:52+08:00][sql] SELECT `project_id` FROM `erp_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.002720s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_project` [ RunTime:0.029815s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001549s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001625s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_data_auth` [ RunTime:0.027521s ] [2026-04-28T23:12:52+08:00][sql] SELECT `conf_10` FROM `erp_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.002308s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1779981172' ) 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.001689s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1779981172' ) 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.001358s ] [2026-04-28T23:12:52+08:00][sql] SELECT `conf_10` FROM `erp_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.001171s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1777648372' ) [ RunTime:0.001075s ] [2026-04-28T23:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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` < '1777648372' ) [ RunTime:0.001599s ] [2026-04-28T23:12:52+08:00][sql] SELECT `position_id` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001388s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_position_group` [ RunTime:0.024116s ] [2026-04-28T23:12:52+08:00][sql] SELECT `group_id` FROM `erp_position_group` WHERE `pid` = 1 [ RunTime:0.001843s ] [2026-04-28T23:12:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_group` [ RunTime:0.037286s ] [2026-04-28T23:12:52+08:00][sql] SELECT `layouts` FROM `erp_admin_group` WHERE `id` = 1 [ RunTime:0.002269s ] [2026-04-28T23:12:52+08:00][sql] CONNECT:[ UseTime:0.014401s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:12:53+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.019140s ] [2026-04-28T23:12:53+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001992s ] [2026-04-28T23:12:53+08:00][sql] SHOW FULL COLUMNS FROM `erp_note` [ RunTime:0.039981s ] [2026-04-28T23:12:53+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `erp_note` `a` INNER JOIN `erp_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.001515s ] [2026-04-28T23:12:53+08:00][sql] CONNECT:[ UseTime:0.014440s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:12:53+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.021184s ] [2026-04-28T23:12:53+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001913s ] [2026-04-28T23:12:53+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.022327s ] [2026-04-28T23:12:53+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777305600' AND '1777391999' [ RunTime:0.000959s ] [2026-04-28T23:12:53+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777219200' AND '1777305599' [ RunTime:0.001160s ] [2026-04-28T23:12:53+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1745769600' AND '1777391999' [ RunTime:0.001160s ] [2026-04-28T23:12:54+08:00][sql] CONNECT:[ UseTime:0.002058s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:12:54+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.088571s ] [2026-04-28T23:12:54+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002014s ] [2026-04-28T23:12:54+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.024766s ] [2026-04-28T23:12:54+08:00][sql] SELECT `id`,`uid` FROM `erp_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1774797174' ) [ RunTime:0.001316s ] [2026-04-28T23:12:54+08:00][sql] CONNECT:[ UseTime:0.019446s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:12:54+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.030041s ] [2026-04-28T23:12:54+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001890s ] [2026-04-28T23:12:54+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001271s ] [2026-04-28T23:12:54+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777389174' WHERE `id` = 1 [ RunTime:0.003664s ] [2026-04-28T23:12:54+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.023330s ] [2026-04-28T23:12:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001689s ] [2026-04-28T23:12:54+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001344s ] [2026-04-28T23:12:54+08:00][sql] CONNECT:[ UseTime:0.019020s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:12:54+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.019801s ] [2026-04-28T23:12:54+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001482s ] [2026-04-28T23:12:54+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.029093s ] [2026-04-28T23:12:54+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777305600' AND '1777391999' [ RunTime:0.001328s ] [2026-04-28T23:12:54+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777219200' AND '1777305599' [ RunTime:0.001511s ] [2026-04-28T23:12:54+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1745769600' AND '1777391999' [ RunTime:0.001303s ] [2026-04-28T23:13:04+08:00][sql] CONNECT:[ UseTime:0.018275s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:13:04+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.049717s ] [2026-04-28T23:13:04+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002338s ] [2026-04-28T23:13:04+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001477s ] [2026-04-28T23:13:04+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777389184' WHERE `id` = 1 [ RunTime:0.003939s ] [2026-04-28T23:13:05+08:00][sql] CONNECT:[ UseTime:0.021112s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:13:05+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.035983s ] [2026-04-28T23:13:05+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002851s ] [2026-04-28T23:13:05+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001358s ] [2026-04-28T23:13:05+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777389185' WHERE `id` = 1 [ RunTime:0.004100s ] [2026-04-28T23:13:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE ( `a`.`status` = '1' AND `a`.`id` > '1' ) [ RunTime:0.002777s ] [2026-04-28T23:35:41+08:00][sql] CONNECT:[ UseTime:0.007137s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.045329s ] [2026-04-28T23:35:41+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002489s ] [2026-04-28T23:35:41+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001649s ] [2026-04-28T23:35:41+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390541' WHERE `id` = 1 [ RunTime:0.005192s ] [2026-04-28T23:35:41+08:00][sql] SELECT `auth_dids` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001389s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_expense` [ RunTime:0.023226s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_expense` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001663s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_invoice` [ RunTime:0.021361s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_invoice` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.002675s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_ticket` [ RunTime:0.023394s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_ticket` WHERE ( `delete_time` = '0' AND `check_status` = 2 ) AND ( ( `admin_id` = 1 ) ) [ RunTime:0.001421s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_official_docs` [ RunTime:0.023099s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_official_docs` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001356s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_seal` [ RunTime:0.016931s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_seal` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001579s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_contract` [ RunTime:0.021024s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_contract` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001294s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_purchase` [ RunTime:0.017652s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_purchase` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001670s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_expense` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) [ RunTime:0.001418s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_invoice` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001141s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_ticket` WHERE ( ( FIND_IN_SET('1',check_uids) ) AND `delete_time` = '0' ) AND ( `invoice_type` > 0 ) [ RunTime:0.001242s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_project_task` [ RunTime:0.021666s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project_task` WHERE ( `director_uid` = 1 AND `status` < 3 AND `delete_time` = '0' ) [ RunTime:0.001409s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_customer` [ RunTime:0.016755s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_customer` WHERE ( `delete_time` = '0' ) AND ( ( `belong_uid` = 1 OR ( FIND_IN_SET('1',share_ids) ) ) ) [ RunTime:0.001605s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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.001180s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_project_user` [ RunTime:0.022233s ] [2026-04-28T23:35:41+08:00][sql] SELECT `project_id` FROM `erp_project_user` WHERE `uid` = 1 AND `delete_time` = '0' [ RunTime:0.001382s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_project` [ RunTime:0.014153s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) [ RunTime:0.001017s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project_task` WHERE ( ( ( `admin_id` = 1 ) OR ( `director_uid` = 1 ) OR ( ( FIND_IN_SET(1,assist_admin_ids) ) ) ) ) AND ( `delete_time` = '0' ) [ RunTime:0.001047s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_data_auth` [ RunTime:0.024239s ] [2026-04-28T23:35:41+08:00][sql] SELECT `conf_10` FROM `erp_data_auth` WHERE ( `name` = 'contract_admin' ) LIMIT 1 [ RunTime:0.001403s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_contract` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1779982541' ) 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.001057s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_purchase` WHERE ( `delete_time` = '0' AND `check_status` = 2 AND `end_time` < '1779982541' ) 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-04-28T23:35:41+08:00][sql] SELECT `conf_10` FROM `erp_data_auth` WHERE ( `name` = 'project_admin' ) LIMIT 1 [ RunTime:0.000887s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_project` WHERE ( `delete_time` = '0' AND 0 = 1 ) AND ( `status` < 3 AND `end_time` < '1777649741' ) [ RunTime:0.000823s ] [2026-04-28T23:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_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` < '1777649741' ) [ RunTime:0.000812s ] [2026-04-28T23:35:41+08:00][sql] SELECT `position_id` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000788s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_position_group` [ RunTime:0.015307s ] [2026-04-28T23:35:41+08:00][sql] SELECT `group_id` FROM `erp_position_group` WHERE `pid` = 1 [ RunTime:0.001073s ] [2026-04-28T23:35:41+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_group` [ RunTime:0.021909s ] [2026-04-28T23:35:41+08:00][sql] SELECT `layouts` FROM `erp_admin_group` WHERE `id` = 1 [ RunTime:0.001139s ] [2026-04-28T23:35:42+08:00][sql] CONNECT:[ UseTime:0.000932s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:42+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.017313s ] [2026-04-28T23:35:42+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001128s ] [2026-04-28T23:35:42+08:00][sql] SHOW FULL COLUMNS FROM `erp_note` [ RunTime:0.013422s ] [2026-04-28T23:35:42+08:00][sql] SELECT `a`.`id`,`a`.`title`,`a`.`create_time`,c.title as cate_title FROM `erp_note` `a` INNER JOIN `erp_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.002337s ] [2026-04-28T23:35:42+08:00][sql] CONNECT:[ UseTime:0.008964s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:42+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.013254s ] [2026-04-28T23:35:42+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001265s ] [2026-04-28T23:35:42+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.009112s ] [2026-04-28T23:35:42+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777305600' AND '1777391999' [ RunTime:0.001312s ] [2026-04-28T23:35:42+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777219200' AND '1777305599' [ RunTime:0.000503s ] [2026-04-28T23:35:42+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1745769600' AND '1777391999' [ RunTime:0.000381s ] [2026-04-28T23:35:43+08:00][sql] CONNECT:[ UseTime:0.013250s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.031376s ] [2026-04-28T23:35:43+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002040s ] [2026-04-28T23:35:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.018314s ] [2026-04-28T23:35:43+08:00][sql] SELECT `id`,`uid` FROM `erp_admin_log` WHERE ( `uid` <> 1 AND `create_time` > '1774798543' ) [ RunTime:0.001076s ] [2026-04-28T23:35:43+08:00][sql] CONNECT:[ UseTime:0.011842s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.016166s ] [2026-04-28T23:35:43+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002011s ] [2026-04-28T23:35:43+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001358s ] [2026-04-28T23:35:43+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390543' WHERE `id` = 1 [ RunTime:0.004369s ] [2026-04-28T23:35:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.011661s ] [2026-04-28T23:35:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.000859s ] [2026-04-28T23:35:43+08:00][sql] SELECT `a`.`id`,`a`.`uid`,`a`.`type`,`a`.`subject`,`a`.`action`,`a`.`create_time`,`u`.`name` FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001246s ] [2026-04-28T23:35:43+08:00][sql] CONNECT:[ UseTime:0.021204s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.013403s ] [2026-04-28T23:35:43+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001178s ] [2026-04-28T23:35:43+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.013918s ] [2026-04-28T23:35:43+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777305600' AND '1777391999' [ RunTime:0.000844s ] [2026-04-28T23:35:43+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1777219200' AND '1777305599' [ RunTime:0.000782s ] [2026-04-28T23:35:43+08:00][sql] SELECT `create_time` FROM `erp_admin_log` WHERE `create_time` BETWEEN '1745769600' AND '1777391999' [ RunTime:0.000716s ] [2026-04-28T23:35:46+08:00][sql] CONNECT:[ UseTime:0.002936s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:46+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.045657s ] [2026-04-28T23:35:46+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001823s ] [2026-04-28T23:35:46+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001030s ] [2026-04-28T23:35:46+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390546' WHERE `id` = 1 [ RunTime:0.004847s ] [2026-04-28T23:35:46+08:00][sql] CONNECT:[ UseTime:0.007075s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:46+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.015754s ] [2026-04-28T23:35:46+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001701s ] [2026-04-28T23:35:46+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001312s ] [2026-04-28T23:35:46+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390546' WHERE `id` = 1 [ RunTime:0.000939s ] [2026-04-28T23:35:46+08:00][sql] SHOW FULL COLUMNS FROM `erp_config` [ RunTime:0.013857s ] [2026-04-28T23:35:46+08:00][sql] SELECT * FROM `erp_config` WHERE ( `status` >= 0 ) [ RunTime:0.002631s ] [2026-04-28T23:35:54+08:00][sql] CONNECT:[ UseTime:0.005614s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:54+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.039617s ] [2026-04-28T23:35:54+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002441s ] [2026-04-28T23:35:54+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002368s ] [2026-04-28T23:35:54+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390554' WHERE `id` = 1 [ RunTime:0.005051s ] [2026-04-28T23:35:55+08:00][sql] CONNECT:[ UseTime:0.013961s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:35:55+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.038165s ] [2026-04-28T23:35:55+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001451s ] [2026-04-28T23:35:55+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000789s ] [2026-04-28T23:35:55+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390555' WHERE `id` = 1 [ RunTime:0.004753s ] [2026-04-28T23:35:55+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_group` [ RunTime:0.012086s ] [2026-04-28T23:35:55+08:00][sql] SELECT * FROM `erp_admin_group` ORDER BY `create_time` ASC [ RunTime:0.002851s ] [2026-04-28T23:36:00+08:00][sql] CONNECT:[ UseTime:0.001597s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:00+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.031429s ] [2026-04-28T23:36:00+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001541s ] [2026-04-28T23:36:00+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001011s ] [2026-04-28T23:36:00+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390560' WHERE `id` = 1 [ RunTime:0.004917s ] [2026-04-28T23:36:00+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_rule` [ RunTime:0.017559s ] [2026-04-28T23:36:00+08:00][sql] SELECT * FROM `erp_admin_rule` WHERE `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007135s ] [2026-04-28T23:36:00+08:00][sql] SHOW FULL COLUMNS FROM `erp_mobile_bar` [ RunTime:0.015164s ] [2026-04-28T23:36:00+08:00][sql] SELECT `id`,`url`,`title`,`icon` FROM `erp_mobile_bar` WHERE ( `status` = 1 ) [ RunTime:0.002623s ] [2026-04-28T23:36:00+08:00][sql] SHOW FULL COLUMNS FROM `erp_mobile_types` [ RunTime:0.016675s ] [2026-04-28T23:36:00+08:00][sql] SELECT * FROM `erp_mobile_types` WHERE `status` = 1 [ RunTime:0.002877s ] [2026-04-28T23:36:01+08:00][sql] SHOW FULL COLUMNS FROM `erp_mobile_menu` [ RunTime:0.022448s ] [2026-04-28T23:36:01+08:00][sql] SELECT * FROM `erp_mobile_menu` WHERE ( `types` = 1 AND `status` = 1 ) [ RunTime:0.002324s ] [2026-04-28T23:36:01+08:00][sql] SELECT * FROM `erp_mobile_menu` WHERE ( `types` = 2 AND `status` = 1 ) [ RunTime:0.001177s ] [2026-04-28T23:36:01+08:00][sql] SELECT * FROM `erp_mobile_menu` WHERE ( `types` = 3 AND `status` = 1 ) [ RunTime:0.001229s ] [2026-04-28T23:36:01+08:00][sql] SELECT * FROM `erp_mobile_menu` WHERE ( `types` = 4 AND `status` = 1 ) [ RunTime:0.001354s ] [2026-04-28T23:36:19+08:00][sql] CONNECT:[ UseTime:0.007961s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:19+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.032601s ] [2026-04-28T23:36:19+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002306s ] [2026-04-28T23:36:19+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001770s ] [2026-04-28T23:36:19+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390579' WHERE `id` = 1 [ RunTime:0.006086s ] [2026-04-28T23:36:20+08:00][sql] CONNECT:[ UseTime:0.010884s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:20+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.031883s ] [2026-04-28T23:36:20+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001723s ] [2026-04-28T23:36:20+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001163s ] [2026-04-28T23:36:20+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390580' WHERE `id` = 1 [ RunTime:0.005983s ] [2026-04-28T23:36:20+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_log` [ RunTime:0.018798s ] [2026-04-28T23:36:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` [ RunTime:0.001449s ] [2026-04-28T23:36:20+08:00][sql] SELECT `a`.*,`u`.`name` FROM `erp_admin_log` `a` INNER JOIN `erp_admin` `u` ON `a`.`uid`=`u`.`id` ORDER BY `a`.`create_time` DESC LIMIT 0,20 [ RunTime:0.001568s ] [2026-04-28T23:36:28+08:00][sql] CONNECT:[ UseTime:0.008009s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:28+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.027713s ] [2026-04-28T23:36:28+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002412s ] [2026-04-28T23:36:28+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001325s ] [2026-04-28T23:36:28+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390588' WHERE `id` = 1 [ RunTime:0.005831s ] [2026-04-28T23:36:29+08:00][sql] CONNECT:[ UseTime:0.005526s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.045840s ] [2026-04-28T23:36:29+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002120s ] [2026-04-28T23:36:29+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001288s ] [2026-04-28T23:36:29+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390589' WHERE `id` = 1 [ RunTime:0.005860s ] [2026-04-28T23:36:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_file` [ RunTime:0.020321s ] [2026-04-28T23:36:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_file` `f` LEFT JOIN `erp_admin` `a` ON `f`.`admin_id`=`a`.`id` LEFT JOIN `erp_file_group` `g` ON `f`.`group_id`=`g`.`id` WHERE ( `f`.`delete_time` = '0' ) [ RunTime:0.006644s ] [2026-04-28T23:36:29+08:00][sql] SELECT `f`.*,a.name as admin_name,g.title as group_title FROM `erp_file` `f` LEFT JOIN `erp_admin` `a` ON `f`.`admin_id`=`a`.`id` LEFT JOIN `erp_file_group` `g` ON `f`.`group_id`=`g`.`id` WHERE ( `f`.`delete_time` = '0' ) ORDER BY `f`.`create_time` DESC LIMIT 0,44 [ RunTime:0.003017s ] [2026-04-28T23:36:29+08:00][sql] CONNECT:[ UseTime:0.013278s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.018244s ] [2026-04-28T23:36:29+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002078s ] [2026-04-28T23:36:29+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001148s ] [2026-04-28T23:36:29+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390589' WHERE `id` = 1 [ RunTime:0.001161s ] [2026-04-28T23:36:29+08:00][sql] SHOW FULL COLUMNS FROM `erp_file_group` [ RunTime:0.016388s ] [2026-04-28T23:36:29+08:00][sql] SELECT * FROM `erp_file_group` WHERE ( `delete_time` = '0' ) [ RunTime:0.001508s ] [2026-04-28T23:36:35+08:00][sql] CONNECT:[ UseTime:0.024261s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:35+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.041409s ] [2026-04-28T23:36:35+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.002118s ] [2026-04-28T23:36:35+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001556s ] [2026-04-28T23:36:35+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390595' WHERE `id` = 1 [ RunTime:0.005317s ] [2026-04-28T23:36:37+08:00][sql] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:37+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.025045s ] [2026-04-28T23:36:37+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001929s ] [2026-04-28T23:36:37+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001444s ] [2026-04-28T23:36:37+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390597' WHERE `id` = 1 [ RunTime:0.004529s ] [2026-04-28T23:36:38+08:00][sql] CONNECT:[ UseTime:0.013605s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:38+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.030643s ] [2026-04-28T23:36:38+08:00][sql] SELECT `a`.*,d.title as department,p.title as position FROM `erp_admin` `a` LEFT JOIN `erp_department` `d` ON `d`.`id`=`a`.`did` LEFT JOIN `erp_position` `p` ON `p`.`id`=`a`.`position_id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.001948s ] [2026-04-28T23:36:38+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001483s ] [2026-04-28T23:36:38+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390598' WHERE `id` = 1 [ RunTime:0.004862s ] [2026-04-28T23:36:38+08:00][sql] SHOW FULL COLUMNS FROM `erp_timing_task` [ RunTime:0.018495s ] [2026-04-28T23:36:38+08:00][sql] SELECT * FROM `erp_timing_task` WHERE `delete_time` = '0' [ RunTime:0.002688s ]