Symfony Profiler

Query Metrics

334 Database Queries

27 Different statements

65.64 ms Query time

7 Invalid entities

307 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

28.35 ms
(43.19%)

107

SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1

Parameters:

[
  97
  "link_bo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.meta_key AS meta_key_2,
  t0.meta_value AS meta_value_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.dossier_id AS dossier_id_7
FROM
  dossier_meta t0
WHERE
  t0.dossier_id = ?
  AND t0.meta_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = 97 AND t0.meta_key = 'link_bo' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\DossierMetaService->setMeta (line 36)
5	App\Twig\Components\DossierLive->save (line 811)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 24)

5.05 ms
(7.70%)

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = ? AND t0_.box = 1 ORDER BY t0_.rank ASC, t0_.created_at DESC

Parameters:

[
  b"\x01 \–\x15sx~‹Êe+ªËþu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t0_.title AS title_2,
  t0_.date_debut AS date_debut_3,
  t0_.date_fin AS date_fin_4,
  t0_.temps_estime AS temps_estime_5,
  t0_.description AS description_6,
  t0_.statut AS statut_7,
  t0_.created_at AS created_at_8,
  t0_.box AS box_9,
  t0_.rank AS rank_10,
  t0_.file AS file_11,
  t0_.priority AS priority_12,
  t0_.kanban_id_old AS kanban_id_old_13,
  t0_.created_by_id AS created_by_id_14,
  t0_.contrat_id AS contrat_id_15,
  t0_.projet_id AS projet_id_16,
  t0_.owner_id AS owner_id_17,
  t0_.employe_id AS employe_id_18,
  t0_.activity_id AS activity_id_19,
  t0_.kanban_id AS kanban_id_20
FROM
  task t0_
WHERE
  t0_.kanban_id = ?
  AND t0_.box = 1
ORDER BY
  t0_.rank ASC,
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = 0x01A05C961573787E8BCA652BAACBFE75 AND t0_.box = 1 ORDER BY t0_.rank ASC, t0_.created_at 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	App\Repository\KanbanRepository->getTasksTodo (line 169)
7	App\Twig\DossierExtension->kanbanLink (line 65)
8	__TwigTemplate_726898f978152757e4a585e41d730d64->doDisplay (line 857)
9	Twig\Template->yield (line 411)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
13	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
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 122)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 24)

4.75 ms
(7.24%)

SELECT
                COUNT(CASE WHEN t.box = 1 THEN 1 END) as todo,
                COUNT(CASE WHEN t.box = 2 THEN 1 END) as progress,
                COUNT(CASE WHEN t.box = 3 THEN 1 END) as completed,
                COUNT(t.id) as total
            FROM kanban k
            LEFT JOIN task t ON t.kanban_id = k.id
            WHERE k.id = ?

Parameters:

[
  b"\x01 \–\x15sx~‹Êe+ªËþu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(CASE WHEN t.box = 1 THEN
    1
  END) as todo,
  COUNT(CASE WHEN t.box = 2 THEN
    1
  END) as progress,
  COUNT(CASE WHEN t.box = 3 THEN
    1
  END) as completed,
  COUNT(t.id) as total
FROM
  kanban k
  LEFT JOIN task t ON t.kanban_id = k.id
WHERE
  k.id = ?

SELECT
                COUNT(CASE WHEN t.box = 1 THEN 1 END) as todo,
                COUNT(CASE WHEN t.box = 2 THEN 1 END) as progress,
                COUNT(CASE WHEN t.box = 3 THEN 1 END) as completed,
                COUNT(t.id) as total
            FROM kanban k
            LEFT JOIN task t ON t.kanban_id = k.id
            WHERE k.id = 0x01A05C961573787E8BCA652BAACBFE75
        ;

#	File/Call
1	App\Repository\KanbanRepository->countTasksByBox (line 138)
2	App\Twig\DossierExtension->kanbanLink (line 62)
3	__TwigTemplate_726898f978152757e4a585e41d730d64->doDisplay (line 857)
4	Twig\Template->yield (line 411)
5	Twig\Template->display (line 366)
6	Twig\Template->render (line 381)
7	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
8	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
9	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 24)

3.28 ms
(5.00%)

SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_id = ?

Parameters:

[
  "dossier"
  99
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  document d0_
WHERE
  d0_.entity_name = ?
  AND d0_.entity_id = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = 'dossier' AND d0_.entity_id = 99;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\DocumentRepository->countByEntity (line 32)
8	App\Twig\DocumentExtension->countDocuments (line 52)
9	__TwigTemplate_726898f978152757e4a585e41d730d64->doDisplay (line 706)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

2.92 ms
(4.45%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.bg AS bg_3,
  t0.visible AS visible_4,
  t0.seo AS seo_5,
  t0.api_update AS api_update_6
FROM
  dossier_status t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status 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\Twig\Components\DossierLive->getStatusList (line 1394)
6	Twig\Extension\CoreExtension->getAttribute (line 1928)
7	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 1041)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
12	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
13	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 24)

2.20 ms
(3.36%)

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = ? AND t0_.box = 2 ORDER BY t0_.rank ASC, t0_.created_at DESC

Parameters:

[
  b"\x01 \–\x15sx~‹Êe+ªËþu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t0_.title AS title_2,
  t0_.date_debut AS date_debut_3,
  t0_.date_fin AS date_fin_4,
  t0_.temps_estime AS temps_estime_5,
  t0_.description AS description_6,
  t0_.statut AS statut_7,
  t0_.created_at AS created_at_8,
  t0_.box AS box_9,
  t0_.rank AS rank_10,
  t0_.file AS file_11,
  t0_.priority AS priority_12,
  t0_.kanban_id_old AS kanban_id_old_13,
  t0_.created_by_id AS created_by_id_14,
  t0_.contrat_id AS contrat_id_15,
  t0_.projet_id AS projet_id_16,
  t0_.owner_id AS owner_id_17,
  t0_.employe_id AS employe_id_18,
  t0_.activity_id AS activity_id_19,
  t0_.kanban_id AS kanban_id_20
FROM
  task t0_
WHERE
  t0_.kanban_id = ?
  AND t0_.box = 2
ORDER BY
  t0_.rank ASC,
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = 0x01A05C961573787E8BCA652BAACBFE75 AND t0_.box = 2 ORDER BY t0_.rank ASC, t0_.created_at 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	App\Repository\KanbanRepository->getTasksInProgress (line 190)
7	App\Repository\KanbanRepository->getKanbanTasksInfo (line 230)
8	App\Twig\DossierExtension->kanbanLink (line 67)
9	__TwigTemplate_726898f978152757e4a585e41d730d64->doDisplay (line 857)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

2.09 ms
(3.18%)

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.created_at AS created_at_2, d0_.date_reception AS date_reception_3, d0_.date_livraison_maquette AS date_livraison_maquette_4, d0_.date_production AS date_production_5, d0_.date_livraison AS date_livraison_6, d0_.description AS description_7, d0_.link AS link_8, d0_.priority AS priority_9, d0_.type AS type_10, d0_.docs AS docs_11, d0_.deadline AS deadline_12, d0_.devis AS devis_13, d0_.slug AS slug_14, d0_.link_preview AS link_preview_15, d0_.link_template AS link_template_16, d0_.facture AS facture_17, d0_.seo_stats AS seo_stats_18, d0_.bloque AS bloque_19, d0_.reference AS reference_20, d0_.projet_id AS projet_id_21, d0_.contact_id AS contact_id_22, d0_.status_id AS status_id_23, d0_.created_by_id AS created_by_id_24, d0_.kanban_id AS kanban_id_25, d0_.manager_id AS manager_id_26, d0_.affected_to_id AS affected_to_id_27 FROM dossier d0_ WHERE d0_.contact_id = ? ORDER BY d0_.created_at DESC

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  d0_.created_at AS created_at_2,
  d0_.date_reception AS date_reception_3,
  d0_.date_livraison_maquette AS date_livraison_maquette_4,
  d0_.date_production AS date_production_5,
  d0_.date_livraison AS date_livraison_6,
  d0_.description AS description_7,
  d0_.link AS link_8,
  d0_.priority AS priority_9,
  d0_.type AS type_10,
  d0_.docs AS docs_11,
  d0_.deadline AS deadline_12,
  d0_.devis AS devis_13,
  d0_.slug AS slug_14,
  d0_.link_preview AS link_preview_15,
  d0_.link_template AS link_template_16,
  d0_.facture AS facture_17,
  d0_.seo_stats AS seo_stats_18,
  d0_.bloque AS bloque_19,
  d0_.reference AS reference_20,
  d0_.projet_id AS projet_id_21,
  d0_.contact_id AS contact_id_22,
  d0_.status_id AS status_id_23,
  d0_.created_by_id AS created_by_id_24,
  d0_.kanban_id AS kanban_id_25,
  d0_.manager_id AS manager_id_26,
  d0_.affected_to_id AS affected_to_id_27
FROM
  dossier d0_
WHERE
  d0_.contact_id = ?
ORDER BY
  d0_.created_at DESC

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.created_at AS created_at_2, d0_.date_reception AS date_reception_3, d0_.date_livraison_maquette AS date_livraison_maquette_4, d0_.date_production AS date_production_5, d0_.date_livraison AS date_livraison_6, d0_.description AS description_7, d0_.link AS link_8, d0_.priority AS priority_9, d0_.type AS type_10, d0_.docs AS docs_11, d0_.deadline AS deadline_12, d0_.devis AS devis_13, d0_.slug AS slug_14, d0_.link_preview AS link_preview_15, d0_.link_template AS link_template_16, d0_.facture AS facture_17, d0_.seo_stats AS seo_stats_18, d0_.bloque AS bloque_19, d0_.reference AS reference_20, d0_.projet_id AS projet_id_21, d0_.contact_id AS contact_id_22, d0_.status_id AS status_id_23, d0_.created_by_id AS created_by_id_24, d0_.kanban_id AS kanban_id_25, d0_.manager_id AS manager_id_26, d0_.affected_to_id AS affected_to_id_27 FROM dossier d0_ WHERE d0_.contact_id = 49 ORDER BY d0_.created_at 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	App\Repository\DossierRepository->findDossiers (line 164)
7	App\Twig\Components\DossierLive->getDossiers (line 1293)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 1132)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

2.09 ms
(3.18%)

UPDATE dossier_meta SET updated_at = ? WHERE id = ?

Parameters:

[
  "2026-09-07 09:34:08"
  594
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  dossier_meta
SET
  updated_at = ?
WHERE
  id = ?

UPDATE dossier_meta SET updated_at = '2026-09-07 09:34:08' WHERE id = 594;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\DossierMetaService->setMeta (line 55)
7	App\Twig\Components\DossierLive->save (line 811)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 24)

2.06 ms
(3.14%)

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC

Parameters:

[
  b"\x01 \–\x15sx~‹Êe+ªËþu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t0_.title AS title_2,
  t0_.date_debut AS date_debut_3,
  t0_.date_fin AS date_fin_4,
  t0_.temps_estime AS temps_estime_5,
  t0_.description AS description_6,
  t0_.statut AS statut_7,
  t0_.created_at AS created_at_8,
  t0_.box AS box_9,
  t0_.rank AS rank_10,
  t0_.file AS file_11,
  t0_.priority AS priority_12,
  t0_.kanban_id_old AS kanban_id_old_13,
  t0_.created_by_id AS created_by_id_14,
  t0_.contrat_id AS contrat_id_15,
  t0_.projet_id AS projet_id_16,
  t0_.owner_id AS owner_id_17,
  t0_.employe_id AS employe_id_18,
  t0_.activity_id AS activity_id_19,
  t0_.kanban_id AS kanban_id_20
FROM
  task t0_
WHERE
  t0_.kanban_id = ?
  AND t0_.box = 3
ORDER BY
  t0_.rank ASC,
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = 0x01A05C961573787E8BCA652BAACBFE75 AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at 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	App\Repository\KanbanRepository->getTasksCompleted (line 211)
7	App\Repository\KanbanRepository->getKanbanTasksInfo (line 231)
8	App\Twig\DossierExtension->kanbanLink (line 67)
9	__TwigTemplate_726898f978152757e4a585e41d730d64->doDisplay (line 857)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

1.92 ms
(2.92%)

SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?

Parameters:

[
  b"\x01 \–\x15sx~‹Êe+ªËþu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  kanban k1_
  LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id
WHERE
  k1_.id = ?

SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = 0x01A05C961573787E8BCA652BAACBFE75;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\KanbanRepository->countTasksByKanban (line 113)
8	App\Twig\DossierExtension->kanbanLink (line 69)
9	__TwigTemplate_726898f978152757e4a585e41d730d64->doDisplay (line 857)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

1.92 ms
(2.92%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.photo AS photo_7, t0.phone AS phone_8, t0.bio AS bio_9, t0.enabled AS enabled_10, t0.reference AS reference_11, t0.theme AS theme_12, t0.kanban_notification AS kanban_notification_13, t0.last_activity_at AS last_activity_at_14, t0.last_activity_source AS last_activity_source_15, t0.access_app AS access_app_16, t0.is_active AS is_active_17, t0.google_id AS google_id_18, t0.google_access_token AS google_access_token_19, t0.google_refresh_token AS google_refresh_token_20, t0.google_token_expires_at AS google_token_expires_at_21, t0.google_token_expires AS google_token_expires_22, t0.role_id AS role_id_23, t0.client_id AS client_id_24 FROM user t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.photo AS photo_7,
  t0.phone AS phone_8,
  t0.bio AS bio_9,
  t0.enabled AS enabled_10,
  t0.reference AS reference_11,
  t0.theme AS theme_12,
  t0.kanban_notification AS kanban_notification_13,
  t0.last_activity_at AS last_activity_at_14,
  t0.last_activity_source AS last_activity_source_15,
  t0.access_app AS access_app_16,
  t0.is_active AS is_active_17,
  t0.google_id AS google_id_18,
  t0.google_access_token AS google_access_token_19,
  t0.google_refresh_token AS google_refresh_token_20,
  t0.google_token_expires_at AS google_token_expires_at_21,
  t0.google_token_expires AS google_token_expires_22,
  t0.role_id AS role_id_23,
  t0.client_id AS client_id_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.photo AS photo_7, t0.phone AS phone_8, t0.bio AS bio_9, t0.enabled AS enabled_10, t0.reference AS reference_11, t0.theme AS theme_12, t0.kanban_notification AS kanban_notification_13, t0.last_activity_at AS last_activity_at_14, t0.last_activity_source AS last_activity_source_15, t0.access_app AS access_app_16, t0.is_active AS is_active_17, t0.google_id AS google_id_18, t0.google_access_token AS google_access_token_19, t0.google_refresh_token AS google_refresh_token_20, t0.google_token_expires_at AS google_token_expires_at_21, t0.google_token_expires AS google_token_expires_22, t0.role_id AS role_id_23, t0.client_id AS client_id_24 FROM user t0 WHERE t0.id = 5;

#	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 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 24)

1.36 ms
(2.07%)

UPDATE dossier SET date_reception = ?, date_livraison_maquette = ?, affected_to_id = ? WHERE id = ?

Parameters:

[
  "2026-08-24"
  "2026-08-31"
  80
  97
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  dossier
SET
  date_reception = ?,
  date_livraison_maquette = ?,
  affected_to_id = ?
WHERE
  id = ?

UPDATE dossier SET date_reception = '2026-08-24', date_livraison_maquette = '2026-08-31', affected_to_id = 80 WHERE id = 97;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Twig\Components\DossierLive->save (line 793)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 24)

1.06 ms
(1.62%)

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.created_at AS created_at_2, d0_.date_reception AS date_reception_3, d0_.date_livraison_maquette AS date_livraison_maquette_4, d0_.date_production AS date_production_5, d0_.date_livraison AS date_livraison_6, d0_.description AS description_7, d0_.link AS link_8, d0_.priority AS priority_9, d0_.type AS type_10, d0_.docs AS docs_11, d0_.deadline AS deadline_12, d0_.devis AS devis_13, d0_.slug AS slug_14, d0_.link_preview AS link_preview_15, d0_.link_template AS link_template_16, d0_.facture AS facture_17, d0_.seo_stats AS seo_stats_18, d0_.bloque AS bloque_19, d0_.reference AS reference_20, d0_.projet_id AS projet_id_21, d0_.contact_id AS contact_id_22, d0_.status_id AS status_id_23, d0_.created_by_id AS created_by_id_24, d0_.kanban_id AS kanban_id_25, d0_.manager_id AS manager_id_26, d0_.affected_to_id AS affected_to_id_27 FROM dossier d0_ WHERE d0_.contact_id = ?

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  d0_.created_at AS created_at_2,
  d0_.date_reception AS date_reception_3,
  d0_.date_livraison_maquette AS date_livraison_maquette_4,
  d0_.date_production AS date_production_5,
  d0_.date_livraison AS date_livraison_6,
  d0_.description AS description_7,
  d0_.link AS link_8,
  d0_.priority AS priority_9,
  d0_.type AS type_10,
  d0_.docs AS docs_11,
  d0_.deadline AS deadline_12,
  d0_.devis AS devis_13,
  d0_.slug AS slug_14,
  d0_.link_preview AS link_preview_15,
  d0_.link_template AS link_template_16,
  d0_.facture AS facture_17,
  d0_.seo_stats AS seo_stats_18,
  d0_.bloque AS bloque_19,
  d0_.reference AS reference_20,
  d0_.projet_id AS projet_id_21,
  d0_.contact_id AS contact_id_22,
  d0_.status_id AS status_id_23,
  d0_.created_by_id AS created_by_id_24,
  d0_.kanban_id AS kanban_id_25,
  d0_.manager_id AS manager_id_26,
  d0_.affected_to_id AS affected_to_id_27
FROM
  dossier d0_
WHERE
  d0_.contact_id = ?

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.created_at AS created_at_2, d0_.date_reception AS date_reception_3, d0_.date_livraison_maquette AS date_livraison_maquette_4, d0_.date_production AS date_production_5, d0_.date_livraison AS date_livraison_6, d0_.description AS description_7, d0_.link AS link_8, d0_.priority AS priority_9, d0_.type AS type_10, d0_.docs AS docs_11, d0_.deadline AS deadline_12, d0_.devis AS devis_13, d0_.slug AS slug_14, d0_.link_preview AS link_preview_15, d0_.link_template AS link_template_16, d0_.facture AS facture_17, d0_.seo_stats AS seo_stats_18, d0_.bloque AS bloque_19, d0_.reference AS reference_20, d0_.projet_id AS projet_id_21, d0_.contact_id AS contact_id_22, d0_.status_id AS status_id_23, d0_.created_by_id AS created_by_id_24, d0_.kanban_id AS kanban_id_25, d0_.manager_id AS manager_id_26, d0_.affected_to_id AS affected_to_id_27 FROM dossier d0_ WHERE d0_.contact_id = 49;

#	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	App\Repository\DossierRepository->findDossierByclient (line 144)
7	App\Service\DossierStatsService->getStats (line 20)
8	App\Twig\Components\DossierLive->getDossierStats (line 1303)
9	Twig\Extension\CoreExtension->getAttribute (line 1928)
10	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 60)
11	Twig\Template->yield (line 411)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
16	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 24)

1.01 ms
(1.54%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\EventSubscriber\UserActivitySubscriber->onRequest (line 35)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 24)

0.85 ms
(1.30%)

UPDATE user SET last_activity_at = ? WHERE id = ?

Parameters:

[
  "2026-09-07 09:34:08"
  5
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_activity_at = ?
WHERE
  id = ?

UPDATE user SET last_activity_at = '2026-09-07 09:34:08' WHERE id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\EventSubscriber\UserActivitySubscriber->onRequest (line 35)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 24)

0.72 ms
(1.09%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\EventSubscriber\UserActivitySubscriber->onRequest (line 35)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 24)

0.72 ms
(1.09%)

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.created_at AS created_at_2, d0_.date_reception AS date_reception_3, d0_.date_livraison_maquette AS date_livraison_maquette_4, d0_.date_production AS date_production_5, d0_.date_livraison AS date_livraison_6, d0_.description AS description_7, d0_.link AS link_8, d0_.priority AS priority_9, d0_.type AS type_10, d0_.docs AS docs_11, d0_.deadline AS deadline_12, d0_.devis AS devis_13, d0_.slug AS slug_14, d0_.link_preview AS link_preview_15, d0_.link_template AS link_template_16, d0_.facture AS facture_17, d0_.seo_stats AS seo_stats_18, d0_.bloque AS bloque_19, d0_.reference AS reference_20, d0_.id AS id_21, d0_.libelle AS libelle_22, d0_.created_at AS created_at_23, d0_.date_reception AS date_reception_24, d0_.date_livraison_maquette AS date_livraison_maquette_25, d0_.date_production AS date_production_26, d0_.date_livraison AS date_livraison_27, d0_.description AS description_28, d0_.link AS link_29, d0_.priority AS priority_30, d0_.type AS type_31, d0_.docs AS docs_32, d0_.deadline AS deadline_33, d0_.devis AS devis_34, d0_.slug AS slug_35, d0_.link_preview AS link_preview_36, d0_.link_template AS link_template_37, d0_.facture AS facture_38, d0_.seo_stats AS seo_stats_39, d0_.bloque AS bloque_40, d0_.reference AS reference_41, d0_.projet_id AS projet_id_42, d0_.contact_id AS contact_id_43, d0_.status_id AS status_id_44, d0_.created_by_id AS created_by_id_45, d0_.kanban_id AS kanban_id_46, d0_.manager_id AS manager_id_47, d0_.affected_to_id AS affected_to_id_48 FROM dossier d0_ WHERE d0_.contact_id = ? ORDER BY d0_.id DESC LIMIT 25

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  d0_.created_at AS created_at_2,
  d0_.date_reception AS date_reception_3,
  d0_.date_livraison_maquette AS date_livraison_maquette_4,
  d0_.date_production AS date_production_5,
  d0_.date_livraison AS date_livraison_6,
  d0_.description AS description_7,
  d0_.link AS link_8,
  d0_.priority AS priority_9,
  d0_.type AS type_10,
  d0_.docs AS docs_11,
  d0_.deadline AS deadline_12,
  d0_.devis AS devis_13,
  d0_.slug AS slug_14,
  d0_.link_preview AS link_preview_15,
  d0_.link_template AS link_template_16,
  d0_.facture AS facture_17,
  d0_.seo_stats AS seo_stats_18,
  d0_.bloque AS bloque_19,
  d0_.reference AS reference_20,
  d0_.id AS id_21,
  d0_.libelle AS libelle_22,
  d0_.created_at AS created_at_23,
  d0_.date_reception AS date_reception_24,
  d0_.date_livraison_maquette AS date_livraison_maquette_25,
  d0_.date_production AS date_production_26,
  d0_.date_livraison AS date_livraison_27,
  d0_.description AS description_28,
  d0_.link AS link_29,
  d0_.priority AS priority_30,
  d0_.type AS type_31,
  d0_.docs AS docs_32,
  d0_.deadline AS deadline_33,
  d0_.devis AS devis_34,
  d0_.slug AS slug_35,
  d0_.link_preview AS link_preview_36,
  d0_.link_template AS link_template_37,
  d0_.facture AS facture_38,
  d0_.seo_stats AS seo_stats_39,
  d0_.bloque AS bloque_40,
  d0_.reference AS reference_41,
  d0_.projet_id AS projet_id_42,
  d0_.contact_id AS contact_id_43,
  d0_.status_id AS status_id_44,
  d0_.created_by_id AS created_by_id_45,
  d0_.kanban_id AS kanban_id_46,
  d0_.manager_id AS manager_id_47,
  d0_.affected_to_id AS affected_to_id_48
FROM
  dossier d0_
WHERE
  d0_.contact_id = ?
ORDER BY
  d0_.id DESC
LIMIT
  25

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.created_at AS created_at_2, d0_.date_reception AS date_reception_3, d0_.date_livraison_maquette AS date_livraison_maquette_4, d0_.date_production AS date_production_5, d0_.date_livraison AS date_livraison_6, d0_.description AS description_7, d0_.link AS link_8, d0_.priority AS priority_9, d0_.type AS type_10, d0_.docs AS docs_11, d0_.deadline AS deadline_12, d0_.devis AS devis_13, d0_.slug AS slug_14, d0_.link_preview AS link_preview_15, d0_.link_template AS link_template_16, d0_.facture AS facture_17, d0_.seo_stats AS seo_stats_18, d0_.bloque AS bloque_19, d0_.reference AS reference_20, d0_.id AS id_21, d0_.libelle AS libelle_22, d0_.created_at AS created_at_23, d0_.date_reception AS date_reception_24, d0_.date_livraison_maquette AS date_livraison_maquette_25, d0_.date_production AS date_production_26, d0_.date_livraison AS date_livraison_27, d0_.description AS description_28, d0_.link AS link_29, d0_.priority AS priority_30, d0_.type AS type_31, d0_.docs AS docs_32, d0_.deadline AS deadline_33, d0_.devis AS devis_34, d0_.slug AS slug_35, d0_.link_preview AS link_preview_36, d0_.link_template AS link_template_37, d0_.facture AS facture_38, d0_.seo_stats AS seo_stats_39, d0_.bloque AS bloque_40, d0_.reference AS reference_41, d0_.projet_id AS projet_id_42, d0_.contact_id AS contact_id_43, d0_.status_id AS status_id_44, d0_.created_by_id AS created_by_id_45, d0_.kanban_id AS kanban_id_46, d0_.manager_id AS manager_id_47, d0_.affected_to_id AS affected_to_id_48 FROM dossier d0_ WHERE d0_.contact_id = 49 ORDER BY d0_.id DESC LIMIT 25;

#	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	App\Twig\Components\DossierLive->getData (line 1679)
7	Twig\Extension\CoreExtension->getAttribute (line 1928)
8	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 589)
9	Twig\Template->yield (line 411)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
13	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
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 122)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 24)

0.61 ms
(0.93%)

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.extension AS extension_7, t0.category AS category_8, t0.entity_name AS entity_name_9, t0.entity_id AS entity_id_10, t0.uploaded_at AS uploaded_at_11 FROM document t0 WHERE t0.id = ?

Parameters:

[
  362
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_name AS original_name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.extension AS extension_7,
  t0.category AS category_8,
  t0.entity_name AS entity_name_9,
  t0.entity_id AS entity_id_10,
  t0.uploaded_at AS uploaded_at_11
FROM
  document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.extension AS extension_7, t0.category AS category_8, t0.entity_name AS entity_name_9, t0.entity_id AS entity_id_10, t0.uploaded_at AS uploaded_at_11 FROM document t0 WHERE t0.id = 362;

#	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	App\Twig\Components\DossierLive->save (line 800)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 24)

0.51 ms
(0.78%)

SELECT u0_.id AS id_0, u0_.full_name AS full_name_1, COUNT(d1_.id) AS sclr_2 FROM user u0_ LEFT JOIN dossier d1_ ON (d1_.manager_id = u0_.id AND d1_.contact_id = ?) WHERE u0_.client_id = ? GROUP BY u0_.id ORDER BY u0_.full_name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.full_name AS full_name_1,
  COUNT(d1_.id) AS sclr_2
FROM
  user u0_
  LEFT JOIN dossier d1_ ON (
    d1_.manager_id = u0_.id
    AND d1_.contact_id = ?
  )
WHERE
  u0_.client_id = ?
GROUP BY
  u0_.id
ORDER BY
  u0_.full_name ASC

SELECT u0_.id AS id_0, u0_.full_name AS full_name_1, COUNT(d1_.id) AS sclr_2 FROM user u0_ LEFT JOIN dossier d1_ ON (d1_.manager_id = u0_.id AND d1_.contact_id = 49) WHERE u0_.client_id = 49 GROUP BY u0_.id ORDER BY u0_.full_name ASC;

#	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	App\Repository\UserRepository->getManagersWithDossierCount (line 184)
7	App\Twig\Components\DossierLive->getManagerFilters (line 1353)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 194)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

0.42 ms
(0.64%)

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, COUNT(d1_.id) AS sclr_2 FROM dossier_status d0_ LEFT JOIN dossier d1_ ON d0_.id = d1_.status_id WHERE d1_.contact_id = ? GROUP BY d0_.id

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  COUNT(d1_.id) AS sclr_2
FROM
  dossier_status d0_
  LEFT JOIN dossier d1_ ON d0_.id = d1_.status_id
WHERE
  d1_.contact_id = ?
GROUP BY
  d0_.id

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, COUNT(d1_.id) AS sclr_2 FROM dossier_status d0_ LEFT JOIN dossier d1_ ON d0_.id = d1_.status_id WHERE d1_.contact_id = 49 GROUP BY d0_.id;

#	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	App\Repository\DossierStatusRepository->getStatutsWithDossierCount (line 110)
7	App\Twig\Components\DossierLive->getLeftStatus (line 1309)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 241)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

0.40 ms
(0.61%)

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.bg AS bg_2, d0_.visible AS visible_3, d0_.seo AS seo_4, d0_.api_update AS api_update_5 FROM dossier_status d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  d0_.bg AS bg_2,
  d0_.visible AS visible_3,
  d0_.seo AS seo_4,
  d0_.api_update AS api_update_5
FROM
  dossier_status d0_

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.bg AS bg_2, d0_.visible AS visible_3, d0_.seo AS seo_4, d0_.api_update AS api_update_5 FROM dossier_status d0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Twig\Components\DossierLive->getFormView (line 120)
21	App\Twig\Components\DossierLive->submitForm (line 180)
22	App\Twig\Components\DossierLive->submitFormOnRender (line 113)
23	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 336)
24	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 24)

0.33 ms
(0.50%)

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dossier d0_ WHERE d0_.contact_id = ?

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  dossier d0_
WHERE
  d0_.contact_id = ?

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dossier d0_ WHERE d0_.contact_id = 49;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Twig\Components\DossierLive->getData (line 1658)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 589)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

0.29 ms
(0.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM role t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM role t0 WHERE t0.id = 1;

#	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\Role::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Role->__get (line 146)
7	App\Entity\Role->getCode (line 65)
8	App\Entity\User->getRoles (line 204)
9	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 308)
10	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 24)

0.28 ms
(0.43%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.entreprise AS entreprise_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.pays AS pays_7, t0.logo AS logo_8, t0.email AS email_9, t0.email2 AS email2_10, t0.tel AS tel_11, t0.tel2 AS tel2_12, t0.fax AS fax_13, t0.remarques AS remarques_14, t0.created_at AS created_at_15, t0.formule AS formule_16, t0.entreprise_type AS entreprise_type_17, t0.cp AS cp_18, t0.ville AS ville_19, t0.slug AS slug_20, t0.avec_dossier AS avec_dossier_21, t0.created_by_id AS created_by_id_22 FROM contact t0 WHERE t0.id = ?

Parameters:

[
  49
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.entreprise AS entreprise_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.adresse AS adresse_6,
  t0.pays AS pays_7,
  t0.logo AS logo_8,
  t0.email AS email_9,
  t0.email2 AS email2_10,
  t0.tel AS tel_11,
  t0.tel2 AS tel2_12,
  t0.fax AS fax_13,
  t0.remarques AS remarques_14,
  t0.created_at AS created_at_15,
  t0.formule AS formule_16,
  t0.entreprise_type AS entreprise_type_17,
  t0.cp AS cp_18,
  t0.ville AS ville_19,
  t0.slug AS slug_20,
  t0.avec_dossier AS avec_dossier_21,
  t0.created_by_id AS created_by_id_22
FROM
  contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.entreprise AS entreprise_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.pays AS pays_7, t0.logo AS logo_8, t0.email AS email_9, t0.email2 AS email2_10, t0.tel AS tel_11, t0.tel2 AS tel2_12, t0.fax AS fax_13, t0.remarques AS remarques_14, t0.created_at AS created_at_15, t0.formule AS formule_16, t0.entreprise_type AS entreprise_type_17, t0.cp AS cp_18, t0.ville AS ville_19, t0.slug AS slug_20, t0.avec_dossier AS avec_dossier_21, t0.created_by_id AS created_by_id_22 FROM contact t0 WHERE t0.id = 49;

#	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	Symfony\UX\LiveComponent\Hydration\DoctrineEntityHydrationExtension->hydrate (line 53)
5	Symfony\UX\LiveComponent\LiveComponentHydrator->hydrateObjectValue (line 724)
6	Symfony\UX\LiveComponent\LiveComponentHydrator->hydrateValue (line 404)
7	Symfony\UX\LiveComponent\LiveComponentHydrator->hydrate (line 186)
8	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->hydrateComponent (line 373)
9	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelController (line 175)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 24)

0.19 ms
(0.28%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.date_reception AS date_reception_4, t0.date_livraison_maquette AS date_livraison_maquette_5, t0.date_production AS date_production_6, t0.date_livraison AS date_livraison_7, t0.description AS description_8, t0.link AS link_9, t0.priority AS priority_10, t0.type AS type_11, t0.docs AS docs_12, t0.deadline AS deadline_13, t0.devis AS devis_14, t0.slug AS slug_15, t0.link_preview AS link_preview_16, t0.link_template AS link_template_17, t0.facture AS facture_18, t0.seo_stats AS seo_stats_19, t0.bloque AS bloque_20, t0.reference AS reference_21, t0.projet_id AS projet_id_22, t0.contact_id AS contact_id_23, t0.status_id AS status_id_24, t0.created_by_id AS created_by_id_25, t0.kanban_id AS kanban_id_26, t0.manager_id AS manager_id_27, t0.affected_to_id AS affected_to_id_28 FROM dossier t0 WHERE t0.id = ?

Parameters:

[
  97
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.created_at AS created_at_3,
  t0.date_reception AS date_reception_4,
  t0.date_livraison_maquette AS date_livraison_maquette_5,
  t0.date_production AS date_production_6,
  t0.date_livraison AS date_livraison_7,
  t0.description AS description_8,
  t0.link AS link_9,
  t0.priority AS priority_10,
  t0.type AS type_11,
  t0.docs AS docs_12,
  t0.deadline AS deadline_13,
  t0.devis AS devis_14,
  t0.slug AS slug_15,
  t0.link_preview AS link_preview_16,
  t0.link_template AS link_template_17,
  t0.facture AS facture_18,
  t0.seo_stats AS seo_stats_19,
  t0.bloque AS bloque_20,
  t0.reference AS reference_21,
  t0.projet_id AS projet_id_22,
  t0.contact_id AS contact_id_23,
  t0.status_id AS status_id_24,
  t0.created_by_id AS created_by_id_25,
  t0.kanban_id AS kanban_id_26,
  t0.manager_id AS manager_id_27,
  t0.affected_to_id AS affected_to_id_28
FROM
  dossier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.date_reception AS date_reception_4, t0.date_livraison_maquette AS date_livraison_maquette_5, t0.date_production AS date_production_6, t0.date_livraison AS date_livraison_7, t0.description AS description_8, t0.link AS link_9, t0.priority AS priority_10, t0.type AS type_11, t0.docs AS docs_12, t0.deadline AS deadline_13, t0.devis AS devis_14, t0.slug AS slug_15, t0.link_preview AS link_preview_16, t0.link_template AS link_template_17, t0.facture AS facture_18, t0.seo_stats AS seo_stats_19, t0.bloque AS bloque_20, t0.reference AS reference_21, t0.projet_id AS projet_id_22, t0.contact_id AS contact_id_23, t0.status_id AS status_id_24, t0.created_by_id AS created_by_id_25, t0.kanban_id AS kanban_id_26, t0.manager_id AS manager_id_27, t0.affected_to_id AS affected_to_id_28 FROM dossier t0 WHERE t0.id = 97;

#	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	App\Twig\Components\DossierLive->save (line 725)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 24)

0.13 ms
(0.20%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.parent AS parent_4, t0.icon AS icon_5 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.parent AS parent_4,
  t0.icon AS icon_5
FROM
  permission t0
  INNER JOIN role_permission ON t0.id = role_permission.permission_id
WHERE
  role_permission.role_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.parent AS parent_4, t0.icon AS icon_5 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = 1;

#	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 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Security\Voter\ModuleVoter->voteOnAttribute (line 60)
8	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 48)
9	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 70)
11	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 35)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 59)
13	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 58)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 41)
15	Symfony\Bundle\SecurityBundle\Security->isGranted (line 63)
16	App\Form\DossierType->buildForm (line 210)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
20	Symfony\Component\Form\FormFactory->createBuilder (line 41)
21	Symfony\Component\Form\FormFactory->create (line 26)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 323)
23	App\Twig\Components\DossierLive->instantiateForm (line 896)
24	App\Twig\Components\DossierLive->getForm (line 196)
25	App\Twig\Components\DossierLive->submitForm (line 162)
26	App\Twig\Components\DossierLive->submitFormOnRender (line 113)
27	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 336)
28	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 182)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 24)

