GET https://www.sokimo.ht2techinfo.cd/transparence/contrat/principal/details/18/page-reset-password.html

Query Metrics

8 Database Queries
8 Different statements
4.24 ms Query time
25 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.90 ms
(21.32%)
1
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:
[
  "18"
]
0.75 ms
(17.80%)
1
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:
[
  18
]
0.61 ms
(14.45%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.unite AS unite_4, t0.symbole_chimique AS symbole_chimique_5, t0.max AS max_6, t0.maxim AS maxim_7, t0.amount AS amount_8, t0.min_annuel AS min_annuel_9, t0.max_annuel AS max_annuel_10, t0.amout_annuel AS amout_annuel_11, t0.max_semestre AS max_semestre_12, t0.amount_semestre AS amount_semestre_13, t0.min_trimestre AS min_trimestre_14, t0.max_trimestre AS max_trimestre_15, t0.amount_trimestre AS amount_trimestre_16, t0.min_semetre AS min_semetre_17, t0.id_dw AS id_dw_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.user_id AS user_id_22 FROM commodite t0 INNER JOIN commodite_contrat_principal ON t0.id = commodite_contrat_principal.commodite_id WHERE commodite_contrat_principal.contrat_principal_id = ?
Parameters:
[
  18
]
0.51 ms
(12.07%)
1
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:
[
  18
]
0.46 ms
(10.94%)
1
SELECT t0.id AS id_1, t0.part_capital AS part_capital_2, t0.date_acquisition AS date_acquisition_3, t0.type_acquisition AS type_acquisition_4, t0.proprietaire AS proprietaire_5, t0.id_dw AS id_dw_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.actionnaire_id AS actionnaire_id_10, t0.investisseur_id AS investisseur_id_11, t0.contrat_principal_id AS contrat_principal_id_12, t0.contrat_relatif_id AS contrat_relatif_id_13, t0.user_id AS user_id_14 FROM part_contrat t0 WHERE t0.contrat_principal_id = ?
Parameters:
[
  18
]
0.44 ms
(10.26%)
1
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:
[
  18
]
0.29 ms
(6.89%)
1
SELECT t0.id AS id_1, t0.action AS action_2, t0.date_acquisition AS date_acquisition_3, t0.id_dw AS id_dw_4, t0.is_publish AS is_publish_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.actionnaire_id AS actionnaire_id_9, t0.contrat_relatif_id AS contrat_relatif_id_10, t0.contrat_principal_id AS contrat_principal_id_11, t0.user_id AS user_id_12 FROM actionnariat_local t0 WHERE t0.contrat_principal_id = ?
Parameters:
[
  18
]
0.27 ms
(6.27%)
1
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:
[
  2
]

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.
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\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\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\Transfert
  • The mappings App\Entity\Activite\Transfert#ancienOperateur and App\Entity\Transparence\Operateur#transferts are inconsistent with each other.
  • 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\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.
App\Entity\Actionnariat\Actionnaire
  • The field App\Entity\Actionnariat\Actionnaire#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\Actionnaire#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Actionnariat\Investisseur
  • The field App\Entity\Actionnariat\Investisseur#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\Investisseur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.