修改了
所属模块 ,旧值为 "0",新值为 "1932"。
修改了
业务部门 ,旧值为 "0",新值为 "2"。
修改了
测试责任人,旧值为 "",新值为 "lijianxing"。
修改了
解决时效 ,旧值为 "0",新值为 "30.05"。
修改了
解决方案 ,旧值为 "tostory",新值为 "bypuduct"。
修改了
是否确认 ,旧值为 "0",新值为 "1"。
修改了
重现步骤 ,区别为:
001- HWY-ZH-GZ-RDS-Warehouse库,zhcxkj-center-warehouse 服务慢sql: SELECT
001+ HWY-ZH-GZ-RDS-Warehouse库,zhcxkj-center-warehouse 服务慢sql: SELECT count(*) FROM t_stk_procurement_detail_checklist a LEFT JOIN t_stk_procurement_list tp ON tp.p_code=a.p_code AND tp.customer_id=a.customer_id left join rb_ware_house c on a.wareHouse_id=c.id and a.customer_id=c.customer_id WHERE a.customer_id = 1 and a.add_time >= 2025-11-15 00:00:00 and 2025-12-15 23:59:59 >= a.add_time 扫描行百万以上,执行时间近10s
002- count(*)
003- FROM
004- t_stk_procurement_detail_checklist a
005- LEFT JOIN t_stk_procurement_list tp ON tp.p_code=a.p_code AND tp.customer_id=a.customer_id
006- left join rb_ware_house c on a.wareHouse_id=c.id and a.customer_id=c.customer_id
007-
008- WHERE a.customer_id = 1
009-
010- and a.add_time >= 2025-11-15 00:00:00
011-
012-
013- and 2025-12-15 23:59:59 >= a.add_time 扫描行百万以上,执行时间近10s
001- HWY-ZH-GZ-RDS-Warehouse库,zhcxkj-center-warehouse 服务慢sql: SELECT<br />
001+ HWY-ZH-GZ-RDS-Warehouse库,zhcxkj-center-warehouse 服务慢sql: SELECT<br /> count(*)<br /> FROM<br /> t_stk_procurement_detail_checklist a<br /> LEFT JOIN t_stk_procurement_list tp ON tp.p_code=a.p_code AND tp.customer_id=a.customer_id<br /> left join rb_ware_house c on a.wareHouse_id=c.id and a.customer_id=c.customer_id<br /><br /> WHERE a.customer_id = 1<br /><br /> and a.add_time >= 2025-11-15 00:00:00<br /><br /><br /> and 2025-12-15 23:59:59 >= a.add_time 扫描行百万以上,执行时间近10s
002- count(*)<br />
003- FROM<br />
004- t_stk_procurement_detail_checklist a<br />
005- LEFT JOIN t_stk_procurement_list tp ON tp.p_code=a.p_code AND tp.customer_id=a.customer_id<br />
006- left join rb_ware_house c on a.wareHouse_id=c.id and a.customer_id=c.customer_id<br />
007- <br />
008- WHERE a.customer_id = 1<br />
009- <br />
010- and a.add_time >= 2025-11-15 00:00:00<br />
011- <br />
012- <br />
013- and 2025-12-15 23:59:59 >= a.add_time 扫描行百万以上,执行时间近10s