0.12 ms
(0.19%)

SELECT n0_.entity_id AS entity_id_0, COUNT(n0_.id) AS sclr_1 FROM notification n0_ WHERE n0_.destination_id = ? AND n0_.vue = 0 AND n0_.type = ? AND n0_.entity = ? AND n0_.entity_id IS NOT NULL GROUP BY n0_.entity_id

Parameters:

[
  5
  "dossier.message"
  "Dossier"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.entity_id AS entity_id_0,
  COUNT(n0_.id) AS sclr_1
FROM
  notification n0_
WHERE
  n0_.destination_id = ?
  AND n0_.vue = 0
  AND n0_.type = ?
  AND n0_.entity = ?
  AND n0_.entity_id IS NOT NULL
GROUP BY
  n0_.entity_id

SELECT n0_.entity_id AS entity_id_0, COUNT(n0_.id) AS sclr_1 FROM notification n0_ WHERE n0_.destination_id = 5 AND n0_.vue = 0 AND n0_.type = 'dossier.message' AND n0_.entity = 'Dossier' AND n0_.entity_id IS NOT NULL GROUP BY n0_.entity_id;

#	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->getArrayResult (line 700)
6	App\Repository\NotificationRepository->countUnreadByEntity (line 123)
7	App\Twig\Components\DossierLive->getUnreadMessageCounts (line 1148)
8	Twig\Extension\CoreExtension->getAttribute (line 1928)
9	__TwigTemplate_726898f978152757e4a585e41d730d64::doDisplay (line 592)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->createResponse (line 339)
15	Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber->onKernelView (line 266)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 24)

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
App\Entity\DossierMeta	103
App\Entity\Dossier	66
App\Entity\Kanban	57
App\Entity\Permission	35
App\Entity\Task	14
App\Entity\DossierStatus	12
App\Entity\User	9
App\Entity\Role	4
App\Entity\Document	3
App\Entity\TaskActivity	3
App\Entity\Contact	1

Entities Mapping

Class	Mapping errors
App\Entity\User	The association App\Entity\User#role refers to the inverse side field App\Entity\Role#user which does not exist.
App\Entity\Role	No errors.
App\Entity\Contact	The mappings App\Entity\Contact#dossiers and App\Entity\Dossier#contact are inconsistent with each other.
App\Entity\UserMeta	No errors.
App\Entity\Permission	No errors.
App\Entity\Dossier	The association App\Entity\Dossier#projet refers to the inverse side field App\Entity\Projet#dossiers which does not exist. The association App\Entity\Dossier#contact refers to the inverse side field App\Entity\Contact#contact which does not exist. The field App\Entity\Dossier#kanban is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Kanban#dossier does not contain the required 'mappedBy: "kanban"' attribute. The field App\Entity\Dossier#statusHistories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DossierStatusHistory#dossier does not contain the required 'inversedBy: "statusHistories"' attribute.
App\Entity\Projet	The association App\Entity\Projet#client refers to the inverse side field App\Entity\Contact#projet which does not exist.
App\Entity\DossierStatus	The field App\Entity\DossierStatus#dossiers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Dossier#status does not contain the required 'inversedBy: "dossiers"' attribute.
App\Entity\Kanban	The association App\Entity\Kanban#contrat refers to the inverse side field App\Entity\Contrat#kanbans which does not exist. The field App\Entity\Kanban#dossier is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Dossier#kanban does not contain the required 'mappedBy: "dossier"' attribute.
App\Entity\Quote	No errors.
App\Entity\DossierMeta	No errors.
App\Entity\DossierStatusHistory	No errors.
App\Entity\Document	No errors.
App\Entity\Notification	No errors.
App\Entity\Task	No errors.
App\Entity\Contrat	The association App\Entity\Contrat#contact refers to the inverse side field App\Entity\Contact#contrat which does not exist.
App\Entity\TaskActivity	No errors.
App\Entity\TaskMeta	No errors.

Symfony Profiler

POST https://crm.blue-web-agency.fr/_components/DossierLive/save

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping