Member Junction
    Preparing search index...
    READ_BY_KEYS_BATCH: 500

    Keys per read: one IN (...) list stays well inside SQL Server's parameter and statement limits.