Query Metrics
42
Database Queries
16
Different statements
509.19 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 70.32 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:
[
"widad@sales-synergy.com"
]
|
2 | 63.23 ms |
SELECT a0_.id AS id_0, a0_.dateappel AS dateappel_1, a0_.numerotelephone AS numerotelephone_2, a0_.dureeappel AS dureeappel_3, a0_.campagneprospect_id AS campagneprospect_id_4, a0_.utilisateur_id AS utilisateur_id_5, a0_.appelstatut_id AS appelstatut_id_6, a0_.commentaire_id AS commentaire_id_7 FROM appel a0_ LEFT JOIN campagneprospect c1_ ON (a0_.campagneprospect_id = c1_.id) LEFT JOIN utilisateur u2_ ON (a0_.utilisateur_id = u2_.id) LEFT JOIN campagne c3_ ON (c1_.campagne_id = c3_.id) LEFT JOIN prospect p4_ ON (c1_.prospect_id = p4_.id) WHERE (1 = 1 AND c1_.prospect_id = 23681)
Parameters:
[] |
3 | 12.01 ms |
SELECT a0_.id AS id_0, a0_.dateappel AS dateappel_1, a0_.numerotelephone AS numerotelephone_2, a0_.dureeappel AS dureeappel_3, a0_.campagneprospect_id AS campagneprospect_id_4, a0_.utilisateur_id AS utilisateur_id_5, a0_.appelstatut_id AS appelstatut_id_6, a0_.commentaire_id AS commentaire_id_7 FROM appel a0_ LEFT JOIN campagneprospect c1_ ON (a0_.campagneprospect_id = c1_.id) LEFT JOIN utilisateur u2_ ON (a0_.utilisateur_id = u2_.id) LEFT JOIN campagne c3_ ON (c1_.campagne_id = c3_.id) LEFT JOIN prospect p4_ ON (c1_.prospect_id = p4_.id) WHERE (1 = 1 AND c1_.prospect_id = 23681) ORDER BY a0_.id DESC LIMIT 100
Parameters:
[] |
4 | 3.79 ms |
SELECT t0.id AS id_1, t0.rappelprive AS rappelprive_2, t0.daterappel AS daterappel_3, t0.historique AS historique_4, t0.commentaire AS commentaire_5, t0.traitementdate AS traitementdate_6, t0.traitementencore AS traitementencore_7, t0.campagne_id AS campagne_id_8, t0.prospect_id AS prospect_id_9, t0.utilisateur_id AS utilisateur_id_10, t0.appelstatut_id AS appelstatut_id_11, t0.traitementpar_id AS traitementpar_id_12 FROM campagneprospect t0 WHERE t0.id = ?
Parameters:
[
56036
]
|
5 | 2.82 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:
[
112
]
|
6 | 26.78 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
]
|
7 | 2.40 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
]
|
8 | 0.28 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
]
|
9 | 5.77 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:
[
43
]
|
10 | 0.26 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:
[
3
]
|
11 | 62.94 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:
[
23681
]
|
12 | 2.01 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:
[
23681
]
|
13 | 4.21 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:
[
223
]
|
14 | 1.36 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:
[
101
]
|
15 | 68.30 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:
[
23681
]
|
16 | 0.51 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
]
|
17 | 0.42 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3, t0.horscible AS horscible_4, t0.nrp AS nrp_5, t0.rdv AS rdv_6, t0.rappel AS rappel_7, t0.couleur AS couleur_8, t0.objectif AS objectif_9, t0.fichequalifie AS fichequalifie_10, t0.fichearequalifie AS fichearequalifie_11 FROM appelstatut t0 WHERE t0.id = ?
Parameters:
[
1
]
|
18 | 0.45 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:
[
56
]
|
19 | 8.97 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:
[
297339
]
|
20 | 0.96 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:
[
296747
]
|
21 | 5.92 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:
[
296157
]
|
22 | 0.34 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:
[
23
]
|
23 | 0.31 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:
[
295241
]
|
24 | 58.45 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:
[
294639
]
|
25 | 7.55 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:
[
67
]
|
26 | 0.47 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:
[
293885
]
|
27 | 3.50 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:
[
292861
]
|
28 | 4.02 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:
[
291695
]
|
29 | 59.15 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:
[
291093
]
|
30 | 3.15 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:
[
14
]
|
31 | 0.52 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:
[
290161
]
|
32 | 7.65 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:
[
289455
]
|
33 | 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:
[
286321
]
|
34 | 9.35 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:
[
69
]
|
35 | 0.56 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:
[
284749
]
|
36 | 3.06 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:
[
283751
]
|
37 | 0.40 ms |
SELECT t0.id AS id_1, t0.rappelprive AS rappelprive_2, t0.daterappel AS daterappel_3, t0.historique AS historique_4, t0.commentaire AS commentaire_5, t0.traitementdate AS traitementdate_6, t0.traitementencore AS traitementencore_7, t0.campagne_id AS campagne_id_8, t0.prospect_id AS prospect_id_9, t0.utilisateur_id AS utilisateur_id_10, t0.appelstatut_id AS appelstatut_id_11, t0.traitementpar_id AS traitementpar_id_12 FROM campagneprospect t0 WHERE t0.id = ?
Parameters:
[
55698
]
|
38 | 5.35 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:
[
111
]
|
39 | 0.19 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:
[
65
]
|
40 | 0.30 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
]
|
41 | 0.30 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3, t0.horscible AS horscible_4, t0.nrp AS nrp_5, t0.rdv AS rdv_6, t0.rappel AS rappel_7, t0.couleur AS couleur_8, t0.objectif AS objectif_9, t0.fichequalifie AS fichequalifie_10, t0.fichearequalifie AS fichearequalifie_11 FROM appelstatut t0 WHERE t0.id = ?
Parameters:
[
23
]
|
42 | 0.44 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:
[
280997
]
|
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\Appel | No errors. |
App\Entity\Campagneprospect | No errors. |
App\Entity\Campagne | No errors. |
App\Entity\Prospect |
|
App\Entity\Appelstatut | No errors. |
App\Entity\Commentaire | 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\Contact | No errors. |
App\Entity\Appareil | No errors. |
App\Entity\Appareiltype | No errors. |
App\Entity\Appareilmarque | No errors. |
App\Entity\Importation | No errors. |