[2026-04-28T23:09:49+08:00][sql] CONNECT:[ UseTime:0.001806s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:09:49+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.031458s ] [2026-04-28T23:09:49+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.001373s ] [2026-04-28T23:09:49+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000597s ] [2026-04-28T23:09:49+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777388989' WHERE `id` = 1 [ RunTime:0.003543s ] [2026-04-28T23:09:49+08:00][sql] SELECT `position_id` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001261s ] [2026-04-28T23:09:49+08:00][sql] SHOW FULL COLUMNS FROM `erp_position_group` [ RunTime:0.019648s ] [2026-04-28T23:09:49+08:00][sql] SELECT * FROM `erp_position_group` `a` LEFT JOIN `erp_admin_group` `g` ON `a`.`group_id`=`g`.`id` WHERE ( `a`.`pid` = '1' AND `g`.`status` = '1' ) [ RunTime:0.002308s ] [2026-04-28T23:09:49+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin_rule` [ RunTime:0.019051s ] [2026-04-28T23:09:49+08:00][sql] SELECT `src` FROM `erp_admin_rule` [ RunTime:0.002033s ] [2026-04-28T23:09:49+08:00][sql] SELECT `src` FROM `erp_admin_rule` WHERE `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) [ RunTime:0.003812s ] [2026-04-28T23:09:49+08:00][sql] SHOW FULL COLUMNS FROM `erp_labor_contract` [ RunTime:0.014918s ] [2026-04-28T23:09:49+08:00][sql] UPDATE `erp_labor_contract` SET `status` = 2 WHERE ( `end_time` < '1777388989' AND `status` = 1 ) [ RunTime:0.001933s ] [2026-04-28T23:09:51+08:00][sql] CONNECT:[ UseTime:0.002538s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:09:51+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.053173s ] [2026-04-28T23:09:51+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.003793s ] [2026-04-28T23:09:51+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000980s ] [2026-04-28T23:09:51+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777388991' WHERE `id` = 1 [ RunTime:0.002403s ] [2026-04-28T23:09:51+08:00][sql] SHOW FULL COLUMNS FROM `erp_labor_contract` [ RunTime:0.027545s ] [2026-04-28T23:09:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_labor_contract` WHERE ( `delete_time` = '0' ) [ RunTime:0.001742s ] [2026-04-28T23:10:00+08:00][sql] CONNECT:[ UseTime:0.002357s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:10:00+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.043546s ] [2026-04-28T23:10: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.002529s ] [2026-04-28T23:10:00+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001513s ] [2026-04-28T23:10:00+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777389000' WHERE `id` = 1 [ RunTime:0.003596s ] [2026-04-28T23:10:00+08:00][sql] SHOW FULL COLUMNS FROM `erp_talent` [ RunTime:0.026401s ] [2026-04-28T23:10:09+08:00][sql] CONNECT:[ UseTime:0.014988s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:10:09+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.027693s ] [2026-04-28T23:10:09+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.001748s ] [2026-04-28T23:10:09+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001311s ] [2026-04-28T23:10:09+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777389009' WHERE `id` = 1 [ RunTime:0.003244s ] [2026-04-28T23:10:09+08:00][sql] SHOW FULL COLUMNS FROM `erp_blacklist` [ RunTime:0.022142s ] [2026-04-28T23:10:10+08:00][sql] CONNECT:[ UseTime:0.003043s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:10:10+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.058453s ] [2026-04-28T23:10:10+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.004370s ] [2026-04-28T23:10:10+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001677s ] [2026-04-28T23:10:10+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777389010' WHERE `id` = 1 [ RunTime:0.003724s ] [2026-04-28T23:10:10+08:00][sql] SHOW FULL COLUMNS FROM `erp_blacklist` [ RunTime:0.040983s ] [2026-04-28T23:10:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `erp_blacklist` WHERE ( `delete_time` = '0' ) [ RunTime:0.002613s ] [2026-04-28T23:36:44+08:00][sql] CONNECT:[ UseTime:0.009666s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:44+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.036293s ] [2026-04-28T23:36: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.002042s ] [2026-04-28T23:36:44+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001411s ] [2026-04-28T23:36:44+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390604' WHERE `id` = 1 [ RunTime:0.005582s ] [2026-04-28T23:36:45+08:00][sql] CONNECT:[ UseTime:0.017720s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:45+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.009079s ] [2026-04-28T23:36:45+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.001282s ] [2026-04-28T23:36:45+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000860s ] [2026-04-28T23:36:45+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390605' WHERE `id` = 1 [ RunTime:0.004835s ] [2026-04-28T23:36:45+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` < '2' ) [ RunTime:0.001086s ] [2026-04-28T23:36:45+08:00][sql] SELECT `a`.*,p.title as position,d.title as department 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` < '2' ) LIMIT 0,20 [ RunTime:0.001157s ] [2026-04-28T23:36:45+08:00][sql] SHOW FULL COLUMNS FROM `erp_department` [ RunTime:0.009588s ] [2026-04-28T23:36:46+08:00][sql] SHOW FULL COLUMNS FROM `erp_department_admin` [ RunTime:0.027373s ] [2026-04-28T23:36:46+08:00][sql] SELECT `erp_department`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`admin_id` AS `pivot__admin_id`,`pivot`.`department_id` AS `pivot__department_id`,`pivot`.`create_time` AS `pivot__create_time` FROM `erp_department` INNER JOIN `erp_department_admin` `pivot` ON `pivot`.`department_id`=`erp_department`.`id` WHERE ( `pivot`.`admin_id` = '1' ) [ RunTime:0.001006s ] [2026-04-28T23:36:52+08:00][sql] CONNECT:[ UseTime:0.019405s ] mysql:host=127.0.0.1;port=3306;dbname=myproerp_erp_system;charset=utf8mb4 [2026-04-28T23:36:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_admin` [ RunTime:0.042918s ] [2026-04-28T23:36: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.002997s ] [2026-04-28T23:36:52+08:00][sql] SELECT `last_login_time` FROM `erp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001628s ] [2026-04-28T23:36:52+08:00][sql] UPDATE `erp_admin` SET `last_login_time` = '1777390612' WHERE `id` = 1 [ RunTime:0.005695s ] [2026-04-28T23:36:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_department` [ RunTime:0.023028s ] [2026-04-28T23:36:52+08:00][sql] SELECT * FROM `erp_department` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002074s ] [2026-04-28T23:36:52+08:00][sql] SHOW FULL COLUMNS FROM `erp_position` [ RunTime:0.022071s ] [2026-04-28T23:36:52+08:00][sql] SELECT * FROM `erp_position` WHERE `status` >= 0 ORDER BY `create_time` ASC [ RunTime:0.001653s ]