Query Metrics
1
Database Queries
1
Different statements
2.28 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.28 ms |
SELECT g0_.id AS id_0, g0_.date_depart AS date_depart_1, g0_.date_retour AS date_retour_2, g0_.heure_depart AS heure_depart_3, g0_.heure_retour AS heure_retour_4, g0_.nb_personnes AS nb_personnes_5, g0_.programme AS programme_6, g0_.detail AS detail_7, g0_.budget AS budget_8, g0_.date_parution AS date_parution_9, g0_.annule AS annule_10, g0_.kilometres AS kilometres_11, g0_.observation AS observation_12, g0_.file_pdf AS file_pdf_13, u1_.id AS id_14, u1_.email AS email_15, u1_.societe AS societe_16, u1_.telephone AS telephone_17, u1_.fax AS fax_18, u1_.portable AS portable_19, u1_.prenom AS prenom_20, u1_.nom AS nom_21, u1_.fonction AS fonction_22, u1_.mot_passe AS mot_passe_23, u1_.roles AS roles_24, u1_.compte_active AS compte_active_25, u1_.date_inscription AS date_inscription_26, u1_.date_der_connexion AS date_der_connexion_27, u1_.is_verified AS is_verified_28, a2_.id AS id_29, a2_.corps_adresse AS corps_adresse_30, a2_.code_postal AS code_postal_31, a2_.ville AS ville_32, a2_.pays AS pays_33, a3_.id AS id_34, a3_.corps_adresse AS corps_adresse_35, a3_.code_postal AS code_postal_36, a3_.ville AS ville_37, a3_.pays AS pays_38, a4_.id AS id_39, a4_.corps_adresse AS corps_adresse_40, a4_.code_postal AS code_postal_41, a4_.ville AS ville_42, a4_.pays AS pays_43, g0_.user_id AS user_id_44, g0_.adresse_depart_id AS adresse_depart_id_45, g0_.adresse_retour_id AS adresse_retour_id_46, g0_.type_client_id AS type_client_id_47, g0_.type_groupe_id AS type_groupe_id_48, g0_.equipements_id AS equipements_id_49, g0_.prestation_id AS prestation_id_50, u1_.type_adherent_id AS type_adherent_id_51, u1_.adresse_id AS adresse_id_52 FROM groupes g0_ LEFT JOIN users u1_ ON g0_.user_id = u1_.id INNER JOIN adresses a2_ ON u1_.adresse_id = a2_.id LEFT JOIN adresses a3_ ON g0_.adresse_depart_id = a3_.id LEFT JOIN adresses a4_ ON g0_.adresse_retour_id = a4_.id ORDER BY g0_.date_depart ASC LIMIT 25
Parameters:
[] |
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\Groupe | No errors. |
App\Entity\User | No errors. |
App\Entity\Adresse | No errors. |
App\Entity\TypeClient | No errors. |
App\Entity\TypeGroupe | No errors. |
App\Entity\Equipement | No errors. |
App\Entity\Prestation | No errors. |
App\Entity\TypeAdherent | No errors. |
App\Entity\Vehicule | No errors. |