[TYPO3 Extbase] Find By Uid including Hidden and Deleted records

Repository.php

    /**
     * Find a record by uid even if it is hidden or deleted
     *
     * @param int $uid
     * @param int|array $pid
     * @return object
     */
    public function findByUidInAllRecordsByUid($uid, $pid=false)
    {
        $query = $this->createQuery();
        $query->getQuerySettings()
            ->setIgnoreEnableFields(true)
            ->setIncludeDeleted(true)
            ->setRespectStoragePage(false);
        if($pid){
            if( is_array($pid) ){
                $query->getQuerySettings()->setStoragePageIds( $pid );
            }
            elseif( is_integer($pid) ){
                $query->getQuerySettings()->setStoragePageIds( [$pid] );
            }
        }
        $query->matching($query->equals('uid', $uid));
        return $query->execute()->getFirst();
    }