重现步骤

with tmp_table_zfp2olomv5 as ( select 13584 source_id, 'R2217TB7V1KG5718SD16' msku union select 13584 source_id, 'R48X66AX21511FKZ' msku union select 13584 source_id, 'R494EW9B426H20238T8E' msku union select 13584 source_id, 'R84H5919T18BR' msku union select 13584 source_id, 'R9Z099U248X1D4949VO85' msku union select 13584 source_id, 'RAG6N2134CN014L' msku union select 13584 source_id, 'RE9V37Q16YMM8141YF57IHR' msku union select 13584 source_id, 'RFRQK06K12356653LU4E' msku union select 13584 source_id, 'RFVHBZ156012AQPWXPG3' msku union select 13584 source_id, 'RH2TFD3RL2C392773R13ZZH' msku union select 13584 source_id, 'RL45G5T2VYI35TA12FRSCPS' msku union select 13584 source_id, 'RM1220752952JEOI' msku union select 13584 source_id, 'RP327811KMMO' msku union select 13584 source_id, 'RS115165812KPGXU' msku union select 13584 source_id, 'RS557809UE' msku union select 13584 source_id, 'RSI2542K1VJ11M' msku union select 13584 source_id, 'RUX14XFREW410834VA8' msku union select 13584 source_id, 'RUXJ0IJ5L1EN5532QSEP09CKG' msku union select 13584 source_id, 'RV14088M12TK' msku union select 13584 source_id, 'RV302510WDI' msku union select 13584 source_id, 'RW3709UG49NP7' msku union select 13584 source_id, 'RWR5531220DUG63M30NNMVHD' msku union select 13584 source_id, 'RYF6F91045L5H256H8' msku union select 13584 source_id, 'S01U6PP550YBOC4UOD21I' msku union select 13584 source_id, 'S094100JG10CEPN7BKFG9N8T' msku union select 13584 source_id, 'S09XSW7P2255QFF6' msku union select 13584 source_id, 'S1046Z6LH50EDI' msku union select 13584 source_id, 'S1270D36XM9' msku union select 13584 source_id, 'S1302O10G9WEL8' msku union select 13584 source_id, 'S14SC225BX2PU0US08SNK' msku union select 13584 source_id, 'S1BQY1430903XPXYT3ETNXIA' msku union select 13584 source_id, 'S1P204RK7X31R706IVW15WBOV' msku union select 13584 source_id, 'S436K4PHTI0IL8R05094YJYU' msku union select 13584 source_id, 'S447909YSUC' msku union select 13584 source_id, 'S58DL25KGURH209S4J911CJ' msku union select 13584 source_id, 'S5Q314D031810F' msku union select 13584 source_id, 'S78OV16BJ9MI46KT01P2LYB' msku union select 13584 source_id, 'S8AXBX2541DKU11IXZBN0I' msku union select 13584 source_id, 'S9520936731' msku union select 13584 source_id, 'SBU559G47BTXT12H' msku union select 13584 source_id, 'SD12GAP5810V75EXA' msku union select 13584 source_id, 'SE4UAC9RO834997SVT09Z' msku union select 13584 source_id, 'SEVOFFY8ZWR3MLU58FK1111TJ' msku union select 13584 source_id, 'SG10A64352W3XF' msku union select 13584 source_id, 'SGUP14G50032NRKMG5U' msku union select 13584 source_id, 'SIM1013G41P4DAOBB' msku union select 13584 source_id, 'SK6G8E2364XX10E' msku union select 13584 source_id, 'SLT10M9W9P12L41KCLTAH' msku union select 13584 source_id, 'SLU92FDD239HZLNGDG1503K9V' msku union select 13584 source_id, 'SOE10PF4NU9PBTUD304I00LSC' msku union select 13584 source_id, 'SOO09Z37HU441F56M4MQGG' msku union select 13584 source_id, 'SP84K1M612V30XJ209Z4' msku union select 13584 source_id, 'SU43842WAZKEOCJ5A209ZZ' msku union select 13584 source_id, 'SV031000T4LSB7Q' msku union select 13584 source_id, 'SV21FEM33LWD40RR09G4C8' msku union select 13584 source_id, 'SWA493909MX' msku union select 13584 source_id, 'SWRQ312083D15SV' msku union select 13584 source_id, 'SY1102PQR8C3EL454411JPW' msku union select 13584 source_id, 'SZ5U5D34YF100P40FH1N1R' msku union select 13584 source_id, 'T04489509UUR' msku union select 13584 source_id, 'T078T8Z206PB2811MGNHCALM7' msku union select 13584 source_id, 'T126063DLYD48LQNGB9TX8' msku union select 13584 source_id, 'T1M5IL710PF10K0114A947' msku union select 13584 source_id, 'T3281G2987D314Y67' msku union select 13584 source_id, 'T3536Q12LXLKP6OXA15OA5' msku union select 13584 source_id, 'T387ZH8E08ANK4G24205PEG' msku union select 13584 source_id, 'T38H2FY31HKP1653LZ' msku union select 13584 source_id, 'T41041KDH11RL' msku union select 13584 source_id, 'T50949P3548BL2V20' msku union select 13584 source_id, 'T51X26U369CJR166UU1QXM7A6' msku union select 13584 source_id, 'T835X429OEC105S' msku union select 13584 source_id, 'TCV8HY51419RSX13S' msku ) select a.source_id, a.msku, a.fulfillable_quantity from t_amazon_fba_virtual_inventory_record a inner join tmp_table_zfp2olomv5 b on a.source_id = b.source_id and a.msku = b.msku -- where a.protection_flag = 1;



