慢sql top 10,缺少索引，执行需要30分钟
2.解决方案： 在晚上业务使用量少的时候创建
- 建议在数据表 irobotbox_instant_sales_customer_1.Amazon_ShipmentItem 的 OrderSourceSku,OrderSourceId,CustomerId 列上添加如下索引，以提高查询性能：
ALTER TABLE `irobotbox_instant_sales_customer_1`.`Amazon_ShipmentItem` ADD INDEX `idx_OrderSourceSku_OrderSourceId_CustomerId` (`OrderSourceSku`, `OrderSourceId`, `CustomerId`)
注意：在业务高峰期，变更表结构存在风险，请谨慎操作！
3.SQL
SELECT `Id`, `CustomerId`, `OrderSourceId`, `OrderSourceSku`, `ShipmentId`
, `QuantityShipped`, `FNSKU`, `QuantityReceived`, `FulfillmentNetworkSKU`, `QuantityInCase`
, `QuantitySending`, `ReceivedTime`, `SendingTime`, `FirstReceivedTime`, `FirstSendingTime`
, `EarlieComeinQty`, `EarlieComeinTime`, `LastComeinQty`, `LastComeinTime`, `WareHouseID`
, `WareHouseName`, `TransportName`, `TransportType`, `LastModifierId`, `LastModifier`
, `LastModificationTime`, `CreatorId`, `Creator`, `CreationTime`
FROM `Amazon_ShipmentItem`
WHERE `CustomerId` = 1
AND `OrderSourceId` = 6657
AND `OrderSourceSku` IN ('056AUIAH717U4OFA8BQ165', '114C1125NWY', '14600RW86184G', '3041C14B111318UBVGMC3CI7', '351118JBZ4B', '3FN7J1486T180FW', '57B0LO59CVDN415W', 'CH05A14JZIMIVR09TO9Q0', 'ESVKIC0N5B9F03BZ1418O', 'GDBR1W2S4Z47130458DBL5V', 'UGL562JJ3U9Q140XX47RZRTRA', 'WE18D14XQ1UI5A3908SOBD', 'Y3611LC183', '010WCGU4923AWO1', '3111FUDDNTU44QQILQ77', 'A9PIN3191043O0TQG', 'B35H1UXQC3917RH', 'V53NC544VZN15TNAV', 'U113I142CGQSZ598FH4O0', 'UL6M28GTJDATH103343P40F4G', 'Q9FRSIZ11E15012658MNVFEP', '5GDJLOKQH464Z4R6J592R09GT', '33J05S11BS', 'JA36CEBH58R91112EWFL', 'JXH11QD92L1392SY1KEY', '14C3678L34JNQ8BONVX61O1X', 'US2ZX841T1AP09Y2940OHGHDX', '18BJSBC3511FL2GX', 'V9VM506753OHCA4191Y', '0XG41J7DV3399Y14LXMP', '2759I8B1R23I84610CLY6', 'BBR09AKXI33NNB49H1L', 'HKF9Y515595843EWHXFXZ', '450FIYT1552I108HD', '1R137112ZTJ', '0126B140OD', '095Q30Z58WIIYIB', '35A751462301TJ14IDSCY', '5315KHY0650X2TQBM49U6', 'I1131D50J8MOF', 'QKF146600MYJ', '130Q01P18DW072', '933K19R3YAUVER358ET', 'YA9KMOKPWMD858M094828ZD9', '59VPN2415WXJ9', '108M2K4V20D9G15135', 'Z4EB10S434OLE130ZEFFX', '61550H18SBLHO', '34MY1V5349DIS1VZ09AA6', 'F5135M13S3R14K', 'G00G1431B2', 'E475187QPW94LU163OG1', 'B37UF63W24109IQJ72H', '6LZ10P532488TN', 'SS149C24FSPRVSDAKM50SOZ', '04UYGQAGLF17108M8YYA5VVAR', 'L1025A118N', 'HKVN3313408Z', 'D7BV6A20559G63TEWA6153', '10E4518IXVW55UEFJ', 'X3444JKT4P95X15EF1341OL4', 'S855N26IT9Q2H11R', 'AEWDIX37GG4913PCDMZ8F0', 'Y0251357A25', '12GJC116KTV937FYR54', 'HC54P509TI36TLC', '34PE14VZO04028S032OY', 'Q0210QDB8ZQ52H0R53PRA6D', 'A8S59VQX522UFPW174VY', '23S2CGFC15103DKW1', 'U8XGAK41Q5114008LQ8WG3', 'GOZS2701I14M6I', '1023336PVJ', '10U34Z510N', '164CU24M20NN', 'Y4DQYIKFR1938Y610CY1B0', 'X3S10ZN424212JYLMWFK', '68R013W1J2QH5260L7BJ', '443GMK36RS58J2GL10A0K3C', '2SKHVQ15UVEA4553JY2', 'AUPSD17655W3KZFV1316GJ', 'VFL51A318J15G0V', 'EA58PHC11Y2KXUVTL426ZEXNH', '8BFW1A6O3K16R4S1584Y5C', 'L51681014QO', 'E9A503309D5', 'GI1510XUC6SE46IM2AY4', '0015D1510MGQ5', '1335623I1X4TMZ', '159HVO21ZO595SRD', '18U2CL10D9013KTG', '201562T2100P09P7JB0', '2512QU61176QWZ', '35994C19G15TO3Q', '5N71909CH56LW8', 'F16LOA5A04U17CTHD', 'I26ZG5611MZY', 'OCTBIT14OLU18017F6E2', 'O1400MXY19N', 'RM38486GXC911EWWR3', 'RU565FD26611X7', 'T3J206F1015969DIGV31L', 'X1C4140281821', 'Y1152EQ116C5UHQKN7', '0010B0COP0I051QIV1I', '5018C16Q6IE', '01K9M107GBA18U861', '082C1992ICW10SO5P38YTBF', '611ICH52U57DVG12C', 'G50M1186DR', '14ZQ0R3313JCH2W1OW8N', '05LP17E16YD', '4M4TL2CPA63BX7GS011148GP', '7Y37ZZ9KTO734150AUHB4PXV', '44969836OZTFV132PO', 'V6UE5139TF11B', 'AHKZCRQSK2430926CR6', 'E4C426XB239K09OM', 'U03T57F4513O', 'VM5946KL3O320993V4DWPDJ', 'CTX157C5UJ01I18L5M4AQ', 'K11VA120H786236KUUT7', '1054LXO3WLU5N39PED', 'SEK611NA5031LYDQY', '00Q93Z47JNX7QKYSR16F4MXS', 'B4709Y9NAN05P37NJPGM3FD2', 'QG1502308D0YV', 'Q4Q2E37B47X098UYF9H', 'ZR05OHZM656BH8GT610K', '15UN935ODVBT371VWZ', 'L8PH29WMN32O14N', '38UF11120MG', '55G398J23XHDN10YPIBKUHTRC', 'DRZ85H104ZU6JO91018MVB', 'PNVM1HV13104AZ36Z5324HDAA', 'S49MUF03397Y9HJ2IC', '04282AK10OT7GSH6', '53HKB4Q4251522X', 'J81V4H6803N17102', '1O7ZS332YRSJLZ29MQHLPO10U', 'W38FTW1560A06J21UJCYIIE', '351040OKFDGS', '3K2031042F1ZH3T', '23T3410MCK', 'AG5MQI0T38I14436LF19DT0X', '00G00737714P', '3TN58T3KTSQG1154XUMJ', '35X9138XS414IHZX3', 'CG10039E4563DHPC6', 'YY19J32H7LIF0U357VY', '10OZ5811GC', 'C5PXW57TF2470SYVF1120BB', 'EQBMLWSZD500U1518184WFE', 'IVVTB09185078S2XT7TLX0B', '03ZNSSIE060329XGQLH2', '1957I43OV8M', 'P25751PT136102K308W9G', '50I805909J', 'GI4573L3E7J19T6', '093434MI18T', '23L10AL41CIT7X', '3410OSY5U5206I1', '6I6956JSGC02HPK09I', 'CPM238E16LD558ZIHTLH14BJ', '143058ZZMUV', '5719M437H5TSC', 'BEC0Z8S8YLO1420DACZP119X1', 'I22333W15S', 'P134413RQ7MH', 'A8P2501X14LS', 'G68351211B3P', '553JIMD05TIY13UN', '1296Q2OCOB19AIZ10FS', 'VG19PAX200A4316P27AG4', '20N51C19NV23WX810UN', 'T58807GDCD11PL', 'C5CLWKD62307M149PA32KM4', '01J18124KF4N2', 'Y545613R5CFS', 'WQC102247TM7', 'IXA1017O038URDH', 'R7CR50NRE41Z16WJ', '38O8ZVI19I12010SF', '094737GMPE', 'L10W0JK118383VDR', 'S458310C47Z', 'UP384212I2VF11WJ', '3707Y1145C', '38JKQ05JNBW2J617CRYGP0', '5ZDY6275910QF', 'A09N4939UWJZQO', 'ECXPELN05AU38FVA19N17QJ6', '281590M5AO', '28UHMN01014BGMD302N', '9U635T19TE33HO9AFKJ9LQ', '435910RNDA', '9HGBU7T1307L956842A3W1', '3033710CZKJ', '5N33V29RD10K', '3FWW56FTZP119258659TY1U7')
