0 - 1 of 1 tags for time consuming

Hi All,

I am trying to debug a query which is taking a lot of time.
Following objects are involved in the query :