Symfony Profiler

Query Metrics

11 Database Queries

4 Different statements

4.39 ms Query time

16 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.48 ms
(33.80%)

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.pas_de_porte AS pas_de_porte_19, t0.loyer_annuel AS loyer_annuel_20, t0.royalties AS royalties_21, t0.reserves AS reserves_22, t0.ressources AS ressources_23, t0.id_dw AS id_dw_24, t0.is_publish AS is_publish_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.type_document_id AS type_document_id_29, t0.actionnariats_locaux_id AS actionnariats_locaux_id_30, t31.id AS id_32, t31.date_debut AS date_debut_33, t31.date_fin AS date_fin_34, t31.statut AS statut_35, t31.phase AS phase_36, t31.anotation AS anotation_37, t31.amodiant AS amodiant_38, t31.amodiateur AS amodiateur_39, t31.id_dw AS id_dw_40, t31.is_publish AS is_publish_41, t31.type_amodiation AS type_amodiation_42, t31.date_signature_contrat AS date_signature_contrat_43, t31.date_declaration_cami AS date_declaration_cami_44, t31.created_at AS created_at_45, t31.updated_at AS updated_at_46, t31.deleted_at AS deleted_at_47, t31.arrete_id AS arrete_id_48, t31.titre_id AS titre_id_49, t31.operateur_amodiateur_id AS operateur_amodiateur_id_50, t31.operateur_amodiant_id AS operateur_amodiant_id_51, t31.contrat_id AS contrat_id_52, t31.user_id AS user_id_53, t54.id AS id_55, t54.date_option AS date_option_56, t54.annotation AS annotation_57, t54.partenaire AS partenaire_58, t54.detentaire AS detentaire_59, t54.id_dw AS id_dw_60, t54.is_publish AS is_publish_61, t54.created_at AS created_at_62, t54.updated_at AS updated_at_63, t54.deleted_at AS deleted_at_64, t54.arrete_id AS arrete_id_65, t54.titre_id AS titre_id_66, t54.operateur_detentaire_id AS operateur_detentaire_id_67, t54.operateur_partenaire_id AS operateur_partenaire_id_68, t54.contrat_id AS contrat_id_69, t54.user_id AS user_id_70, t71.id AS id_72, t71.date_cession AS date_cession_73, t71.operation AS operation_74, t71.valeur AS valeur_75, t71.type_cession AS type_cession_76, t71.annotation AS annotation_77, t71.cedant AS cedant_78, t71.cessionnaire AS cessionnaire_79, t71.id_dw AS id_dw_80, t71.is_publish AS is_publish_81, t71.date_declaration_cami AS date_declaration_cami_82, t71.created_at AS created_at_83, t71.updated_at AS updated_at_84, t71.deleted_at AS deleted_at_85, t71.titre_id AS titre_id_86, t71.arrete_id AS arrete_id_87, t71.operateur_cedant_id AS operateur_cedant_id_88, t71.operateurcessionnaire_id AS operateurcessionnaire_id_89, t71.contrat_id AS contrat_id_90, t71.user_id AS user_id_91, t0.user_id AS user_id_92 FROM contrat_principal t0 LEFT JOIN amodiation t31 ON t31.contrat_id = t0.id LEFT JOIN `option` t54 ON t54.contrat_id = t0.id LEFT JOIN cession t71 ON t71.contrat_id = t0.id WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fichier AS fichier_2,
  t0.nom AS nom_3,
  t0.langue AS langue_4,
  t0.date_signature AS date_signature_5,
  t0.url_source AS url_source_6,
  t0.mode_divulgation AS mode_divulgation_7,
  t0.mode_text_divulgation AS mode_text_divulgation_8,
  t0.date_recuperation AS date_recuperation_9,
  t0.categorie AS categorie_10,
  t0.note AS note_11,
  t0.identifiant AS identifiant_12,
  t0.page_manquent AS page_manquent_13,
  t0.annexe_manquent AS annexe_manquent_14,
  t0.statut AS statut_15,
  t0.part_etat AS part_etat_16,
  t0.dure AS dure_17,
  t0.annee_signature AS annee_signature_18,
  t0.pas_de_porte AS pas_de_porte_19,
  t0.loyer_annuel AS loyer_annuel_20,
  t0.royalties AS royalties_21,
  t0.reserves AS reserves_22,
  t0.ressources AS ressources_23,
  t0.id_dw AS id_dw_24,
  t0.is_publish AS is_publish_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.deleted_at AS deleted_at_28,
  t0.type_document_id AS type_document_id_29,
  t0.actionnariats_locaux_id AS actionnariats_locaux_id_30,
  t31.id AS id_32,
  t31.date_debut AS date_debut_33,
  t31.date_fin AS date_fin_34,
  t31.statut AS statut_35,
  t31.phase AS phase_36,
  t31.anotation AS anotation_37,
  t31.amodiant AS amodiant_38,
  t31.amodiateur AS amodiateur_39,
  t31.id_dw AS id_dw_40,
  t31.is_publish AS is_publish_41,
  t31.type_amodiation AS type_amodiation_42,
  t31.date_signature_contrat AS date_signature_contrat_43,
  t31.date_declaration_cami AS date_declaration_cami_44,
  t31.created_at AS created_at_45,
  t31.updated_at AS updated_at_46,
  t31.deleted_at AS deleted_at_47,
  t31.arrete_id AS arrete_id_48,
  t31.titre_id AS titre_id_49,
  t31.operateur_amodiateur_id AS operateur_amodiateur_id_50,
  t31.operateur_amodiant_id AS operateur_amodiant_id_51,
  t31.contrat_id AS contrat_id_52,
  t31.user_id AS user_id_53,
  t54.id AS id_55,
  t54.date_option AS date_option_56,
  t54.annotation AS annotation_57,
  t54.partenaire AS partenaire_58,
  t54.detentaire AS detentaire_59,
  t54.id_dw AS id_dw_60,
  t54.is_publish AS is_publish_61,
  t54.created_at AS created_at_62,
  t54.updated_at AS updated_at_63,
  t54.deleted_at AS deleted_at_64,
  t54.arrete_id AS arrete_id_65,
  t54.titre_id AS titre_id_66,
  t54.operateur_detentaire_id AS operateur_detentaire_id_67,
  t54.operateur_partenaire_id AS operateur_partenaire_id_68,
  t54.contrat_id AS contrat_id_69,
  t54.user_id AS user_id_70,
  t71.id AS id_72,
  t71.date_cession AS date_cession_73,
  t71.operation AS operation_74,
  t71.valeur AS valeur_75,
  t71.type_cession AS type_cession_76,
  t71.annotation AS annotation_77,
  t71.cedant AS cedant_78,
  t71.cessionnaire AS cessionnaire_79,
  t71.id_dw AS id_dw_80,
  t71.is_publish AS is_publish_81,
  t71.date_declaration_cami AS date_declaration_cami_82,
  t71.created_at AS created_at_83,
  t71.updated_at AS updated_at_84,
  t71.deleted_at AS deleted_at_85,
  t71.titre_id AS titre_id_86,
  t71.arrete_id AS arrete_id_87,
  t71.operateur_cedant_id AS operateur_cedant_id_88,
  t71.operateurcessionnaire_id AS operateurcessionnaire_id_89,
  t71.contrat_id AS contrat_id_90,
  t71.user_id AS user_id_91,
  t0.user_id AS user_id_92
