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 ZenTop006Controller extends AbstractController
{
/**
* @var EntityManagerInterface
*/
protected $entityManager;
public function __construct(EntityManagerInterface $entityManager)
{
$this->entityManager = $entityManager;
}
/**
* @Route("/block/zen_top006", name="block_zen_top006")
*/
public function index(Request $request, SessionInterface $session)
{
// SQLクエリを実行してデータを取得
$connection = $this->entityManager->getConnection();
$sql = 'SELECT * ';
$sql .= 'FROM `blb_events` ';
$sql .= 'WHERE `view` = 1 ';
$sql .= 'AND CURDATE() BETWEEN `ss_date` AND `ee_date` ';
$sql .= 'ORDER BY `s_date` LIMIT 3';
$stmt = $connection->prepare($sql);
$result = $stmt->executeQuery();
$events = $result->fetchAllAssociative();
// echo '[BITLABO ' . $sql . ']';
for ($i = 0; $i < count($events); $i++) {
if (file_exists('up_images/events/' . $events[$i]['id'] . '/1.jpg')) {
$events[$i]['image'] = '../up_images/events/' . $events[$i]['id'] . '/1.jpg';
} else {
$events[$i]['image'] = '';
}
}
// $connection = $this->entityManager->getConnection();
$sql = 'SELECT * FROM `blb_information` WHERE `view`=1 ORDER BY `s_date` DESC LIMIT 3'; // 任意のテーブル名を指定
$stmt = $connection->prepare($sql);
$result = $stmt->executeQuery();
$newsList = $result->fetchAllAssociative();
for ($i = 0; $i < count($newsList); $i++) {
if (file_exists('up_images/news/' . $newsList[$i]['id'] . '/1.jpg')) {
$newsList[$i]['image'] = '../up_images/news/' . $newsList[$i]['id'] . '/1.jpg';
} else {
$newsList[$i]['image'] = '';
}
}
// テンプレートにデータを渡してレンダリング
return $this->render('Block/zen_top006.twig', [
'NewsList' => $newsList,
'Events' => $events,
]);
}
}

app/Customize/Controller/Block/ZenTop006Controller.php line 28