POST https://formatracker.com/erp/dossiers/generate-document/10011?p=erp%2Fdossiers%2Fgenerate-document%2F10011

Query Metrics

15 Database Queries
13 Different statements
10.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.72 ms
(26.67%)
2
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "Certification de réalisation-session-5131-67adb598c3e25.pdf"
  "ZINGRAFF-Lionel-5131/Certification de réalisation-session-5131-67adb598c3e25.pdf"
  "2025-02-13 09:04:24"
  0
  null
  null
  null
  null
  null
  null
  null
  0
  1
  10011
  1
]
1.99 ms
(19.52%)
1
"COMMIT"
Parameters:
[]
1.50 ms
(14.74%)
1
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 = ?
Parameters:
[
  6
]
0.69 ms
(6.81%)
1
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 = ?
Parameters:
[
  31
]
0.69 ms
(6.80%)
2
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.id = ?
Parameters:
[
  "58"
]
0.51 ms
(4.97%)
1
UPDATE clients SET num_edof = ? WHERE id = ?
Parameters:
[
  381104554249
  8089
]
0.34 ms
(3.35%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_entree AS date_entree_3, t0.date_sortie AS date_sortie_4, t0.lieu AS lieu_5, t0.formation_id AS formation_id_6, t0.format_id AS format_id_7, t0.mode_id AS mode_id_8, t0.provenance_id AS provenance_id_9, t0.referant_id AS referant_id_10, t0.societe_id AS societe_id_11 FROM sessions t0 WHERE t0.id = ?
Parameters:
[
  5131
]
0.33 ms
(3.23%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.mail AS mail_4, t0.adresse AS adresse_5, t0.ville AS ville_6, t0.tel AS tel_7, t0.num_edof AS num_edof_8, t0.date_creation AS date_creation_9, t0.vendeur AS vendeur_10, t0.cp AS cp_11, t0.date_naissance AS date_naissance_12, t0.lieu_naissance AS lieu_naissance_13, t0.statut_id AS statut_id_14, t0.statut_prospect_id AS statut_prospect_id_15, t0.provenance_id AS provenance_id_16, t0.categorie_id AS categorie_id_17, t0.civilite_id AS civilite_id_18, t0.societe_id AS societe_id_19 FROM clients t0 WHERE t0.id = ?
Parameters:
[
  8089
]
0.32 ms
(3.18%)
1
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 = ?
Parameters:
[
  1
]
0.30 ms
(2.94%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "$logoSociete$"
  "$nomClient$"
  "$prenomClient$"
  "$titreFormation$"
  "$dateEntreeSession$"
  "$dateSortieSession$"
  "$dureeHeuresFormation$"
  "$villeSociete$"
  "$dateDocument$"
  "$tamponSociete$"
]
0.29 ms
(2.86%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.num_edof AS num_edof_3, t0.client_id AS client_id_4, t0.session_id AS session_id_5, t0.societe_id AS societe_id_6 FROM session_client t0 WHERE t0.id = ?
Parameters:
[
  "10011"
]
0.25 ms
(2.48%)
1
"START TRANSACTION"
Parameters:
[]
0.25 ms
(2.45%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "$logoSociete$"
  "$nomClient$"
  "$prenomClient$"
  "$titreFormation$"
  "$dateEntreeSession$"
  "$dateSortieSession$"
  "$dureeHeuresFormation$"
  "$villeSociete$"
  "$dateDocument$"
  "$raisonSociale$"
  "$tamponSociete$"
]

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