Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.49 ms Query time

0 Invalid entities

149 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.16 ms

SELECT DISTINCT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.locality AS locality_3, b0_.position AS position_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.facebook AS facebook_7, b0_.instagram AS instagram_8, b0_.website AS website_9, b0_.untapped AS untapped_10, b0_.twitter AS twitter_11, b0_.white_bg AS white_bg_12, b1_.id AS id_13, b1_.year AS year_14, b2_.id AS id_15, b2_.name AS name_16, b2_.alcool AS alcool_17, b2_.type AS type_18, b2_.position AS position_19, b3_.id AS id_20, b3_.keyword AS keyword_21, b3_.position AS position_22, b1_.brewer_id AS brewer_id_23, b2_.brewer_id AS brewer_id_24, b3_.beer_id AS beer_id_25 FROM brewer b0_ LEFT JOIN brewer_year b1_ ON b0_.id = b1_.brewer_id LEFT JOIN beer b2_ ON b0_.id = b2_.brewer_id LEFT JOIN beer_keyword b3_ ON b2_.id = b3_.beer_id INNER JOIN brewer_year b4_ ON b0_.id = b4_.brewer_id AND (b4_.year = ?) ORDER BY b0_.position ASC, b1_.year DESC, b1_.id ASC, b2_.position ASC, b2_.id ASC, b3_.position ASC, b3_.id ASC

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.logo AS logo_2,
  b0_.locality AS locality_3,
  b0_.position AS position_4,
  b0_.latitude AS latitude_5,
  b0_.longitude AS longitude_6,
  b0_.facebook AS facebook_7,
  b0_.instagram AS instagram_8,
  b0_.website AS website_9,
  b0_.untapped AS untapped_10,
  b0_.twitter AS twitter_11,
  b0_.white_bg AS white_bg_12,
  b1_.id AS id_13,
  b1_.year AS year_14,
  b2_.id AS id_15,
  b2_.name AS name_16,
  b2_.alcool AS alcool_17,
  b2_.type AS type_18,
  b2_.position AS position_19,
  b3_.id AS id_20,
  b3_.keyword AS keyword_21,
  b3_.position AS position_22,
  b1_.brewer_id AS brewer_id_23,
  b2_.brewer_id AS brewer_id_24,
  b3_.beer_id AS beer_id_25
FROM
  brewer b0_
  LEFT JOIN brewer_year b1_ ON b0_.id = b1_.brewer_id
  LEFT JOIN beer b2_ ON b0_.id = b2_.brewer_id
  LEFT JOIN beer_keyword b3_ ON b2_.id = b3_.beer_id
  INNER JOIN brewer_year b4_ ON b0_.id = b4_.brewer_id
  AND (b4_.year = ?)
ORDER BY
  b0_.position ASC,
  b1_.year DESC,
  b1_.id ASC,
  b2_.position ASC,
  b2_.id ASC,
  b3_.position ASC,
  b3_.id ASC

SELECT DISTINCT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.locality AS locality_3, b0_.position AS position_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.facebook AS facebook_7, b0_.instagram AS instagram_8, b0_.website AS website_9, b0_.untapped AS untapped_10, b0_.twitter AS twitter_11, b0_.white_bg AS white_bg_12, b1_.id AS id_13, b1_.year AS year_14, b2_.id AS id_15, b2_.name AS name_16, b2_.alcool AS alcool_17, b2_.type AS type_18, b2_.position AS position_19, b3_.id AS id_20, b3_.keyword AS keyword_21, b3_.position AS position_22, b1_.brewer_id AS brewer_id_23, b2_.brewer_id AS brewer_id_24, b3_.beer_id AS beer_id_25 FROM brewer b0_ LEFT JOIN brewer_year b1_ ON b0_.id = b1_.brewer_id LEFT JOIN beer b2_ ON b0_.id = b2_.brewer_id LEFT JOIN beer_keyword b3_ ON b2_.id = b3_.beer_id INNER JOIN brewer_year b4_ ON b0_.id = b4_.brewer_id AND (b4_.year = 2026) ORDER BY b0_.position ASC, b1_.year DESC, b1_.id ASC, b2_.position ASC, b2_.id ASC, b3_.position ASC, b3_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BrewerRepository->findByYear (line 40)
7	App\Service\Brewery->getBreweriesOfYear (line 39)
8	App\Controller\HomepageController->index (line 25)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.34 ms