建议优化：

drop temporary table if exists tblzfp;
create temporary table tblzfp as
with tmp_table_zfp2olomv5 as ( select 13584 source_id, 'R2217TB7V1KG5718SD16' msku union select 13584 source_id, 'R48X66AX21511FKZ' msku union select 13584 source_id, 'R494EW9B426H20238T8E' msku union select 13584 source_id, 'R84H5919T18BR' msku union select 13584 source_id, 'R9Z099U248X1D4949VO85' msku union select 13584 source_id, 'RAG6N2134CN014L' msku union select 13584 source_id, 'RE9V37Q16YMM8141YF57IHR' msku union select 13584 source_id, 'RFRQK06K12356653LU4E' msku union select 13584 source_id, 'RFVHBZ156012AQPWXPG3' msku union select 13584 source_id, 'RH2TFD3RL2C392773R13ZZH' msku union select 13584 source_id, 'RL45G5T2VYI35TA12FRSCPS' msku union select 13584 source_id, 'RM1220752952JEOI' msku union select 13584 source_id, 'RP327811KMMO' msku union select 13584 source_id, 'RS115165812KPGXU' msku union select 13584 source_id, 'RS557809UE' msku union select 13584 source_id, 'RSI2542K1VJ11M' msku union select 13584 source_id, 'RUX14XFREW410834VA8' msku union select 13584 source_id, 'RUXJ0IJ5L1EN5532QSEP09CKG' msku union select 13584 source_id, 'RV14088M12TK' msku union select 13584 source_id, 'RV302510WDI' msku union select 13584 source_id, 'RW3709UG49NP7' msku union select 13584 source_id, 'RWR5531220DUG63M30NNMVHD' msku union select 13584 source_id, 'RYF6F91045L5H256H8' msku union select 13584 source_id, 'S01U6PP550YBOC4UOD21I' msku union select 13584 source_id, 'S094100JG10CEPN7BKFG9N8T' msku union select 13584 source_id, 'S09XSW7P2255QFF6' msku union select 13584 source_id, 'S1046Z6LH50EDI' msku union select 13584 source_id, 'S1270D36XM9' msku union select 13584 source_id, 'S1302O10G9WEL8' msku union select 13584 source_id, 'S14SC225BX2PU0US08SNK' msku union select 13584 source_id, 'S1BQY1430903XPXYT3ETNXIA' msku union select 13584 source_id, 'S1P204RK7X31R706IVW15WBOV' msku union select 13584 source_id, 'S436K4PHTI0IL8R05094YJYU' msku union select 13584 source_id, 'S447909YSUC' msku union select 13584 source_id, 'S58DL25KGURH209S4J911CJ' msku union select 13584 source_id, 'S5Q314D031810F' msku union select 13584 source_id, 'S78OV16BJ9MI46KT01P2LYB' msku union select 13584 source_id, 'S8AXBX2541DKU11IXZBN0I' msku union select 13584 source_id, 'S9520936731' msku union select 13584 source_id, 'SBU559G47BTXT12H' msku union select 13584 source_id, 'SD12GAP5810V75EXA' msku union select 13584 source_id, 'SE4UAC9RO834997SVT09Z' msku union select 13584 source_id, 'SEVOFFY8ZWR3MLU58FK1111TJ' msku union select 13584 source_id, 'SG10A64352W3XF' msku union select 13584 source_id, 'SGUP14G50032NRKMG5U' msku union select 13584 source_id, 'SIM1013G41P4DAOBB' msku union select 13584 source_id, 'SK6G8E2364XX10E' msku union select 13584 source_id, 'SLT10M9W9P12L41KCLTAH' msku union select 13584 source_id, 'SLU92FDD239HZLNGDG1503K9V' msku union select 13584 source_id, 'SOE10PF4NU9PBTUD304I00LSC' msku union select 13584 source_id, 'SOO09Z37HU441F56M4MQGG' msku union select 13584 source_id, 'SP84K1M612V30XJ209Z4' msku union select 13584 source_id, 'SU43842WAZKEOCJ5A209ZZ' msku union select 13584 source_id, 'SV031000T4LSB7Q' msku union select 13584 source_id, 'SV21FEM33LWD40RR09G4C8' msku union select 13584 source_id, 'SWA493909MX' msku union select 13584 source_id, 'SWRQ312083D15SV' msku union select 13584 source_id, 'SY1102PQR8C3EL454411JPW' msku union select 13584 source_id, 'SZ5U5D34YF100P40FH1N1R' msku union select 13584 source_id, 'T04489509UUR' msku union select 13584 source_id, 'T078T8Z206PB2811MGNHCALM7' msku union select 13584 source_id, 'T126063DLYD48LQNGB9TX8' msku union select 13584 source_id, 'T1M5IL710PF10K0114A947' msku union select 13584 source_id, 'T3281G2987D314Y67' msku union select 13584 source_id, 'T3536Q12LXLKP6OXA15OA5' msku union select 13584 source_id, 'T387ZH8E08ANK4G24205PEG' msku union select 13584 source_id, 'T38H2FY31HKP1653LZ' msku union select 13584 source_id, 'T41041KDH11RL' msku union select 13584 source_id, 'T50949P3548BL2V20' msku union select 13584 source_id, 'T51X26U369CJR166UU1QXM7A6' msku union select 13584 source_id, 'T835X429OEC105S' msku union select 13584 source_id, 'TCV8HY51419RSX13S' msku )
select * from tmp_table_zfp2olomv5;
create index idx_msku_sourceid on tblzfp(msku,source_id);
select a.source_id, a.msku, a.fulfillable_quantity from t_amazon_fba_virtual_inventory_record a inner join tblzfp b on a.source_id = b.source_id and a.msku = b.msku ;


历史记录  
  1. 2024-08-27 09:02:19, 由 吴高发 创建。
  2. 2024-08-27 10:46:07, 由 李乐同 指派给 宋宁。
    修改了 指派给，旧值为 "liletong"，新值为 "songning"。
  3. 2024-08-27 10:58:14, 由 宋宁 指派给 吴高发。
    修改了 指派给，旧值为 "songning"，新值为 "wugaofa"。
    正在上传图片，请稍后...


    正在上传图片，请稍后...

    sql并不慢，并且是成功命中uk_source_msku索引，之所以某个时间段执行慢，是因为listing-amazon库经常被策略中台大批量拉数据导致cpu飙升，进行影响sql执行
  4. 2024-08-27 11:19:22, 由 吴高发 解决，方案为 服务器原因 。
    修改了 解决方案，旧值为 ""，新值为 "server"。
    修改了 解决日期，旧值为 ""，新值为 "2024-08-27 11:19:12"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "wugaofa"。
  5. 2024-08-27 11:19:38, 由 吴高发 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "wugaofa"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "wugaofa"。
    修改了 关闭日期，旧值为 ""，新值为 "2024-08-27 11:19:38"。
所属项目 技术中心-需求池
所属模块 系统运维   性能优化
所属计划
所属迭代
Bug类型 性能问题
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门
影响功能
开发责任人 吴高发
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2024-08-27 11:19:38
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 吴高发 于 2024-08-27 09:02:19
影响环境 577
由谁解决 吴高发 于 2024-08-27 11:19:12
解决版本
解决方案 服务器原因
由谁关闭 吴高发 于 2024-08-27 11:19:38
最后修改 吴高发 于 2024-08-27 11:19:38
相关Bug