排查问题
关联查询太多
SELECT t.id AS news_id, t.app_ids, t.rid, t.ds_code, t.ds_news_columns, t.media_source, t.title, t.src_publish_date, t.news_url, p.handle_status, t.publish_date, t.similar_news_id, p1.handle_status AS 'similar_news_handle_status', t.dup_news_id, p2.handle_status AS 'dup_news_handle_status', p.create_time AS process_create_time, t.create_time FROM master .hw_news_middle t LEFT JOIN bm.processing p ON p.news_id = t.id LEFT JOIN bm.processing p1 ON p1.news_id = t.similar_news_id LEFT JOIN bm.processing p2 ON p2.news_id = t.dup_news_id WHERE 1=1 AND t.create_time >= CONCAT('2023-04-10', ' 00:00:00') AND t.create_time <= CONCAT('2023-04-10', ' 23:59:59') AND t.ds_code =221695 and t.id in (23509988545845,23509988545844) ORDER BY t.create_time DESC ;
标签:语句,status,handle,create,time,查询,使用,news,id From: https://www.cnblogs.com/junzizhibang/p/17919166.html