Query Metrics
8
Database Queries
8
Different statements
4.64 ms
Query time
19
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.66 ms (35.84%) |
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:
[
"33"
]
|
|
0.79 ms (17.09%) |
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:
[
33
]
|
|
0.44 ms (9.39%) |
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:
[
33
]
|
|
0.40 ms (8.66%) |
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:
[
33
]
|
|
0.40 ms (8.62%) |
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:
[
33
]
|
|
0.40 ms (8.53%) |
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:
[
33
]
|
|
0.29 ms (6.19%) |
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:
[
33
]
|
|
0.26 ms (5.69%) |
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 |
|
| App\Entity\Transparence\TypeDocument |
|
| App\Entity\Actionnariat\ActionnariatLocal |
|
| App\Entity\Autres\Amodiation |
|
| App\Entity\Transparence\Arrete |
|
| App\Entity\Activite\TitreMinier |
|
| App\Entity\Transparence\Operateur | No errors. |
| App\Entity\User |
|
| App\Entity\Activite\Option |
|
| App\Entity\Activite\Cession |
|
| App\Entity\Transparence\Pays |
|
| App\Entity\Transparence\ContratRelatif |
|
| App\Entity\Activite\Projet |
|
| App\Entity\Transparence\TypeContrat |
|
| App\Entity\Transparence\Commodite |
|
| App\Entity\Transparence\EntiteGouvernementale |
|
| App\Entity\Transparence\PartContrat |
|
| App\Entity\Transparence\Province |
|
| App\Entity\Actionnariat\Actionnaire |
|
| App\Entity\Actionnariat\Investisseur |
|