Timeline optimization (speed improvements enhancements) #4367
Description
- 1. remove double query
- 2. remove DAYOFYEAR\
- 3. change LEFT join to INNER join
- 4. remove ISNULL(
sys_profiles.status) OR - 5. remove distinct in every subquery, use one insead of