任务描述
1。问题分析;
  count() 查询了大量不必要的字段和left join 查询,耗费了大量时间, 

2.解决方案:
1. select 查询去掉 其他查询字段,只保留一个rps.ID;
2. 去掉left join 查询;
3. in 查询修改为表值参数或零时表后join 查询

    rb.BusinessAdminID in (


测试优化后由100秒减少到优化后的2秒


3. 优化后的慢查询sql

SELECT Count(1)
FROM   (SELECT rps.ID
               --rps.CustomerID,
               --rps.SKU,
               --rps.ProductNameCN,
               --rps.ShipDate,
               --rps.DailyAvgSalePrice,
               --rps.DailySaleNumber,
               --rps.DailyAvgProfits               AS DailyAvgProfits,
               --rps.SevenDayAvgProfits            AS SevenDayAvgProfits,
               --rps.DailyProfits,
               --CASE
               --  WHEN rps.SKUCurrWeekprofits = 0 THEN 0
               --  ELSE ( rps.SKUCurrWeekprofits - rps.SKULastWeekprofits ) / rps.SKUCurrWeekprofits
               --END                               AS WeekOrofitGrowthRate,
               --Isnull(rps.SevenDayProfits, 0)    AS SevenDayProfits,
               --Isnull(rps.SevenDaySaleNumber, 0) AS SevenDaySaleNumber,
               --Isnull(rps.MonthProfits, 0)       AS MonthProfits,
               --Isnull(rps.MonthSaleNumber, 0)    AS MonthSaleNumber,
               --Isnull(rps.MonthAvgProfits, 0)    AS MonthAvgProfits,
               --pa.DevelopAdminName,
               --Isnull(( CASE
               --           WHEN p.ClassID1 = p.ClassID THEN c1.ClassNameCn
               --           WHEN p.ClassID1 != p.ClassID2
               --                AND p.ClassID = p.ClassID2 THEN c1.ClassNameCn + ' >> ' + c2.ClassNameCn
               --           WHEN p.ClassID1 = p.ClassID2
               --                AND p.ClassID != p.ClassID2 THEN c1.ClassNameCn + ' >> ' + c3.ClassNameCn
               --           ELSE c1.ClassNameCn + ' >> ' + c2.ClassNameCn + ' >> '
               --                + c3.ClassNameCn
               --         END ), '')               AS ClassNameCn,
               --rps.DailyAvgRefund,
               --rps.SevenDayAvgRefund,
               --rps.MonthAvgRefund,
               --rps.DailyRefund,
               --rps.SevenDayRefund,
               --rps.MonthRefund
        FROM   RB_Report_SKUProductProfitStastic rps(NOLOCK)
               --LEFT JOIN dbo.RB_Product AS p(NOLOCK)
               --       ON p.CustomerID = rps.CustomerID
               --          AND p.SKU = rps.SKU
               --LEFT JOIN dbo.RB_Product_Admin AS pa(NOLOCK)
               --       ON pa.CustomerID = p.CustomerID
               --          AND pa.SKU = p.SKU
               --LEFT JOIN RB_Product_Class AS c1 WITH(nolock)
               --       ON p.CustomerID = c1.CustomerID
               --          AND p.ClassID1 = c1.ID
               --LEFT JOIN RB_Product_Class AS c2 WITH(nolock)
               --       ON p.CustomerID = c2.CustomerID
               --          AND p.ClassID2 = c2.ID
               --LEFT JOIN RB_Product_Class AS c3 WITH(nolock)
               --       ON p.CustomerID = c3.CustomerID
               --          AND p.ClassID = c3.ID
        WHERE  rps.CustomerID = 1
               AND rps.ShipDate >= '2022-02-24 11:19:09'
               AND rps.ShipDate <= '2022-03-24 11:19:09'
       AND Exists(
       SELECT top 1 1  FROM RB_Report_SalesProductProfit AS rb WHERE rps.CustomerID=rb.CustomerID AND rps.SKU=rb.SKU AND rb.ShipDate=rps.ShipDate  
         AND rb.BusinessAdminID in (
               94,4964,224,2577,5600,1941,1941,563,1062,1222,3148,3418,3708,3723,3812,5575,6250,6309
               ,563,725,994,2026,2304,3353,3553,3943,4193,5229,5546,6441,6845,725,393,1027,1282,2078,
               2139,3360,3466,3801,3945,5599,6252,6846,1282,1472,2356,3273,3377,3405,3469,5427,5597,
               5900,6101,6105,6143,6307,6360,6617,3273,3222,3542,3615,3616,3771,3790,3967,4215,4216,
               5689,5758,5786,6275,6323,3616,3709,3738,3788,5426,5574,5982,6018,6031,6230,6361,6424,6629,
               3788,6844,271,271,202,1322,2768,2990,3731,4136,5210,5815,6002,6293,6321,6474,2990,1037,2582,
               3758,5286,5425,5471,5945,6279,6300,6434,6455,6564,6739,6823,1037,1479,2137,2152,
               3088,3179,5167,5304,5826,5825,5925,6505,6796,1479,304,2045,4321,5326,5724,304,139,270,424,
               1013,1060,2116,1114,4660,996,1025,1837,2296,2947,3236,3452,4214,4432,4516,4517,4539,4563,4839,
               4965,5252,5338,5754,5804,5926,6033,6453,996,1073,2089,2261,2342,4236,938,954,1021,1024,1992
               ,3532,4226,4237,4842,6372,4291,4669,4681,4812,4815,4831,2148,4273,4274,4599,4620,4668,4762,4811,
               4820,5012,5179,3286,3473,3964,4238,4295,4657,4841,4957,4958,6756,3286,3355,3446,3503,3505,4239,4279,
               4324,4336,4793,4322,4325,4356,4438,4440,4621,4745,4827,4866,6318,3338,3384,4800,4863,4867,6426,6447
               ,6670,6687,3308,3339,4690,4700,4701,4898,3300,6402,6403,3474,3504,3901,4622,4757,4794,4039,4039,3278,
               3637,4331,4458,4935,5394,5506,6023,6713,3637,3190,3197,4897,5763,5984,6577,6712,3197,4275,5325,5325,1770,
               1770,1005,1575,4072,6567,6714,1005,3334,4646,6240,6633,3334,2000,4731,6289,2129,2167,4603,5180,6590,6632,
               6859,6868,7039,7092,7098,7099,7131,4608,4639,6627,4639,3428,3428,1780,2596,2901,4293,4294,4653,6271,6425,
               1780,4562,4754,5474,5906,6206,6264,6265,4511,5788,6272,6324,6417,6443,6499,6522,6524,6523,6685,4047,4048,
               4049,5351,5352,5353,882,1463,1486,1799,2125,2436,2859,4116,4126,4288,4299,4303,4348,4367,4369,4747,4943,
               4946,4976,4977,5106,5151,5205,5222,5346,5370,5482,5483,5484,5512,5519,5520,5673,5733,5734,5769,5775,5951,
               6182,6675,882,882,7152,5393,5401,5739,5777,5889,1834,2364,3823,3885,4315,4695,5187,5290,5581,5606,5745,
               5746,7201,7207,1834,7056,5729,6775,6774,6766,6768,6770,6771,6762,6470,6763,6764,6765,3736,2587,2588,2593
               ,3735,5310,5311,5312,5309,5356,5357,5358,5359,5360,3794,3831,4188,4284,4285,4667,6594,6492,6494,6493,6489,
               6491,6487,6488,6496,6559,6560,6561,6558,6498,6490,6557,6495,6497,6562,5405,5406,5407,5408,5409,5476,5477,
               5478,5479,5480,5481,5931,5932,5933,5934,5957,5958,5959,5960,5961,5962,5963,5964,5965,5969,5967,5968,6081,6082,
               6083,6084,6085,6086,6087,6088,6089,6090,6091,6093,6094,6207,6208,6209,6210,6211,6212,6213,6214,6215,6216,6217,6218,
               6219,6220,6221,6222,6223,6224,6225,6226,6337,6338,6339,6340,6341,6342,6343,6344,6345,6346,6381,6383,6384,6385,6449,
               6450,6783,6784,6785,6786,6791,6792,6793,6798,6799,6800,6795,6825,6826,6827,6863,6864,6869,6870,6877,6880,6886,6887,
               6895,6896,6898,6899,6900,6901,6904,6905,6906,6907,6917,6918,6920,6921,6934,6935,6937,7010,7011,6971,6972,6973,6958,
               6948,6949,6950,6951,6952,6953,6954,6955,6956,6994,6995,6996,6997,6966,6967,6969,6974,6975,6976,6961,6977,6962,7001,
               7002,7003,7004,7005,7012,6963,6959,7006,7007,6978,6960,7046,6942,6943,6944,7047,7013,6999,6979,6980,6981,6982,6983,
               6984,6985,6986,6987,6988,6989,6964,7048,6990,6991,6992,6993,6965,6970,6998,7000,7008,7009,7014,7020,7021,7022,7023,
               7034,7035,7041,7042,7043,7045,7049,7050,7051,7061,7062,7063,7064,7065,7070,7074,7076,7077,7078,7080,7081,7082,7083,
               7084,7085,7086,7087,7089,7090,7091,7094,7095,7096,7097,7100,7101,7106,7109,7110,7111,7115,7116,7118,7120,7121,7122,
               7123,7124,7128,7129,7130,7134,7149,7165,6550,6551,6552,6553,6554,6480,6481,6482,6483,6484,6485,6486,6555,6623,6624,
               6693,6694,6726,6727,371,6540,6542,6544,6592,6760,6463,6464,6465,6507,6467,6468,6469,6472,6476,6477,6478,6479,6546,6547,
               6548,6549,6593,6618,6621,6622,6672,6673,1197,1319,1316,1324,1468,7140,1830,2235,2234,2634,2835,3247,3821,3824,3825,3827,
               3883,3886,3888,4103,4104,4133,4333,4316,4317,4365,4460,4535,4719,4721,4854,4907,4908,4909,4912,4921,4923,4925,5005,5186,5283,
               5306,7025,5442,5443,5444,5445,5670,5522,5523,5608,5607,5740,5741,5742,5743,5744,5756,5757,5764,5765,5791,5792,5793,5794,5817,
               5855,7029,5857,5858,5883,5928,5929,5930,5955,5956,5975,5976,5977,6129,6130,6155,6204,7026,6243,6298,6322,6377,6378,6379,6380,
               6386,6392,6527,6586,6587,6585,6588,6607,6608,6609,6610,6640,6641,6642,6643,6644,6650,6651,6652,6689,6704,6735,6737,6830,6758,
               6759,6862,7027,6892,6916,7015,7016,7030,7037,7038,7052,7055,7088,7112,7127,7135,7141,7142,7151,7156,7157,7166,7171,7174,7175,
               7176,7179,7180,7189,7190,7191,7192,7193,7198,7200,7206,7209,7213,7214,7218,7219,7220,7242,7243,7246,7245,7249,7250,7251,7252,
               7256,7257,7261,7266,7267,7268,7269,7272,7273,7279,7280,7281,7282,371,6601,6662,138,3958,3959,4179,4180,4012,3991,3992,5291,
               6676,1775,1789,1790,1861,1869,1919,1934,2172,2314,2431,2442,2515,2541,2552,2553,2708,2710,2844,3243,2983,3034,3228,3271,
               3386,3475,3517,3548,3607,3785,3668,3753,3815,3820,3858,3859,3861,3882,3947,3951,4029,4420,4748,4992,5019,5023,5031,5033,5066,
               5068,5070,5071,5134,5135,5169,5188,5191,5198,5199,5206,5218,5223,5225,5234,5235,5257,5274,5279,5280,5298,5321,5334,5368,5369,
               5372,5373,5374,5375,5376,5379,5380,5381,5382,5383,5384,5387,5388,5389,5390,5391,5392,5395,5396,5397,5398,5400,5447,5449,5451,
               5452,5453,5454,5455,5463,5464,5465,5467,5468,5486,5487,5488,5489,5490,5492,5494,5495,5497,5498,5499,5500,5501,5508,5511,5513,5516,
               5517,5524,5586,5587,5671,5672,5674,5675,5676,5677,5678,5679,5695,5698,5699,5700,5702,5703,5704,5730,5731,5753,5735,5736,5737,5738,5751,
               5752,5770,5771,5772,5774,5776,5818,5819,5820,5821,5822,5823,5844,5845,5846,5864,5865,5870,5871,5884,5885,5886,5887,5888,5890,5936,5937,5938,
               5939,5940,5941,5942,5943,5944,5953,5954,5978,5979,5988,5989,5990,6009,6010,6011,6012,6013,6014,6015,6024,6025,6026,6027,6028,6036,6037,6038,
               6039,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,6073,6074,6075,6076,6077,6078,6079,6080,6116,6117,6118,6119,6120,6121,6123,6124,
               6125,6132,6134,6135,6136,6137,6138,6139,6140,6141,6170,6171,6172,6173,6174,6175,6176,6177,6178,6231,6232,6233,6234,6235,6236,6237,6238,6282,
               6283,6284,6285,6286,6287,6297,6347,6348,6349,6350,6351,6352,6409,6410,6412,6414,6415,6429,6535,6536,6537,6539,6597,6598,6599,6600,6625,6626,
               6648,6649,6661,6705,6707,6722,6723,6746,6747,6780,6871,6872,6873,6874,6884,6930,6924,7018,7073,6203,138,4167,4168,4169,4492,435,610,778,804,
               807,956,1032,1107,1161,1217,1261,1262,1263,1299,1356,1354,1391,4024,4025,4117,4118,4119,4120,4148,4160,4161,4164,4165,4176,4197,4204,4205,4206,
               4217,4220,4229,4260,4264,4265,4289,4304,4346,4349,4357,4361,4381,4386,4387,4393,4402,4407,4446,4447,4473,4501,4521,4530,
               4545,4548,4553,4577,4579,4609,4612,4637,4638,4671,4704,4705,4712,4714,4724,4726,4749,4765,4771,4779,4796,4803,4837,4878,
               4882,4885,4900,4902,4960,4949,4954,5402,5798,6181,6253,6255,6256,6257,6258,6259,1129,903,1215,2443,2489,2652,6929,
               6909,6910,6911,6912,6913,6914,6915,7044,7060,6957,6502,6503,6504,7247,333,6374,6375,6376,6418,6420,6421,6471,6462
               ,6528,6569,6570,6576,6604,6802,6803,6923,6928,7113,7114,7148,7194,7195,7199,7202,7203,7205,7211,7212,7210,7229,7230
               ,7231,7232,7233,7234,7235,7236,7237,7238,7253,7254,7255,7259,7262,7263,7283,751,1049,3724,4079,4092,4093,4123,5366
               ,5371,5448,5697,6122,6133,6538,7183,685,541,592,2253,3150,3235,5319,5347,5948,6148,6373,1444,541,1439,5525,5526,5779
               ,6437,7154,5779,659,915,998,2190,3837,4011,5125,5176,5415,6164,659,4018,4814,5220,5876,4814,297,2776,2890,4088,4566,
               4752,4928,5080,5416,5692,5762,5778,5835,7153,7264,7274,6897,220,3778,3495,4010,1360,1361,1440,1266,1950,1995,2061,2071
               ,2248,2779,3027,6260,6452,6752,6867,7069,7104,1015,1886,2605,2640,3029,3537,5057,6718,7265,2130,2280,2632,2935,4019
               ,4213,5138,6866,7031,7197,651,2809,4212,4634,5014,5177,5282,5601,5897,5918,6517,6683,6822,6848,7133,2746,2747,71
               ,2,241,3221,1811,5270,5611,6391,235,327,327,436,1900,3349,3659,3766,3802,4514,4840,6315,6698,6781,1900,692,1986
               ,2512,3210,3660,4138,4139,6400,6445,6927,692,350,2160,2573,2858,3015,3200,4036,5878,6730,7032,7136,7137,350,1150
               ,2810,2857,3174,3299,3521,4845,5084,6049,6699,6782,7138,1150,2952,3183,3226,3297,3341,4490,5062,5078,6719,6855,6878
               ,3183,2143,3054,3128,5288,5583,5688,5759,6109,6367,6525,6541,6635,502,502,625,1524,2594,3199,5642,5643,6512,6605,6947
               ,625,2842,5323,5364,5852,5873,5997,7059,7144,2842,1812,5644,5946,6436,6456,6513,6832,1812,3748,4810,5831,7058,3748,2917
               ,4758,6100,6305,6390,6821,6922,2917,3650,5994,6151,6299,6932,3650,389,389,1118,2135,2884,5060,5850,5905,6888,7158,1118
               ,1151,1827,2940,5650,6150,6396,7067,1151,2603,3117,3445,4593,5128,5799,6334,6850,3445,2113,4035,4597,6423,6939,7186,4035
               ,4959,5646,5910,6329,4959,2001,6068,6646,6831,7182,2001,231,231,546,3285,3347,3471,4484,4776,4781,5895,6067,6358,6817
               ,546,534,2107,3302,3329,4966,5308,5983,6000,6229,534,3905,3955,4648,5412,5807,6249,6738,4034,4034,4070,4109,5026,5030
               ,6190,6728,6804,6839,5026,2413,5638,5892,5924,6304,6398,7102,2413,4890,4891,5633,6680,6717,4890,230,230,3710,3741,5141
               ,5923,6159,6179,1244,1913,2332,2441,3164,3507,4696,5215,5514,1244,2136,2914,3007,5076,5617,5618,5853,6055,6153,3007
               ,2076,3584,3906,4666,6303,6882,6883,2076,2475,3903,4538,5613,5615,6364,2475,3343,5318,6030,6440,7053,3343,390,390
               ,530,2651,3261,3630,3845,5011,6301,6518,530,552,1967,3486,3627,5624,5625,6788,6843,7143,7276,552,885,3740,3894,5893
               ,6806,885,1968,3869,3908,5061,6458,7275,3908,2911,5344,5619,6146,6807,7108,2911,3911,5981,6005,6744,3911,267,267
               ,2216,4470,5411,5830,5862,6428,6743,7066,2216,655,2648,2916,2955,3759,4537,6189,6734,6816,6824,655,2528,3804,3912
               ,5143,5629,5630,6180,6281,6606,2528,2782,3587,5716,6277,6682,6716,6741,2782,2110,5293,5631,6745,7147,7164,2110
               ,3770,6183,6288,6809,7105,3770,2175,2175,2735,3260,5114,5595,5596,5656,5800,5851,6368,2735,2861,3163,3171,3361
               ,3904,5655,6669,6732,7167,3361,3277,3747,4064,5654,5709,6192,6860,3277,1241,4488,5053,5816,6645,6751,7181,1241
               ,2886,4896,6228,6261,6422,6808,6931,4896,2121,2121,1882,2942,3559,5708,5827,5899,6638,6655,6690,6849,6851,2912
               ,3443,3846,6667,6691,6695,6715,6750,6865,7278,2912,5663,5664,5681,6042,7277,2714,5230,5612,5721,6278,6439,7017
               ,7161,7163,2714,3264,3264,403,2285,5305,5475,6526,6583,6731,7072,2285,342,2309,2824,2960,3713,5262,6584,6688,
               3713,3619,5685,6169,6241,6325,7071,5433,5557,106,1549,5429,1835,1835,1184,2145,3419,3436,3541,3589,3939,4727
               ,5552,6572,3541,1098,1814,2878,3465,4683,1098,3056,3120,3704,4058,5457,5840,6369,3056,357,6663,1953,1974,1985
               ,2994,5320,5727,6097,1953,1195,1435,2105,2361,2367,2402,5576,5833,6126,6292,497,497,497,967,3578,3595,4504,
               5547,6195,6196,6639,967,440,1334,1954,1996,3586,4008,5570,440,856,988,2183,2948,3052,3223,3406,3540,3638,856
               ,1258,1866,2051,3459,5935,2051,3442,3442,1779,1929,2880,2889,3133,3556,3687,5055,5432,5055,2469,2780,3411,3893
               ,4051,5029,6653,2469,2150,2691,3145,3502,3701,3844,6363,3502,2088,3083,4543,5550,5590,5875,5903,6431,6709,2088,
               3031,3568,3715,3946,4327,5694,7033,5221,844,3059,5247,6184,7019,7019,374,5049,5343,5458,5568,5569,5841,5913,5972,
               6108,6099,6145,6157,6328,6370,374,1534,1776,3232,3457,5691,6034,6046,6432,6631,6679,1534,3166,4968,5782,5859,5902
               ,5912,6004,6681,5782,3889,6147,3889,1802,6589,3217,5292,3156,1958,2834,3451,3900,4241,2807,2807,7227,7239,7240,7241,
               208,3520,2626,7228,587,527,5435,5805,5809,5812,2730,7184,2679,488,4023,1249,2414,2215,5986,258,258,1521,1803,3142,3923
               ,5578,5904,6357,1521,3557,5158,5424,5785,5842,6312,3557,2187,4971,5422,2187,2344,3276,3768,4798,4871,5113,5159,5591,5847
               ,6198,6515,3276,2926,4166,4541,4604,5423,5592,6573,6657,6658,4166,3043,3058,3930,5378,5950,2645,5726,5783,6331,6565,2645,
               2465,4053,5013,5075,5317,5504,5504,1003,3057,3430,1003,2163,4832,5047,5461,5503,5589,5848,2163,6003,819,4494,5027,5593,5993
               ,6160,6201,6461,6506,6579,6579,921,2892,3030,6016,6043,6070,6199,6244,7270,7271,2416,6729,6729,4235,4861,1416,1416,2022,5420
               ,6306,5579,5720,4865,3924,2864,3956,5101,5533,6430,6520,6933,7036,1902,2034,2034,6853,2477,2449,2452,2808,4334,4640,4664,753
               ,753,412,2219,2297,2427,4624,6051,558,1976,2815,3813,3960,4328,5907,1879,2291,2796,4635,5269,1133,2098,2527,2677,4862,6702,1133
               ,957,4020,5837,5868,5980,6266,6419,6545,957,2307,4462,5867,6267,6754,2374,5991,290,290,2027,3642,6006,6069,6149,6165,6188,6200,
               6290,6335,857,2057,3130,3321,3872,3874,3875,4276,6314,6397,901,2698,3087,3487,5123,6389,1076,2445,5438,5949,5417,5872,1122,1567,
               1122,1405,3101,4297,4782,6021,6245,6519,3344,5602,5780,5854,6654,2360,2360,2184,2212,4972,5361,5527,6053,6753,1991,2387,3135,3467,4895
               ,5914,5970,6596,6811,1991,3957,7215,7248,6837,6678,6748,1518,6677,7159,7103,7117,7132,7145,7169,7139,7172,7172)
          )
       ) AS PagerTable 

   --946950
历史记录  
  1. 2022-04-28 15:46:37, 由 陈少军 创建。
  2. 2022-04-28 15:49:23, 由 陈少军 指派给 许瑞丰。
    修改了 预计剩余,旧值为 "0",新值为 "2"。

     参考解决方案修改

    等同 bug28293 产品利润,进页面超时报错,修改后,改一下状态

  3. 2022-04-29 10:22:37, 由 许瑞丰 完成。
    修改了 总计消耗,旧值为 "0",新值为 "5"。
    修改了 指派给 ,旧值为 "xuruifeng",新值为 "chenshaojun"。
    修改了 实际完成,旧值为 "",新值为 "2022-04-29 10:20:56"。
    修改了 任务状态,旧值为 "wait",新值为 "done"。
    修改了 实际开始,旧值为 "0000-00-00 00:00:00",新值为 "2022-04-29 10:22:37"。
    修改了 预计剩余,旧值为 "2",新值为 "0"。
    修改了 由谁完成,旧值为 "",新值为 "xuruifeng"。
       同这个BUG,语句和功能完全一致,这个已经在2022-04-29优化完成等待上线
  4. 2022-07-16 17:09:17, 由 zhengqiao 关闭。
    修改了 任务状态,旧值为 "done",新值为 "closed"。
    修改了 指派给 ,旧值为 "chenshaojun",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "zhengqiao"。
    修改了 关闭时间,旧值为 "0000-00-00 00:00:00",新值为 "2022-07-16 17:09:17"。
    修改了 关闭原因,旧值为 "",新值为 "done"。
所属迭代 系统管理部 - 系统服务优化
所属模块 /
相关需求 暂无
指派给 Closed 于 2022-07-16 17:09:17
任务类型 后端
任务标签 初始
开发组
任务状态 已关闭
进度 100%
优先级 P2
关键词
抄送给 刘灿 黄金龙 胡晓龙
由谁创建 陈少军 于 2022-04-28 15:46:37
由谁完成 许瑞丰 于 2022-04-29 10:20:56
由谁取消 暂无
由谁关闭 zhengqiao 于 2022-07-16 17:09:17
关闭原因 已完成
最后编辑 zhengqiao 于 2022-07-16 17:09:17
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 0工时
总计消耗 5工时
预计剩余 0工时
预计开始 2022-04-28
实际开始 2022-04-29
截止日期 2022-05-05