记录一次left join带where的优化0
有如下一条SQL 执行时间1.477s
SELECT
`c`.*,
`p`.`patient_name`,
`p`.`age_first_val` AS `age`,
`p`.`patient_phone`,
`p`.`department_name`,
`p`.`case_type`,
`p`.`check_time`,
`p`.`card_no`,
`p`.`doctor`,
`p`.`outpatient`,
`p`.`coll_time`,
`r`.`json_data`,
`r`.`report_form`,
`p`.`created_at` AS `receive_time`,
`r`.`created_at` AS `report_time`,
`r`.`state`
FROM
`ts_repo...