Symfony Profiler

Query Metrics

34 Database Queries

7 Different statements

8.88 ms Query time

23 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.59 ms
(29.13%)

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.royaltie AS royaltie_21, t0.ressources AS ressources_22, t0.reserves AS reserves_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.contrat_principal_id AS contrat_principal_id_30, t0.actionnariats_locaux_id AS actionnariats_locaux_id_31, t0.user_id AS user_id_32 FROM contrat_relatif t0 WHERE t0.contrat_principal_id = ?

Parameters:

[
  14
]

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.royaltie AS royaltie_21,
  t0.ressources AS ressources_22,
  t0.reserves AS reserves_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.contrat_principal_id AS contrat_principal_id_30,
  t0.actionnariats_locaux_id AS actionnariats_locaux_id_31,
  t0.user_id AS user_id_32
FROM
  contrat_relatif t0
WHERE
  t0.contrat_principal_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.royaltie AS royaltie_21, t0.ressources AS ressources_22, t0.reserves AS reserves_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.contrat_principal_id AS contrat_principal_id_30, t0.actionnariats_locaux_id AS actionnariats_locaux_id_31, t0.user_id AS user_id_32 FROM contrat_relatif t0 WHERE t0.contrat_principal_id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3224)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 311)
10	__TwigTemplate_10b55968e5312c2fe6ee1a952b59c874->block_body (line 171)
11	Twig\Template->displayBlock (line 76)
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_10b55968e5312c2fe6ee1a952b59c874->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 66)
27	App\Controller\Transparence\ContratPrincipalController->index (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)

2.26 ms
(25.44%)

SELECT t0.id AS id_1, t0.permis AS permis_2, t0.titulaire AS titulaire_3, t0.type_permis AS type_permis_4, t0.status AS status_5, t0.date_octroi AS date_octroi_6, t0.date_expiration AS date_expiration_7, t0.carres AS carres_8, t0.localisation AS localisation_9, t0.code AS code_10, t0.libelle AS libelle_11, t0.id_dw AS id_dw_12, t0.is_publish AS is_publish_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.province_id AS province_id_17, t0.arrete_id AS arrete_id_18, t0.projet_id AS projet_id_19, t0.user_id AS user_id_20 FROM titre_minier t0 INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id WHERE contrat_principal_titre_minier.contrat_principal_id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.permis AS permis_2,
  t0.titulaire AS titulaire_3,
  t0.type_permis AS type_permis_4,
  t0.status AS status_5,
  t0.date_octroi AS date_octroi_6,
  t0.date_expiration AS date_expiration_7,
  t0.carres AS carres_8,
  t0.localisation AS localisation_9,
  t0.code AS code_10,
  t0.libelle AS libelle_11,
  t0.id_dw AS id_dw_12,
  t0.is_publish AS is_publish_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.province_id AS province_id_17,
  t0.arrete_id AS arrete_id_18,
  t0.projet_id AS projet_id_19,
  t0.user_id AS user_id_20
FROM
  titre_minier t0
  INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id
WHERE
  contrat_principal_titre_minier.contrat_principal_id = ?

SELECT t0.id AS id_1, t0.permis AS permis_2, t0.titulaire AS titulaire_3, t0.type_permis AS type_permis_4, t0.status AS status_5, t0.date_octroi AS date_octroi_6, t0.date_expiration AS date_expiration_7, t0.carres AS carres_8, t0.localisation AS localisation_9, t0.code AS code_10, t0.libelle AS libelle_11, t0.id_dw AS id_dw_12, t0.is_publish AS is_publish_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.province_id AS province_id_17, t0.arrete_id AS arrete_id_18, t0.projet_id AS projet_id_19, t0.user_id AS user_id_20 FROM titre_minier t0 INNER JOIN contrat_principal_titre_minier ON t0.id = contrat_principal_titre_minier.titre_minier_id WHERE contrat_principal_titre_minier.contrat_principal_id = 14;

#	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 291)
8	__TwigTemplate_10b55968e5312c2fe6ee1a952b59c874->block_body (line 171)
9	Twig\Template->displayBlock (line 76)
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_10b55968e5312c2fe6ee1a952b59c874->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 66)
25	App\Controller\Transparence\ContratPrincipalController->index (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)

2.20 ms
(24.74%)

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_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id WHERE contrat_principal_type_contrat.contrat_principal_id = ?

Parameters:

[
  14
]

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_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id
WHERE
  contrat_principal_type_contrat.contrat_principal_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_principal_type_contrat ON t0.id = contrat_principal_type_contrat.type_contrat_id WHERE contrat_principal_type_contrat.contrat_principal_id = 14;

#	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 271)
8	__TwigTemplate_10b55968e5312c2fe6ee1a952b59c874->block_body (line 171)
9	Twig\Template->displayBlock (line 76)
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_10b55968e5312c2fe6ee1a952b59c874->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 66)
25	App\Controller\Transparence\ContratPrincipalController->index (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)

1.04 ms
(11.74%)

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_.royalties AS royalties_20, c0_.reserves AS reserves_21, c0_.ressources AS ressources_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_.actionnariats_locaux_id AS actionnariats_locaux_id_29, c0_.user_id AS user_id_30 FROM contrat_principal c0_ WHERE c0_.is_publish = 1 ORDER BY c0_.id ASC

Parameters:

[]

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_.royalties AS royalties_20,
  c0_.reserves AS reserves_21,
  c0_.ressources AS ressources_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_.actionnariats_locaux_id AS actionnariats_locaux_id_29,
  c0_.user_id AS user_id_30
FROM
  contrat_principal c0_
WHERE
  c0_.is_publish = 1
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_.royalties AS royalties_20, c0_.reserves AS reserves_21, c0_.ressources AS ressources_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_.actionnariats_locaux_id AS actionnariats_locaux_id_29, c0_.user_id AS user_id_30 FROM contrat_principal c0_ WHERE c0_.is_publish = 1 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 184)
7	App\Repository\Transparence\ContratPrincipalRepository->getContrats (line 51)
8	App\Controller\Transparence\ContratPrincipalController->index (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)

0.37 ms
(4.14%)

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.is_publish = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_principal c0_
WHERE
  c0_.is_publish = 1

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.is_publish = 1;

#	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 26)
7	App\Repository\Transparence\ContratPrincipalRepository->getTotal (line 56)
8	App\Controller\Transparence\ContratPrincipalController->index (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)

0.23 ms
(2.53%)

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_relatif c0_

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_;

#	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 25)
7	App\Repository\Transparence\ContratRelatifRepository->getTotal (line 57)
8	App\Controller\Transparence\ContratPrincipalController->index (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)

0.20 ms
(2.26%)

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:

[
  5
]

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 = 5;

#	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 346)
8	__TwigTemplate_10b55968e5312c2fe6ee1a952b59c874->block_body (line 171)
9	Twig\Template->displayBlock (line 76)
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_10b55968e5312c2fe6ee1a952b59c874->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 66)
25	App\Controller\Transparence\ContratPrincipalController->index (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)

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\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\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\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\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.
App\Entity\Transparence\Province	The field App\Entity\Transparence\Province#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\Province#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\Impact\Environemental	The field App\Entity\Impact\Environemental#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\Impact\Environemental#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 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\Activite\Transformation	The field App\Entity\Activite\Transformation#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\Transformation#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 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\Activite\Transfert	The field App\Entity\Activite\Transfert#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\Transfert#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 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\Ressource	The field App\Entity\Activite\Ressource#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\Ressource#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Activite\Reserve	The field App\Entity\Activite\Reserve#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\Reserve#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Autres\Gisement	The field App\Entity\Autres\Gisement#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\Gisement#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://www.sokimo.ht2techinfo.cd/transparence/contrat/principal/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping