MySQL SQL 优化 字段类型转换

• 慢查询发现开发定义的外键的字段类型不同 强制转换后再进行join

#原来
SELECT *
        FROM t_order o
            INNER JOIN pmc_pay_record_public pprp ON o.id = pprp.orderId
        WHERE o.id > 1 AND o.orderTime >= 1 AND o.payStatus = 0 AND o.isDelete = 0
        ORDER BY o.id ASC
        LIMIT 100

#新
SELECT *
FROM 
(SELECT concat(o.id) id
FROM t_order o  WHERE  o.orderTime >= 1567147910034 AND o.payStatus = 0 AND o.isDelete = 0  
ORDER BY o.id ASC
LIMIT 100 ) T
INNER JOIN pmc_pay_record_public pprp ON T.id = pprp.orderId