Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.tel AS tel_7,
  t0.societe_id AS societe_id_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.tel AS tel_7, t0.societe_id AS societe_id_8 FROM user t0 WHERE t0.id = 6;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.prenom AS prenom_2,
  c0_.mail AS mail_3,
  c0_.adresse AS adresse_4,
  c0_.ville AS ville_5,
  c0_.tel AS tel_6,
  c0_.num_edof AS num_edof_7,
  c0_.date_creation AS date_creation_8,
  c0_.vendeur AS vendeur_9,
  c0_.cp AS cp_10,
  c0_.date_naissance AS date_naissance_11,
  c0_.lieu_naissance AS lieu_naissance_12,
  c0_.statut_id AS statut_id_13,
  c0_.statut_prospect_id AS statut_prospect_id_14,
  c0_.provenance_id AS provenance_id_15,
  c0_.categorie_id AS categorie_id_16,
  c0_.civilite_id AS civilite_id_17,
  c0_.societe_id AS societe_id_18
FROM
  clients c0_
WHERE
  c0_.societe_id = ?
  AND c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.prenom AS prenom_2, c0_.mail AS mail_3, c0_.adresse AS adresse_4, c0_.ville AS ville_5, c0_.tel AS tel_6, c0_.num_edof AS num_edof_7, c0_.date_creation AS date_creation_8, c0_.vendeur AS vendeur_9, c0_.cp AS cp_10, c0_.date_naissance AS date_naissance_11, c0_.lieu_naissance AS lieu_naissance_12, c0_.statut_id AS statut_id_13, c0_.statut_prospect_id AS statut_prospect_id_14, c0_.provenance_id AS provenance_id_15, c0_.categorie_id AS categorie_id_16, c0_.civilite_id AS civilite_id_17, c0_.societe_id AS societe_id_18 FROM clients c0_ WHERE c0_.societe_id = 1 AND c0_.id IN ('8086');

SELECT
  s0_.id AS id_0,
  s0_.titre AS titre_1,
  s0_.date_entree AS date_entree_2,
  s0_.date_sortie AS date_sortie_3,
  s0_.lieu AS lieu_4,
  s0_.formation_id AS formation_id_5,
  s0_.format_id AS format_id_6,
  s0_.mode_id AS mode_id_7,
  s0_.provenance_id AS provenance_id_8,
  s0_.referant_id AS referant_id_9,
  s0_.societe_id AS societe_id_10
FROM
  sessions s0_
WHERE
  s0_.societe_id = ?
  AND s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.date_entree AS date_entree_2, s0_.date_sortie AS date_sortie_3, s0_.lieu AS lieu_4, s0_.formation_id AS formation_id_5, s0_.format_id AS format_id_6, s0_.mode_id AS mode_id_7, s0_.provenance_id AS provenance_id_8, s0_.referant_id AS referant_id_9, s0_.societe_id AS societe_id_10 FROM sessions s0_ WHERE s0_.societe_id = 1 AND s0_.id IN ('5127');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO session_client (
  date, num_edof, client_id, session_id,
  societe_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO session_client (date, num_edof, client_id, session_id, societe_id) VALUES ('2025-01-08 14:43:30', '401092068830', 8086, 5127, 1);

UPDATE
  clients
SET
  num_edof = ?
WHERE
  id = ?

UPDATE clients SET num_edof = 401092068830 WHERE id = 8086;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.contenu AS contenu_3,
  t0.signature AS signature_4,
  t0.auto_send AS auto_send_5,
  t0.societe_id AS societe_id_6
FROM
  model_document t0
WHERE
  t0.auto_send = ?
  AND t0.societe_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.signature AS signature_4, t0.auto_send AS auto_send_5, t0.societe_id AS societe_id_6 FROM model_document t0 WHERE t0.auto_send = 1 AND t0.societe_id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.syntaxe AS syntaxe_3,
  t0.tab AS tab_4,
  t0.champ AS champ_5
FROM
  variables t0
WHERE
  t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN ('$logoSociete$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$prefectureSociete$', '$numNDAsociete$', '$siretSociete$', '$adresseSociete$', '$codePostalSociete$', '$villeSociete$', '$telSociete$', '$emailSociete$', '$telSociete$', '$emailSociete$', '$tamponSociete$');

SELECT
  t0.id AS id_1,
  t0.raison_sociale AS raison_sociale_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.ville AS ville_5,
  t0.pays AS pays_6,
  t0.tel AS tel_7,
  t0.mail AS mail_8,
  t0.logo AS logo_9,
  t0.siret AS siret_10,
  t0.num_tva AS num_tva_11,
  t0.nda AS nda_12,
  t0.representant AS representant_13,
  t0.site_internet AS site_internet_14,
  t0.tampon AS tampon_15,
  t0.prefecture AS prefecture_16,
  t0.signature_restante AS signature_restante_17,
  t0.type AS type_18
FROM
  societe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.tel AS tel_7, t0.mail AS mail_8, t0.logo AS logo_9, t0.siret AS siret_10, t0.num_tva AS num_tva_11, t0.nda AS nda_12, t0.representant AS representant_13, t0.site_internet AS site_internet_14, t0.tampon AS tampon_15, t0.prefecture AS prefecture_16, t0.signature_restante AS signature_restante_17, t0.type AS type_18 FROM societe t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.syntaxe AS syntaxe_3,
  t0.tab AS tab_4,
  t0.champ AS champ_5
FROM
  variables t0
WHERE
  t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN ('$logoSociete$', '$titreFormation$', '$objectifFormation$', '$preRequisFormation$', '$resultatAttenduFormation$', '$certificationFormation$', '$dureeHeuresFormation$', '$publicFormation$', '$contenuFormation$', '$moyenFormation$', '$tamponSociete$');

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.tarif_ht AS tarif_ht_3,
  t0.tarif_ttc AS tarif_ttc_4,
  t0.duree_jours AS duree_jours_5,
  t0.duree_heures AS duree_heures_6,
  t0.objectif AS objectif_7,
  t0.ressource AS ressource_8,
  t0.suivi AS suivi_9,
  t0.contenu AS contenu_10,
  t0.participant_min AS participant_min_11,
  t0.participant_max AS participant_max_12,
  t0.public AS public_13,
  t0.pre_requis AS pre_requis_14,
  t0.resultat_attendu AS resultat_attendu_15,
  t0.modalite_admission AS modalite_admission_16,
  t0.date_creation AS date_creation_17,
  t0.certification AS certification_18,
  t0.moyen AS moyen_19,
  t0.format_id AS format_id_20,
  t0.tva_id AS tva_id_21,
  t0.admission_id AS admission_id_22,
  t0.referent_id AS referent_id_23,
  t0.societe_id AS societe_id_24
FROM
  formations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.tarif_ht AS tarif_ht_3, t0.tarif_ttc AS tarif_ttc_4, t0.duree_jours AS duree_jours_5, t0.duree_heures AS duree_heures_6, t0.objectif AS objectif_7, t0.ressource AS ressource_8, t0.suivi AS suivi_9, t0.contenu AS contenu_10, t0.participant_min AS participant_min_11, t0.participant_max AS participant_max_12, t0.public AS public_13, t0.pre_requis AS pre_requis_14, t0.resultat_attendu AS resultat_attendu_15, t0.modalite_admission AS modalite_admission_16, t0.date_creation AS date_creation_17, t0.certification AS certification_18, t0.moyen AS moyen_19, t0.format_id AS format_id_20, t0.tva_id AS tva_id_21, t0.admission_id AS admission_id_22, t0.referent_id AS referent_id_23, t0.societe_id AS societe_id_24 FROM formations t0 WHERE t0.id = 33;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.syntaxe AS syntaxe_3,
  t0.tab AS tab_4,
  t0.champ AS champ_5
FROM
  variables t0
WHERE
  t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN ('$logoSociete$', '$raisonSociale$', '$numNDAsociete$', '$siretSociete$', '$adresseSociete$', '$codePostalSociete$', '$villeSociete$', '$telSociete$', '$emailSociete$', '$telSociete$', '$emailSociete$', '$villeSociete$', '$dateDocument$', '$raisonSociale$', '$tamponSociete$');

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.syntaxe AS syntaxe_3,
  t0.tab AS tab_4,
  t0.champ AS champ_5
FROM
  variables t0
WHERE
  t0.syntaxe IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN ('$logoSociete$', '$nomClient$', '$prenomClient$', '$adresseClient$', '$codePostalClient$', '$villeClient$', '$titreFormation$', '$titreFormation$', '$dateEntreeSession$', '$dateSortieSession$', '$tarifTTCFormation$', '$villeSociete$', '$dateDocument$', '$tamponSociete$');

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.syntaxe AS syntaxe_3,
  t0.tab AS tab_4,
  t0.champ AS champ_5
FROM
  variables t0
WHERE
  t0.syntaxe IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.syntaxe AS syntaxe_3, t0.tab AS tab_4, t0.champ AS champ_5 FROM variables t0 WHERE t0.syntaxe IN ('$logoSociete$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$raisonSociale$', '$villeSociete$', '$dateDocument$', '$raisonSociale$', '$tamponSociete$');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO document_client (
  titre, lien, date, signature, signature_canva,
  code_tel, signature_envoi, signature_canva_date,
  signature_ip, signature_sms_date,
  token, auto_send, generate, session_client_id,
  societe_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES ('Mentions légales-session-5127-677e8f133f5ff.pdf', 'NOIRE-Celine-5127/Mentions légales-session-5127-677e8f133f5ff.pdf', '2025-01-08 14:43:31', 0, NULL, NULL, '2025-01-08 14:43:31', NULL, NULL, NULL, NULL, 1, 1, 10010, 1);

INSERT INTO document_client (
  titre, lien, date, signature, signature_canva,
  code_tel, signature_envoi, signature_canva_date,
  signature_ip, signature_sms_date,
  token, auto_send, generate, session_client_id,
  societe_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES ('Programme de formation-session-5127-677e8f135bcd5.pdf', 'NOIRE-Celine-5127/Programme de formation-session-5127-677e8f135bcd5.pdf', '2025-01-08 14:43:31', 0, NULL, NULL, '2025-01-08 14:43:31', NULL, NULL, NULL, NULL, 1, 1, 10010, 1);

INSERT INTO document_client (
  titre, lien, date, signature, signature_canva,
  code_tel, signature_envoi, signature_canva_date,
  signature_ip, signature_sms_date,
  token, auto_send, generate, session_client_id,
  societe_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES ('CGV-session-5127-677e8f137e2af.pdf', 'NOIRE-Celine-5127/CGV-session-5127-677e8f137e2af.pdf', '2025-01-08 14:43:31', 0, NULL, NULL, '2025-01-08 14:43:31', NULL, NULL, NULL, NULL, 1, 1, 10010, 1);

INSERT INTO document_client (
  titre, lien, date, signature, signature_canva,
  code_tel, signature_envoi, signature_canva_date,
  signature_ip, signature_sms_date,
  token, auto_send, generate, session_client_id,
  societe_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES ('Contrat de formation-session-5127-677e8f13a0124.pdf', 'NOIRE-Celine-5127/Contrat de formation-session-5127-677e8f13a0124.pdf', '2025-01-08 14:43:31', 1, NULL, NULL, '2025-01-08 14:43:31', NULL, NULL, NULL, '209ebae7fddf871cd451efe773c0115d12dc9c03ee3cdcfb295f370b836be797', 1, 1, 10010, 1);

INSERT INTO document_client (
  titre, lien, date, signature, signature_canva,
  code_tel, signature_envoi, signature_canva_date,
  signature_ip, signature_sms_date,
  token, auto_send, generate, session_client_id,
  societe_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO document_client (titre, lien, date, signature, signature_canva, code_tel, signature_envoi, signature_canva_date, signature_ip, signature_sms_date, token, auto_send, generate, session_client_id, societe_id) VALUES ('Règlement intérieur-session-5127-677e8f13d8906.pdf', 'NOIRE-Celine-5127/Règlement intérieur-session-5127-677e8f13d8906.pdf', '2025-01-08 14:43:31', 0, NULL, NULL, '2025-01-08 14:43:31', NULL, NULL, NULL, NULL, 1, 1, 10010, 1);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO hitorique_mail (
  user_mail, commentaire, date, user_id,
  societe_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO hitorique_mail (user_mail, commentaire, date, user_id, societe_id) VALUES ('Celinechristmann78@gmail.com', 'document n°1 : Mentions légales-session-5127-677e8f133f5ff.pdf, document n°2 : Programme de formation-session-5127-677e8f135bcd5.pdf, document n°3 : CGV-session-5127-677e8f137e2af.pdf, document n°4 : Règlement intérieur-session-5127-677e8f13d8906.pdf', '2025-01-08 14:43:32', 8086, 1);

"COMMIT"

"COMMIT";