记录一个超长sql的优化从4s到0.0015s

TIPS:Mysql版本8.0.19 废话不多说,直入正题,先来看看我所说的超长sql: SELECT my.id, my.date, my.business_date AS businessDate, my.CODE, my.customer_id AS customerId, cc.NAME AS customerName, cc.boss_name AS bossName, my.contact_person_id AS contactPersonId, ccp.NAME AS contactPersonName, my.department_id AS depa