Symfony Profiler

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 = 'sana@itsales.fr' LIMIT 1;

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

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.code = ?
LIMIT
  1

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.code = '8710A' LIMIT 1;

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

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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  prospect
SET
  datemodification = ?
WHERE
  id = ?

UPDATE prospect SET datemodification = '2025-01-15 17:49:29' WHERE id = 24301;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO commentaire (
  message, date, prospect_id, importation_id,
  utilisateur_id, campagne_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO commentaire (message, date, prospect_id, importation_id, utilisateur_id, campagne_id) VALUES ('<p>pas de RI trouvé que le directeur </p>', '2025-01-15 17:49:29', 24301, NULL, 65, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO commentaire (
  message, date, prospect_id, importation_id,
  utilisateur_id, campagne_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO commentaire (message, date, prospect_id, importation_id, utilisateur_id, campagne_id) VALUES ('', '2025-01-15 17:49:29', NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

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

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

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

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.prospect_id = ?
  AND t0.campagne_id = ?
LIMIT
  1

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.prospect_id = 24301 AND t0.campagne_id = 118 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO campagneprospect (
  rappelprive, daterappel, historique,
  commentaire, traitementdate, traitementencore,
  campagne_id, prospect_id, utilisateur_id,
  appelstatut_id, traitementpar_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO campagneprospect (rappelprive, daterappel, historique, commentaire, traitementdate, traitementencore, campagne_id, prospect_id, utilisateur_id, appelstatut_id, traitementpar_id) VALUES (-1, NULL, '[]', '<p>pas de RI trouvé que le directeur </p>', NULL, 0, 118, 24301, NULL, NULL, NULL);

INSERT INTO appel (
  dateappel, numerotelephone, dureeappel,
  campagneprospect_id, utilisateur_id,
  appelstatut_id, commentaire_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO appel (dateappel, numerotelephone, dureeappel, campagneprospect_id, utilisateur_id, appelstatut_id, commentaire_id) VALUES ('2025-01-15 17:49:29', '0473658227', 6, 57543, 65, 23, 333017);

UPDATE
  campagneprospect
SET
  traitementdate = ?,
  utilisateur_id = ?,
  appelstatut_id = ?,
  traitementpar_id = ?
WHERE
  id = ?

UPDATE campagneprospect SET traitementdate = '2025-01-15 17:49:29', utilisateur_id = 65, appelstatut_id = 23, traitementpar_id = 65 WHERE id = 57543;

"COMMIT"

"COMMIT";