Getting data from query result taking a long time

So I am wondering, with this example where is the field Scan that you are querying for?
And yes you are right the TrackTime index will not help right now. Do you have one for Scan?