title: The left joins making query slow,is there any method to increase the speed of this query
body: <pre><code>select 
      b.entry_id,
      b.assign_id,
      a.profile_type,
      a.profile_id,
      a.profile_name,
      a.profile_status,
      b.entry_type,
      b.assign_id,
      c.chapter_name,
      d.section_name,
      h.group_name,
      i.programme_name,
      k.subjectprogramme_name,
      j.masterprogramme_name,
      l.developmentprogramme_name
  from profile_master a
  left join profile_assign b on (a.profile_id = b.profile_id)  
  left join chapter_master c 
         on (b.entry_id = c.chapter_id and b.entry_type='chapter') 
  left join section_master d 
         on (b.entry_id = d.section_id and b.entry_type='section')
  left join group_master h 
         on (b.entry_id = h.group_id and b.entry_type='Group' 
             and h.year_id='".$this-&gt;year."')
  left join programme_master i 
         on (b.entry_id = i.programme_id and b.entry_type='Programme' 
             and i.year_id='".$this-&gt;year."')
  left join subjectprogramme_master k 
         on (b.entry_id = k.subjectprogramme_id and b.entry_type='subjectProgramme' 
             and k.year_id='".$this-&gt;year."')
  left join masterprogramme_master j 
         on (b.entry_id = j.masterprogramme_id and b.entry_type='masterProgramme' 
             and j.year_id='".$this-&gt;year."')
  left join developmentprogramme_master l 
         on (b.entry_id = l.developmentprogramme_id 
             and b.entry_type='developmentProgramme')
  </code></pre>