重现步骤

反馈人：吴荣发

问题1：

数据库：zhcxkj-center-product
节点ID：0e95197892a84afdb4a86b4eae5de8d6in01
查询时间：156.63
扫描行数：12646400.0
返回行数：48
一天执行次数： 2025-07-14
慢日志时间：2025-07-15
SQL语句：select 'id' , 'customer_id' , 'sku' , 'platform_id' , 'risk_level' , 'platform_type' , 'update_time' , 'update_by' , 'create_by' , 'create_time' , 'is_deleted' , 'site_code' FROM ? where ( update_time < replace ( '?' , '?' , '?' ) AND update_time >= replace ( '?' , '?' , '?' ) ) ;
真实SQL：select 'id','customer_id','sku','platform_id','risk_level','platform_type','update_time','update_by','create_by','create_time','is_deleted','site_code' from rb_product_risk_level_platform_country where (update_time= replace('2025-05-29 15:55:03','%',' '));
负责人参考：公用
('2025-07-14>

项目参考：java项目('2025-07-14>


('2025-07-14>

问题2：('2025-07-14>


数据库：zhcxkj-center-product
节点ID：1fbcbf228fc94da0b9ca8c7d48e0afcbin01
查询时间：294.616
扫描行数：2728680.0
返回行数：1040
一天执行次数： 2025-07-14
慢日志时间：2025-07-15
SQL语句：SELECT sku , risk_level FROM ? WHERE ( sku IN ( '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '
真实SQL：SELECT sku,risk_level FROM rb_product_risk_level_platform_country WHERE (sku IN ('9555871','9555977','11397514','15464267','11397514','3221336','17153094','15004358','3189662','3028933','13106281','4020634','8456972','6873983','17737521','17737618','9867081','15732607','7442523','3077386','10089254','10829299','3189662','17153094','7758215','13304106','4462552','4462595','4462604','17704766','6804858','2948261','13233015','13550430','4052960','7249278','16590616','7511221','11397514','16590616','11294326','1910276','7442523','11397514','15464267','9639191','4462595','4462604','4462552','11397514','5592432','17029152','17029169','1881565','17029152','17029169','13233015','13632947','17720555','17585912','18144482','14709712','14709874','17698871','10242646','9424853','13618420','13302026','5990963','17818780','18071850','2481899','15958389','10210685','16953239','2615125','2615151','3304057','7325333','7325360','13348419','13348813','13348853','13348901','13348930','13054309','16864450','17389291','13265957','13266037','10382438','10382516','18047223','17942369','18559471','17730421','17819074','16639723','16639765','18004037','18004209','4891289','7145681','2835767','7960210','6366460','4850127','8121649','11057516','10462428','10264623','13045707','11366310','13252701','13896516','6756473','6759177','3096879','16360596','16402951','13039502','13039637','13039675','13348419','13348813','13348853','13348901','13348930','17897854','17933940','18598438','3122725','7249278','14938640','17954160','7400250','15620436','15620558','6559078','8375088','10678855','17214277','17214321','10710206','10710306','15991023','16001941','17174679','11667603','16377497','10994249','15011207','14418314','14895796','17732159','17488471','11907568','10686065','7442523','14426273','10797938','8347855','15825248','10208864','6795255','6795434','6795435','6795436','6795437','2929296','13416670','18559471','10796799','6549556','17331223','13334220','14895787','3042761','16003534','10214945','10027622','11770115','12122425','2561602','13920042','13920121','13920163','3145263','3152531','12122425','16708160','14895796','3155208','3155259','5218412','6972035','2090314','8457981','16300286','7580943','14449393','14895796','8457981','3871213','17468042','8121649','8121835','17823783','3886064','6581385','11387646','12093075','17643549','15643630','16951693','16045359','16045384','17235452','17888463','14338789','2443660','2216110','17693631','17375915','16351555','3189662','2666557','3586716','7442523','15819534','8045255','17573221','14612107','14612150','14612151','5600283','8095862','10797938','14629472','7723548','6949803','6949928','7579705','7580547','7580581','18004037','18004209','14758870','7310699','7310797','7310815','3871213','16344909','16612376','17647898','14913754','14913843','17254038','3408954','14313479','9872700','16867355','16867389','6949803','6949928','4464880','17235452','17235478','14426273','13697601','13697689','4850127','2336625','2336694','3189662','17488471','8064561','8064829','8064882','3021344','3021401','16691440','17214277','17214321','10028718','10028786','10028800','6535250','6535727','6535728','2455593','2455898','2455911','2455919','16867355','16867389','4360694','7893591','17622520','4608589','4043781','9515163','9515224','17029152','17029169','2565302','3095863','12690585','12690636','12690637','12690638','10939831','5289991','12317625','12317736','12317737','12317738','16937260','17033395','4113142','4113319','4113341','8844102','17512639','8095862','2216110','4105849','4105958','4106027','3634096','4608589','7442523','2565302','3279492','8266023','4522311','5123374','5081070','13380844','13380985','13381061','7011129','4485094','4485244','4485245','4485246','13370110','13371520','13371521','7775698','13485007','14013739','10748012','10748096','10748108','8682759','8683442','8683443','8296200','15873690','16005912','17994585','16167699','16167733','14132231','10282206','16310473','13532610','13416670','17481601','18004037','18004209','17950231','18006645','18006710','4567691','16505250','5290080','4688147','2615125','2615151','3304057','6605763','16321005','17128033','10710420','12838628','10462428','16883760','17647898','5990963','13397065','17030453','9628847','17380791','17647898','14580267','14417595','14417702','2615125','2615151','3304057','17128033','17029152','17029169','17033395','13682426','17019283','7592079','6775696','6775649','11397514','17647898','2344769','3257040','11660485','11688178','8738406','16175951','16176266','9898990','17128033','7226634','5227417','2658403','5550465','2344769','14913754','14913843','17029152','17029169','17481601','9064684','8561565','4339191','10066210','3713797','10990618','17466677','13442677','14426617','15521306','3257040','10066210','7310699','7310797','7310815','16639567','16639716','16708160','8266023','14922414','14922510','17030453','2615125','2615151','3304057','15044759','9898990','15723312','17153196','7986933','7987159','15991023','16001941','6756473','5227417','14431236','14431372','6799069','7986933','7987159','2344769','14303426','17033395','8375088','11660485','11688178','17174679','16631150','16439322','15781580','13,'14488440','15044759','10298861','10298881','13151009','13166618','13166619','13411360','13411407','10286905','7533880','7534004','7534005','7534006','2615125','2615151','3304057','13561478','6346737','13303001','8212505','','17828085','15683523','17770339','16402951','15614760','18061750','18061778','13636328','13636400','13655984','16175000','16175095','16204211','16204255','16204256','4215518','4215579','9974031','9974350','16136271','17866631','14960954','14961123','16639765','1651304','17823783','13684819','17323809','17323886','17131930','11354602','3762204','13265593','13265632','2993828','2993897','6697094','6697095','2615125','2615151','3304057','6064480','6064509','6064516','4185521','4185536','12850303','11057516','8296200','9715280','7534445','8045255','7011129','3713797','17029152','17029169','18605152','18605797','18605820','18595084','17567335','17823783','16708160','6466668','16395031','16363467','17192840','17407483','17382787','17127097','16017913','17078969','17088687','17362795','8207872','4063483','10252105','5990799','5990963','3145263','3152531','10120672','10120767','14922414','14922510','2564927','16402951','16384320','8296200','16136271','9715280','15732607','10500224','15845212','16462816','3821252','5159444','2800637','3947553','7547460','12105046','13370110','13371520','13371521','14490546','19399677','12093075','11817375','11713455','11904694','12498209','13014377','17494825','11491379','16884980','9844933','9715280','10066210','10231500','10252105','10113759','10177436','10208864','14112065','15770796','14907413','16119892','15042187','10994249','16394512','11397514','17881743','16573404','10574312','18623833','10724729','11055321','10705893','17900189','11737109','12306674','9147793','10756530','18050633','14034594','14034630','2821320','2821390','2821395','2821401','11535935','10477631','10393934','19132000','17818780','18585393','17045902','14475636','18623855','3167296','7318895','10797938','1747334','6346737','16844550','9462366','17130212','16590616','17456802','15010952','7579705','7580547','7580581','17253350','15610709','14131135','17136022','14131109','18612696','7534445','8121835','6081391','6081393','11491379','15010952','17253350','15610709','7325333','7325360','4098931','6549556','4098931','7579705','7580547','7580581','10410399','17642557','17455816','17455982','15610709','5219496','18606701','12105046','17971443','18585849','18007453','13014377','12112354','18086052','11905159','17749733','17033395','17407483','17546198','16916470','17573338','17487351','17111767','16931002','16136271','16312422','16413356','16710256','16593514','14431236','14431372','16639723','16639765','14417595','14417702','11994545','12122575','12203329','12179948','8561565','9872700','2992150','8154355','8844102','14389692','10260641','14124055','8356945','9154936','8543481','13618420','13672997','10574312','9929567','3111711','10797841','8121835','14027053','14490546','13679692','3215256','5123374','13882953','10872581','10456327','10091840','15450471','14603876','14313477','15514258','9715280','15515771','15932307','16017913','16086464','10048852','16091448','15809399','10066210','15845116','10829299','15820363','13711674','15832408','14141482','10417167','15966935','14965538','10242646','10766138','15845212','3530354','19445569','7508691','7508793','7508794','5990799','5990963','2481899','10100275','10100357','2408518','2408555','2408560','8121649','4462552','7310699','7310797','7310815','10298861','10298881','4608589','2220590','2220649','2220651','2220657','10319388','10214945','6605497','1656126','3586716','3871213','6972035','2565302','4747955','8058442','5070707','8072830','7976367','7580943','10393934','10424939','8390641','8390712','10739183','10739285','16204211','16204255','16204256','17174679','17773833','14112065','14425820','3363579','6832793','3393180','6939957','7028657','7028698','7028714','7028725','7028774','7028798','7028817','6734804','19433161','19433211','2344769','11294326','5916048','5916323','5916324','5916325','5916326','5916328','5916329','16685863','16686050','16686096','16533895','16534071','16534092','2939633','2939839','2939897','17945034','17945180','17945212','17945242','17945254','17911804','17911934','16310473','16310499','13587137','13587231','13487524','13487548','13501138','18061750','18061778','10571669','10571903','5144501','5144722','3079403','3079404','6788025','7229039','8347855','4668829','8251940','3084446','18065574','5054604','17292831','16951693','6425561','12415461','13249356','11894646','11308631','11349742','11349779','7533880','7534004','7534005','7534006','16403087','16403152','16768669','16768672','17971443','19248996','17033395','19136750','17362795','19400239','12604917','16384136','8326573','10526352','16136271','5159444','1656126','4056979','2647237','19417390','16367017','17713582','17698919','18716456','13665313','17945034','17945180','17945212','17945242','17945254','18136840','18687775','14475636','14719679','14112065','8251940','19489740','19533197','16144855','16420489...;
负责人参考：公用
项目参考：java项目

('2025-07-14>

历史记录  
  1. 2025-07-15 18:25:27, 由 陈莉珍 创建。
  2. 2025-07-15 18:32:39, 由 陈莉珍 编辑。
    修改了 所属项目，旧值为 "51"，新值为 "55"。
    修改了 所属模块，旧值为 "0"，新值为 "1901"。
    修改了 业务部门，旧值为 "0"，新值为 "2"。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 重现步骤，区别为：
    001- 反馈人：吴荣发
    001+ 反馈人：吴荣发
    002- 数据库：zhcxkj-center-product
    002+ 问题1：
    003- 节点ID：0e95197892a84afdb4a86b4eae5de8d6in01
    003+ 数据库：zhcxkj-center-product
    004- 查询时间：156.63
    004+ 节点ID：0e95197892a84afdb4a86b4eae5de8d6in01 查询时间：156.63 扫描行数：12646400.0 返回行数：48 一天执行次数： 2025-07-14 慢日志时间：2025-07-15 SQL语句：select 'id' , 'customer_id' , 'sku' , 'platform_id' , 'risk_level' , 'platform_type' , 'update_time' , 'update_by' , 'create_by' , 'create_time' , 'is_deleted' , 'site_code' FROM ? where ( update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= replace ( '?' , '?' , '?' ) ) ; 真实SQL：select 'id','customer_id','sku','platform_id','risk_level','platform_type','update_time','update_by','create_by','create_time','is_deleted','site_code' from rb_product_risk_level_platform_country where (update_time= replace('2025-05-29 15:55:03','%',' ')); 负责人参考：公用('2025-07-14&gt;
    005- 扫描行数：12646400.0
    005+ 项目参考：java项目('2025-07-14&gt;
    006- 返回行数：48
    006+ ('2025-07-14&gt;
    007- 一天执行次数： 2025-07-14
    007+ 问题2：('2025-07-14&gt;
    008- 慢日志时间：2025-07-15
    008+ 数据库：zhcxkj-center-product节点ID：1fbcbf228fc94da0b9ca8c7d48e0afcbin01查询时间：294.616扫描行数：2728680.0返回行数：1040一天执行次数： 2025-07-14慢日志时间：2025-07-15SQL语句：SELECT
    009- SQL语句：select 'id' , 'customer_id' , 'sku' , 'platform_id' , 'risk_level' , 'platform_type' , 'update_time' , 'update_by' , 'create_by' , 'create_time' , 'is_deleted' , 'site_code' FROM ? where ( update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= replace ( '?' , '?' , '?' ) ) ;
    009+ sku , risk_level FROM ? WHERE ( sku IN ( '?' , '?' , '?' , '?' , '?' ,
    010- 真实SQL：select 'id','customer_id','sku','platform_id','risk_level','platform_type','update_time','update_by','create_by','create_time','is_deleted','site_code' from rb_product_risk_level_platform_country where (update_time= replace('2025-05-29 15:55:03','%',' '));
    010+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    011- 负责人参考：公用
    011+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    012- 项目参考：java项目
    012+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    013-
    013+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    014+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    015+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    016+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    017+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    018+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    019+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    020+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    021+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    022+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    023+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    024+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    025+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    026+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    027+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    028+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    029+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    030+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    031+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    032+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    033+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    034+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    035+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    036+ '?' , '?' , '真实SQL：SELECT sku,risk_level FROM
    037+ rb_product_risk_level_platform_country WHERE (sku IN
    038+ ('9555871','9555977','11397514','15464267','11397514','3221336','17153094','15004358','3189662','3028933','13106281','4020634','8456972','6873983','17737521','17737618','9867081','15732607','7442523','3077386','10089254','10829299','3189662','17153094','7758215','13304106','4462552','4462595','4462604','17704766','6804858','2948261','13233015','13550430','4052960','7249278','16590616','7511221','11397514','16590616','11294326','1910276','7442523','11397514','15464267','9639191','4462595','4462604','4462552','11397514','5592432','17029152','17029169','1881565','17029152','17029169','13233015','13632947','17720555','17585912','18144482','14709712','14709874','17698871','10242646','9424853','13618420','13302026','5990963','17818780','18071850','2481899','15958389','10210685','16953239','2615125','2615151','3304057','7325333','7325360','13348419','13348813','13348853','13348901','13348930','13054309','16864450','17389291','13265957','13266037','10382438','10382516','18047223','17942369','18559471','17730421','17819074','16639723','16639765','18004037','18004209','4891289','7145681','2835767','7960210','6366460','4850127','8121649','11057516','10462428','10264623','13045707','11366310','13252701','13896516','6756473','6759177','3096879','16360596','16402951','13039502','13039637','13039675','13348419','13348813','13348853','13348901','13348930','17897854','17933940','18598438','3122725','7249278','14938640','17954160','7400250','15620436','15620558','6559078','8375088','10678855','17214277','17214321','10710206','10710306','15991023','16001941','17174679','11667603','16377497','10994249','15011207','14418314','14895796','17732159','17488471','11907568','10686065','7442523','14426273','10797938','8347855','15825248','10208864','6795255','6795434','6795435','6795436','6795437','2929296','13416670','18559471','10796799','6549556','17331223','13334220','14895787','3042761','16003534','10214945','10027622','11770115','12122425','2561602','13920042','13920121','13920163','3145263','3152531','12122425','16708160','14895796','3155208','3155259','5218412','6972035','2090314','8457981','16300286','7580943','14449393','14895796','8457981','3871213','17468042','8121649','8121835','17823783','3886064','6581385','11387646','12093075','17643549','15643630','16951693','16045359','16045384','17235452','17888463','14338789','2443660','2216110','17693631','17375915','16351555','3189662','2666557','3586716','7442523','15819534','8045255','17573221','14612107','14612150','14612151','5600283','8095862','10797938','14629472','7723548','6949803','6949928','7579705','7580547','7580581','18004037','18004209','14758870','7310699','7310797','7310815','3871213','16344909','16612376','17647898','14913754','14913843','17254038','3408954','14313479','9872700','16867355','16867389','6949803','6949928','4464880','17235452','17235478','14426273','13697601','13697689','4850127','2336625','2336694','3189662','17488471','8064561','8064829','8064882','3021344','3021401','16691440','17214277','17214321','10028718','10028786','10028800','6535250','6535727','6535728','2455593','2455898','2455911','2455919','16867355','16867389','4360694','7893591','17622520','4608589','4043781','9515163','9515224','17029152','17029169','2565302','3095863','12690585','12690636','12690637','12690638','10939831','5289991','12317625','12317736','12317737','12317738','16937260','17033395','4113142','4113319','4113341','8844102','17512639','8095862','2216110','4105849','4105958','4106027','3634096','4608589','7442523','2565302','3279492','8266023','4522311','5123374','5081070','13380844','13380985','13381061','7011129','4485094','4485244','4485245','4485246','13370110','13371520','13371521','7775698','13485007','14013739','10748012','10748096','10748108','8682759','8683442','8683443','8296200','15873690','16005912','17994585','16167699','16167733','14132231','10282206','16310473','13532610','13416670','17481601','18004037','18004209','17950231','18006645','18006710','4567691','16505250','5290080','4688147','2615125','2615151','3304057','6605763','16321005','17128033','10710420','12838628','10462428','16883760','17647898','5990963','13397065','17030453','9628847','17380791','17647898','14580267','14417595','14417702','2615125','2615151','3304057','17128033','17029152','17029169','17033395','13682426','17019283','7592079','6775696','6775649','11397514','17647898','2344769','3257040','11660485','11688178','8738406','16175951','16176266','9898990','17128033','7226634','5227417','2658403','5550465','2344769','14913754','14913843','17029152','17029169','17481601','9064684','8561565','4339191','10066210','3713797','10990618','17466677','13442677','14426617','15521306','3257040','10066210','7310699','7310797','7310815','16639567','16639716','16708160','8266023','14922414','14922510','17030453','2615125','2615151','3304057','15044759','9898990','15723312','17153196','7986933','7987159','15991023','16001941','6756473','5227417','14431236','14431372','6799069','7986933','7987159','2344769','14303426','17033395','8375088','11660485','11688178','17174679','16631150','16439322','15781580','13,'14488440','15044759','10298861','10298881','13151009','13166618','13166619','13411360','13411407','10286905','7533880','7534004','7534005','7534006','2615125','2615151','3304057','13561478','6346737','13303001','8212505','','17828085','15683523','17770339','16402951','15614760','18061750','18061778','13636328','13636400','13655984','16175000','16175095','16204211','16204255','16204256','4215518','4215579','9974031','9974350','16136271','17866631','14960954','14961123','16639765','1651304','17823783','13684819','17323809','17323886','17131930','11354602','3762204','13265593','13265632','2993828','2993897','6697094','6697095','2615125','2615151','3304057','6064480','6064509','6064516','4185521','4185536','12850303','11057516','8296200','9715280','7534445','8045255','7011129','3713797','17029152','17029169','18605152','18605797','18605820','18595084','17567335','17823783','16708160','6466668','16395031','16363467','17192840','17407483','17382787','17127097','16017913','17078969','17088687','17362795','8207872','4063483','10252105','5990799','5990963','3145263','3152531','10120672','10120767','14922414','14922510','2564927','16402951','16384320','8296200','16136271','9715280','15732607','10500224','15845212','16462816','3821252','5159444','2800637','3947553','7547460','12105046','13370110','13371520','13371521','14490546','19399677','12093075','11817375','11713455','11904694','12498209','13014377','17494825','11491379','16884980','9844933','9715280','10066210','10231500','10252105','10113759','10177436','10208864','14112065','15770796','14907413','16119892','15042187','10994249','16394512','11397514','17881743','16573404','10574312','18623833','10724729','11055321','10705893','17900189','11737109','12306674','9147793','10756530','18050633','14034594','14034630','2821320','2821390','2821395','2821401','11535935','10477631','10393934','19132000','17818780','18585393','17045902','14475636','18623855','3167296','7318895','10797938','1747334','6346737','16844550','9462366','17130212','16590616','17456802','15010952','7579705','7580547','7580581','17253350','15610709','14131135','17136022','14131109','18612696','7534445','8121835','6081391','6081393','11491379','15010952','17253350','15610709','7325333','7325360','4098931','6549556','4098931','7579705','7580547','7580581','10410399','17642557','17455816','17455982','15610709','5219496','18606701','12105046','17971443','18585849','18007453','13014377','12112354','18086052','11905159','17749733','17033395','17407483','17546198','16916470','17573338','17487351','17111767','16931002','16136271','16312422','16413356','16710256','16593514','14431236','14431372','16639723','16639765','14417595','14417702','11994545','12122575','12203329','12179948','8561565','9872700','2992150','8154355','8844102','14389692','10260641','14124055','8356945','9154936','8543481','13618420','13672997','10574312','9929567','3111711','10797841','8121835','14027053','14490546','13679692','3215256','5123374','13882953','10872581','10456327','10091840','15450471','14603876','14313477','15514258','9715280','15515771','15932307','16017913','16086464','10048852','16091448','15809399','10066210','15845116','10829299','15820363','13711674','15832408','14141482','10417167','15966935','14965538','10242646','10766138','15845212','3530354','19445569','7508691','7508793','7508794','5990799','5990963','2481899','10100275','10100357','2408518','2408555','2408560','8121649','4462552','7310699','7310797','7310815','10298861','10298881','4608589','2220590','2220649','2220651','2220657','10319388','10214945','6605497','1656126','3586716','3871213','6972035','2565302','4747955','8058442','5070707','8072830','7976367','7580943','10393934','10424939','8390641','8390712','10739183','10739285','16204211','16204255','16204256','17174679','17773833','14112065','14425820','3363579','6832793','3393180','6939957','7028657','7028698','7028714','7028725','7028774','7028798','7028817','6734804','19433161','19433211','2344769','11294326','5916048','5916323','5916324','5916325','5916326','5916328','5916329','16685863','16686050','16686096','16533895','16534071','16534092','2939633','2939839','2939897','17945034','17945180','17945212','17945242','17945254','17911804','17911934','16310473','16310499','13587137','13587231','13487524','13487548','13501138','18061750','18061778','10571669','10571903','5144501','5144722','3079403','3079404','6788025','7229039','8347855','4668829','8251940','3084446','18065574','5054604','17292831','16951693','6425561','12415461','13249356','11894646','11308631','11349742','11349779','7533880','7534004','7534005','7534006','16403087','16403152','16768669','16768672','17971443','19248996','17033395','19136750','17362795','19400239','12604917','16384136','8326573','10526352','16136271','5159444','1656126','4056979','2647237','19417390','16367017','17713582','17698919','18716456','13665313','17945034','17945180','17945212','17945242','17945254','18136840','18687775','14475636','14719679','14112065','8251940','19489740','19533197','16144855','16420489...;负责人参考：公用项目参考：java项目('2025-07-14&gt;
    001- 反馈人：吴荣发<br />
    001+ <p>反馈人：吴荣发</p>
    002- 数据库：zhcxkj-center-product<br />
    002+ <p>问题1：</p>
    003- 节点ID：0e95197892a84afdb4a86b4eae5de8d6in01<br />
    003+ 数据库：zhcxkj-center-product<br />
    004- 查询时间：156.63<br />
    004+ 节点ID：0e95197892a84afdb4a86b4eae5de8d6in01<br /> 查询时间：156.63<br /> 扫描行数：12646400.0<br /> 返回行数：48<br /> 一天执行次数： 2025-07-14<br /> 慢日志时间：2025-07-15<br /> SQL语句：select 'id' , 'customer_id' , 'sku' , 'platform_id' , 'risk_level' , 'platform_type' , 'update_time' , 'update_by' , 'create_by' , 'create_time' , 'is_deleted' , 'site_code' FROM ? where ( update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= replace ( '?' , '?' , '?' ) ) ;<br /> 真实SQL：select 'id','customer_id','sku','platform_id','risk_level','platform_type','update_time','update_by','create_by','create_time','is_deleted','site_code' from rb_product_risk_level_platform_country where (update_time= replace('2025-05-29 15:55:03','%',' '));<br /> 负责人参考：公用<br />('2025-07-14&gt;
    005- 扫描行数：12646400.0<br />
    005+ <p> 项目参考：java项目('2025-07-14&gt;</p>
    006- 返回行数：48<br />
    006+ <p><br />('2025-07-14&gt;</p>
    007- 一天执行次数： 2025-07-14<br />
    007+ <p>问题2：('2025-07-14&gt;</p>
    008- 慢日志时间：2025-07-15<br />
    008+ <p><br />数据库：zhcxkj-center-product<br />节点ID：1fbcbf228fc94da0b9ca8c7d48e0afcbin01<br />查询时间：294.616<br />扫描行数：2728680.0<br />返回行数：1040<br />一天执行次数： 2025-07-14<br />慢日志时间：2025-07-15<br />SQL语句：SELECT
    009- SQL语句：select 'id' , 'customer_id' , 'sku' , 'platform_id' , 'risk_level' , 'platform_type' , 'update_time' , 'update_by' , 'create_by' , 'create_time' , 'is_deleted' , 'site_code' FROM ? where ( update_time &lt; replace ( '?' , '?' , '?' ) AND update_time &gt;= replace ( '?' , '?' , '?' ) ) ;<br />
    009+ sku , risk_level FROM ? WHERE ( sku IN ( '?' , '?' , '?' , '?' , '?' ,
    010- 真实SQL：select 'id','customer_id','sku','platform_id','risk_level','platform_type','update_time','update_by','create_by','create_time','is_deleted','site_code' from rb_product_risk_level_platform_country where (update_time<replace('2025-07-14 08:00:22','%','="" ')="" and="" update_time="">= replace('2025-05-29 15:55:03','%',' '));<br />
    010+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    011- 负责人参考：公用<br />
    011+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    012- 项目参考：java项目<br />
    012+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    013- </replace('2025-07-14>
    013+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    014+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    015+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    016+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    017+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    018+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    019+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    020+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    021+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    022+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    023+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    024+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    025+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    026+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    027+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    028+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    029+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    030+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    031+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    032+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    033+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    034+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    035+ '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' , '?' ,
    036+ '?' , '?' , '<br />真实SQL：SELECT sku,risk_level FROM
    037+ rb_product_risk_level_platform_country WHERE (sku IN
    038+ ('9555871','9555977','11397514','15464267','11397514','3221336','17153094','15004358','3189662','3028933','13106281','4020634','8456972','6873983','17737521','17737618','9867081','15732607','7442523','3077386','10089254','10829299','3189662','17153094','7758215','13304106','4462552','4462595','4462604','17704766','6804858','2948261','13233015','13550430','4052960','7249278','16590616','7511221','11397514','16590616','11294326','1910276','7442523','11397514','15464267','9639191','4462595','4462604','4462552','11397514','5592432','17029152','17029169','1881565','17029152','17029169','13233015','13632947','17720555','17585912','18144482','14709712','14709874','17698871','10242646','9424853','13618420','13302026','5990963','17818780','18071850','2481899','15958389','10210685','16953239','2615125','2615151','3304057','7325333','7325360','13348419','13348813','13348853','13348901','13348930','13054309','16864450','17389291','13265957','13266037','10382438','10382516','18047223','17942369','18559471','17730421','17819074','16639723','16639765','18004037','18004209','4891289','7145681','2835767','7960210','6366460','4850127','8121649','11057516','10462428','10264623','13045707','11366310','13252701','13896516','6756473','6759177','3096879','16360596','16402951','13039502','13039637','13039675','13348419','13348813','13348853','13348901','13348930','17897854','17933940','18598438','3122725','7249278','14938640','17954160','7400250','15620436','15620558','6559078','8375088','10678855','17214277','17214321','10710206','10710306','15991023','16001941','17174679','11667603','16377497','10994249','15011207','14418314','14895796','17732159','17488471','11907568','10686065','7442523','14426273','10797938','8347855','15825248','10208864','6795255','6795434','6795435','6795436','6795437','2929296','13416670','18559471','10796799','6549556','17331223','13334220','14895787','3042761','16003534','10214945','10027622','11770115','12122425','2561602','13920042','13920121','13920163','3145263','3152531','12122425','16708160','14895796','3155208','3155259','5218412','6972035','2090314','8457981','16300286','7580943','14449393','14895796','8457981','3871213','17468042','8121649','8121835','17823783','3886064','6581385','11387646','12093075','17643549','15643630','16951693','16045359','16045384','17235452','17888463','14338789','2443660','2216110','17693631','17375915','16351555','3189662','2666557','3586716','7442523','15819534','8045255','17573221','14612107','14612150','14612151','5600283','8095862','10797938','14629472','7723548','6949803','6949928','7579705','7580547','7580581','18004037','18004209','14758870','7310699','7310797','7310815','3871213','16344909','16612376','17647898','14913754','14913843','17254038','3408954','14313479','9872700','16867355','16867389','6949803','6949928','4464880','17235452','17235478','14426273','13697601','13697689','4850127','2336625','2336694','3189662','17488471','8064561','8064829','8064882','3021344','3021401','16691440','17214277','17214321','10028718','10028786','10028800','6535250','6535727','6535728','2455593','2455898','2455911','2455919','16867355','16867389','4360694','7893591','17622520','4608589','4043781','9515163','9515224','17029152','17029169','2565302','3095863','12690585','12690636','12690637','12690638','10939831','5289991','12317625','12317736','12317737','12317738','16937260','17033395','4113142','4113319','4113341','8844102','17512639','8095862','2216110','4105849','4105958','4106027','3634096','4608589','7442523','2565302','3279492','8266023','4522311','5123374','5081070','13380844','13380985','13381061','7011129','4485094','4485244','4485245','4485246','13370110','13371520','13371521','7775698','13485007','14013739','10748012','10748096','10748108','8682759','8683442','8683443','8296200','15873690','16005912','17994585','16167699','16167733','14132231','10282206','16310473','13532610','13416670','17481601','18004037','18004209','17950231','18006645','18006710','4567691','16505250','5290080','4688147','2615125','2615151','3304057','6605763','16321005','17128033','10710420','12838628','10462428','16883760','17647898','5990963','13397065','17030453','9628847','17380791','17647898','14580267','14417595','14417702','2615125','2615151','3304057','17128033','17029152','17029169','17033395','13682426','17019283','7592079','6775696','6775649','11397514','17647898','2344769','3257040','11660485','11688178','8738406','16175951','16176266','9898990','17128033','7226634','5227417','2658403','5550465','2344769','14913754','14913843','17029152','17029169','17481601','9064684','8561565','4339191','10066210','3713797','10990618','17466677','13442677','14426617','15521306','3257040','10066210','7310699','7310797','7310815','16639567','16639716','16708160','8266023','14922414','14922510','17030453','2615125','2615151','3304057','15044759','9898990','15723312','17153196','7986933','7987159','15991023','16001941','6756473','5227417','14431236','14431372','6799069','7986933','7987159','2344769','14303426','17033395','8375088','11660485','11688178','17174679','16631150','16439322','15781580','13,'14488440','15044759','10298861','10298881','13151009','13166618','13166619','13411360','13411407','10286905','7533880','7534004','7534005','7534006','2615125','2615151','3304057','13561478','6346737','13303001','8212505','','17828085','15683523','17770339','16402951','15614760','18061750','18061778','13636328','13636400','13655984','16175000','16175095','16204211','16204255','16204256','4215518','4215579','9974031','9974350','16136271','17866631','14960954','14961123','16639765','1651304','17823783','13684819','17323809','17323886','17131930','11354602','3762204','13265593','13265632','2993828','2993897','6697094','6697095','2615125','2615151','3304057','6064480','6064509','6064516','4185521','4185536','12850303','11057516','8296200','9715280','7534445','8045255','7011129','3713797','17029152','17029169','18605152','18605797','18605820','18595084','17567335','17823783','16708160','6466668','16395031','16363467','17192840','17407483','17382787','17127097','16017913','17078969','17088687','17362795','8207872','4063483','10252105','5990799','5990963','3145263','3152531','10120672','10120767','14922414','14922510','2564927','16402951','16384320','8296200','16136271','9715280','15732607','10500224','15845212','16462816','3821252','5159444','2800637','3947553','7547460','12105046','13370110','13371520','13371521','14490546','19399677','12093075','11817375','11713455','11904694','12498209','13014377','17494825','11491379','16884980','9844933','9715280','10066210','10231500','10252105','10113759','10177436','10208864','14112065','15770796','14907413','16119892','15042187','10994249','16394512','11397514','17881743','16573404','10574312','18623833','10724729','11055321','10705893','17900189','11737109','12306674','9147793','10756530','18050633','14034594','14034630','2821320','2821390','2821395','2821401','11535935','10477631','10393934','19132000','17818780','18585393','17045902','14475636','18623855','3167296','7318895','10797938','1747334','6346737','16844550','9462366','17130212','16590616','17456802','15010952','7579705','7580547','7580581','17253350','15610709','14131135','17136022','14131109','18612696','7534445','8121835','6081391','6081393','11491379','15010952','17253350','15610709','7325333','7325360','4098931','6549556','4098931','7579705','7580547','7580581','10410399','17642557','17455816','17455982','15610709','5219496','18606701','12105046','17971443','18585849','18007453','13014377','12112354','18086052','11905159','17749733','17033395','17407483','17546198','16916470','17573338','17487351','17111767','16931002','16136271','16312422','16413356','16710256','16593514','14431236','14431372','16639723','16639765','14417595','14417702','11994545','12122575','12203329','12179948','8561565','9872700','2992150','8154355','8844102','14389692','10260641','14124055','8356945','9154936','8543481','13618420','13672997','10574312','9929567','3111711','10797841','8121835','14027053','14490546','13679692','3215256','5123374','13882953','10872581','10456327','10091840','15450471','14603876','14313477','15514258','9715280','15515771','15932307','16017913','16086464','10048852','16091448','15809399','10066210','15845116','10829299','15820363','13711674','15832408','14141482','10417167','15966935','14965538','10242646','10766138','15845212','3530354','19445569','7508691','7508793','7508794','5990799','5990963','2481899','10100275','10100357','2408518','2408555','2408560','8121649','4462552','7310699','7310797','7310815','10298861','10298881','4608589','2220590','2220649','2220651','2220657','10319388','10214945','6605497','1656126','3586716','3871213','6972035','2565302','4747955','8058442','5070707','8072830','7976367','7580943','10393934','10424939','8390641','8390712','10739183','10739285','16204211','16204255','16204256','17174679','17773833','14112065','14425820','3363579','6832793','3393180','6939957','7028657','7028698','7028714','7028725','7028774','7028798','7028817','6734804','19433161','19433211','2344769','11294326','5916048','5916323','5916324','5916325','5916326','5916328','5916329','16685863','16686050','16686096','16533895','16534071','16534092','2939633','2939839','2939897','17945034','17945180','17945212','17945242','17945254','17911804','17911934','16310473','16310499','13587137','13587231','13487524','13487548','13501138','18061750','18061778','10571669','10571903','5144501','5144722','3079403','3079404','6788025','7229039','8347855','4668829','8251940','3084446','18065574','5054604','17292831','16951693','6425561','12415461','13249356','11894646','11308631','11349742','11349779','7533880','7534004','7534005','7534006','16403087','16403152','16768669','16768672','17971443','19248996','17033395','19136750','17362795','19400239','12604917','16384136','8326573','10526352','16136271','5159444','1656126','4056979','2647237','19417390','16367017','17713582','17698919','18716456','13665313','17945034','17945180','17945212','17945242','17945254','18136840','18687775','14475636','14719679','14112065','8251940','19489740','19533197','16144855','16420489...;<br />负责人参考：公用<br />项目参考：java项目<br /><br />('2025-07-14&gt;</p>
  3. 2025-07-16 19:18:34, 由 张星 指派给 陈莉珍。
    修改了 指派给，旧值为 "zhangxing"，新值为 "chenlizhen"。
  4. 2025-07-17 17:58:01, 由 彭章权 指派给 陈莉珍。
    不是侵权组的的sql
  5. 2025-07-17 19:57:09, 由 陈莉珍 编辑。
    修改了 所属项目，旧值为 "55"，新值为 "51"。
    修改了 所属模块，旧值为 "1901"，新值为 "1868"。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 重现步骤，区别为：
    005- 项目参考：java项目('2025-07-14&gt;
    005+ 项目参考：java项目('2025-07-14&gt;
    005- <p> 项目参考：java项目('2025-07-14&gt;</p>
    005+ <p>项目参考：java项目('2025-07-14&gt;</p>
  6. 2025-07-18 11:40:15, 由 陈莉珍 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2025-07-18 11:40:09"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "chenlizhen"。
  7. 2025-07-18 11:40:48, 由 陈莉珍 编辑。
    修改了 开发责任人，旧值为 ""，新值为 "renfangtao"。
    修改了 测试责任人，旧值为 ""，新值为 "renfangtao"。
    修改了 解决时效 ，旧值为 "0"，新值为 "65.25"。
    修改了 上线时间 ，旧值为 "0000-00-00 00:00:00"，新值为 "2025-07-17 14:00"。
    修改了 上线时效 ，旧值为 "-1"，新值为 "43.58"。
  8. 2025-07-18 11:40:51, 由 陈莉珍 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-07-18 11:40:51"。
  9. 2025-08-07 16:12:14, 由 陈莉珍 编辑。
    修改了 上线时间，旧值为 "2025-07-17 14:00:00"，新值为 "2025-07-16 18:30"。
    修改了 上线时效，旧值为 "43.58"，新值为 "24.08"。
所属项目 技术中心-需求池
所属模块 多平台   Aliexpress
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 任芳涛
测试责任人 任芳涛
解决时效 65.25
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-08-07 16:12:14
截止日期 0000-00-00
上线时间 2025-07-16 18:30:00
上线时效 24.08
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-07-15 18:25:27
影响环境 生产环境-业务反馈
由谁解决 陈莉珍 于 2025-07-18 11:40:09
解决版本 主干
解决方案 性能问题
由谁关闭 陈莉珍 于 2025-07-18 11:40:51
最后修改 陈莉珍 于 2025-08-07 16:12:14
相关Bug