记一次sql优化

之前的sql

    LEFT JOIN (
            SELECT
            a.*
            FROM
            ${item.tableName} a
            LEFT JOIN ${item.tableName} b ON a.core_id = b.core_id
            AND (a.updated_time < b.updated_time OR (a.updated_time = b.updated_time AND a.id < b.id))
            WHERE
            b.updated_time IS NULL
            ) s_${item.id} ON s_${item.id}.core_id = s.id

优化后的sql

SELECT s.*,a1.* FROM xin_guan_yi_miao_jie_zhong_zhuan_xiang_xin_xi_dong_tai s
    left  join      
           ( select a.core_id from xin_guan_yi_miao_jie_zhong_ji_lu  a group by a.core_id  order by a.updated_time desc ) a1 
           on a1.core_id = s.id;