FROM
  contrat_principal t0
  LEFT JOIN amodiation t31 ON t31.contrat_id = t0.id
  LEFT JOIN `option` t54 ON t54.contrat_id = t0.id
  LEFT JOIN cession t71 ON t71.contrat_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.pas_de_porte AS pas_de_porte_19, t0.loyer_annuel AS loyer_annuel_20, t0.royalties AS royalties_21, t0.reserves AS reserves_22, t0.ressources AS ressources_23, t0.id_dw AS id_dw_24, t0.is_publish AS is_publish_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.type_document_id AS type_document_id_29, t0.actionnariats_locaux_id AS actionnariats_locaux_id_30, t31.id AS id_32, t31.date_debut AS date_debut_33, t31.date_fin AS date_fin_34, t31.statut AS statut_35, t31.phase AS phase_36, t31.anotation AS anotation_37, t31.amodiant AS amodiant_38, t31.amodiateur AS amodiateur_39, t31.id_dw AS id_dw_40, t31.is_publish AS is_publish_41, t31.type_amodiation AS type_amodiation_42, t31.date_signature_contrat AS date_signature_contrat_43, t31.date_declaration_cami AS date_declaration_cami_44, t31.created_at AS created_at_45, t31.updated_at AS updated_at_46, t31.deleted_at AS deleted_at_47, t31.arrete_id AS arrete_id_48, t31.titre_id AS titre_id_49, t31.operateur_amodiateur_id AS operateur_amodiateur_id_50, t31.operateur_amodiant_id AS operateur_amodiant_id_51, t31.contrat_id AS contrat_id_52, t31.user_id AS user_id_53, t54.id AS id_55, t54.date_option AS date_option_56, t54.annotation AS annotation_57, t54.partenaire AS partenaire_58, t54.detentaire AS detentaire_59, t54.id_dw AS id_dw_60, t54.is_publish AS is_publish_61, t54.created_at AS created_at_62, t54.updated_at AS updated_at_63, t54.deleted_at AS deleted_at_64, t54.arrete_id AS arrete_id_65, t54.titre_id AS titre_id_66, t54.operateur_detentaire_id AS operateur_detentaire_id_67, t54.operateur_partenaire_id AS operateur_partenaire_id_68, t54.contrat_id AS contrat_id_69, t54.user_id AS user_id_70, t71.id AS id_72, t71.date_cession AS date_cession_73, t71.operation AS operation_74, t71.valeur AS valeur_75, t71.type_cession AS type_cession_76, t71.annotation AS annotation_77, t71.cedant AS cedant_78, t71.cessionnaire AS cessionnaire_79, t71.id_dw AS id_dw_80, t71.is_publish AS is_publish_81, t71.date_declaration_cami AS date_declaration_cami_82, t71.created_at AS created_at_83, t71.updated_at AS updated_at_84, t71.deleted_at AS deleted_at_85, t71.titre_id AS titre_id_86, t71.arrete_id AS arrete_id_87, t71.operateur_cedant_id AS operateur_cedant_id_88, t71.operateurcessionnaire_id AS operateurcessionnaire_id_89, t71.contrat_id AS contrat_id_90, t71.user_id AS user_id_91, t0.user_id AS user_id_92 FROM contrat_principal t0 LEFT JOIN amodiation t31 ON t31.contrat_id = t0.id LEFT JOIN `option` t54 ON t54.contrat_id = t0.id LEFT JOIN cession t71 ON t71.contrat_id = t0.id WHERE t0.id = '2';

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

1.35 ms
(30.81%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_contrat t0 INNER JOIN contrat_relatif_type_contrat ON t0.id = contrat_relatif_type_contrat.type_contrat_id WHERE contrat_relatif_type_contrat.contrat_relatif_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.id_dw AS id_dw_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  type_contrat t0
  INNER JOIN contrat_relatif_type_contrat ON t0.id = contrat_relatif_type_contrat.type_contrat_id
WHERE
  contrat_relatif_type_contrat.contrat_relatif_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_contrat t0 INNER JOIN contrat_relatif_type_contrat ON t0.id = contrat_relatif_type_contrat.type_contrat_id WHERE contrat_relatif_type_contrat.contrat_relatif_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 228)
8	__TwigTemplate_5fc8dd448107849d14bf2c20f7a770bc->block_body (line 171)
9	Twig\Template->displayBlock (line 86)
10	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 51)
13	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 49)
16	__TwigTemplate_5fc8dd448107849d14bf2c20f7a770bc->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
25	App\Controller\Transparence\ContratPrincipalController->contratRelatif (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.80 ms
(18.15%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_document t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.id_dw AS id_dw_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  type_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_document t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Transparence\TypeDocument::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Transparence\TypeDocument->__get (line 52)
8	App\Entity\Transparence\TypeDocument->getNom (line 1635)
9	twig_get_attribute (line 243)
10	__TwigTemplate_5fc8dd448107849d14bf2c20f7a770bc->block_body (line 171)
11	Twig\Template->displayBlock (line 86)
12	__TwigTemplate_725b5741f0b67fc58b12bd5e2e9d30fe->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_f5d6cbd903fe872e7e4e3395be2eb55e->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 49)
18	__TwigTemplate_5fc8dd448107849d14bf2c20f7a770bc->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 111)
27	App\Controller\Transparence\ContratPrincipalController->contratRelatif (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.76 ms
(17.24%)

SELECT c0_.id AS id_0, c0_.fichier AS fichier_1, c0_.nom AS nom_2, c0_.langue AS langue_3, c0_.date_signature AS date_signature_4, c0_.url_source AS url_source_5, c0_.mode_divulgation AS mode_divulgation_6, c0_.mode_text_divulgation AS mode_text_divulgation_7, c0_.date_recuperation AS date_recuperation_8, c0_.categorie AS categorie_9, c0_.note AS note_10, c0_.identifiant AS identifiant_11, c0_.page_manquent AS page_manquent_12, c0_.annexe_manquent AS annexe_manquent_13, c0_.statut AS statut_14, c0_.part_etat AS part_etat_15, c0_.dure AS dure_16, c0_.annee_signature AS annee_signature_17, c0_.pas_de_porte AS pas_de_porte_18, c0_.loyer_annuel AS loyer_annuel_19, c0_.royaltie AS royaltie_20, c0_.ressources AS ressources_21, c0_.reserves AS reserves_22, c0_.id_dw AS id_dw_23, c0_.is_publish AS is_publish_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c0_.deleted_at AS deleted_at_27, c0_.type_document_id AS type_document_id_28, c0_.contrat_principal_id AS contrat_principal_id_29, c0_.actionnariats_locaux_id AS actionnariats_locaux_id_30, c0_.user_id AS user_id_31 FROM contrat_relatif c0_ WHERE c0_.contrat_principal_id = ? ORDER BY c0_.id ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.fichier AS fichier_1,
  c0_.nom AS nom_2,
  c0_.langue AS langue_3,
  c0_.date_signature AS date_signature_4,
  c0_.url_source AS url_source_5,
  c0_.mode_divulgation AS mode_divulgation_6,
  c0_.mode_text_divulgation AS mode_text_divulgation_7,
  c0_.date_recuperation AS date_recuperation_8,
  c0_.categorie AS categorie_9,
  c0_.note AS note_10,
  c0_.identifiant AS identifiant_11,
  c0_.page_manquent AS page_manquent_12,
  c0_.annexe_manquent AS annexe_manquent_13,
  c0_.statut AS statut_14,
  c0_.part_etat AS part_etat_15,
  c0_.dure AS dure_16,
  c0_.annee_signature AS annee_signature_17,
  c0_.pas_de_porte AS pas_de_porte_18,
  c0_.loyer_annuel AS loyer_annuel_19,
  c0_.royaltie AS royaltie_20,
  c0_.ressources AS ressources_21,
  c0_.reserves AS reserves_22,
  c0_.id_dw AS id_dw_23,
  c0_.is_publish AS is_publish_24,
  c0_.created_at AS created_at_25,
  c0_.updated_at AS updated_at_26,
  c0_.deleted_at AS deleted_at_27,
  c0_.type_document_id AS type_document_id_28,
  c0_.contrat_principal_id AS contrat_principal_id_29,
  c0_.actionnariats_locaux_id AS actionnariats_locaux_id_30,
  c0_.user_id AS user_id_31
FROM
  contrat_relatif c0_
WHERE
  c0_.contrat_principal_id = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.fichier AS fichier_1, c0_.nom AS nom_2, c0_.langue AS langue_3, c0_.date_signature AS date_signature_4, c0_.url_source AS url_source_5, c0_.mode_divulgation AS mode_divulgation_6, c0_.mode_text_divulgation AS mode_text_divulgation_7, c0_.date_recuperation AS date_recuperation_8, c0_.categorie AS categorie_9, c0_.note AS note_10, c0_.identifiant AS identifiant_11, c0_.page_manquent AS page_manquent_12, c0_.annexe_manquent AS annexe_manquent_13, c0_.statut AS statut_14, c0_.part_etat AS part_etat_15, c0_.dure AS dure_16, c0_.annee_signature AS annee_signature_17, c0_.pas_de_porte AS pas_de_porte_18, c0_.loyer_annuel AS loyer_annuel_19, c0_.royaltie AS royaltie_20, c0_.ressources AS ressources_21, c0_.reserves AS reserves_22, c0_.id_dw AS id_dw_23, c0_.is_publish AS is_publish_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c0_.deleted_at AS deleted_at_27, c0_.type_document_id AS type_document_id_28, c0_.contrat_principal_id AS contrat_principal_id_29, c0_.actionnariats_locaux_id AS actionnariats_locaux_id_30, c0_.user_id AS user_id_31 FROM contrat_relatif c0_ WHERE c0_.contrat_principal_id = 2 ORDER BY c0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 36)
