GET https://gexsign.app/process/getFile/4qQ37PZdCcGV8dWcGSgQhi

Query Metrics

3 Database Queries
3 Different statements
0.23 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.10 ms
(43.40%)
1
SELECT t0.id AS id_1, t0.fi_pdf AS fi_pdf_2, t0.fi_dh_creation AS fi_dh_creation_3, t0.fi_link AS fi_link_4, t0.fi_nom AS fi_nom_5, t0.client_id AS client_id_6, t7.id AS id_8, t7.fx_dh_creation AS fx_dh_creation_9, t7.fx_dh_envoi AS fx_dh_envoi_10, t7.fx_dh_signature AS fx_dh_signature_11, t7.fx_etat_signature AS fx_etat_signature_12, t7.entetedocument AS entetedocument_13, t7.fx_contenu AS fx_contenu_14, t7.fx_modele AS fx_modele_15, t7.en_test AS en_test_16, t7.fichier_id AS fichier_id_17 FROM fichier t0 LEFT JOIN fichiersignature t7 ON t7.fichier_id = t0.id WHERE t0.id = ?
Parameters:
[
  314
]
0.08 ms
(33.06%)
1
SELECT t0.id AS id_1, t0.tiers AS tiers_2, t0.contact AS contact_3, t0.f1_nom AS f1_nom_4, t0.f1_telephone AS f1_telephone_5, t0.f1_email AS f1_email_6, t0.f1_dh_signature AS f1_dh_signature_7, t0.f1_etat_signature AS f1_etat_signature_8, t0.f1_link AS f1_link_9, t0.f1_prenom AS f1_prenom_10, t0.f1_id_externe AS f1_id_externe_11, t0.f1_id_local AS f1_id_local_12, t0.fichiersignature_id AS fichiersignature_id_13 FROM fichiersignaturetiers t0 WHERE t0.f1_link = ? LIMIT 1
Parameters:
[
  "4qQ37PZdCcGV8dWcGSgQhi"
]
0.05 ms
(23.54%)
1
SELECT t0.id AS id_1, t0.fx_dh_creation AS fx_dh_creation_2, t0.fx_dh_envoi AS fx_dh_envoi_3, t0.fx_dh_signature AS fx_dh_signature_4, t0.fx_etat_signature AS fx_etat_signature_5, t0.entetedocument AS entetedocument_6, t0.fx_contenu AS fx_contenu_7, t0.fx_modele AS fx_modele_8, t0.en_test AS en_test_9, t0.fichier_id AS fichier_id_10 FROM fichiersignature t0 WHERE t0.id = ?
Parameters:
[
  416
]

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

Class Mapping errors
App\Entity\Fichiersignaturetiers No errors.
App\Entity\Fichiersignature
  • The association App\Entity\Fichiersignature#fichier refers to the inverse side field App\Entity\Fichier#fichiersignatures which does not exist.
App\Entity\Fichier
  • The mappings App\Entity\Fichier#fichiersignature and App\Entity\Fichiersignature#fichier are inconsistent with each other.
App\Entity\Client No errors.