查询问题的语句使用

发布时间 2023-12-21 15:29:37作者: 难搞2023

排查问题

关联查询太多

   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  ;