Query Metrics
9
Database Queries
9
Different statements
10.53 ms
Query time
4
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.85 ms |
SELECT t0.id AS id_1, t0.libelle_operateur AS libelle_operateur_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.updated_at AS updated_at_6 FROM metier.type_operateur t0 ORDER BY t0.libelle_operateur ASC
Parameters:
[] |
| 2 | 1.42 ms |
SELECT e0_.id AS id_0, e0_.numero_exploitant AS numero_exploitant_1, e0_.raison_sociale_exploitant AS raison_sociale_exploitant_2, e0_.qualite_exploitant AS qualite_exploitant_3, e0_.marteau_exploitant AS marteau_exploitant_4, e0_.adresse_exploitant AS adresse_exploitant_5, e0_.tel_exploitant AS tel_exploitant_6, e0_.ncc_exploitant AS ncc_exploitant_7, e0_.sigle AS sigle_8, e0_.datecreation AS datecreation_9, e0_.forme_juridique AS forme_juridique_10, e0_.capital AS capital_11, e0_.rccim AS rccim_12, e0_.situation_geographie AS situation_geographie_13, e0_.mobile_exploitant AS mobile_exploitant_14, e0_.email_info AS email_info_15, e0_.fax AS fax_16, e0_.nb_salarie AS nb_salarie_17, e0_.ca AS ca_18, e0_.gerant AS gerant_19, e0_.personne_ressource AS personne_ressource_20, e0_.email_personne_ressource AS email_personne_ressource_21, e0_.mobile_personne_ressource AS mobile_personne_ressource_22, e0_.export AS export_23, e0_.code_exportateur AS code_exportateur_24, e0_.created_at AS created_at_25, e0_.created_by AS created_by_26, e0_.updated_by AS updated_by_27, e0_.updated_at AS updated_at_28, e0_.latitude AS latitude_29, e0_.longitude AS longitude_30, e0_.code_cantonnement_id AS code_cantonnement_id_31, e0_.filiale_id AS filiale_id_32 FROM metier.exploitant e0_ WHERE e0_.email_personne_ressource IS NOT NULL ORDER BY e0_.raison_sociale_exploitant ASC
Parameters:
[] |
| 3 | 1.64 ms |
SELECT u0_.id AS id_0, u0_.numero_usine AS numero_usine_1, u0_.raison_sociale_usine AS raison_sociale_usine_2, u0_.personne_ressource AS personne_ressource_3, u0_.cc_usine AS cc_usine_4, u0_.tel_usine AS tel_usine_5, u0_.fax_usine AS fax_usine_6, u0_.adresse_usine AS adresse_usine_7, u0_.localisation_usine AS localisation_usine_8, u0_.ville AS ville_9, u0_.capacite_usine AS capacite_usine_10, u0_.sigle AS sigle_11, u0_.email_personne_ressource AS email_personne_ressource_12, u0_.mobile_personne_ressource AS mobile_personne_ressource_13, u0_.export AS export_14, u0_.code_exportateur AS code_exportateur_15, u0_.created_at AS created_at_16, u0_.created_by AS created_by_17, u0_.updated_by AS updated_by_18, u0_.updated_at AS updated_at_19, u0_.agree AS agree_20, u0_.latitude AS latitude_21, u0_.longitude AS longitude_22, u0_.code_cantonnement_id AS code_cantonnement_id_23, u0_.code_exploitant_id AS code_exploitant_id_24 FROM metier.usine u0_ WHERE u0_.email_personne_ressource IS NOT NULL ORDER BY u0_.raison_sociale_usine ASC
Parameters:
[] |
| 4 | 1.22 ms |
SELECT e0_.id AS id_0, e0_.code_exportateur AS code_exportateur_1, e0_.raison_sociale_exportateur AS raison_sociale_exportateur_2, e0_.adresse_exportateur AS adresse_exportateur_3, e0_.tel_exportateur AS tel_exportateur_4, e0_.email_exportateur AS email_exportateur_5, e0_.date_creation AS date_creation_6, e0_.personne_ressource AS personne_ressource_7, e0_.email_personne_ressource AS email_personne_ressource_8, e0_.mobile_personne_ressource AS mobile_personne_ressource_9, e0_.created_at AS created_at_10, e0_.created_by AS created_by_11, e0_.updated_at AS updated_at_12, e0_.updated_by AS updated_by_13, e0_.sigle AS sigle_14, e0_.statut AS statut_15, e0_.code_cantonnement_id AS code_cantonnement_id_16 FROM metier.exportateur e0_ WHERE e0_.email_personne_ressource IS NOT NULL ORDER BY e0_.raison_sociale_exportateur ASC
Parameters:
[] |
| 5 | 0.84 ms |
SELECT d0_.id AS id_0, d0_.denomination AS denomination_1, d0_.email_responsable AS email_responsable_2, d0_.created_at AS created_at_3, d0_.created_by AS created_by_4, d0_.updated_by AS updated_by_5, d0_.updated_at AS updated_at_6, d0_.personne_ressource AS personne_ressource_7, d0_.email_personne_ressource AS email_personne_ressource_8, d0_.mobile_personne_ressource AS mobile_personne_ressource_9 FROM metier.dr d0_ WHERE d0_.email_personne_ressource IS NOT NULL ORDER BY d0_.denomination ASC
Parameters:
[] |
| 6 | 1.20 ms |
SELECT c0_.id AS id_0, c0_.nom_cantonnement AS nom_cantonnement_1, c0_.email_responsable AS email_responsable_2, c0_.created_at AS created_at_3, c0_.created_by AS created_by_4, c0_.updated_by AS updated_by_5, c0_.updated_at AS updated_at_6, c0_.personne_ressource AS personne_ressource_7, c0_.email_personne_ressource AS email_personne_ressource_8, c0_.mobile_personne_ressource AS mobile_personne_ressource_9, c0_.code_dr_id AS code_dr_id_10, c0_.code_ddef_id AS code_ddef_id_11 FROM metier.cantonnement c0_ WHERE c0_.email_personne_ressource IS NOT NULL ORDER BY c0_.nom_cantonnement ASC
Parameters:
[] |
| 7 | 1.03 ms |
SELECT d0_.id AS id_0, d0_.nom_ddef AS nom_ddef_1, d0_.email_responsable AS email_responsable_2, d0_.created_at AS created_at_3, d0_.created_by AS created_by_4, d0_.updated_by AS updated_by_5, d0_.updated_at AS updated_at_6, d0_.personne_ressource AS personne_ressource_7, d0_.email_personne_ressource AS email_personne_ressource_8, d0_.mobile_personne_ressource AS mobile_personne_ressource_9, d0_.code_dr_id AS code_dr_id_10 FROM metier.ddef d0_ WHERE d0_.email_personne_ressource IS NOT NULL ORDER BY d0_.nom_ddef ASC
Parameters:
[] |
| 8 | 0.78 ms |
SELECT p0_.id AS id_0, p0_.denomination AS denomination_1, p0_.email_responsable AS email_responsable_2, p0_.situation_geographique AS situation_geographique_3, p0_.created_at AS created_at_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.updated_at AS updated_at_7, p0_.personne_ressource AS personne_ressource_8, p0_.email_personne_ressource AS email_personne_ressource_9, p0_.mobile_personne_ressource AS mobile_personne_ressource_10, p0_.code_cantonnement_id AS code_cantonnement_id_11 FROM metier.poste_forestier p0_ WHERE p0_.email_personne_ressource IS NOT NULL ORDER BY p0_.denomination ASC
Parameters:
[] |
| 9 | 0.54 ms |
SELECT d0_.id AS id_0, d0_.denomination AS denomination_1, d0_.sigle AS sigle_2, d0_.email_responsable AS email_responsable_3, d0_.created_at AS created_at_4, d0_.created_by AS created_by_5, d0_.updated_by AS updated_by_6, d0_.updated_at AS updated_at_7, d0_.personne_ressource AS personne_ressource_8, d0_.email_personne_ressource AS email_personne_ressource_9, d0_.mobile_personne_ressource AS mobile_personne_ressource_10 FROM metier.direction d0_ WHERE d0_.email_personne_ressource IS NOT NULL ORDER BY d0_.sigle ASC
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.