Query Metrics
13
Database Queries
13
Different statements
15.62 ms
Query time
3
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.85 ms |
SELECT t0.id AS id_1, t0.nom_groupe AS nom_groupe_2, t0.groupe_system AS groupe_system_3, t0.parent_groupe AS parent_groupe_4, t0.code_type_operateur AS code_type_operateur_5, t0.code_operateur AS code_operateur_6, t0.craeted_at AS craeted_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.en_relation_avec_id AS en_relation_avec_id_11 FROM metier.groupe t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 2.02 ms |
SELECT t0.id AS id_1, t0.numero_usine AS numero_usine_2, t0.raison_sociale_usine AS raison_sociale_usine_3, t0.personne_ressource AS personne_ressource_4, t0.cc_usine AS cc_usine_5, t0.tel_usine AS tel_usine_6, t0.fax_usine AS fax_usine_7, t0.adresse_usine AS adresse_usine_8, t0.localisation_usine AS localisation_usine_9, t0.ville AS ville_10, t0.capacite_usine AS capacite_usine_11, t0.sigle AS sigle_12, t0.email_personne_ressource AS email_personne_ressource_13, t0.mobile_personne_ressource AS mobile_personne_ressource_14, t0.export AS export_15, t0.code_exportateur AS code_exportateur_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.updated_at AS updated_at_20, t0.agree AS agree_21, t0.latitude AS latitude_22, t0.longitude AS longitude_23, t0.code_cantonnement_id AS code_cantonnement_id_24, t0.code_exploitant_id AS code_exploitant_id_25 FROM metier.usine t0 WHERE t0.id = ?
Parameters:
[
406
]
|
| 3 | 2.48 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_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_transformation t0 INNER JOIN usine_type_transformation ON t0.id = usine_type_transformation.type_transformation_id WHERE usine_type_transformation.usine_id = ?
Parameters:
[
406
]
|
| 4 | 1.45 ms |
SELECT t0.id AS id_1, t0.nom_cantonnement AS nom_cantonnement_2, t0.email_responsable AS email_responsable_3, t0.created_at AS created_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.updated_at AS updated_at_7, t0.personne_ressource AS personne_ressource_8, t0.email_personne_ressource AS email_personne_ressource_9, t0.mobile_personne_ressource AS mobile_personne_ressource_10, t0.code_dr_id AS code_dr_id_11, t0.code_ddef_id AS code_ddef_id_12 FROM metier.cantonnement t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 5 | 1.46 ms |
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 WHERE t0.id = ?
Parameters:
[
178
]
|
| 6 | 0.24 ms |
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.created_at AS created_at_2, t0_.created_by AS created_by_3, t0_.updated_by AS updated_by_4, t0_.updated_at AS updated_at_5 FROM metier.type_transformation t0_
Parameters:
[] |
| 7 | 0.60 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_ ORDER BY c0_.nom_cantonnement ASC
Parameters:
[] |
| 8 | 0.90 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_ ORDER BY e0_.raison_sociale_exploitant ASC
Parameters:
[] |
| 9 | 0.49 ms |
SELECT t0.id AS id_1, t0.numero_usine AS numero_usine_2, t0.raison_sociale_usine AS raison_sociale_usine_3, t0.personne_ressource AS personne_ressource_4, t0.cc_usine AS cc_usine_5, t0.tel_usine AS tel_usine_6, t0.fax_usine AS fax_usine_7, t0.adresse_usine AS adresse_usine_8, t0.localisation_usine AS localisation_usine_9, t0.ville AS ville_10, t0.capacite_usine AS capacite_usine_11, t0.sigle AS sigle_12, t0.email_personne_ressource AS email_personne_ressource_13, t0.mobile_personne_ressource AS mobile_personne_ressource_14, t0.export AS export_15, t0.code_exportateur AS code_exportateur_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.updated_at AS updated_at_20, t0.agree AS agree_21, t0.latitude AS latitude_22, t0.longitude AS longitude_23, t0.code_cantonnement_id AS code_cantonnement_id_24, t0.code_exploitant_id AS code_exploitant_id_25 FROM metier.usine t0
Parameters:
[] |
| 10 | 1.00 ms |
SELECT m0_.id AS id_0, m0_.nom_menu AS nom_menu_1, m0_.icon_menu AS icon_menu_2, m0_.parent_menu AS parent_menu_3, m0_.classname_menu AS classname_menu_4 FROM metier.menu m0_ WHERE m0_.parent_menu IS NULL ORDER BY m0_.nom_menu ASC
Parameters:
[] |
| 11 | 1.14 ms |
SELECT t0.id AS id_1, t0.sujet AS sujet_2, t0.description AS description_3, t0.from_user AS from_user_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.lu AS lu_7, t0.reference AS reference_8, t0.related_to_entity AS related_to_entity_9, t0.related_to_id AS related_to_id_10, t0.cloture AS cloture_11, t0.to_user_id AS to_user_id_12 FROM metier.notification t0 WHERE t0.to_user_id IS NULL LIMIT 5
Parameters:
[] |
| 12 | 0.23 ms |
SELECT t0.id AS id_1, t0.nom_menu AS nom_menu_2, t0.icon_menu AS icon_menu_3, t0.parent_menu AS parent_menu_4, t0.classname_menu AS classname_menu_5 FROM metier.menu t0
Parameters:
[] |
| 13 | 1.76 ms |
SELECT t0.id AS id_1, t0.nom_menu AS nom_menu_2, t0.icon_menu AS icon_menu_3, t0.parent_menu AS parent_menu_4, t0.classname_menu AS classname_menu_5, t0.code_groupe_id AS code_groupe_id_6, t0.id_permission AS id_permission_7 FROM metier.menu_permission t0 WHERE t0.code_groupe_id = ?
Parameters:
[
1
]
|
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.