重现步骤
反馈人 王凯
数据库：zhcxkj_center_order
查询时间：22.3047
执行次数: 245
扫描行数：74897.1
发送行数：1613.13
指纹SQL: select msku , purchase_date_day , COUNT ( order_item_id ) order_quantity FROM ? WHERE purchase_date_day >= ? AND purchase_date_day <= ? AND order_status IN ( ? , ? , ? , ? ) and source_id = ? and msku in ( '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
真实SQL：select msku,purchase_date_day,COUNT(order_item_id) order_quantity FROM t_amazon_sales_5 WHERE purchase_date_day >= 20250514 AND purchase_date_day <= 20250811 AND order_status IN (1, 2, 3, 4) and source_id = 6156 and msku in ( '18LCV045A413PYXV' , 'amzn.gr.W1260F19UW5N-HUCuk_UnpSAvB6aO-LN' , 'TW18G2IHI10R09B8ZI2Q3' , '7O44Z38I1132261A1X12' , 'KSU8SBKN06T39W7B2713IWGMX' , 'MUZOJ7HGP7594EM36413MR' , 'KH0811Z3355VECD9G' , 'amzn.gr.30159P161EO-5L_cBt-vfia3LS9Ab-VG' , 'ON9XHW0538X1T249XSMS11E' , 'GP9V3805GG9RHOP9V5D0714E' , 'MJRHBD703QYTLEI1631IZ2QD' , '726XW40BNCGTG14TM' , 'M0145DF148' , '3421593FMS' , 'ZI13KTK59L6835A6ENJ' , 'C14R11F36ZWZ' , '2411381CNXGA' , '52YY158R08M7DY0C5AFY' , 'Z820H211VEX40QS0B5F' , '1221109EJZ1I' , 'RFZG9Y6UX49SAH934011ITW9' , 'HUZD55LV03P0901GWL4DDEQ9' , '9E3Z1534P14VSD' , '454UPY5D13M4J46D43' , '1P02DAYV17WS14OXSC0NH8' , 'B26W2M206593J9814ZNKLTAC9' , '0SRFG1341940SYMP' , 'Y5SSB7YS4652G2YOE11W7J' , '4U382R46181JQVF' , 'NFBZ1K48851134M2IOH' , 'IDCB26OTSZ903D0X14F6N7CME' , 'WUQ16I10X0163R37GHO5' , '3UY16F38AX01IK2FRAGX' , 'amzn.gr.0957C4V16PY3Q116RKPED-lfVcc9K-LN' , 'CPK11ERF34186J6' , '626Y8W3D435F10OWS4T1' , 'KH5U11KWVG35ND9061A2OUWB' , 'amzn.gr.01DN58311ZC-k09sEjevXJ_wfme9o-VG' , 'J05C9LHIWES1135CXGGR' , '1448H3M30F9QQQG' , 'WR607W250P14SYQV3EGB' , 'BFH616SOS59160KR7CG54VRUP' , 'P4C09I02C2SD047P3MHJ0' , 'O1316719V9' , 'amzn.gr.3090185-6156-100356026-05eE0t-LN' , 'FUR2HNBZX143811NB32XT' , 'N331WR3ED14KR600I8JGT4ZQ' , '1QL18NS9SI357714YXG1Z' , '42511J19GCK' , 'PJON0423Q1557' , '1294K35E8Y6ZEUXD38H0DNE7G' , '138116QS1OK6' , 'TO11ZR4372PB94' , 'V5401ST16IW1' , 'ZV1CE1107HCH8G38U3MOOK' , 'FW55U1612XB4' , 'N020V214950RA6Y14SVDXM' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-6RUATJ-LN' , '2926WVXYU162L' , '107294GWFI' , 'VBP7211OQ3506RN57WIBQR' , 'amzn.gr.9Q00AZ8I2D40HA1201L4Q4-V_2tm3-LN' , 'J12TQTH2M097Y9T150YIRA' , 'LL1374QI1K5VBB536MF6H5I' , 'amzn.gr.1002413YCNX-kHA7rqq4ASTCP3Ea0-VG' , 'amzn.gr.Q0NSAZ468U0559Y111VX-JQwPdkV4-LN' , '9PAM1438SIW313Q7L4HE' , 'amzn.gr.Q540113V57BGUL5-fZ5qWNtMko4qH-AC' , '6TA35128D11H80J' , 'TA75439HP0NL211GSP' , 'W8JX7PHVF3414766OD' , 'IH29V8S8X1405PW11Q0302BQ' , 'amzn.gr.468OH49LQ411LV-EKWG0BtMLv3jA2-LN' , 'B4KCJ012G13V11YL1ATWFE49' , '814OES03TSELS9CO109ESG0' , '1002413YCNX' , '17330H1371O8R' , '04GA0714W4' , 'VQA52M506X67181EN' , 'PR01062R3502MWCHA' , '381OLX1541DZY' , 'UJWPA26H40BPX25VX0213RM' , '18PXTFJ43NXGG138ZITA' , '709OYS07301P0GNQ' , '16CG0252N3LK31386DZLP' , 'KN3EVGRZ2913359SYE' , 'JMCBK983751X43U5JW8G14T6' , 'L3832WISCQM0511EOHBZZM' , 'amzn.gr.J43735Q183A-xy1KpU5waJL2rOrMo-VG' , 'I4092FOT1304676KW' , 'MBN1363A0L005Z37LN0Z5' , 'A59K351142' , '1051F10313K5H9BUYW8' , 'MUJX8QJPJ10UAGZ8B58406KN' , '13M15YSF5E2C38ZKTC1M' , 'amzn.gr.4U382R46181JQVF-b5w5c0BN6X2_1-VG' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-IViHnh-LN' ,
##王凯,人工修改过##
AISQL修改建议：in 数量过多导致索引失效，拆分业务，in数量控制到100个以内，低并发场景可考虑临时表join方式，但该方式io消耗较高，高并发容易io阻塞
explain表：
额外建议：
索引建议：

历史记录  
  1. 2025-08-18 11:01:05, 由 李乐同 创建。
  2. 2025-08-18 15:45:28, 由 关依林 指派给 宋宁。
    修改了 指派给，旧值为 "guanyilin"，新值为 "songning"。
  3. 2025-08-18 17:21:57, 由 宋宁 指派给 关依林。
    修改了 指派给，旧值为 "songning"，新值为 "guanyilin"。
    这个目前in个数是100，随着销量数据增长，之前设计的方案需要调整
  4. 2025-08-18 18:11:08, 由 关依林 指派给 王凯。
    修改了 指派给，旧值为 "guanyilin"，新值为 "wangkai"。
    并非IN数量过多导致索引失效问题，目前IN的数量为100，销量数据增长的原因导致，销量合计的影响非常大，影响面很广，要专项优化调整
  5. 2025-08-18 18:56:22, 由 王凯 指派给 李乐同。
    修改了 指派给，旧值为 "wangkai"，新值为 "liletong"。
    帮安排下转需求进行优化
  6. 2025-08-22 14:49:34, 由 李乐同 指派给 陈江华。
    修改了 指派给，旧值为 "liletong"，新值为 "chenjianghua"。
    安排转需求处理
  7. 2025-09-02 08:57:32, 由 陈江华 指派给 关依林。
    修改了 指派给，旧值为 "chenjianghua"，新值为 "guanyilin"。
  8. 2025-09-02 09:56:13, 由 关依林 编辑。
    修改了 所属模块，旧值为 "0"，新值为 "1842"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "closed"。
    修改了 业务部门，旧值为 "0"，新值为 "2"。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 指派给 ，旧值为 "guanyilin"，新值为 "closed"。
    修改了 解决者 ，旧值为 ""，新值为 "guanyilin"。
    修改了 解决日期，旧值为 "0000-00-00 00:00:00"，新值为 "2025-09-02 09:56:13"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决方案，旧值为 ""，新值为 "feibug"。
    修改了 由谁关闭，旧值为 ""，新值为 "guanyilin"。
    修改了 关闭日期，旧值为 "0000-00-00 00:00:00"，新值为 "2025-09-02 09:56:13"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 重现步骤，区别为：
    001- 反馈人 王凯
    001+ 反馈人 王凯 数据库：zhcxkj_center_order 查询时间：22.3047 执行次数: 245 扫描行数：74897.1 发送行数：1613.13 指纹SQL: select msku , purchase_date_day , COUNT ( order_item_id ) order_quantity FROM ? WHERE purchase_date_day &gt;= ? AND purchase_date_day &lt;= ? AND order_status IN ( ? , ? , ? , ? ) and source_id = ? and msku in ( '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , 真实SQL：select msku,purchase_date_day,COUNT(order_item_id) order_quantity FROM t_amazon_sales_5 WHERE purchase_date_day &gt;= 20250514 AND purchase_date_day &lt;= 20250811 AND order_status IN (1, 2, 3, 4) and source_id = 6156 and msku in ( '18LCV045A413PYXV' , 'amzn.gr.W1260F19UW5N-HUCuk_UnpSAvB6aO-LN' , 'TW18G2IHI10R09B8ZI2Q3' , '7O44Z38I1132261A1X12' , 'KSU8SBKN06T39W7B2713IWGMX' , 'MUZOJ7HGP7594EM36413MR' , 'KH0811Z3355VECD9G' , 'amzn.gr.30159P161EO-5L_cBt-vfia3LS9Ab-VG' , 'ON9XHW0538X1T249XSMS11E' , 'GP9V3805GG9RHOP9V5D0714E' , 'MJRHBD703QYTLEI1631IZ2QD' , '726XW40BNCGTG14TM' , 'M0145DF148' , '3421593FMS' , 'ZI13KTK59L6835A6ENJ' , 'C14R11F36ZWZ' , '2411381CNXGA' , '52YY158R08M7DY0C5AFY' , 'Z820H211VEX40QS0B5F' , '1221109EJZ1I' , 'RFZG9Y6UX49SAH934011ITW9' , 'HUZD55LV03P0901GWL4DDEQ9' , '9E3Z1534P14VSD' , '454UPY5D13M4J46D43' , '1P02DAYV17WS14OXSC0NH8' , 'B26W2M206593J9814ZNKLTAC9' , '0SRFG1341940SYMP' , 'Y5SSB7YS4652G2YOE11W7J' , '4U382R46181JQVF' , 'NFBZ1K48851134M2IOH' , 'IDCB26OTSZ903D0X14F6N7CME' , 'WUQ16I10X0163R37GHO5' , '3UY16F38AX01IK2FRAGX' , 'amzn.gr.0957C4V16PY3Q116RKPED-lfVcc9K-LN' , 'CPK11ERF34186J6' , '626Y8W3D435F10OWS4T1' , 'KH5U11KWVG35ND9061A2OUWB' , 'amzn.gr.01DN58311ZC-k09sEjevXJ_wfme9o-VG' , 'J05C9LHIWES1135CXGGR' , '1448H3M30F9QQQG' , 'WR607W250P14SYQV3EGB' , 'BFH616SOS59160KR7CG54VRUP' , 'P4C09I02C2SD047P3MHJ0' , 'O1316719V9' , 'amzn.gr.3090185-6156-100356026-05eE0t-LN' , 'FUR2HNBZX143811NB32XT' , 'N331WR3ED14KR600I8JGT4ZQ' , '1QL18NS9SI357714YXG1Z' , '42511J19GCK' , 'PJON0423Q1557' , '1294K35E8Y6ZEUXD38H0DNE7G' , '138116QS1OK6' , 'TO11ZR4372PB94' , 'V5401ST16IW1' , 'ZV1CE1107HCH8G38U3MOOK' , 'FW55U1612XB4' , 'N020V214950RA6Y14SVDXM' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-6RUATJ-LN' , '2926WVXYU162L' , '107294GWFI' , 'VBP7211OQ3506RN57WIBQR' , 'amzn.gr.9Q00AZ8I2D40HA1201L4Q4-V_2tm3-LN' , 'J12TQTH2M097Y9T150YIRA' , 'LL1374QI1K5VBB536MF6H5I' , 'amzn.gr.1002413YCNX-kHA7rqq4ASTCP3Ea0-VG' , 'amzn.gr.Q0NSAZ468U0559Y111VX-JQwPdkV4-LN' , '9PAM1438SIW313Q7L4HE' , 'amzn.gr.Q540113V57BGUL5-fZ5qWNtMko4qH-AC' , '6TA35128D11H80J' , 'TA75439HP0NL211GSP' , 'W8JX7PHVF3414766OD' , 'IH29V8S8X1405PW11Q0302BQ' , 'amzn.gr.468OH49LQ411LV-EKWG0BtMLv3jA2-LN' , 'B4KCJ012G13V11YL1ATWFE49' , '814OES03TSELS9CO109ESG0' , '1002413YCNX' , '17330H1371O8R' , '04GA0714W4' , 'VQA52M506X67181EN' , 'PR01062R3502MWCHA' , '381OLX1541DZY' , 'UJWPA26H40BPX25VX0213RM' , '18PXTFJ43NXGG138ZITA' , '709OYS07301P0GNQ' , '16CG0252N3LK31386DZLP' , 'KN3EVGRZ2913359SYE' , 'JMCBK983751X43U5JW8G14T6' , 'L3832WISCQM0511EOHBZZM' , 'amzn.gr.J43735Q183A-xy1KpU5waJL2rOrMo-VG' , 'I4092FOT1304676KW' , 'MBN1363A0L005Z37LN0Z5' , 'A59K351142' , '1051F10313K5H9BUYW8' , 'MUJX8QJPJ10UAGZ8B58406KN' , '13M15YSF5E2C38ZKTC1M' , 'amzn.gr.4U382R46181JQVF-b5w5c0BN6X2_1-VG' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-IViHnh-LN' , ##王凯,人工修改过## AISQL修改建议：in 数量过多导致索引失效，拆分业务，in数量控制到100个以内，低并发场景可考虑临时表join方式，但该方式io消耗较高，高并发容易io阻塞 explain表： 额外建议： 索引建议：
    002- 数据库：zhcxkj_center_order
    003- 查询时间：22.3047
    004- 执行次数: 245
    005- 扫描行数：74897.1
    006- 发送行数：1613.13
    007- 指纹SQL: select msku , purchase_date_day , COUNT ( order_item_id ) order_quantity FROM ? WHERE purchase_date_day &gt;= ? AND purchase_date_day &lt;= ? AND order_status IN ( ? , ? , ? , ? ) and source_id = ? and msku in ( '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    008- 真实SQL：select msku,purchase_date_day,COUNT(order_item_id) order_quantity FROM t_amazon_sales_5 WHERE purchase_date_day &gt;= 20250514 AND purchase_date_day &lt;= 20250811 AND order_status IN (1, 2, 3, 4) and source_id = 6156 and msku in ( '18LCV045A413PYXV' , 'amzn.gr.W1260F19UW5N-HUCuk_UnpSAvB6aO-LN' , 'TW18G2IHI10R09B8ZI2Q3' , '7O44Z38I1132261A1X12' , 'KSU8SBKN06T39W7B2713IWGMX' , 'MUZOJ7HGP7594EM36413MR' , 'KH0811Z3355VECD9G' , 'amzn.gr.30159P161EO-5L_cBt-vfia3LS9Ab-VG' , 'ON9XHW0538X1T249XSMS11E' , 'GP9V3805GG9RHOP9V5D0714E' , 'MJRHBD703QYTLEI1631IZ2QD' , '726XW40BNCGTG14TM' , 'M0145DF148' , '3421593FMS' , 'ZI13KTK59L6835A6ENJ' , 'C14R11F36ZWZ' , '2411381CNXGA' , '52YY158R08M7DY0C5AFY' , 'Z820H211VEX40QS0B5F' , '1221109EJZ1I' , 'RFZG9Y6UX49SAH934011ITW9' , 'HUZD55LV03P0901GWL4DDEQ9' , '9E3Z1534P14VSD' , '454UPY5D13M4J46D43' , '1P02DAYV17WS14OXSC0NH8' , 'B26W2M206593J9814ZNKLTAC9' , '0SRFG1341940SYMP' , 'Y5SSB7YS4652G2YOE11W7J' , '4U382R46181JQVF' , 'NFBZ1K48851134M2IOH' , 'IDCB26OTSZ903D0X14F6N7CME' , 'WUQ16I10X0163R37GHO5' , '3UY16F38AX01IK2FRAGX' , 'amzn.gr.0957C4V16PY3Q116RKPED-lfVcc9K-LN' , 'CPK11ERF34186J6' , '626Y8W3D435F10OWS4T1' , 'KH5U11KWVG35ND9061A2OUWB' , 'amzn.gr.01DN58311ZC-k09sEjevXJ_wfme9o-VG' , 'J05C9LHIWES1135CXGGR' , '1448H3M30F9QQQG' , 'WR607W250P14SYQV3EGB' , 'BFH616SOS59160KR7CG54VRUP' , 'P4C09I02C2SD047P3MHJ0' , 'O1316719V9' , 'amzn.gr.3090185-6156-100356026-05eE0t-LN' , 'FUR2HNBZX143811NB32XT' , 'N331WR3ED14KR600I8JGT4ZQ' , '1QL18NS9SI357714YXG1Z' , '42511J19GCK' , 'PJON0423Q1557' , '1294K35E8Y6ZEUXD38H0DNE7G' , '138116QS1OK6' , 'TO11ZR4372PB94' , 'V5401ST16IW1' , 'ZV1CE1107HCH8G38U3MOOK' , 'FW55U1612XB4' , 'N020V214950RA6Y14SVDXM' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-6RUATJ-LN' , '2926WVXYU162L' , '107294GWFI' , 'VBP7211OQ3506RN57WIBQR' , 'amzn.gr.9Q00AZ8I2D40HA1201L4Q4-V_2tm3-LN' , 'J12TQTH2M097Y9T150YIRA' , 'LL1374QI1K5VBB536MF6H5I' , 'amzn.gr.1002413YCNX-kHA7rqq4ASTCP3Ea0-VG' , 'amzn.gr.Q0NSAZ468U0559Y111VX-JQwPdkV4-LN' , '9PAM1438SIW313Q7L4HE' , 'amzn.gr.Q540113V57BGUL5-fZ5qWNtMko4qH-AC' , '6TA35128D11H80J' , 'TA75439HP0NL211GSP' , 'W8JX7PHVF3414766OD' , 'IH29V8S8X1405PW11Q0302BQ' , 'amzn.gr.468OH49LQ411LV-EKWG0BtMLv3jA2-LN' , 'B4KCJ012G13V11YL1ATWFE49' , '814OES03TSELS9CO109ESG0' , '1002413YCNX' , '17330H1371O8R' , '04GA0714W4' , 'VQA52M506X67181EN' , 'PR01062R3502MWCHA' , '381OLX1541DZY' , 'UJWPA26H40BPX25VX0213RM' , '18PXTFJ43NXGG138ZITA' , '709OYS07301P0GNQ' , '16CG0252N3LK31386DZLP' , 'KN3EVGRZ2913359SYE' , 'JMCBK983751X43U5JW8G14T6' , 'L3832WISCQM0511EOHBZZM' , 'amzn.gr.J43735Q183A-xy1KpU5waJL2rOrMo-VG' , 'I4092FOT1304676KW' , 'MBN1363A0L005Z37LN0Z5' , 'A59K351142' , '1051F10313K5H9BUYW8' , 'MUJX8QJPJ10UAGZ8B58406KN' , '13M15YSF5E2C38ZKTC1M' , 'amzn.gr.4U382R46181JQVF-b5w5c0BN6X2_1-VG' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-IViHnh-LN' ,
    009- ##王凯,人工修改过##
    010- AISQL修改建议：in 数量过多导致索引失效，拆分业务，in数量控制到100个以内，低并发场景可考虑临时表join方式，但该方式io消耗较高，高并发容易io阻塞
    011- explain表：
    012- 额外建议：
    013- 索引建议：
    014-
    001- 反馈人 王凯<br />
    001+ 反馈人 王凯<br /> 数据库：zhcxkj_center_order<br /> 查询时间：22.3047<br /> 执行次数: 245<br /> 扫描行数：74897.1<br /> 发送行数：1613.13<br /> 指纹SQL: select msku , purchase_date_day , COUNT ( order_item_id ) order_quantity FROM ? WHERE purchase_date_day &gt;= ? AND purchase_date_day &lt;= ? AND order_status IN ( ? , ? , ? , ? ) and source_id = ? and msku in ( '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,<br /> 真实SQL：select msku,purchase_date_day,COUNT(order_item_id) order_quantity FROM t_amazon_sales_5 WHERE purchase_date_day &gt;= 20250514 AND purchase_date_day &lt;= 20250811 AND order_status IN (1, 2, 3, 4) and source_id = 6156 and msku in ( '18LCV045A413PYXV' , 'amzn.gr.W1260F19UW5N-HUCuk_UnpSAvB6aO-LN' , 'TW18G2IHI10R09B8ZI2Q3' , '7O44Z38I1132261A1X12' , 'KSU8SBKN06T39W7B2713IWGMX' , 'MUZOJ7HGP7594EM36413MR' , 'KH0811Z3355VECD9G' , 'amzn.gr.30159P161EO-5L_cBt-vfia3LS9Ab-VG' , 'ON9XHW0538X1T249XSMS11E' , 'GP9V3805GG9RHOP9V5D0714E' , 'MJRHBD703QYTLEI1631IZ2QD' , '726XW40BNCGTG14TM' , 'M0145DF148' , '3421593FMS' , 'ZI13KTK59L6835A6ENJ' , 'C14R11F36ZWZ' , '2411381CNXGA' , '52YY158R08M7DY0C5AFY' , 'Z820H211VEX40QS0B5F' , '1221109EJZ1I' , 'RFZG9Y6UX49SAH934011ITW9' , 'HUZD55LV03P0901GWL4DDEQ9' , '9E3Z1534P14VSD' , '454UPY5D13M4J46D43' , '1P02DAYV17WS14OXSC0NH8' , 'B26W2M206593J9814ZNKLTAC9' , '0SRFG1341940SYMP' , 'Y5SSB7YS4652G2YOE11W7J' , '4U382R46181JQVF' , 'NFBZ1K48851134M2IOH' , 'IDCB26OTSZ903D0X14F6N7CME' , 'WUQ16I10X0163R37GHO5' , '3UY16F38AX01IK2FRAGX' , 'amzn.gr.0957C4V16PY3Q116RKPED-lfVcc9K-LN' , 'CPK11ERF34186J6' , '626Y8W3D435F10OWS4T1' , 'KH5U11KWVG35ND9061A2OUWB' , 'amzn.gr.01DN58311ZC-k09sEjevXJ_wfme9o-VG' , 'J05C9LHIWES1135CXGGR' , '1448H3M30F9QQQG' , 'WR607W250P14SYQV3EGB' , 'BFH616SOS59160KR7CG54VRUP' , 'P4C09I02C2SD047P3MHJ0' , 'O1316719V9' , 'amzn.gr.3090185-6156-100356026-05eE0t-LN' , 'FUR2HNBZX143811NB32XT' , 'N331WR3ED14KR600I8JGT4ZQ' , '1QL18NS9SI357714YXG1Z' , '42511J19GCK' , 'PJON0423Q1557' , '1294K35E8Y6ZEUXD38H0DNE7G' , '138116QS1OK6' , 'TO11ZR4372PB94' , 'V5401ST16IW1' , 'ZV1CE1107HCH8G38U3MOOK' , 'FW55U1612XB4' , 'N020V214950RA6Y14SVDXM' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-6RUATJ-LN' , '2926WVXYU162L' , '107294GWFI' , 'VBP7211OQ3506RN57WIBQR' , 'amzn.gr.9Q00AZ8I2D40HA1201L4Q4-V_2tm3-LN' , 'J12TQTH2M097Y9T150YIRA' , 'LL1374QI1K5VBB536MF6H5I' , 'amzn.gr.1002413YCNX-kHA7rqq4ASTCP3Ea0-VG' , 'amzn.gr.Q0NSAZ468U0559Y111VX-JQwPdkV4-LN' , '9PAM1438SIW313Q7L4HE' , 'amzn.gr.Q540113V57BGUL5-fZ5qWNtMko4qH-AC' , '6TA35128D11H80J' , 'TA75439HP0NL211GSP' , 'W8JX7PHVF3414766OD' , 'IH29V8S8X1405PW11Q0302BQ' , 'amzn.gr.468OH49LQ411LV-EKWG0BtMLv3jA2-LN' , 'B4KCJ012G13V11YL1ATWFE49' , '814OES03TSELS9CO109ESG0' , '1002413YCNX' , '17330H1371O8R' , '04GA0714W4' , 'VQA52M506X67181EN' , 'PR01062R3502MWCHA' , '381OLX1541DZY' , 'UJWPA26H40BPX25VX0213RM' , '18PXTFJ43NXGG138ZITA' , '709OYS07301P0GNQ' , '16CG0252N3LK31386DZLP' , 'KN3EVGRZ2913359SYE' , 'JMCBK983751X43U5JW8G14T6' , 'L3832WISCQM0511EOHBZZM' , 'amzn.gr.J43735Q183A-xy1KpU5waJL2rOrMo-VG' , 'I4092FOT1304676KW' , 'MBN1363A0L005Z37LN0Z5' , 'A59K351142' , '1051F10313K5H9BUYW8' , 'MUJX8QJPJ10UAGZ8B58406KN' , '13M15YSF5E2C38ZKTC1M' , 'amzn.gr.4U382R46181JQVF-b5w5c0BN6X2_1-VG' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-IViHnh-LN' , <br /> ##王凯,人工修改过##<br /> AISQL修改建议：in 数量过多导致索引失效，拆分业务，in数量控制到100个以内，低并发场景可考虑临时表join方式，但该方式io消耗较高，高并发容易io阻塞<br /> explain表：<br /> 额外建议：<br /> 索引建议：<br /><br />
    002- 数据库：zhcxkj_center_order<br />
    003- 查询时间：22.3047<br />
    004- 执行次数: 245<br />
    005- 扫描行数：74897.1<br />
    006- 发送行数：1613.13<br />
    007- 指纹SQL: select msku , purchase_date_day , COUNT ( order_item_id ) order_quantity FROM ? WHERE purchase_date_day &gt;= ? AND purchase_date_day &lt;= ? AND order_status IN ( ? , ? , ? , ? ) and source_id = ? and msku in ( '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,<br />
    008- 真实SQL：select msku,purchase_date_day,COUNT(order_item_id) order_quantity FROM t_amazon_sales_5 WHERE purchase_date_day &gt;= 20250514 AND purchase_date_day &lt;= 20250811 AND order_status IN (1, 2, 3, 4) and source_id = 6156 and msku in ( '18LCV045A413PYXV' , 'amzn.gr.W1260F19UW5N-HUCuk_UnpSAvB6aO-LN' , 'TW18G2IHI10R09B8ZI2Q3' , '7O44Z38I1132261A1X12' , 'KSU8SBKN06T39W7B2713IWGMX' , 'MUZOJ7HGP7594EM36413MR' , 'KH0811Z3355VECD9G' , 'amzn.gr.30159P161EO-5L_cBt-vfia3LS9Ab-VG' , 'ON9XHW0538X1T249XSMS11E' , 'GP9V3805GG9RHOP9V5D0714E' , 'MJRHBD703QYTLEI1631IZ2QD' , '726XW40BNCGTG14TM' , 'M0145DF148' , '3421593FMS' , 'ZI13KTK59L6835A6ENJ' , 'C14R11F36ZWZ' , '2411381CNXGA' , '52YY158R08M7DY0C5AFY' , 'Z820H211VEX40QS0B5F' , '1221109EJZ1I' , 'RFZG9Y6UX49SAH934011ITW9' , 'HUZD55LV03P0901GWL4DDEQ9' , '9E3Z1534P14VSD' , '454UPY5D13M4J46D43' , '1P02DAYV17WS14OXSC0NH8' , 'B26W2M206593J9814ZNKLTAC9' , '0SRFG1341940SYMP' , 'Y5SSB7YS4652G2YOE11W7J' , '4U382R46181JQVF' , 'NFBZ1K48851134M2IOH' , 'IDCB26OTSZ903D0X14F6N7CME' , 'WUQ16I10X0163R37GHO5' , '3UY16F38AX01IK2FRAGX' , 'amzn.gr.0957C4V16PY3Q116RKPED-lfVcc9K-LN' , 'CPK11ERF34186J6' , '626Y8W3D435F10OWS4T1' , 'KH5U11KWVG35ND9061A2OUWB' , 'amzn.gr.01DN58311ZC-k09sEjevXJ_wfme9o-VG' , 'J05C9LHIWES1135CXGGR' , '1448H3M30F9QQQG' , 'WR607W250P14SYQV3EGB' , 'BFH616SOS59160KR7CG54VRUP' , 'P4C09I02C2SD047P3MHJ0' , 'O1316719V9' , 'amzn.gr.3090185-6156-100356026-05eE0t-LN' , 'FUR2HNBZX143811NB32XT' , 'N331WR3ED14KR600I8JGT4ZQ' , '1QL18NS9SI357714YXG1Z' , '42511J19GCK' , 'PJON0423Q1557' , '1294K35E8Y6ZEUXD38H0DNE7G' , '138116QS1OK6' , 'TO11ZR4372PB94' , 'V5401ST16IW1' , 'ZV1CE1107HCH8G38U3MOOK' , 'FW55U1612XB4' , 'N020V214950RA6Y14SVDXM' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-6RUATJ-LN' , '2926WVXYU162L' , '107294GWFI' , 'VBP7211OQ3506RN57WIBQR' , 'amzn.gr.9Q00AZ8I2D40HA1201L4Q4-V_2tm3-LN' , 'J12TQTH2M097Y9T150YIRA' , 'LL1374QI1K5VBB536MF6H5I' , 'amzn.gr.1002413YCNX-kHA7rqq4ASTCP3Ea0-VG' , 'amzn.gr.Q0NSAZ468U0559Y111VX-JQwPdkV4-LN' , '9PAM1438SIW313Q7L4HE' , 'amzn.gr.Q540113V57BGUL5-fZ5qWNtMko4qH-AC' , '6TA35128D11H80J' , 'TA75439HP0NL211GSP' , 'W8JX7PHVF3414766OD' , 'IH29V8S8X1405PW11Q0302BQ' , 'amzn.gr.468OH49LQ411LV-EKWG0BtMLv3jA2-LN' , 'B4KCJ012G13V11YL1ATWFE49' , '814OES03TSELS9CO109ESG0' , '1002413YCNX' , '17330H1371O8R' , '04GA0714W4' , 'VQA52M506X67181EN' , 'PR01062R3502MWCHA' , '381OLX1541DZY' , 'UJWPA26H40BPX25VX0213RM' , '18PXTFJ43NXGG138ZITA' , '709OYS07301P0GNQ' , '16CG0252N3LK31386DZLP' , 'KN3EVGRZ2913359SYE' , 'JMCBK983751X43U5JW8G14T6' , 'L3832WISCQM0511EOHBZZM' , 'amzn.gr.J43735Q183A-xy1KpU5waJL2rOrMo-VG' , 'I4092FOT1304676KW' , 'MBN1363A0L005Z37LN0Z5' , 'A59K351142' , '1051F10313K5H9BUYW8' , 'MUJX8QJPJ10UAGZ8B58406KN' , '13M15YSF5E2C38ZKTC1M' , 'amzn.gr.4U382R46181JQVF-b5w5c0BN6X2_1-VG' , 'amzn.gr.23J8TOKG2923Y5KP15MSO5-IViHnh-LN' , <br />
    009- ##王凯,人工修改过##<br />
    010- AISQL修改建议：in 数量过多导致索引失效，拆分业务，in数量控制到100个以内，低并发场景可考虑临时表join方式，但该方式io消耗较高，高并发容易io阻塞<br />
    011- explain表：<br />
    012- 额外建议：<br />
    013- 索引建议：<br />
    014- <br />
    非IN个数问题
  9. 2025-09-04 16:56:13, 由 陈莉珍 编辑。
    修改了 所属项目，旧值为 "51"，新值为 "52"。
    修改了 所属模块，旧值为 "1842"，新值为 "1955"。
    修改了 解决时效，旧值为 "0"，新值为 "262.92"。
所属项目 智能中心-需求池
所属模块 ERP系统（销售管理）   AMZ百货
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 关依林
测试责任人
解决时效 262.92
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-09-04 16:56:13
截止日期 0000-00-00
上线时间 0000-00-00 00:00:00
上线时效 -1
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 李乐同 于 2025-08-18 11:01:05
影响环境 生产环境-业务反馈
由谁解决 关依林 于 2025-09-02 09:56:13
解决版本 主干
解决方案 非BUG-纯属误判
由谁关闭 关依林 于 2025-09-02 09:56:13
最后修改 陈莉珍 于 2025-09-04 16:56:13
相关Bug