Why is the temperature of soil higher than the water when heated by the sun?

Because water has a higher thermal capacity than soil and also water tends to circulate which soil can't do.