BUG #59874 技术研发中心-慢SQL审批提交工单 - 技术中心-需求池

重现步骤

反馈人：王凯
数据库：zhcxkj_center_strategy_comprehensive
查询时间：113.781
执行次数: 1401
扫描行数：15101100
发送行数：156.372
指纹SQL: SELECT id , sku FROM ? WHERE ( sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND status IN ( ? , ? ) AND customer_id = ? AND is_deleted = ? ) ORDER BY type ASC , sku ASC ;
真实SQL：SELECT id,sku FROM t_strategy_pool_publish_fruugo WHERE (sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764) AND status IN (-1,0) AND customer_id = 0 AND is_deleted = 0) ORDER BY type ASC,sku ASC;
王凯,人工修改过
AISQL修改建议：SELECT id, sku
FROM t_strategy_pool_publish_fruugo
WHERE sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764)
AND status IN (-1, 0)
AND customer_id = 0
AND is_deleted = 0
ORDER BY type ASC, sku ASC;
explain表：

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t_strategy_pool_publish_fruugo	None	ALL	idx_status_source_id_sku,idx_status_customer_id	None	None	None	16746692	0.26	Using where; Using filesort

额外建议：
索引建议：避免使用外部排序，无法走索引

历史记录

2025-10-13 09:12:12, 由 陈莉珍 创建。
2025-10-15 15:03:59, 由 蔡俊伟 解决，方案为 性能问题 。
修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2025-10-15 15:03:43"。
修改了 指派给 ，旧值为 "caijunwei"，新值为 "chenlizhen"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "caijunwei"。

已解决
2025-10-15 18:10:01, 由 陈莉珍 编辑。
修改了 所属模块 ，旧值为 "0"，新值为 "1927"。
修改了 业务部门 ，旧值为 "0"，新值为 "2"。
修改了 开发责任人，旧值为 ""，新值为 "caijunwei"。
修改了 测试责任人，旧值为 ""，新值为 "caijunwei"。
修改了 解决时效 ，旧值为 "0"，新值为 "53.86"。
修改了 重现步骤 ，区别为：
001- ~~反馈人：王凯~~
001+ 反馈人：王凯数据库：zhcxkj_center_strategy_comprehensive 查询时间：113.781 执行次数: 1401 扫描行数：15101100 发送行数：156.372 指纹SQL: SELECT id , sku FROM ? WHERE ( sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND status IN ( ? , ? ) AND customer_id = ? AND is_deleted = ? ) ORDER BY type ASC , sku ASC ; 真实SQL：SELECT id,sku FROM t_strategy_pool_publish_fruugo WHERE (sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764) AND status IN (-1,0) AND customer_id = 0 AND is_deleted = 0) ORDER BY type ASC,sku ASC; 王凯,人工修改过 AISQL修改建议：SELECT id, sku FROM t_strategy_pool_publish_fruugo WHERE sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764) AND status IN (-1, 0) AND customer_id = 0 AND is_deleted = 0 ORDER BY type ASC, sku ASC; explain表：id
002- ~~数据库：zhcxkj_center_strategy_comprehensive~~
002+ select_type
003- ~~查询时间：113.781~~
003+ table
004- ~~执行次数: 1401~~
004+ partitions
005- ~~扫描行数：15101100~~
005+ type
006- ~~发送行数：156.372~~
006+ possible_keys
007- 指纹SQL: SELECT id , sku FROM ? WHERE ( sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND status IN ( ? , ? ) AND customer_id = ? AND is_deleted = ? ) ORDER BY type ASC , sku ASC ;
007+ key
008- 真实SQL：SELECT id,sku FROM t_strategy_pool_publish_fruugo WHERE (sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764) AND status IN (-1,0) AND customer_id = 0 AND is_deleted = 0) ORDER BY type ASC,sku ASC;
008+ key_len
009- ~~王凯,人工修改过~~
009+ ref
010- ~~AISQL修改建议：SELECT id, sku~~
010+ rows
011- ~~FROM t_strategy_pool_publish_fruugo~~
011+ filtered
012- WHERE sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764)
012+ Extra
013- ~~AND status IN (-1, 0)~~
013+ 1
014- ~~AND customer_id = 0~~
014+ SIMPLE
015- ~~AND is_deleted = 0~~
015+ t_strategy_pool_publish_fruugo
016- ~~ORDER BY type ASC, sku ASC;~~
016+ None
017- ~~explain表：~~
017+ ALL
018-
018+ idx_status_source_id_sku,idx_status_customer_id
019-
019+ None
020-
020+ None
021-
021+ None
022-
022+ 16746692
023-
023+ 0.26
024-
024+ Using where; Using filesort
025-
025+
026-
026+ 额外建议：索引建议：避免使用外部排序，无法走索引
027-
028- id
029-
030-
031- ~~select_type~~
032-
033-
034- ~~table~~
035-
036-
037- ~~partitions~~
038-
039-
040- ~~type~~
041-
042-
043- ~~possible_keys~~
044-
045-
046- ~~key~~
047-
048-
049- ~~key_len~~
050-
051-
052- ~~ref~~
053-
054-
055- ~~rows~~
056-
057-
058- ~~filtered~~
059-
060-
061- ~~Extra~~
062-
063-
064-
065-
066-
067-
068- 1
069-
070-
071- ~~SIMPLE~~
072-
073-
074- ~~t_strategy_pool_publish_fruugo~~
075-
076-
077- ~~None~~
078-
079-
080- ~~ALL~~
081-
082-
083- ~~idx_status_source_id_sku,idx_status_customer_id~~
084-
085-
086- ~~None~~
087-
088-
089- ~~None~~
090-
091-
092- ~~None~~
093-
094-
095- ~~16746692~~
096-
097-
098- ~~0.26~~
099-
100-
101- ~~Using where; Using filesort~~
102-
103-
104-
105-
106-
107- ~~额外建议：~~
108- ~~索引建议：避免使用外部排序，无法走索引~~
109-
110-

001- ~~反馈人：王凯<br />~~
001+ 反馈人：王凯<br /> 数据库：zhcxkj_center_strategy_comprehensive<br /> 查询时间：113.781<br /> 执行次数: 1401<br /> 扫描行数：15101100<br /> 发送行数：156.372<br /> 指纹SQL: SELECT id , sku FROM ? WHERE ( sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND status IN ( ? , ? ) AND customer_id = ? AND is_deleted = ? ) ORDER BY type ASC , sku ASC ;<br /> 真实SQL：SELECT id,sku FROM t_strategy_pool_publish_fruugo WHERE (sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764) AND status IN (-1,0) AND customer_id = 0 AND is_deleted = 0) ORDER BY type ASC,sku ASC;<br /> 王凯,人工修改过<br /> AISQL修改建议：SELECT id, sku<br /> FROM t_strategy_pool_publish_fruugo<br /> WHERE sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764)<br /> AND status IN (-1, 0)<br /> AND customer_id = 0<br /> AND is_deleted = 0<br /> ORDER BY type ASC, sku ASC;<br /> explain表：<br /><br /><br /><br /><br /><br /><br /><table><tbody><tr><th>id</th>
002- ~~数据库：zhcxkj_center_strategy_comprehensive<br />~~
002+ <th>select_type</th>
003- ~~查询时间：113.781<br />~~
003+ <th>table</th>
004- ~~执行次数: 1401<br />~~
004+ <th>partitions</th>
005- ~~扫描行数：15101100<br />~~
005+ <th>type</th>
006- ~~发送行数：156.372<br />~~
006+ <th>possible_keys</th>
007- 指纹SQL: SELECT id , sku FROM ? WHERE ( sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND status IN ( ? , ? ) AND customer_id = ? AND is_deleted = ? ) ORDER BY type ASC , sku ASC ;<br />
007+ <th>key</th>
008- 真实SQL：SELECT id,sku FROM t_strategy_pool_publish_fruugo WHERE (sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764) AND status IN (-1,0) AND customer_id = 0 AND is_deleted = 0) ORDER BY type ASC,sku ASC;<br />
008+ <th>key_len</th>
009- ~~王凯,人工修改过<br />~~
009+ <th>ref</th>
010- ~~AISQL修改建议：SELECT id, sku<br />~~
010+ <th>rows</th>
011- ~~FROM t_strategy_pool_publish_fruugo<br />~~
011+ <th>filtered</th>
012- WHERE sku IN (17495641,17046567,15564608,11479328,14984147,13450089,21181582,11866562,13659002,4782560,16147721,10554978,2963484,19906322,20307292,14007777,11063227,12264894,16158085,16149857,10910718,11329473,14345266,14621118,12317562,4678745,14369172,15215510,15762615,8027201,13462216,17218327,16225244,14607432,19389953,6124964,11830777,4361928,11384184,9877000,12590627,20708500,12089566,13104562,12199183,5965201,14595173,13733139,7779192,14348598,12926494,8883928,9253728,12614438,7305648,9682492,14931019,11198787,7708145,12314933,13674785,13916059,7387290,3969735,10707852,10729586,14610423,13672878,14180446,12223108,15381475,14656031,14998599,12910415,14350195,10504661,17981013,13637307,13331905,11302954,15500233,18098913,15255649,13340331,14970630,14843220,2984062,20128533,11389259,13762942,12094958,16044725,20436265,18773053,18969034,15683077,20025960,8403030,16544517,11702764)<br />
012+ <th>Extra</th>
013- ~~AND status IN (-1, 0)<br />~~
013+ </tr></tbody><tbody><tr><td>1</td>
014- ~~AND customer_id = 0<br />~~
014+ <td>SIMPLE</td>
015- ~~AND is_deleted = 0<br />~~
015+ <td>t_strategy_pool_publish_fruugo</td>
016- ~~ORDER BY type ASC, sku ASC;<br />~~
016+ <td>None</td>
017- ~~explain表：<br />~~
017+ <td>ALL</td>
018- ~~<br />~~
018+ <td>idx_status_source_id_sku,idx_status_customer_id</td>
019- ~~<br />~~
019+ <td>None</td>
020- ~~<br />~~
020+ <td>None</td>
021- ~~<br />~~
021+ <td>None</td>
022- ~~<br />~~
022+ <td>16746692</td>
023- ~~<br />~~
023+ <td>0.26</td>
024- ~~<table>~~
024+ <td>Using where; Using filesort</td>
025- ~~<tbody>~~
025+ </tr></tbody></table><br />
026- ~~<tr>~~
026+ 额外建议：<br /> 索引建议：避免使用外部排序，无法走索引<br /><br /><br />
027- ~~<th>~~
028- id
029- ~~</th>~~
030- ~~<th>~~
031- ~~select_type~~
032- ~~</th>~~
033- ~~<th>~~
034- ~~table~~
035- ~~</th>~~
036- ~~<th>~~
037- ~~partitions~~
038- ~~</th>~~
039- ~~<th>~~
040- ~~type~~
041- ~~</th>~~
042- ~~<th>~~
043- ~~possible_keys~~
044- ~~</th>~~
045- ~~<th>~~
046- ~~key~~
047- ~~</th>~~
048- ~~<th>~~
049- ~~key_len~~
050- ~~</th>~~
051- ~~<th>~~
052- ~~ref~~
053- ~~</th>~~
054- ~~<th>~~
055- ~~rows~~
056- ~~</th>~~
057- ~~<th>~~
058- ~~filtered~~
059- ~~</th>~~
060- ~~<th>~~
061- ~~Extra~~
062- ~~</th>~~
063- ~~</tr>~~
064- ~~</tbody>~~
065- ~~<tbody>~~
066- ~~<tr>~~
067- ~~<td>~~
068- 1
069- ~~</td>~~
070- ~~<td>~~
071- ~~SIMPLE~~
072- ~~</td>~~
073- ~~<td>~~
074- ~~t_strategy_pool_publish_fruugo~~
075- ~~</td>~~
076- ~~<td>~~
077- ~~None~~
078- ~~</td>~~
079- ~~<td>~~
080- ~~ALL~~
081- ~~</td>~~
082- ~~<td>~~
083- ~~idx_status_source_id_sku,idx_status_customer_id~~
084- ~~</td>~~
085- ~~<td>~~
086- ~~None~~
087- ~~</td>~~
088- ~~<td>~~
089- ~~None~~
090- ~~</td>~~
091- ~~<td>~~
092- ~~None~~
093- ~~</td>~~
094- ~~<td>~~
095- ~~16746692~~
096- ~~</td>~~
097- ~~<td>~~
098- ~~0.26~~
099- ~~</td>~~
100- ~~<td>~~
101- ~~Using where; Using filesort~~
102- ~~</td>~~
103- ~~</tr>~~
104- ~~</tbody>~~
105- ~~</table>~~
106- ~~<br />~~
107- ~~额外建议：<br />~~
108- ~~索引建议：避免使用外部排序，无法走索引<br />~~
109- ~~<br />~~
110- ~~<br />~~
2025-10-15 18:10:06, 由 陈莉珍 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
修改了 关闭日期，旧值为 ""，新值为 "2025-10-15 18:10:06"。

基本信息
迭代/需求/任务

所属项目	技术中心-需求池
所属模块	多平台 Fruugo
所属计划
所属迭代
Bug类型
严重程度	一般
优先级	P1
Bug状态	已关闭
业务部门	总经办
影响功能
开发责任人	蔡俊伟
测试责任人	蔡俊伟
解决时效	53.86
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2025-10-15 18:10:06
截止日期	0000-00-00
上线时间	2025-10-15 15:03:43
上线时效	53.86
操作系统
浏览器
关键词
抄送给

所属迭代
相关需求
相关任务

Bug的一生
其他相关

由谁创建	陈莉珍于 2025-10-13 09:12:12
影响环境	生产环境-业务反馈
由谁解决	蔡俊伟于 2025-10-15 15:03:43
解决版本	主干
解决方案	性能问题
由谁关闭	陈莉珍于 2025-10-15 18:10:06
最后修改	陈莉珍于 2025-10-15 18:10:06

相关Bug