需要账户私聊提供
目前发现该页面有的账户会超时，有的账户不会
重现步骤
历史记录
- 2022-03-14 11:49:00, 由 林鸿贵 创建。
-
2022-03-14 15:02:05, 由 林鸿贵 编辑。
修改了 指派给，旧值为 "chengwei"，新值为 "linhonggui"。
-
2022-03-23 09:37:55, 由 林鸿贵 编辑。
修改了 Bug类型 ，旧值为 "bypuduct"，新值为 "bydesign"。
修改了 指派给 ，旧值为 "linhonggui"，新值为 "hejianbao"。
修改了 所属迭代，旧值为 "613"，新值为 "617"。
修改了 相关任务，旧值为 "25412"，新值为 "0"。
修改了 影响环境，旧值为 "572"，新值为 "588"。
修改了 Bug标题 ，区别为：001-
新增仓库报错
001+ 产品利润，进页面超时报错001-
修改了 重现步骤，区别为：新增仓库报错
001+ 产品利润，进页面超时报错001-
http://10.158.158.22:8080/IrobotBox/LogFile/LogFileEdit.aspx?1=1&keywords=N1145461&fileName=DBError_2022-03-14.txt
001+ 需要账户私聊提供
002-
002+ 目前发现该页面有的账户会超时，有的账户不会
003+001-
<p>http://10.158.158.22:8080/IrobotBox/LogFile/LogFileEdit.aspx?1=1&keywords=N1145461&fileName=DBError_2022-03-14.txt</p>
001+ <p>需要账户私聊提供</p>
002-<p><img src="{191556.png}" alt="" /></p>
002+ <p>目前发现该页面有的账户会超时，有的账户不会</p>
003+ <p><img src="{192160.png}" alt="" /><img src="{192161.png}" alt="" /></p> -
2022-03-23 11:24:14, 由 何建宝 指派给 林鸿贵。
修改了 指派给，旧值为 "hejianbao"，新值为 "linhonggui"。
产品利润不属于我这边的模块 -
2022-03-24 09:36:44, 由 林鸿贵 指派给 许瑞丰。
修改了 指派给，旧值为 "linhonggui"，新值为 "xuruifeng"。
-
2022-03-24 13:38:36, 由 许瑞丰 解决，方案为 性能问题 。
修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2022-03-24 13:36:16"。
修改了 指派给 ，旧值为 "xuruifeng"，新值为 "linhonggui"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "xuruifeng"。
正常客户使用不会有问题，原因是因为这个账号开通了查看所有销售人员的权限，一次查这么多销售人员的数据导致超时的可能
-
2022-03-24 13:42:18, 由 许瑞丰 添加备注。
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
--select COUNT(*) from RB_Report_SalesProductProfit
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
原sql
-
2022-03-24 15:39:41, 由 林鸿贵 指派给 胡晓龙。
修改了 指派给，旧值为 "linhonggui"，新值为 "huxiaolong"。
原因：
有的账户权限比较大，可以查80%、90%的销售人员数据，导致超时
-
2022-03-25 09:20:19, 由 许瑞丰 添加备注。
建议调整设计，需要查询全员权限需要有独立的标识（不做销售员过滤条件的形式同样达到查询全员），（目前查询全员权限，依然需要过滤销售员，只是把过滤的个人增加到几千个或者更多，导致查询非常慢）
-
2022-03-29 13:51:00, 由 胡晓龙 指派给 陈少军。
修改了 指派给，旧值为 "huxiaolong"，新值为 "chenshaojun"。
少军，你帮看下这个sql -
2022-03-29 13:51:48, 由 胡晓龙 激活。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "active"。
修改了 影响环境，旧值为 "588"，新值为 "577"。
修改了 激活日期，旧值为 ""，新值为 "2022-03-29 13:51:48"。
修改了 激活次数，旧值为 "0"，新值为 "1"。
修改了 解决方案，旧值为 "performance"，新值为 ""。
修改了 解决日期，旧值为 "2022-03-24 13:36:16"，新值为 "0000-00-00"。
修改了 解决者 ，旧值为 "xuruifeng"，新值为 ""。
修改了 解决版本，旧值为 "trunk"，新值为 ""。
修改了 关闭日期，旧值为 ""，新值为 "0000-00-00"。
-
2022-04-28 15:39:50, 由 陈少军 解决，方案为 性能问题 。
修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "569"。
修改了 解决日期，旧值为 ""，新值为 "2022-04-28 15:34:48"。
修改了 指派给 ，旧值为 "chenshaojun"，新值为 "xuruifeng"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 解决者 ，旧值为 ""，新值为 "chenshaojun"。
1。问题分析；
1.count(） 查询了大量不必要的字段和left join 查询，耗费了大量时间
2.解决方案：
1. select 查询去掉 其他查询字段，只保留一个rps.ID；
2. 去掉left join 查询；
3. in 查询修改为表值参数或零时表后join 查询
rb.BusinessAdminID in (
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 -
2022-04-28 15:41:07, 由 陈少军 指派给 许瑞丰。
修改了 抄送给，旧值为 ""，新值为 ",huxiaolong"。
参考解决方案修改，测试 效果由100秒查询减少到优化后的2秒查询出结果 -
2022-04-28 15:55:04, 由 许瑞丰 指派给 何智军。
修改了 指派给，旧值为 "xuruifeng"，新值为 "hezhijun"。
-
2022-05-03 16:19:33, 由 何智军 添加备注。
该报表查询的时候，Get请求拼接的URL参数过长也会导致报错
-
2022-05-04 19:11:48, 由 何智军 指派给 林鸿贵。
修改了 指派给，旧值为 "hezhijun"，新值为 "linhonggui"。
重新调整URL参数，查询中使用表值函数切分，添加表索引 -
2022-05-05 17:30:17, 由 林鸿贵 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "linhonggui"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "linhonggui"。
修改了 关闭日期，旧值为 ""，新值为 "2022-05-05 09:32:12"。
SQL脚本执行没有报错
具体性能优化效果线上观察
| 所属项目 | 技术中心-需求池 |
|---|---|
| 所属模块 | / |
| 所属迭代 | 【智汇】产品部 3月 第 2 版本（2022年） |
| Bug类型 | 系统设计缺陷 |
| 严重程度 | 提示 |
| 优先级 | P2 |
| Bug状态 | 已关闭 |
| 业务部门 | |
| 开发责任人 | |
| 测试责任人 | |
| 解决时效 | 0 |
| 激活次数 | 1 |
| 激活日期 | 2022-03-29 13:51:48 |
| 当前指派 | Closed 于 2022-05-05 09:32:12 |
| 截止日期 | 0000-00-00 |
| 上线时间 | |
| 上线时效 | |
| 关键词 | |
| 抄送给 | 胡晓龙 |
| 所属迭代 | 【智汇】产品部 3月 第 2 版本（2022年） |
|---|---|
| 相关需求 | |
| 相关任务 |
| 由谁创建 | 林鸿贵 于 2022-03-14 11:49:00 |
|---|---|
| 影响环境 |
577 |
| 由谁解决 | 陈少军 于 2022-04-28 15:34:48 |
| 解决版本 | 569 |
| 解决方案 | 性能问题 |
| 由谁关闭 | 林鸿贵 于 2022-05-05 09:32:12 |
| 最后修改 | 林鸿贵 于 2022-05-05 09:32:12 |
| 相关Bug |
|---|