Query Metrics

15 Database Queries
11 Different statements
43.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.06 ms
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
]
2 8.99 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.lien AS lien_3, t0.date AS date_4, t0.signature AS signature_5, t0.signature_canva AS signature_canva_6, t0.code_tel AS code_tel_7, t0.signature_envoi AS signature_envoi_8, t0.signature_canva_date AS signature_canva_date_9, t0.signature_ip AS signature_ip_10, t0.signature_sms_date AS signature_sms_date_11, t0.token AS token_12, t0.auto_send AS auto_send_13, t0.generate AS generate_14, t0.session_client_id AS session_client_id_15, t0.societe_id AS societe_id_16 FROM document_client t0 WHERE t0.id = ?
Parameters:
[
  "2088"
]
3 0.77 ms
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:
[
  10013
]
4 0.34 ms
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:
[
  8090
]
5 0.18 ms
"START TRANSACTION"
Parameters:
[]
6 0.45 ms
UPDATE document_client SET token = ? WHERE id = ?
Parameters:
[
  "8b19e633ae8266b486ba6212827b26a94ff5943104a3fe67288cd7f8d55a4f35"
  2088
]
7 0.27 ms
UPDATE clients SET num_edof = ? WHERE id = ?
Parameters:
[
  381100366846
  8090
]
8 13.55 ms
"COMMIT"
Parameters:
[]
9 0.24 ms
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
]
10 14.17 ms
"START TRANSACTION"
Parameters:
[]
11 0.54 ms
UPDATE document_client SET signature_envoi = ? WHERE id = ?
Parameters:
[
  "2025-02-19 09:42:09"
  2088
]
12 1.22 ms
"COMMIT"
Parameters:
[]
13 0.18 ms
"START TRANSACTION"
Parameters:
[]
14 0.42 ms
INSERT INTO hitorique_mail (user_mail, commentaire, date, user_id, societe_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "dimitri.weiland@gmail.com"
  "document n°1 : Feuile de présence-session-5133-67b5a76b201ad.pdf"
  "2025-02-19 09:42:09"
  8090
  1
]
15 0.89 ms
"COMMIT"
Parameters:
[]

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