SELECT DISTINCT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.locality AS locality_3, b0_.position AS position_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.facebook AS facebook_7, b0_.instagram AS instagram_8, b0_.website AS website_9, b0_.untapped AS untapped_10, b0_.twitter AS twitter_11, b0_.white_bg AS white_bg_12, b1_.id AS id_13, b1_.year AS year_14, b2_.id AS id_15, b2_.name AS name_16, b2_.alcool AS alcool_17, b2_.type AS type_18, b2_.position AS position_19, b3_.id AS id_20, b3_.keyword AS keyword_21, b3_.position AS position_22, b1_.brewer_id AS brewer_id_23, b2_.brewer_id AS brewer_id_24, b3_.beer_id AS beer_id_25 FROM brewer b0_ LEFT JOIN brewer_year b1_ ON b0_.id = b1_.brewer_id LEFT JOIN beer b2_ ON b0_.id = b2_.brewer_id LEFT JOIN beer_keyword b3_ ON b2_.id = b3_.beer_id LEFT JOIN brewer_year b4_ ON b0_.id = b4_.brewer_id AND (b4_.year = ?) WHERE b4_.id IS NULL ORDER BY b0_.position ASC, b1_.year DESC, b1_.id ASC, b2_.position ASC, b2_.id ASC, b3_.position ASC, b3_.id ASC

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.logo AS logo_2,
  b0_.locality AS locality_3,
  b0_.position AS position_4,
  b0_.latitude AS latitude_5,
  b0_.longitude AS longitude_6,
  b0_.facebook AS facebook_7,
  b0_.instagram AS instagram_8,
  b0_.website AS website_9,
  b0_.untapped AS untapped_10,
  b0_.twitter AS twitter_11,
  b0_.white_bg AS white_bg_12,
  b1_.id AS id_13,
  b1_.year AS year_14,
  b2_.id AS id_15,
  b2_.name AS name_16,
  b2_.alcool AS alcool_17,
  b2_.type AS type_18,
  b2_.position AS position_19,
  b3_.id AS id_20,
  b3_.keyword AS keyword_21,
  b3_.position AS position_22,
  b1_.brewer_id AS brewer_id_23,
  b2_.brewer_id AS brewer_id_24,
  b3_.beer_id AS beer_id_25
FROM
  brewer b0_
  LEFT JOIN brewer_year b1_ ON b0_.id = b1_.brewer_id
  LEFT JOIN beer b2_ ON b0_.id = b2_.brewer_id
  LEFT JOIN beer_keyword b3_ ON b2_.id = b3_.beer_id
  LEFT JOIN brewer_year b4_ ON b0_.id = b4_.brewer_id
  AND (b4_.year = ?)
WHERE
  b4_.id IS NULL
ORDER BY
  b0_.position ASC,
  b1_.year DESC,
  b1_.id ASC,
  b2_.position ASC,
  b2_.id ASC,
  b3_.position ASC,
  b3_.id ASC

SELECT DISTINCT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.locality AS locality_3, b0_.position AS position_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.facebook AS facebook_7, b0_.instagram AS instagram_8, b0_.website AS website_9, b0_.untapped AS untapped_10, b0_.twitter AS twitter_11, b0_.white_bg AS white_bg_12, b1_.id AS id_13, b1_.year AS year_14, b2_.id AS id_15, b2_.name AS name_16, b2_.alcool AS alcool_17, b2_.type AS type_18, b2_.position AS position_19, b3_.id AS id_20, b3_.keyword AS keyword_21, b3_.position AS position_22, b1_.brewer_id AS brewer_id_23, b2_.brewer_id AS brewer_id_24, b3_.beer_id AS beer_id_25 FROM brewer b0_ LEFT JOIN brewer_year b1_ ON b0_.id = b1_.brewer_id LEFT JOIN beer b2_ ON b0_.id = b2_.brewer_id LEFT JOIN beer_keyword b3_ ON b2_.id = b3_.beer_id LEFT JOIN brewer_year b4_ ON b0_.id = b4_.brewer_id AND (b4_.year = 2026) WHERE b4_.id IS NULL ORDER BY b0_.position ASC, b1_.year DESC, b1_.id ASC, b2_.position ASC, b2_.id ASC, b3_.position ASC, b3_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BrewerRepository->findWithoutYear (line 54)
7	App\Service\Brewery->getOldBreweries (line 31)
8	App\Controller\HomepageController->index (line 26)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\BrewerYear	66
App\Entity\Brewer	54
App\Entity\Beer	26
App\Entity\BeerKeyword	3

Entities Mapping

Class	Mapping errors
App\Entity\Brewer	No errors.
App\Entity\BrewerYear	No errors.
App\Entity\Beer	No errors.
App\Entity\BeerKeyword	No errors.
App\Entity\BeerRating	No errors.

Symfony Profiler

GET http://brassicollines.be/

Configuration Settings

Theme

Page Width