[2026-11-07T23:47:06+08:00][sql] CONNECT:[ UseTime:0.025535s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:06+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1044 LIMIT 1 [ RunTime:0.000622s ] [2026-11-07T23:47:06+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715224' LIMIT 1 [ RunTime:0.000753s ] [2026-11-07T23:47:06+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 LIMIT 1 [ RunTime:0.000502s ] [2026-11-07T23:47:06+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000504s ] [2026-11-07T23:47:06+08:00][sql] SELECT `id`,`title`,`icon`,`icon_color`,`action`,`route`,`user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `status` = 1 ORDER BY `sort`,`id` [ RunTime:0.000621s ] [2026-11-07T23:47:08+08:00][sql] CONNECT:[ UseTime:0.011984s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1044 LIMIT 1 [ RunTime:0.000611s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715224' LIMIT 1 [ RunTime:0.000780s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 LIMIT 1 [ RunTime:0.000491s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000546s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000983s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000593s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 297 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000514s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.001191s ] [2026-11-07T23:47:08+08:00][sql] SELECT DISTINCT `line` FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 [ RunTime:0.001889s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `id` IN (34,316,33,550,632,319,303,302,436,748,813,572,21,749,815,549,885,872,886,24,25,874,537,20,875,859,551,750,305,884,584,814,747,707,873,294,437,919,22,871,304,434,438,640,812,726,661,468,287,290,443,444,288,547,281,32,637,447,320,338,341,340,339,342,277,317,51,548,278,279,313,280,35,724,300,589,578,708,638,639,641,648,649,650,657,651,728,709,710,732,751,603) ORDER BY `title` [ RunTime:0.001123s ] [2026-11-07T23:47:08+08:00][sql] SELECT `line` FROM `oms_team_list` WHERE `id` = 297 LIMIT 1 [ RunTime:0.000354s ] [2026-11-07T23:47:08+08:00][sql] SELECT DISTINCT `type` FROM `oms_me_machine_list` WHERE `line` = 814 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.001333s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` WHERE `id` IN (695,705,903,162,159,165,957,956,981,912) ORDER BY `title` [ RunTime:0.000831s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000832s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 297 LIMIT 1 [ RunTime:0.000473s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 811 LIMIT 1 [ RunTime:0.000773s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`position`,`type`,`order` FROM `oms_team_plan_position` WHERE `plan_id` = 811 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.003515s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`eid`,`ename`,`tid`,`poid`,`indirect`,`status` FROM `oms_member_list` WHERE `tid` = 297 AND `status` = 1 ORDER BY `eid`,`id` [ RunTime:0.005120s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000749s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 ORDER BY `project`,`line`,`team`,`id` [ RunTime:0.001014s ] [2026-11-07T23:47:08+08:00][sql] CONNECT:[ UseTime:0.012943s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1044 LIMIT 1 [ RunTime:0.002478s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715224' LIMIT 1 [ RunTime:0.000835s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 LIMIT 1 [ RunTime:0.000484s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000670s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000567s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000691s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000669s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 297 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000646s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000678s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000512s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 AND `plan_id` = 811 AND `status` = 1 LIMIT 1 [ RunTime:0.001100s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 811 LIMIT 1 [ RunTime:0.001220s ] [2026-11-07T23:47:08+08:00][sql] SELECT `m_id` FROM `oms_me_position_device` WHERE `plan_id` = 811 AND `poid` = 19543 [ RunTime:0.001720s ] [2026-11-07T23:47:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `id` = 5686 AND `line` = 814 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.000544s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5686 AND `line` = 814 AND `status` = 1 AND `is_check` = 1 ORDER BY `id` LIMIT 0,20 [ RunTime:0.000523s ] [2026-11-07T23:47:08+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066429 [ RunTime:0.000961s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001519s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000621s ] [2026-11-07T23:47:08+08:00][sql] SELECT GET_LOCK('oms-check-catalog:c9ed4d5318ce7b8b2b4679b43e3b4e7d69f14121',0) acquired [ RunTime:0.000418s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 159 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.000797s ] [2026-11-07T23:47:08+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:c9ed4d5318ce7b8b2b4679b43e3b4e7d69f14121') [ RunTime:0.000426s ] [2026-11-07T23:47:08+08:00][sql] SELECT GET_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b',0) acquired [ RunTime:0.000458s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` [ RunTime:0.001223s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000657s ] [2026-11-07T23:47:08+08:00][sql] SELECT `l`.`id`,`p`.`title` FROM `oms_team_base` `l` LEFT JOIN `oms_team_base` `p` ON `p`.`id`=l.mark AND p.mid=1 WHERE `l`.`mid` = 2 [ RunTime:0.001717s ] [2026-11-07T23:47:08+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b') [ RunTime:0.000421s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 14650 [ RunTime:0.000466s ] [2026-11-07T23:47:08+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5686 AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.001627s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001665s ] [2026-11-07T23:47:08+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.000628s ] [2026-11-07T23:47:08+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000673s ] [2026-11-07T23:47:09+08:00][sql] CONNECT:[ UseTime:0.015727s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1044 LIMIT 1 [ RunTime:0.000582s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715224' LIMIT 1 [ RunTime:0.000870s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 LIMIT 1 [ RunTime:0.000490s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000527s ] [2026-11-07T23:47:09+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000746s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000694s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 297 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000628s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5686 LIMIT 1 [ RunTime:0.000503s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.001687s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000538s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000516s ] [2026-11-07T23:47:09+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066430 [ RunTime:0.000838s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001523s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 LIMIT 1 [ RunTime:0.000513s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001659s ] [2026-11-07T23:47:09+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 14650 [ RunTime:0.000654s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77465,77466,77467,77468,77469,77470,77471,77472,77473,77474,77475,77476,77477,77478,77479,77480) ORDER BY `id` [ RunTime:0.001740s ] [2026-11-07T23:47:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5686 AND `i`.`status` IN (1,2) [ RunTime:0.000590s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000536s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 AND `plan_id` = 811 AND `status` = 1 LIMIT 1 [ RunTime:0.000456s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 811 LIMIT 1 [ RunTime:0.000452s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.001612s ] [2026-11-07T23:47:09+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000673s ] [2026-11-07T23:47:09+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.000647s ] [2026-11-07T23:47:09+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000665s ] [2026-11-07T23:47:22+08:00][sql] CONNECT:[ UseTime:0.013776s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1044 LIMIT 1 [ RunTime:0.001821s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715224' LIMIT 1 [ RunTime:0.000847s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 LIMIT 1 [ RunTime:0.000554s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000607s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000528s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000874s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000721s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 297 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000773s ] [2026-11-07T23:47:22+08:00][sql] SELECT GET_LOCK('oms-check:6a1cbd82036ab812760034682f9eb6f5a839b21b',5) acquired [ RunTime:0.000544s ] [2026-11-07T23:47:22+08:00][sql] SELECT GET_LOCK('employee:2747abf107b1235889ac85c4dc895a6308830703dd5a18b8',5) acquired [ RunTime:0.000725s ] [2026-11-07T23:47:22+08:00][sql] SELECT GET_LOCK('position-device:2747abf107b1235889ac85c4dc895a6308830703',5) acquired [ RunTime:0.000325s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 297 LIMIT 1 [ RunTime:0.000506s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000590s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5686 LIMIT 1 [ RunTime:0.000909s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000631s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000460s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000402s ] [2026-11-07T23:47:22+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066443 [ RunTime:0.000936s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.002776s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 LIMIT 1 [ RunTime:0.001315s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.002072s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 159 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.000833s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 14650 [ RunTime:0.000394s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77465,77466,77467,77468,77469,77470,77471,77472,77473,77474,77475,77476,77477,77478,77479,77480) ORDER BY `id` [ RunTime:0.000672s ] [2026-11-07T23:47:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5686 AND `i`.`status` IN (1,2) [ RunTime:0.000680s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000565s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 AND `plan_id` = 811 AND `status` = 1 LIMIT 1 [ RunTime:0.000563s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 811 LIMIT 1 [ RunTime:0.001295s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.001942s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000464s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.000377s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000462s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000375s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 AND `plan_id` = 811 AND `status` = 1 LIMIT 1 [ RunTime:0.000317s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 811 LIMIT 1 [ RunTime:0.000297s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.000359s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000434s ] [2026-11-07T23:47:22+08:00][sql] INSERT INTO `oms_me_check_record` SET `m_id` = 5686 , `check_id` = 260 , `check_date` = 1793980800 , `shift` = 2 , `tid` = 297 , `mid` = 14650 , `result` = 1 , `mark` = '' , `update` = 1794066442 , `status` = 1 [ RunTime:0.000360s ] [2026-11-07T23:47:22+08:00][sql] INSERT INTO `oms_me_check_record` SET `m_id` = 5686 , `check_id` = 261 , `check_date` = 1793980800 , `shift` = 2 , `tid` = 297 , `mid` = 14650 , `result` = 1 , `mark` = '' , `update` = 1794066442 , `status` = 1 [ RunTime:0.000313s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5686 LIMIT 1 [ RunTime:0.000345s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000485s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000365s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000392s ] [2026-11-07T23:47:22+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066443 [ RunTime:0.001326s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.000611s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 LIMIT 1 [ RunTime:0.000483s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 14650 [ RunTime:0.000752s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77465,77466,77467,77468,77469,77470,77471,77472,77473,77474,77475,77476,77477,77478,77479,77480,79244,79245) ORDER BY `id` [ RunTime:0.000723s ] [2026-11-07T23:47:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5686 AND `i`.`status` IN (1,2) [ RunTime:0.001062s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000601s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 AND `plan_id` = 811 AND `status` = 1 LIMIT 1 [ RunTime:0.000496s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 811 LIMIT 1 [ RunTime:0.000411s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.000506s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000503s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.000512s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000795s ] [2026-11-07T23:47:22+08:00][sql] SELECT RELEASE_LOCK('position-device:2747abf107b1235889ac85c4dc895a6308830703') [ RunTime:0.000505s ] [2026-11-07T23:47:22+08:00][sql] SELECT RELEASE_LOCK('employee:2747abf107b1235889ac85c4dc895a6308830703dd5a18b8') [ RunTime:0.000269s ] [2026-11-07T23:47:22+08:00][sql] SELECT RELEASE_LOCK('oms-check:6a1cbd82036ab812760034682f9eb6f5a839b21b') [ RunTime:0.000409s ] [2026-11-07T23:47:22+08:00][sql] CONNECT:[ UseTime:0.013961s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1044 LIMIT 1 [ RunTime:0.000783s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715224' LIMIT 1 [ RunTime:0.001120s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 LIMIT 1 [ RunTime:0.000522s ] [2026-11-07T23:47:22+08:00][sql] SELECT GET_LOCK('oms-inbox:adb49c9440d32d9b181a7b99e49599a4b0f7d6d3',5) acquired [ RunTime:0.000469s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980042 [ RunTime:0.002164s ] [2026-11-07T23:47:22+08:00][sql] SELECT 1 [ RunTime:0.000396s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000617s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000573s ] [2026-11-07T23:47:22+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000650s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000594s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 715224 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791474442 ) ) ) ) [ RunTime:0.006282s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '715224' AND `status` = 4 AND `update` >= 1791474442 ) ) [ RunTime:0.001814s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000573s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 715224 AND ( `status` = 1 OR `update` >= 1791474442 ) ) ) [ RunTime:0.001026s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000467s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000661s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14650 AND `status` IN (2,3) AND `update` >= 1791474442 [ RunTime:0.003351s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000609s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14650 AND `exam_date` > 1794062842 AND `status` IN (1,3) [ RunTime:0.001373s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14650 AND `status` = 2 AND `exam_date` >= 1791474442 [ RunTime:0.001006s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 715224 AND `status` > 0 AND `eff_date` >= 1791474442 [ RunTime:0.001013s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001223s ] [2026-11-07T23:47:22+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 1044 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.002932s ] [2026-11-07T23:47:22+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791474442 [ RunTime:0.001708s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791474442 OR `update` >= 1791474442 OR `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) ) [ RunTime:0.001992s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.001811s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.001035s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.000914s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000700s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.001229s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000906s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000625s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.001032s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.001890s ] [2026-11-07T23:47:22+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066442 WHERE `auth_id` = 1044 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000508s ] [2026-11-07T23:47:22+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066442 WHERE `auth_id` = 1044 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000561s ] [2026-11-07T23:47:22+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066442 WHERE `auth_id` = 1044 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000439s ] [2026-11-07T23:47:22+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 1044 GROUP BY `state` [ RunTime:0.000490s ] [2026-11-07T23:47:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 1044 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000498s ] [2026-11-07T23:47:22+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:adb49c9440d32d9b181a7b99e49599a4b0f7d6d3') [ RunTime:0.000321s ] [2026-11-07T23:47:22+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 1044 AND `state` IN ('pending','notice') [ RunTime:0.000519s ] [2026-11-07T23:47:22+08:00][sql] CONNECT:[ UseTime:0.012102s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1044 LIMIT 1 [ RunTime:0.002628s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715224' LIMIT 1 [ RunTime:0.000863s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 LIMIT 1 [ RunTime:0.000528s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000598s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000495s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000696s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000531s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 297 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000614s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `eid` = '715224' AND `status` = 1 LIMIT 1 [ RunTime:0.000571s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14650 AND `status` = 1 LIMIT 1 [ RunTime:0.000553s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19543 AND `plan_id` = 811 AND `status` = 1 LIMIT 1 [ RunTime:0.000893s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 811 LIMIT 1 [ RunTime:0.000788s ] [2026-11-07T23:47:22+08:00][sql] SELECT `m_id` FROM `oms_me_position_device` WHERE `plan_id` = 811 AND `poid` = 19543 [ RunTime:0.001591s ] [2026-11-07T23:47:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `id` = 5686 AND `line` = 814 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.000453s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5686 AND `line` = 814 AND `status` = 1 AND `is_check` = 1 ORDER BY `id` LIMIT 0,20 [ RunTime:0.000585s ] [2026-11-07T23:47:22+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066443 [ RunTime:0.000884s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001595s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5686 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000658s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 14650 [ RunTime:0.000445s ] [2026-11-07T23:47:22+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5686 AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.000639s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001759s ] [2026-11-07T23:47:22+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 811 ORDER BY `m_id` [ RunTime:0.000569s ] [2026-11-07T23:47:22+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19532,19541,19542,19540,19533,19529,19543,19544,20295,19534,19531,19535,19537,19536,19539,19538,19577) [ RunTime:0.000790s ] [2026-11-07T23:47:24+08:00][sql] CONNECT:[ UseTime:0.015576s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000570s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000613s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000499s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 LIMIT 1 [ RunTime:0.000523s ] [2026-11-07T23:47:24+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000478s ] [2026-11-07T23:47:24+08:00][sql] SELECT `user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `action` = 'afterSalesRepair' AND `status` = 1 LIMIT 1 [ RunTime:0.000614s ] [2026-11-07T23:47:24+08:00][sql] SELECT GET_LOCK('repair:40fb95fdd5eced9ff7bb8e3cfe3190c34a915fc65c2dbb95',5) acquired [ RunTime:0.000422s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000524s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000629s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000521s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 LIMIT 1 [ RunTime:0.000532s ] [2026-11-07T23:47:24+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000539s ] [2026-11-07T23:47:24+08:00][sql] SELECT `user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `action` = 'afterSalesRepair' AND `status` = 1 LIMIT 1 [ RunTime:0.000519s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_after_sales_repair` WHERE `id` = 264 AND `creator_id` = 205 AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.000803s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_after_sales_repair_image` WHERE `repair_id` = 264 ORDER BY `image_type`,`id` [ RunTime:0.000656s ] [2026-11-07T23:47:24+08:00][sql] UPDATE `oms_after_sales_repair` SET `trace_no` = '27286361' , `project` = 'F710S' , `harness_name` = '仪表线束' , `problem_description` = '连接喇叭插头损坏' , `repair_method` = '更换插头' , `repair_area` = '其他区域' , `repair_at` = '2026-11-07 23:44:00' , `remark` = '车架号为零件号 生产日期2026/10/29 P36156161933526091646' , `updated_at` = '2026-11-07 23:47:24' , `revision` = 2 WHERE `id` = 264 AND `creator_id` = 205 AND `revision` = 1 AND `deleted_at` IS NULL [ RunTime:0.000589s ] [2026-11-07T23:47:24+08:00][sql] DELETE FROM `oms_after_sales_repair_person` WHERE `repair_id` = 264 [ RunTime:0.000491s ] [2026-11-07T23:47:24+08:00][sql] DELETE FROM `oms_after_sales_repair_image` WHERE `repair_id` = 264 AND `id` NOT IN (438,439) [ RunTime:0.000507s ] [2026-11-07T23:47:24+08:00][sql] SELECT RELEASE_LOCK('repair:40fb95fdd5eced9ff7bb8e3cfe3190c34a915fc65c2dbb95') [ RunTime:0.000548s ] [2026-11-07T23:47:24+08:00][sql] CONNECT:[ UseTime:0.011100s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000602s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000694s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000486s ] [2026-11-07T23:47:24+08:00][sql] SELECT GET_LOCK('oms-inbox:ae442a2b78cca1232d8db9e9dfc163fa713c7e8a',5) acquired [ RunTime:0.000528s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `status` = 1 AND `username` = '284971' AND `job` <> 79 LIMIT 1 [ RunTime:0.000598s ] [2026-11-07T23:47:24+08:00][sql] SELECT `s_id` FROM `oms_common_visitor_step` WHERE `aid` = 205 AND `status` IN (0,2) AND `update` >= 1791474444 [ RunTime:0.001495s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_common_visitor_list` WHERE ( `status` = 1 AND `aid` = 205 OR ( `owner` = 205 AND `status` IN (-1,0,2) AND `create_date` >= 1791474444 ) ) [ RunTime:0.002033s ] [2026-11-07T23:47:24+08:00][sql] SELECT `mark`,`title` FROM `oms_onsite_base` WHERE `mid` = 718 [ RunTime:0.001771s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_common_outplant` WHERE `type` = 2 AND ( `on_check` = 205 OR ( `owner` = 205 AND `ownerType` > 1 AND `status` IN (0,4,5) AND `create_time` >= 1791474444 ) OR ( `apv1` = 205 AND `apv1_time` >= 1791474444 ) OR ( `apv2` = 205 AND `apv2_time` >= 1791474444 ) OR ( `apv3` = 205 AND `apv3_time` >= 1791474444 ) ) [ RunTime:0.009408s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_common_outplant_back` WHERE `schema_version` = 1 AND ( `apv` = 205 AND `status` = 1 OR ( `apv` = 205 AND `apv_time` >= 1791474444 ) OR ( `owner` = 205 AND `status` IN (0,2) AND `apv_time` >= 1791474444 ) ) [ RunTime:0.001818s ] [2026-11-07T23:47:24+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980044 [ RunTime:0.001768s ] [2026-11-07T23:47:24+08:00][sql] SELECT 1 [ RunTime:0.000425s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000551s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000532s ] [2026-11-07T23:47:24+08:00][sql] SELECT `mark` FROM `oms_member_base` WHERE `mid` = 3 AND `title` = '205' [ RunTime:0.000593s ] [2026-11-07T23:47:24+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000540s ] [2026-11-07T23:47:24+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000443s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 284971 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791474444 ) ) ) OR ( `owner` = 205 AND ( `status` IN (2,3) OR ( `status` = 4 AND `update` >= 1791474444 ) ) ) OR ( `transfer_to` = 205 AND `transfer_id` > 0 ) ) [ RunTime:0.006189s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `state` <> 'pending' AND `handled_at` >= 1791474444 AND ( `from_owner` = 205 OR `to_owner` = 205 ) [ RunTime:0.000663s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `dpt` = 53 AND `status` = 1 AND `username` = '284971' LIMIT 1 [ RunTime:0.000653s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '284971' AND `status` = 4 AND `update` >= 1791474444 ) OR ( `owner` = 205 AND ( `status` IN (2,3) OR ( `status` = 4 AND `update` >= 1791474444 ) ) ) ) [ RunTime:0.002036s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `aid` = 205 AND `status` IN (2,3,4) AND `update` >= 1791474444 ) ) [ RunTime:0.001246s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 LIMIT 1 [ RunTime:0.000666s ] [2026-11-07T23:47:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_team_list` WHERE `aid` = 205 [ RunTime:0.000906s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` = 9 LIMIT 1 [ RunTime:0.000673s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `status` = 1 AND `username` = '284971' AND `job` <> 79 LIMIT 1 [ RunTime:0.000787s ] [2026-11-07T23:47:24+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000614s ] [2026-11-07T23:47:24+08:00][sql] SELECT `user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `action` = 'wirApply' AND `status` = 1 LIMIT 1 [ RunTime:0.001071s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_quality_wir_list` WHERE ( ( `owner` = 205 AND `status` = 2 AND `published_at` >= 1791474444 ) ) [ RunTime:0.001056s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 284971 AND `status` > 0 AND `eff_date` >= 1791474444 [ RunTime:0.001299s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001069s ] [2026-11-07T23:47:24+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 120 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.001649s ] [2026-11-07T23:47:24+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791474444 [ RunTime:0.001430s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791474444 OR `update` >= 1791474444 OR `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) ) [ RunTime:0.001747s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.002190s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.001203s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.001705s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000693s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.000633s ] [2026-11-07T23:47:24+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000882s ] [2026-11-07T23:47:24+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.001135s ] [2026-11-07T23:47:24+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.001010s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.001808s ] [2026-11-07T23:47:24+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066444 WHERE `auth_id` = 120 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000705s ] [2026-11-07T23:47:24+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066444 WHERE `auth_id` = 120 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000666s ] [2026-11-07T23:47:24+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066444 WHERE `auth_id` = 120 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000470s ] [2026-11-07T23:47:24+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 120 GROUP BY `state` [ RunTime:0.000496s ] [2026-11-07T23:47:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 120 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000537s ] [2026-11-07T23:47:24+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:ae442a2b78cca1232d8db9e9dfc163fa713c7e8a') [ RunTime:0.000433s ] [2026-11-07T23:47:24+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 120 AND `state` IN ('pending','notice') [ RunTime:0.000712s ] [2026-11-07T23:47:24+08:00][sql] CONNECT:[ UseTime:0.014663s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000516s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000503s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000406s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 LIMIT 1 [ RunTime:0.000419s ] [2026-11-07T23:47:24+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000384s ] [2026-11-07T23:47:24+08:00][sql] SELECT `user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `action` = 'afterSalesRepair' AND `status` = 1 LIMIT 1 [ RunTime:0.000341s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_after_sales_repair` WHERE `id` = 264 AND `creator_id` = 205 AND `deleted_at` IS NULL LIMIT 1 [ RunTime:0.001569s ] [2026-11-07T23:47:24+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000317s ] [2026-11-07T23:47:24+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 264 AND `p`.`admin_id` <> 205 [ RunTime:0.001446s ] [2026-11-07T23:47:24+08:00][sql] SELECT * FROM `oms_after_sales_repair_image` WHERE `repair_id` = 264 ORDER BY `image_type`,`id` [ RunTime:0.001450s ] [2026-11-07T23:47:25+08:00][sql] CONNECT:[ UseTime:0.015139s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:25+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000656s ] [2026-11-07T23:47:25+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000676s ] [2026-11-07T23:47:25+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000604s ] [2026-11-07T23:47:25+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 LIMIT 1 [ RunTime:0.000531s ] [2026-11-07T23:47:25+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000504s ] [2026-11-07T23:47:25+08:00][sql] SELECT `user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `action` = 'afterSalesRepair' AND `status` = 1 LIMIT 1 [ RunTime:0.000712s ] [2026-11-07T23:47:25+08:00][sql] SELECT `id`,`truename` FROM `oms_admin_user` WHERE `dpt` = 3 AND `status` = 1 AND `id` <> 205 ORDER BY `truename`,`id` [ RunTime:0.000775s ] [2026-11-07T23:47:27+08:00][sql] CONNECT:[ UseTime:0.001144s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:27+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000608s ] [2026-11-07T23:47:27+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000698s ] [2026-11-07T23:47:27+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000492s ] [2026-11-07T23:47:27+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 LIMIT 1 [ RunTime:0.000516s ] [2026-11-07T23:47:27+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000673s ] [2026-11-07T23:47:27+08:00][sql] SELECT `user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `action` = 'afterSalesRepair' AND `status` = 1 LIMIT 1 [ RunTime:0.000548s ] [2026-11-07T23:47:27+08:00][sql] SELECT `id`,`truename` FROM `oms_admin_user` WHERE `dpt` = 3 AND `status` = 1 AND `id` <> 205 ORDER BY `truename`,`id` [ RunTime:0.000808s ] [2026-11-07T23:47:28+08:00][sql] CONNECT:[ UseTime:0.015505s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:28+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000615s ] [2026-11-07T23:47:28+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000586s ] [2026-11-07T23:47:28+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000523s ] [2026-11-07T23:47:28+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 LIMIT 1 [ RunTime:0.000485s ] [2026-11-07T23:47:28+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000486s ] [2026-11-07T23:47:28+08:00][sql] SELECT `user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `action` = 'afterSalesRepair' AND `status` = 1 LIMIT 1 [ RunTime:0.000483s ] [2026-11-07T23:47:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_after_sales_repair` WHERE `creator_id` = 205 AND `deleted_at` IS NULL [ RunTime:0.002117s ] [2026-11-07T23:47:28+08:00][sql] SELECT * FROM `oms_after_sales_repair` WHERE `creator_id` = 205 AND `deleted_at` IS NULL ORDER BY `repair_at` DESC,`id` DESC LIMIT 0,15 [ RunTime:0.000690s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000515s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 264 AND `p`.`admin_id` <> 205 [ RunTime:0.001552s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000454s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 263 AND `p`.`admin_id` <> 205 [ RunTime:0.000584s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000432s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 232 AND `p`.`admin_id` <> 205 [ RunTime:0.000499s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000442s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 229 AND `p`.`admin_id` <> 205 [ RunTime:0.000486s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000462s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 228 AND `p`.`admin_id` <> 205 [ RunTime:0.000484s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000410s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 227 AND `p`.`admin_id` <> 205 [ RunTime:0.000531s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000518s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 173 AND `p`.`admin_id` <> 205 [ RunTime:0.000610s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000448s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 172 AND `p`.`admin_id` <> 205 [ RunTime:0.000491s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000436s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 171 AND `p`.`admin_id` <> 205 [ RunTime:0.000500s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000424s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 163 AND `p`.`admin_id` <> 205 [ RunTime:0.000441s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000518s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 162 AND `p`.`admin_id` <> 205 [ RunTime:0.000637s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000526s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 161 AND `p`.`admin_id` <> 205 [ RunTime:0.000514s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000452s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 160 AND `p`.`admin_id` <> 205 [ RunTime:0.000436s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000384s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 159 AND `p`.`admin_id` <> 205 [ RunTime:0.000380s ] [2026-11-07T23:47:28+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000382s ] [2026-11-07T23:47:28+08:00][sql] SELECT `p`.`admin_id`,`a`.`truename` FROM `oms_after_sales_repair_person` `p` LEFT JOIN `oms_admin_user` `a` ON `a`.`id`=`p`.`admin_id` WHERE `p`.`repair_id` = 158 AND `p`.`admin_id` <> 205 [ RunTime:0.000492s ] [2026-11-07T23:47:31+08:00][sql] CONNECT:[ UseTime:0.017798s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:47:31+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 120 LIMIT 1 [ RunTime:0.000650s ] [2026-11-07T23:47:31+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '284971' LIMIT 1 [ RunTime:0.000632s ] [2026-11-07T23:47:31+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000591s ] [2026-11-07T23:47:31+08:00][sql] SELECT `dpt`,`rightid` FROM `oms_admin_user` WHERE `id` = 205 AND `username` = '284971' AND `status` = 1 AND `job` <> 79 LIMIT 1 [ RunTime:0.000557s ] [2026-11-07T23:47:31+08:00][sql] SELECT `id`,`title`,`icon`,`icon_color`,`action`,`route`,`user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `status` = 1 ORDER BY `sort`,`id` [ RunTime:0.000783s ] [2026-11-07T23:52:30+08:00][sql] CONNECT:[ UseTime:0.010563s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.001820s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000847s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000506s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000702s ] [2026-11-07T23:52:30+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000768s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000722s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000739s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5693 LIMIT 1 [ RunTime:0.000610s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000659s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000493s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000481s ] [2026-11-07T23:52:30+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066751 [ RunTime:0.000911s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001639s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000849s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001636s ] [2026-11-07T23:52:30+08:00][sql] SELECT GET_LOCK('oms-check-catalog:c9ed4d5318ce7b8b2b4679b43e3b4e7d69f14121',5) acquired [ RunTime:0.000418s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 159 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.001160s ] [2026-11-07T23:52:30+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:c9ed4d5318ce7b8b2b4679b43e3b4e7d69f14121') [ RunTime:0.000464s ] [2026-11-07T23:52:30+08:00][sql] SELECT GET_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b',5) acquired [ RunTime:0.000380s ] [2026-11-07T23:52:30+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` [ RunTime:0.000918s ] [2026-11-07T23:52:30+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000736s ] [2026-11-07T23:52:30+08:00][sql] SELECT `l`.`id`,`p`.`title` FROM `oms_team_base` `l` LEFT JOIN `oms_team_base` `p` ON `p`.`id`=l.mark AND p.mid=1 WHERE `l`.`mid` = 2 [ RunTime:0.001976s ] [2026-11-07T23:52:30+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b') [ RunTime:0.000389s ] [2026-11-07T23:52:30+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000464s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77730,77731,77732,77733,77734,77735,77736,77737,77738,77739,77740,77741,77742,77743,77744,77745,77746) ORDER BY `id` [ RunTime:0.001760s ] [2026-11-07T23:52:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5693 AND `i`.`status` IN (1,2) [ RunTime:0.000824s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000876s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000806s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.001040s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.001847s ] [2026-11-07T23:52:30+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000716s ] [2026-11-07T23:52:30+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000558s ] [2026-11-07T23:52:30+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000669s ] [2026-11-07T23:52:31+08:00][sql] CONNECT:[ UseTime:0.015304s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:31+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000727s ] [2026-11-07T23:52:31+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000839s ] [2026-11-07T23:52:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000542s ] [2026-11-07T23:52:31+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000761s ] [2026-11-07T23:52:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000562s ] [2026-11-07T23:52:31+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.001118s ] [2026-11-07T23:52:31+08:00][sql] SELECT `content` FROM `oms_member_base` WHERE `mid` = 20 AND `title` = '780549' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003777s ] [2026-11-07T23:52:31+08:00][sql] SELECT `phone`,`size` FROM `oms_member_interview` WHERE `m_id` = 317 LIMIT 1 [ RunTime:0.001159s ] [2026-11-07T23:52:31+08:00][sql] SELECT `position` FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000993s ] [2026-11-07T23:52:31+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000503s ] [2026-11-07T23:52:32+08:00][sql] CONNECT:[ UseTime:0.025765s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000771s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000940s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000542s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000626s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000804s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000574s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000685s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5693 LIMIT 1 [ RunTime:0.000641s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000923s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000629s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000513s ] [2026-11-07T23:52:32+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066753 [ RunTime:0.001115s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001839s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000557s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001843s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000505s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77730,77731,77732,77733,77734,77735,77736,77737,77738,77739,77740,77741,77742,77743,77744,77745,77746) ORDER BY `id` [ RunTime:0.002142s ] [2026-11-07T23:52:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5693 AND `i`.`status` IN (1,2) [ RunTime:0.000890s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000691s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000526s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000983s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.001740s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000820s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000640s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000856s ] [2026-11-07T23:52:32+08:00][sql] CONNECT:[ UseTime:0.024171s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000671s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000771s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000515s ] [2026-11-07T23:52:32+08:00][sql] SELECT GET_LOCK('oms-inbox:7117d17605106e198a1ab40b531e988e9a193bd9',5) acquired [ RunTime:0.000555s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980352 [ RunTime:0.002013s ] [2026-11-07T23:52:32+08:00][sql] SELECT 1 [ RunTime:0.000433s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000555s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000522s ] [2026-11-07T23:52:32+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000734s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000719s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 780549 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791474752 ) ) ) ) [ RunTime:0.005211s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '780549' AND `status` = 4 AND `update` >= 1791474752 ) ) [ RunTime:0.001945s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000758s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 780549 AND ( `status` = 1 OR `update` >= 1791474752 ) ) ) [ RunTime:0.001252s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000506s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000556s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 317 AND `status` IN (2,3) AND `update` >= 1791474752 [ RunTime:0.002875s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000593s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 317 AND `exam_date` > 1794063152 AND `status` IN (1,3) [ RunTime:0.001475s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 317 AND `status` = 2 AND `exam_date` >= 1791474752 [ RunTime:0.001042s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 780549 AND `status` > 0 AND `eff_date` >= 1791474752 [ RunTime:0.001046s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001176s ] [2026-11-07T23:52:32+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 751 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.001628s ] [2026-11-07T23:52:32+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791474752 [ RunTime:0.001495s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791474752 OR `update` >= 1791474752 OR `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) ) [ RunTime:0.002204s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.001681s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.001072s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.001271s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000760s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.001139s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000819s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000617s ] [2026-11-07T23:52:32+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.000970s ] [2026-11-07T23:52:32+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.001866s ] [2026-11-07T23:52:32+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066752 WHERE `auth_id` = 751 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000597s ] [2026-11-07T23:52:32+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066752 WHERE `auth_id` = 751 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000582s ] [2026-11-07T23:52:32+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066752 WHERE `auth_id` = 751 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000487s ] [2026-11-07T23:52:32+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 751 GROUP BY `state` [ RunTime:0.000490s ] [2026-11-07T23:52:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 751 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000499s ] [2026-11-07T23:52:32+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:7117d17605106e198a1ab40b531e988e9a193bd9') [ RunTime:0.000505s ] [2026-11-07T23:52:32+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 751 AND `state` IN ('pending','notice') [ RunTime:0.000697s ] [2026-11-07T23:52:45+08:00][sql] CONNECT:[ UseTime:0.014838s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000747s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000997s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000568s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000541s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000481s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000688s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000602s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000729s ] [2026-11-07T23:52:45+08:00][sql] SELECT GET_LOCK('oms-check:d317e4d7cdc9f684a20134740c33ea91f96a991e',5) acquired [ RunTime:0.000503s ] [2026-11-07T23:52:45+08:00][sql] SELECT GET_LOCK('employee:2747abf107b1235889ac85c4dc895a6308830703dd5a18b8',5) acquired [ RunTime:0.000406s ] [2026-11-07T23:52:45+08:00][sql] SELECT GET_LOCK('position-device:2747abf107b1235889ac85c4dc895a6308830703',5) acquired [ RunTime:0.000384s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000514s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000500s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5693 LIMIT 1 [ RunTime:0.000654s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.001039s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000536s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000470s ] [2026-11-07T23:52:45+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066766 [ RunTime:0.000749s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.000484s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000493s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.000569s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 159 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.000853s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000438s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77730,77731,77732,77733,77734,77735,77736,77737,77738,77739,77740,77741,77742,77743,77744,77745,77746) ORDER BY `id` [ RunTime:0.000581s ] [2026-11-07T23:52:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5693 AND `i`.`status` IN (1,2) [ RunTime:0.000584s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000466s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000422s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000470s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000475s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000741s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000649s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000770s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000546s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000448s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000407s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000550s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000770s ] [2026-11-07T23:52:45+08:00][sql] INSERT INTO `oms_me_check_record` SET `m_id` = 5693 , `check_id` = 260 , `check_date` = 1793980800 , `shift` = 2 , `tid` = 298 , `mid` = 317 , `result` = 1 , `mark` = '' , `update` = 1794066765 , `status` = 1 [ RunTime:0.000519s ] [2026-11-07T23:52:45+08:00][sql] INSERT INTO `oms_me_check_record` SET `m_id` = 5693 , `check_id` = 261 , `check_date` = 1793980800 , `shift` = 2 , `tid` = 298 , `mid` = 317 , `result` = 1 , `mark` = '' , `update` = 1794066765 , `status` = 1 [ RunTime:0.000442s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5693 LIMIT 1 [ RunTime:0.000472s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000585s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000495s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000481s ] [2026-11-07T23:52:45+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066766 [ RunTime:0.000720s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.000408s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000335s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000454s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77730,77731,77732,77733,77734,77735,77736,77737,77738,77739,77740,77741,77742,77743,77744,77745,77746,79246,79247) ORDER BY `id` [ RunTime:0.000613s ] [2026-11-07T23:52:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5693 AND `i`.`status` IN (1,2) [ RunTime:0.000583s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000388s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000430s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000384s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000639s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000759s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000904s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000667s ] [2026-11-07T23:52:45+08:00][sql] SELECT RELEASE_LOCK('position-device:2747abf107b1235889ac85c4dc895a6308830703') [ RunTime:0.000547s ] [2026-11-07T23:52:45+08:00][sql] SELECT RELEASE_LOCK('employee:2747abf107b1235889ac85c4dc895a6308830703dd5a18b8') [ RunTime:0.000486s ] [2026-11-07T23:52:45+08:00][sql] SELECT RELEASE_LOCK('oms-check:d317e4d7cdc9f684a20134740c33ea91f96a991e') [ RunTime:0.000479s ] [2026-11-07T23:52:45+08:00][sql] CONNECT:[ UseTime:0.016267s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000688s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000913s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000749s ] [2026-11-07T23:52:45+08:00][sql] SELECT GET_LOCK('oms-inbox:7117d17605106e198a1ab40b531e988e9a193bd9',5) acquired [ RunTime:0.000439s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980365 [ RunTime:0.001785s ] [2026-11-07T23:52:45+08:00][sql] SELECT 1 [ RunTime:0.000463s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000547s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000514s ] [2026-11-07T23:52:45+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000627s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000444s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 780549 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791474765 ) ) ) ) [ RunTime:0.005649s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '780549' AND `status` = 4 AND `update` >= 1791474765 ) ) [ RunTime:0.002047s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000600s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 780549 AND ( `status` = 1 OR `update` >= 1791474765 ) ) ) [ RunTime:0.001048s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000526s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000539s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 317 AND `status` IN (2,3) AND `update` >= 1791474765 [ RunTime:0.003044s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000521s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 317 AND `exam_date` > 1794063165 AND `status` IN (1,3) [ RunTime:0.001817s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 317 AND `status` = 2 AND `exam_date` >= 1791474765 [ RunTime:0.001005s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 780549 AND `status` > 0 AND `eff_date` >= 1791474765 [ RunTime:0.001133s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001169s ] [2026-11-07T23:52:45+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 751 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.001823s ] [2026-11-07T23:52:45+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791474765 [ RunTime:0.001491s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791474765 OR `update` >= 1791474765 OR `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) ) [ RunTime:0.002200s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.001772s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.000980s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.000898s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000733s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.001003s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000813s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000661s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.001087s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.002104s ] [2026-11-07T23:52:45+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066765 WHERE `auth_id` = 751 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000513s ] [2026-11-07T23:52:45+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066765 WHERE `auth_id` = 751 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000549s ] [2026-11-07T23:52:45+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066765 WHERE `auth_id` = 751 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000460s ] [2026-11-07T23:52:45+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 751 GROUP BY `state` [ RunTime:0.000554s ] [2026-11-07T23:52:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 751 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000502s ] [2026-11-07T23:52:45+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:7117d17605106e198a1ab40b531e988e9a193bd9') [ RunTime:0.000364s ] [2026-11-07T23:52:45+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 751 AND `state` IN ('pending','notice') [ RunTime:0.000502s ] [2026-11-07T23:52:45+08:00][sql] CONNECT:[ UseTime:0.019601s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000916s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.001800s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000602s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000551s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000806s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000591s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000615s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.001389s ] [2026-11-07T23:52:45+08:00][sql] SELECT DISTINCT `line` FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 [ RunTime:0.002490s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `id` IN (34,316,33,550,632,319,303,302,436,748,813,572,21,749,815,549,885,872,886,24,25,874,537,20,875,859,551,750,305,884,584,814,747,707,873,294,437,919,22,871,304,434,438,640,812,726,661,468,287,290,443,444,288,547,281,32,637,447,320,338,341,340,339,342,277,317,51,548,278,279,313,280,35,724,300,589,578,708,638,639,641,648,649,650,657,651,728,709,710,732,751,603) ORDER BY `title` [ RunTime:0.001337s ] [2026-11-07T23:52:45+08:00][sql] SELECT `line` FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000358s ] [2026-11-07T23:52:45+08:00][sql] SELECT DISTINCT `type` FROM `oms_me_machine_list` WHERE `line` = 815 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.001422s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` WHERE `id` IN (674,695,701,702,706,903,159,165,957,956,705) ORDER BY `title` [ RunTime:0.000858s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000417s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000416s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000377s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`position`,`type`,`order` FROM `oms_team_plan_position` WHERE `plan_id` = 808 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.003341s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`eid`,`ename`,`tid`,`poid`,`indirect`,`status` FROM `oms_member_list` WHERE `tid` = 298 AND `status` = 1 ORDER BY `eid`,`id` [ RunTime:0.005137s ] [2026-11-07T23:52:45+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000707s ] [2026-11-07T23:52:45+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 ORDER BY `project`,`line`,`team`,`id` [ RunTime:0.001045s ] [2026-11-07T23:52:46+08:00][sql] CONNECT:[ UseTime:0.015247s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.001727s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000791s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000575s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000557s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000856s ] [2026-11-07T23:52:46+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000780s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000511s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000667s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000487s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000623s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.001024s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.001155s ] [2026-11-07T23:52:46+08:00][sql] SELECT `m_id` FROM `oms_me_position_device` WHERE `plan_id` = 808 AND `poid` = 19417 [ RunTime:0.001616s ] [2026-11-07T23:52:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `id` = 5693 AND `line` = 815 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.000516s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5693 AND `line` = 815 AND `status` = 1 AND `is_check` = 1 ORDER BY `id` LIMIT 0,20 [ RunTime:0.000534s ] [2026-11-07T23:52:46+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066766 [ RunTime:0.000812s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001607s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5693 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000580s ] [2026-11-07T23:52:46+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000471s ] [2026-11-07T23:52:46+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5693 AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.000793s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001808s ] [2026-11-07T23:52:46+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000527s ] [2026-11-07T23:52:46+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000721s ] [2026-11-07T23:52:52+08:00][sql] CONNECT:[ UseTime:0.014754s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000564s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000809s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000521s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000736s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000529s ] [2026-11-07T23:52:52+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000718s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000648s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000897s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000768s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000554s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000543s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000474s ] [2026-11-07T23:52:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 [ RunTime:0.001382s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 ORDER BY `type`,`id` LIMIT 0,20 [ RunTime:0.001692s ] [2026-11-07T23:52:52+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066773 [ RunTime:0.003415s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.000695s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.001474s ] [2026-11-07T23:52:52+08:00][sql] SELECT GET_LOCK('oms-check-catalog:54d6b11f7749c4172ceddfe5f43efb989f56d30b',5) acquired [ RunTime:0.000518s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 165 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.001185s ] [2026-11-07T23:52:52+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:54d6b11f7749c4172ceddfe5f43efb989f56d30b') [ RunTime:0.000385s ] [2026-11-07T23:52:52+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` IN (14012,317,15292,5897,14005,14001,15131) [ RunTime:0.000539s ] [2026-11-07T23:52:52+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.000867s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.000614s ] [2026-11-07T23:52:52+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000577s ] [2026-11-07T23:52:52+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000928s ] [2026-11-07T23:53:00+08:00][sql] CONNECT:[ UseTime:0.017043s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000565s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000808s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000557s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000399s ] [2026-11-07T23:53:00+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.001030s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000407s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000856s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5692 LIMIT 1 [ RunTime:0.000719s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000941s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000596s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000377s ] [2026-11-07T23:53:00+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066781 [ RunTime:0.000859s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001568s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000423s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001702s ] [2026-11-07T23:53:00+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000383s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77802,77803,77804,77805,77806,77807,77808,77809,77810,77811,77812,77813,77814,77815,77816,77817,77818) ORDER BY `id` [ RunTime:0.001922s ] [2026-11-07T23:53:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5692 AND `i`.`status` IN (1,2) [ RunTime:0.000483s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000401s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000323s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000898s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.002005s ] [2026-11-07T23:53:00+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000610s ] [2026-11-07T23:53:00+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000386s ] [2026-11-07T23:53:00+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000590s ] [2026-11-07T23:53:31+08:00][sql] CONNECT:[ UseTime:0.001094s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.001801s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000735s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000745s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.001172s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000699s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000758s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000904s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000763s ] [2026-11-07T23:53:31+08:00][sql] SELECT GET_LOCK('oms-check:ccfe2fcaf6a40d898d990de121cf0d232b70327a',5) acquired [ RunTime:0.000543s ] [2026-11-07T23:53:31+08:00][sql] SELECT GET_LOCK('employee:2747abf107b1235889ac85c4dc895a6308830703dd5a18b8',5) acquired [ RunTime:0.000351s ] [2026-11-07T23:53:31+08:00][sql] SELECT GET_LOCK('position-device:2747abf107b1235889ac85c4dc895a6308830703',5) acquired [ RunTime:0.000255s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000425s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000387s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5692 LIMIT 1 [ RunTime:0.000417s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000621s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000443s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000383s ] [2026-11-07T23:53:31+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066812 [ RunTime:0.000848s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001618s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000960s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001727s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 159 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.000798s ] [2026-11-07T23:53:31+08:00][sql] SELECT GET_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b',0) acquired [ RunTime:0.000231s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` [ RunTime:0.000792s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000698s ] [2026-11-07T23:53:31+08:00][sql] SELECT `l`.`id`,`p`.`title` FROM `oms_team_base` `l` LEFT JOIN `oms_team_base` `p` ON `p`.`id`=l.mark AND p.mid=1 WHERE `l`.`mid` = 2 [ RunTime:0.001751s ] [2026-11-07T23:53:31+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b') [ RunTime:0.000719s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000501s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77802,77803,77804,77805,77806,77807,77808,77809,77810,77811,77812,77813,77814,77815,77816,77817,77818) ORDER BY `id` [ RunTime:0.001718s ] [2026-11-07T23:53:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5692 AND `i`.`status` IN (1,2) [ RunTime:0.000475s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000332s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000348s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000756s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.002101s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000605s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000388s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000597s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000428s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000340s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000400s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000441s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000609s ] [2026-11-07T23:53:31+08:00][sql] INSERT INTO `oms_me_check_record` SET `m_id` = 5692 , `check_id` = 260 , `check_date` = 1793980800 , `shift` = 2 , `tid` = 298 , `mid` = 317 , `result` = 1 , `mark` = '' , `update` = 1794066811 , `status` = 1 [ RunTime:0.000450s ] [2026-11-07T23:53:31+08:00][sql] INSERT INTO `oms_me_check_record` SET `m_id` = 5692 , `check_id` = 261 , `check_date` = 1793980800 , `shift` = 2 , `tid` = 298 , `mid` = 317 , `result` = 1 , `mark` = '' , `update` = 1794066811 , `status` = 1 [ RunTime:0.000387s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5692 LIMIT 1 [ RunTime:0.000399s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000520s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000837s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000751s ] [2026-11-07T23:53:31+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066812 [ RunTime:0.001049s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.000353s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000357s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000306s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77802,77803,77804,77805,77806,77807,77808,77809,77810,77811,77812,77813,77814,77815,77816,77817,77818,79248,79249) ORDER BY `id` [ RunTime:0.000468s ] [2026-11-07T23:53:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5692 AND `i`.`status` IN (1,2) [ RunTime:0.000492s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000492s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000559s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000461s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000439s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000568s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000407s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000568s ] [2026-11-07T23:53:31+08:00][sql] SELECT RELEASE_LOCK('position-device:2747abf107b1235889ac85c4dc895a6308830703') [ RunTime:0.000415s ] [2026-11-07T23:53:31+08:00][sql] SELECT RELEASE_LOCK('employee:2747abf107b1235889ac85c4dc895a6308830703dd5a18b8') [ RunTime:0.000263s ] [2026-11-07T23:53:31+08:00][sql] SELECT RELEASE_LOCK('oms-check:ccfe2fcaf6a40d898d990de121cf0d232b70327a') [ RunTime:0.000327s ] [2026-11-07T23:53:31+08:00][sql] CONNECT:[ UseTime:0.001163s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000515s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.001112s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000391s ] [2026-11-07T23:53:31+08:00][sql] SELECT GET_LOCK('oms-inbox:7117d17605106e198a1ab40b531e988e9a193bd9',5) acquired [ RunTime:0.000377s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980411 [ RunTime:0.002029s ] [2026-11-07T23:53:31+08:00][sql] SELECT 1 [ RunTime:0.000602s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000575s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000443s ] [2026-11-07T23:53:31+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000506s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000334s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 780549 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791474811 ) ) ) ) [ RunTime:0.005399s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '780549' AND `status` = 4 AND `update` >= 1791474811 ) ) [ RunTime:0.001847s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000594s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 780549 AND ( `status` = 1 OR `update` >= 1791474811 ) ) ) [ RunTime:0.001136s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000493s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000484s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 317 AND `status` IN (2,3) AND `update` >= 1791474811 [ RunTime:0.003180s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000878s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 317 AND `exam_date` > 1794063211 AND `status` IN (1,3) [ RunTime:0.001667s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 317 AND `status` = 2 AND `exam_date` >= 1791474811 [ RunTime:0.001006s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 780549 AND `status` > 0 AND `eff_date` >= 1791474811 [ RunTime:0.000941s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001070s ] [2026-11-07T23:53:31+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 751 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.001642s ] [2026-11-07T23:53:31+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791474811 [ RunTime:0.001556s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791474811 OR `update` >= 1791474811 OR `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) ) [ RunTime:0.001980s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.001929s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.001034s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.000969s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000529s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.000985s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000762s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000581s ] [2026-11-07T23:53:31+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.001009s ] [2026-11-07T23:53:31+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.002059s ] [2026-11-07T23:53:31+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066811 WHERE `auth_id` = 751 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000772s ] [2026-11-07T23:53:31+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066811 WHERE `auth_id` = 751 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000596s ] [2026-11-07T23:53:31+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066811 WHERE `auth_id` = 751 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000628s ] [2026-11-07T23:53:31+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 751 GROUP BY `state` [ RunTime:0.001088s ] [2026-11-07T23:53:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 751 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000540s ] [2026-11-07T23:53:31+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:7117d17605106e198a1ab40b531e988e9a193bd9') [ RunTime:0.000231s ] [2026-11-07T23:53:31+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 751 AND `state` IN ('pending','notice') [ RunTime:0.000367s ] [2026-11-07T23:53:32+08:00][sql] CONNECT:[ UseTime:0.001350s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000435s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000830s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000423s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000486s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000996s ] [2026-11-07T23:53:32+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000592s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000464s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000533s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000368s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000657s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000834s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000807s ] [2026-11-07T23:53:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 [ RunTime:0.001350s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 ORDER BY `type`,`id` LIMIT 0,20 [ RunTime:0.001765s ] [2026-11-07T23:53:32+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066813 [ RunTime:0.003603s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001712s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.001135s ] [2026-11-07T23:53:32+08:00][sql] SELECT GET_LOCK('oms-check-catalog:c9ed4d5318ce7b8b2b4679b43e3b4e7d69f14121',0) acquired [ RunTime:0.000451s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 159 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.001116s ] [2026-11-07T23:53:32+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:c9ed4d5318ce7b8b2b4679b43e3b4e7d69f14121') [ RunTime:0.000255s ] [2026-11-07T23:53:32+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` IN (14012,317,15292,5897,14005,14001,15131) [ RunTime:0.000693s ] [2026-11-07T23:53:32+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.001985s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001600s ] [2026-11-07T23:53:32+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.001823s ] [2026-11-07T23:53:32+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000619s ] [2026-11-07T23:53:46+08:00][sql] CONNECT:[ UseTime:0.013750s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000649s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000784s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000515s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000487s ] [2026-11-07T23:53:46+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000988s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000590s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000648s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` = 5692 LIMIT 1 [ RunTime:0.000517s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000712s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000544s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000482s ] [2026-11-07T23:53:46+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` = 5692 AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066827 [ RunTime:0.000893s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` = 5692 AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001931s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 LIMIT 1 [ RunTime:0.000524s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.002152s ] [2026-11-07T23:53:46+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 317 [ RunTime:0.000619s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE `check_id` IN (77802,77803,77804,77805,77806,77807,77808,77809,77810,77811,77812,77813,77814,77815,77816,77817,77818,79248,79249) ORDER BY `id` [ RunTime:0.001702s ] [2026-11-07T23:53:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` = 5692 AND `i`.`status` IN (1,2) [ RunTime:0.000663s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000553s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000494s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000858s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.001650s ] [2026-11-07T23:53:46+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000694s ] [2026-11-07T23:53:46+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000547s ] [2026-11-07T23:53:46+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000677s ] [2026-11-07T23:53:53+08:00][sql] CONNECT:[ UseTime:0.018504s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000563s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000790s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000591s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000533s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000744s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000764s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000800s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.001430s ] [2026-11-07T23:53:53+08:00][sql] SELECT DISTINCT `line` FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 [ RunTime:0.002772s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `id` IN (34,316,33,550,632,319,303,302,436,748,813,572,21,749,815,549,885,872,886,24,25,874,537,20,875,859,551,750,305,884,584,814,747,707,873,294,437,919,22,871,304,434,438,640,812,726,661,468,287,290,443,444,288,547,281,32,637,447,320,338,341,340,339,342,277,317,51,548,278,279,313,280,35,724,300,589,578,708,638,639,641,648,649,650,657,651,728,709,710,732,751,603) ORDER BY `title` [ RunTime:0.001339s ] [2026-11-07T23:53:53+08:00][sql] SELECT `line` FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000471s ] [2026-11-07T23:53:53+08:00][sql] SELECT DISTINCT `type` FROM `oms_me_machine_list` WHERE `line` = 815 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.001486s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` WHERE `id` IN (674,695,701,702,706,903,159,165,957,956,705) ORDER BY `title` [ RunTime:0.000930s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000510s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000485s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000816s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`position`,`type`,`order` FROM `oms_team_plan_position` WHERE `plan_id` = 808 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.003705s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`eid`,`ename`,`tid`,`poid`,`indirect`,`status` FROM `oms_member_list` WHERE `tid` = 298 AND `status` = 1 ORDER BY `eid`,`id` [ RunTime:0.004988s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000713s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 ORDER BY `project`,`line`,`team`,`id` [ RunTime:0.001184s ] [2026-11-07T23:53:53+08:00][sql] CONNECT:[ UseTime:0.012000s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000693s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000917s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000523s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000550s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000574s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000686s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000513s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000609s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000501s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000747s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000604s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000908s ] [2026-11-07T23:53:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 [ RunTime:0.001430s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 ORDER BY `type`,`id` LIMIT 0,20 [ RunTime:0.001553s ] [2026-11-07T23:53:53+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066834 [ RunTime:0.003778s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.001754s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.001841s ] [2026-11-07T23:53:53+08:00][sql] SELECT GET_LOCK('oms-check-catalog:54d6b11f7749c4172ceddfe5f43efb989f56d30b',0) acquired [ RunTime:0.000659s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 165 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.001285s ] [2026-11-07T23:53:53+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:54d6b11f7749c4172ceddfe5f43efb989f56d30b') [ RunTime:0.000477s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` IN (14012,317,15292,5897,14005,14001,15131) [ RunTime:0.000576s ] [2026-11-07T23:53:53+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` IN (5518,5688,5689,5690,5691,5692,5693,5694,6328,5701,5703,5705,5706,5707,5708,5709,5711,5712,5714,5716) AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.001870s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.001598s ] [2026-11-07T23:53:53+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.001878s ] [2026-11-07T23:53:53+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000671s ] [2026-11-07T23:54:47+08:00][sql] CONNECT:[ UseTime:0.011080s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 751 LIMIT 1 [ RunTime:0.000663s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '780549' LIMIT 1 [ RunTime:0.000859s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 LIMIT 1 [ RunTime:0.000663s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000554s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000650s ] [2026-11-07T23:54:47+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000799s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000532s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000654s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `eid` = '780549' AND `status` = 1 LIMIT 1 [ RunTime:0.000577s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 317 AND `status` = 1 LIMIT 1 [ RunTime:0.000516s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19417 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000525s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000523s ] [2026-11-07T23:54:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 [ RunTime:0.001652s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 AND `line` = 815 ORDER BY `type`,`id` LIMIT 20,20 [ RunTime:0.001684s ] [2026-11-07T23:54:47+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` IN (5718,5721,6191,6193,6195,6197,6198,6199,6201,6202,6204,6206,6208,6210,6212,6214,6217,6218,6219,6220) AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066888 [ RunTime:0.003024s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` IN (5718,5721,6191,6193,6195,6197,6198,6199,6201,6202,6204,6206,6208,6210,6212,6214,6217,6218,6219,6220) AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.000689s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` IN (5718,5721,6191,6193,6195,6197,6198,6199,6201,6202,6204,6206,6208,6210,6212,6214,6217,6218,6219,6220) AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.001042s ] [2026-11-07T23:54:47+08:00][sql] SELECT GET_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b',0) acquired [ RunTime:0.000455s ] [2026-11-07T23:54:47+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` [ RunTime:0.000836s ] [2026-11-07T23:54:47+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000655s ] [2026-11-07T23:54:47+08:00][sql] SELECT `l`.`id`,`p`.`title` FROM `oms_team_base` `l` LEFT JOIN `oms_team_base` `p` ON `p`.`id`=l.mark AND p.mid=1 WHERE `l`.`mid` = 2 [ RunTime:0.001396s ] [2026-11-07T23:54:47+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:28ea7ea285e7cdace9753f5131cbf8c3c7425c4b') [ RunTime:0.000524s ] [2026-11-07T23:54:47+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` IN (13982,5174,13852,3264,14041,14014,4169,2006,10758) [ RunTime:0.000514s ] [2026-11-07T23:54:47+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` IN (5718,5721,6191,6193,6195,6197,6198,6199,6201,6202,6204,6206,6208,6210,6212,6214,6217,6218,6219,6220) AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.000838s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.000765s ] [2026-11-07T23:54:47+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000599s ] [2026-11-07T23:54:47+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000722s ] [2026-11-07T23:54:55+08:00][sql] CONNECT:[ UseTime:0.026049s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_auth` WHERE `openid` = 'oXWIHxpvIXpRW6v8pwrMl7Ppd0Bc' LIMIT 1 [ RunTime:0.000592s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.000819s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 LIMIT 1 [ RunTime:0.000518s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.000730s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.000753s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `status` = 1 LIMIT 1 [ RunTime:0.000506s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000518s ] [2026-11-07T23:54:55+08:00][sql] SELECT `content` FROM `oms_member_base` WHERE `mid` = 20 AND `title` = '715161' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002229s ] [2026-11-07T23:54:55+08:00][sql] SELECT `phone`,`size` FROM `oms_member_interview` WHERE `m_id` = 14591 LIMIT 1 [ RunTime:0.005128s ] [2026-11-07T23:54:55+08:00][sql] SELECT `position` FROM `oms_team_plan_position` WHERE `id` = 19769 LIMIT 1 [ RunTime:0.000520s ] [2026-11-07T23:54:55+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000435s ] [2026-11-07T23:54:55+08:00][sql] CONNECT:[ UseTime:0.016342s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 742 LIMIT 1 [ RunTime:0.000643s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.001094s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 LIMIT 1 [ RunTime:0.000533s ] [2026-11-07T23:54:55+08:00][sql] SELECT GET_LOCK('oms-inbox:946648fdaa95ea58121bf6ce57e2d7efb9e1fb85',5) acquired [ RunTime:0.000536s ] [2026-11-07T23:54:55+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980495 [ RunTime:0.002145s ] [2026-11-07T23:54:55+08:00][sql] SELECT 1 [ RunTime:0.000391s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000526s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000565s ] [2026-11-07T23:54:55+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000913s ] [2026-11-07T23:54:55+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000681s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 715161 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791474895 ) ) ) ) [ RunTime:0.005469s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '715161' AND `status` = 4 AND `update` >= 1791474895 ) ) [ RunTime:0.001704s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000618s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 715161 AND ( `status` = 1 OR `update` >= 1791474895 ) ) ) [ RunTime:0.001253s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000496s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000527s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14591 AND `status` IN (2,3) AND `update` >= 1791474895 [ RunTime:0.002880s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000814s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14591 AND `exam_date` > 1794063295 AND `status` IN (1,3) [ RunTime:0.001434s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14591 AND `status` = 2 AND `exam_date` >= 1791474895 [ RunTime:0.001059s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 715161 AND `status` > 0 AND `eff_date` >= 1791474895 [ RunTime:0.001237s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001105s ] [2026-11-07T23:54:55+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 742 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.001643s ] [2026-11-07T23:54:55+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791474895 [ RunTime:0.001495s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791474895 OR `update` >= 1791474895 OR `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) ) [ RunTime:0.001746s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.001970s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.001082s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.000998s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000749s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.001513s ] [2026-11-07T23:54:55+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000871s ] [2026-11-07T23:54:55+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000643s ] [2026-11-07T23:54:55+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.001037s ] [2026-11-07T23:54:55+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.001869s ] [2026-11-07T23:54:55+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066895 WHERE `auth_id` = 742 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000548s ] [2026-11-07T23:54:55+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066895 WHERE `auth_id` = 742 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000603s ] [2026-11-07T23:54:55+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794066895 WHERE `auth_id` = 742 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000513s ] [2026-11-07T23:54:55+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 742 GROUP BY `state` [ RunTime:0.000634s ] [2026-11-07T23:54:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 742 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000614s ] [2026-11-07T23:54:55+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:946648fdaa95ea58121bf6ce57e2d7efb9e1fb85') [ RunTime:0.000353s ] [2026-11-07T23:54:55+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 742 AND `state` IN ('pending','notice') [ RunTime:0.000582s ] [2026-11-07T23:54:56+08:00][sql] CONNECT:[ UseTime:0.001126s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:54:56+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 742 LIMIT 1 [ RunTime:0.002122s ] [2026-11-07T23:54:56+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.000807s ] [2026-11-07T23:54:56+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 LIMIT 1 [ RunTime:0.000651s ] [2026-11-07T23:54:56+08:00][sql] CONNECT:[ UseTime:0.014251s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:54:56+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 742 LIMIT 1 [ RunTime:0.000447s ] [2026-11-07T23:54:56+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.000706s ] [2026-11-07T23:54:56+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 LIMIT 1 [ RunTime:0.000488s ] [2026-11-07T23:54:56+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000675s ] [2026-11-07T23:54:56+08:00][sql] SELECT `id`,`title`,`icon`,`icon_color`,`action`,`route`,`user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `status` = 1 ORDER BY `sort`,`id` [ RunTime:0.001011s ] [2026-11-07T23:54:57+08:00][sql] CONNECT:[ UseTime:0.001264s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 742 LIMIT 1 [ RunTime:0.001766s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.000869s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 LIMIT 1 [ RunTime:0.000530s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000649s ] [2026-11-07T23:54:57+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000777s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000640s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000629s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.001134s ] [2026-11-07T23:54:57+08:00][sql] SELECT DISTINCT `line` FROM `oms_me_machine_list` WHERE `status` = 1 AND `is_check` = 1 [ RunTime:0.002024s ] [2026-11-07T23:54:57+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `id` IN (34,316,33,550,632,319,303,302,436,748,813,572,21,749,815,549,885,872,886,24,25,874,537,20,875,859,551,750,305,884,584,814,747,707,873,294,437,919,22,871,304,434,438,640,812,726,661,468,287,290,443,444,288,547,281,32,637,447,320,338,341,340,339,342,277,317,51,548,278,279,313,280,35,724,300,589,578,708,638,639,641,648,649,650,657,651,728,709,710,732,751,603) ORDER BY `title` [ RunTime:0.001263s ] [2026-11-07T23:54:57+08:00][sql] SELECT `line` FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000447s ] [2026-11-07T23:54:57+08:00][sql] SELECT DISTINCT `type` FROM `oms_me_machine_list` WHERE `line` = 815 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.001477s ] [2026-11-07T23:54:57+08:00][sql] SELECT `id`,`title` FROM `oms_me_base` WHERE `id` IN (674,695,701,702,706,903,159,165,957,956,705) ORDER BY `title` [ RunTime:0.000596s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000858s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 298 LIMIT 1 [ RunTime:0.000731s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.001056s ] [2026-11-07T23:54:57+08:00][sql] SELECT `id`,`position`,`type`,`order` FROM `oms_team_plan_position` WHERE `plan_id` = 808 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.003706s ] [2026-11-07T23:54:57+08:00][sql] SELECT `id`,`eid`,`ename`,`tid`,`poid`,`indirect`,`status` FROM `oms_member_list` WHERE `tid` = 298 AND `status` = 1 ORDER BY `eid`,`id` [ RunTime:0.005186s ] [2026-11-07T23:54:57+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` [ RunTime:0.000838s ] [2026-11-07T23:54:57+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 ORDER BY `project`,`line`,`team`,`id` [ RunTime:0.001164s ] [2026-11-07T23:54:58+08:00][sql] CONNECT:[ UseTime:0.015843s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 742 LIMIT 1 [ RunTime:0.000933s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '715161' LIMIT 1 [ RunTime:0.000885s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 LIMIT 1 [ RunTime:0.000486s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000627s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000561s ] [2026-11-07T23:54:58+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 AND `content` IN (1,2) ORDER BY CAST(mark AS SIGNED) ASC,`id` [ RunTime:0.000707s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000494s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_team_list` WHERE `status` = 1 AND `type` < 4 AND `project` IN (11,73,15,16,17,301,433,442,746,706,796,870,883,951) AND ( `id` = -1 OR `id` = 298 ) ORDER BY FIELD(project,11,73,15,16,17,301,433,442,746,706,796,870,883,951),`team`,`id` [ RunTime:0.000663s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `eid` = '715161' AND `status` = 1 LIMIT 1 [ RunTime:0.000536s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14591 AND `status` = 1 LIMIT 1 [ RunTime:0.000502s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_team_plan_position` WHERE `id` = 19769 AND `plan_id` = 808 AND `status` = 1 LIMIT 1 [ RunTime:0.000498s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_team_plan_capacity` WHERE `id` = 808 LIMIT 1 [ RunTime:0.000694s ] [2026-11-07T23:54:58+08:00][sql] SELECT `m_id` FROM `oms_me_position_device` WHERE `plan_id` = 808 AND `poid` = 19769 [ RunTime:0.000548s ] [2026-11-07T23:54:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_me_machine_list` WHERE `id` IN (1011,6227) AND `line` = 815 AND `status` = 1 AND `is_check` = 1 [ RunTime:0.000528s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (1011,6227) AND `line` = 815 AND `status` = 1 AND `is_check` = 1 ORDER BY `id` LIMIT 0,20 [ RunTime:0.000522s ] [2026-11-07T23:54:58+08:00][sql] SELECT DISTINCT `m_id`,`check_id` FROM `oms_me_check_record` WHERE `m_id` IN (1011,6227) AND `status` = 1 AND `update` >= 1793462400 AND `update` < 1794066899 [ RunTime:0.000983s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_me_check_close` WHERE `m_id` IN (1011,6227) AND `check_date` = 1793980800 AND `shift` = 2 [ RunTime:0.000520s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `m_id` IN (1011,6227) AND `check_date` = 1793980800 AND `shift` = 2 AND `status` = 1 ORDER BY `id` [ RunTime:0.000605s ] [2026-11-07T23:54:58+08:00][sql] SELECT GET_LOCK('oms-check-catalog:f5b2de836b6183e2b0b61ffdf2904716824fd7f7',5) acquired [ RunTime:0.000406s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 903 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.000760s ] [2026-11-07T23:54:58+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:f5b2de836b6183e2b0b61ffdf2904716824fd7f7') [ RunTime:0.000354s ] [2026-11-07T23:54:58+08:00][sql] SELECT GET_LOCK('oms-check-catalog:54d6b11f7749c4172ceddfe5f43efb989f56d30b',0) acquired [ RunTime:0.000370s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `type` = 165 AND `status` = 1 ORDER BY `order`,`id` [ RunTime:0.000965s ] [2026-11-07T23:54:58+08:00][sql] SELECT RELEASE_LOCK('oms-check-catalog:54d6b11f7749c4172ceddfe5f43efb989f56d30b') [ RunTime:0.000382s ] [2026-11-07T23:54:58+08:00][sql] SELECT `id`,`ename` FROM `oms_member_list` WHERE `id` = 14591 [ RunTime:0.000461s ] [2026-11-07T23:54:58+08:00][sql] SELECT `r`.`m_id`,COUNT(*) FROM `oms_me_check_issue` `i` INNER JOIN `oms_me_check_record` `r` ON `r`.`id`=`i`.`check_id` WHERE `r`.`m_id` IN (1011,6227) AND `i`.`status` IN (1,2) GROUP BY `r`.`m_id` [ RunTime:0.001112s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_me_check_pause` WHERE `start_date` <= 1793980800 AND `end_date` > 1793980800 ORDER BY `id` [ RunTime:0.000701s ] [2026-11-07T23:54:58+08:00][sql] SELECT * FROM `oms_me_position_device` WHERE `plan_id` = 808 ORDER BY `m_id` [ RunTime:0.000504s ] [2026-11-07T23:54:58+08:00][sql] SELECT `id`,`position` FROM `oms_team_plan_position` WHERE `id` IN (19412,19771,19758,19769,19762,19909,19777,19413,19761,19514,19767,19429,19515,19780,19775,19528,19773,19766,19764,19910,19409,19411,19417,19410,19765,19776,19763,19770,20158,19757,19768,19772) [ RunTime:0.000759s ] [2026-11-07T23:56:53+08:00][sql] CONNECT:[ UseTime:0.017664s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_auth` WHERE `openid` = 'oXWIHxo6oEQp8dhx9uJYyZd2QecU' LIMIT 1 [ RunTime:0.000836s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000973s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000835s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.001090s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000812s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `status` = 1 LIMIT 1 [ RunTime:0.000555s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` = 150 LIMIT 1 [ RunTime:0.000540s ] [2026-11-07T23:56:53+08:00][sql] SELECT `content` FROM `oms_member_base` WHERE `mid` = 20 AND `title` = '714721' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002597s ] [2026-11-07T23:56:53+08:00][sql] SELECT `phone`,`size` FROM `oms_member_interview` WHERE `m_id` = 14124 LIMIT 1 [ RunTime:0.004743s ] [2026-11-07T23:56:53+08:00][sql] SELECT `position` FROM `oms_team_plan_position` WHERE `id` = 20512 LIMIT 1 [ RunTime:0.000707s ] [2026-11-07T23:56:53+08:00][sql] SELECT `truename` FROM `oms_admin_user` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000510s ] [2026-11-07T23:56:53+08:00][sql] CONNECT:[ UseTime:0.011914s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000683s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000862s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000663s ] [2026-11-07T23:56:53+08:00][sql] CONNECT:[ UseTime:0.024304s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000721s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.001463s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000825s ] [2026-11-07T23:56:53+08:00][sql] SELECT GET_LOCK('oms-inbox:f71c8ab09436aaf84ff933bf1f5fefb3933b4d22',5) acquired [ RunTime:0.000482s ] [2026-11-07T23:56:53+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980613 [ RunTime:0.002277s ] [2026-11-07T23:56:53+08:00][sql] SELECT 1 [ RunTime:0.000376s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000525s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000528s ] [2026-11-07T23:56:53+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000551s ] [2026-11-07T23:56:53+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000447s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 714721 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791475013 ) ) ) ) [ RunTime:0.005429s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '714721' AND `status` = 4 AND `update` >= 1791475013 ) ) [ RunTime:0.002154s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000585s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 714721 AND ( `status` = 1 OR `update` >= 1791475013 ) ) ) [ RunTime:0.001061s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000491s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000539s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14124 AND `status` IN (2,3) AND `update` >= 1791475013 [ RunTime:0.003354s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000776s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14124 AND `exam_date` > 1794063413 AND `status` IN (1,3) [ RunTime:0.002101s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14124 AND `status` = 2 AND `exam_date` >= 1791475013 [ RunTime:0.001117s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 714721 AND `status` > 0 AND `eff_date` >= 1791475013 [ RunTime:0.001008s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001064s ] [2026-11-07T23:56:53+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 1129 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.001651s ] [2026-11-07T23:56:53+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791475013 [ RunTime:0.001580s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791475013 OR `update` >= 1791475013 OR `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) ) [ RunTime:0.001749s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.001689s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.001009s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.001010s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000707s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.000986s ] [2026-11-07T23:56:53+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000809s ] [2026-11-07T23:56:53+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000606s ] [2026-11-07T23:56:53+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.000972s ] [2026-11-07T23:56:53+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.002450s ] [2026-11-07T23:56:53+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067013 WHERE `auth_id` = 1129 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000510s ] [2026-11-07T23:56:53+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067013 WHERE `auth_id` = 1129 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000522s ] [2026-11-07T23:56:53+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067013 WHERE `auth_id` = 1129 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000402s ] [2026-11-07T23:56:53+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 1129 GROUP BY `state` [ RunTime:0.000509s ] [2026-11-07T23:56:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 1129 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000498s ] [2026-11-07T23:56:53+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:f71c8ab09436aaf84ff933bf1f5fefb3933b4d22') [ RunTime:0.000410s ] [2026-11-07T23:56:53+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 1129 AND `state` IN ('pending','notice') [ RunTime:0.000514s ] [2026-11-07T23:56:55+08:00][sql] CONNECT:[ UseTime:0.016599s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:56:55+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000627s ] [2026-11-07T23:56:55+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000807s ] [2026-11-07T23:56:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000487s ] [2026-11-07T23:56:55+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000500s ] [2026-11-07T23:56:55+08:00][sql] SELECT `id`,`title`,`icon`,`icon_color`,`action`,`route`,`user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `status` = 1 ORDER BY `sort`,`id` [ RunTime:0.001338s ] [2026-11-07T23:56:59+08:00][sql] CONNECT:[ UseTime:0.015449s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.001870s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000805s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000522s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000847s ] [2026-11-07T23:56:59+08:00][sql] CONNECT:[ UseTime:0.017511s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000687s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000783s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000512s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000530s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND `kpi_date` BETWEEN 1792598400 AND 1795190400 AND `eid` = 714721 ORDER BY `id` DESC [ RunTime:0.001096s ] [2026-11-07T23:56:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000520s ] [2026-11-07T23:57:01+08:00][sql] CONNECT:[ UseTime:0.016471s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:57:01+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000753s ] [2026-11-07T23:57:01+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000755s ] [2026-11-07T23:57:01+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000517s ] [2026-11-07T23:57:01+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000547s ] [2026-11-07T23:57:01+08:00][sql] SELECT `id`,`title`,`icon`,`icon_color`,`action`,`route`,`user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `status` = 1 ORDER BY `sort`,`id` [ RunTime:0.000805s ] [2026-11-07T23:57:02+08:00][sql] CONNECT:[ UseTime:0.015577s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000567s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000804s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000544s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000528s ] [2026-11-07T23:57:02+08:00][sql] CONNECT:[ UseTime:0.015282s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000680s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000835s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000518s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000492s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND `kpi_date` BETWEEN 1792598400 AND 1795190400 AND `eid` = 714721 ORDER BY `id` DESC [ RunTime:0.001378s ] [2026-11-07T23:57:02+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000575s ] [2026-11-07T23:57:05+08:00][sql] CONNECT:[ UseTime:0.016888s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:57:05+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000622s ] [2026-11-07T23:57:05+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000813s ] [2026-11-07T23:57:05+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000595s ] [2026-11-07T23:57:05+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000495s ] [2026-11-07T23:57:05+08:00][sql] SELECT `id`,`title`,`icon`,`icon_color`,`action`,`route`,`user_types`,`department_ids` FROM `oms_admin_menus_wx` WHERE `status` = 1 ORDER BY `sort`,`id` [ RunTime:0.000972s ] [2026-11-07T23:57:06+08:00][sql] CONNECT:[ UseTime:0.015504s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:57:06+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000603s ] [2026-11-07T23:57:06+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000976s ] [2026-11-07T23:57:06+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000661s ] [2026-11-07T23:57:06+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000716s ] [2026-11-07T23:57:06+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14124 AND `status` = 1 ORDER BY `id` DESC LIMIT 2 [ RunTime:0.040571s ] [2026-11-07T23:57:06+08:00][sql] SELECT `id`,`team`,`project`,`aid` FROM `oms_team_list` WHERE `status` = 1 ORDER BY `project`,`team`,`id` [ RunTime:0.000715s ] [2026-11-07T23:57:06+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 [ RunTime:0.000601s ] [2026-11-07T23:57:06+08:00][sql] SELECT `id`,truename as name FROM `oms_admin_user` WHERE `status` = 1 AND `job` = 9 ORDER BY `truename`,`id` [ RunTime:0.000755s ] [2026-11-07T23:57:06+08:00][sql] SELECT `id`,`title`,`content` FROM `oms_member_base` WHERE `mid` = 1 AND `mark` = 1 AND `id` > 100 AND `id` < 300 ORDER BY `title`,`id` [ RunTime:0.000831s ] [2026-11-07T23:57:59+08:00][sql] CONNECT:[ UseTime:0.000974s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000482s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000742s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000378s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000340s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14124 AND `status` = 1 ORDER BY `id` DESC LIMIT 2 [ RunTime:0.042364s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,`team`,`project`,`aid` FROM `oms_team_list` WHERE `status` = 1 ORDER BY `project`,`team`,`id` [ RunTime:0.001003s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 [ RunTime:0.000602s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,truename as name FROM `oms_admin_user` WHERE `status` = 1 AND `job` = 9 ORDER BY `truename`,`id` [ RunTime:0.001031s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,`title`,`content` FROM `oms_member_base` WHERE `mid` = 1 AND `mark` = 1 AND `id` > 100 AND `id` < 300 ORDER BY `title`,`id` [ RunTime:0.001166s ] [2026-11-07T23:57:59+08:00][sql] CONNECT:[ UseTime:0.001130s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.001830s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000789s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000430s ] [2026-11-07T23:57:59+08:00][sql] SELECT GET_LOCK('oms-inbox:f71c8ab09436aaf84ff933bf1f5fefb3933b4d22',5) acquired [ RunTime:0.000244s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980679 [ RunTime:0.001776s ] [2026-11-07T23:57:59+08:00][sql] SELECT 1 [ RunTime:0.000260s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000369s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000369s ] [2026-11-07T23:57:59+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000412s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000338s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 714721 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791475079 ) ) ) ) [ RunTime:0.005605s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '714721' AND `status` = 4 AND `update` >= 1791475079 ) ) [ RunTime:0.001914s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000516s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 714721 AND ( `status` = 1 OR `update` >= 1791475079 ) ) ) [ RunTime:0.000978s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000395s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000419s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14124 AND `status` IN (2,3) AND `update` >= 1791475079 [ RunTime:0.003695s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000451s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14124 AND `exam_date` > 1794063479 AND `status` IN (1,3) [ RunTime:0.001324s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14124 AND `status` = 2 AND `exam_date` >= 1791475079 [ RunTime:0.000892s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 714721 AND `status` > 0 AND `eff_date` >= 1791475079 [ RunTime:0.001000s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001191s ] [2026-11-07T23:57:59+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 1129 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.002143s ] [2026-11-07T23:57:59+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791475079 [ RunTime:0.001570s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791475079 OR `update` >= 1791475079 OR `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) ) [ RunTime:0.001932s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.001801s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.000927s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.000876s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000479s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.001203s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000914s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000621s ] [2026-11-07T23:57:59+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.000963s ] [2026-11-07T23:57:59+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.001884s ] [2026-11-07T23:57:59+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067079 WHERE `auth_id` = 1129 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000417s ] [2026-11-07T23:57:59+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067079 WHERE `auth_id` = 1129 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000388s ] [2026-11-07T23:57:59+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067079 WHERE `auth_id` = 1129 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000282s ] [2026-11-07T23:57:59+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 1129 GROUP BY `state` [ RunTime:0.000369s ] [2026-11-07T23:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 1129 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000296s ] [2026-11-07T23:57:59+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:f71c8ab09436aaf84ff933bf1f5fefb3933b4d22') [ RunTime:0.000191s ] [2026-11-07T23:57:59+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 1129 AND `state` IN ('pending','notice') [ RunTime:0.000417s ] [2026-11-07T23:59:53+08:00][sql] CONNECT:[ UseTime:0.010496s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000705s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.001155s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000832s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000844s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14124 AND `status` = 1 ORDER BY `id` DESC LIMIT 2 [ RunTime:0.045436s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,`team`,`project`,`aid` FROM `oms_team_list` WHERE `status` = 1 ORDER BY `project`,`team`,`id` [ RunTime:0.000780s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,`title` FROM `oms_team_base` WHERE `mid` = 1 [ RunTime:0.000686s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,truename as name FROM `oms_admin_user` WHERE `status` = 1 AND `job` = 9 ORDER BY `truename`,`id` [ RunTime:0.000881s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,`title`,`content` FROM `oms_member_base` WHERE `mid` = 1 AND `mark` = 1 AND `id` > 100 AND `id` < 300 ORDER BY `title`,`id` [ RunTime:0.001323s ] [2026-11-07T23:59:53+08:00][sql] CONNECT:[ UseTime:0.022921s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8 [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_auth` WHERE `id` = 1129 LIMIT 1 [ RunTime:0.000983s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_admin_user` WHERE `username` = '714721' LIMIT 1 [ RunTime:0.000846s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 LIMIT 1 [ RunTime:0.000512s ] [2026-11-07T23:59:53+08:00][sql] SELECT GET_LOCK('oms-inbox:f71c8ab09436aaf84ff933bf1f5fefb3933b4d22',5) acquired [ RunTime:0.000392s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id` FROM `oms_onsite_suggestion_transfer` WHERE `state` = 'pending' AND `created_at` <= 1793980793 [ RunTime:0.002552s ] [2026-11-07T23:59:53+08:00][sql] SELECT 1 [ RunTime:0.000397s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_onsite_suggestion_transfer` WHERE `id` = 2 AND `state` = 'pending' LIMIT 1 [ RunTime:0.000647s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `id` = 11554 LIMIT 1 [ RunTime:0.000765s ] [2026-11-07T23:59:53+08:00][sql] SELECT `content` FROM `oms_onsite_base` WHERE `mid` = 88 [ RunTime:0.000644s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,`username` FROM `oms_admin_user` WHERE `id` = 656 AND `status` = 1 [ RunTime:0.000456s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_onsite_suggestion_list` WHERE `status` > 0 AND ( ( `eid` = 714721 AND ( `status` = 3 OR ( `status` = 4 AND `update` >= 1791475193 ) ) ) ) [ RunTime:0.005795s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_onsite_safe_list` WHERE `status` > 0 AND ( ( `eid` = '714721' AND `status` = 4 AND `update` >= 1791475193 ) ) [ RunTime:0.002272s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000599s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_kpi_record` WHERE `status` > 0 AND ( `id` = -1 OR ( `eid` = 714721 AND ( `status` = 1 OR `update` >= 1791475193 ) ) ) [ RunTime:0.001559s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000583s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000647s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_perleave` WHERE `mid` = 14124 AND `status` IN (2,3) AND `update` >= 1791475193 [ RunTime:0.003509s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_member_list` WHERE `id` = 14124 AND `eid` = '714721' AND `status` = 1 LIMIT 1 [ RunTime:0.000836s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14124 AND `exam_date` > 1794063593 AND `status` IN (1,3) [ RunTime:0.001551s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_quality_newskill_score` WHERE `mid` = 14124 AND `status` = 2 AND `exam_date` >= 1791475193 [ RunTime:0.001166s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_common_night_bus` WHERE `eid` = 714721 AND `status` > 0 AND `eff_date` >= 1791475193 [ RunTime:0.001110s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_me_base` WHERE `mid` IN (20,21) [ RunTime:0.001165s ] [2026-11-07T23:59:53+08:00][sql] SELECT `business_id` FROM `oms_message` WHERE `auth_id` = 1129 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.002490s ] [2026-11-07T23:59:53+08:00][sql] SELECT `issue_id` FROM `oms_me_check_issue_flow` WHERE `updated_at` >= 1791475193 [ RunTime:0.001479s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_me_check_issue` WHERE ( `status` IN (1,2) OR `check_time` >= 1791475193 OR `update` >= 1791475193 OR `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) ) [ RunTime:0.001836s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_me_check_record` WHERE `id` IN (3325,5078,9052,13365,22021,22195,22378,25028,25257,26079,28000,28439,30232,30943,32124,33161,33165,34839,37396,37943,38701,43233,45931,47673,49333,50398,52433,55811,56342,61045,63190,65326,65333,67949,68514,68571,69448,73942,77878,78106) [ RunTime:0.002029s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_me_machine_list` WHERE `id` IN (5319,5684,5318,2787,5976,1418,5681,475,6050,1421,1419,5643,244,5886,5703,1543,5772,5516) [ RunTime:0.001395s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_me_check_list` WHERE `id` IN (321,260,674,62,285,468,309,256,284,472,164,320,274,281,470,821) [ RunTime:0.000861s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_me_check_issue_flow` WHERE `issue_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) [ RunTime:0.000466s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_team_list` WHERE `id` IN (289,326,179,29,153,31,317,30,266,212,318,297,298,151) [ RunTime:0.000879s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,`id`,`truename`,`status`,`job` FROM `oms_admin_user` [ RunTime:0.000833s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,`id`,`ename` FROM `oms_member_list` WHERE `id` IN (33,11271,14061,895,14554,97,11045,8661,12526,8351,14631,14413,13123,8679,121,15292,518,249) [ RunTime:0.000761s ] [2026-11-07T23:59:53+08:00][sql] SELECT `id`,`id`,`title` FROM `oms_team_base` [ RunTime:0.001650s ] [2026-11-07T23:59:53+08:00][sql] SELECT * FROM `oms_me_check_issue_log` WHERE `issue_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) AND `action` <> '保存草稿' ORDER BY `id` [ RunTime:0.001927s ] [2026-11-07T23:59:53+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067193 WHERE `auth_id` = 1129 AND `business` = 'check-issue' AND `state` IN ('pending','notice') [ RunTime:0.000517s ] [2026-11-07T23:59:53+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067193 WHERE `auth_id` = 1129 AND `state` = 'pending' AND `business` IN ('visitor','outplant','material-return','suggestion','safety-risk','performance','leave','daily-issue','key-exam','night-bus','check-issue') [ RunTime:0.000570s ] [2026-11-07T23:59:53+08:00][sql] UPDATE `oms_message` SET `state` = 'closed' , `updated_at` = 1794067193 WHERE `auth_id` = 1129 AND `business` = 'key-exam' AND `node` = 'exam' AND `state` = 'notice' [ RunTime:0.000399s ] [2026-11-07T23:59:53+08:00][sql] SELECT state,COUNT(*) total FROM `oms_message` WHERE `auth_id` = 1129 GROUP BY `state` [ RunTime:0.000429s ] [2026-11-07T23:59:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `oms_message` WHERE `auth_id` = 1129 AND `state` = 'notice' AND `read_at` = 0 [ RunTime:0.000475s ] [2026-11-07T23:59:53+08:00][sql] SELECT RELEASE_LOCK('oms-inbox:f71c8ab09436aaf84ff933bf1f5fefb3933b4d22') [ RunTime:0.000287s ] [2026-11-07T23:59:53+08:00][sql] SELECT `task_at`,`deadline` FROM `oms_message` WHERE `auth_id` = 1129 AND `state` IN ('pending','notice') [ RunTime:0.000405s ]