7	App\Repository\Transparence\ContratRelatifRepository->getDocumentByContrat (line 102)
8	App\Controller\Transparence\ContratPrincipalController->contratRelatif (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Transparence\ContratPrincipal	The field App\Entity\Transparence\ContratPrincipal#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\ContratPrincipal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\TypeDocument	The field App\Entity\Transparence\TypeDocument#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\TypeDocument#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Actionnariat\ActionnariatLocal	The field App\Entity\Actionnariat\ActionnariatLocal#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Actionnariat\ActionnariatLocal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Autres\Amodiation	The association App\Entity\Autres\Amodiation#arrete refers to the inverse side field App\Entity\Transparence\Arrete#amodiations which does not exist. The mappings App\Entity\Autres\Amodiation#operateurAmodiant and App\Entity\Transparence\Operateur#amodiations are inconsistent with each other. The association App\Entity\Autres\Amodiation#titres refers to the inverse side field App\Entity\Activite\TitreMinier#lesAmodiations which does not exist. The field App\Entity\Autres\Amodiation#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Autres\Amodiation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Arrete	The field App\Entity\Transparence\Arrete#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\Arrete#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\TitreMinier	The association App\Entity\Activite\TitreMinier#arrete refers to the inverse side field App\Entity\Transparence\Arrete#titreMiniers which does not exist. The field App\Entity\Activite\TitreMinier#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\TitreMinier#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Operateur	No errors.
App\Entity\User	The field App\Entity\User#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\User#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Option	The association App\Entity\Activite\Option#arrete refers to the inverse side field App\Entity\Transparence\Arrete#options which does not exist. The association App\Entity\Activite\Option#titres refers to the inverse side field App\Entity\Activite\TitreMinier#lesAmodiations which does not exist. The field App\Entity\Activite\Option#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\Option#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Cession	The association App\Entity\Activite\Cession#arrete refers to the inverse side field App\Entity\Transparence\Arrete#cessions which does not exist. The mappings App\Entity\Activite\Cession#operateurcessionnaire and App\Entity\Transparence\Operateur#cessions are inconsistent with each other. The association App\Entity\Activite\Cession#titres refers to the inverse side field App\Entity\Activite\TitreMinier#lesAmodiations which does not exist. The field App\Entity\Activite\Cession#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\Cession#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Pays	The field App\Entity\Transparence\Pays#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\Pays#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\ContratRelatif	The field App\Entity\Transparence\ContratRelatif#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\ContratRelatif#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Projet	The field App\Entity\Activite\Projet#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Activite\Projet#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\TypeContrat	The field App\Entity\Transparence\TypeContrat#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\TypeContrat#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\Commodite	The field App\Entity\Transparence\Commodite#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\Commodite#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\EntiteGouvernementale	The field App\Entity\Transparence\EntiteGouvernementale#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\EntiteGouvernementale#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\PartContrat	The field App\Entity\Transparence\PartContrat#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute. If association App\Entity\Transparence\PartContrat#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://www.sakima.ht2techinfo.cd/transparence/contrat/principal/contrat/relatif/2?sp=sp

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping