重现步骤

进入【进销存库存明细账】-【盘点出入库】、【调拨出入库】等界面超时

账号：Admin186

[步骤]


[结果]


[期望]


历史记录  
  1. 2022-03-15 23:25:54, 由 qihaoran 创建。
  2. 2022-03-15 23:31:55, 由 qihaoran 编辑。
    修改了 重现步骤，区别为：
    005- [结果]
    005+
    006- [期望]
    006+
    007-
    007+ [结果]
    008+ [期望]
    009+
    005- <p>[结果]</p>
    005+ <p><img src="{191651.png}" alt="" /></p>
    006- <br /><p>[期望]</p>
    006+ <p><img src="{191652.png}" alt="" /></p>
    007- <br />
    007+ <p>[结果]</p>
    008+ <br /><p>[期望]</p>
    009+ <br />
  3. 2022-03-15 23:48:52, 由 qihaoran 编辑。
    修改了 重现步骤，区别为：
    001- 进入【进销存库存明细账】-【盘点出入库】、【调拨出入库】界面超时
    001+ 进入【进销存库存明细账】-【盘点出入库】、【调拨出入库】等界面超时
    002- [步骤]
    002+
    003-
    003+ 使用账号：Admin186密码：Panda186
    004-
    004+ [步骤]
    005-
    005+
    006-
    006+
    007- [结果]
    007+
    008- [期望]
    008+
    009-
    009+
    010+
    011+ [结果]
    012+ [期望]
    013+
    001- <p>进入【进销存库存明细账】-【盘点出入库】、【调拨出入库】界面超时</p>
    001+ <p>进入【进销存库存明细账】-【盘点出入库】、【调拨出入库】等界面超时</p>
    002- <p>[步骤]</p>
    002+ <p><br /></p>
    003- <p><img src="{191649.png}" alt="" /></p>
    003+ <p>使用账号：Admin186<br />密码：Panda186</p>
    004- <p><img src="{191650.png}" alt="" /></p>
    004+ <p>[步骤]</p>
    005- <p><img src="{191651.png}" alt="" /></p>
    005+ <p><img src="{191649.png}" alt="" /></p>
    006- <p><img src="{191652.png}" alt="" /></p>
    006+ <p><img src="{191650.png}" alt="" /></p>
    007- <p>[结果]</p>
    007+ <p><img src="{191651.png}" alt="" /></p>
    008- <br /><p>[期望]</p>
    008+ <p><img src="{191652.png}" alt="" /></p>
    009- <br />
    009+ <p><img src="{191653.png}" alt="" /></p>
    010+ <p><br /></p>
    011+ <p>[结果]</p>
    012+ <br /><p>[期望]</p>
    013+ <br />
  4. 2022-03-16 00:02:21, 由 qihaoran 编辑。
    修改了 重现步骤，区别为：
    003- 使用账号：Admin186密码：Panda186
    003+ [步骤]
    004- [步骤]
    004+
    005-
    005+
    006-
    006+
    007-
    007+
    008-
    008+
    009-
    009+
    010-
    010+ [结果]
    011- [结果]
    011+ [期望]
    012- [期望]
    012+
    013-
    003- <p>使用账号：Admin186<br />密码：Panda186</p>
    003+ <p>[步骤]</p>
    004- <p>[步骤]</p>
    004+ <p><img src="{191649.png}" alt="" /></p>
    005- <p><img src="{191649.png}" alt="" /></p>
    005+ <p><img src="{191650.png}" alt="" /></p>
    006- <p><img src="{191650.png}" alt="" /></p>
    006+ <p><img src="{191651.png}" alt="" /></p>
    007- <p><img src="{191651.png}" alt="" /></p>
    007+ <p><img src="{191652.png}" alt="" /></p>
    008- <p><img src="{191652.png}" alt="" /></p>
    008+ <p><img src="{191653.png}" alt="" /></p>
    009- <p><img src="{191653.png}" alt="" /></p>
    009+ <p><br /></p>
    010- <p><br /></p>
    010+ <p>[结果]</p>
    011- <p>[结果]</p>
    011+ <br /><p>[期望]</p>
    012- <br /><p>[期望]</p>
    012+ <br />
    013- <br />
  5. 2022-03-16 00:05:30, 由 qihaoran 编辑。
    修改了 重现步骤，区别为：
    004-
    004+
    005-
    005+
    006-
    006+
    007-
    007+
    008-
    008+
    004- <p><img src="{191649.png}" alt="" /></p>
    004+ <p><img src="{191657.png}" alt="" /></p>
    005- <p><img src="{191650.png}" alt="" /></p>
    005+ <p><img src="{191658.png}" alt="" /></p>
    006- <p><img src="{191651.png}" alt="" /></p>
    006+ <p><img src="{191659.png}" alt="" /></p>
    007- <p><img src="{191652.png}" alt="" /></p>
    007+ <p><img src="{191660.png}" alt="" /></p>
    008- <p><img src="{191653.png}" alt="" /></p>
    008+ <p><img src="{191661.png}" alt="" /></p>
  6. 2022-03-16 00:11:10, 由 qihaoran 编辑。
    修改了 重现步骤，区别为：
    002-
    002+ 账号：Admin186
    002- <p><br /></p>
    002+ <p>账号：Admin186</p>
  7. 2022-03-16 12:05:21, 由 许瑞丰 指派给 陈少军。
    修改了 指派给，旧值为 "xuruifeng"，新值为 "chenshaojun"。

    盘点出入库，sql   抽查了几次均在一秒之内，但是测试部说频繁超时，也找不到原因，请架构师帮忙诊断一下，谢谢


    SELECT * FROM (

    SELECT
    ROW_NUMBER() OVER (ORDER BY  AddTime DESC ) AS [PageIndex] ,* FROM ( SELECT  pg.ID ,
                                        pg.BillNumber ,
                                        pg.AddTime,
                                        pg.BillType ,
                                        pg.OperateTime ,
                                        ISNULL(wh.WareHouseName, '') AS WareHouseName ,
                                        ISNULL(iwh.InventoryWarehouseName, '') AS InventoryWarehouseName ,
                                        pg.SKU ,
                                        ISNULL(p.ClientSKU, '') AS ClientSKU ,
                                        pg.OrderSourceSKU ,
                                        ISNULL(p.ProductNameCN, '') AS ProductNameCN ,
                                        pg.OperateNum ,
                                        ISNULL(pg.BuyPrice,0) BuyPrice,
                                        pg.BuyShipPrice ,
                                        pg.DecalrePrice ,
                                        pg.UserName ,
                                        pg.OriginBillNumber ,
                                        ISNULL(OrderListID,0) OrderListID,
                                        CASE WHEN pg.OperateTime< @MaxClosedDate THEN ISNULL(pg.UnitPrice, 0)ELSE 0 END AS UnitPrice,
                                        --ISNULL(pg.UnitPrice, 0) AS UnitPrice ,
                                        ISNULL(pg.UnitMinus, 0) AS UnitMinus ,
                                        wh.IsTaxFree,
                                        case when LEFT(pg.OriginBillNumber,2)='BC' then 0  
                                        when LEFT(pg.OriginBillNumber,2)='ZH' then 0  
                                        when LEFT(pg.OriginBillNumber,2)='CH' then 0  
                                        else ISNULL(inoutbalance.OperateType,0) END   OperateType,
                                        pg.MUnitPrice
                                FROM    RB_Inventory_DetailLog pg WITH ( NOLOCK )
                                        LEFT JOIN RB_Inventory_InOutBallance inoutbalance WITH ( NOLOCK ) ON inoutbalance.ID=pg.RealtionId
                                                                                     AND inoutbalance.CustomerID=pg.CustomerID AND pg.WareHouseID=inoutbalance.WareHouseID
                                        LEFT JOIN RB_WareHouse wh WITH ( NOLOCK ) ON pg.CustomerID = wh.CustomerID
                                                                                     AND pg.WareHouseID = wh.ID
                                        LEFT JOIN RB_Product p WITH ( NOLOCK ) ON pg.CustomerID = p.CustomerID
                                                                                  AND pg.SKU = p.SKU
                                        LEFT JOIN RB_Inventory_WareHouse iwh WITH ( NOLOCK ) ON iwh.CustomerID = pg.CustomerID
                                                                                              AND iwh.ID = pg.MontherWareHouseID  WHERE  pg.CustomerID = @CustomerID
                                        AND pg.BillType IN(7,6)
                                        AND pg.OperateTime >= @OperateTimeBegin
                                        AND pg.OperateTime < @OperateTimeEnd ) AS TempTable ) AS  PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20

    PARAMS:@CustomerID = 1 ,@OperateTimeBegin = 2022-02-15 ,@OperateTimeEnd = 2022-03-16 0:00:00 ,@MaxClosedDate = 2022-03-01 0:00:00


    调拨出入库sql

    SELECT * FROM (
    SELECT
    ROW_NUMBER() OVER (ORDER BY  AddTime DESC ) AS [PageIndex] ,* FROM ( SELECT  pg.ID ,
                                        pg.BillNumber ,
                                        pg.AddTime,
                                        pg.BillType ,
                                        pg.OperateTime ,
                                        ISNULL(wh.WareHouseName, '') AS WareHouseName ,
                                        ISNULL(iwh.InventoryWarehouseName, '') AS InventoryWarehouseName ,
                                        pg.SKU ,
                                        ISNULL(p.ClientSKU, '') AS ClientSKU ,
                                        pg.OrderSourceSKU ,
                                        ISNULL(p.ProductNameCN, '') AS ProductNameCN ,
                                        pg.OperateNum ,
                                        ISNULL(pg.BuyPrice,0) BuyPrice,
                                        pg.BuyShipPrice ,
                                        pg.DecalrePrice ,
                                        pg.UserName ,
                                        pg.OriginBillNumber ,
                                        ISNULL(OrderListID,0) OrderListID,
                                        CASE WHEN pg.OperateTime< @MaxClosedDate THEN ISNULL(pg.UnitPrice, 0)ELSE 0 END AS UnitPrice,
                                        --ISNULL(pg.UnitPrice, 0) AS UnitPrice ,
                                        ISNULL(pg.UnitMinus, 0) AS UnitMinus ,
                                        wh.IsTaxFree,
                                        case when LEFT(pg.OriginBillNumber,2)='BC' then 0  
                                        when LEFT(pg.OriginBillNumber,2)='ZH' then 0  
                                        when LEFT(pg.OriginBillNumber,2)='CH' then 0  
                                        else ISNULL(inoutbalance.OperateType,0) END   OperateType,
                                        pg.MUnitPrice
                                FROM    RB_Inventory_DetailLog pg WITH ( NOLOCK )
                                        LEFT JOIN RB_Inventory_InOutBallance inoutbalance WITH ( NOLOCK ) ON inoutbalance.ID=pg.RealtionId
                                                                                     AND inoutbalance.CustomerID=pg.CustomerID AND pg.WareHouseID=inoutbalance.WareHouseID
                                        LEFT JOIN RB_WareHouse wh WITH ( NOLOCK ) ON pg.CustomerID = wh.CustomerID
                                                                                     AND pg.WareHouseID = wh.ID
                                        LEFT JOIN RB_Product p WITH ( NOLOCK ) ON pg.CustomerID = p.CustomerID
                                                                                  AND pg.SKU = p.SKU
                                        LEFT JOIN RB_Inventory_WareHouse iwh WITH ( NOLOCK ) ON iwh.CustomerID = pg.CustomerID
                                                                                              AND iwh.ID = pg.MontherWareHouseID  WHERE  pg.CustomerID = @CustomerID
                                        AND pg.BillType IN(4,5)
                                        AND pg.OperateTime >= @OperateTimeBegin
                                        AND pg.OperateTime < @OperateTimeEnd ) AS TempTable ) AS  PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20
    PARAMS:@CustomerID = 1 ,@OperateTimeBegin = 2022-02-15 ,@OperateTimeEnd = 2022-03-16 0:00:00 ,@MaxClosedDate = 2022-03-01 0:00:00




  8. 2022-05-16 14:47:27, 由 陈少军 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "569"。
    修改了 解决日期，旧值为 ""，新值为 "2022-05-16 14:46:40"。
    修改了 指派给 ，旧值为 "chenshaojun"，新值为 "qihaoran"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "chenshaojun"。
    查看分析后，确实是1秒内执行完成，在验证看看
  9. 2022-05-16 14:47:54, 由 陈少军 指派给 qihaoran。
    修改了 抄送给，旧值为 ""，新值为 ",xuruifeng"。
    查看分析后，确实是1秒内执行完成，在验证看看
  10. 2022-05-18 15:17:43, 由 qihaoran 添加备注。

    已验证

  11. 2022-05-18 15:17:53, 由 qihaoran 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "qihaoran"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "qihaoran"。
    修改了 关闭日期，旧值为 ""，新值为 "2022-05-18 15:17:53"。
返回
所属项目 技术中心-需求池
所属模块 /
所属计划
所属迭代 【智汇】产品部 3月 第1 版本（2022年）
Bug类型 性能问题
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人 许瑞丰
测试责任人 qihaoran
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2022-05-18 15:17:53
截止日期 0000-00-00
上线时间
上线时效
操作系统 Windows
浏览器
关键词
抄送给 许瑞丰
所属迭代 【智汇】产品部 3月 第1 版本（2022年）
相关需求
相关任务
由谁创建 qihaoran 于 2022-03-15 23:25:53
影响环境 577
由谁解决 陈少军 于 2022-05-16 14:46:40
解决版本 569
解决方案 性能问题
由谁关闭 qihaoran 于 2022-05-18 15:17:53
最后修改 qihaoran 于 2022-05-18 15:17:53
相关Bug