Almost never. As a kid my mon would be screaming at us to close the fridge.
As an adult, I buy the groceries and open the fridge myself to take out food throughout the day, so I pretty much know what’s in there before I open the door. A spouse or kid who rarely gets their own food usually needs more time to assess their options.
I did have the refrigerator and freezer open a little longer than usual Saturday, because we returned home Friday and had very little in both. I needed to stare inside to tell my husband his choices for a meal and I didn’t remember what I had to choose from. Maybe it was open 30 seconds.