Symfony Profiler

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 = ?

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 = 297339;

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

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 = 'widad@sales-synergy.com' LIMIT 1;

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 = ?

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 = 23681;

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
  )

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);

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 = ?

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 = 23681;

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 = ?

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 = 43;

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 = ?

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 = 12;

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

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;

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 = ?

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 = 112;

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 = ?

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 = 223;

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 = ?

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 = 56036;

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 = ?

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 = 12;

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 = ?

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 = 23681;

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 = ?

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 = 101;

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 = ?

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 = 4;

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 = ?

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 = 1;