Symfony Profiler

Query Metrics

41 Database Queries

31 Different statements

116.24 ms Query time

0 Invalid entities

185 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

27.78 ms
(23.90%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM lle_hermes_template_translation t0 WHERE t0.object_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  lle_hermes_template_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM lle_hermes_template_translation t0 WHERE t0.object_id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 4000)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 129)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 278)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1226)
16	Doctrine\ORM\AbstractQuery->execute (line 1167)
17	Doctrine\ORM\AbstractQuery->getResult (line 906)
18	App\Twig\Extension\TemplateCancelEmailExtension->getCancelTemplates (line 32)
19	__TwigTemplate_855c2ea5b8b229b15c2c6a2e3c71a6ea->block_body (line 218)
20	Twig\Template->yieldBlock (line 456)
21	__TwigTemplate_e9bdd468760f7d242b96c4ca6b855eb9->block_content (line 97)
22	Twig\Template->yieldBlock (line 456)
23	__TwigTemplate_e9bdd468760f7d242b96c4ca6b855eb9->doDisplay (line 59)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_855c2ea5b8b229b15c2c6a2e3c71a6ea->doDisplay (line 55)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_61ffc25eced81cc7efbc4ed7afa1e28b->doDisplay (line 74)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Extension\CoreExtension->include (line 1522)
33	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b::block_actions (line 194)
34	Twig\Template->yieldBlock (line 456)
35	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b->block_links_actions (line 108)
36	Twig\Template->yieldBlock (line 456)
37	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b->doDisplay (line 52)
38	Twig\Template->yield (line 411)
39	__TwigTemplate_8e18a2e4780c2bfaff19e44ac103e9a9->doDisplay (line 66)
40	Twig\Template->yield (line 411)
41	__TwigTemplate_a066515090f935df7142c737805bfffb->doDisplay (line 91)
42	Twig\Template->yield (line 411)
43	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->block_content (line 135)
44	Twig\Template->yieldBlock (line 456)
45	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_main (line 470)
46	Twig\Template->yieldBlock (line 456)
47	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_body (line 351)
48	Twig\Template->yieldBlock (line 456)
49	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->doDisplay (line 113)
50	Twig\Template->yield (line 411)
51	__TwigTemplate_9db3c7da83bebe4fd9f76815c6c99890->doDisplay (line 57)
52	Twig\Template->yield (line 411)
53	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->doDisplay (line 54)
54	Twig\Template->yield (line 411)
55	Twig\Template->display (line 366)
56	Twig\Template->render (line 381)
57	Twig\TemplateWrapper->render (line 51)
58	Twig\Environment->render (line 333)
59	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
60	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
61	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
62	App\Controller\Crudit\CommandeController->show (line 54)
63	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
64	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
65	Symfony\Component\HttpKernel\Kernel->handle (line 193)
66	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
67	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
68	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
69	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
70	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
71	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
72	Symfony\Component\HttpKernel\Kernel->handle (line 179)
73	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
74	require_once (line 32)
75	require_once (line 5)

5.39 ms
(4.64%)

SELECT t0.id AS id_1, t0.to_name AS to_name_2, t0.to_email AS to_email_3, t0.data AS data_4, t0.status AS status_5, t0.open_date AS open_date_6, t0.test AS test_7, t0.tenant_id AS tenant_id_8, t0.error_message AS error_message_9, t0.mail_id AS mail_id_10, t0.cc_mail_id AS cc_mail_id_11 FROM lle_hermes_recipient t0 WHERE t0.mail_id = ?

Parameters:

[
  60189
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.to_name AS to_name_2,
  t0.to_email AS to_email_3,
  t0.data AS data_4,
  t0.status AS status_5,
  t0.open_date AS open_date_6,
  t0.test AS test_7,
  t0.tenant_id AS tenant_id_8,
  t0.error_message AS error_message_9,
  t0.mail_id AS mail_id_10,
  t0.cc_mail_id AS cc_mail_id_11
FROM
  lle_hermes_recipient t0
WHERE
  t0.mail_id = ?

SELECT t0.id AS id_1, t0.to_name AS to_name_2, t0.to_email AS to_email_3, t0.data AS data_4, t0.status AS status_5, t0.open_date AS open_date_6, t0.test AS test_7, t0.tenant_id AS tenant_id_8, t0.error_message AS error_message_9, t0.mail_id AS mail_id_10, t0.cc_mail_id AS cc_mail_id_11 FROM lle_hermes_recipient t0 WHERE t0.mail_id = 60189;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Lle\HermesBundle\Entity\Mail->countRecipients (line 209)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
11	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
12	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
13	Lle\HermesBundle\Crudit\Brick\MailSublistBrick\MailSublistFactory->getLines (line 97)
14	Lle\HermesBundle\Crudit\Brick\MailSublistBrick\MailSublistFactory->buildView (line 51)
15	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
16	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
17	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
18	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
19	App\Controller\Crudit\CommandeController->show (line 53)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
25	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
29	Symfony\Component\HttpKernel\Kernel->handle (line 179)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

3.50 ms
(3.01%)

SELECT l0_.id AS id_0, l0_.libelle AS libelle_1, l0_.subject AS subject_2, l0_.sender_name AS sender_name_3, l0_.sender_email AS sender_email_4, l0_.text AS text_5, l0_.code AS code_6, l0_.html AS html_7, l0_.unsubscriptions AS unsubscriptions_8, l0_.statistics AS statistics_9, l0_.send_to_errors AS send_to_errors_10, l0_.tenant_id AS tenant_id_11, l0_.custom_bounce_email AS custom_bounce_email_12, l0_.type AS type_13, l0_.mjml AS mjml_14 FROM lle_hermes_template l0_ WHERE l0_.code LIKE ? OR l0_.code LIKE ? OR l0_.code LIKE ? OR l0_.code LIKE ?

Parameters:

[
  "ANNULATION_MAIL_CLIENT%"
  "ANNULATION_MAIL_REFUGE%"
  "RECAP_MAIL_REFUGE%"
  "RECAP_MAIL_CLIENT%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.libelle AS libelle_1,
  l0_.subject AS subject_2,
  l0_.sender_name AS sender_name_3,
  l0_.sender_email AS sender_email_4,
  l0_.text AS text_5,
  l0_.code AS code_6,
  l0_.html AS html_7,
  l0_.unsubscriptions AS unsubscriptions_8,
  l0_.statistics AS statistics_9,
  l0_.send_to_errors AS send_to_errors_10,
  l0_.tenant_id AS tenant_id_11,
  l0_.custom_bounce_email AS custom_bounce_email_12,
  l0_.type AS type_13,
  l0_.mjml AS mjml_14
FROM
  lle_hermes_template l0_
WHERE
  l0_.code LIKE ?
  OR l0_.code LIKE ?
  OR l0_.code LIKE ?
  OR l0_.code LIKE ?

SELECT l0_.id AS id_0, l0_.libelle AS libelle_1, l0_.subject AS subject_2, l0_.sender_name AS sender_name_3, l0_.sender_email AS sender_email_4, l0_.text AS text_5, l0_.code AS code_6, l0_.html AS html_7, l0_.unsubscriptions AS unsubscriptions_8, l0_.statistics AS statistics_9, l0_.send_to_errors AS send_to_errors_10, l0_.tenant_id AS tenant_id_11, l0_.custom_bounce_email AS custom_bounce_email_12, l0_.type AS type_13, l0_.mjml AS mjml_14 FROM lle_hermes_template l0_ WHERE l0_.code LIKE 'ANNULATION_MAIL_CLIENT%' OR l0_.code LIKE 'ANNULATION_MAIL_REFUGE%' OR l0_.code LIKE 'RECAP_MAIL_REFUGE%' OR l0_.code LIKE 'RECAP_MAIL_CLIENT%';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Twig\Extension\TemplateCancelEmailExtension->getCommandeTemplates (line 49)
7	__TwigTemplate_82719596d88165b8ec7529156c3a0519->block_body (line 112)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_e9bdd468760f7d242b96c4ca6b855eb9->block_content (line 97)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_e9bdd468760f7d242b96c4ca6b855eb9->doDisplay (line 59)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_82719596d88165b8ec7529156c3a0519->doDisplay (line 55)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_61ffc25eced81cc7efbc4ed7afa1e28b->doDisplay (line 74)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Extension\CoreExtension->include (line 1522)
21	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b::block_actions (line 194)
22	Twig\Template->yieldBlock (line 456)
23	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b->block_links_actions (line 108)
24	Twig\Template->yieldBlock (line 456)
25	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b->doDisplay (line 52)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_8e18a2e4780c2bfaff19e44ac103e9a9->doDisplay (line 66)
28	Twig\Template->yield (line 411)
29	__TwigTemplate_a066515090f935df7142c737805bfffb->doDisplay (line 91)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->block_content (line 135)
32	Twig\Template->yieldBlock (line 456)
33	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_main (line 470)
34	Twig\Template->yieldBlock (line 456)
35	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_body (line 351)
36	Twig\Template->yieldBlock (line 456)
37	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->doDisplay (line 113)
38	Twig\Template->yield (line 411)
39	__TwigTemplate_9db3c7da83bebe4fd9f76815c6c99890->doDisplay (line 57)
40	Twig\Template->yield (line 411)
41	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->doDisplay (line 54)
42	Twig\Template->yield (line 411)
43	Twig\Template->display (line 366)
44	Twig\Template->render (line 381)
45	Twig\TemplateWrapper->render (line 51)
46	Twig\Environment->render (line 333)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
50	App\Controller\Crudit\CommandeController->show (line 54)
51	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
52	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
53	Symfony\Component\HttpKernel\Kernel->handle (line 193)
54	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
55	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
56	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
57	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
58	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
59	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
60	Symfony\Component\HttpKernel\Kernel->handle (line 179)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
62	require_once (line 32)
63	require_once (line 5)

3.38 ms
(2.90%)

SELECT l0_.id AS id_0, l0_.libelle AS libelle_1, l0_.subject AS subject_2, l0_.sender_name AS sender_name_3, l0_.sender_email AS sender_email_4, l0_.text AS text_5, l0_.code AS code_6, l0_.html AS html_7, l0_.unsubscriptions AS unsubscriptions_8, l0_.statistics AS statistics_9, l0_.send_to_errors AS send_to_errors_10, l0_.tenant_id AS tenant_id_11, l0_.custom_bounce_email AS custom_bounce_email_12, l0_.type AS type_13, l0_.mjml AS mjml_14 FROM lle_hermes_template l0_ WHERE l0_.code LIKE ?

Parameters:

[
  "ANNULATION_MAIL_CLIENT%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.libelle AS libelle_1,
  l0_.subject AS subject_2,
  l0_.sender_name AS sender_name_3,
  l0_.sender_email AS sender_email_4,
  l0_.text AS text_5,
  l0_.code AS code_6,
  l0_.html AS html_7,
  l0_.unsubscriptions AS unsubscriptions_8,
  l0_.statistics AS statistics_9,
  l0_.send_to_errors AS send_to_errors_10,
  l0_.tenant_id AS tenant_id_11,
  l0_.custom_bounce_email AS custom_bounce_email_12,
  l0_.type AS type_13,
  l0_.mjml AS mjml_14
FROM
  lle_hermes_template l0_
WHERE
  l0_.code LIKE ?

SELECT l0_.id AS id_0, l0_.libelle AS libelle_1, l0_.subject AS subject_2, l0_.sender_name AS sender_name_3, l0_.sender_email AS sender_email_4, l0_.text AS text_5, l0_.code AS code_6, l0_.html AS html_7, l0_.unsubscriptions AS unsubscriptions_8, l0_.statistics AS statistics_9, l0_.send_to_errors AS send_to_errors_10, l0_.tenant_id AS tenant_id_11, l0_.custom_bounce_email AS custom_bounce_email_12, l0_.type AS type_13, l0_.mjml AS mjml_14 FROM lle_hermes_template l0_ WHERE l0_.code LIKE 'ANNULATION_MAIL_CLIENT%';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Twig\Extension\TemplateCancelEmailExtension->getCancelTemplates (line 32)
7	__TwigTemplate_855c2ea5b8b229b15c2c6a2e3c71a6ea->block_body (line 218)
8	Twig\Template->yieldBlock (line 456)
9	__TwigTemplate_e9bdd468760f7d242b96c4ca6b855eb9->block_content (line 97)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_e9bdd468760f7d242b96c4ca6b855eb9->doDisplay (line 59)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_855c2ea5b8b229b15c2c6a2e3c71a6ea->doDisplay (line 55)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_61ffc25eced81cc7efbc4ed7afa1e28b->doDisplay (line 74)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Extension\CoreExtension->include (line 1522)
21	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b::block_actions (line 194)
22	Twig\Template->yieldBlock (line 456)
23	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b->block_links_actions (line 108)
24	Twig\Template->yieldBlock (line 456)
25	__TwigTemplate_0a3c85183759704f1a77c33e7850f69b->doDisplay (line 52)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_8e18a2e4780c2bfaff19e44ac103e9a9->doDisplay (line 66)
28	Twig\Template->yield (line 411)
29	__TwigTemplate_a066515090f935df7142c737805bfffb->doDisplay (line 91)
30	Twig\Template->yield (line 411)
31	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->block_content (line 135)
32	Twig\Template->yieldBlock (line 456)
33	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_main (line 470)
34	Twig\Template->yieldBlock (line 456)
35	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_body (line 351)
36	Twig\Template->yieldBlock (line 456)
37	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->doDisplay (line 113)
38	Twig\Template->yield (line 411)
39	__TwigTemplate_9db3c7da83bebe4fd9f76815c6c99890->doDisplay (line 57)
40	Twig\Template->yield (line 411)
41	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->doDisplay (line 54)
42	Twig\Template->yield (line 411)
43	Twig\Template->display (line 366)
44	Twig\Template->render (line 381)
45	Twig\TemplateWrapper->render (line 51)
46	Twig\Environment->render (line 333)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
50	App\Controller\Crudit\CommandeController->show (line 54)
51	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
52	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
53	Symfony\Component\HttpKernel\Kernel->handle (line 193)
54	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
55	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
56	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
57	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
58	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
59	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
60	Symfony\Component\HttpKernel\Kernel->handle (line 179)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
62	require_once (line 32)
63	require_once (line 5)

3.23 ms
(2.78%)

SELECT count(DISTINCT (t0_.id)) AS sclr_0 FROM transfert_paiement t0_ WHERE t0_.commande_id IN (?)

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(
    DISTINCT (t0_.id)
  ) AS sclr_0
FROM
  transfert_paiement t0_
WHERE
  t0_.commande_id IN (?)

SELECT count(DISTINCT (t0_.id)) AS sclr_0 FROM transfert_paiement t0_ WHERE t0_.commande_id IN ('401783');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->count (line 266)
8	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 81)
9	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
12	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
13	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
14	App\Controller\Crudit\CommandeController->show (line 53)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
20	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
24	Symfony\Component\HttpKernel\Kernel->handle (line 179)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.99 ms
(2.57%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.status AS status_3, t0.nb_personnes AS nb_personnes_4, t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5, t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6, t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7, t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8, t0.sous_total_du_eur AS sous_total_du_eur_9, t0.sous_total_eur AS sous_total_eur_10, t0.sous_total_du_chf AS sous_total_du_chf_11, t0.sous_total_chf AS sous_total_chf_12, t0.assurance AS assurance_13, t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14, t0.remarque_client AS remarque_client_15, t0.ref_commande AS ref_commande_16, t0.delai_annulation AS delai_annulation_17, t0.litige AS litige_18, t0.motif_litige AS motif_litige_19, t0.commentaire_litige AS commentaire_litige_20, t0.frais_annulation_eur AS frais_annulation_eur_21, t0.frais_annulation_chf AS frais_annulation_chf_22, t0.last_action AS last_action_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.client_id AS client_id_28, t0.circuit_id AS circuit_id_29, t0.cancelled_command_id AS cancelled_command_id_30, t31.id AS id_32, t31.date AS date_33, t31.status AS status_34, t31.nb_personnes AS nb_personnes_35, t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36, t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37, t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38, t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39, t31.sous_total_du_eur AS sous_total_du_eur_40, t31.sous_total_eur AS sous_total_eur_41, t31.sous_total_du_chf AS sous_total_du_chf_42, t31.sous_total_chf AS sous_total_chf_43, t31.assurance AS assurance_44, t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45, t31.remarque_client AS remarque_client_46, t31.ref_commande AS ref_commande_47, t31.delai_annulation AS delai_annulation_48, t31.litige AS litige_49, t31.motif_litige AS motif_litige_50, t31.commentaire_litige AS commentaire_litige_51, t31.frais_annulation_eur AS frais_annulation_eur_52, t31.frais_annulation_chf AS frais_annulation_chf_53, t31.last_action AS last_action_54, t31.created_at AS created_at_55, t31.updated_at AS updated_at_56, t31.created_by AS created_by_57, t31.updated_by AS updated_by_58, t31.client_id AS client_id_59, t31.circuit_id AS circuit_id_60, t31.cancelled_command_id AS cancelled_command_id_61 FROM commande t0 LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id WHERE t0.id = ?

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.status AS status_3,
  t0.nb_personnes AS nb_personnes_4,
  t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5,
  t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6,
  t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7,
  t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8,
  t0.sous_total_du_eur AS sous_total_du_eur_9,
  t0.sous_total_eur AS sous_total_eur_10,
  t0.sous_total_du_chf AS sous_total_du_chf_11,
  t0.sous_total_chf AS sous_total_chf_12,
  t0.assurance AS assurance_13,
  t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14,
  t0.remarque_client AS remarque_client_15,
  t0.ref_commande AS ref_commande_16,
  t0.delai_annulation AS delai_annulation_17,
  t0.litige AS litige_18,
  t0.motif_litige AS motif_litige_19,
  t0.commentaire_litige AS commentaire_litige_20,
  t0.frais_annulation_eur AS frais_annulation_eur_21,
  t0.frais_annulation_chf AS frais_annulation_chf_22,
  t0.last_action AS last_action_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.created_by AS created_by_26,
  t0.updated_by AS updated_by_27,
  t0.client_id AS client_id_28,
  t0.circuit_id AS circuit_id_29,
  t0.cancelled_command_id AS cancelled_command_id_30,
  t31.id AS id_32,
  t31.date AS date_33,
  t31.status AS status_34,
  t31.nb_personnes AS nb_personnes_35,
  t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36,
  t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37,
  t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38,
  t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39,
  t31.sous_total_du_eur AS sous_total_du_eur_40,
  t31.sous_total_eur AS sous_total_eur_41,
  t31.sous_total_du_chf AS sous_total_du_chf_42,
  t31.sous_total_chf AS sous_total_chf_43,
  t31.assurance AS assurance_44,
  t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45,
  t31.remarque_client AS remarque_client_46,
  t31.ref_commande AS ref_commande_47,
  t31.delai_annulation AS delai_annulation_48,
  t31.litige AS litige_49,
  t31.motif_litige AS motif_litige_50,
  t31.commentaire_litige AS commentaire_litige_51,
  t31.frais_annulation_eur AS frais_annulation_eur_52,
  t31.frais_annulation_chf AS frais_annulation_chf_53,
  t31.last_action AS last_action_54,
  t31.created_at AS created_at_55,
  t31.updated_at AS updated_at_56,
  t31.created_by AS created_by_57,
  t31.updated_by AS updated_by_58,
  t31.client_id AS client_id_59,
  t31.circuit_id AS circuit_id_60,
  t31.cancelled_command_id AS cancelled_command_id_61
FROM
  commande t0
  LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.status AS status_3, t0.nb_personnes AS nb_personnes_4, t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5, t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6, t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7, t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8, t0.sous_total_du_eur AS sous_total_du_eur_9, t0.sous_total_eur AS sous_total_eur_10, t0.sous_total_du_chf AS sous_total_du_chf_11, t0.sous_total_chf AS sous_total_chf_12, t0.assurance AS assurance_13, t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14, t0.remarque_client AS remarque_client_15, t0.ref_commande AS ref_commande_16, t0.delai_annulation AS delai_annulation_17, t0.litige AS litige_18, t0.motif_litige AS motif_litige_19, t0.commentaire_litige AS commentaire_litige_20, t0.frais_annulation_eur AS frais_annulation_eur_21, t0.frais_annulation_chf AS frais_annulation_chf_22, t0.last_action AS last_action_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.client_id AS client_id_28, t0.circuit_id AS circuit_id_29, t0.cancelled_command_id AS cancelled_command_id_30, t31.id AS id_32, t31.date AS date_33, t31.status AS status_34, t31.nb_personnes AS nb_personnes_35, t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36, t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37, t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38, t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39, t31.sous_total_du_eur AS sous_total_du_eur_40, t31.sous_total_eur AS sous_total_eur_41, t31.sous_total_du_chf AS sous_total_du_chf_42, t31.sous_total_chf AS sous_total_chf_43, t31.assurance AS assurance_44, t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45, t31.remarque_client AS remarque_client_46, t31.ref_commande AS ref_commande_47, t31.delai_annulation AS delai_annulation_48, t31.litige AS litige_49, t31.motif_litige AS motif_litige_50, t31.commentaire_litige AS commentaire_litige_51, t31.frais_annulation_eur AS frais_annulation_eur_52, t31.frais_annulation_chf AS frais_annulation_chf_53, t31.last_action AS last_action_54, t31.created_at AS created_at_55, t31.updated_at AS updated_at_56, t31.created_by AS created_by_57, t31.updated_by AS updated_by_58, t31.client_id AS client_id_59, t31.circuit_id AS circuit_id_60, t31.cancelled_command_id AS cancelled_command_id_61 FROM commande t0 LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id WHERE t0.id = '401783';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->get (line 72)
6	App\Controller\Crudit\CommandeController->getResource (line 338)
7	App\Controller\Crudit\CommandeController->show (line 44)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
13	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
17	Symfony\Component\HttpKernel\Kernel->handle (line 179)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

2.95 ms
(2.54%)

SELECT count(DISTINCT (v0_.id)) AS sclr_0 FROM voyageur v0_ WHERE v0_.commande_id IN (?)

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(
    DISTINCT (v0_.id)
  ) AS sclr_0
FROM
  voyageur v0_
WHERE
  v0_.commande_id IN (?)

SELECT count(DISTINCT (v0_.id)) AS sclr_0 FROM voyageur v0_ WHERE v0_.commande_id IN ('401783');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->count (line 266)
8	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 81)
9	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
12	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
13	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
14	App\Controller\Crudit\CommandeController->show (line 53)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
20	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
24	Symfony\Component\HttpKernel\Kernel->handle (line 179)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.94 ms
(2.53%)

SELECT t0.id AS id_1, t0.age_min AS age_min_2, t0.age_max AS age_max_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.enfant AS enfant_7, t0.acompte AS acompte_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.refuge_id AS refuge_id_13, t0.roomtype_id AS roomtype_id_14 FROM taxe_sejour_config t0 WHERE t0.id = ?

Parameters:

[
  65
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.age_min AS age_min_2,
  t0.age_max AS age_max_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.prix AS prix_6,
  t0.enfant AS enfant_7,
  t0.acompte AS acompte_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12,
  t0.refuge_id AS refuge_id_13,
  t0.roomtype_id AS roomtype_id_14
FROM
  taxe_sejour_config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.age_min AS age_min_2, t0.age_max AS age_max_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.prix AS prix_6, t0.enfant AS enfant_7, t0.acompte AS acompte_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.refuge_id AS refuge_id_13, t0.roomtype_id AS roomtype_id_14 FROM taxe_sejour_config t0 WHERE t0.id = 65;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\TaxeSejourConfig::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\TaxeSejourConfig->__get (line 153)
7	App\Entity\TaxeSejourConfig->__toString (line 52)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_1cd82688447b51f78122c5b92c2982df->doDisplay (line 105)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_8b4b03d3ce73dc1333bf6a3f741185e4->doDisplay (line 68)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1f854564388d6fd4cf13823f9838b83d->doDisplay (line 183)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_a066515090f935df7142c737805bfffb->doDisplay (line 91)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->block_content (line 135)
18	Twig\Template->yieldBlock (line 456)
19	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_main (line 470)
20	Twig\Template->yieldBlock (line 456)
21	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->block_body (line 351)
22	Twig\Template->yieldBlock (line 456)
23	__TwigTemplate_4022bbe6b9b5cd4b1cdb8806901f5797->doDisplay (line 113)
24	Twig\Template->yield (line 411)
25	__TwigTemplate_9db3c7da83bebe4fd9f76815c6c99890->doDisplay (line 57)
26	Twig\Template->yield (line 411)
27	__TwigTemplate_5a416c030c4b281ab23075180debe8a3->doDisplay (line 54)
28	Twig\Template->yield (line 411)
29	Twig\Template->display (line 366)
30	Twig\Template->render (line 381)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
36	App\Controller\Crudit\CommandeController->show (line 54)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
42	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
44	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
46	Symfony\Component\HttpKernel\Kernel->handle (line 179)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 32)
49	require_once (line 5)

2.91 ms
(2.51%)

SELECT t0.id AS id_1, t0.montant_paye AS montant_paye_2, t0.montant_du AS montant_du_3, t0.montant_total AS montant_total_4, t0.delai_annulation AS delai_annulation_5, t0.status AS status_6, t0.calc_date_arrivee AS calc_date_arrivee_7, t0.calc_date_depart AS calc_date_depart_8, t0.montant_rembourse AS montant_rembourse_9, t0.note_interne AS note_interne_10, t0.pms_reservation_id AS pms_reservation_id_11, t0.mail_refuge_sent AS mail_refuge_sent_12, t0.frais_annulation AS frais_annulation_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.refuge_id AS refuge_id_18, t0.currency_id AS currency_id_19, t0.commande_id AS commande_id_20, t21.id AS id_22, t21.status AS status_23, t21.request_xml AS request_xml_24, t21.scheduled_at AS scheduled_at_25, t21.created_at AS created_at_26, t21.updated_at AS updated_at_27, t21.created_by AS created_by_28, t21.updated_by AS updated_by_29, t21.reservation_id AS reservation_id_30, t21.refuge_id AS refuge_id_31, t0.cancelled_reservation_id AS cancelled_reservation_id_32, t33.id AS id_34, t33.montant_paye AS montant_paye_35, t33.montant_du AS montant_du_36, t33.montant_total AS montant_total_37, t33.delai_annulation AS delai_annulation_38, t33.status AS status_39, t33.calc_date_arrivee AS calc_date_arrivee_40, t33.calc_date_depart AS calc_date_depart_41, t33.montant_rembourse AS montant_rembourse_42, t33.note_interne AS note_interne_43, t33.pms_reservation_id AS pms_reservation_id_44, t33.mail_refuge_sent AS mail_refuge_sent_45, t33.frais_annulation AS frais_annulation_46, t33.created_at AS created_at_47, t33.updated_at AS updated_at_48, t33.created_by AS created_by_49, t33.updated_by AS updated_by_50, t33.refuge_id AS refuge_id_51, t33.currency_id AS currency_id_52, t33.commande_id AS commande_id_53, t33.cancelled_reservation_id AS cancelled_reservation_id_54 FROM reservation t0 LEFT JOIN pms_booking_dispatch t21 ON t21.reservation_id = t0.id LEFT JOIN reservation t33 ON t33.cancelled_reservation_id = t0.id WHERE t0.commande_id = ?

Parameters:

[
  401783
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.montant_paye AS montant_paye_2,
  t0.montant_du AS montant_du_3,
  t0.montant_total AS montant_total_4,
  t0.delai_annulation AS delai_annulation_5,
  t0.status AS status_6,
  t0.calc_date_arrivee AS calc_date_arrivee_7,
  t0.calc_date_depart AS calc_date_depart_8,
  t0.montant_rembourse AS montant_rembourse_9,
  t0.note_interne AS note_interne_10,
  t0.pms_reservation_id AS pms_reservation_id_11,
  t0.mail_refuge_sent AS mail_refuge_sent_12,
  t0.frais_annulation AS frais_annulation_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17,
  t0.refuge_id AS refuge_id_18,
  t0.currency_id AS currency_id_19,
  t0.commande_id AS commande_id_20,
  t21.id AS id_22,
  t21.status AS status_23,
  t21.request_xml AS request_xml_24,
  t21.scheduled_at AS scheduled_at_25,
  t21.created_at AS created_at_26,
  t21.updated_at AS updated_at_27,
  t21.created_by AS created_by_28,
  t21.updated_by AS updated_by_29,
  t21.reservation_id AS reservation_id_30,
  t21.refuge_id AS refuge_id_31,
  t0.cancelled_reservation_id AS cancelled_reservation_id_32,
  t33.id AS id_34,
  t33.montant_paye AS montant_paye_35,
  t33.montant_du AS montant_du_36,
  t33.montant_total AS montant_total_37,
  t33.delai_annulation AS delai_annulation_38,
  t33.status AS status_39,
  t33.calc_date_arrivee AS calc_date_arrivee_40,
  t33.calc_date_depart AS calc_date_depart_41,
  t33.montant_rembourse AS montant_rembourse_42,
  t33.note_interne AS note_interne_43,
  t33.pms_reservation_id AS pms_reservation_id_44,
  t33.mail_refuge_sent AS mail_refuge_sent_45,
  t33.frais_annulation AS frais_annulation_46,
  t33.created_at AS created_at_47,
  t33.updated_at AS updated_at_48,
  t33.created_by AS created_by_49,
  t33.updated_by AS updated_by_50,
  t33.refuge_id AS refuge_id_51,
  t33.currency_id AS currency_id_52,
  t33.commande_id AS commande_id_53,
  t33.cancelled_reservation_id AS cancelled_reservation_id_54
FROM
  reservation t0
  LEFT JOIN pms_booking_dispatch t21 ON t21.reservation_id = t0.id
  LEFT JOIN reservation t33 ON t33.cancelled_reservation_id = t0.id
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.montant_paye AS montant_paye_2, t0.montant_du AS montant_du_3, t0.montant_total AS montant_total_4, t0.delai_annulation AS delai_annulation_5, t0.status AS status_6, t0.calc_date_arrivee AS calc_date_arrivee_7, t0.calc_date_depart AS calc_date_depart_8, t0.montant_rembourse AS montant_rembourse_9, t0.note_interne AS note_interne_10, t0.pms_reservation_id AS pms_reservation_id_11, t0.mail_refuge_sent AS mail_refuge_sent_12, t0.frais_annulation AS frais_annulation_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.refuge_id AS refuge_id_18, t0.currency_id AS currency_id_19, t0.commande_id AS commande_id_20, t21.id AS id_22, t21.status AS status_23, t21.request_xml AS request_xml_24, t21.scheduled_at AS scheduled_at_25, t21.created_at AS created_at_26, t21.updated_at AS updated_at_27, t21.created_by AS created_by_28, t21.updated_by AS updated_by_29, t21.reservation_id AS reservation_id_30, t21.refuge_id AS refuge_id_31, t0.cancelled_reservation_id AS cancelled_reservation_id_32, t33.id AS id_34, t33.montant_paye AS montant_paye_35, t33.montant_du AS montant_du_36, t33.montant_total AS montant_total_37, t33.delai_annulation AS delai_annulation_38, t33.status AS status_39, t33.calc_date_arrivee AS calc_date_arrivee_40, t33.calc_date_depart AS calc_date_depart_41, t33.montant_rembourse AS montant_rembourse_42, t33.note_interne AS note_interne_43, t33.pms_reservation_id AS pms_reservation_id_44, t33.mail_refuge_sent AS mail_refuge_sent_45, t33.frais_annulation AS frais_annulation_46, t33.created_at AS created_at_47, t33.updated_at AS updated_at_48, t33.created_by AS created_by_49, t33.updated_by AS updated_by_50, t33.refuge_id AS refuge_id_51, t33.currency_id AS currency_id_52, t33.commande_id AS commande_id_53, t33.cancelled_reservation_id AS cancelled_reservation_id_54 FROM reservation t0 LEFT JOIN pms_booking_dispatch t21 ON t21.reservation_id = t0.id LEFT JOIN reservation t33 ON t33.cancelled_reservation_id = t0.id WHERE t0.commande_id = 401783;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 535)
9	App\Entity\Commande->getErrors (line 443)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
12	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
13	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
14	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
15	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->getResourceView (line 62)
16	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->buildView (line 27)
17	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
18	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
19	App\Controller\Crudit\CommandeController->show (line 53)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
25	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
29	Symfony\Component\HttpKernel\Kernel->handle (line 179)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

2.89 ms
(2.49%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM currency t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.symbol AS symbol_3,
  t0.prefix AS prefix_4,
  t0.suffix AS suffix_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM currency t0 WHERE t0.id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Currency::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Currency->__get (line 153)
7	App\Entity\Currency->__toString (line 71)
8	App\Twig\Extension\CurrencyExtension->formatCurrency (line 27)
9	__TwigTemplate_45f1396e42dfe24fe0970261c401719c->doDisplay (line 55)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Lle\CruditBundle\Field\AbstractField->render (line 48)
16	Lle\CruditBundle\Field\AbstractField->buildView (line 40)
17	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 102)
18	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
19	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
20	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 85)
21	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
22	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
23	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
24	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
25	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
26	App\Controller\Crudit\CommandeController->show (line 53)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
32	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
36	Symfony\Component\HttpKernel\Kernel->handle (line 179)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

2.89 ms
(2.49%)

SELECT t0.id AS id_1, t0.date_arrivee AS date_arrivee_2, t0.date_depart AS date_depart_3, t0.prix AS prix_4, t0.nb_jours AS nb_jours_5, t0.nb_personnes AS nb_personnes_6, t0.quantite AS quantite_7, t0.acompte AS acompte_8, t0.prix_unitaire AS prix_unitaire_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.room_type_id AS room_type_id_14, t0.currency_id AS currency_id_15, t0.reservation_id AS reservation_id_16, t0.refuge_id AS refuge_id_17 FROM sejour t0 WHERE t0.reservation_id = ?

Parameters:

[
  74713
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_arrivee AS date_arrivee_2,
  t0.date_depart AS date_depart_3,
  t0.prix AS prix_4,
  t0.nb_jours AS nb_jours_5,
  t0.nb_personnes AS nb_personnes_6,
  t0.quantite AS quantite_7,
  t0.acompte AS acompte_8,
  t0.prix_unitaire AS prix_unitaire_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.room_type_id AS room_type_id_14,
  t0.currency_id AS currency_id_15,
  t0.reservation_id AS reservation_id_16,
  t0.refuge_id AS refuge_id_17
FROM
  sejour t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.date_arrivee AS date_arrivee_2, t0.date_depart AS date_depart_3, t0.prix AS prix_4, t0.nb_jours AS nb_jours_5, t0.nb_personnes AS nb_personnes_6, t0.quantite AS quantite_7, t0.acompte AS acompte_8, t0.prix_unitaire AS prix_unitaire_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.room_type_id AS room_type_id_14, t0.currency_id AS currency_id_15, t0.reservation_id AS reservation_id_16, t0.refuge_id AS refuge_id_17 FROM sejour t0 WHERE t0.reservation_id = 74713;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Reservation->getNbTaxeSejour (line 406)
8	App\Entity\Commande->getErrors (line 485)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
11	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
12	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
13	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
14	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->getResourceView (line 62)
15	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->buildView (line 27)
16	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
17	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
18	App\Controller\Crudit\CommandeController->show (line 53)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
24	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
28	Symfony\Component\HttpKernel\Kernel->handle (line 179)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

2.87 ms
(2.47%)

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.currency AS currency_3, t0.status AS status_4, t0.reference AS reference_5, t0.checkout_session_id AS checkout_session_id_6, t0.payment_intent_id AS payment_intent_id_7, t0.checkout_url AS checkout_url_8, t0.refunded AS refunded_9, t0.balance AS balance_10, t0.fee AS fee_11, t0.is_lien_paiement AS is_lien_paiement_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.commande_id AS commande_id_17 FROM payment t0 WHERE t0.commande_id = ?

Parameters:

[
  401783
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.currency AS currency_3,
  t0.status AS status_4,
  t0.reference AS reference_5,
  t0.checkout_session_id AS checkout_session_id_6,
  t0.payment_intent_id AS payment_intent_id_7,
  t0.checkout_url AS checkout_url_8,
  t0.refunded AS refunded_9,
  t0.balance AS balance_10,
  t0.fee AS fee_11,
  t0.is_lien_paiement AS is_lien_paiement_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.commande_id AS commande_id_17
FROM
  payment t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.currency AS currency_3, t0.status AS status_4, t0.reference AS reference_5, t0.checkout_session_id AS checkout_session_id_6, t0.payment_intent_id AS payment_intent_id_7, t0.checkout_url AS checkout_url_8, t0.refunded AS refunded_9, t0.balance AS balance_10, t0.fee AS fee_11, t0.is_lien_paiement AS is_lien_paiement_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.commande_id AS commande_id_17 FROM payment t0 WHERE t0.commande_id = 401783;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Commande->getTotalPayeEur (line 237)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
11	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
12	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
13	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->getResourceView (line 62)
14	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->buildView (line 27)
15	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
16	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
17	App\Controller\Crudit\CommandeController->show (line 53)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
23	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
27	Symfony\Component\HttpKernel\Kernel->handle (line 179)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

2.86 ms
(2.46%)

SELECT DISTINCT l0_.id AS id_0, l0_.sender_name AS sender_name_1, l0_.sender_email AS sender_email_2, l0_.data AS data_3, l0_.status AS status_4, l0_.total_to_send AS total_to_send_5, l0_.total_sended AS total_sended_6, l0_.subject AS subject_7, l0_.sending_date AS sending_date_8, l0_.send_at_date AS send_at_date_9, l0_.text AS text_10, l0_.html AS html_11, l0_.created_at AS created_at_12, l0_.updated_at AS updated_at_13, l0_.total_unsubscribed AS total_unsubscribed_14, l0_.total_error AS total_error_15, l0_.attachement AS attachement_16, l0_.total_opened AS total_opened_17, l0_.tenant_id AS tenant_id_18, l0_.dsn AS dsn_19, l0_.attachments_deleted AS attachments_deleted_20, l0_.entity_class AS entity_class_21, l0_.entity_id AS entity_id_22, l0_.mjml AS mjml_23, l0_.locale AS locale_24, l0_.template_id AS template_id_25 FROM lle_hermes_mail l0_ WHERE l0_.entity_class = ? AND l0_.entity_id = ? LIMIT 30

Parameters:

[
  "App\Entity\Commande"
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.sender_name AS sender_name_1,
  l0_.sender_email AS sender_email_2,
  l0_.data AS data_3,
  l0_.status AS status_4,
  l0_.total_to_send AS total_to_send_5,
  l0_.total_sended AS total_sended_6,
  l0_.subject AS subject_7,
  l0_.sending_date AS sending_date_8,
  l0_.send_at_date AS send_at_date_9,
  l0_.text AS text_10,
  l0_.html AS html_11,
  l0_.created_at AS created_at_12,
  l0_.updated_at AS updated_at_13,
  l0_.total_unsubscribed AS total_unsubscribed_14,
  l0_.total_error AS total_error_15,
  l0_.attachement AS attachement_16,
  l0_.total_opened AS total_opened_17,
  l0_.tenant_id AS tenant_id_18,
  l0_.dsn AS dsn_19,
  l0_.attachments_deleted AS attachments_deleted_20,
  l0_.entity_class AS entity_class_21,
  l0_.entity_id AS entity_id_22,
  l0_.mjml AS mjml_23,
  l0_.locale AS locale_24,
  l0_.template_id AS template_id_25
FROM
  lle_hermes_mail l0_
WHERE
  l0_.entity_class = ?
  AND l0_.entity_id = ?
LIMIT
  30

SELECT DISTINCT l0_.id AS id_0, l0_.sender_name AS sender_name_1, l0_.sender_email AS sender_email_2, l0_.data AS data_3, l0_.status AS status_4, l0_.total_to_send AS total_to_send_5, l0_.total_sended AS total_sended_6, l0_.subject AS subject_7, l0_.sending_date AS sending_date_8, l0_.send_at_date AS send_at_date_9, l0_.text AS text_10, l0_.html AS html_11, l0_.created_at AS created_at_12, l0_.updated_at AS updated_at_13, l0_.total_unsubscribed AS total_unsubscribed_14, l0_.total_error AS total_error_15, l0_.attachement AS attachement_16, l0_.total_opened AS total_opened_17, l0_.tenant_id AS tenant_id_18, l0_.dsn AS dsn_19, l0_.attachments_deleted AS attachments_deleted_20, l0_.entity_class AS entity_class_21, l0_.entity_id AS entity_id_22, l0_.mjml AS mjml_23, l0_.locale AS locale_24, l0_.template_id AS template_id_25 FROM lle_hermes_mail l0_ WHERE l0_.entity_class = 'App\\Entity\\Commande' AND l0_.entity_id = '401783' LIMIT 30;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->list (line 92)
6	Lle\HermesBundle\Crudit\Brick\MailSublistBrick\MailSublistFactory->getLines (line 94)
7	Lle\HermesBundle\Crudit\Brick\MailSublistBrick\MailSublistFactory->buildView (line 51)
8	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
9	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
12	App\Controller\Crudit\CommandeController->show (line 53)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
22	Symfony\Component\HttpKernel\Kernel->handle (line 179)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

2.85 ms
(2.46%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM roomtype_translation t0 WHERE t0.object_id = ?

Parameters:

[
  663
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  roomtype_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM roomtype_translation t0 WHERE t0.object_id = 663;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 4000)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 55)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 278)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 787)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
17	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
18	Proxies\__CG__\App\Entity\Roomtype::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
19	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
20	Proxies\__CG__\App\Entity\Roomtype->__isset (line 258)
21	App\Entity\Roomtype->__toString (line 104)
22	Twig\Runtime\EscaperRuntime->escape (line 126)
23	__TwigTemplate_055423f8ecb8d059273915013af24104->doDisplay (line 68)
24	Twig\Template->yield (line 411)
25	Twig\Template->display (line 366)
26	Twig\Template->render (line 381)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Lle\CruditBundle\Field\AbstractField->render (line 48)
30	Lle\CruditBundle\Field\AbstractField->buildView (line 40)
31	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 102)
32	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
33	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
34	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 85)
35	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
36	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
37	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
38	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
39	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
40	App\Controller\Crudit\CommandeController->show (line 53)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
43	Symfony\Component\HttpKernel\Kernel->handle (line 193)
44	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
46	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
47	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
48	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
49	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
50	Symfony\Component\HttpKernel\Kernel->handle (line 179)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
52	require_once (line 32)
53	require_once (line 5)

2.84 ms
(2.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_role AS is_role_3, t0.active AS active_4, t0.required_role AS required_role_5, t0.rank AS rank_6, t0.label AS label_7 FROM lle_credential_group t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_role AS is_role_3,
  t0.active AS active_4,
  t0.required_role AS required_role_5,
  t0.rank AS rank_6,
  t0.label AS label_7
FROM
  lle_credential_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_role AS is_role_3, t0.active AS active_4, t0.required_role AS required_role_5, t0.rank AS rank_6, t0.label AS label_7 FROM lle_credential_group t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\Lle\CredentialBundle\Entity\Group::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\Lle\CredentialBundle\Entity\Group->__get (line 153)
7	Lle\CredentialBundle\Entity\Group->getName (line 93)
8	App\Entity\User->getRoles (line 119)
9	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 329)
10	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 230)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
24	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
28	Symfony\Component\HttpKernel\Kernel->handle (line 179)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

2.84 ms
(2.44%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.altitude AS altitude_4, t0.tel AS tel_5, t0.web AS web_6, t0.email AS email_7, t0.description AS description_8, t0.tarif_indicatif AS tarif_indicatif_9, t0.capacite AS capacite_10, t0.cp AS cp_11, t0.ville AS ville_12, t0.nom_gardien AS nom_gardien_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.adresse AS adresse_16, t0.adresse2 AS adresse2_17, t0.acces AS acces_18, t0.info AS info_19, t0.photo AS photo_20, t0.tel_mobile AS tel_mobile_21, t0.tel_hors_saison AS tel_hors_saison_22, t0.photo_gardien AS photo_gardien_23, t0.age_max_enfant AS age_max_enfant_24, t0.stripe_account_id AS stripe_account_id_25, t0.heure_ouverture_tel AS heure_ouverture_tel_26, t0.tri AS tri_27, t0.pms_endpoint AS pms_endpoint_28, t0.pms_username AS pms_username_29, t0.pms_password AS pms_password_30, t0.texte_mail_resa_client AS texte_mail_resa_client_31, t0.heure_max_arrivee AS heure_max_arrivee_32, t0.heure_max_depart AS heure_max_depart_33, t0.heure_repas AS heure_repas_34, t0.pms_rateplan_code AS pms_rateplan_code_35, t0.actif AS actif_36, t0.arhon_id AS arhon_id_37, t0.delai_reservation AS delai_reservation_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.created_by AS created_by_41, t0.updated_by AS updated_by_42, t0.country_id AS country_id_43, t0.currency_id AS currency_id_44, t0.zone_geographique_id AS zone_geographique_id_45, t46.id AS id_47, t46.libelle AS libelle_48, t46.lat AS lat_49, t46.lng AS lng_50, t46.tri AS tri_51, t46.created_at AS created_at_52, t46.updated_at AS updated_at_53, t46.created_by AS created_by_54, t46.updated_by AS updated_by_55 FROM refuge t0 LEFT JOIN zone_geographique t46 ON t0.zone_geographique_id = t46.id WHERE t0.id = ?

Parameters:

[
  32398
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.altitude AS altitude_4,
  t0.tel AS tel_5,
  t0.web AS web_6,
  t0.email AS email_7,
  t0.description AS description_8,
  t0.tarif_indicatif AS tarif_indicatif_9,
  t0.capacite AS capacite_10,
  t0.cp AS cp_11,
  t0.ville AS ville_12,
  t0.nom_gardien AS nom_gardien_13,
  t0.lat AS lat_14,
  t0.lng AS lng_15,
  t0.adresse AS adresse_16,
  t0.adresse2 AS adresse2_17,
  t0.acces AS acces_18,
  t0.info AS info_19,
  t0.photo AS photo_20,
  t0.tel_mobile AS tel_mobile_21,
  t0.tel_hors_saison AS tel_hors_saison_22,
  t0.photo_gardien AS photo_gardien_23,
  t0.age_max_enfant AS age_max_enfant_24,
  t0.stripe_account_id AS stripe_account_id_25,
  t0.heure_ouverture_tel AS heure_ouverture_tel_26,
  t0.tri AS tri_27,
  t0.pms_endpoint AS pms_endpoint_28,
  t0.pms_username AS pms_username_29,
  t0.pms_password AS pms_password_30,
  t0.texte_mail_resa_client AS texte_mail_resa_client_31,
  t0.heure_max_arrivee AS heure_max_arrivee_32,
  t0.heure_max_depart AS heure_max_depart_33,
  t0.heure_repas AS heure_repas_34,
  t0.pms_rateplan_code AS pms_rateplan_code_35,
  t0.actif AS actif_36,
  t0.arhon_id AS arhon_id_37,
  t0.delai_reservation AS delai_reservation_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.created_by AS created_by_41,
  t0.updated_by AS updated_by_42,
  t0.country_id AS country_id_43,
  t0.currency_id AS currency_id_44,
  t0.zone_geographique_id AS zone_geographique_id_45,
  t46.id AS id_47,
  t46.libelle AS libelle_48,
  t46.lat AS lat_49,
  t46.lng AS lng_50,
  t46.tri AS tri_51,
  t46.created_at AS created_at_52,
  t46.updated_at AS updated_at_53,
  t46.created_by AS created_by_54,
  t46.updated_by AS updated_by_55
FROM
  refuge t0
  LEFT JOIN zone_geographique t46 ON t0.zone_geographique_id = t46.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.altitude AS altitude_4, t0.tel AS tel_5, t0.web AS web_6, t0.email AS email_7, t0.description AS description_8, t0.tarif_indicatif AS tarif_indicatif_9, t0.capacite AS capacite_10, t0.cp AS cp_11, t0.ville AS ville_12, t0.nom_gardien AS nom_gardien_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.adresse AS adresse_16, t0.adresse2 AS adresse2_17, t0.acces AS acces_18, t0.info AS info_19, t0.photo AS photo_20, t0.tel_mobile AS tel_mobile_21, t0.tel_hors_saison AS tel_hors_saison_22, t0.photo_gardien AS photo_gardien_23, t0.age_max_enfant AS age_max_enfant_24, t0.stripe_account_id AS stripe_account_id_25, t0.heure_ouverture_tel AS heure_ouverture_tel_26, t0.tri AS tri_27, t0.pms_endpoint AS pms_endpoint_28, t0.pms_username AS pms_username_29, t0.pms_password AS pms_password_30, t0.texte_mail_resa_client AS texte_mail_resa_client_31, t0.heure_max_arrivee AS heure_max_arrivee_32, t0.heure_max_depart AS heure_max_depart_33, t0.heure_repas AS heure_repas_34, t0.pms_rateplan_code AS pms_rateplan_code_35, t0.actif AS actif_36, t0.arhon_id AS arhon_id_37, t0.delai_reservation AS delai_reservation_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.created_by AS created_by_41, t0.updated_by AS updated_by_42, t0.country_id AS country_id_43, t0.currency_id AS currency_id_44, t0.zone_geographique_id AS zone_geographique_id_45, t46.id AS id_47, t46.libelle AS libelle_48, t46.lat AS lat_49, t46.lng AS lng_50, t46.tri AS tri_51, t46.created_at AS created_at_52, t46.updated_at AS updated_at_53, t46.created_by AS created_by_54, t46.updated_by AS updated_by_55 FROM refuge t0 LEFT JOIN zone_geographique t46 ON t0.zone_geographique_id = t46.id WHERE t0.id = 32398;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Refuge::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Refuge->__get (line 153)
7	App\Entity\Refuge->__toString (line 259)
8	App\Entity\Reservation->__toString (line 105)
9	App\Entity\Reservation->getToString (line 110)
10	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
11	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
12	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
13	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
14	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
15	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 85)
16	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
17	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
18	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
19	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
20	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
21	App\Controller\Crudit\CommandeController->show (line 53)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
27	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
31	Symfony\Component\HttpKernel\Kernel->handle (line 179)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

2.82 ms
(2.42%)

SELECT DISTINCT t0_.id AS id_0, t0_.statut AS statut_1, t0_.montant AS montant_2, t0_.devise AS devise_3, t0_.message AS message_4, t0_.nombre_essais AS nombre_essais_5, t0_.transfer_id AS transfer_id_6, t0_.reversed AS reversed_7, t0_.solde AS solde_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.created_by AS created_by_11, t0_.updated_by AS updated_by_12, t0_.payment_id AS payment_id_13, t0_.commande_id AS commande_id_14, t0_.refuge_id AS refuge_id_15, t0_.reservation_id AS reservation_id_16 FROM transfert_paiement t0_ WHERE t0_.commande_id IN (?) ORDER BY t0_.created_at ASC LIMIT 30

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.statut AS statut_1,
  t0_.montant AS montant_2,
  t0_.devise AS devise_3,
  t0_.message AS message_4,
  t0_.nombre_essais AS nombre_essais_5,
  t0_.transfer_id AS transfer_id_6,
  t0_.reversed AS reversed_7,
  t0_.solde AS solde_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  t0_.created_by AS created_by_11,
  t0_.updated_by AS updated_by_12,
  t0_.payment_id AS payment_id_13,
  t0_.commande_id AS commande_id_14,
  t0_.refuge_id AS refuge_id_15,
  t0_.reservation_id AS reservation_id_16
FROM
  transfert_paiement t0_
WHERE
  t0_.commande_id IN (?)
ORDER BY
  t0_.created_at ASC
LIMIT
  30

SELECT DISTINCT t0_.id AS id_0, t0_.statut AS statut_1, t0_.montant AS montant_2, t0_.devise AS devise_3, t0_.message AS message_4, t0_.nombre_essais AS nombre_essais_5, t0_.transfer_id AS transfer_id_6, t0_.reversed AS reversed_7, t0_.solde AS solde_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.created_by AS created_by_11, t0_.updated_by AS updated_by_12, t0_.payment_id AS payment_id_13, t0_.commande_id AS commande_id_14, t0_.refuge_id AS refuge_id_15, t0_.reservation_id AS reservation_id_16 FROM transfert_paiement t0_ WHERE t0_.commande_id IN ('401783') ORDER BY t0_.created_at ASC LIMIT 30;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->list (line 92)
6	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 82)
7	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
8	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
9	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
12	App\Controller\Crudit\CommandeController->show (line 53)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
22	Symfony\Component\HttpKernel\Kernel->handle (line 179)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

2.81 ms
(2.42%)

SELECT count(DISTINCT (l0_.id)) AS sclr_0 FROM lle_hermes_mail l0_ WHERE l0_.entity_class = ? AND l0_.entity_id = ?

Parameters:

[
  "App\Entity\Commande"
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(
    DISTINCT (l0_.id)
  ) AS sclr_0
FROM
  lle_hermes_mail l0_
WHERE
  l0_.entity_class = ?
  AND l0_.entity_id = ?

SELECT count(DISTINCT (l0_.id)) AS sclr_0 FROM lle_hermes_mail l0_ WHERE l0_.entity_class = 'App\\Entity\\Commande' AND l0_.entity_id = '401783';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->count (line 266)
8	Lle\HermesBundle\Crudit\Brick\MailSublistBrick\MailSublistFactory->getLines (line 93)
9	Lle\HermesBundle\Crudit\Brick\MailSublistBrick\MailSublistFactory->buildView (line 51)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
12	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
13	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
14	App\Controller\Crudit\CommandeController->show (line 53)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
20	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
24	Symfony\Component\HttpKernel\Kernel->handle (line 179)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.81 ms
(2.41%)

SELECT t0.id AS id_1, t0.statut AS statut_2, t0.montant AS montant_3, t0.devise AS devise_4, t0.message AS message_5, t0.nombre_essais AS nombre_essais_6, t0.transfer_id AS transfer_id_7, t0.reversed AS reversed_8, t0.solde AS solde_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.payment_id AS payment_id_14, t0.commande_id AS commande_id_15, t0.refuge_id AS refuge_id_16, t0.reservation_id AS reservation_id_17 FROM transfert_paiement t0 WHERE t0.commande_id = ?

Parameters:

[
  401783
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.statut AS statut_2,
  t0.montant AS montant_3,
  t0.devise AS devise_4,
  t0.message AS message_5,
  t0.nombre_essais AS nombre_essais_6,
  t0.transfer_id AS transfer_id_7,
  t0.reversed AS reversed_8,
  t0.solde AS solde_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.payment_id AS payment_id_14,
  t0.commande_id AS commande_id_15,
  t0.refuge_id AS refuge_id_16,
  t0.reservation_id AS reservation_id_17
FROM
  transfert_paiement t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.statut AS statut_2, t0.montant AS montant_3, t0.devise AS devise_4, t0.message AS message_5, t0.nombre_essais AS nombre_essais_6, t0.transfer_id AS transfer_id_7, t0.reversed AS reversed_8, t0.solde AS solde_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.payment_id AS payment_id_14, t0.commande_id AS commande_id_15, t0.refuge_id AS refuge_id_16, t0.reservation_id AS reservation_id_17 FROM transfert_paiement t0 WHERE t0.commande_id = 401783;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Commande->getErrors (line 450)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
11	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
12	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
13	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->getResourceView (line 62)
14	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->buildView (line 27)
15	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
16	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
17	App\Controller\Crudit\CommandeController->show (line 53)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
23	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
27	Symfony\Component\HttpKernel\Kernel->handle (line 179)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

2.80 ms
(2.41%)

SELECT DISTINCT v0_.id AS id_0, v0_.nom AS nom_1, v0_.prenom AS prenom_2, v0_.date_naissance AS date_naissance_3, v0_.email AS email_4, v0_.tel_mobile AS tel_mobile_5, v0_.nationalite AS nationalite_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.created_by AS created_by_9, v0_.updated_by AS updated_by_10, v0_.commande_id AS commande_id_11 FROM voyageur v0_ WHERE v0_.commande_id IN (?) ORDER BY v0_.nom ASC LIMIT 30

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.nom AS nom_1,
  v0_.prenom AS prenom_2,
  v0_.date_naissance AS date_naissance_3,
  v0_.email AS email_4,
  v0_.tel_mobile AS tel_mobile_5,
  v0_.nationalite AS nationalite_6,
  v0_.created_at AS created_at_7,
  v0_.updated_at AS updated_at_8,
  v0_.created_by AS created_by_9,
  v0_.updated_by AS updated_by_10,
  v0_.commande_id AS commande_id_11
FROM
  voyageur v0_
WHERE
  v0_.commande_id IN (?)
ORDER BY
  v0_.nom ASC
LIMIT
  30

SELECT DISTINCT v0_.id AS id_0, v0_.nom AS nom_1, v0_.prenom AS prenom_2, v0_.date_naissance AS date_naissance_3, v0_.email AS email_4, v0_.tel_mobile AS tel_mobile_5, v0_.nationalite AS nationalite_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.created_by AS created_by_9, v0_.updated_by AS updated_by_10, v0_.commande_id AS commande_id_11 FROM voyageur v0_ WHERE v0_.commande_id IN ('401783') ORDER BY v0_.nom ASC LIMIT 30;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->list (line 92)
6	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 82)
7	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
8	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
9	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
12	App\Controller\Crudit\CommandeController->show (line 53)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
22	Symfony\Component\HttpKernel\Kernel->handle (line 179)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

2.80 ms
(2.41%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.connect_id AS connect_id_6, t0.username AS username_7, t0.actif AS actif_8, t0.last_login AS last_login_9, t0.locale AS locale_10, t0.profil_id AS profil_id_11, t0.refuge_id AS refuge_id_12 FROM user t0 WHERE t0.id = ?

Parameters:

[
  19
]

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.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.connect_id AS connect_id_6,
  t0.username AS username_7,
  t0.actif AS actif_8,
  t0.last_login AS last_login_9,
  t0.locale AS locale_10,
  t0.profil_id AS profil_id_11,
  t0.refuge_id AS refuge_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.connect_id AS connect_id_6, t0.username AS username_7, t0.actif AS actif_8, t0.last_login AS last_login_9, t0.locale AS locale_10, t0.profil_id AS profil_id_11, t0.refuge_id AS refuge_id_12 FROM user t0 WHERE t0.id = 19;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
10	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
20	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
24	Symfony\Component\HttpKernel\Kernel->handle (line 179)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.78 ms
(2.40%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.societe AS societe_5, t0.adresse AS adresse_6, t0.adresse2 AS adresse2_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.telephone AS telephone_10, t0.nationalite AS nationalite_11, t0.nationalite_iso AS nationalite_iso_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.civilite_id AS civilite_id_17, t0.agence_voyage_id AS agence_voyage_id_18 FROM client t0 WHERE t0.id = ?

Parameters:

[
  348609
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.societe AS societe_5,
  t0.adresse AS adresse_6,
  t0.adresse2 AS adresse2_7,
  t0.ville AS ville_8,
  t0.code_postal AS code_postal_9,
  t0.telephone AS telephone_10,
  t0.nationalite AS nationalite_11,
  t0.nationalite_iso AS nationalite_iso_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.civilite_id AS civilite_id_17,
  t0.agence_voyage_id AS agence_voyage_id_18
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.societe AS societe_5, t0.adresse AS adresse_6, t0.adresse2 AS adresse2_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.telephone AS telephone_10, t0.nationalite AS nationalite_11, t0.nationalite_iso AS nationalite_iso_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.civilite_id AS civilite_id_17, t0.agence_voyage_id AS agence_voyage_id_18 FROM client t0 WHERE t0.id = 348609;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Client::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Client->__get (line 153)
7	App\Entity\Client->__toString (line 90)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_69eb2bc2f25252f2d298a14fe24dba1c->doDisplay (line 248)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Lle\CruditBundle\Field\AbstractField->render (line 48)
16	Lle\CruditBundle\Field\AbstractField->buildView (line 40)
17	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 102)
18	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
19	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
20	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->getResourceView (line 62)
21	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->buildView (line 27)
22	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
23	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
24	App\Controller\Crudit\CommandeController->show (line 53)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
30	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
34	Symfony\Component\HttpKernel\Kernel->handle (line 179)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

2.78 ms
(2.39%)

SELECT DISTINCT p0_.id AS id_0, p0_.amount AS amount_1, p0_.currency AS currency_2, p0_.status AS status_3, p0_.reference AS reference_4, p0_.checkout_session_id AS checkout_session_id_5, p0_.payment_intent_id AS payment_intent_id_6, p0_.checkout_url AS checkout_url_7, p0_.refunded AS refunded_8, p0_.balance AS balance_9, p0_.fee AS fee_10, p0_.is_lien_paiement AS is_lien_paiement_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.created_by AS created_by_14, p0_.updated_by AS updated_by_15, p0_.commande_id AS commande_id_16 FROM payment p0_ LEFT JOIN commande c1_ ON p0_.commande_id = c1_.id WHERE p0_.commande_id IN (?) ORDER BY c1_.created_at ASC LIMIT 30

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.amount AS amount_1,
  p0_.currency AS currency_2,
  p0_.status AS status_3,
  p0_.reference AS reference_4,
  p0_.checkout_session_id AS checkout_session_id_5,
  p0_.payment_intent_id AS payment_intent_id_6,
  p0_.checkout_url AS checkout_url_7,
  p0_.refunded AS refunded_8,
  p0_.balance AS balance_9,
  p0_.fee AS fee_10,
  p0_.is_lien_paiement AS is_lien_paiement_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  p0_.created_by AS created_by_14,
  p0_.updated_by AS updated_by_15,
  p0_.commande_id AS commande_id_16
FROM
  payment p0_
  LEFT JOIN commande c1_ ON p0_.commande_id = c1_.id
WHERE
  p0_.commande_id IN (?)
ORDER BY
  c1_.created_at ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.amount AS amount_1, p0_.currency AS currency_2, p0_.status AS status_3, p0_.reference AS reference_4, p0_.checkout_session_id AS checkout_session_id_5, p0_.payment_intent_id AS payment_intent_id_6, p0_.checkout_url AS checkout_url_7, p0_.refunded AS refunded_8, p0_.balance AS balance_9, p0_.fee AS fee_10, p0_.is_lien_paiement AS is_lien_paiement_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.created_by AS created_by_14, p0_.updated_by AS updated_by_15, p0_.commande_id AS commande_id_16 FROM payment p0_ LEFT JOIN commande c1_ ON p0_.commande_id = c1_.id WHERE p0_.commande_id IN ('401783') ORDER BY c1_.created_at ASC LIMIT 30;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->list (line 92)
6	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 82)
7	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
8	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
9	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
12	App\Controller\Crudit\CommandeController->show (line 53)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
22	Symfony\Component\HttpKernel\Kernel->handle (line 179)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

2.78 ms
(2.39%)

SELECT count(DISTINCT (p0_.id)) AS sclr_0 FROM payment p0_ WHERE p0_.commande_id IN (?)

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(
    DISTINCT (p0_.id)
  ) AS sclr_0
FROM
  payment p0_
WHERE
  p0_.commande_id IN (?)

SELECT count(DISTINCT (p0_.id)) AS sclr_0 FROM payment p0_ WHERE p0_.commande_id IN ('401783');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->count (line 266)
8	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 81)
9	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
12	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
13	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
14	App\Controller\Crudit\CommandeController->show (line 53)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
20	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
24	Symfony\Component\HttpKernel\Kernel->handle (line 179)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.77 ms
(2.38%)

SELECT DISTINCT r0_.id AS id_0, r0_.montant_paye AS montant_paye_1, r0_.montant_du AS montant_du_2, r0_.montant_total AS montant_total_3, r0_.delai_annulation AS delai_annulation_4, r0_.status AS status_5, r0_.calc_date_arrivee AS calc_date_arrivee_6, r0_.calc_date_depart AS calc_date_depart_7, r0_.montant_rembourse AS montant_rembourse_8, r0_.note_interne AS note_interne_9, r0_.pms_reservation_id AS pms_reservation_id_10, r0_.mail_refuge_sent AS mail_refuge_sent_11, r0_.frais_annulation AS frais_annulation_12, r0_.created_at AS created_at_13, r0_.updated_at AS updated_at_14, r0_.created_by AS created_by_15, r0_.updated_by AS updated_by_16, r0_.refuge_id AS refuge_id_17, r0_.currency_id AS currency_id_18, r0_.commande_id AS commande_id_19, r0_.cancelled_reservation_id AS cancelled_reservation_id_20 FROM reservation r0_ WHERE r0_.commande_id IN (?) ORDER BY r0_.refuge_id ASC LIMIT 30

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.montant_paye AS montant_paye_1,
  r0_.montant_du AS montant_du_2,
  r0_.montant_total AS montant_total_3,
  r0_.delai_annulation AS delai_annulation_4,
  r0_.status AS status_5,
  r0_.calc_date_arrivee AS calc_date_arrivee_6,
  r0_.calc_date_depart AS calc_date_depart_7,
  r0_.montant_rembourse AS montant_rembourse_8,
  r0_.note_interne AS note_interne_9,
  r0_.pms_reservation_id AS pms_reservation_id_10,
  r0_.mail_refuge_sent AS mail_refuge_sent_11,
  r0_.frais_annulation AS frais_annulation_12,
  r0_.created_at AS created_at_13,
  r0_.updated_at AS updated_at_14,
  r0_.created_by AS created_by_15,
  r0_.updated_by AS updated_by_16,
  r0_.refuge_id AS refuge_id_17,
  r0_.currency_id AS currency_id_18,
  r0_.commande_id AS commande_id_19,
  r0_.cancelled_reservation_id AS cancelled_reservation_id_20
FROM
  reservation r0_
WHERE
  r0_.commande_id IN (?)
ORDER BY
  r0_.refuge_id ASC
LIMIT
  30

SELECT DISTINCT r0_.id AS id_0, r0_.montant_paye AS montant_paye_1, r0_.montant_du AS montant_du_2, r0_.montant_total AS montant_total_3, r0_.delai_annulation AS delai_annulation_4, r0_.status AS status_5, r0_.calc_date_arrivee AS calc_date_arrivee_6, r0_.calc_date_depart AS calc_date_depart_7, r0_.montant_rembourse AS montant_rembourse_8, r0_.note_interne AS note_interne_9, r0_.pms_reservation_id AS pms_reservation_id_10, r0_.mail_refuge_sent AS mail_refuge_sent_11, r0_.frais_annulation AS frais_annulation_12, r0_.created_at AS created_at_13, r0_.updated_at AS updated_at_14, r0_.created_by AS created_by_15, r0_.updated_by AS updated_by_16, r0_.refuge_id AS refuge_id_17, r0_.currency_id AS currency_id_18, r0_.commande_id AS commande_id_19, r0_.cancelled_reservation_id AS cancelled_reservation_id_20 FROM reservation r0_ WHERE r0_.commande_id IN ('401783') ORDER BY r0_.refuge_id ASC LIMIT 30;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->list (line 92)
6	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 82)
7	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
8	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
9	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
12	App\Controller\Crudit\CommandeController->show (line 53)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
18	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
22	Symfony\Component\HttpKernel\Kernel->handle (line 179)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

2.74 ms
(2.36%)

SELECT e0_.ip_address AS ip_address_0, e0_.main_object_id AS main_object_id_1, e0_.main_object_class AS main_object_class_2, e0_.id AS id_3, e0_.action AS action_4, e0_.logged_at AS logged_at_5, e0_.object_id AS object_id_6, e0_.object_class AS object_class_7, e0_.version AS version_8, e0_.data AS data_9, e0_.username AS username_10 FROM ext_log_entries e0_ WHERE (e0_.object_id = ? AND e0_.object_class = ?) OR (e0_.main_object_id = ? AND e0_.main_object_class = ?) ORDER BY e0_.version DESC

Parameters:

[
  "401783"
  "App\Entity\Commande"
  "401783"
  "App\Entity\Commande"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.ip_address AS ip_address_0,
  e0_.main_object_id AS main_object_id_1,
  e0_.main_object_class AS main_object_class_2,
  e0_.id AS id_3,
  e0_.action AS action_4,
  e0_.logged_at AS logged_at_5,
  e0_.object_id AS object_id_6,
  e0_.object_class AS object_class_7,
  e0_.version AS version_8,
  e0_.data AS data_9,
  e0_.username AS username_10
FROM
  ext_log_entries e0_
WHERE
  (
    e0_.object_id = ?
    AND e0_.object_class = ?
  )
  OR (
    e0_.main_object_id = ?
    AND e0_.main_object_class = ?
  )
ORDER BY
  e0_.version DESC

SELECT e0_.ip_address AS ip_address_0, e0_.main_object_id AS main_object_id_1, e0_.main_object_class AS main_object_class_2, e0_.id AS id_3, e0_.action AS action_4, e0_.logged_at AS logged_at_5, e0_.object_id AS object_id_6, e0_.object_class AS object_class_7, e0_.version AS version_8, e0_.data AS data_9, e0_.username AS username_10 FROM ext_log_entries e0_ WHERE (e0_.object_id = '401783' AND e0_.object_class = 'App\\Entity\\Commande') OR (e0_.main_object_id = '401783' AND e0_.main_object_class = 'App\\Entity\\Commande') ORDER BY e0_.version DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\LogEntryRepository->getLogEntries (line 35)
7	Lle\CruditBundle\Brick\HistoryBrick\HistoryFactory->getLogEntriesDatasource (line 91)
8	Lle\CruditBundle\Brick\HistoryBrick\HistoryFactory->getLogEntries (line 61)
9	Lle\CruditBundle\Brick\HistoryBrick\HistoryFactory->buildView (line 43)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
12	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
13	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
14	App\Controller\Crudit\CommandeController->show (line 53)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
20	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
24	Symfony\Component\HttpKernel\Kernel->handle (line 179)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.73 ms
(2.35%)

SELECT count(DISTINCT (r0_.id)) AS sclr_0 FROM reservation r0_ WHERE r0_.commande_id IN (?)

Parameters:

[
  "401783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(
    DISTINCT (r0_.id)
  ) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.commande_id IN (?)

SELECT count(DISTINCT (r0_.id)) AS sclr_0 FROM reservation r0_ WHERE r0_.commande_id IN ('401783');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 1025)
7	Lle\CruditBundle\Datasource\AbstractDoctrineDatasource->count (line 266)
8	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 81)
9	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
10	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
11	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
12	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
13	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
14	App\Controller\Crudit\CommandeController->show (line 53)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
20	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
24	Symfony\Component\HttpKernel\Kernel->handle (line 179)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.71 ms
(2.34%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM refuge_translation t0 WHERE t0.object_id = ?

Parameters:

[
  32398
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  refuge_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM refuge_translation t0 WHERE t0.object_id = 32398;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 4000)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 129)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 278)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 787)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
17	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
18	Proxies\__CG__\App\Entity\Refuge::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
19	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
20	Proxies\__CG__\App\Entity\Refuge->__get (line 153)
21	App\Entity\Refuge->__toString (line 259)
22	App\Entity\Reservation->__toString (line 105)
23	App\Entity\Reservation->getToString (line 110)
24	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
25	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
26	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
27	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
28	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
29	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 85)
30	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
31	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
32	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
33	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
34	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
35	App\Controller\Crudit\CommandeController->show (line 53)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
41	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
42	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
44	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
45	Symfony\Component\HttpKernel\Kernel->handle (line 179)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
47	require_once (line 32)
48	require_once (line 5)

2.68 ms
(2.31%)

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.total AS total_3, t0.enfant AS enfant_4, t0.acompte AS acompte_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.sejour_id AS sejour_id_10, t0.taxe_sejour_config_id AS taxe_sejour_config_id_11 FROM taxe_sejour t0 WHERE t0.sejour_id = ?

Parameters:

[
  81523
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.total AS total_3,
  t0.enfant AS enfant_4,
  t0.acompte AS acompte_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.sejour_id AS sejour_id_10,
  t0.taxe_sejour_config_id AS taxe_sejour_config_id_11
FROM
  taxe_sejour t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.total AS total_3, t0.enfant AS enfant_4, t0.acompte AS acompte_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.sejour_id AS sejour_id_10, t0.taxe_sejour_config_id AS taxe_sejour_config_id_11 FROM taxe_sejour t0 WHERE t0.sejour_id = 81523;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Reservation->getNbTaxeSejour (line 407)
8	App\Entity\Commande->getErrors (line 485)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
11	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
12	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
13	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
14	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->getResourceView (line 62)
15	Lle\CruditBundle\Brick\ShowBrick\ShowFactory->buildView (line 27)
16	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
17	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
18	App\Controller\Crudit\CommandeController->show (line 53)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
24	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
28	Symfony\Component\HttpKernel\Kernel->handle (line 179)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

2.57 ms
(2.21%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.nb_personne AS nb_personne_4, t0.description AS description_5, t0.acompte AS acompte_6, t0.individuel AS individuel_7, t0.capacite AS capacite_8, t0.tri AS tri_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.refuge_id AS refuge_id_14, t0.confort_id AS confort_id_15 FROM roomtype t0 WHERE t0.id = ?

Parameters:

[
  663
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.nb_personne AS nb_personne_4,
  t0.description AS description_5,
  t0.acompte AS acompte_6,
  t0.individuel AS individuel_7,
  t0.capacite AS capacite_8,
  t0.tri AS tri_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.refuge_id AS refuge_id_14,
  t0.confort_id AS confort_id_15
FROM
  roomtype t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.nb_personne AS nb_personne_4, t0.description AS description_5, t0.acompte AS acompte_6, t0.individuel AS individuel_7, t0.capacite AS capacite_8, t0.tri AS tri_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.refuge_id AS refuge_id_14, t0.confort_id AS confort_id_15 FROM roomtype t0 WHERE t0.id = 663;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Roomtype::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Roomtype->__isset (line 258)
7	App\Entity\Roomtype->__toString (line 104)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_055423f8ecb8d059273915013af24104->doDisplay (line 68)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Lle\CruditBundle\Field\AbstractField->render (line 48)
16	Lle\CruditBundle\Field\AbstractField->buildView (line 40)
17	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 102)
18	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
19	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
20	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 85)
21	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
22	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
23	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
24	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
25	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
26	App\Controller\Crudit\CommandeController->show (line 53)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
32	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
36	Symfony\Component\HttpKernel\Kernel->handle (line 179)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

2.54 ms
(2.18%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM zone_geographique_translation t0 WHERE t0.object_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  zone_geographique_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM zone_geographique_translation t0 WHERE t0.object_id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 98)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 66)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 4000)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 129)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 278)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 787)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
17	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
18	Proxies\__CG__\App\Entity\Refuge::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
19	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
20	Proxies\__CG__\App\Entity\Refuge->__get (line 153)
21	App\Entity\Refuge->__toString (line 259)
22	App\Entity\Reservation->__toString (line 105)
23	App\Entity\Reservation->getToString (line 110)
24	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
25	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
26	Lle\CruditBundle\Resolver\FieldResolver->resolveView (line 88)
27	Lle\CruditBundle\Resolver\ResourceResolver->getFieldViews (line 70)
28	Lle\CruditBundle\Resolver\ResourceResolver->resolve (line 38)
29	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->getLines (line 85)
30	Lle\CruditBundle\Brick\SublistBrick\SublistFactory->buildView (line 52)
31	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
32	Lle\CruditBundle\Brick\TabBrick\TabFactory->buildView (line 42)
33	Lle\CruditBundle\Builder\BrickBuilder->buildBrick (line 56)
34	Lle\CruditBundle\Builder\BrickBuilder->build (line 43)
35	App\Controller\Crudit\CommandeController->show (line 53)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 476)
41	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 68)
42	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 453)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 351)
44	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 220)
45	Symfony\Component\HttpKernel\Kernel->handle (line 179)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
47	require_once (line 32)
48	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
Lle\HermesBundle\Entity\Translation\TemplateTranslation	72
App\Entity\LogEntry	53
App\Entity\Translation\RefugeTranslation	18
Lle\HermesBundle\Entity\Template	10
App\Entity\Translation\ZoneGeographiqueTranslation	5
App\Entity\Commande	2
App\Entity\Payment	2
App\Entity\Translation\RoomtypeTranslation	2
App\Entity\Voyageur	2
Lle\HermesBundle\Entity\Mail	2
Lle\HermesBundle\Entity\Recipient	2
App\Entity\User	1
Lle\CredentialBundle\Entity\Group	1
App\Entity\Client	1
App\Entity\Circuit	1
App\Entity\Civilite	1
App\Entity\Reservation	1
App\Entity\Refuge	1
App\Entity\Currency	1
App\Entity\Sejour	1
App\Entity\Roomtype	1
App\Entity\TaxeSejour	1
App\Entity\TaxeSejourConfig	1
App\Entity\Country	1
App\Entity\ZoneGeographique	1
App\Entity\Confort	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
Lle\CredentialBundle\Entity\Group	No errors.
App\Entity\Refuge	No errors.
Lle\CredentialBundle\Entity\GroupCredential	No errors.
App\Entity\Commande	No errors.
App\Entity\Client	No errors.
App\Entity\Circuit	No errors.
App\Entity\Reservation	No errors.
App\Entity\Confort	No errors.
App\Entity\Voyageur	No errors.
App\Entity\Payment	No errors.
App\Entity\TransfertPaiement	No errors.
App\Entity\Config	No errors.
App\Entity\Civilite	No errors.
App\Entity\AgenceVoyage	No errors.
App\Entity\Currency	No errors.
App\Entity\PmsBookingDispatch	No errors.
App\Entity\Sejour	No errors.
App\Entity\ResaService	No errors.
App\Entity\Roomtype	No errors.
App\Entity\Occupation	No errors.
App\Entity\TaxeSejour	No errors.
App\Entity\TaxeSejourConfig	No errors.
App\Entity\Country	No errors.
App\Entity\ZoneGeographique	No errors.
App\Entity\Service	No errors.
App\Entity\RefugeAttribut	No errors.
App\Entity\RoomtypeRate	No errors.
App\Entity\Segment	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Entity\Translation\RefugeTranslation	No errors.
App\Entity\ConfigAgence	No errors.
App\Entity\Translation\ZoneGeographiqueTranslation	No errors.
App\Entity\Translation\RoomtypeTranslation	No errors.
Lle\HermesBundle\Entity\Mail	No errors.
Lle\HermesBundle\Entity\Template	No errors.
Lle\HermesBundle\Entity\Recipient	No errors.
Lle\HermesBundle\Entity\Link	No errors.
Lle\HermesBundle\Entity\LinkOpening	No errors.
App\Entity\LogEntry	No errors.
Lle\HermesBundle\Entity\Translation\TemplateTranslation	No errors.

Symfony Profiler

GET https://tmb.2le-test.me/admin/commande/show/401783

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping