学习AI，助力开发--AI如何改变我的工作

请参考 com.jdwl.wms.inventory.count.CountTaskController#drawGuidedCountTask 方法，在 com.jdwl.wms.inventory.transfer.ReplenishTaskController 类中开发一个类似的方法，方法命名为 drawGuidedReplenishTask，方法注释为认领引导式补货任务，其中资源码@MenuPermission中的codes值配置与 com.jdwl.wms.inventory.transfer.ReplenishTaskController#drawTask 中的@MenuPermission配置一致。有以下信息输入：1、ReplenishTaskController 类中新定义 drawGuidedReplenishTask 方法的入参类定义名字为 GuidedReplenishDrawRequest ，返回值定义为 Result<GuidedReplenishDrawResponse> ，其中 GuidedReplenishDrawResponse 也是新定义的类2、GuidedReplenishDrawRequest 中有一个属性字段，定义为 taskNo，类型为String 3、GuidedReplenishDrawResponse 中定义的字段分别为 orderNo、taskNo、taskType、taskStatus，其中 orderNo、taskNo 定义为String类型，taskType、taskStatus 定义为 Integer 类型4、在 drawGuidedReplenishTask 里面，最终会调用 com.jdwl.wms.inventory.interfaces.transfer.task.ReplenishTaskAppService 中的 drawGuidedReplenishTask 方法，其中 ReplenishTaskAppService中的drawGuidedReplenishTask 目前没有，需要新增开发，这个方法的入参类 定义为 GuidedReplenishDrawDto ，返回值类型为 Result<GuidedReplenishDrawResult> ，其中 GuidedReplenishDrawResult 也是新定义的类5、GuidedReplenishDrawDto 中的字段定义与 GuidedReplenishDrawRequest 一致6、GuidedReplenishDrawResult 中的字段定义与 GuidedReplenishDrawResponse 一致7、在 com.jdwl.wms.inventory.transfer.mapper.ReplenishMapper 中定义相应的方法，实现 GuidedReplenishDrawRequest 到 GuidedReplenishDrawDto的转换，以及 GuidedReplenishDrawResult 到 GuidedReplenishDrawResponse 的转换，可其他代码风格8、请先实现以上内容，ReplenishTaskAppService中的drawGuidedReplenishTask 方法的具体实现，稍后我会再次给输入信息

参考 com.jdwl.wms.inventory.count.task.app.service.CountTaskAppServiceImpl#drawGuidedCountTask ，开发实现 com.jdwl.wms.inventory.transfer.task.app.service.ReplenishTaskAppServiceImpl#drawGuidedReplenishTask注意 CountTaskAppServiceImpl#drawGuidedCountTask 是盘点count领域的服务，而 ReplenishTaskAppServiceImpl#drawGuidedReplenishTask 是补货领域的服务，只是参考盘点的形式去开发 ReplenishTaskAppServiceImpl#drawGuidedReplenishTask，而不是照搬内容。下面给出一些约束信息：1、查询补货任务调用接口 com.jdwl.wms.inventory.transfer.task.domain.repo.TransferTaskRepository#queryByTaskNo2、校验任务状态，当任务状态是com.jdwl.wms.inventory.interfaces.transfer.task.enums.TaskStatusEnum#FINISHED 、com.jdwl.wms.inventory.interfaces.transfer.task.enums.TaskStatusEnum#PUT_ON_COMPLETED、 com.jdwl.wms.inventory.interfaces.transfer.task.enums.TaskStatusEnum#CANCEL 其中一种时，则抛出业务异常3、参考 com.jdwl.wms.inventory.count.task.domain.repo.CountTaskRepository#queryTaskDetailIdsByTaskNo ， 在 com.jdwl.wms.inventory.transfer.task.domain.repo.TransferTaskRepository 中新增开发一个类似的方法，方法命名为 queryTaskDetailIdsByTaskNo，根据任务号和状态查询 inv_transfer_task_detail 表的 id列表，4、参考 com.jdwl.wms.inventory.count.task.domain.repo.CountTaskRepository#refreshCountUser ，在 com.jdwl.wms.inventory.transfer.task.domain.repo.TransferTaskRepository 中新增开发一个类似的方法，方法命名为 refreshCountUser，其中会分别通过 com.jdwl.wms.inventory.transfer.task.infrastructure.jdbc.dao.TransferTaskDao 更新 inv_transfer_task.task_userm  和 update_user，和 com.jdwl.wms.inventory.transfer.task.infrastructure.jdbc.dao.TransferTaskDetailDao 更新 inv_transfer_task_detail.taskUser 和 update_user

