protected function addParentPathConstraintToQueryBuilder(QueryBuilder $queryBuilder, $parentPath, $recursive = false)
{
if (!$recursive) {
$queryBuilder->andWhere('n.parentPathHash = :parentPathHash')->setParameter('parentPathHash', md5($parentPath));
} else {
$queryBuilder->andWhere($queryBuilder->expr()->orX()->add($queryBuilder->expr()->eq('n.parentPathHash', ':parentPathHash'))->add($queryBuilder->expr()->like('n.parentPath', ':parentPath')))->setParameter('parentPathHash', md5($parentPath))->setParameter('parentPath', rtrim($parentPath, '/') . '/%');
}
}