Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

4 Database Queries

4 Different statements

0.32 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.14 ms

SELECT t0.id AS id_1, t0.cl_nom AS cl_nom_2, t0.cl_logo AS cl_logo_3, t0.signature_options AS signature_options_4, t0.code_client AS code_client_5, t0.cle_securite AS cle_securite_6, t0.account AS account_7, t0.serveur AS serveur_8, t0.cl_email AS cl_email_9 FROM client t0 WHERE t0.code_client = ? AND t0.cle_securite = ? LIMIT 1

Parameters:

[
  "CAR-E"
  "747931379402"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cl_nom AS cl_nom_2,
  t0.cl_logo AS cl_logo_3,
  t0.signature_options AS signature_options_4,
  t0.code_client AS code_client_5,
  t0.cle_securite AS cle_securite_6,
  t0.account AS account_7,
  t0.serveur AS serveur_8,
  t0.cl_email AS cl_email_9
FROM
  client t0
WHERE
  t0.code_client = ?
  AND t0.cle_securite = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cl_nom AS cl_nom_2, t0.cl_logo AS cl_logo_3, t0.signature_options AS signature_options_4, t0.code_client AS code_client_5, t0.cle_securite AS cle_securite_6, t0.account AS account_7, t0.serveur AS serveur_8, t0.cl_email AS cl_email_9 FROM client t0 WHERE t0.code_client = 'CAR-E' AND t0.cle_securite = '747931379402' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 110)
4	App\Service\Fonction::fctGetClient (line 584)
5	App\Controller\DataController->refreshFichiersignature (line 182)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.04 ms

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.en_test AS en_test_8, t0.fichier_id AS fichier_id_9 FROM fichiersignature t0 WHERE t0.id = ?

Parameters:

[
  "101"
]

View formatted query View runnable query Explain query View query backtrace

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.en_test AS en_test_8,
  t0.fichier_id AS fichier_id_9
FROM
  fichiersignature t0
WHERE
  t0.id = ?

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.en_test AS en_test_8, t0.fichier_id AS fichier_id_9 FROM fichiersignature t0 WHERE t0.id = '101';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 589)
6	App\Controller\DataController->refreshFichiersignature (line 182)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.10 ms

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.en_test AS en_test_15, t7.fichier_id AS fichier_id_16 FROM fichier t0 LEFT JOIN fichiersignature t7 ON t7.fichier_id = t0.id WHERE t0.id = ?

Parameters:

[
  81
]

View formatted query View runnable query Explain query View query backtrace

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.en_test AS en_test_15,
  t7.fichier_id AS fichier_id_16
FROM
  fichier t0
  LEFT JOIN fichiersignature t7 ON t7.fichier_id = t0.id
WHERE
  t0.id = ?

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.en_test AS en_test_15, t7.fichier_id AS fichier_id_16 FROM fichier t0 LEFT JOIN fichiersignature t7 ON t7.fichier_id = t0.id WHERE t0.id = 81;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Fichier->__get (line 51)
8	App\Entity\Fichier->getFiPDF (line 411)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 112)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 142)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 190)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 159)
13	Symfony\Component\Serializer\Serializer->normalize (line 224)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 159)
15	Symfony\Component\Serializer\Serializer->normalize (line 138)
16	Symfony\Component\Serializer\Serializer->serialize (line 604)
17	App\Controller\DataController->refreshFichiersignature (line 182)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.04 ms

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.fichiersignature_id = ?

Parameters:

[
  101
]

View formatted query View runnable query Explain query View query backtrace

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.fichiersignature_id = ?

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.fichiersignature_id = 101;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 176)
8	Symfony\Component\Serializer\Serializer->normalize (line 224)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 159)
10	Symfony\Component\Serializer\Serializer->normalize (line 138)
11	Symfony\Component\Serializer\Serializer->serialize (line 604)
12	App\Controller\DataController->refreshFichiersignature (line 182)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

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\Client	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\Fichiersignaturetiers	No errors.

Symfony Profiler

POST https://gexsign.app/data/getFichiersignature/101

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping