GET https://www.dot.cd/transparence/arrete

Query Metrics

5 Database Queries
5 Different statements
1.75 ms Query time
9 Invalid entities

Queries

Group similar statements

# Time Info
1 0.63 ms
SELECT a0_.id AS id_0, a0_.fichier AS fichier_1, a0_.nom_original AS nom_original_2, a0_.date_arrete AS date_arrete_3, a0_.date_inserion AS date_inserion_4, a0_.libelle AS libelle_5, a0_.numero_ordre AS numero_ordre_6, a0_.numero AS numero_7, a0_.id_dw AS id_dw_8, a0_.is_publish AS is_publish_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12, a0_.sous_categorie_arrete_id AS sous_categorie_arrete_id_13, a0_.type_arrete_id AS type_arrete_id_14, a0_.user_id AS user_id_15 FROM arrete a0_ WHERE a0_.is_publish = 1
Parameters:
[]
2 0.33 ms
SELECT t0.id AS id_1, t0.membre_communaute_local1 AS membre_communaute_local1_2, t0.membre_communaute_local2 AS membre_communaute_local2_3, t0.membre_organisation_communautaire1 AS membre_organisation_communautaire1_4, t0.membre_organisation_communautaire2 AS membre_organisation_communautaire2_5, t0.membre_operateur1 AS membre_operateur1_6, t0.membre_operateur2 AS membre_operateur2_7, t0.membre_autorite1 AS membre_autorite1_8, t0.membre_autorite2 AS membre_autorite2_9, t0.membre_fonds_national1 AS membre_fonds_national1_10, t0.membre_fonds_national2 AS membre_fonds_national2_11, t0.membre_direction1 AS membre_direction1_12, t0.membre_direction2 AS membre_direction2_13, t0.nom AS nom_14, t0.date_creation AS date_creation_15, t0.id_dw AS id_dw_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.operateur_id AS operateur_id_20, t0.arrete_id AS arrete_id_21, t0.user_id AS user_id_22 FROM dot t0 WHERE t0.arrete_id = ?
Parameters:
[
  1
]
3 0.29 ms
SELECT t0.id AS id_1, t0.membre_communaute_local1 AS membre_communaute_local1_2, t0.membre_communaute_local2 AS membre_communaute_local2_3, t0.membre_organisation_communautaire1 AS membre_organisation_communautaire1_4, t0.membre_organisation_communautaire2 AS membre_organisation_communautaire2_5, t0.membre_operateur1 AS membre_operateur1_6, t0.membre_operateur2 AS membre_operateur2_7, t0.membre_autorite1 AS membre_autorite1_8, t0.membre_autorite2 AS membre_autorite2_9, t0.membre_fonds_national1 AS membre_fonds_national1_10, t0.membre_fonds_national2 AS membre_fonds_national2_11, t0.membre_direction1 AS membre_direction1_12, t0.membre_direction2 AS membre_direction2_13, t0.date_nomination AS date_nomination_14, t0.id_dw AS id_dw_15, t0.is_publish AS is_publish_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.dot_id AS dot_id_20, t0.arrete_id AS arrete_id_21, t0.user_id AS user_id_22 FROM comite_pilotage_dot t0 WHERE t0.arrete_id = ?
Parameters:
[
  1
]
4 0.21 ms
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_arrete t0
Parameters:
[]
5 0.29 ms
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.categorie_id AS categorie_id_7, t0.user_id AS user_id_8 FROM sous_categorie_arrete t0 WHERE t0.id = ?
Parameters:
[
  8
]

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\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\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\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\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\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.