Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.55 ms Query time

19 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.55 ms
(100.00%)

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom_original AS nom_original_3, t0.date_arrete AS date_arrete_4, t0.date_inserion AS date_inserion_5, t0.libelle AS libelle_6, t0.numero_ordre AS numero_ordre_7, t0.numero AS numero_8, t0.id_dw AS id_dw_9, t0.is_publish AS is_publish_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.sous_categorie_arrete_id AS sous_categorie_arrete_id_14, t0.type_arrete_id AS type_arrete_id_15, t16.id AS id_17, t16.membre_communaute_local1 AS membre_communaute_local1_18, t16.membre_communaute_local2 AS membre_communaute_local2_19, t16.membre_organisation_communautaire1 AS membre_organisation_communautaire1_20, t16.membre_organisation_communautaire2 AS membre_organisation_communautaire2_21, t16.membre_operateur1 AS membre_operateur1_22, t16.membre_operateur2 AS membre_operateur2_23, t16.membre_autorite1 AS membre_autorite1_24, t16.membre_autorite2 AS membre_autorite2_25, t16.membre_fonds_national1 AS membre_fonds_national1_26, t16.membre_fonds_national2 AS membre_fonds_national2_27, t16.membre_direction1 AS membre_direction1_28, t16.membre_direction2 AS membre_direction2_29, t16.nom AS nom_30, t16.date_creation AS date_creation_31, t16.id_dw AS id_dw_32, t16.created_at AS created_at_33, t16.updated_at AS updated_at_34, t16.deleted_at AS deleted_at_35, t16.operateur_id AS operateur_id_36, t16.arrete_id AS arrete_id_37, t16.user_id AS user_id_38, t39.id AS id_40, t39.membre_communaute_local1 AS membre_communaute_local1_41, t39.membre_communaute_local2 AS membre_communaute_local2_42, t39.membre_organisation_communautaire1 AS membre_organisation_communautaire1_43, t39.membre_organisation_communautaire2 AS membre_organisation_communautaire2_44, t39.membre_operateur1 AS membre_operateur1_45, t39.membre_operateur2 AS membre_operateur2_46, t39.membre_autorite1 AS membre_autorite1_47, t39.membre_autorite2 AS membre_autorite2_48, t39.membre_fonds_national1 AS membre_fonds_national1_49, t39.membre_fonds_national2 AS membre_fonds_national2_50, t39.membre_direction1 AS membre_direction1_51, t39.membre_direction2 AS membre_direction2_52, t39.date_nomination AS date_nomination_53, t39.id_dw AS id_dw_54, t39.is_publish AS is_publish_55, t39.created_at AS created_at_56, t39.updated_at AS updated_at_57, t39.deleted_at AS deleted_at_58, t39.dot_id AS dot_id_59, t39.arrete_id AS arrete_id_60, t39.user_id AS user_id_61, t0.user_id AS user_id_62 FROM arrete t0 LEFT JOIN dot t16 ON t16.arrete_id = t0.id LEFT JOIN comite_pilotage_dot t39 ON t39.arrete_id = t0.id WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fichier AS fichier_2,
  t0.nom_original AS nom_original_3,
  t0.date_arrete AS date_arrete_4,
  t0.date_inserion AS date_inserion_5,
  t0.libelle AS libelle_6,
  t0.numero_ordre AS numero_ordre_7,
  t0.numero AS numero_8,
  t0.id_dw AS id_dw_9,
  t0.is_publish AS is_publish_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.sous_categorie_arrete_id AS sous_categorie_arrete_id_14,
  t0.type_arrete_id AS type_arrete_id_15,
  t16.id AS id_17,
  t16.membre_communaute_local1 AS membre_communaute_local1_18,
  t16.membre_communaute_local2 AS membre_communaute_local2_19,
  t16.membre_organisation_communautaire1 AS membre_organisation_communautaire1_20,
  t16.membre_organisation_communautaire2 AS membre_organisation_communautaire2_21,
  t16.membre_operateur1 AS membre_operateur1_22,
  t16.membre_operateur2 AS membre_operateur2_23,
  t16.membre_autorite1 AS membre_autorite1_24,
  t16.membre_autorite2 AS membre_autorite2_25,
  t16.membre_fonds_national1 AS membre_fonds_national1_26,
  t16.membre_fonds_national2 AS membre_fonds_national2_27,
  t16.membre_direction1 AS membre_direction1_28,
  t16.membre_direction2 AS membre_direction2_29,
  t16.nom AS nom_30,
  t16.date_creation AS date_creation_31,
  t16.id_dw AS id_dw_32,
  t16.created_at AS created_at_33,
  t16.updated_at AS updated_at_34,
  t16.deleted_at AS deleted_at_35,
  t16.operateur_id AS operateur_id_36,
  t16.arrete_id AS arrete_id_37,
  t16.user_id AS user_id_38,
  t39.id AS id_40,
  t39.membre_communaute_local1 AS membre_communaute_local1_41,
  t39.membre_communaute_local2 AS membre_communaute_local2_42,
  t39.membre_organisation_communautaire1 AS membre_organisation_communautaire1_43,
  t39.membre_organisation_communautaire2 AS membre_organisation_communautaire2_44,
  t39.membre_operateur1 AS membre_operateur1_45,
  t39.membre_operateur2 AS membre_operateur2_46,
  t39.membre_autorite1 AS membre_autorite1_47,
  t39.membre_autorite2 AS membre_autorite2_48,
  t39.membre_fonds_national1 AS membre_fonds_national1_49,
  t39.membre_fonds_national2 AS membre_fonds_national2_50,
  t39.membre_direction1 AS membre_direction1_51,
  t39.membre_direction2 AS membre_direction2_52,
  t39.date_nomination AS date_nomination_53,
  t39.id_dw AS id_dw_54,
  t39.is_publish AS is_publish_55,
  t39.created_at AS created_at_56,
  t39.updated_at AS updated_at_57,
  t39.deleted_at AS deleted_at_58,
  t39.dot_id AS dot_id_59,
  t39.arrete_id AS arrete_id_60,
  t39.user_id AS user_id_61,
  t0.user_id AS user_id_62
FROM
  arrete t0
  LEFT JOIN dot t16 ON t16.arrete_id = t0.id
  LEFT JOIN comite_pilotage_dot t39 ON t39.arrete_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom_original AS nom_original_3, t0.date_arrete AS date_arrete_4, t0.date_inserion AS date_inserion_5, t0.libelle AS libelle_6, t0.numero_ordre AS numero_ordre_7, t0.numero AS numero_8, t0.id_dw AS id_dw_9, t0.is_publish AS is_publish_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.sous_categorie_arrete_id AS sous_categorie_arrete_id_14, t0.type_arrete_id AS type_arrete_id_15, t16.id AS id_17, t16.membre_communaute_local1 AS membre_communaute_local1_18, t16.membre_communaute_local2 AS membre_communaute_local2_19, t16.membre_organisation_communautaire1 AS membre_organisation_communautaire1_20, t16.membre_organisation_communautaire2 AS membre_organisation_communautaire2_21, t16.membre_operateur1 AS membre_operateur1_22, t16.membre_operateur2 AS membre_operateur2_23, t16.membre_autorite1 AS membre_autorite1_24, t16.membre_autorite2 AS membre_autorite2_25, t16.membre_fonds_national1 AS membre_fonds_national1_26, t16.membre_fonds_national2 AS membre_fonds_national2_27, t16.membre_direction1 AS membre_direction1_28, t16.membre_direction2 AS membre_direction2_29, t16.nom AS nom_30, t16.date_creation AS date_creation_31, t16.id_dw AS id_dw_32, t16.created_at AS created_at_33, t16.updated_at AS updated_at_34, t16.deleted_at AS deleted_at_35, t16.operateur_id AS operateur_id_36, t16.arrete_id AS arrete_id_37, t16.user_id AS user_id_38, t39.id AS id_40, t39.membre_communaute_local1 AS membre_communaute_local1_41, t39.membre_communaute_local2 AS membre_communaute_local2_42, t39.membre_organisation_communautaire1 AS membre_organisation_communautaire1_43, t39.membre_organisation_communautaire2 AS membre_organisation_communautaire2_44, t39.membre_operateur1 AS membre_operateur1_45, t39.membre_operateur2 AS membre_operateur2_46, t39.membre_autorite1 AS membre_autorite1_47, t39.membre_autorite2 AS membre_autorite2_48, t39.membre_fonds_national1 AS membre_fonds_national1_49, t39.membre_fonds_national2 AS membre_fonds_national2_50, t39.membre_direction1 AS membre_direction1_51, t39.membre_direction2 AS membre_direction2_52, t39.date_nomination AS date_nomination_53, t39.id_dw AS id_dw_54, t39.is_publish AS is_publish_55, t39.created_at AS created_at_56, t39.updated_at AS updated_at_57, t39.deleted_at AS deleted_at_58, t39.dot_id AS dot_id_59, t39.arrete_id AS arrete_id_60, t39.user_id AS user_id_61, t0.user_id AS user_id_62 FROM arrete t0 LEFT JOIN dot t16 ON t16.arrete_id = t0.id LEFT JOIN comite_pilotage_dot t39 ON t39.arrete_id = t0.id WHERE t0.id = '1';

