深圳智汇创想科技有限公司

修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2025-10-17 17:52:07"。
修改了 指派给 ，旧值为 "renfangtao"，新值为 "chenlizhen"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "renfangtao"。

修改了 所属模块 ，旧值为 "0"，新值为 "1868"。
修改了 业务部门 ，旧值为 "0"，新值为 "2"。
修改了 测试责任人，旧值为 ""，新值为 "renfangtao"。
修改了 解决时效 ，旧值为 "0"，新值为 "7.12"。
修改了 重现步骤 ，区别为：

001-
001+ 反馈人：李冠
002- 反馈人：李冠
002+ aliexpress严重SQL性能问题，一次性查询太多数据，造成数据库压力过大，或服务OOM，性能SQL为：
003-
003+ SELECT id,customer_id,import_type,import_id,rule_code,import_val,convert_val,create_by,create_time,update_by,update_time,is_deleted FROM t_strategy_import_filter_aliexpress WHERE (rule_code = appoint_product AND import_id IN (29574,29572,29571,29569,29568,29563,29559,29556,29555,29553,29551,29548,29547,29546,29544,29535,29534,29533,29530,29527,29056,29043,28961,28960,28956,28955,28949,28944,28932,28930,28926,28924,28919,28898,28847,28819,28814,28812,28811,28803,28802,28798,28796,28794,28680,28642,28634,28632,28631,28629,28628,28621,28620,28607,28606,28595,28594,28589,28588,28585,28584,28577,28576,28573,28572,28515,28514,28513,28512,28509,28508,28499,28497,28396,28395,28390,28389,28381,28379,28378,28377,28375,28267,28266,28263,28262,28259,28258,28257,28256,28255,28254,28253,28252,28251,28250,28249,28248,28247,28246,28243,28242,28241,28240,28195,28194,28183,28182,28181,28180,28177,28123,28118,28117,28114,28109,28105,28094,28093,28053,28052,28051,28044,28033,27947,27877,27861,27859,27858,27856,27853,27848,27844,27841,27839,27807,27806,27804,27799,27798,27788,27777,27776,27772,27769,27764,27762,27761,27723,27721,27720,27718,27714,27712,27591,27588,27587,27586,27585,27584,27583,27582,27580,27579,27564,27556,27551,27550,27549,27537,27536,27497,27490,27485,27484,27480,27472,27471,27470,27460,27445,27408,27395,27386,27383,27378,27377,27376,27375,27374,27372,27238,27236,27231,27229,27228,27227,27191,27187,27186,27184,27179,27176,27174,27170,27168,27154,27148,27142,27141,27134,27108,27106,27103,27101,27098,27092,27086,27082,27081,27080,27006,26955,26918,26906,26893,26888,26855,26839,26837,26826,26822,26820,26817,26815,26814,26808,26790,26774,26766,26758,26756,26750,26747,26739,26717,26701,26660,26633,26618,26590,26580,26572,26559,26547,26517,26490,26482,26469,26468,26465,26461,26456,26447,26446,26424,26422,26418,26409,26408,26405,26400,26380,26377,26366,26349,26309,26296,26287));
004-
004+ <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/17/10f7e87b1d3c450ba5f3ad093560ab0d/7b3faa67-c4bb-4731-9e5a-7acaf2afb1c0.png" title="from clipboard" alt="from clipboard" />
005- aliexpress严重SQL性能问题，一次性查询太多数据，造成数据库压力过大，或服务OOM，性能SQL为：
005+ 解决方案：分页查询
006-
007-
008- SELECT id,customer_id,import_type,import_id,rule_code,import_val,convert_val,create_by,create_time,update_by,update_time,is_deleted FROM t_strategy_import_filter_aliexpress WHERE (rule_code = appoint_product AND import_id IN (29574,29572,29571,29569,29568,29563,29559,29556,29555,29553,29551,29548,29547,29546,29544,29535,29534,29533,29530,29527,29056,29043,28961,28960,28956,28955,28949,28944,28932,28930,28926,28924,28919,28898,28847,28819,28814,28812,28811,28803,28802,28798,28796,28794,28680,28642,28634,28632,28631,28629,28628,28621,28620,28607,28606,28595,28594,28589,28588,28585,28584,28577,28576,28573,28572,28515,28514,28513,28512,28509,28508,28499,28497,28396,28395,28390,28389,28381,28379,28378,28377,28375,28267,28266,28263,28262,28259,28258,28257,28256,28255,28254,28253,28252,28251,28250,28249,28248,28247,28246,28243,28242,28241,28240,28195,28194,28183,28182,28181,28180,28177,28123,28118,28117,28114,28109,28105,28094,28093,28053,28052,28051,28044,28033,27947,27877,27861,27859,27858,27856,27853,27848,27844,27841,27839,27807,27806,27804,27799,27798,27788,27777,27776,27772,27769,27764,27762,27761,27723,27721,27720,27718,27714,27712,27591,27588,27587,27586,27585,27584,27583,27582,27580,27579,27564,27556,27551,27550,27549,27537,27536,27497,27490,27485,27484,27480,27472,27471,27470,27460,27445,27408,27395,27386,27383,27378,27377,27376,27375,27374,27372,27238,27236,27231,27229,27228,27227,27191,27187,27186,27184,27179,27176,27174,27170,27168,27154,27148,27142,27141,27134,27108,27106,27103,27101,27098,27092,27086,27082,27081,27080,27006,26955,26918,26906,26893,26888,26855,26839,26837,26826,26822,26820,26817,26815,26814,26808,26790,26774,26766,26758,26756,26750,26747,26739,26717,26701,26660,26633,26618,26590,26580,26572,26559,26547,26517,26490,26482,26469,26468,26465,26461,26456,26447,26446,26424,26422,26418,26409,26408,26405,26400,26380,26377,26366,26349,26309,26296,26287));
009-
010-
011- <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/17/10f7e87b1d3c450ba5f3ad093560ab0d/7b3faa67-c4bb-4731-9e5a-7acaf2afb1c0.png" title="from clipboard" alt="from clipboard" />
012-
013-
014- 解决方案：分页查询
015-