在这个开发案例中，简单总结一下：

• 这个需求点，AI大概可以辅助完成70%左右，新建的类，没有自动import，开发的类因为缺少import都飘红了，还得主动提示。

• 国际化完成度不够，模仿了国际化的写法，但国际化的编码并未定义,也未在message.properties中主动配置，需要人工补位，下次我明确说明国际化试下。

• 我用的Claude3.5，感觉编码交互一直停不下来，一直写了改，改了写，写过的代码还会再来一遍，还在同一个类中生成了两个一样的方法，导致方法重复飘红，需要人工停止。

• 对于提示非常完善的地方相对还是到位的。

在这个需求中，我当时的心得感受如下：

• 对于一个需求，拆分多个相对独立一些的改动点，一次投喂给AI大模型的内容不宜过多，最好是一个单独的改动点，比如单独实现一个具体方法，给出必要的约束条件和其他参考写法。

• 一次完成的方法实现，调用链不宜过深，层次跨度不宜过大。

• 这个改动点写好后，再把该需求的另一个改动点投喂给它实现。One by one, step by step. 

• 当发现大模型来回改写，循环不止时，大模型有点晕菜了，果断出手终止干预，不要在循环改写等待中浪费过多时间，进行人工补位修正，或重新给出新的指引。

• 利用大模型好用的地方，不好用的地方进行人工补位修正。

这里有个需求请帮我开发，在任务式变更自动生成规则 autoGenerateChangeTaskRule 中，当选择的商品等级是待检品，对应等级编码是以3开头的编码时，比如3，300等，则在商品等级条件后新增一个条件，这个条件是一个复选框，复选框对应的文案为“超过待检天数”，当用户勾选了“超过待检天数”后，且当商品等级为待检品时，去掉【保质期状态】这个条件的必选限制。当点击【确认】进行保存时，超过待检天数对应的字段名是inspectionDaysRestrictEnabled，对应的值为true或false，如果选中了“超过待检天数”，则inspectionDaysRestrictEnabled保存为true，否则为false。

页面效果

在这个需求案例中，VUE开发几乎完全托管给JoyCode开发，我只需要将详细的需求投喂给JoyCode即可，独立实现程度非常之高，效果非常好！

请找出下面报文中ProductID值重复出现的值及对应的出现次数：<?xml version="1.0" encoding="UTF-8"?><StockParamterxmlns:xsd="http://www.w3.org/2001/XMLSchema"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><RFID>CL1967529871672389632</RFID><OperatorName>yx.leiya</OperatorName><Notes>CL1967529871672389632</Notes><JgID>-1</JgID><GUID>CL1967529871672389632</GUID><WMSGUID>4_2274-CL1967529871672389632</WMSGUID><BoxID>2274</BoxID><Type>11</Type><KdanHao>2274</KdanHao><OwnerNo>2</OwnerNo><cky2>4</cky2><operationTime>2025-09-15 19:15:50</operationTime><CreateTime>2025-09-15 18:04:11</CreateTime><WDList><StockParmaterDetail><ProductID>100000769709</ProductID><GoodsName><![CDATA[金号（KINGSHORE）【整包】金号 无捻提缎绣面巾G1850WH 72*34cm 88g*5条装 ]]></GoodsName><LotNo>-1</LotNo><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>-1</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100000857833</ProductID><GoodsName><![CDATA[洁柔抽纸黑Face系列古龙水香味3层150抽3包装（大规格）BR060-01单提]]></GoodsName><LotNo>-1</LotNo><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>-1</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100004594228</ProductID><GoodsName><![CDATA[好丽友（ORION）呀土豆 蜂蜜黄油味 70g*5包 350g/包]]></GoodsName><LotNo>f16edc4fd849efd1ed88efe71a86bc05</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-04</productionDate><expirationDate>2026-05-01</expirationDate><adventDate>2026-02-22</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>f16edc4fd849efd1ed88efe71a86bc05</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100006855446</ProductID><GoodsName><![CDATA[奇多乐事奇多美式火鸡味90克膨化零食（新老包装随机发货）]]></GoodsName><LotNo>8744adc1325571ebb9e850652cdbe592</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-22</productionDate><expirationDate>2026-04-18</expirationDate><adventDate>2026-02-09</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>8744adc1325571ebb9e850652cdbe592</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100012157490</ProductID><GoodsName><![CDATA[劲仔【整盒】劲仔 小鱼 香辣味 加量装 10g*23/盒 （新老包装随机）]]></GoodsName><LotNo>0af4965055926c77533c4a10aa285b81</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-11</productionDate><expirationDate>2026-08-11</expirationDate><adventDate>2026-05-12</adventDate><Num>2</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>0af4965055926c77533c4a10aa285b81</batchNo><batchQty>2</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100019612931</ProductID><GoodsName><![CDATA[百草味鸭脖 110g(甜辣味)  休闲鸭肉卤味真空包装办公室夜宵休闲零食]]></GoodsName><LotNo>3cf1aae3752ff90bd86caacf6233cdc9</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-28</productionDate><expirationDate>2026-04-24</expirationDate><adventDate>2026-02-15</adventDate><Num>2</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>3cf1aae3752ff90bd86caacf6233cdc9</batchNo><batchQty>2</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100033103320</ProductID><GoodsName><![CDATA[洽洽【整包】 坚果炒货 多味瓜子 230g*4袋]]></GoodsName><LotNo>13e90f0bd6d22c90b72feade6b6dd3a7</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-16</productionDate><expirationDate>2026-04-13</expirationDate><adventDate>2026-02-12</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>13e90f0bd6d22c90b72feade6b6dd3a7</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100044836200</ProductID><GoodsName><![CDATA[七度空间（SPACE 7）优雅系列棉柔超薄卫生巾超长夜用338mm8片装 QUC8808]]></GoodsName><LotNo>2c7cccc5766059c64d666dc92cf67712</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-07</productionDate><expirationDate>2028-08-06</expirationDate><adventDate>2027-11-06</adventDate><Num>4</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>2c7cccc5766059c64d666dc92cf67712</batchNo><batchQty>4</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100044836200</ProductID><GoodsName><![CDATA[七度空间（SPACE 7）优雅系列棉柔超薄卫生巾超长夜用338mm8片装 QUC8808]]></GoodsName><LotNo>37c4a9c7cf870b5b9a56a3bb59578667</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-03</productionDate><expirationDate>2028-07-02</expirationDate><adventDate>2027-10-02</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>37c4a9c7cf870b5b9a56a3bb59578667</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100046691930</ProductID><GoodsName><![CDATA[苏菲超熟睡安心裤 超薄 XL 2P Standing 157201]]></GoodsName><LotNo>ea1a5a70295e5170ca84309bb85137c2</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-22</productionDate><expirationDate>2028-07-21</expirationDate><adventDate>2027-10-21</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>ea1a5a70295e5170ca84309bb85137c2</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100048212902</ProductID><GoodsName><![CDATA[上好佳【单包】 上好佳 洋葱圈 休闲膨化零食 80g]]></GoodsName><LotNo>93475430309610b401c364e3f6757d23</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-30</productionDate><expirationDate>2026-04-26</expirationDate><adventDate>2026-02-17</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>93475430309610b401c364e3f6757d23</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100057842591</ProductID><GoodsName><![CDATA[百世兴【单袋】馋库印度风味飞饼70g]]></GoodsName><LotNo>3bc4b755616d426295fbba52148ce8ae</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-05</productionDate><expirationDate>2026-02-01</expirationDate><adventDate>2025-12-23</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>3bc4b755616d426295fbba52148ce8ae</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100060386828</ProductID><GoodsName><![CDATA[盼盼鸡味块 烧烤牛排味（新老包装随机发货） 膨化 60g/袋 单袋]]></GoodsName><LotNo>7bd14f2db59af83bea2481c452434854</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-14</productionDate><expirationDate>2026-05-11</expirationDate><adventDate>2026-03-04</adventDate><Num>2</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>7bd14f2db59af83bea2481c452434854</batchNo><batchQty>2</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100060386828</ProductID><GoodsName><![CDATA[盼盼鸡味块 烧烤牛排味（新老包装随机发货） 膨化 60g/袋 单袋]]></GoodsName><LotNo>e9f03130f7f110823bd584515df96f7c</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-12</productionDate><expirationDate>2026-05-09</expirationDate><adventDate>2026-03-02</adventDate><Num>8</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>e9f03130f7f110823bd584515df96f7c</batchNo><batchQty>8</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100062718365</ProductID><GoodsName><![CDATA[自由点（FREEMORE）柔感超薄棉柔40片护垫单包]]></GoodsName><LotNo>82e56b4237ed472d579a205ee6936cb5</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-10</productionDate><expirationDate>2028-07-09</expirationDate><adventDate>2027-10-09</adventDate><Num>7</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>82e56b4237ed472d579a205ee6936cb5</batchNo><batchQty>7</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100063711969</ProductID><GoodsName><![CDATA[邬辣妈【单包】 茶油豆腐 辣条 80g袋/包 麻辣休闲零食]]></GoodsName><LotNo>94b36251fd9a76683dfbbafec1075374</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-19</productionDate><expirationDate>2026-04-16</expirationDate><adventDate>2026-02-15</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>94b36251fd9a76683dfbbafec1075374</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100064051705</ProductID><GoodsName><![CDATA[盼盼手撕面包 奶香味（新老包装随机） 80g/袋 单袋]]></GoodsName><LotNo>0e616ab132a5561f77846f8e18ea7b55</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-08</productionDate><expirationDate>2026-02-04</expirationDate><adventDate>2025-12-26</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>0e616ab132a5561f77846f8e18ea7b55</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100068552254</ProductID><GoodsName><![CDATA[飘柔滋润去屑洗发露洗发水200g]]></GoodsName><LotNo>d2c08782967ac38441efce1e0c605f02</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-18</productionDate><expirationDate>2028-07-17</expirationDate><adventDate>2027-10-17</adventDate><Num>2</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>d2c08782967ac38441efce1e0c605f02</batchNo><batchQty>2</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100080727332</ProductID><GoodsName><![CDATA[自由点益生菌8片日用卫生巾单包]]></GoodsName><LotNo>34ad2e5bbfe0ec10ee76ff5f6a82e6c6</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-30</productionDate><expirationDate>2028-07-29</expirationDate><adventDate>2027-10-29</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>34ad2e5bbfe0ec10ee76ff5f6a82e6c6</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100080727332</ProductID><GoodsName><![CDATA[自由点益生菌8片日用卫生巾单包]]></GoodsName><LotNo>d1bf17638a61ad92cf500e0355edfd96</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-05</productionDate><expirationDate>2028-08-04</expirationDate><adventDate>2027-11-04</adventDate><Num>4</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>d1bf17638a61ad92cf500e0355edfd96</batchNo><batchQty>4</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100094479855</ProductID><GoodsName><![CDATA[法丽兹果粒草莓味曲奇派100g]]></GoodsName><LotNo>5610b357dbc2bce7ffc476c0c2682b92</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-07</productionDate><expirationDate>2026-05-04</expirationDate><adventDate>2026-02-25</adventDate><Num>2</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>5610b357dbc2bce7ffc476c0c2682b92</batchNo><batchQty>2</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100101303907</ProductID><GoodsName><![CDATA[金磨坊90g*5包金箍棒香辣味 辣条辣棒面筋制品辣味零食]]></GoodsName><LotNo>073f9b893583f52bda64324b25d53700</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-24</productionDate><expirationDate>2026-02-20</expirationDate><adventDate>2026-01-11</adventDate><Num>2</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>073f9b893583f52bda64324b25d53700</batchNo><batchQty>2</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100105558307</ProductID><GoodsName><![CDATA[百草味草莓干80g水果干小吃休闲零食网红蜜饯果脯货架任务]]></GoodsName><LotNo>31d237ef92f132cb6c7d0373f31bcb7a</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-14</productionDate><expirationDate>2026-08-09</expirationDate><adventDate>2026-05-11</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>31d237ef92f132cb6c7d0373f31bcb7a</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100105558307</ProductID><GoodsName><![CDATA[百草味草莓干80g水果干小吃休闲零食网红蜜饯果脯货架任务]]></GoodsName><LotNo>9eb2ce9dd078361e27629d171332232f</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-07</productionDate><expirationDate>2026-08-02</expirationDate><adventDate>2026-05-04</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>9eb2ce9dd078361e27629d171332232f</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100106043891</ProductID><GoodsName><![CDATA[海底捞【单包】火锅蘸料 花生芝麻酱100g/包]]></GoodsName><LotNo>3b6db7902eb5c261dd1419cebb8fae59</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-13</productionDate><expirationDate>2026-07-13</expirationDate><adventDate>2026-04-13</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>3b6db7902eb5c261dd1419cebb8fae59</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100106043891</ProductID><GoodsName><![CDATA[海底捞【单包】火锅蘸料 花生芝麻酱100g/包]]></GoodsName><LotNo>ec6dec16f6f579c74b474ebe5d11f326</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-02</productionDate><expirationDate>2026-08-02</expirationDate><adventDate>2026-05-03</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>ec6dec16f6f579c74b474ebe5d11f326</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100127411299</ProductID><GoodsName><![CDATA[亲亲鲜虾片(原味)40g/袋 休闲零食小吃 童年记忆膨化食品 ]]></GoodsName><LotNo>2876fc0c0f40ea446ca95d7a4d401587</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-30</productionDate><expirationDate>2026-05-27</expirationDate><adventDate>2026-03-20</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>2876fc0c0f40ea446ca95d7a4d401587</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100133925218</ProductID><GoodsName><![CDATA[脆升升薯条蜂蜜黄油味40g]]></GoodsName><LotNo>c67b3309e6dd64862c5f4cd0f8d4725e</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-02</productionDate><expirationDate>2026-05-29</expirationDate><adventDate>2026-03-15</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>c67b3309e6dd64862c5f4cd0f8d4725e</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100165901615</ProductID><GoodsName><![CDATA[海天yes黄豆酱340g/瓶黄豆发酵东北大酱点蘸拌饭蒸鱼炒菜厨房焖鱼(cd)]]></GoodsName><LotNo>eee992ff0380d1a9cda2990a1a478539</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-06-18</productionDate><expirationDate>2027-06-08</expirationDate><adventDate>2026-12-10</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>eee992ff0380d1a9cda2990a1a478539</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100166621829</ProductID><GoodsName><![CDATA[千禾特香老抽酱油 500mL]]></GoodsName><LotNo>aeb413757642667998c7e051522b3a22</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-07</productionDate><expirationDate>2027-06-27</expirationDate><adventDate>2026-12-29</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>aeb413757642667998c7e051522b3a22</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100168090554</ProductID><GoodsName><![CDATA[美焙辰 93g肉松海苔味吐司（新老包装随机发）]]></GoodsName><LotNo>967f1ee8187a8eed4fc82048319c7cc4</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-19</productionDate><expirationDate>2025-11-17</expirationDate><adventDate>2025-10-28</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>967f1ee8187a8eed4fc82048319c7cc4</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100168090558</ProductID><GoodsName><![CDATA[美焙辰 90g肉松芝麻味面包（新老包装随机发）]]></GoodsName><LotNo>633eccfa194db5129c935a0a5e5bec61</LotNo><shelfLifeStatus>2</shelfLifeStatus><shelfLifeStatusName>预警</shelfLifeStatusName><productionDate>2025-08-04</productionDate><expirationDate>2025-11-02</expirationDate><adventDate>2025-10-13</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>633eccfa194db5129c935a0a5e5bec61</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100199406356</ProductID><GoodsName><![CDATA[纳爱斯硫磺药皂90g]]></GoodsName><LotNo>20fc04b50a7d862767d47fbc5b280fe9</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-14</productionDate><expirationDate>2028-07-13</expirationDate><adventDate>2027-10-13</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>20fc04b50a7d862767d47fbc5b280fe9</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100201116194</ProductID><GoodsName><![CDATA[豪士乳酸菌面包66g]]></GoodsName><LotNo>de440688b3370ed12fc47132699c740d</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-23</productionDate><expirationDate>2025-11-21</expirationDate><adventDate>2025-11-01</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>de440688b3370ed12fc47132699c740d</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100213191466</ProductID><GoodsName><![CDATA[海天古道料酒450ml家用瓶装炒菜厨房调味料去腥解膻腌肉料米酒(cd)]]></GoodsName><LotNo>10297056e2194d85b9d1fbabd34c91fc</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-05-06</productionDate><expirationDate>2026-10-28</expirationDate><adventDate>2026-06-15</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>10297056e2194d85b9d1fbabd34c91fc</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100222059710</ProductID><GoodsName><![CDATA[金厨娘【单袋】多味泡卤鸡翅尖100g/袋]]></GoodsName><LotNo>5610b357dbc2bce7ffc476c0c2682b92</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-07</productionDate><expirationDate>2026-05-04</expirationDate><adventDate>2026-02-25</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>5610b357dbc2bce7ffc476c0c2682b92</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100244692728</ProductID><GoodsName><![CDATA[卫龙【单袋】 辣条大面筋65g 吮指烤肉味 网红经典零食]]></GoodsName><LotNo>b1baf918dd94c2dcdcc4c993b13ced4d</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-07</productionDate><expirationDate>2026-01-04</expirationDate><adventDate>2025-11-25</adventDate><Num>3</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>b1baf918dd94c2dcdcc4c993b13ced4d</batchNo><batchQty>3</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100265600474</ProductID><GoodsName><![CDATA[良品铺子流心桂花月饼（小青柑味）60g散装月饼传统糕点心送礼广式月饼]]></GoodsName><LotNo>9a646abd90e9477305e2ddf538751667</LotNo><shelfLifeStatus>2</shelfLifeStatus><shelfLifeStatusName>预警</shelfLifeStatusName><productionDate>2025-08-16</productionDate><expirationDate>2025-11-14</expirationDate><adventDate>2025-10-25</adventDate><Num>2</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>9a646abd90e9477305e2ddf538751667</batchNo><batchQty>2</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>100265600474</ProductID><GoodsName><![CDATA[良品铺子流心桂花月饼（小青柑味）60g散装月饼传统糕点心送礼广式月饼]]></GoodsName><LotNo>de440688b3370ed12fc47132699c740d</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-23</productionDate><expirationDate>2025-11-21</expirationDate><adventDate>2025-11-01</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>de440688b3370ed12fc47132699c740d</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>3526554</ProductID><GoodsName><![CDATA[好丽友（orion） 休闲零食 双莓派 6枚 138g/盒（新老包装随机发货）]]></GoodsName><LotNo>17f0d11d60e84f589380c295ec5a90b9</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-08-12</productionDate><expirationDate>2026-04-09</expirationDate><adventDate>2026-02-08</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>17f0d11d60e84f589380c295ec5a90b9</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>4262690</ProductID><GoodsName><![CDATA[奇多奇多妙脆角茄汁味 65克（新老包装随机发货）]]></GoodsName><LotNo>3e389cfab23e707ad92fe28c73b99524</LotNo><shelfLifeStatus>1</shelfLifeStatus><shelfLifeStatusName>正常</shelfLifeStatusName><productionDate>2025-07-20</productionDate><expirationDate>2026-04-16</expirationDate><adventDate>2026-02-07</adventDate><Num>3</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>3e389cfab23e707ad92fe28c73b99524</batchNo><batchQty>3</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail><StockParmaterDetail><ProductID>8339995</ProductID><GoodsName><![CDATA[大宝SOD蜜【中包】90ml*7瓶 包装随机发货（买整箱无赠品）]]></GoodsName><LotNo>ed6d92999ac7d59a0feeb9f28e827368</LotNo><shelfLifeStatus>2</shelfLifeStatus><shelfLifeStatusName>预警</shelfLifeStatusName><productionDate>2024-08-18</productionDate><expirationDate>2027-08-18</expirationDate><adventDate>2026-11-17</adventDate><Num>1</Num><StockGoodsLevel>2</StockGoodsLevel><Reason1>1193||库存差异</Reason1><Reason2>1195||丢失-盘点差异</Reason2><Reason3>1196||盘点</Reason3><Container>1196</Container><ReceiptBatch><Batch><batchNo>ed6d92999ac7d59a0feeb9f28e827368</batchNo><batchQty>1</batchQty><productLevel>2</productLevel></Batch></ReceiptBatch></StockParmaterDetail></WDList></StockParamter>

我有个表st_stock对应的大数据Hive表为fdm_wms_stock_st_stock__new, fdm_wms_stock_st_stock__new表的分区字段是dt,今日统计昨日的数据dt用法是dt=sysdate(-1),SQL:select * from st_stock where warehouse_no = '6_1184'limit 100,请帮我改成Hive的写法，统计昨天的数据版本，注意：dt=sysdate(-1)表示昨天的数据版本

我在启动本项目方法 com.jdwl.wms.stock.ApiProviderApplication#main 时，启动失败，请帮我解决启动问题，具体报错信息如下：java: java.lang.ExceptionInInitializerErrorcom.sun.tools.javac.code.TypeTag :: UNKNOWN

请通过MAVEN命令，mvn package 和 mvn deploy ，对 wms-stock-api 发布服务

我有一个慢SQL，其执行计划如下图，请分析并给出优化建议SELECT id, tenant_code, warehouse_no, sku, location_no, zone_no, zone_type, container_level_1, container_level_2, lot_no, sku_level, owner_no, pack_code, conversion_rate, sum(stock_qty) as stock_qty, sum(prepicked_qty) as prepicked_qty, sum(premoved_qty) as premoved_qty, sum(frozen_qty) as frozen_qty, sum(diff_qty) as diff_qty, sum(broken_qty) as broken_qty, status, md5_value, version, create_user, update_user, create_time, update_time FROM st_stock WHERE deleted = 0 AND warehouse_no = '10_11151' AND stock_qty > 0 AND owner_no IN ( 'EBU4418056309960' ) AND zone_type NOT IN ( 't' ) AND extend_content ->> '$.skuInfo.consumablePlatformFlag' = 'true' AND (stock_qty - prepicked_qty - premoved_qty - frozen_qty - diff_qty - broken_qty) > 0 GROUP BY warehouse_no , sku LIMIT 20, 10 /* [SQLMarking] statementId: com.jdwl.wms.stock.infrastructure.jdbc.main.slave.dao.SlaveStockQueryDao.queryBriefStock, PFinderId: 6716160.58044.17607005587432320, traceId: bec6fbc9-79a2-4e9f-ad5a-d0d3cb64834d */;

我的MySQL engine Innodb status如下，请帮我分析其中的死锁情况，并给出优化建议：-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 593043 srv_active, 0 srv_shutdown, 28689 srv_idlesrv_master_thread log flush and writes: 621728----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count 21789755OS WAIT ARRAY INFO: signal count 62932727RW-shared spins 0, rounds 226885778, OS waits 11866365RW-excl spins 0, rounds 991398258, OS waits 4817950RW-sx spins 51711037, rounds 420896171, OS waits 2548436Spin rounds per wait: 226885778.00 RW-shared, 991398258.00 RW-excl, 8.14 RW-sx------------------------LATEST DETECTED DEADLOCK------------------------2025-10-17 21:40:06 0x7fb82e1e0700*** (1) TRANSACTION:TRANSACTION 28779788619, ACTIVE 0 sec starting index readmysql tables in use 1, locked 1LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 2041334, OS thread handle 140429395166976, query id 1209840727 11.*.*.24 **** updatingUPDATE st_stock             set stock_qty=case WHEN
        deleted = 0        AND warehouse_no = '630_211'        AND id = 1978784037019373568
                        and stock_qty >= 0 * -1                        THEN stock_qty + 0 end,                premoved_qty=case WHEN
        deleted = 0        AND warehouse_no = '630_211'        AND id = 1978784037019373568
                        and premoved_qty >= -698.0000 * -1                        THEN premoved_qty + -698.0000 end,                update_time = now()                , version = version + 1                , update_user = 'locating'
                    , extend_content = json_set(extend_content, '$.stockInfo.businessType', 'INV-REPLENISH01', '$.stockInfo.businessTypeName', '补货单', '$.stockInfo.businessNo', 'BHO630_2111979172287022358528') 
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 23296 page no 82994 n bits 80 index PRIMARY of table `wms_stock`.`st_stock` trx id 28779788619 lock_mode X locks rec but not gap waitingRecord lock, heap no 3 PHYSICAL RECORD: n_fields 33; compact format; info bits 0 0: len 8; hex 1b760d98fdc0d000; asc  v      ;; 1: len 6; hex 0006b368b94c; asc    h L;; 2: len 7; hex 6900005d2d2a26; asc i  ]-*&;; 3: len 10; hex 54433537373930323833; asc TC57790283;; 4: len 7; hex 3633305f323131; asc 630_211;; 5: len 16; hex 454d4734343138363431343538393533; asc EMG4418641458953;; 6: len 6; hex 324141303432; asc 2AA042;; 7: len 2; hex 3241; asc 2A;; 8: len 1; hex 73; asc s;; 9: len 0; hex ; asc ;; 10: len 0; hex ; asc ;; 11: len 30; hex 313966616666346264343438303238306431653165653563336563386234; asc 19faff4bd4480280d1e1ee5c3ec8b4; (total 32 bytes); 12: len 3; hex 313030; asc 100;; 13: len 16; hex 45425534343138303535363330303237; asc EBU4418055630027;; 14: len 30; hex 626338656130616365376138613731613635353935656361313136383330; asc bc8ea0ace7a8a71a65595eca116830; (total 32 bytes); 15: len 10; hex 80000000000000000000; asc           ;; 16: len 10; hex 8000000000008dcc0000; asc           ;; 17: len 10; hex 80000000000000000000; asc           ;; 18: len 10; hex 8000000000000b370000; asc        7  ;; 19: len 10; hex 80000000000000000000; asc           ;; 20: len 10; hex 80000000000000000000; asc           ;; 21: len 10; hex 80000000000000000000; asc           ;; 22: len 2; hex 8000; asc   ;; 23: len 30; hex 666539663135373339356431333631633539313735346663303431386334; asc fe9f157395d1361c591754fc0418c4; (total 32 bytes); 24: len 30; hex 000500b807270007002e000700350009003e000b0049000d00005600009a; asc      '   .   5   >   I    V   ; (total 1977 bytes); 25: len 0; hex ; asc ;; 26: len 4; hex 8000012c; asc    ,;; 27: len 19; hex 79786d6965727a6174697475657273756e2e31; asc yxmierzatituersun.1;; 28: len 8; hex 6c6f636174696e67; asc locating;; 29: len 5; hex 99b7e1360d; asc    6 ;; 30: len 5; hex 99b7e35a06; asc    Z ;; 31: len 4; hex 68f24736; asc h G6;; 32: len 1; hex 80; asc  ;;*** (2) TRANSACTION:TRANSACTION 28779788620, ACTIVE 0 sec starting index readmysql tables in use 1, locked 15 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 2MySQL thread id 2042835, OS thread handle 140429024429824, query id 1209840741 11.*.*.138 **** updatingUPDATE st_stock_match             set premoved_qty=case WHEN
        deleted = 0        AND warehouse_no = '630_211'        AND id = 1979172342361776128
                        THEN premoved_qty + 700.0000 end,                update_time = now()                , version = version + 1                , update_user = 'locating'             WHERE
                (         deleted = 0        AND warehouse_no = '630_211'        AND id = 1979172342361776128     ) /* [SQLMarking] statementId: com.jdwl.wms.stock.infrastructure.jdbc.main.dao.StockMatchOperationDao.simpleIncreasePreMovedQty, PFinderId: 6048116.56579.17607084058361870 */*** (2) HOLDS THE LOCK(S):篇幅考虑，这里省略若干文字内容……*** WE ROLL BACK TRANSACTION (2)