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

重现步骤

反馈人：袁慧斌
数据库：zhcxkj-center-product
查询时间：488.425
执行次数: 24
扫描行数：8482.38
发送行数：8482.38
指纹SQL: WITH RankedTitles AS ( SELECT sku , title_name , ROW_NUMBER ( ) OVER ( PARTITION BY sku ORDER BY create_time DESC ) as rn FROM ? WHERE sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
真实SQL：WITH RankedTitles AS ( SELECT sku, title_name, ROW_NUMBER() OVER (PARTITION BY sku ORDER BY create_time DESC) as rn FROM t_product_sku_title_fruugo WHERE sku IN (19032847,13157924,10293876,14423775,19092442,11741938,13262891,19176401,7897288,10295898,4495702,9528483,8211451,14621106,3480239,6800191,13754188,13077789,9899339,11079825,18974927,17663707,19003707,20074487,13331193,19639820,8814605,11386929,10116846,19789799,14425455,14802678,20283282,17352655,7149746,18004813,17842793,17779052,18861803,18113671,4011960,10977449,10462589,16513258,16971836,10431120,17727048,15774601,17801786,13512910,18005662,20284100,2370421,8039978,20081361,9816037,10059736,1667525,18098799,18593737,4611469,18600868,14443278,8297490,9762046,7402822,10059340,17196525,11631730,11699210,9884443,8121085,14437309,6680110,18595611,6147883,11292308,2178008,14281143,13574028,15616181,7943454,10496129,17032371,9675198,6302806,7456712,9889863,7962233,16402963,12026140,8448058,7683810,5495712,8168058,11480083,3365192,11410945,14285859,12308971,17382251,17723650,16036553,6281056,18127323,10983870,5901686,10789247,10533537,4738737,4264287,9446771,1402876,16963242,4487743,9290691,10852495,7102599,6353673,17650193,8364239,8774147,11045116,9940407,11322131,5773209,7875340,3316345,6692300,8627448,10437073,10017791,9972577,13750592,6760767,4792940,11173914,8524611,5227994,3472406,6185010,6589523,8068557,6133566,2148454,12838696,8027874,4787011,7897635,7840338,9626532,14279526,8923920,12636280,4610847,17513295,17678154,13533334,10681695,8740357,2346142,3837963,9699946,6662268,8793443,3876743,7212058,17353619,8511280,6286158,8525347,9130892,2926015,15530515,6126131,9825132,8555687,7107163,8419795,9966457,2544341,8436778,8432769,9092465,11454100,11158221,4576300,2579242,12329185,9583721,7388672,3559666,8503060,3893765,6034657,11171941,9967990,9839197,5778725,5548077,9302231,8749654,8389979,12358114,4944622,11512418,8487325,9302578,3702079,6716109,14296287,7407413,10956744,2346087,8981351,13578439,9375610,10351456,8431782,15794942,7945763,9100106,10784259,14425751,8853934,7219424,7838240,11136791,14580080,9950017,4567833,13325351,11651147,10786532,11946602,13391784,12639589,7759096,6865412,5403842,10440755,6950321,10703666,3604619,3085320,6078109,12091328,11965670,7269187,6573638,8900338,6325652,8601700,7213839,10349320,9569955,7775082,10339445,13694118,9981501,15940034,11647857,11762436,10133520,17177363,7546730,11279990,13529789,8732239,8880972,13241351,5498975,7934815,7319062,16626991,14114276,7397430,11894489,11583110,7240579,13607271,17097621,7130513,6629455,9480262,10899528,11466963,11598298,10622989,17893282,9682585,5384740,17349680,11860526,9733631,7367181,16522513,11776473,14382107,17269190,15983112,17517669,18043171,19808052,13964230,11453441,12196245,16523225,18816403,19715821,7767711,15947674,15467775,17491361,18091361,18765811,19137245,17658547,17782659,16970235,2206024,13919972,16301953,18113210,11741804,10127696,21030938,13097432,14591316,2713671,4067841,15586973,10390490,14413596,6758439,9876496,8500741,15004993,11153355,9050099,19367459,20154953,16178590,7886455,19546851,18093719,19154155,10935801,11591504,11476507,17718615,17275380,17204045,16897828,18773077,8798137,2906082,20148489,11677359,7291021,3904127,8091370,14049346,18031823,9885506,14160005,17776278,17347476,4850910,7362770,4649396,17545437,16892088,16398612,19110814,11017443,19364105,18625462,18581243,17632053,15962328,19434076,19234047,16228559,12613693,12349206,14743843,17187782,18705201,18859728,17789809,12222694,16944246,13587940,13755972,18104885,10069255,11423053,19163620,14399125,18571962,19380138,6911998,15779083,17923608,13580339,20110459,17552192,11829083,18123257,19616848,17204555,12189600,10930687,15912362,19629897,20028388,10980686,14406920,19333260,18878967,10836866,12049386,13689757,18816099,11804945,17170806,12314805,17475431,6801903,6054189,9531616,4611623,7039748,4217512,4108934,7257352,4763842,6873884,9521620,8713367,3667192,6602141,7551042,7169616,3197388,20479914,19384017,5154272,9958045,20703162,7277591,20779778,8327325,6817079,9842086,8262547,20327991,3641279,20367348,7375771,3066789,9710464,7107041,9343805,7096737,4390739,6077588,6257995,4254721,6157137,8568140,3255480,6386533,7166004,7304210,9766612,21039241,7136633,8120046,7236195,8245532,20255170755,9253845,8555226,11024013,16366656,10647799,10533411,15543688,10611929,11003407,10683079,10493555,16299316,10691580,10668202,6044626,10638786,10575796,16909491,10685054,10603601,10636873,10554931,10499220,10500494,10499660,16826665,17061975,15597399,8703872,15478278,8342489,11937122,14859043,3198153,6688350,10804469,4912525,8263419,9268755,16075278,10622865,13612625,7943091,16647626,11266721,6127168,15491489,10319117,7595732,10778761,11225104,10680173,10752356,10746331,10768557,10797385,10705589,11219281,7286279,3934691,10834070,10669633,13642685,10844029,11166682,10752434,17196847,10724646,10709754,6629705,10747303,10282938,10765195,10278281,17881481,10763728,10766921,17413951,17534451,11736347,16773977,11525277,17328144,12095672,19363348,13293824,11680674,7724133,11759980,11463584,4193255,11863297,17899549,10763272,11389313,11870788,9223078,9628907,11392298,7740489,11822711,10878346,10286209,11004028,16354215,11013946,10380051,10850575,11028587,10853702,16430015,10898368,11024951,11422505,10938874,4721602,10435185,10916373,11003385,11460314,10982909,10898072,10354649,10817602,10818991,10857994,11018453,17339695,7322912,7527528,6104794,19523552,11392637,17161565,13542746,9831464,8546333,7111955,6505211,7839331,6583521,11714511,11707598,17214014,17184231,19344991,11249258,16862803,13291576,10993506,11196769,5214775,11051464,16701371,13924693,11057926,6735011,11041458,10474630,11219389,4850148,11027583,11072515,11032135,11231787,11138030,11396105,11160512,11356474,11259141,17696466,11937071,17732138,10527044,17081620,9281155,11551680,12317538,11974034,11889188,11534088,14284327,9203435,11703225,12185526,12598897,12180636,11750574,15772522,12359020,9989330,13247786,11770609,15567698,13069263,11569541,11803513,12008811,12311161,12922661,19001756,8547359,11608761,12018912,11718401,11882656,11771057,16654099,8515062,12294609,8320222,6641916,14861500,11553191,4111321,19436061,19173699,18033852,11594509,9488978,9267545,18005944,19014141,7036707,6275592,14353028,17773416,13393669,16587245,16720789,6709575,15579321,16180913,11646227,16632028,16809892,14386494,11150713,11766848,8346587,17567557,13065068,11882447,12113168,12063672,11397975,16538579,7198007,11786541,14300398,11809420,12848966,11317169,10496971,10974169,12869631,15621349,12227287,4540453,12843242,11964170,10765577,6824588,13013433,4221937,7377741,16259861,5683644,11924958,19320950,11752869,11674471,10939954,6497808,10874930,14100181,19628680,9701942,14042963,7582405,11324788,9513761,14445372,4444408,8397928,19363316,16543233,6358157,11454395,17224126,16449016,9977480,11947497,8808622,10976024,14733755,11773971,18871326,10579133,14643797,10973902,13568910,11396932,11569851,14375500,11093209,5925641,11991647,15380971,11573116,15108356,10269972,3531703,11141602,15373072,14461255,12173462,14461310,10037697,11540850,5593142,15904992,17383336,6906664,15539502,11488147,14858060,11886518,12199482,11909397,11954105,2951577,10120280,10249454,10119458,14164256,10506084,16241235,16818063,10109740,10350544,10494821,3961240,5957562,9578018,17069806,14746202,7871576,15288908,16898553,10017043,10831144,10869146,16927141,11524415,11297932,13382897,11523893,10571872,11958062,11957248,14737916,12079758,10241003,10734910,4980981,16262672,16946649,11730201,3270425,10704848,11744084,10121708,10648301,9550862,10575496,17159150,10229290,10627252,10189176,16270636,10315805,10237614,10581800,10312775,10117920,5255052,10151200,10202747,10530153,10087703,3875726,6847730,6316543,12201543,18057526,17150670,6001005,12004802,10170102,6004512,10271601,12379190,7819477,10076788,12214216,10236181,10235244,7440666,10284232,13518218,4278131,13261721,11593692,4274758,13104331,11174604,10410917,7597193,16339766,16050062,4519276,10063575,11924651,8438637,10654159,19621895,13382882,11845417,6344127,8527880,16606595,11111307,5218876,12038087,11974704,5362817,13617345,5391650,11086803,12190068,10437319,6844531,21017921,9889717,15971627,2595196,11169615,9774211,11430541,8330410,9853613,...;
袁慧斌,人工修改过
AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ... at line 1")
explain表：
额外建议：IN 的内容太多了
索引建议：

历史记录

2025-10-23 09:04:05, 由 陈莉珍 创建。
2025-11-04 15:47:47, 由 叶嘉璇 解决，方案为 程序BUG 。
修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2025-11-04 15:47:20"。
修改了 指派给 ，旧值为 "yejiaxuan"，新值为 "chenlizhen"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "yejiaxuan"。
2025-11-05 09:05:18, 由 陈莉珍 编辑。
修改了 所属模块 ，旧值为 "0"，新值为 "1934"。
修改了 业务部门 ，旧值为 "0"，新值为 "2"。
修改了 测试责任人，旧值为 ""，新值为 "yejiaxuan"。
修改了 解决时效 ，旧值为 "0"，新值为 "198.72"。
修改了 重现步骤 ，区别为：
001- ~~反馈人：袁慧斌~~
001+ 反馈人：袁慧斌数据库：zhcxkj-center-product 查询时间：488.425 执行次数: 24 扫描行数：8482.38 发送行数：8482.38 指纹SQL: WITH RankedTitles AS ( SELECT sku , title_name , ROW_NUMBER ( ) OVER ( PARTITION BY sku ORDER BY create_time DESC ) as rn FROM ? WHERE sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , 真实SQL：WITH RankedTitles AS ( SELECT sku, title_name, ROW_NUMBER() OVER (PARTITION BY sku ORDER BY create_time DESC) as rn FROM t_product_sku_title_fruugo WHERE sku IN (19032847,13157924,10293876,14423775,19092442,11741938,13262891,19176401,7897288,10295898,4495702,9528483,8211451,14621106,3480239,6800191,13754188,13077789,9899339,11079825,18974927,17663707,19003707,20074487,13331193,19639820,8814605,11386929,10116846,19789799,14425455,14802678,20283282,17352655,7149746,18004813,17842793,17779052,18861803,18113671,4011960,10977449,10462589,16513258,16971836,10431120,17727048,15774601,17801786,13512910,18005662,20284100,2370421,8039978,20081361,9816037,10059736,1667525,18098799,18593737,4611469,18600868,14443278,8297490,9762046,7402822,10059340,17196525,11631730,11699210,9884443,8121085,14437309,6680110,18595611,6147883,11292308,2178008,14281143,13574028,15616181,7943454,10496129,17032371,9675198,6302806,7456712,9889863,7962233,16402963,12026140,8448058,7683810,5495712,8168058,11480083,3365192,11410945,14285859,12308971,17382251,17723650,16036553,6281056,18127323,10983870,5901686,10789247,10533537,4738737,4264287,9446771,1402876,16963242,4487743,9290691,10852495,7102599,6353673,17650193,8364239,8774147,11045116,9940407,11322131,5773209,7875340,3316345,6692300,8627448,10437073,10017791,9972577,13750592,6760767,4792940,11173914,8524611,5227994,3472406,6185010,6589523,8068557,6133566,2148454,12838696,8027874,4787011,7897635,7840338,9626532,14279526,8923920,12636280,4610847,17513295,17678154,13533334,10681695,8740357,2346142,3837963,9699946,6662268,8793443,3876743,7212058,17353619,8511280,6286158,8525347,9130892,2926015,15530515,6126131,9825132,8555687,7107163,8419795,9966457,2544341,8436778,8432769,9092465,11454100,11158221,4576300,2579242,12329185,9583721,7388672,3559666,8503060,3893765,6034657,11171941,9967990,9839197,5778725,5548077,9302231,8749654,8389979,12358114,4944622,11512418,8487325,9302578,3702079,6716109,14296287,7407413,10956744,2346087,8981351,13578439,9375610,10351456,8431782,15794942,7945763,9100106,10784259,14425751,8853934,7219424,7838240,11136791,14580080,9950017,4567833,13325351,11651147,10786532,11946602,13391784,12639589,7759096,6865412,5403842,10440755,6950321,10703666,3604619,3085320,6078109,12091328,11965670,7269187,6573638,8900338,6325652,8601700,7213839,10349320,9569955,7775082,10339445,13694118,9981501,15940034,11647857,11762436,10133520,17177363,7546730,11279990,13529789,8732239,8880972,13241351,5498975,7934815,7319062,16626991,14114276,7397430,11894489,11583110,7240579,13607271,17097621,7130513,6629455,9480262,10899528,11466963,11598298,10622989,17893282,9682585,5384740,17349680,11860526,9733631,7367181,16522513,11776473,14382107,17269190,15983112,17517669,18043171,19808052,13964230,11453441,12196245,16523225,18816403,19715821,7767711,15947674,15467775,17491361,18091361,18765811,19137245,17658547,17782659,16970235,2206024,13919972,16301953,18113210,11741804,10127696,21030938,13097432,14591316,2713671,4067841,15586973,10390490,14413596,6758439,9876496,8500741,15004993,11153355,9050099,19367459,20154953,16178590,7886455,19546851,18093719,19154155,10935801,11591504,11476507,17718615,17275380,17204045,16897828,18773077,8798137,2906082,20148489,11677359,7291021,3904127,8091370,14049346,18031823,9885506,14160005,17776278,17347476,4850910,7362770,4649396,17545437,16892088,16398612,19110814,11017443,19364105,18625462,18581243,17632053,15962328,19434076,19234047,16228559,12613693,12349206,14743843,17187782,18705201,18859728,17789809,12222694,16944246,13587940,13755972,18104885,10069255,11423053,19163620,14399125,18571962,19380138,6911998,15779083,17923608,13580339,20110459,17552192,11829083,18123257,19616848,17204555,12189600,10930687,15912362,19629897,20028388,10980686,14406920,19333260,18878967,10836866,12049386,13689757,18816099,11804945,17170806,12314805,17475431,6801903,6054189,9531616,4611623,7039748,4217512,4108934,7257352,4763842,6873884,9521620,8713367,3667192,6602141,7551042,7169616,3197388,20479914,19384017,5154272,9958045,20703162,7277591,20779778,8327325,6817079,9842086,8262547,20327991,3641279,20367348,7375771,3066789,9710464,7107041,9343805,7096737,4390739,6077588,6257995,4254721,6157137,8568140,3255480,6386533,7166004,7304210,9766612,21039241,7136633,8120046,7236195,8245532,20255170755,9253845,8555226,11024013,16366656,10647799,10533411,15543688,10611929,11003407,10683079,10493555,16299316,10691580,10668202,6044626,10638786,10575796,16909491,10685054,10603601,10636873,10554931,10499220,10500494,10499660,16826665,17061975,15597399,8703872,15478278,8342489,11937122,14859043,3198153,6688350,10804469,4912525,8263419,9268755,16075278,10622865,13612625,7943091,16647626,11266721,6127168,15491489,10319117,7595732,10778761,11225104,10680173,10752356,10746331,10768557,10797385,10705589,11219281,7286279,3934691,10834070,10669633,13642685,10844029,11166682,10752434,17196847,10724646,10709754,6629705,10747303,10282938,10765195,10278281,17881481,10763728,10766921,17413951,17534451,11736347,16773977,11525277,17328144,12095672,19363348,13293824,11680674,7724133,11759980,11463584,4193255,11863297,17899549,10763272,11389313,11870788,9223078,9628907,11392298,7740489,11822711,10878346,10286209,11004028,16354215,11013946,10380051,10850575,11028587,10853702,16430015,10898368,11024951,11422505,10938874,4721602,10435185,10916373,11003385,11460314,10982909,10898072,10354649,10817602,10818991,10857994,11018453,17339695,7322912,7527528,6104794,19523552,11392637,17161565,13542746,9831464,8546333,7111955,6505211,7839331,6583521,11714511,11707598,17214014,17184231,19344991,11249258,16862803,13291576,10993506,11196769,5214775,11051464,16701371,13924693,11057926,6735011,11041458,10474630,11219389,4850148,11027583,11072515,11032135,11231787,11138030,11396105,11160512,11356474,11259141,17696466,11937071,17732138,10527044,17081620,9281155,11551680,12317538,11974034,11889188,11534088,14284327,9203435,11703225,12185526,12598897,12180636,11750574,15772522,12359020,9989330,13247786,11770609,15567698,13069263,11569541,11803513,12008811,12311161,12922661,19001756,8547359,11608761,12018912,11718401,11882656,11771057,16654099,8515062,12294609,8320222,6641916,14861500,11553191,4111321,19436061,19173699,18033852,11594509,9488978,9267545,18005944,19014141,7036707,6275592,14353028,17773416,13393669,16587245,16720789,6709575,15579321,16180913,11646227,16632028,16809892,14386494,11150713,11766848,8346587,17567557,13065068,11882447,12113168,12063672,11397975,16538579,7198007,11786541,14300398,11809420,12848966,11317169,10496971,10974169,12869631,15621349,12227287,4540453,12843242,11964170,10765577,6824588,13013433,4221937,7377741,16259861,5683644,11924958,19320950,11752869,11674471,10939954,6497808,10874930,14100181,19628680,9701942,14042963,7582405,11324788,9513761,14445372,4444408,8397928,19363316,16543233,6358157,11454395,17224126,16449016,9977480,11947497,8808622,10976024,14733755,11773971,18871326,10579133,14643797,10973902,13568910,11396932,11569851,14375500,11093209,5925641,11991647,15380971,11573116,15108356,10269972,3531703,11141602,15373072,14461255,12173462,14461310,10037697,11540850,5593142,15904992,17383336,6906664,15539502,11488147,14858060,11886518,12199482,11909397,11954105,2951577,10120280,10249454,10119458,14164256,10506084,16241235,16818063,10109740,10350544,10494821,3961240,5957562,9578018,17069806,14746202,7871576,15288908,16898553,10017043,10831144,10869146,16927141,11524415,11297932,13382897,11523893,10571872,11958062,11957248,14737916,12079758,10241003,10734910,4980981,16262672,16946649,11730201,3270425,10704848,11744084,10121708,10648301,9550862,10575496,17159150,10229290,10627252,10189176,16270636,10315805,10237614,10581800,10312775,10117920,5255052,10151200,10202747,10530153,10087703,3875726,6847730,6316543,12201543,18057526,17150670,6001005,12004802,10170102,6004512,10271601,12379190,7819477,10076788,12214216,10236181,10235244,7440666,10284232,13518218,4278131,13261721,11593692,4274758,13104331,11174604,10410917,7597193,16339766,16050062,4519276,10063575,11924651,8438637,10654159,19621895,13382882,11845417,6344127,8527880,16606595,11111307,5218876,12038087,11974704,5362817,13617345,5391650,11086803,12190068,10437319,6844531,21017921,9889717,15971627,2595196,11169615,9774211,11430541,8330410,9853613,...; 袁慧斌,人工修改过 AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ... at line 1") explain表：额外建议：IN 的内容太多了索引建议：
002- ~~数据库：zhcxkj-center-product~~
003- ~~查询时间：488.425~~
004- ~~执行次数: 24~~
005- ~~扫描行数：8482.38~~
006- ~~发送行数：8482.38~~
007- 指纹SQL: WITH RankedTitles AS ( SELECT sku , title_name , ROW_NUMBER ( ) OVER ( PARTITION BY sku ORDER BY create_time DESC ) as rn FROM ? WHERE sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
008- 真实SQL：WITH RankedTitles AS ( SELECT sku, title_name, ROW_NUMBER() OVER (PARTITION BY sku ORDER BY create_time DESC) as rn FROM t_product_sku_title_fruugo WHERE sku IN (19032847,13157924,10293876,14423775,19092442,11741938,13262891,19176401,7897288,10295898,4495702,9528483,8211451,14621106,3480239,6800191,13754188,13077789,9899339,11079825,18974927,17663707,19003707,20074487,13331193,19639820,8814605,11386929,10116846,19789799,14425455,14802678,20283282,17352655,7149746,18004813,17842793,17779052,18861803,18113671,4011960,10977449,10462589,16513258,16971836,10431120,17727048,15774601,17801786,13512910,18005662,20284100,2370421,8039978,20081361,9816037,10059736,1667525,18098799,18593737,4611469,18600868,14443278,8297490,9762046,7402822,10059340,17196525,11631730,11699210,9884443,8121085,14437309,6680110,18595611,6147883,11292308,2178008,14281143,13574028,15616181,7943454,10496129,17032371,9675198,6302806,7456712,9889863,7962233,16402963,12026140,8448058,7683810,5495712,8168058,11480083,3365192,11410945,14285859,12308971,17382251,17723650,16036553,6281056,18127323,10983870,5901686,10789247,10533537,4738737,4264287,9446771,1402876,16963242,4487743,9290691,10852495,7102599,6353673,17650193,8364239,8774147,11045116,9940407,11322131,5773209,7875340,3316345,6692300,8627448,10437073,10017791,9972577,13750592,6760767,4792940,11173914,8524611,5227994,3472406,6185010,6589523,8068557,6133566,2148454,12838696,8027874,4787011,7897635,7840338,9626532,14279526,8923920,12636280,4610847,17513295,17678154,13533334,10681695,8740357,2346142,3837963,9699946,6662268,8793443,3876743,7212058,17353619,8511280,6286158,8525347,9130892,2926015,15530515,6126131,9825132,8555687,7107163,8419795,9966457,2544341,8436778,8432769,9092465,11454100,11158221,4576300,2579242,12329185,9583721,7388672,3559666,8503060,3893765,6034657,11171941,9967990,9839197,5778725,5548077,9302231,8749654,8389979,12358114,4944622,11512418,8487325,9302578,3702079,6716109,14296287,7407413,10956744,2346087,8981351,13578439,9375610,10351456,8431782,15794942,7945763,9100106,10784259,14425751,8853934,7219424,7838240,11136791,14580080,9950017,4567833,13325351,11651147,10786532,11946602,13391784,12639589,7759096,6865412,5403842,10440755,6950321,10703666,3604619,3085320,6078109,12091328,11965670,7269187,6573638,8900338,6325652,8601700,7213839,10349320,9569955,7775082,10339445,13694118,9981501,15940034,11647857,11762436,10133520,17177363,7546730,11279990,13529789,8732239,8880972,13241351,5498975,7934815,7319062,16626991,14114276,7397430,11894489,11583110,7240579,13607271,17097621,7130513,6629455,9480262,10899528,11466963,11598298,10622989,17893282,9682585,5384740,17349680,11860526,9733631,7367181,16522513,11776473,14382107,17269190,15983112,17517669,18043171,19808052,13964230,11453441,12196245,16523225,18816403,19715821,7767711,15947674,15467775,17491361,18091361,18765811,19137245,17658547,17782659,16970235,2206024,13919972,16301953,18113210,11741804,10127696,21030938,13097432,14591316,2713671,4067841,15586973,10390490,14413596,6758439,9876496,8500741,15004993,11153355,9050099,19367459,20154953,16178590,7886455,19546851,18093719,19154155,10935801,11591504,11476507,17718615,17275380,17204045,16897828,18773077,8798137,2906082,20148489,11677359,7291021,3904127,8091370,14049346,18031823,9885506,14160005,17776278,17347476,4850910,7362770,4649396,17545437,16892088,16398612,19110814,11017443,19364105,18625462,18581243,17632053,15962328,19434076,19234047,16228559,12613693,12349206,14743843,17187782,18705201,18859728,17789809,12222694,16944246,13587940,13755972,18104885,10069255,11423053,19163620,14399125,18571962,19380138,6911998,15779083,17923608,13580339,20110459,17552192,11829083,18123257,19616848,17204555,12189600,10930687,15912362,19629897,20028388,10980686,14406920,19333260,18878967,10836866,12049386,13689757,18816099,11804945,17170806,12314805,17475431,6801903,6054189,9531616,4611623,7039748,4217512,4108934,7257352,4763842,6873884,9521620,8713367,3667192,6602141,7551042,7169616,3197388,20479914,19384017,5154272,9958045,20703162,7277591,20779778,8327325,6817079,9842086,8262547,20327991,3641279,20367348,7375771,3066789,9710464,7107041,9343805,7096737,4390739,6077588,6257995,4254721,6157137,8568140,3255480,6386533,7166004,7304210,9766612,21039241,7136633,8120046,7236195,8245532,20255170755,9253845,8555226,11024013,16366656,10647799,10533411,15543688,10611929,11003407,10683079,10493555,16299316,10691580,10668202,6044626,10638786,10575796,16909491,10685054,10603601,10636873,10554931,10499220,10500494,10499660,16826665,17061975,15597399,8703872,15478278,8342489,11937122,14859043,3198153,6688350,10804469,4912525,8263419,9268755,16075278,10622865,13612625,7943091,16647626,11266721,6127168,15491489,10319117,7595732,10778761,11225104,10680173,10752356,10746331,10768557,10797385,10705589,11219281,7286279,3934691,10834070,10669633,13642685,10844029,11166682,10752434,17196847,10724646,10709754,6629705,10747303,10282938,10765195,10278281,17881481,10763728,10766921,17413951,17534451,11736347,16773977,11525277,17328144,12095672,19363348,13293824,11680674,7724133,11759980,11463584,4193255,11863297,17899549,10763272,11389313,11870788,9223078,9628907,11392298,7740489,11822711,10878346,10286209,11004028,16354215,11013946,10380051,10850575,11028587,10853702,16430015,10898368,11024951,11422505,10938874,4721602,10435185,10916373,11003385,11460314,10982909,10898072,10354649,10817602,10818991,10857994,11018453,17339695,7322912,7527528,6104794,19523552,11392637,17161565,13542746,9831464,8546333,7111955,6505211,7839331,6583521,11714511,11707598,17214014,17184231,19344991,11249258,16862803,13291576,10993506,11196769,5214775,11051464,16701371,13924693,11057926,6735011,11041458,10474630,11219389,4850148,11027583,11072515,11032135,11231787,11138030,11396105,11160512,11356474,11259141,17696466,11937071,17732138,10527044,17081620,9281155,11551680,12317538,11974034,11889188,11534088,14284327,9203435,11703225,12185526,12598897,12180636,11750574,15772522,12359020,9989330,13247786,11770609,15567698,13069263,11569541,11803513,12008811,12311161,12922661,19001756,8547359,11608761,12018912,11718401,11882656,11771057,16654099,8515062,12294609,8320222,6641916,14861500,11553191,4111321,19436061,19173699,18033852,11594509,9488978,9267545,18005944,19014141,7036707,6275592,14353028,17773416,13393669,16587245,16720789,6709575,15579321,16180913,11646227,16632028,16809892,14386494,11150713,11766848,8346587,17567557,13065068,11882447,12113168,12063672,11397975,16538579,7198007,11786541,14300398,11809420,12848966,11317169,10496971,10974169,12869631,15621349,12227287,4540453,12843242,11964170,10765577,6824588,13013433,4221937,7377741,16259861,5683644,11924958,19320950,11752869,11674471,10939954,6497808,10874930,14100181,19628680,9701942,14042963,7582405,11324788,9513761,14445372,4444408,8397928,19363316,16543233,6358157,11454395,17224126,16449016,9977480,11947497,8808622,10976024,14733755,11773971,18871326,10579133,14643797,10973902,13568910,11396932,11569851,14375500,11093209,5925641,11991647,15380971,11573116,15108356,10269972,3531703,11141602,15373072,14461255,12173462,14461310,10037697,11540850,5593142,15904992,17383336,6906664,15539502,11488147,14858060,11886518,12199482,11909397,11954105,2951577,10120280,10249454,10119458,14164256,10506084,16241235,16818063,10109740,10350544,10494821,3961240,5957562,9578018,17069806,14746202,7871576,15288908,16898553,10017043,10831144,10869146,16927141,11524415,11297932,13382897,11523893,10571872,11958062,11957248,14737916,12079758,10241003,10734910,4980981,16262672,16946649,11730201,3270425,10704848,11744084,10121708,10648301,9550862,10575496,17159150,10229290,10627252,10189176,16270636,10315805,10237614,10581800,10312775,10117920,5255052,10151200,10202747,10530153,10087703,3875726,6847730,6316543,12201543,18057526,17150670,6001005,12004802,10170102,6004512,10271601,12379190,7819477,10076788,12214216,10236181,10235244,7440666,10284232,13518218,4278131,13261721,11593692,4274758,13104331,11174604,10410917,7597193,16339766,16050062,4519276,10063575,11924651,8438637,10654159,19621895,13382882,11845417,6344127,8527880,16606595,11111307,5218876,12038087,11974704,5362817,13617345,5391650,11086803,12190068,10437319,6844531,21017921,9889717,15971627,2595196,11169615,9774211,11430541,8330410,9853613,...;
009- ~~袁慧斌,人工修改过~~
010- AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ... at line 1")
011- ~~explain表：~~
012- ~~额外建议：IN 的内容太多了~~
013- ~~索引建议：~~
014-

001- ~~反馈人：袁慧斌 ~~
001+ 反馈人：袁慧斌 数据库：zhcxkj-center-product 查询时间：488.425 执行次数: 24 扫描行数：8482.38 发送行数：8482.38 指纹SQL: WITH RankedTitles AS ( SELECT sku , title_name , ROW_NUMBER ( ) OVER ( PARTITION BY sku ORDER BY create_time DESC ) as rn FROM ? WHERE sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , 真实SQL：WITH RankedTitles AS ( SELECT sku, title_name, ROW_NUMBER() OVER (PARTITION BY sku ORDER BY create_time DESC) as rn FROM t_product_sku_title_fruugo WHERE sku IN (19032847,13157924,10293876,14423775,19092442,11741938,13262891,19176401,7897288,10295898,4495702,9528483,8211451,14621106,3480239,6800191,13754188,13077789,9899339,11079825,18974927,17663707,19003707,20074487,13331193,19639820,8814605,11386929,10116846,19789799,14425455,14802678,20283282,17352655,7149746,18004813,17842793,17779052,18861803,18113671,4011960,10977449,10462589,16513258,16971836,10431120,17727048,15774601,17801786,13512910,18005662,20284100,2370421,8039978,20081361,9816037,10059736,1667525,18098799,18593737,4611469,18600868,14443278,8297490,9762046,7402822,10059340,17196525,11631730,11699210,9884443,8121085,14437309,6680110,18595611,6147883,11292308,2178008,14281143,13574028,15616181,7943454,10496129,17032371,9675198,6302806,7456712,9889863,7962233,16402963,12026140,8448058,7683810,5495712,8168058,11480083,3365192,11410945,14285859,12308971,17382251,17723650,16036553,6281056,18127323,10983870,5901686,10789247,10533537,4738737,4264287,9446771,1402876,16963242,4487743,9290691,10852495,7102599,6353673,17650193,8364239,8774147,11045116,9940407,11322131,5773209,7875340,3316345,6692300,8627448,10437073,10017791,9972577,13750592,6760767,4792940,11173914,8524611,5227994,3472406,6185010,6589523,8068557,6133566,2148454,12838696,8027874,4787011,7897635,7840338,9626532,14279526,8923920,12636280,4610847,17513295,17678154,13533334,10681695,8740357,2346142,3837963,9699946,6662268,8793443,3876743,7212058,17353619,8511280,6286158,8525347,9130892,2926015,15530515,6126131,9825132,8555687,7107163,8419795,9966457,2544341,8436778,8432769,9092465,11454100,11158221,4576300,2579242,12329185,9583721,7388672,3559666,8503060,3893765,6034657,11171941,9967990,9839197,5778725,5548077,9302231,8749654,8389979,12358114,4944622,11512418,8487325,9302578,3702079,6716109,14296287,7407413,10956744,2346087,8981351,13578439,9375610,10351456,8431782,15794942,7945763,9100106,10784259,14425751,8853934,7219424,7838240,11136791,14580080,9950017,4567833,13325351,11651147,10786532,11946602,13391784,12639589,7759096,6865412,5403842,10440755,6950321,10703666,3604619,3085320,6078109,12091328,11965670,7269187,6573638,8900338,6325652,8601700,7213839,10349320,9569955,7775082,10339445,13694118,9981501,15940034,11647857,11762436,10133520,17177363,7546730,11279990,13529789,8732239,8880972,13241351,5498975,7934815,7319062,16626991,14114276,7397430,11894489,11583110,7240579,13607271,17097621,7130513,6629455,9480262,10899528,11466963,11598298,10622989,17893282,9682585,5384740,17349680,11860526,9733631,7367181,16522513,11776473,14382107,17269190,15983112,17517669,18043171,19808052,13964230,11453441,12196245,16523225,18816403,19715821,7767711,15947674,15467775,17491361,18091361,18765811,19137245,17658547,17782659,16970235,2206024,13919972,16301953,18113210,11741804,10127696,21030938,13097432,14591316,2713671,4067841,15586973,10390490,14413596,6758439,9876496,8500741,15004993,11153355,9050099,19367459,20154953,16178590,7886455,19546851,18093719,19154155,10935801,11591504,11476507,17718615,17275380,17204045,16897828,18773077,8798137,2906082,20148489,11677359,7291021,3904127,8091370,14049346,18031823,9885506,14160005,17776278,17347476,4850910,7362770,4649396,17545437,16892088,16398612,19110814,11017443,19364105,18625462,18581243,17632053,15962328,19434076,19234047,16228559,12613693,12349206,14743843,17187782,18705201,18859728,17789809,12222694,16944246,13587940,13755972,18104885,10069255,11423053,19163620,14399125,18571962,19380138,6911998,15779083,17923608,13580339,20110459,17552192,11829083,18123257,19616848,17204555,12189600,10930687,15912362,19629897,20028388,10980686,14406920,19333260,18878967,10836866,12049386,13689757,18816099,11804945,17170806,12314805,17475431,6801903,6054189,9531616,4611623,7039748,4217512,4108934,7257352,4763842,6873884,9521620,8713367,3667192,6602141,7551042,7169616,3197388,20479914,19384017,5154272,9958045,20703162,7277591,20779778,8327325,6817079,9842086,8262547,20327991,3641279,20367348,7375771,3066789,9710464,7107041,9343805,7096737,4390739,6077588,6257995,4254721,6157137,8568140,3255480,6386533,7166004,7304210,9766612,21039241,7136633,8120046,7236195,8245532,20255170755,9253845,8555226,11024013,16366656,10647799,10533411,15543688,10611929,11003407,10683079,10493555,16299316,10691580,10668202,6044626,10638786,10575796,16909491,10685054,10603601,10636873,10554931,10499220,10500494,10499660,16826665,17061975,15597399,8703872,15478278,8342489,11937122,14859043,3198153,6688350,10804469,4912525,8263419,9268755,16075278,10622865,13612625,7943091,16647626,11266721,6127168,15491489,10319117,7595732,10778761,11225104,10680173,10752356,10746331,10768557,10797385,10705589,11219281,7286279,3934691,10834070,10669633,13642685,10844029,11166682,10752434,17196847,10724646,10709754,6629705,10747303,10282938,10765195,10278281,17881481,10763728,10766921,17413951,17534451,11736347,16773977,11525277,17328144,12095672,19363348,13293824,11680674,7724133,11759980,11463584,4193255,11863297,17899549,10763272,11389313,11870788,9223078,9628907,11392298,7740489,11822711,10878346,10286209,11004028,16354215,11013946,10380051,10850575,11028587,10853702,16430015,10898368,11024951,11422505,10938874,4721602,10435185,10916373,11003385,11460314,10982909,10898072,10354649,10817602,10818991,10857994,11018453,17339695,7322912,7527528,6104794,19523552,11392637,17161565,13542746,9831464,8546333,7111955,6505211,7839331,6583521,11714511,11707598,17214014,17184231,19344991,11249258,16862803,13291576,10993506,11196769,5214775,11051464,16701371,13924693,11057926,6735011,11041458,10474630,11219389,4850148,11027583,11072515,11032135,11231787,11138030,11396105,11160512,11356474,11259141,17696466,11937071,17732138,10527044,17081620,9281155,11551680,12317538,11974034,11889188,11534088,14284327,9203435,11703225,12185526,12598897,12180636,11750574,15772522,12359020,9989330,13247786,11770609,15567698,13069263,11569541,11803513,12008811,12311161,12922661,19001756,8547359,11608761,12018912,11718401,11882656,11771057,16654099,8515062,12294609,8320222,6641916,14861500,11553191,4111321,19436061,19173699,18033852,11594509,9488978,9267545,18005944,19014141,7036707,6275592,14353028,17773416,13393669,16587245,16720789,6709575,15579321,16180913,11646227,16632028,16809892,14386494,11150713,11766848,8346587,17567557,13065068,11882447,12113168,12063672,11397975,16538579,7198007,11786541,14300398,11809420,12848966,11317169,10496971,10974169,12869631,15621349,12227287,4540453,12843242,11964170,10765577,6824588,13013433,4221937,7377741,16259861,5683644,11924958,19320950,11752869,11674471,10939954,6497808,10874930,14100181,19628680,9701942,14042963,7582405,11324788,9513761,14445372,4444408,8397928,19363316,16543233,6358157,11454395,17224126,16449016,9977480,11947497,8808622,10976024,14733755,11773971,18871326,10579133,14643797,10973902,13568910,11396932,11569851,14375500,11093209,5925641,11991647,15380971,11573116,15108356,10269972,3531703,11141602,15373072,14461255,12173462,14461310,10037697,11540850,5593142,15904992,17383336,6906664,15539502,11488147,14858060,11886518,12199482,11909397,11954105,2951577,10120280,10249454,10119458,14164256,10506084,16241235,16818063,10109740,10350544,10494821,3961240,5957562,9578018,17069806,14746202,7871576,15288908,16898553,10017043,10831144,10869146,16927141,11524415,11297932,13382897,11523893,10571872,11958062,11957248,14737916,12079758,10241003,10734910,4980981,16262672,16946649,11730201,3270425,10704848,11744084,10121708,10648301,9550862,10575496,17159150,10229290,10627252,10189176,16270636,10315805,10237614,10581800,10312775,10117920,5255052,10151200,10202747,10530153,10087703,3875726,6847730,6316543,12201543,18057526,17150670,6001005,12004802,10170102,6004512,10271601,12379190,7819477,10076788,12214216,10236181,10235244,7440666,10284232,13518218,4278131,13261721,11593692,4274758,13104331,11174604,10410917,7597193,16339766,16050062,4519276,10063575,11924651,8438637,10654159,19621895,13382882,11845417,6344127,8527880,16606595,11111307,5218876,12038087,11974704,5362817,13617345,5391650,11086803,12190068,10437319,6844531,21017921,9889717,15971627,2595196,11169615,9774211,11430541,8330410,9853613,...; 袁慧斌,人工修改过 AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ... at line 1") explain表： 额外建议：IN 的内容太多了 索引建议： 
002- ~~数据库：zhcxkj-center-product ~~
003- ~~查询时间：488.425 ~~
004- ~~执行次数: 24 ~~
005- ~~扫描行数：8482.38 ~~
006- ~~发送行数：8482.38 ~~
007- 指纹SQL: WITH RankedTitles AS ( SELECT sku , title_name , ROW_NUMBER ( ) OVER ( PARTITION BY sku ORDER BY create_time DESC ) as rn FROM ? WHERE sku IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , 
008- 真实SQL：WITH RankedTitles AS ( SELECT sku, title_name, ROW_NUMBER() OVER (PARTITION BY sku ORDER BY create_time DESC) as rn FROM t_product_sku_title_fruugo WHERE sku IN (19032847,13157924,10293876,14423775,19092442,11741938,13262891,19176401,7897288,10295898,4495702,9528483,8211451,14621106,3480239,6800191,13754188,13077789,9899339,11079825,18974927,17663707,19003707,20074487,13331193,19639820,8814605,11386929,10116846,19789799,14425455,14802678,20283282,17352655,7149746,18004813,17842793,17779052,18861803,18113671,4011960,10977449,10462589,16513258,16971836,10431120,17727048,15774601,17801786,13512910,18005662,20284100,2370421,8039978,20081361,9816037,10059736,1667525,18098799,18593737,4611469,18600868,14443278,8297490,9762046,7402822,10059340,17196525,11631730,11699210,9884443,8121085,14437309,6680110,18595611,6147883,11292308,2178008,14281143,13574028,15616181,7943454,10496129,17032371,9675198,6302806,7456712,9889863,7962233,16402963,12026140,8448058,7683810,5495712,8168058,11480083,3365192,11410945,14285859,12308971,17382251,17723650,16036553,6281056,18127323,10983870,5901686,10789247,10533537,4738737,4264287,9446771,1402876,16963242,4487743,9290691,10852495,7102599,6353673,17650193,8364239,8774147,11045116,9940407,11322131,5773209,7875340,3316345,6692300,8627448,10437073,10017791,9972577,13750592,6760767,4792940,11173914,8524611,5227994,3472406,6185010,6589523,8068557,6133566,2148454,12838696,8027874,4787011,7897635,7840338,9626532,14279526,8923920,12636280,4610847,17513295,17678154,13533334,10681695,8740357,2346142,3837963,9699946,6662268,8793443,3876743,7212058,17353619,8511280,6286158,8525347,9130892,2926015,15530515,6126131,9825132,8555687,7107163,8419795,9966457,2544341,8436778,8432769,9092465,11454100,11158221,4576300,2579242,12329185,9583721,7388672,3559666,8503060,3893765,6034657,11171941,9967990,9839197,5778725,5548077,9302231,8749654,8389979,12358114,4944622,11512418,8487325,9302578,3702079,6716109,14296287,7407413,10956744,2346087,8981351,13578439,9375610,10351456,8431782,15794942,7945763,9100106,10784259,14425751,8853934,7219424,7838240,11136791,14580080,9950017,4567833,13325351,11651147,10786532,11946602,13391784,12639589,7759096,6865412,5403842,10440755,6950321,10703666,3604619,3085320,6078109,12091328,11965670,7269187,6573638,8900338,6325652,8601700,7213839,10349320,9569955,7775082,10339445,13694118,9981501,15940034,11647857,11762436,10133520,17177363,7546730,11279990,13529789,8732239,8880972,13241351,5498975,7934815,7319062,16626991,14114276,7397430,11894489,11583110,7240579,13607271,17097621,7130513,6629455,9480262,10899528,11466963,11598298,10622989,17893282,9682585,5384740,17349680,11860526,9733631,7367181,16522513,11776473,14382107,17269190,15983112,17517669,18043171,19808052,13964230,11453441,12196245,16523225,18816403,19715821,7767711,15947674,15467775,17491361,18091361,18765811,19137245,17658547,17782659,16970235,2206024,13919972,16301953,18113210,11741804,10127696,21030938,13097432,14591316,2713671,4067841,15586973,10390490,14413596,6758439,9876496,8500741,15004993,11153355,9050099,19367459,20154953,16178590,7886455,19546851,18093719,19154155,10935801,11591504,11476507,17718615,17275380,17204045,16897828,18773077,8798137,2906082,20148489,11677359,7291021,3904127,8091370,14049346,18031823,9885506,14160005,17776278,17347476,4850910,7362770,4649396,17545437,16892088,16398612,19110814,11017443,19364105,18625462,18581243,17632053,15962328,19434076,19234047,16228559,12613693,12349206,14743843,17187782,18705201,18859728,17789809,12222694,16944246,13587940,13755972,18104885,10069255,11423053,19163620,14399125,18571962,19380138,6911998,15779083,17923608,13580339,20110459,17552192,11829083,18123257,19616848,17204555,12189600,10930687,15912362,19629897,20028388,10980686,14406920,19333260,18878967,10836866,12049386,13689757,18816099,11804945,17170806,12314805,17475431,6801903,6054189,9531616,4611623,7039748,4217512,4108934,7257352,4763842,6873884,9521620,8713367,3667192,6602141,7551042,7169616,3197388,20479914,19384017,5154272,9958045,20703162,7277591,20779778,8327325,6817079,9842086,8262547,20327991,3641279,20367348,7375771,3066789,9710464,7107041,9343805,7096737,4390739,6077588,6257995,4254721,6157137,8568140,3255480,6386533,7166004,7304210,9766612,21039241,7136633,8120046,7236195,8245532,20255170755,9253845,8555226,11024013,16366656,10647799,10533411,15543688,10611929,11003407,10683079,10493555,16299316,10691580,10668202,6044626,10638786,10575796,16909491,10685054,10603601,10636873,10554931,10499220,10500494,10499660,16826665,17061975,15597399,8703872,15478278,8342489,11937122,14859043,3198153,6688350,10804469,4912525,8263419,9268755,16075278,10622865,13612625,7943091,16647626,11266721,6127168,15491489,10319117,7595732,10778761,11225104,10680173,10752356,10746331,10768557,10797385,10705589,11219281,7286279,3934691,10834070,10669633,13642685,10844029,11166682,10752434,17196847,10724646,10709754,6629705,10747303,10282938,10765195,10278281,17881481,10763728,10766921,17413951,17534451,11736347,16773977,11525277,17328144,12095672,19363348,13293824,11680674,7724133,11759980,11463584,4193255,11863297,17899549,10763272,11389313,11870788,9223078,9628907,11392298,7740489,11822711,10878346,10286209,11004028,16354215,11013946,10380051,10850575,11028587,10853702,16430015,10898368,11024951,11422505,10938874,4721602,10435185,10916373,11003385,11460314,10982909,10898072,10354649,10817602,10818991,10857994,11018453,17339695,7322912,7527528,6104794,19523552,11392637,17161565,13542746,9831464,8546333,7111955,6505211,7839331,6583521,11714511,11707598,17214014,17184231,19344991,11249258,16862803,13291576,10993506,11196769,5214775,11051464,16701371,13924693,11057926,6735011,11041458,10474630,11219389,4850148,11027583,11072515,11032135,11231787,11138030,11396105,11160512,11356474,11259141,17696466,11937071,17732138,10527044,17081620,9281155,11551680,12317538,11974034,11889188,11534088,14284327,9203435,11703225,12185526,12598897,12180636,11750574,15772522,12359020,9989330,13247786,11770609,15567698,13069263,11569541,11803513,12008811,12311161,12922661,19001756,8547359,11608761,12018912,11718401,11882656,11771057,16654099,8515062,12294609,8320222,6641916,14861500,11553191,4111321,19436061,19173699,18033852,11594509,9488978,9267545,18005944,19014141,7036707,6275592,14353028,17773416,13393669,16587245,16720789,6709575,15579321,16180913,11646227,16632028,16809892,14386494,11150713,11766848,8346587,17567557,13065068,11882447,12113168,12063672,11397975,16538579,7198007,11786541,14300398,11809420,12848966,11317169,10496971,10974169,12869631,15621349,12227287,4540453,12843242,11964170,10765577,6824588,13013433,4221937,7377741,16259861,5683644,11924958,19320950,11752869,11674471,10939954,6497808,10874930,14100181,19628680,9701942,14042963,7582405,11324788,9513761,14445372,4444408,8397928,19363316,16543233,6358157,11454395,17224126,16449016,9977480,11947497,8808622,10976024,14733755,11773971,18871326,10579133,14643797,10973902,13568910,11396932,11569851,14375500,11093209,5925641,11991647,15380971,11573116,15108356,10269972,3531703,11141602,15373072,14461255,12173462,14461310,10037697,11540850,5593142,15904992,17383336,6906664,15539502,11488147,14858060,11886518,12199482,11909397,11954105,2951577,10120280,10249454,10119458,14164256,10506084,16241235,16818063,10109740,10350544,10494821,3961240,5957562,9578018,17069806,14746202,7871576,15288908,16898553,10017043,10831144,10869146,16927141,11524415,11297932,13382897,11523893,10571872,11958062,11957248,14737916,12079758,10241003,10734910,4980981,16262672,16946649,11730201,3270425,10704848,11744084,10121708,10648301,9550862,10575496,17159150,10229290,10627252,10189176,16270636,10315805,10237614,10581800,10312775,10117920,5255052,10151200,10202747,10530153,10087703,3875726,6847730,6316543,12201543,18057526,17150670,6001005,12004802,10170102,6004512,10271601,12379190,7819477,10076788,12214216,10236181,10235244,7440666,10284232,13518218,4278131,13261721,11593692,4274758,13104331,11174604,10410917,7597193,16339766,16050062,4519276,10063575,11924651,8438637,10654159,19621895,13382882,11845417,6344127,8527880,16606595,11111307,5218876,12038087,11974704,5362817,13617345,5391650,11086803,12190068,10437319,6844531,21017921,9889717,15971627,2595196,11169615,9774211,11430541,8330410,9853613,...; 
009- ~~袁慧斌,人工修改过 ~~
010- AISQL修改建议：真实SQL语法报错无法AI分析,MySQL 内部错误：(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ... at line 1") 
011- ~~explain表： ~~
012- ~~额外建议：IN 的内容太多了 ~~
013- ~~索引建议： ~~
014- ~~ ~~
2025-11-05 09:05:21, 由 陈莉珍 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
修改了 关闭日期，旧值为 ""，新值为 "2025-11-05 09:05:21"。
2025-11-05 13:36:21, 由 陈莉珍 编辑。
修改了 解决时效，旧值为 "198.72"，新值为 "5.00"。
修改了 上线时间，旧值为 "2025-11-04 15:47:20"，新值为 "2025-10-23 14:04:05"。
修改了 上线时效，旧值为 "198.72"，新值为 "5.00"。
修改了 解决日期，旧值为 "2025-11-04 15:47:20"，新值为 "2025-10-23 14:04:05"。

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

所属项目	技术中心-需求池
所属模块	数据智能数据工程
所属计划
所属迭代
Bug类型
严重程度	一般
优先级	P1
Bug状态	已关闭
业务部门	总经办
影响功能
开发责任人	叶嘉璇
测试责任人	叶嘉璇
解决时效	5
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2025-11-05 13:36:21
截止日期	0000-00-00
上线时间	2025-10-23 14:04:05
上线时效	5
操作系统
浏览器
关键词
抄送给

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

Bug的一生
其他相关

由谁创建	陈莉珍于 2025-10-23 09:04:05
影响环境	生产环境-业务反馈
由谁解决	叶嘉璇于 2025-10-23 14:04:05
解决版本	主干
解决方案	程序BUG
由谁关闭	陈莉珍于 2025-11-05 09:05:21
最后修改	陈莉珍于 2025-11-05 13:36:21

相关Bug