001- <p>
001+ <p>反馈人：李冠</p>
002- 反馈人：李冠
002+ <p>aliexpress严重SQL性能问题，一次性查询太多数据，造成数据库压力过大，或服务OOM，性能SQL为：</p>
003- </p>
003+ <p>SELECT id,customer_id,import_type,import_id,rule_code,import_val,convert_val,create_by,create_time,update_by,update_time,is_deleted FROM t_strategy_import_filter_aliexpress WHERE (rule_code = appoint_product AND import_id IN (29574,29572,29571,29569,29568,29563,29559,29556,29555,29553,29551,29548,29547,29546,29544,29535,29534,29533,29530,29527,29056,29043,28961,28960,28956,28955,28949,28944,28932,28930,28926,28924,28919,28898,28847,28819,28814,28812,28811,28803,28802,28798,28796,28794,28680,28642,28634,28632,28631,28629,28628,28621,28620,28607,28606,28595,28594,28589,28588,28585,28584,28577,28576,28573,28572,28515,28514,28513,28512,28509,28508,28499,28497,28396,28395,28390,28389,28381,28379,28378,28377,28375,28267,28266,28263,28262,28259,28258,28257,28256,28255,28254,28253,28252,28251,28250,28249,28248,28247,28246,28243,28242,28241,28240,28195,28194,28183,28182,28181,28180,28177,28123,28118,28117,28114,28109,28105,28094,28093,28053,28052,28051,28044,28033,27947,27877,27861,27859,27858,27856,27853,27848,27844,27841,27839,27807,27806,27804,27799,27798,27788,27777,27776,27772,27769,27764,27762,27761,27723,27721,27720,27718,27714,27712,27591,27588,27587,27586,27585,27584,27583,27582,27580,27579,27564,27556,27551,27550,27549,27537,27536,27497,27490,27485,27484,27480,27472,27471,27470,27460,27445,27408,27395,27386,27383,27378,27377,27376,27375,27374,27372,27238,27236,27231,27229,27228,27227,27191,27187,27186,27184,27179,27176,27174,27170,27168,27154,27148,27142,27141,27134,27108,27106,27103,27101,27098,27092,27086,27082,27081,27080,27006,26955,26918,26906,26893,26888,26855,26839,26837,26826,26822,26820,26817,26815,26814,26808,26790,26774,26766,26758,26756,26750,26747,26739,26717,26701,26660,26633,26618,26590,26580,26572,26559,26547,26517,26490,26482,26469,26468,26465,26461,26456,26447,26446,26424,26422,26418,26409,26408,26405,26400,26380,26377,26366,26349,26309,26296,26287));</p>
004- <p>
004+ <p><img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/17/10f7e87b1d3c450ba5f3ad093560ab0d/7b3faa67-c4bb-4731-9e5a-7acaf2afb1c0.png" title="from clipboard" alt="from clipboard" /></p>
005- aliexpress严重SQL性能问题，一次性查询太多数据，造成数据库压力过大，或服务OOM，性能SQL为：
005+ <p>解决方案：分页查询</p>
006- </p>
007- <p>
008- SELECT id,customer_id,import_type,import_id,rule_code,import_val,convert_val,create_by,create_time,update_by,update_time,is_deleted FROM t_strategy_import_filter_aliexpress WHERE (rule_code = appoint_product AND import_id IN (29574,29572,29571,29569,29568,29563,29559,29556,29555,29553,29551,29548,29547,29546,29544,29535,29534,29533,29530,29527,29056,29043,28961,28960,28956,28955,28949,28944,28932,28930,28926,28924,28919,28898,28847,28819,28814,28812,28811,28803,28802,28798,28796,28794,28680,28642,28634,28632,28631,28629,28628,28621,28620,28607,28606,28595,28594,28589,28588,28585,28584,28577,28576,28573,28572,28515,28514,28513,28512,28509,28508,28499,28497,28396,28395,28390,28389,28381,28379,28378,28377,28375,28267,28266,28263,28262,28259,28258,28257,28256,28255,28254,28253,28252,28251,28250,28249,28248,28247,28246,28243,28242,28241,28240,28195,28194,28183,28182,28181,28180,28177,28123,28118,28117,28114,28109,28105,28094,28093,28053,28052,28051,28044,28033,27947,27877,27861,27859,27858,27856,27853,27848,27844,27841,27839,27807,27806,27804,27799,27798,27788,27777,27776,27772,27769,27764,27762,27761,27723,27721,27720,27718,27714,27712,27591,27588,27587,27586,27585,27584,27583,27582,27580,27579,27564,27556,27551,27550,27549,27537,27536,27497,27490,27485,27484,27480,27472,27471,27470,27460,27445,27408,27395,27386,27383,27378,27377,27376,27375,27374,27372,27238,27236,27231,27229,27228,27227,27191,27187,27186,27184,27179,27176,27174,27170,27168,27154,27148,27142,27141,27134,27108,27106,27103,27101,27098,27092,27086,27082,27081,27080,27006,26955,26918,26906,26893,26888,26855,26839,26837,26826,26822,26820,26817,26815,26814,26808,26790,26774,26766,26758,26756,26750,26747,26739,26717,26701,26660,26633,26618,26590,26580,26572,26559,26547,26517,26490,26482,26469,26468,26465,26461,26456,26447,26446,26424,26422,26418,26409,26408,26405,26400,26380,26377,26366,26349,26309,26296,26287));
009- </p>
010- <p>
011- <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/17/10f7e87b1d3c450ba5f3ad093560ab0d/7b3faa67-c4bb-4731-9e5a-7acaf2afb1c0.png" title="from clipboard" alt="from clipboard" />
012- </p>
013- <p>
014- 解决方案：分页查询
015- </p>

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
修改了 关闭日期，旧值为 ""，新值为 "2025-10-20 14:32:50"。