The frantic search for a missing toddler who vanished in central Queensland has come to a tragic end after he was found dead.