Symfony Profiler

<?php
namespace Customize\Controller\Block;
use Eccube\Controller\AbstractController;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\Routing\Annotation\Route;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\HttpFoundation\Session\SessionInterface;
class ZenSlideController extends AbstractController
{
/**
* @var EntityManagerInterface
*/
protected $entityManager;
public function __construct(EntityManagerInterface $entityManager)
{
$this->entityManager = $entityManager;
}
/**
* @Route("/block/zen_slide", name="block_zen_slide")
*/
public function index(Request $request, SessionInterface $session)
{
// SQLクエリを実行してデータを取得
$connection = $this->entityManager->getConnection();
$sql = 'SELECT * FROM `blb_sliders` WHERE `view`=1 ORDER BY RAND()'; // 任意のテーブル名を指定
$stmt = $connection->prepare($sql);
$result = $stmt->executeQuery();
$sliders = $result->fetchAllAssociative();
for ($i = 0; $i < count($sliders); $i++) {
if (file_exists('up_images/sliders/' . $sliders[$i]['id'] . '/1.jpg')) {
$sliders[$i]['image'] = '../up_images/sliders/' . $sliders[$i]['id'] . '/1.jpg';
} else {
$sliders[$i]['image'] = '';
}
if (file_exists('up_images/sliders/' . $sliders[$i]['id'] . '/2.jpg')) {
$sliders[$i]['image2'] = '../up_images/sliders/' . $sliders[$i]['id'] . '/2.jpg';
} else {
$sliders[$i]['image2'] = '';
}
}
return $this->render('Block/zen_slide.twig', [
'Sliders' => $sliders,
]);
}
}

app/Customize/Controller/Block/ZenSlideController.php line 27