重现步骤
反馈人：吴荣发
数据库：zhcxkj_center_listing_comprehensive
节点ID：497fd948de9643998944407f361dd881in01
查询时间：118.088
扫描行数：6228110.0
返回行数：74
一天执行次数： 300.0
慢日志时间：2025-07-21
指纹：7d892d822d31ebfeaf678e57f0361113
SQL语句：SELECT Id AS Id , ? AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST ( Status AS CHAR ) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , ? AS IsSyncSuccess , ? AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id = ? ) ORDER BY Id LIMIT ? , ? ;
真实SQL：SELECT Id AS Id , 1 AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST(Status AS CHAR) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , 1 AS IsSyncSuccess , 2 AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id =28058) ORDER BY Id LIMIT 4800,300;
负责人参考：蔡俊伟
项目参考：java项目
历史记录  
  1. 2025-07-21 13:45:09, 由 陈莉珍 创建。
  2. 2025-07-21 14:49:51, 由 李乐同 指派给 胡晓龙。
    修改了 指派给，旧值为 "caijunwei"，新值为 "huxiaolong"。
  3. 2025-07-21 14:52:36, 由 李乐同 指派给 王金锋。
    修改了 指派给，旧值为 "huxiaolong"，新值为 "wangjinfeng"。
  4. 2025-07-22 16:09:25, 由 王金锋 指派给 李乐同。
    修改了 指派给，旧值为 "wangjinfeng"，新值为 "liletong"。

    这个不是JAVA项目中的表

  5. 2025-07-22 16:12:37, 由 李乐同 指派给 韦思成。
    修改了 指派给，旧值为 "liletong"，新值为 "weisicheng"。
  6. 2025-07-22 18:18:49, 由 韦思成 解决，方案为 历史bug（180天以上） 。
    修改了 解决方案，旧值为 ""，新值为 "history"。
    修改了 解决版本，旧值为 ""，新值为 "trunk"。
    修改了 解决日期，旧值为 ""，新值为 "2025-07-22 18:18:02"。
    修改了 指派给 ，旧值为 "weisicheng"，新值为 "chenlizhen"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "weisicheng"。

    增加更新时间查询条件，如下：

  7. 2025-07-23 09:00:18, 由 陈莉珍 编辑。
    修改了 所属模块 ，旧值为 "0"，新值为 "1874"。
    修改了 业务部门 ，旧值为 "0"，新值为 "2"。
    修改了 测试责任人，旧值为 ""，新值为 "weisicheng"。
    修改了 解决时效 ，旧值为 "0"，新值为 "28.55"。
    修改了 重现步骤 ，区别为：
    001- 反馈人：吴荣发
    001+ 反馈人：吴荣发 数据库：zhcxkj_center_listing_comprehensive 节点ID：497fd948de9643998944407f361dd881in01 查询时间：118.088 扫描行数：6228110.0 返回行数：74 一天执行次数： 300.0 慢日志时间：2025-07-21 指纹：7d892d822d31ebfeaf678e57f0361113 SQL语句：SELECT Id AS Id , ? AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST ( Status AS CHAR ) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , ? AS IsSyncSuccess , ? AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id = ? ) ORDER BY Id LIMIT ? , ? ; 真实SQL：SELECT Id AS Id , 1 AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST(Status AS CHAR) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , 1 AS IsSyncSuccess , 2 AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id =28058) ORDER BY Id LIMIT 4800,300; 负责人参考：蔡俊伟 项目参考：java项目
    002- 数据库：zhcxkj_center_listing_comprehensive
    003- 节点ID：497fd948de9643998944407f361dd881in01
    004- 查询时间：118.088
    005- 扫描行数：6228110.0
    006- 返回行数：74
    007- 一天执行次数： 300.0
    008- 慢日志时间：2025-07-21
    009- 指纹：7d892d822d31ebfeaf678e57f0361113
    010- SQL语句：SELECT Id AS Id , ? AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST ( Status AS CHAR ) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , ? AS IsSyncSuccess , ? AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id = ? ) ORDER BY Id LIMIT ? , ? ;
    011- 真实SQL：SELECT Id AS Id , 1 AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST(Status AS CHAR) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , 1 AS IsSyncSuccess , 2 AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id =28058) ORDER BY Id LIMIT 4800,300;
    012- 负责人参考：蔡俊伟
    013- 项目参考：java项目
    001- 反馈人：吴荣发<br />
    001+ 反馈人：吴荣发<br /> 数据库：zhcxkj_center_listing_comprehensive<br /> 节点ID：497fd948de9643998944407f361dd881in01<br /> 查询时间：118.088<br /> 扫描行数：6228110.0<br /> 返回行数：74<br /> 一天执行次数： 300.0<br /> 慢日志时间：2025-07-21<br /> 指纹：7d892d822d31ebfeaf678e57f0361113<br /> SQL语句：SELECT Id AS Id , ? AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST ( Status AS CHAR ) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , ? AS IsSyncSuccess , ? AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id = ? ) ORDER BY Id LIMIT ? , ? ;<br /> 真实SQL：SELECT Id AS Id , 1 AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST(Status AS CHAR) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , 1 AS IsSyncSuccess , 2 AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id =28058) ORDER BY Id LIMIT 4800,300;<br /> 负责人参考：蔡俊伟<br /> 项目参考：java项目<br />
    002- 数据库：zhcxkj_center_listing_comprehensive<br />
    003- 节点ID：497fd948de9643998944407f361dd881in01<br />
    004- 查询时间：118.088<br />
    005- 扫描行数：6228110.0<br />
    006- 返回行数：74<br />
    007- 一天执行次数： 300.0<br />
    008- 慢日志时间：2025-07-21<br />
    009- 指纹：7d892d822d31ebfeaf678e57f0361113<br />
    010- SQL语句：SELECT Id AS Id , ? AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST ( Status AS CHAR ) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , ? AS IsSyncSuccess , ? AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id = ? ) ORDER BY Id LIMIT ? , ? ;<br />
    011- 真实SQL：SELECT Id AS Id , 1 AS CustomerId , Source_Id AS OrderSourceIdByLong , Site_Id AS SiteId , Sku AS Sku , Source_Sku AS SellerSku , Pf_Global_Listing_Id AS ProductId , Pf_Listing_Id AS SiteProductId , sale_price AS Price , Stock AS Quantity , Category_Id AS CategoryId , Publish_Time AS PublishTime , Update_Time AS UpdateTime , pf_online_time AS DateCreated , logistic_type AS LogisticType , Title AS SiteTitle , CAST(Status AS CHAR) AS Status , original_price AS OriginalPrice , sub_status AS SubStatus , 1 AS IsSyncSuccess , 2 AS SyncType FROM T_Listing_Mercadolibre WHERE ( Source_Id =28058) ORDER BY Id LIMIT 4800,300;<br />
    012- 负责人参考：蔡俊伟<br />
    013- 项目参考：java项目<br />
  8. 2025-07-23 09:00:20, 由 陈莉珍 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-07-23 09:00:20"。
所属项目 技术中心-需求池
所属模块 多平台   mercado
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 韦思成
测试责任人 韦思成
解决时效 28.55
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-07-23 09:00:20
截止日期 0000-00-00
上线时间 2025-07-22 18:20:00
上线时效 28.58
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-07-21 13:45:09
影响环境 生产环境-业务反馈
由谁解决 韦思成 于 2025-07-22 18:18:02
解决版本 主干
解决方案 历史bug（180天以上）
由谁关闭 陈莉珍 于 2025-07-23 09:00:20
最后修改 陈莉珍 于 2025-07-23 09:00:20
相关Bug