#	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)

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\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\Transparence\SousCategorieArrete	The field App\Entity\Transparence\SousCategorieArrete#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\SousCategorieArrete#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\TypeArrete	The field App\Entity\Transparence\TypeArrete#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\TypeArrete#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Dot	The field App\Entity\Operateur\Dot#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\Operateur\Dot#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Operateur	The association App\Entity\Operateur\Operateur#commodites refers to the inverse side field App\Entity\Transparence\Commodite#operateurs which does not exist. The association App\Entity\Operateur\Operateur#province refers to the inverse side field App\Entity\Transparence\Province#operateurs which does not exist. The field App\Entity\Operateur\Operateur#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\Operateur\Operateur#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\Operateur\ComitePilotageDot	The field App\Entity\Operateur\ComitePilotageDot#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\Operateur\ComitePilotageDot#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\ProjetDot	The association App\Entity\Operateur\ProjetDot#nature refers to the inverse side field App\Entity\Obligation\NatureProjet#projetDots which does not exist. The field App\Entity\Operateur\ProjetDot#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\Operateur\ProjetDot#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Transparence\CategorieArrete	The field App\Entity\Transparence\CategorieArrete#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\CategorieArrete#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Obligation\InformationFinanciere	The field App\Entity\Obligation\InformationFinanciere#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\Obligation\InformationFinanciere#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Categorie	The field App\Entity\Operateur\Categorie#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\Operateur\Categorie#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\FormeJuridique	The field App\Entity\Operateur\FormeJuridique#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\Operateur\FormeJuridique#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Ville	The association App\Entity\Operateur\Ville#province refers to the inverse side field App\Entity\Transparence\Province#villes which does not exist. The field App\Entity\Operateur\Ville#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\Operateur\Ville#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\Operateur\SiegeExploitation	The field App\Entity\Operateur\SiegeExploitation#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\Operateur\SiegeExploitation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\SousSecteur	The field App\Entity\Operateur\SousSecteur#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\Operateur\SousSecteur#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\Obligation\NatureProjet	The field App\Entity\Obligation\NatureProjet#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\Obligation\NatureProjet#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Operateur\Image	The field App\Entity\Operateur\Image#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\Operateur\Image#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.

Symfony Profiler

GET https://kcc.ht2techinfo.cd/transparence/arrete/download/1/arrete

Configuration Settings

Theme