Symfony Profiler

Query Metrics

15 Database Queries

13 Different statements

10.22 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.32 ms
(32.53%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_at AS start_at_2, e0_.end_at AS end_at_3, e0_.description AS description_4, e0_.place AS place_5, e0_.color AS color_6, e0_.lat AS lat_7, e0_.lng AS lng_8, e0_.is_recurrent AS is_recurrent_9, e0_.recurrent_type AS recurrent_type_10, e0_.stop_reccurent_at AS stop_reccurent_at_11, e0_.file AS file_12, e0_.team_arrival_at AS team_arrival_at_13, e0_.customer_id AS customer_id_14, e0_.information_sheet_id AS information_sheet_id_15, e0_.author_id AS author_id_16 FROM event e0_ LEFT JOIN wedding w1_ ON e0_.id = w1_.event_id WHERE (w1_.id IS NULL OR w1_.is_complete = 0 OR w1_.is_complete IS NULL) AND e0_.color = ? AND (e0_.start_at >= ? AND e0_.start_at <= ?)

Parameters:

[
  "Mariage"
  "2026-10-04 19:24:41"
  "2026-11-03 19:24:41"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.start_at AS start_at_2,
  e0_.end_at AS end_at_3,
  e0_.description AS description_4,
  e0_.place AS place_5,
  e0_.color AS color_6,
  e0_.lat AS lat_7,
  e0_.lng AS lng_8,
  e0_.is_recurrent AS is_recurrent_9,
  e0_.recurrent_type AS recurrent_type_10,
  e0_.stop_reccurent_at AS stop_reccurent_at_11,
  e0_.file AS file_12,
  e0_.team_arrival_at AS team_arrival_at_13,
  e0_.customer_id AS customer_id_14,
  e0_.information_sheet_id AS information_sheet_id_15,
  e0_.author_id AS author_id_16
FROM
  event e0_
  LEFT JOIN wedding w1_ ON e0_.id = w1_.event_id
WHERE
  (
    w1_.id IS NULL
    OR w1_.is_complete = 0
    OR w1_.is_complete IS NULL
  )
  AND e0_.color = ?
  AND (
    e0_.start_at >= ?
    AND e0_.start_at <= ?
  )

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.start_at AS start_at_2, e0_.end_at AS end_at_3, e0_.description AS description_4, e0_.place AS place_5, e0_.color AS color_6, e0_.lat AS lat_7, e0_.lng AS lng_8, e0_.is_recurrent AS is_recurrent_9, e0_.recurrent_type AS recurrent_type_10, e0_.stop_reccurent_at AS stop_reccurent_at_11, e0_.file AS file_12, e0_.team_arrival_at AS team_arrival_at_13, e0_.customer_id AS customer_id_14, e0_.information_sheet_id AS information_sheet_id_15, e0_.author_id AS author_id_16 FROM event e0_ LEFT JOIN wedding w1_ ON e0_.id = w1_.event_id WHERE (w1_.id IS NULL OR w1_.is_complete = 0 OR w1_.is_complete IS NULL) AND e0_.color = 'Mariage' AND (e0_.start_at >= '2026-10-04 19:24:41' AND e0_.start_at <= '2026-11-03 19:24:41');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 139)
7	App\Repository\EventRepository->searchWeddingAlert (line 30)
8	App\Twig\TwigExtension->getGlobals (line 331)
9	Twig\ExtensionSet->getGlobals (line 788)
10	Twig\Environment->getGlobals (line 801)
11	Twig\Environment->mergeGlobals (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
18	App\Controller\CalendarController->quickview (line 182)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

2.26 ms
(22.15%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.tva_rate AS tva_rate_3, t0.header_information AS header_information_4, t0.footer_information AS footer_information_5, t0.logo AS logo_6, t0.color AS color_7, t0.base AS base_8, t0.cgv AS cgv_9, t0.welcome AS welcome_10, t0.mail_send_invoice AS mail_send_invoice_11, t0.mail_send_quote AS mail_send_quote_12, t0.mail_send_wedding AS mail_send_wedding_13, t0.company AS company_14, t0.iban AS iban_15, t0.bic AS bic_16 FROM context t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tva_rate AS tva_rate_3,
  t0.header_information AS header_information_4,
  t0.footer_information AS footer_information_5,
  t0.logo AS logo_6,
  t0.color AS color_7,
  t0.base AS base_8,
  t0.cgv AS cgv_9,
  t0.welcome AS welcome_10,
  t0.mail_send_invoice AS mail_send_invoice_11,
  t0.mail_send_quote AS mail_send_quote_12,
  t0.mail_send_wedding AS mail_send_wedding_13,
  t0.company AS company_14,
  t0.iban AS iban_15,
  t0.bic AS bic_16
FROM
  context t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.tva_rate AS tva_rate_3, t0.header_information AS header_information_4, t0.footer_information AS footer_information_5, t0.logo AS logo_6, t0.color AS color_7, t0.base AS base_8, t0.cgv AS cgv_9, t0.welcome AS welcome_10, t0.mail_send_invoice AS mail_send_invoice_11, t0.mail_send_quote AS mail_send_quote_12, t0.mail_send_wedding AS mail_send_wedding_13, t0.company AS company_14, t0.iban AS iban_15, t0.bic AS bic_16 FROM context t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 37)
5	App\Twig\TwigExtension->getGlobals (line 331)
6	Twig\ExtensionSet->getGlobals (line 788)
7	Twig\Environment->getGlobals (line 801)
8	Twig\Environment->mergeGlobals (line 367)
9	Twig\Template->display (line 379)
10	Twig\Template->render (line 40)
11	Twig\TemplateWrapper->render (line 280)
12	Twig\Environment->render (line 243)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
15	App\Controller\CalendarController->quickview (line 182)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.93 ms
(9.13%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.presta_type AS presta_type_3, t0.compta_id AS compta_id_4, t0.created_at AS created_at_5, t0.discount_money AS discount_money_6, t0.discount_percent AS discount_percent_7, t0.tva_rate AS tva_rate_8, t0.state AS state_9, t0.zone_title AS zone_title_10, t0.zone_price AS zone_price_11, t0.rythme AS rythme_12, t0.is_check_presta AS is_check_presta_13, t0.sent_at AS sent_at_14, t0.customer_id AS customer_id_15, t0.context_id AS context_id_16, t0.information_sheet_id AS information_sheet_id_17, t0.event_id AS event_id_18, t19.id AS id_20, t19.cocktail_entrance AS cocktail_entrance_21, t19.cocktail_music AS cocktail_music_22, t19.entrance_type AS entrance_type_23, t19.entrance_placement AS entrance_placement_24, t19.entrance_music AS entrance_music_25, t19.open_bal_type AS open_bal_type_26, t19.open_bal_value AS open_bal_value_27, t19.champagne_type AS champagne_type_28, t19.champagne_music AS champagne_music_29, t19.blacklist AS blacklist_30, t19.bestlist AS bestlist_31, t19.is_complete AS is_complete_32, t19.cocktail_note AS cocktail_note_33, t19.note AS note_34, t19.entrance_note AS entrance_note_35, t19.open_bar_note AS open_bar_note_36, t19.champagne_note AS champagne_note_37, t19.cocktail_music_file AS cocktail_music_file_38, t19.champagne_music_file AS champagne_music_file_39, t19.cocktail_bouquet AS cocktail_bouquet_40, t19.cocktail_bouquet_music AS cocktail_bouquet_music_41, t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42, t19.cocktail_bouquet_note AS cocktail_bouquet_note_43, t19.customer_id AS customer_id_44, t19.event_id AS event_id_45, t19.quote_id AS quote_id_46 FROM quote t0 LEFT JOIN wedding t19 ON t19.quote_id = t0.id WHERE t0.is_check_presta = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.presta_type AS presta_type_3,
  t0.compta_id AS compta_id_4,
  t0.created_at AS created_at_5,
  t0.discount_money AS discount_money_6,
  t0.discount_percent AS discount_percent_7,
  t0.tva_rate AS tva_rate_8,
  t0.state AS state_9,
  t0.zone_title AS zone_title_10,
  t0.zone_price AS zone_price_11,
  t0.rythme AS rythme_12,
  t0.is_check_presta AS is_check_presta_13,
  t0.sent_at AS sent_at_14,
  t0.customer_id AS customer_id_15,
  t0.context_id AS context_id_16,
  t0.information_sheet_id AS information_sheet_id_17,
  t0.event_id AS event_id_18,
  t19.id AS id_20,
  t19.cocktail_entrance AS cocktail_entrance_21,
  t19.cocktail_music AS cocktail_music_22,
  t19.entrance_type AS entrance_type_23,
  t19.entrance_placement AS entrance_placement_24,
  t19.entrance_music AS entrance_music_25,
  t19.open_bal_type AS open_bal_type_26,
  t19.open_bal_value AS open_bal_value_27,
  t19.champagne_type AS champagne_type_28,
  t19.champagne_music AS champagne_music_29,
  t19.blacklist AS blacklist_30,
  t19.bestlist AS bestlist_31,
  t19.is_complete AS is_complete_32,
  t19.cocktail_note AS cocktail_note_33,
  t19.note AS note_34,
  t19.entrance_note AS entrance_note_35,
  t19.open_bar_note AS open_bar_note_36,
  t19.champagne_note AS champagne_note_37,
  t19.cocktail_music_file AS cocktail_music_file_38,
  t19.champagne_music_file AS champagne_music_file_39,
  t19.cocktail_bouquet AS cocktail_bouquet_40,
  t19.cocktail_bouquet_music AS cocktail_bouquet_music_41,
  t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42,
  t19.cocktail_bouquet_note AS cocktail_bouquet_note_43,
  t19.customer_id AS customer_id_44,
  t19.event_id AS event_id_45,
  t19.quote_id AS quote_id_46
FROM
  quote t0
  LEFT JOIN wedding t19 ON t19.quote_id = t0.id
WHERE
  t0.is_check_presta = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.presta_type AS presta_type_3, t0.compta_id AS compta_id_4, t0.created_at AS created_at_5, t0.discount_money AS discount_money_6, t0.discount_percent AS discount_percent_7, t0.tva_rate AS tva_rate_8, t0.state AS state_9, t0.zone_title AS zone_title_10, t0.zone_price AS zone_price_11, t0.rythme AS rythme_12, t0.is_check_presta AS is_check_presta_13, t0.sent_at AS sent_at_14, t0.customer_id AS customer_id_15, t0.context_id AS context_id_16, t0.information_sheet_id AS information_sheet_id_17, t0.event_id AS event_id_18, t19.id AS id_20, t19.cocktail_entrance AS cocktail_entrance_21, t19.cocktail_music AS cocktail_music_22, t19.entrance_type AS entrance_type_23, t19.entrance_placement AS entrance_placement_24, t19.entrance_music AS entrance_music_25, t19.open_bal_type AS open_bal_type_26, t19.open_bal_value AS open_bal_value_27, t19.champagne_type AS champagne_type_28, t19.champagne_music AS champagne_music_29, t19.blacklist AS blacklist_30, t19.bestlist AS bestlist_31, t19.is_complete AS is_complete_32, t19.cocktail_note AS cocktail_note_33, t19.note AS note_34, t19.entrance_note AS entrance_note_35, t19.open_bar_note AS open_bar_note_36, t19.champagne_note AS champagne_note_37, t19.cocktail_music_file AS cocktail_music_file_38, t19.champagne_music_file AS champagne_music_file_39, t19.cocktail_bouquet AS cocktail_bouquet_40, t19.cocktail_bouquet_music AS cocktail_bouquet_music_41, t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42, t19.cocktail_bouquet_note AS cocktail_bouquet_note_43, t19.customer_id AS customer_id_44, t19.event_id AS event_id_45, t19.quote_id AS quote_id_46 FROM quote t0 LEFT JOIN wedding t19 ON t19.quote_id = t0.id WHERE t0.is_check_presta = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 368)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 272)
5	Doctrine\ORM\EntityRepository->__call (line 32)
6	App\Twig\TwigExtension->getGlobals (line 331)
7	Twig\ExtensionSet->getGlobals (line 788)
8	Twig\Environment->getGlobals (line 801)
9	Twig\Environment->mergeGlobals (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 40)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 243)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
16	App\Controller\CalendarController->quickview (line 182)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.62 ms
(6.06%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permissions AS permissions_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.is_calendar_delete AS is_calendar_delete_8, t0.is_alerts AS is_alerts_9, t0.topbar_shortcuts AS topbar_shortcuts_10 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

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.permissions AS permissions_4,
  t0.password AS password_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.is_calendar_delete AS is_calendar_delete_8,
  t0.is_alerts AS is_alerts_9,
  t0.topbar_shortcuts AS topbar_shortcuts_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permissions AS permissions_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.is_calendar_delete AS is_calendar_delete_8, t0.is_alerts AS is_alerts_9, t0.topbar_shortcuts AS topbar_shortcuts_10 FROM user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 73)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 158)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.48 ms
(4.74%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.company AS company_4, t0.address AS address_5, t0.postal AS postal_6, t0.city AS city_7, t0.country AS country_8, t0.phone AS phone_9, t0.email AS email_10, t0.type AS type_11, t0.note AS note_12, t0.file AS file_13, t0.is_commission AS is_commission_14, t0.context_id AS context_id_15 FROM provider t0 INNER JOIN event_provider ON t0.id = event_provider.provider_id WHERE event_provider.event_id = ?

Parameters:

[
  2261
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.company AS company_4,
  t0.address AS address_5,
  t0.postal AS postal_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.phone AS phone_9,
  t0.email AS email_10,
  t0.type AS type_11,
  t0.note AS note_12,
  t0.file AS file_13,
  t0.is_commission AS is_commission_14,
  t0.context_id AS context_id_15
FROM
  provider t0
  INNER JOIN event_provider ON t0.id = event_provider.provider_id
WHERE
  event_provider.event_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.company AS company_4, t0.address AS address_5, t0.postal AS postal_6, t0.city AS city_7, t0.country AS country_8, t0.phone AS phone_9, t0.email AS email_10, t0.type AS type_11, t0.note AS note_12, t0.file AS file_13, t0.is_commission AS is_commission_14, t0.context_id AS context_id_15 FROM provider t0 INNER JOIN event_provider ON t0.id = event_provider.provider_id WHERE event_provider.event_id = 2261;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3170)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 244)
8	__TwigTemplate_864c516b673acff432dde51d4c010100->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 40)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 243)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
16	App\Controller\CalendarController->quickview (line 182)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.42 ms
(4.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.description AS description_5, t0.place AS place_6, t0.color AS color_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.is_recurrent AS is_recurrent_10, t0.recurrent_type AS recurrent_type_11, t0.stop_reccurent_at AS stop_reccurent_at_12, t0.file AS file_13, t0.team_arrival_at AS team_arrival_at_14, t0.customer_id AS customer_id_15, t0.information_sheet_id AS information_sheet_id_16, t17.id AS id_18, t17.cocktail_entrance AS cocktail_entrance_19, t17.cocktail_music AS cocktail_music_20, t17.entrance_type AS entrance_type_21, t17.entrance_placement AS entrance_placement_22, t17.entrance_music AS entrance_music_23, t17.open_bal_type AS open_bal_type_24, t17.open_bal_value AS open_bal_value_25, t17.champagne_type AS champagne_type_26, t17.champagne_music AS champagne_music_27, t17.blacklist AS blacklist_28, t17.bestlist AS bestlist_29, t17.is_complete AS is_complete_30, t17.cocktail_note AS cocktail_note_31, t17.note AS note_32, t17.entrance_note AS entrance_note_33, t17.open_bar_note AS open_bar_note_34, t17.champagne_note AS champagne_note_35, t17.cocktail_music_file AS cocktail_music_file_36, t17.champagne_music_file AS champagne_music_file_37, t17.cocktail_bouquet AS cocktail_bouquet_38, t17.cocktail_bouquet_music AS cocktail_bouquet_music_39, t17.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_40, t17.cocktail_bouquet_note AS cocktail_bouquet_note_41, t17.customer_id AS customer_id_42, t17.event_id AS event_id_43, t17.quote_id AS quote_id_44, t0.author_id AS author_id_45 FROM event t0 LEFT JOIN wedding t17 ON t17.event_id = t0.id WHERE t0.id = ? LIMIT 1

Parameters:

[
  "2261"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.description AS description_5,
  t0.place AS place_6,
  t0.color AS color_7,
  t0.lat AS lat_8,
  t0.lng AS lng_9,
  t0.is_recurrent AS is_recurrent_10,
  t0.recurrent_type AS recurrent_type_11,
  t0.stop_reccurent_at AS stop_reccurent_at_12,
  t0.file AS file_13,
  t0.team_arrival_at AS team_arrival_at_14,
  t0.customer_id AS customer_id_15,
  t0.information_sheet_id AS information_sheet_id_16,
  t17.id AS id_18,
  t17.cocktail_entrance AS cocktail_entrance_19,
  t17.cocktail_music AS cocktail_music_20,
  t17.entrance_type AS entrance_type_21,
  t17.entrance_placement AS entrance_placement_22,
  t17.entrance_music AS entrance_music_23,
  t17.open_bal_type AS open_bal_type_24,
  t17.open_bal_value AS open_bal_value_25,
  t17.champagne_type AS champagne_type_26,
  t17.champagne_music AS champagne_music_27,
  t17.blacklist AS blacklist_28,
  t17.bestlist AS bestlist_29,
  t17.is_complete AS is_complete_30,
  t17.cocktail_note AS cocktail_note_31,
  t17.note AS note_32,
  t17.entrance_note AS entrance_note_33,
  t17.open_bar_note AS open_bar_note_34,
  t17.champagne_note AS champagne_note_35,
  t17.cocktail_music_file AS cocktail_music_file_36,
  t17.champagne_music_file AS champagne_music_file_37,
  t17.cocktail_bouquet AS cocktail_bouquet_38,
  t17.cocktail_bouquet_music AS cocktail_bouquet_music_39,
  t17.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_40,
  t17.cocktail_bouquet_note AS cocktail_bouquet_note_41,
  t17.customer_id AS customer_id_42,
  t17.event_id AS event_id_43,
  t17.quote_id AS quote_id_44,
  t0.author_id AS author_id_45
FROM
  event t0
  LEFT JOIN wedding t17 ON t17.event_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.description AS description_5, t0.place AS place_6, t0.color AS color_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.is_recurrent AS is_recurrent_10, t0.recurrent_type AS recurrent_type_11, t0.stop_reccurent_at AS stop_reccurent_at_12, t0.file AS file_13, t0.team_arrival_at AS team_arrival_at_14, t0.customer_id AS customer_id_15, t0.information_sheet_id AS information_sheet_id_16, t17.id AS id_18, t17.cocktail_entrance AS cocktail_entrance_19, t17.cocktail_music AS cocktail_music_20, t17.entrance_type AS entrance_type_21, t17.entrance_placement AS entrance_placement_22, t17.entrance_music AS entrance_music_23, t17.open_bal_type AS open_bal_type_24, t17.open_bal_value AS open_bal_value_25, t17.champagne_type AS champagne_type_26, t17.champagne_music AS champagne_music_27, t17.blacklist AS blacklist_28, t17.bestlist AS bestlist_29, t17.is_complete AS is_complete_30, t17.cocktail_note AS cocktail_note_31, t17.note AS note_32, t17.entrance_note AS entrance_note_33, t17.open_bar_note AS open_bar_note_34, t17.champagne_note AS champagne_note_35, t17.cocktail_music_file AS cocktail_music_file_36, t17.champagne_music_file AS champagne_music_file_37, t17.cocktail_bouquet AS cocktail_bouquet_38, t17.cocktail_bouquet_music AS cocktail_bouquet_music_39, t17.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_40, t17.cocktail_bouquet_note AS cocktail_bouquet_note_41, t17.customer_id AS customer_id_42, t17.event_id AS event_id_43, t17.quote_id AS quote_id_44, t0.author_id AS author_id_45 FROM event t0 LEFT JOIN wedding t17 ON t17.event_id = t0.id WHERE t0.id = '2261' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 368)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 276)
5	Doctrine\ORM\EntityRepository->__call (line 136)
6	App\Controller\CalendarController->quickview (line 182)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.41 ms
(4.03%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.presta_type AS presta_type_3, t0.compta_id AS compta_id_4, t0.created_at AS created_at_5, t0.discount_money AS discount_money_6, t0.discount_percent AS discount_percent_7, t0.tva_rate AS tva_rate_8, t0.state AS state_9, t0.zone_title AS zone_title_10, t0.zone_price AS zone_price_11, t0.rythme AS rythme_12, t0.is_check_presta AS is_check_presta_13, t0.sent_at AS sent_at_14, t0.customer_id AS customer_id_15, t0.context_id AS context_id_16, t0.information_sheet_id AS information_sheet_id_17, t0.event_id AS event_id_18, t19.id AS id_20, t19.cocktail_entrance AS cocktail_entrance_21, t19.cocktail_music AS cocktail_music_22, t19.entrance_type AS entrance_type_23, t19.entrance_placement AS entrance_placement_24, t19.entrance_music AS entrance_music_25, t19.open_bal_type AS open_bal_type_26, t19.open_bal_value AS open_bal_value_27, t19.champagne_type AS champagne_type_28, t19.champagne_music AS champagne_music_29, t19.blacklist AS blacklist_30, t19.bestlist AS bestlist_31, t19.is_complete AS is_complete_32, t19.cocktail_note AS cocktail_note_33, t19.note AS note_34, t19.entrance_note AS entrance_note_35, t19.open_bar_note AS open_bar_note_36, t19.champagne_note AS champagne_note_37, t19.cocktail_music_file AS cocktail_music_file_38, t19.champagne_music_file AS champagne_music_file_39, t19.cocktail_bouquet AS cocktail_bouquet_40, t19.cocktail_bouquet_music AS cocktail_bouquet_music_41, t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42, t19.cocktail_bouquet_note AS cocktail_bouquet_note_43, t19.customer_id AS customer_id_44, t19.event_id AS event_id_45, t19.quote_id AS quote_id_46 FROM quote t0 LEFT JOIN wedding t19 ON t19.quote_id = t0.id WHERE t0.event_id = ?

Parameters:

[
  2261
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.presta_type AS presta_type_3,
  t0.compta_id AS compta_id_4,
  t0.created_at AS created_at_5,
  t0.discount_money AS discount_money_6,
  t0.discount_percent AS discount_percent_7,
  t0.tva_rate AS tva_rate_8,
  t0.state AS state_9,
  t0.zone_title AS zone_title_10,
  t0.zone_price AS zone_price_11,
  t0.rythme AS rythme_12,
  t0.is_check_presta AS is_check_presta_13,
  t0.sent_at AS sent_at_14,
  t0.customer_id AS customer_id_15,
  t0.context_id AS context_id_16,
  t0.information_sheet_id AS information_sheet_id_17,
  t0.event_id AS event_id_18,
  t19.id AS id_20,
  t19.cocktail_entrance AS cocktail_entrance_21,
  t19.cocktail_music AS cocktail_music_22,
  t19.entrance_type AS entrance_type_23,
  t19.entrance_placement AS entrance_placement_24,
  t19.entrance_music AS entrance_music_25,
  t19.open_bal_type AS open_bal_type_26,
  t19.open_bal_value AS open_bal_value_27,
  t19.champagne_type AS champagne_type_28,
  t19.champagne_music AS champagne_music_29,
  t19.blacklist AS blacklist_30,
  t19.bestlist AS bestlist_31,
  t19.is_complete AS is_complete_32,
  t19.cocktail_note AS cocktail_note_33,
  t19.note AS note_34,
  t19.entrance_note AS entrance_note_35,
  t19.open_bar_note AS open_bar_note_36,
  t19.champagne_note AS champagne_note_37,
  t19.cocktail_music_file AS cocktail_music_file_38,
  t19.champagne_music_file AS champagne_music_file_39,
  t19.cocktail_bouquet AS cocktail_bouquet_40,
  t19.cocktail_bouquet_music AS cocktail_bouquet_music_41,
  t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42,
  t19.cocktail_bouquet_note AS cocktail_bouquet_note_43,
  t19.customer_id AS customer_id_44,
  t19.event_id AS event_id_45,
  t19.quote_id AS quote_id_46
FROM
  quote t0
  LEFT JOIN wedding t19 ON t19.quote_id = t0.id
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.presta_type AS presta_type_3, t0.compta_id AS compta_id_4, t0.created_at AS created_at_5, t0.discount_money AS discount_money_6, t0.discount_percent AS discount_percent_7, t0.tva_rate AS tva_rate_8, t0.state AS state_9, t0.zone_title AS zone_title_10, t0.zone_price AS zone_price_11, t0.rythme AS rythme_12, t0.is_check_presta AS is_check_presta_13, t0.sent_at AS sent_at_14, t0.customer_id AS customer_id_15, t0.context_id AS context_id_16, t0.information_sheet_id AS information_sheet_id_17, t0.event_id AS event_id_18, t19.id AS id_20, t19.cocktail_entrance AS cocktail_entrance_21, t19.cocktail_music AS cocktail_music_22, t19.entrance_type AS entrance_type_23, t19.entrance_placement AS entrance_placement_24, t19.entrance_music AS entrance_music_25, t19.open_bal_type AS open_bal_type_26, t19.open_bal_value AS open_bal_value_27, t19.champagne_type AS champagne_type_28, t19.champagne_music AS champagne_music_29, t19.blacklist AS blacklist_30, t19.bestlist AS bestlist_31, t19.is_complete AS is_complete_32, t19.cocktail_note AS cocktail_note_33, t19.note AS note_34, t19.entrance_note AS entrance_note_35, t19.open_bar_note AS open_bar_note_36, t19.champagne_note AS champagne_note_37, t19.cocktail_music_file AS cocktail_music_file_38, t19.champagne_music_file AS champagne_music_file_39, t19.cocktail_bouquet AS cocktail_bouquet_40, t19.cocktail_bouquet_music AS cocktail_bouquet_music_41, t19.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_42, t19.cocktail_bouquet_note AS cocktail_bouquet_note_43, t19.customer_id AS customer_id_44, t19.event_id AS event_id_45, t19.quote_id AS quote_id_46 FROM quote t0 LEFT JOIN wedding t19 ON t19.quote_id = t0.id WHERE t0.event_id = 2261;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 145)
8	App\Controller\CalendarController->quickview (line 182)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.41 ms
(3.98%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.event_id AS event_id_3, t0.provider_id AS provider_id_4 FROM notification_provider t0 WHERE t0.event_id = ?

Parameters:

[
  2261
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.event_id AS event_id_3,
  t0.provider_id AS provider_id_4
FROM
  notification_provider t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.event_id AS event_id_3, t0.provider_id AS provider_id_4 FROM notification_provider t0 WHERE t0.event_id = 2261;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 368)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 272)
5	Doctrine\ORM\EntityRepository->__call (line 140)
6	App\Controller\CalendarController->quickview (line 182)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.30 ms
(2.91%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.compta_id AS compta_id_4, t0.state AS state_5, t0.paid_at AS paid_at_6, t0.sent_at AS sent_at_7, t0.tva_rate AS tva_rate_8, t0.presta_type AS presta_type_9, t0.is_credit_invoice AS is_credit_invoice_10, t0.compta_id_credit_invoice AS compta_id_credit_invoice_11, t0.credit_invoice_created_at AS credit_invoice_created_at_12, t0.payment_mode AS payment_mode_13, t0.payment_mode_number AS payment_mode_number_14, t0.reference AS reference_15, t0.notification_email AS notification_email_16, t0.discount_money AS discount_money_17, t0.discount_percent AS discount_percent_18, t0.customer_id AS customer_id_19, t0.quote_id AS quote_id_20, t0.context_id AS context_id_21, t0.event_id AS event_id_22 FROM invoice t0 WHERE t0.event_id = ?

Parameters:

[
  2261
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.compta_id AS compta_id_4,
  t0.state AS state_5,
  t0.paid_at AS paid_at_6,
  t0.sent_at AS sent_at_7,
  t0.tva_rate AS tva_rate_8,
  t0.presta_type AS presta_type_9,
  t0.is_credit_invoice AS is_credit_invoice_10,
  t0.compta_id_credit_invoice AS compta_id_credit_invoice_11,
  t0.credit_invoice_created_at AS credit_invoice_created_at_12,
  t0.payment_mode AS payment_mode_13,
  t0.payment_mode_number AS payment_mode_number_14,
  t0.reference AS reference_15,
  t0.notification_email AS notification_email_16,
  t0.discount_money AS discount_money_17,
  t0.discount_percent AS discount_percent_18,
  t0.customer_id AS customer_id_19,
  t0.quote_id AS quote_id_20,
  t0.context_id AS context_id_21,
  t0.event_id AS event_id_22
FROM
  invoice t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.compta_id AS compta_id_4, t0.state AS state_5, t0.paid_at AS paid_at_6, t0.sent_at AS sent_at_7, t0.tva_rate AS tva_rate_8, t0.presta_type AS presta_type_9, t0.is_credit_invoice AS is_credit_invoice_10, t0.compta_id_credit_invoice AS compta_id_credit_invoice_11, t0.credit_invoice_created_at AS credit_invoice_created_at_12, t0.payment_mode AS payment_mode_13, t0.payment_mode_number AS payment_mode_number_14, t0.reference AS reference_15, t0.notification_email AS notification_email_16, t0.discount_money AS discount_money_17, t0.discount_percent AS discount_percent_18, t0.customer_id AS customer_id_19, t0.quote_id AS quote_id_20, t0.context_id AS context_id_21, t0.event_id AS event_id_22 FROM invoice t0 WHERE t0.event_id = 2261;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1131)
9	twig_length_filter (line 653)
10	__TwigTemplate_864c516b673acff432dde51d4c010100->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
18	App\Controller\CalendarController->quickview (line 182)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.29 ms
(2.84%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.address AS address_4, t0.postal AS postal_5, t0.city AS city_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.company AS company_10, t0.is_pro AS is_pro_11, t0.duo_identity AS duo_identity_12, t0.note AS note_13, t0.job AS job_14, t0.age AS age_15, t0.origin AS origin_16, t0.source AS source_17, t0.public_token AS public_token_18, t0.context_id AS context_id_19 FROM customer t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.address AS address_4,
  t0.postal AS postal_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.company AS company_10,
  t0.is_pro AS is_pro_11,
  t0.duo_identity AS duo_identity_12,
  t0.note AS note_13,
  t0.job AS job_14,
  t0.age AS age_15,
  t0.origin AS origin_16,
  t0.source AS source_17,
  t0.public_token AS public_token_18,
  t0.context_id AS context_id_19
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.address AS address_4, t0.postal AS postal_5, t0.city AS city_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.company AS company_10, t0.is_pro AS is_pro_11, t0.duo_identity AS duo_identity_12, t0.note AS note_13, t0.job AS job_14, t0.age AS age_15, t0.origin AS origin_16, t0.source AS source_17, t0.public_token AS public_token_18, t0.context_id AS context_id_19 FROM customer t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Customer->__get (line 536)
8	App\Entity\Customer->getContext (line 1637)
9	twig_get_attribute (line 115)
10	__TwigTemplate_864c516b673acff432dde51d4c010100->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
18	App\Controller\CalendarController->quickview (line 182)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.28 ms
(2.73%)

SELECT t0.id AS id_1, t0.cocktail_entrance AS cocktail_entrance_2, t0.cocktail_music AS cocktail_music_3, t0.entrance_type AS entrance_type_4, t0.entrance_placement AS entrance_placement_5, t0.entrance_music AS entrance_music_6, t0.open_bal_type AS open_bal_type_7, t0.open_bal_value AS open_bal_value_8, t0.champagne_type AS champagne_type_9, t0.champagne_music AS champagne_music_10, t0.blacklist AS blacklist_11, t0.bestlist AS bestlist_12, t0.is_complete AS is_complete_13, t0.cocktail_note AS cocktail_note_14, t0.note AS note_15, t0.entrance_note AS entrance_note_16, t0.open_bar_note AS open_bar_note_17, t0.champagne_note AS champagne_note_18, t0.cocktail_music_file AS cocktail_music_file_19, t0.champagne_music_file AS champagne_music_file_20, t0.cocktail_bouquet AS cocktail_bouquet_21, t0.cocktail_bouquet_music AS cocktail_bouquet_music_22, t0.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_23, t0.cocktail_bouquet_note AS cocktail_bouquet_note_24, t0.customer_id AS customer_id_25, t0.event_id AS event_id_26, t0.quote_id AS quote_id_27 FROM wedding t0 WHERE t0.event_id = ?

Parameters:

[
  1528
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cocktail_entrance AS cocktail_entrance_2,
  t0.cocktail_music AS cocktail_music_3,
  t0.entrance_type AS entrance_type_4,
  t0.entrance_placement AS entrance_placement_5,
  t0.entrance_music AS entrance_music_6,
  t0.open_bal_type AS open_bal_type_7,
  t0.open_bal_value AS open_bal_value_8,
  t0.champagne_type AS champagne_type_9,
  t0.champagne_music AS champagne_music_10,
  t0.blacklist AS blacklist_11,
  t0.bestlist AS bestlist_12,
  t0.is_complete AS is_complete_13,
  t0.cocktail_note AS cocktail_note_14,
  t0.note AS note_15,
  t0.entrance_note AS entrance_note_16,
  t0.open_bar_note AS open_bar_note_17,
  t0.champagne_note AS champagne_note_18,
  t0.cocktail_music_file AS cocktail_music_file_19,
  t0.champagne_music_file AS champagne_music_file_20,
  t0.cocktail_bouquet AS cocktail_bouquet_21,
  t0.cocktail_bouquet_music AS cocktail_bouquet_music_22,
  t0.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_23,
  t0.cocktail_bouquet_note AS cocktail_bouquet_note_24,
  t0.customer_id AS customer_id_25,
  t0.event_id AS event_id_26,
  t0.quote_id AS quote_id_27
FROM
  wedding t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.cocktail_entrance AS cocktail_entrance_2, t0.cocktail_music AS cocktail_music_3, t0.entrance_type AS entrance_type_4, t0.entrance_placement AS entrance_placement_5, t0.entrance_music AS entrance_music_6, t0.open_bal_type AS open_bal_type_7, t0.open_bal_value AS open_bal_value_8, t0.champagne_type AS champagne_type_9, t0.champagne_music AS champagne_music_10, t0.blacklist AS blacklist_11, t0.bestlist AS bestlist_12, t0.is_complete AS is_complete_13, t0.cocktail_note AS cocktail_note_14, t0.note AS note_15, t0.entrance_note AS entrance_note_16, t0.open_bar_note AS open_bar_note_17, t0.champagne_note AS champagne_note_18, t0.cocktail_music_file AS cocktail_music_file_19, t0.champagne_music_file AS champagne_music_file_20, t0.cocktail_bouquet AS cocktail_bouquet_21, t0.cocktail_bouquet_music AS cocktail_bouquet_music_22, t0.cocktail_bouquet_music_file AS cocktail_bouquet_music_file_23, t0.cocktail_bouquet_note AS cocktail_bouquet_note_24, t0.customer_id AS customer_id_25, t0.event_id AS event_id_26, t0.quote_id AS quote_id_27 FROM wedding t0 WHERE t0.event_id = 1528;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2968)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
10	Doctrine\ORM\AbstractQuery->execute (line 901)
11	Doctrine\ORM\AbstractQuery->getResult (line 208)
12	App\Repository\EventRepository->searchBirthdayAlert (line 31)
13	App\Twig\TwigExtension->getGlobals (line 331)
14	Twig\ExtensionSet->getGlobals (line 788)
15	Twig\Environment->getGlobals (line 801)
16	Twig\Environment->mergeGlobals (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
23	App\Controller\CalendarController->quickview (line 182)
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.25 ms
(2.47%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.job AS job_6, t0.age AS age_7, t0.origin AS origin_8, t0.customer_id AS customer_id_9 FROM customer_contact t0 WHERE t0.customer_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.job AS job_6,
  t0.age AS age_7,
  t0.origin AS origin_8,
  t0.customer_id AS customer_id_9
FROM
  customer_contact t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.job AS job_6, t0.age AS age_7, t0.origin AS origin_8, t0.customer_id AS customer_id_9 FROM customer_contact t0 WHERE t0.customer_id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 491)
8	__TwigTemplate_864c516b673acff432dde51d4c010100->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 40)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 243)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
16	App\Controller\CalendarController->quickview (line 182)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.23 ms
(2.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.customer_id AS customer_id_4 FROM file t0 WHERE t0.customer_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.file AS file_3,
  t0.customer_id AS customer_id_4
FROM
  file t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.customer_id AS customer_id_4 FROM file t0 WHERE t0.customer_id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1131)
9	twig_length_filter (line 891)
10	__TwigTemplate_864c516b673acff432dde51d4c010100->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 158)
18	App\Controller\CalendarController->quickview (line 182)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\User	No errors.
App\Entity\Event	No errors.
App\Entity\Customer	No errors.
App\Entity\InformationSheet	No errors.
App\Entity\Wedding	The mappings App\Entity\Wedding#weddingCocktailSurprises and App\Entity\WeddingCocktailSurprise#wedding are inconsistent with each other. The mappings App\Entity\Wedding#weddingEntranceSurprises and App\Entity\WeddingEntranceSurprise#wedding are inconsistent with each other. The mappings App\Entity\Wedding#openBalSurprises and App\Entity\OpenBalSurprise#wedding are inconsistent with each other. The mappings App\Entity\Wedding#weddingChampagneSurprises and App\Entity\WeddingChampagneSurprise#wedding are inconsistent with each other.
App\Entity\Quote	No errors.
App\Entity\EventFile	No errors.
App\Entity\Invoice	No errors.
App\Entity\Provider	No errors.
App\Entity\NotificationProvider	No errors.
App\Entity\Context	No errors.
App\Entity\QuoteLine	No errors.
App\Entity\CostLine	No errors.
App\Entity\QuoteMaterial	The association App\Entity\QuoteMaterial#event refers to the inverse side field App\Entity\Event#quoteMaterials which does not exist.
App\Entity\WeddingMusic	No errors.
App\Entity\WeddingGenre	No errors.
App\Entity\WeddingDeroulement	No errors.
App\Entity\WeddingDeroulementSurprise	No errors.
App\Entity\WeddingCocktail	No errors.
App\Entity\WeddingCocktailSurprise	No errors.
App\Entity\WeddingEntranceSurprise	No errors.
App\Entity\OpenBalSurprise	No errors.
App\Entity\WeddingChampagneSurprise	No errors.
App\Entity\WeddingEntrance	No errors.
App\Entity\WeddingOpenBal	No errors.
App\Entity\File	No errors.
App\Entity\CustomerContact	No errors.

Symfony Profiler

GET https://manager.dreammusicevent.com/workspace/calendar/quickview/2261/event

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping