Symfony Profiler

Query Metrics

33 Database Queries

11 Different statements

39.92 ms Query time

5 Invalid entities

61 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

8.94 ms
(22.40%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.etat AS etat_3, t0.date_start AS date_start_4, t0.comment AS comment_5, t0.date_preview_end AS date_preview_end_6, t0.date_end AS date_end_7, t0.date_preview_start AS date_preview_start_8, t0.ticket_id AS ticket_id_9 FROM affectation t0 WHERE t0.ticket_id = ?

Parameters:

[
  2620
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.etat AS etat_3,
  t0.date_start AS date_start_4,
  t0.comment AS comment_5,
  t0.date_preview_end AS date_preview_end_6,
  t0.date_end AS date_end_7,
  t0.date_preview_start AS date_preview_start_8,
  t0.ticket_id AS ticket_id_9
FROM
  affectation t0
WHERE
  t0.ticket_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.etat AS etat_3, t0.date_start AS date_start_4, t0.comment AS comment_5, t0.date_preview_end AS date_preview_end_6, t0.date_end AS date_end_7, t0.date_preview_start AS date_preview_start_8, t0.ticket_id AS ticket_id_9 FROM affectation t0 WHERE t0.ticket_id = 2620;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1704)
10	__TwigTemplate_610704a8d7879c562e55fc274810c204::block_body (line 539)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_418e5c597a82f9694c0dcef0aed33177->doDisplay (line 252)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_610704a8d7879c562e55fc274810c204->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\TicketsController->ticketFermer (line 163)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

8.00 ms
(20.04%)

SELECT t0.id AS id_1, t0.version AS version_2, t0.type_contrat AS type_contrat_3, t0.adresse_facturation AS adresse_facturation_4, t0.ref_band_commande AS ref_band_commande_5, t0.statut AS statut_6, t0.periodicite_facturation AS periodicite_facturation_7, t0.premiere_mensualite AS premiere_mensualite_8, t0.terme_facturation AS terme_facturation_9, t0.action_aterme AS action_aterme_10, t0.val_decote AS val_decote_11, t0.loyers AS loyers_12, t0.sepatare_factures AS sepatare_factures_13, t0.preventive AS preventive_14, t0.ref_contrat AS ref_contrat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sla AS sla_18, t0.delivery_status AS delivery_status_19, t0.sage_sync AS sage_sync_20, t0.numero_contrat AS numero_contrat_21, t0.date_start_contrat AS date_start_contrat_22, t0.client_id AS client_id_23, t0.devis_id AS devis_id_24, t0.added_by_id AS added_by_id_25 FROM contrat t0 WHERE t0.id = ?

Parameters:

[
  3542
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.type_contrat AS type_contrat_3,
  t0.adresse_facturation AS adresse_facturation_4,
  t0.ref_band_commande AS ref_band_commande_5,
  t0.statut AS statut_6,
  t0.periodicite_facturation AS periodicite_facturation_7,
  t0.premiere_mensualite AS premiere_mensualite_8,
  t0.terme_facturation AS terme_facturation_9,
  t0.action_aterme AS action_aterme_10,
  t0.val_decote AS val_decote_11,
  t0.loyers AS loyers_12,
  t0.sepatare_factures AS sepatare_factures_13,
  t0.preventive AS preventive_14,
  t0.ref_contrat AS ref_contrat_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.sla AS sla_18,
  t0.delivery_status AS delivery_status_19,
  t0.sage_sync AS sage_sync_20,
  t0.numero_contrat AS numero_contrat_21,
  t0.date_start_contrat AS date_start_contrat_22,
  t0.client_id AS client_id_23,
  t0.devis_id AS devis_id_24,
  t0.added_by_id AS added_by_id_25
FROM
  contrat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.type_contrat AS type_contrat_3, t0.adresse_facturation AS adresse_facturation_4, t0.ref_band_commande AS ref_band_commande_5, t0.statut AS statut_6, t0.periodicite_facturation AS periodicite_facturation_7, t0.premiere_mensualite AS premiere_mensualite_8, t0.terme_facturation AS terme_facturation_9, t0.action_aterme AS action_aterme_10, t0.val_decote AS val_decote_11, t0.loyers AS loyers_12, t0.sepatare_factures AS sepatare_factures_13, t0.preventive AS preventive_14, t0.ref_contrat AS ref_contrat_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sla AS sla_18, t0.delivery_status AS delivery_status_19, t0.sage_sync AS sage_sync_20, t0.numero_contrat AS numero_contrat_21, t0.date_start_contrat AS date_start_contrat_22, t0.client_id AS client_id_23, t0.devis_id AS devis_id_24, t0.added_by_id AS added_by_id_25 FROM contrat t0 WHERE t0.id = 3542;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Contrat::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Contrat->__get (line 120)
7	App\Entity\Contrat->getSla (line 386)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_610704a8d7879c562e55fc274810c204::block_body (line 310)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_418e5c597a82f9694c0dcef0aed33177->doDisplay (line 252)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_610704a8d7879c562e55fc274810c204->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\TicketsController->ticketFermer (line 163)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

5.53 ms
(13.84%)

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM tickets t0_ WHERE t0_.status = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT t0_.id) AS sclr_0
FROM
  tickets t0_
WHERE
  t0_.status = ?

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM tickets t0_ WHERE t0_.status = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container4PRxPfq\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\TicketsController->ticketFermer (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 185)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

5.20 ms
(13.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.mail AS mail_3, t0.phone AS phone_4, t0.website AS website_5, t0.address AS address_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.ref AS ref_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.code_client AS code_client_14, t0.sage_sync AS sage_sync_15, t0.client_type_id AS client_type_id_16, t0.user_id AS user_id_17, t0.commercial_id AS commercial_id_18 FROM client t0 WHERE t0.id = ?

Parameters:

[
  582
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.mail AS mail_3,
  t0.phone AS phone_4,
  t0.website AS website_5,
  t0.address AS address_6,
  t0.code_postal AS code_postal_7,
  t0.ville AS ville_8,
  t0.ref AS ref_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.ice AS ice_12,
  t0.rc AS rc_13,
  t0.code_client AS code_client_14,
  t0.sage_sync AS sage_sync_15,
  t0.client_type_id AS client_type_id_16,
  t0.user_id AS user_id_17,
  t0.commercial_id AS commercial_id_18
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.mail AS mail_3, t0.phone AS phone_4, t0.website AS website_5, t0.address AS address_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.ref AS ref_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.code_client AS code_client_14, t0.sage_sync AS sage_sync_15, t0.client_type_id AS client_type_id_16, t0.user_id AS user_id_17, t0.commercial_id AS commercial_id_18 FROM client t0 WHERE t0.id = 582;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Client::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Client->__get (line 120)
7	App\Entity\Client->getName (line 131)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_610704a8d7879c562e55fc274810c204::block_body (line 487)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_418e5c597a82f9694c0dcef0aed33177->doDisplay (line 252)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_610704a8d7879c562e55fc274810c204->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\TicketsController->ticketFermer (line 163)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

3.54 ms
(8.87%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.reset_token AS reset_token_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.civility AS civility_11,
  t0.telephone AS telephone_12,
  t0.company_id AS company_id_13,
  t14.id AS id_15,
  t14.email AS email_16,
  t14.date_of_birth AS date_of_birth_17,
  t14.created_at AS created_at_18,
  t14.salary AS salary_19,
  t14.last_name AS last_name_20,
  t14.first_name AS first_name_21,
  t14.civility AS civility_22,
  t14.telephone AS telephone_23,
  t14.department_id AS department_id_24,
  t14.fonction_id AS fonction_id_25,
  t14.user_id AS user_id_26
FROM
  user t0
  LEFT JOIN employee t14 ON t14.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 127)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 154)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 185)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

2.32 ms
(5.81%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id INNER JOIN affectation_user ON t0.id = affectation_user.user_id WHERE affectation_user.affectation_id = ?

Parameters:

[
  2388
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.reset_token AS reset_token_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.civility AS civility_11,
  t0.telephone AS telephone_12,
  t0.company_id AS company_id_13,
  t14.id AS id_15,
  t14.email AS email_16,
  t14.date_of_birth AS date_of_birth_17,
  t14.created_at AS created_at_18,
  t14.salary AS salary_19,
  t14.last_name AS last_name_20,
  t14.first_name AS first_name_21,
  t14.civility AS civility_22,
  t14.telephone AS telephone_23,
  t14.department_id AS department_id_24,
  t14.fonction_id AS fonction_id_25,
  t14.user_id AS user_id_26
FROM
  user t0
  LEFT JOIN employee t14 ON t14.user_id = t0.id
  INNER JOIN affectation_user ON t0.id = affectation_user.user_id
WHERE
  affectation_user.affectation_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id INNER JOIN affectation_user ON t0.id = affectation_user.user_id WHERE affectation_user.affectation_id = 2388;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1704)
10	__TwigTemplate_610704a8d7879c562e55fc274810c204::block_body (line 547)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_418e5c597a82f9694c0dcef0aed33177->doDisplay (line 252)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_610704a8d7879c562e55fc274810c204->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\TicketsController->ticketFermer (line 163)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.62 ms
(4.05%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM type_attribute t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  type_attribute t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM type_attribute t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\GlobalService->list_type_attribute (line 74)
6	Twig\Extension\CoreExtension->getAttribute (line 1919)
7	__TwigTemplate_c725a81120fea5bdfceb98435d5132aa::doDisplay (line 135)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1526)
13	__TwigTemplate_418e5c597a82f9694c0dcef0aed33177::doDisplay (line 225)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_610704a8d7879c562e55fc274810c204->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\TicketsController->ticketFermer (line 163)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 185)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.51 ms
(3.79%)

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.rc AS rc_3, t0.ice AS ice_4, t0.address AS address_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.email AS email_9, t0.id_fiscal AS id_fiscal_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.currency AS currency_13, t0.exchange_rates AS exchange_rates_14, t0.cost AS cost_15, t0.ca AS ca_16, t0.week_work_hours AS week_work_hours_17, t0.day_work_hours AS day_work_hours_18, t0.workload_breakdown AS workload_breakdown_19, t0.cost_per_hour AS cost_per_hour_20, t0.dig_price AS dig_price_21, t0.ca_breakdown AS ca_breakdown_22, t0.marge AS marge_23, t0.marge_attribute AS marge_attribute_24, t0.marge_min AS marge_min_25, t0.marge_min_attribute AS marge_min_attribute_26, t0.contrat_title AS contrat_title_27, t0.contrat_service_titre AS contrat_service_titre_28, t0.interfacing AS interfacing_29, t0.limit_depasement AS limit_depasement_30, t0.notification_signature_contrat AS notification_signature_contrat_31, t0.notification_fin_contrat AS notification_fin_contrat_32, t0.envoi_automatique_factures AS envoi_automatique_factures_33, t0.volume_mensel_recommande AS volume_mensel_recommande_34, t0.show_all_pieces AS show_all_pieces_35, t0.show_all_consommable AS show_all_consommable_36, t0.permissions_version AS permissions_version_37, t0.company_id AS company_id_38, t0.contrat_emplacement_id AS contrat_emplacement_id_39 FROM setting t0 WHERE t0.company_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.rc AS rc_3,
  t0.ice AS ice_4,
  t0.address AS address_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.pays AS pays_8,
  t0.email AS email_9,
  t0.id_fiscal AS id_fiscal_10,
  t0.phone AS phone_11,
  t0.fax AS fax_12,
  t0.currency AS currency_13,
  t0.exchange_rates AS exchange_rates_14,
  t0.cost AS cost_15,
  t0.ca AS ca_16,
  t0.week_work_hours AS week_work_hours_17,
  t0.day_work_hours AS day_work_hours_18,
  t0.workload_breakdown AS workload_breakdown_19,
  t0.cost_per_hour AS cost_per_hour_20,
  t0.dig_price AS dig_price_21,
  t0.ca_breakdown AS ca_breakdown_22,
  t0.marge AS marge_23,
  t0.marge_attribute AS marge_attribute_24,
  t0.marge_min AS marge_min_25,
  t0.marge_min_attribute AS marge_min_attribute_26,
  t0.contrat_title AS contrat_title_27,
  t0.contrat_service_titre AS contrat_service_titre_28,
  t0.interfacing AS interfacing_29,
  t0.limit_depasement AS limit_depasement_30,
  t0.notification_signature_contrat AS notification_signature_contrat_31,
  t0.notification_fin_contrat AS notification_fin_contrat_32,
  t0.envoi_automatique_factures AS envoi_automatique_factures_33,
  t0.volume_mensel_recommande AS volume_mensel_recommande_34,
  t0.show_all_pieces AS show_all_pieces_35,
  t0.show_all_consommable AS show_all_consommable_36,
  t0.permissions_version AS permissions_version_37,
  t0.company_id AS company_id_38,
  t0.contrat_emplacement_id AS contrat_emplacement_id_39
FROM
  setting t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.rc AS rc_3, t0.ice AS ice_4, t0.address AS address_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.email AS email_9, t0.id_fiscal AS id_fiscal_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.currency AS currency_13, t0.exchange_rates AS exchange_rates_14, t0.cost AS cost_15, t0.ca AS ca_16, t0.week_work_hours AS week_work_hours_17, t0.day_work_hours AS day_work_hours_18, t0.workload_breakdown AS workload_breakdown_19, t0.cost_per_hour AS cost_per_hour_20, t0.dig_price AS dig_price_21, t0.ca_breakdown AS ca_breakdown_22, t0.marge AS marge_23, t0.marge_attribute AS marge_attribute_24, t0.marge_min AS marge_min_25, t0.marge_min_attribute AS marge_min_attribute_26, t0.contrat_title AS contrat_title_27, t0.contrat_service_titre AS contrat_service_titre_28, t0.interfacing AS interfacing_29, t0.limit_depasement AS limit_depasement_30, t0.notification_signature_contrat AS notification_signature_contrat_31, t0.notification_fin_contrat AS notification_fin_contrat_32, t0.envoi_automatique_factures AS envoi_automatique_factures_33, t0.volume_mensel_recommande AS volume_mensel_recommande_34, t0.show_all_pieces AS show_all_pieces_35, t0.show_all_consommable AS show_all_consommable_36, t0.permissions_version AS permissions_version_37, t0.company_id AS company_id_38, t0.contrat_emplacement_id AS contrat_emplacement_id_39 FROM setting t0 WHERE t0.company_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\EventListener\SettingListener->fillSetting (line 63)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 185)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.23 ms
(3.08%)

SELECT t0_.id AS id_0, t0_.serie AS serie_1, t0_.reference AS reference_2, t0_.designation AS designation_3, t0_.type_ticket AS type_ticket_4, t0_.email AS email_5, t0_.adresse AS adresse_6, t0_.phone AS phone_7, t0_.comment AS comment_8, t0_.ref_ticket AS ref_ticket_9, t0_.is_referenced AS is_referenced_10, t0_.closed_at AS closed_at_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, t0_.status AS status_14, t0_.compteur_mono_a4 AS compteur_mono_a4_15, t0_.compteur_mono_a3 AS compteur_mono_a3_16, t0_.compteur_mono_gf AS compteur_mono_gf_17, t0_.compteur_color_a4 AS compteur_color_a4_18, t0_.compteur_color_a3 AS compteur_color_a3_19, t0_.compteur_color_gf AS compteur_color_gf_20, t0_.description_file AS description_file_21, t0_.code_machine AS code_machine_22, t0_.ville AS ville_23, t0_.contrat_id AS contrat_id_24, t0_.product_id AS product_id_25, t0_.client_id AS client_id_26, t0_.user_id AS user_id_27, t0_.ticket_category_id AS ticket_category_id_28 FROM tickets t0_ WHERE t0_.status = ? AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.serie AS serie_1,
  t0_.reference AS reference_2,
  t0_.designation AS designation_3,
  t0_.type_ticket AS type_ticket_4,
  t0_.email AS email_5,
  t0_.adresse AS adresse_6,
  t0_.phone AS phone_7,
  t0_.comment AS comment_8,
  t0_.ref_ticket AS ref_ticket_9,
  t0_.is_referenced AS is_referenced_10,
  t0_.closed_at AS closed_at_11,
  t0_.created_at AS created_at_12,
  t0_.updated_at AS updated_at_13,
  t0_.status AS status_14,
  t0_.compteur_mono_a4 AS compteur_mono_a4_15,
  t0_.compteur_mono_a3 AS compteur_mono_a3_16,
  t0_.compteur_mono_gf AS compteur_mono_gf_17,
  t0_.compteur_color_a4 AS compteur_color_a4_18,
  t0_.compteur_color_a3 AS compteur_color_a3_19,
  t0_.compteur_color_gf AS compteur_color_gf_20,
  t0_.description_file AS description_file_21,
  t0_.code_machine AS code_machine_22,
  t0_.ville AS ville_23,
  t0_.contrat_id AS contrat_id_24,
  t0_.product_id AS product_id_25,
  t0_.client_id AS client_id_26,
  t0_.user_id AS user_id_27,
  t0_.ticket_category_id AS ticket_category_id_28
FROM
  tickets t0_
WHERE
  t0_.status = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t0_.id DESC

SELECT t0_.id AS id_0, t0_.serie AS serie_1, t0_.reference AS reference_2, t0_.designation AS designation_3, t0_.type_ticket AS type_ticket_4, t0_.email AS email_5, t0_.adresse AS adresse_6, t0_.phone AS phone_7, t0_.comment AS comment_8, t0_.ref_ticket AS ref_ticket_9, t0_.is_referenced AS is_referenced_10, t0_.closed_at AS closed_at_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, t0_.status AS status_14, t0_.compteur_mono_a4 AS compteur_mono_a4_15, t0_.compteur_mono_a3 AS compteur_mono_a3_16, t0_.compteur_mono_gf AS compteur_mono_gf_17, t0_.compteur_color_a4 AS compteur_color_a4_18, t0_.compteur_color_a3 AS compteur_color_a3_19, t0_.compteur_color_gf AS compteur_color_gf_20, t0_.description_file AS description_file_21, t0_.code_machine AS code_machine_22, t0_.ville AS ville_23, t0_.contrat_id AS contrat_id_24, t0_.product_id AS product_id_25, t0_.client_id AS client_id_26, t0_.user_id AS user_id_27, t0_.ticket_category_id AS ticket_category_id_28 FROM tickets t0_ WHERE t0_.status = 2 AND t0_.id IN (2620, 2619, 2618, 2617, 2616, 2615, 2614, 2613, 2612, 2611) ORDER BY t0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container4PRxPfq\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\TicketsController->ticketFermer (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 185)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.20 ms
(3.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM roles t0 INNER JOIN user_roles ON t0.id = user_roles.roles_id WHERE user_roles.user_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.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  roles t0
  INNER JOIN user_roles ON t0.id = user_roles.roles_id
WHERE
  user_roles.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM roles t0 INNER JOIN user_roles ON t0.id = user_roles.roles_id WHERE user_roles.user_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Service\GlobalService->getRoleNames (line 293)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_c725a81120fea5bdfceb98435d5132aa::doDisplay (line 407)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1526)
