http://api.sales-synergy.com/api/appel/find Return to referer URL

Query Metrics

42 Database Queries
16 Different statements
509.19 ms Query time
1 Invalid entities

Queries

Group similar statements

# 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
  • The field App\Entity\Prospect#appareils is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Appareil#prospect does not contain the required 'inversedBy="appareils"' attribute.
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.