Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.95 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.67 ms
(34.38%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.creation_datetime AS creation_datetime_3, t0.signature AS signature_4, t0.signature_datetime AS signature_datetime_5, t0.relationship AS relationship_6, t0.event_location AS event_location_7, t0.event_datetime AS event_datetime_8, t0.bride_last_name AS bride_last_name_9, t0.bride_first_name AS bride_first_name_10, t0.bride_phone_number AS bride_phone_number_11, t0.groom_last_name AS groom_last_name_12, t0.groom_first_name AS groom_first_name_13, t0.groom_phone_number AS groom_phone_number_14, t0.rhythm_style_and_cadence AS rhythm_style_and_cadence_15, t0.favorite_music_from_zily AS favorite_music_from_zily_16, t0.stories AS stories_17, t0.expectations AS expectations_18, t0.message_to_be_conveyed AS message_to_be_conveyed_19, t0.delivery_datetime AS delivery_datetime_20, t0.imported AS imported_21, t0.ebp_code AS ebp_code_22, t0.comment AS comment_23, t0.customer_id AS customer_id_24, t0.beatmaker_id AS beatmaker_id_25 FROM wedding_song t0 WHERE t0.id = ?

Parameters:

[
  "107"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.creation_datetime AS creation_datetime_3,
  t0.signature AS signature_4,
  t0.signature_datetime AS signature_datetime_5,
  t0.relationship AS relationship_6,
  t0.event_location AS event_location_7,
  t0.event_datetime AS event_datetime_8,
  t0.bride_last_name AS bride_last_name_9,
  t0.bride_first_name AS bride_first_name_10,
  t0.bride_phone_number AS bride_phone_number_11,
  t0.groom_last_name AS groom_last_name_12,
  t0.groom_first_name AS groom_first_name_13,
  t0.groom_phone_number AS groom_phone_number_14,
  t0.rhythm_style_and_cadence AS rhythm_style_and_cadence_15,
  t0.favorite_music_from_zily AS favorite_music_from_zily_16,
  t0.stories AS stories_17,
  t0.expectations AS expectations_18,
  t0.message_to_be_conveyed AS message_to_be_conveyed_19,
  t0.delivery_datetime AS delivery_datetime_20,
  t0.imported AS imported_21,
  t0.ebp_code AS ebp_code_22,
  t0.comment AS comment_23,
  t0.customer_id AS customer_id_24,
  t0.beatmaker_id AS beatmaker_id_25
FROM
  wedding_song t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.creation_datetime AS creation_datetime_3, t0.signature AS signature_4, t0.signature_datetime AS signature_datetime_5, t0.relationship AS relationship_6, t0.event_location AS event_location_7, t0.event_datetime AS event_datetime_8, t0.bride_last_name AS bride_last_name_9, t0.bride_first_name AS bride_first_name_10, t0.bride_phone_number AS bride_phone_number_11, t0.groom_last_name AS groom_last_name_12, t0.groom_first_name AS groom_first_name_13, t0.groom_phone_number AS groom_phone_number_14, t0.rhythm_style_and_cadence AS rhythm_style_and_cadence_15, t0.favorite_music_from_zily AS favorite_music_from_zily_16, t0.stories AS stories_17, t0.expectations AS expectations_18, t0.message_to_be_conveyed AS message_to_be_conveyed_19, t0.delivery_datetime AS delivery_datetime_20, t0.imported AS imported_21, t0.ebp_code AS ebp_code_22, t0.comment AS comment_23, t0.customer_id AS customer_id_24, t0.beatmaker_id AS beatmaker_id_25 FROM wedding_song t0 WHERE t0.id = '107';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.51 ms
(26.32%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.relationship AS relationship_3, t0.bride_or_groom AS bride_or_groom_4, t0.song_id AS song_id_5 FROM wedding_person t0 WHERE t0.song_id = ?

Parameters:

[
  107
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.relationship AS relationship_3,
  t0.bride_or_groom AS bride_or_groom_4,
  t0.song_id AS song_id_5
FROM
  wedding_person t0
WHERE
  t0.song_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.relationship AS relationship_3, t0.bride_or_groom AS bride_or_groom_4, t0.song_id AS song_id_5 FROM wedding_person t0 WHERE t0.song_id = 107;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 412)
8	Doctrine\ORM\PersistentCollection->containsKey (line 496)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1595)
10	Twig\Extension\CoreExtension::getAttribute (line 541)
11	__TwigTemplate_e85e3c80e08df6076034915b6ceaa7b4->block_body (line 437)
12	Twig\Template->yieldBlock (line 186)
13	__TwigTemplate_ab50c1215638f9b53db05d3266788efe->doDisplay (line 393)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_e85e3c80e08df6076034915b6ceaa7b4->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 187)
23	App\Controller\Customer\WeddingSongController->weddingSongRead (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.42 ms
(21.78%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.civility AS civility_8, t0.address AS address_9, t0.village AS village_10, t0.postal_code AS postal_code_11, t0.active AS active_12, t0.reset_token AS reset_token_13, t0.reset_token_date_time AS reset_token_date_time_14, t0.imported AS imported_15 FROM customer t0 WHERE t0.id = ?

Parameters:

[
  249
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone_number AS phone_number_7,
  t0.civility AS civility_8,
  t0.address AS address_9,
  t0.village AS village_10,
  t0.postal_code AS postal_code_11,
  t0.active AS active_12,
  t0.reset_token AS reset_token_13,
  t0.reset_token_date_time AS reset_token_date_time_14,
  t0.imported AS imported_15
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.civility AS civility_8, t0.address AS address_9, t0.village AS village_10, t0.postal_code AS postal_code_11, t0.active AS active_12, t0.reset_token AS reset_token_13, t0.reset_token_date_time AS reset_token_date_time_14, t0.imported AS imported_15 FROM customer t0 WHERE t0.id = 249;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\Customer::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 111)
7	Proxies\__CG__\App\Entity\Customer->__load (line 102)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
9	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
15	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 65)
16	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 116)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 176)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.34 ms
(17.52%)

SELECT t0.id AS id_1, t0.base_price AS base_price_2, t0.additional_price AS additional_price_3 FROM pricing_configuration t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.base_price AS base_price_2,
  t0.additional_price AS additional_price_3
FROM
  pricing_configuration t0

SELECT t0.id AS id_1, t0.base_price AS base_price_2, t0.additional_price AS additional_price_3 FROM pricing_configuration t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 183)
5	App\Controller\Customer\WeddingSongController->weddingSongRead (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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.

Entities Mapping

Class	Mapping errors
App\Entity\WeddingSong	No errors.
App\Entity\Customer	No errors.
App\Entity\Beatmaker	No errors.
App\Entity\WeddingPerson	No errors.
App\Entity\BirthdaySong	No errors.
App\Entity\PricingConfiguration	No errors.

Symfony Profiler

GET https://yekaproduction.yt/client/demande/mariage/107/voir

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping