wp_load_core_site_options example

$blog_id = $current_blog->blog_id;
    $public  = $current_blog->public;

    if ( empty( $current_blog->site_id ) ) {
        // This dates to [MU134] and shouldn't be relevant anymore,         // but it could be possible for arguments passed to insert_blog() etc.         $current_blog->site_id = 1;
    }

    $site_id = $current_blog->site_id;
    wp_load_core_site_options( $site_id );
}

$wpdb->set_prefix( $table_prefix, false ); // $table_prefix can be set in sunrise.php. $wpdb->set_blog_id( $current_blog->blog_id, $current_blog->site_id );
$table_prefix       = $wpdb->get_blog_prefix();
$_wp_switched_stack = array();
$switched           = false;

// Need to init cache again after blog_id is set. wp_start_object_cache();