Query Metrics
24
Database Queries
19
Different statements
7.35 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.33 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.parametres AS parametres_8, t0.erreur AS erreur_9, t0.erreurdate AS erreurdate_10, t0.groupe_id AS groupe_id_11, t0.photo_id AS photo_id_12, t0.client_id AS client_id_13 FROM utilisateur t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"yasmine@itsales.fr"
]
|
2 | 0.34 ms |
SELECT t0.id AS id_1, t0.daterdv AS daterdv_2, t0.datecreation AS datecreation_3, t0.datemodification AS datemodification_4, t0.campagne_id AS campagne_id_5, t0.prospect_id AS prospect_id_6, t0.utilisateur_id AS utilisateur_id_7, t0.commentaire_id AS commentaire_id_8, t0.rdvstatut_id AS rdvstatut_id_9, t0.contact_id AS contact_id_10, t0.commercial_id AS commercial_id_11, t0.commentaireresponsable_id AS commentaireresponsable_id_12 FROM rdv t0 WHERE t0.id = ?
Parameters:
[
1653
]
|
3 | 0.25 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3, t0.validerparadmin AS validerparadmin_4, t0.arevoirparagent AS arevoirparagent_5, t0.couleur AS couleur_6, t0.annulerparadmin AS annulerparadmin_7, t0.validerparagent AS validerparagent_8, t0.annulerparagent AS annulerparagent_9 FROM rdvstatut t0 WHERE t0.id = ?
Parameters:
[
2
]
|
4 | 0.20 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.parametres AS parametres_8, t0.erreur AS erreur_9, t0.erreurdate AS erreurdate_10, t0.groupe_id AS groupe_id_11, t0.photo_id AS photo_id_12, t0.client_id AS client_id_13 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
31
]
|
5 | 0.22 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4, t0.datecreation AS datecreation_5, t0.datedebut AS datedebut_6, t0.datefin AS datefin_7, t0.objectif AS objectif_8, t0.objectifagent AS objectifagent_9, t0.type AS type_10, t0.campagnecible AS campagnecible_11, t0.recuperer_tous_historique AS recuperer_tous_historique_12, t0.client_id AS client_id_13, t0.reponsable_id AS reponsable_id_14, t0.clientmanager_id AS clientmanager_id_15 FROM campagne t0 WHERE t0.id = ?
Parameters:
[
114
]
|
6 | 0.18 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.parametres AS parametres_8, t0.erreur AS erreur_9, t0.erreurdate AS erreurdate_10, t0.groupe_id AS groupe_id_11, t0.photo_id AS photo_id_12, t0.client_id AS client_id_13 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
68
]
|
7 | 0.53 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.parametres AS parametres_8, t0.erreur AS erreur_9, t0.erreurdate AS erreurdate_10, t0.groupe_id AS groupe_id_11, t0.photo_id AS photo_id_12, t0.client_id AS client_id_13 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
62
]
|
8 | 0.25 ms |
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.siren AS siren_3, t0.adresse AS adresse_4, t0.adressesuite AS adressesuite_5, t0.chiffre_affaire AS chiffre_affaire_6, t0.active AS active_7, t0.standard AS standard_8, t0.email AS email_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.siteweb AS siteweb_12, t0.effectif AS effectif_13, t0.siret AS siret_14, t0.description AS description_15, t0.ville_id AS ville_id_16, t0.codenaf_id AS codenaf_id_17, t18.id AS id_19, t18.consultationderniere AS consultationderniere_20, t18.consultationprochaine AS consultationprochaine_21, t18.prestataire AS prestataire_22, t18.sitedecionnaire AS sitedecionnaire_23, t18.societedecisionnaire AS societedecisionnaire_24, t18.effectif2 AS effectif2_25, t18.description AS description_26, t18.segmentmarche_id AS segmentmarche_id_27, t18.prospect_id AS prospect_id_28, t18.politiquerenouvellement_id AS politiquerenouvellement_id_29 FROM prospect t0 LEFT JOIN prospectdetail t18 ON t18.prospect_id = t0.id WHERE t0.id = ?
Parameters:
[
20343
]
|
9 | 0.26 ms |
"START TRANSACTION"
Parameters:
[] |
10 | 0.70 ms |
UPDATE rdv SET datemodification = ?, rdvstatut_id = ? WHERE id = ?
Parameters:
[ "2025-05-13 18:17:39" 2 1653 ] |
11 | 1.11 ms |
"COMMIT"
Parameters:
[] |
12 | 0.25 ms |
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.adresse AS adresse_3, t0.fixe AS fixe_4, t0.mobile AS mobile_5, t0.email AS email_6, t0.siteweb AS siteweb_7, t0.active AS active_8, t0.siren AS siren_9, t0.ville_id AS ville_id_10, t0.manager_id AS manager_id_11 FROM client t0 WHERE t0.id = ?
Parameters:
[
12
]
|
13 | 0.25 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.parametres AS parametres_8, t0.erreur AS erreur_9, t0.erreurdate AS erreurdate_10, t0.groupe_id AS groupe_id_11, t0.photo_id AS photo_id_12, t0.client_id AS client_id_13 FROM utilisateur t0 WHERE t0.client_id = ?
Parameters:
[
12
]
|
14 | 0.19 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.permissions AS permissions_3, t0.active AS active_4, t0.est_globale AS est_globale_5 FROM groupe t0 WHERE t0.id = ?
Parameters:
[
4
]
|
15 | 0.23 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.permissions AS permissions_3, t0.active AS active_4, t0.est_globale AS est_globale_5 FROM groupe t0 WHERE t0.id = ?
Parameters:
[
1
]
|
16 | 0.22 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.email AS email_6, t0.fixe AS fixe_7, t0.mobile AS mobile_8, t0.active AS active_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.rgpd AS rgpd_12, t0.prospect_id AS prospect_id_13, t0.collaborateur_id AS collaborateur_id_14 FROM contact t0 WHERE t0.prospect_id = ?
Parameters:
[
20343
]
|
17 | 0.19 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.codepostal AS codepostal_3, t0.active AS active_4, t0.pays AS pays_5 FROM ville t0 WHERE t0.id = ?
Parameters:
[
4710
]
|
18 | 0.20 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.active AS active_4 FROM codenaf t0 WHERE t0.id = ?
Parameters:
[
166
]
|
19 | 0.22 ms |
SELECT t0.id AS id_1, t0.nbre AS nbre_2, t0.description AS description_3, t0.type_id AS type_id_4, t0.marque_id AS marque_id_5, t0.prospect_id AS prospect_id_6 FROM appareil t0 WHERE t0.prospect_id = ?
Parameters:
[
20343
]
|
20 | 0.19 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4 FROM appareiltype t0 WHERE t0.id = ?
Parameters:
[
8
]
|
21 | 0.19 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4 FROM appareilmarque t0 WHERE t0.id = ?
Parameters:
[
4
]
|
22 | 0.21 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.permissions AS permissions_3, t0.active AS active_4, t0.est_globale AS est_globale_5 FROM groupe t0 WHERE t0.id = ?
Parameters:
[
2
]
|
23 | 0.21 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.date AS date_3, t0.prospect_id AS prospect_id_4, t0.importation_id AS importation_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.campagne_id AS campagne_id_7 FROM commentaire t0 WHERE t0.id = ?
Parameters:
[
382052
]
|
24 | 0.41 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.date AS date_3, t0.prospect_id AS prospect_id_4, t0.importation_id AS importation_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.campagne_id AS campagne_id_7 FROM commentaire t0 WHERE t0.id = ?
Parameters:
[
382053
]
|
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\Utilisateur | No errors. |
App\Entity\Groupe | No errors. |
App\Entity\Fichier | No errors. |
App\Entity\Client | No errors. |
App\Entity\Rdv | No errors. |
App\Entity\Campagne | No errors. |
App\Entity\Prospect |
|
App\Entity\Commentaire | No errors. |
App\Entity\Rdvstatut | No errors. |
App\Entity\Contact | No errors. |
App\Entity\Commercial | No errors. |
App\Entity\Ville | No errors. |
App\Entity\Codenaf | No errors. |
App\Entity\Prospectdetail | No errors. |
App\Entity\Segmentmarche | No errors. |
App\Entity\Politiquerenouvellement | No errors. |
App\Entity\Appareil | No errors. |
App\Entity\Importation | No errors. |
App\Entity\Appareiltype | No errors. |
App\Entity\Appareilmarque | No errors. |