Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.62 ms Query time

0 Invalid entities

0 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection

#▲

Time

Info

0.40 ms

SELECT id FROM lang WHERE iso_code = ?

Parameters:

[
  "it"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  lang
WHERE
  iso_code = ?

SELECT id FROM lang WHERE iso_code = 'it';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\Front\PageController->show (line 31)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 208)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

0.22 ms

SELECT id FROM lang WHERE active = 1 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  lang
WHERE
  active = 1
LIMIT
  1

SELECT id FROM lang WHERE active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Controller\Front\PageController->show (line 32)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 208)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 29)
8	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
messenger	doctrine.dbal.messenger_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Artist	No errors.
App\Entity\Admin\Employee	No errors.
App\Entity\Admin\EmployeeResetPasswordRequest	No errors.
App\Entity\ArtistLang	No errors.
App\Entity\ArtistType	No errors.
App\Entity\ArtistTypeLang	No errors.
App\Entity\Band	No errors.
App\Entity\BandInvitation	No errors.
App\Entity\BandJoinRequest	No errors.
App\Entity\BandLang	No errors.
App\Entity\BandMedia	No errors.
App\Entity\BandsintownImportLog	No errors.
App\Entity\BandsintownImportRun	No errors.
App\Entity\Broadcast	No errors.
App\Entity\BroadcastLang	No errors.
App\Entity\City	No errors.
App\Entity\Configuration	No errors.
App\Entity\Country	No errors.
App\Entity\CountryLang	No errors.
App\Entity\EmailCampaign	No errors.
App\Entity\Event	No errors.
App\Entity\EventBandPoints	No errors.
App\Entity\EventLang	No errors.
App\Entity\EventVote	No errors.
App\Entity\Instrument	No errors.
App\Entity\InstrumentGroup	No errors.
App\Entity\InstrumentGroupLang	No errors.
App\Entity\InstrumentLang	No errors.
App\Entity\Lang	No errors.
App\Entity\LoginBotTrafficStat	No errors.
App\Entity\MusicGenre	No errors.
App\Entity\MusicGenreLang	No errors.
App\Entity\Notification	No errors.
App\Entity\Page	No errors.
App\Entity\PageLang	No errors.
App\Entity\PointRule	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\User	No errors.
App\Entity\State	No errors.
App\Entity\Tier	No errors.
App\Entity\TierLang	No errors.
App\Entity\UserBandFollow	No errors.
App\Entity\UserDeletionRequest	No errors.
App\Entity\Venue	No errors.
App\Entity\VenueLang	No errors.
App\Entity\VenueReview	No errors.
Vich\UploaderBundle\Entity\File	No errors.