Query Metrics
630
Database Queries
13
Different statements
161.67 ms
Query time
5
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
98.17 ms (60.72%) |
432 |
SELECT t0.id AS id_1, t0.numero_autorisation AS numero_autorisation_2, t0.date_autorisation AS date_autorisation_3, t0.created_by AS created_by_4, t0.created_at AS created_at_5, t0.updated_by AS updated_by_6, t0.updated_at AS updated_at_7, t0.validation_document AS validation_document_8, t0.statut AS statut_9, t0.motif AS motif_10, t0.code_attribution_id AS code_attribution_id_11, t0.exercice_id AS exercice_id_12 FROM metier.reprise t0 WHERE t0.code_attribution_id = ? LIMIT 1
Parameters:
[
1774
]
|
48.70 ms (30.12%) |
187 |
SELECT t0.id AS id_1, t0.numero_decision AS numero_decision_2, t0.date_decision AS date_decision_3, t0.statut AS statut_4, t0.reprise AS reprise_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.validation_document AS validation_document_8, t0.retire AS retire_9, t0.abandonne AS abandonne_10, t0.motif AS motif_11, t0.date_retrait AS date_retrait_12, t0.date_abandon AS date_abandon_13, t0.code_exploitant_id AS code_exploitant_id_14, t0.code_foret_id AS code_foret_id_15, t0.exercice_id AS exercice_id_16 FROM metier.attribution t0 WHERE t0.code_exploitant_id = ? AND t0.statut = ? AND t0.exercice_id = ?
Parameters:
[ 84 1 7 ] |
6.21 ms (3.84%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.nom_utilisateur AS nom_utilisateur_6, t0.prenoms_utilisateur AS prenoms_utilisateur_7, t0.photo AS photo_8, t0.statut AS statut_9, t0.agent_sodef AS agent_sodef_10, t0.actif AS actif_11, t0.nouveau AS nouveau_12, t0.mobile AS mobile_13, t0.profile_user AS profile_user_14, t0.numero_exploitant AS numero_exploitant_15, t0.log_code AS log_code_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.updated_at AS updated_at_19, t0.updated_by AS updated_by_20, t0.is_responsable AS is_responsable_21, t0.code_sms AS code_sms_22, t0.locale AS locale_23, t0.fonction AS fonction_24, t0.superviseur_groupe AS superviseur_groupe_25, t0.code_groupe_id AS code_groupe_id_26, t0.codeexploitant_id AS codeexploitant_id_27, t0.code_service_id AS code_service_id_28, t0.code_direction_id AS code_direction_id_29, t0.codeindustriel_id AS codeindustriel_id_30, t0.code_dr_id AS code_dr_id_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.code_operateur_id AS code_operateur_id_33, t0.code_ddef_id AS code_ddef_id_34, t0.code_poste_controle_id AS code_poste_controle_id_35, t0.code_exportateur_id AS code_exportateur_id_36, t0.titre_id AS titre_id_37, t0.code_commercant_id AS code_commercant_id_38, t0.code_oi_id AS code_oi_id_39 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
542
]
|
1.73 ms (1.07%) |
1 |
SELECT t0.id AS id_1, t0.numero_exploitant AS numero_exploitant_2, t0.raison_sociale_exploitant AS raison_sociale_exploitant_3, t0.qualite_exploitant AS qualite_exploitant_4, t0.marteau_exploitant AS marteau_exploitant_5, t0.adresse_exploitant AS adresse_exploitant_6, t0.tel_exploitant AS tel_exploitant_7, t0.ncc_exploitant AS ncc_exploitant_8, t0.sigle AS sigle_9, t0.datecreation AS datecreation_10, t0.forme_juridique AS forme_juridique_11, t0.capital AS capital_12, t0.rccim AS rccim_13, t0.situation_geographie AS situation_geographie_14, t0.mobile_exploitant AS mobile_exploitant_15, t0.email_info AS email_info_16, t0.fax AS fax_17, t0.nb_salarie AS nb_salarie_18, t0.ca AS ca_19, t0.gerant AS gerant_20, t0.personne_ressource AS personne_ressource_21, t0.email_personne_ressource AS email_personne_ressource_22, t0.mobile_personne_ressource AS mobile_personne_ressource_23, t0.export AS export_24, t0.code_exportateur AS code_exportateur_25, t0.created_at AS created_at_26, t0.created_by AS created_by_27, t0.updated_by AS updated_by_28, t0.updated_at AS updated_at_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.filiale_id AS filiale_id_33 FROM metier.exploitant t0
Parameters:
[] |
1.26 ms (0.78%) |
1 |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.cloture AS cloture_3, t0.date_expiration_rallonge AS date_expiration_rallonge_4, t0.rallonge AS rallonge_5, t0.nb_mois AS nb_mois_6, t0.date_debut AS date_debut_7, t0.datefin AS datefin_8 FROM admin.exercice t0 WHERE t0.cloture = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
0
]
|
1.20 ms (0.74%) |
1 |
SELECT COUNT(*) FROM metier.usine t0
Parameters:
[] |
0.79 ms (0.49%) |
1 |
SELECT COUNT(*) FROM metier.exportateur t0
Parameters:
[] |
0.78 ms (0.48%) |
1 |
SELECT COUNT(*) FROM metier.cantonnement t0
Parameters:
[] |
0.63 ms (0.39%) |
1 |
SELECT COUNT(*) FROM metier.poste_forestier t0
Parameters:
[] |
0.62 ms (0.38%) |
1 |
SELECT COUNT(*) FROM metier.ddef t0
Parameters:
[] |
0.59 ms (0.37%) |
1 |
SELECT COUNT(*) FROM metier.dr t0
Parameters:
[] |
0.53 ms (0.33%) |
1 |
SELECT COUNT(*) FROM metier.exploitant t0
Parameters:
[] |
0.46 ms (0.29%) |
1 |
SELECT COUNT(*) FROM metier.oi t0
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
alt | doctrine.dbal.alt_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.