15	__TwigTemplate_418e5c597a82f9694c0dcef0aed33177::doDisplay (line 225)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_610704a8d7879c562e55fc274810c204->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	App\Controller\TicketsController->ticketFermer (line 163)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 185)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.83 ms
(2.09%)

SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM tickets t0_ WHERE t0_.status = ? ORDER BY t0_.id DESC LIMIT 10

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.id AS id_1
FROM
  tickets t0_
WHERE
  t0_.status = ?
ORDER BY
  t0_.id DESC
LIMIT
  10

SELECT DISTINCT t0_.id AS id_0, t0_.id AS id_1 FROM tickets t0_ WHERE t0_.status = 2 ORDER BY t0_.id DESC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	Container4PRxPfq\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\TicketsController->ticketFermer (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 185)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
interfacage	doctrine.dbal.interfacage_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Affectation	11
App\Entity\Tickets	10
App\Entity\Contrat	8
App\Entity\Devis	8
App\Entity\Client	5
App\Entity\Product	4
App\Entity\User	3
App\Entity\TypeAttribute	3
App\Entity\TicketCategory	2
App\Entity\Company	1
App\Entity\Setting	1
App\Entity\ContratArticles	1
App\Entity\Roles	1
App\Entity\Employee	1
App\Entity\Department	1
App\Entity\Fonction	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Employee	No errors.
App\Entity\Department	No errors.
App\Entity\Fonction	No errors.
App\Entity\Client	The association App\Entity\Client#machineLocations refers to the owning side field App\Entity\MachineLocation#client which does not exist.
App\Entity\Devis	No errors.
App\Entity\Contrat	The association App\Entity\Contrat#compteFacturations refers to the owning side field App\Entity\CompteFacturation#contrat which does not exist.
App\Entity\Tickets	No errors.
App\Entity\Roles	No errors.
App\Entity\Affectation	No errors.
App\Entity\DemandePieces	No errors.
App\Entity\PieceDemandeStatus	No errors.
App\Entity\AffectationSequances	No errors.
App\Entity\DemandeConsommables	No errors.
App\Entity\ConsommableDemandeStatus	No errors.
App\Entity\TicketsComments	No errors.
App\Entity\Livraison	If association App\Entity\Livraison#devis is one-to-one, then the inversed side App\Entity\Devis#livraison has to be one-to-one as well.
App\Entity\Setting	No errors.
App\Entity\ContratArticles	No errors.
App\Entity\Product	The association App\Entity\Product#livraisons refers to the owning side field App\Entity\Livraison#machine which does not exist. The mappings App\Entity\Product#livraisonStatut and App\Entity\LivraisonStatut#machine are inconsistent with each other.
App\Entity\TicketCategory	No errors.
App\Entity\DevisIntervenstion	No errors.
App\Entity\TypeAttribute	No errors.
App\Entity\MachineAttribute	No errors.
App\Entity\Permission	No errors.
App\Entity\LivraisonStatut	No errors.
App\Entity\CompteFacturation	No errors.
App\Entity\Factures	No errors.
App\Entity\ClientType	No errors.
App\Entity\Contact	No errors.
App\Entity\Sites	No errors.
App\Entity\MachineLocation	The association App\Entity\MachineLocation#contrat refers to the inverse side field App\Entity\Contrat#machineLocations which does not exist.

Symfony Profiler

GET https://demosymph.omnipilote.ma/fr/dashboard/tickets/ticketFermer

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping