fix(optimizer): Prevent issuing duplicated queries for certain uses of first() and get()

fix(optimizer): Prevent issuing duplicated queries for certain uses of first() and get() #1045