sthamann

$logger = new \Doctrine\DBAL\Logging\DebugStack();
$logger->enabled;
Shopware()->Models()->getConfiguration()->setSQLLogger($logger);

// Shopware Doctrine Queries
            //get access on the customer repository
            $query = $this->getRepository()->getListQuery($filter, $customerGroup, $sort, $limit, $offset);

            //returns the total count of the query
            $totalResult = $this->getManager()->getQueryCount($query);