public function getTotalCount() { $qb = $this->createQueryBuilder('c')->select('count(c.id)')->where('c.del_flg = 0'); $count = $qb->getQuery()->getSingleScalarResult(); return $count; }