After Apple gets an app it stays in review for anywhere between a couple of hours, to a couple of months. These are both rare cases though. Typically it sits in review for 4-7 days. Then once the email is sent out saying that the app has been accepted it usually takes about 3 hours before it shows up in the store.