Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.13 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.73 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.mdp AS mdp_4, t0.role AS role_5, t0.ip_vpn AS ip_vpn_6, t0.acreer AS acreer_7, t0.user_samba AS user_samba_8, t0.pass_samba AS pass_samba_9, t0.token_reinit AS token_reinit_10, t0.email AS email_11, t0.la_clinique_id AS la_clinique_id_12 FROM user t0 WHERE t0.id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.mdp AS mdp_4,
  t0.role AS role_5,
  t0.ip_vpn AS ip_vpn_6,
  t0.acreer AS acreer_7,
  t0.user_samba AS user_samba_8,
  t0.pass_samba AS pass_samba_9,
  t0.token_reinit AS token_reinit_10,
  t0.email AS email_11,
  t0.la_clinique_id AS la_clinique_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.mdp AS mdp_4, t0.role AS role_5, t0.ip_vpn AS ip_vpn_6, t0.acreer AS acreer_7, t0.user_samba AS user_samba_8, t0.pass_samba AS pass_samba_9, t0.token_reinit AS token_reinit_10, t0.email AS email_11, t0.la_clinique_id AS la_clinique_id_12 FROM user t0 WHERE t0.id = 25;

#	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 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 368)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 306)
14	App\Controller\ConverterController->exporterEnJPEG (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

1.41 ms

SELECT t0.id AS id_1, t0.date_upload AS date_upload_2, t0.heure_upload AS heure_upload_3, t0.proprietaire_animal AS proprietaire_animal_4, t0.modalite AS modalite_5, t0.format AS format_6, t0.les_fichiers AS les_fichiers_7, t0.autopdf AS autopdf_8, t0.chemin_pdf AS chemin_pdf_9, t0.username AS username_10, t0.nom_pdf AS nom_pdf_11, t0.la_clinique_id AS la_clinique_id_12, t0.le_sr_id AS le_sr_id_13 FROM fichier t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "13731"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_upload AS date_upload_2,
  t0.heure_upload AS heure_upload_3,
  t0.proprietaire_animal AS proprietaire_animal_4,
  t0.modalite AS modalite_5,
  t0.format AS format_6,
  t0.les_fichiers AS les_fichiers_7,
  t0.autopdf AS autopdf_8,
  t0.chemin_pdf AS chemin_pdf_9,
  t0.username AS username_10,
  t0.nom_pdf AS nom_pdf_11,
  t0.la_clinique_id AS la_clinique_id_12,
  t0.le_sr_id AS le_sr_id_13
FROM
  fichier t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_upload AS date_upload_2, t0.heure_upload AS heure_upload_3, t0.proprietaire_animal AS proprietaire_animal_4, t0.modalite AS modalite_5, t0.format AS format_6, t0.les_fichiers AS les_fichiers_7, t0.autopdf AS autopdf_8, t0.chemin_pdf AS chemin_pdf_9, t0.username AS username_10, t0.nom_pdf AS nom_pdf_11, t0.la_clinique_id AS la_clinique_id_12, t0.le_sr_id AS le_sr_id_13 FROM fichier t0 WHERE t0.id = '13731' 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 312)
4	App\Controller\ConverterController->exporterEnJPEG (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\User	No errors.
App\Entity\Clinique	The field 'App\Entity\Clinique#id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Fichier	No errors.
App\Entity\FichierSR	No errors.

Symfony Profiler

GET https://xplorer.atimaweb.fr/projet1/public/index.php/radio/exporter_en_jpeg/13731

Configuration Settings

Theme