Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.64 ms Query time

3 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.47 ms
(72.81%)

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.email AS email_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.17 ms
(27.19%)

SELECT t0.id AS id_1, t0.numero_physique AS numero_physique_2, t0.libelle_compteur AS libelle_compteur_3, t0.emplacement_compteur AS emplacement_compteur_4, t0.compteur_accessible AS compteur_accessible_5, t0.commentaire AS commentaire_6, t0.email AS email_7, t0.tel1 AS tel1_8, t0.tel2 AS tel2_9, t0.numero_client AS numero_client_10, t0.civilite AS civilite_11, t0.nom AS nom_12, t0.numero_rue AS numero_rue_13, t0.titre_rue AS titre_rue_14, t0.nom_rue AS nom_rue_15, t0.quartier AS quartier_16, t0.code_postal AS code_postal_17, t0.ville AS ville_18, t0.module_seul AS module_seul_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.locked AS locked_22, t0.first AS first_23, t0.selected AS selected_24, t0.search AS search_25, t0.etatcomm AS etatcomm_26, t0.cluster1 AS cluster1_27, t0.cluster2 AS cluster2_28, t0.cluster3 AS cluster3_29, t0.cluster4 AS cluster4_30, t0.cluster5 AS cluster5_31, t0.location_lat_long AS location_lat_long_32, t0.remarque AS remarque_33, t0.alerte AS alerte_34, t0.mission_id AS mission_id_35, t0.creneau_id AS creneau_id_36, t0.etat_id AS etat_id_37, t0.opertaion_id AS opertaion_id_38, t0.agent_id AS agent_id_39 FROM point t0 WHERE t0.id = ?

Parameters:

[
  38229
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero_physique AS numero_physique_2,
  t0.libelle_compteur AS libelle_compteur_3,
  t0.emplacement_compteur AS emplacement_compteur_4,
  t0.compteur_accessible AS compteur_accessible_5,
  t0.commentaire AS commentaire_6,
  t0.email AS email_7,
  t0.tel1 AS tel1_8,
  t0.tel2 AS tel2_9,
  t0.numero_client AS numero_client_10,
  t0.civilite AS civilite_11,
  t0.nom AS nom_12,
  t0.numero_rue AS numero_rue_13,
  t0.titre_rue AS titre_rue_14,
  t0.nom_rue AS nom_rue_15,
  t0.quartier AS quartier_16,
  t0.code_postal AS code_postal_17,
  t0.ville AS ville_18,
  t0.module_seul AS module_seul_19,
  t0.latitude AS latitude_20,
  t0.longitude AS longitude_21,
  t0.locked AS locked_22,
  t0.first AS first_23,
  t0.selected AS selected_24,
  t0.search AS search_25,
  t0.etatcomm AS etatcomm_26,
  t0.cluster1 AS cluster1_27,
  t0.cluster2 AS cluster2_28,
  t0.cluster3 AS cluster3_29,
  t0.cluster4 AS cluster4_30,
  t0.cluster5 AS cluster5_31,
  t0.location_lat_long AS location_lat_long_32,
  t0.remarque AS remarque_33,
  t0.alerte AS alerte_34,
  t0.mission_id AS mission_id_35,
  t0.creneau_id AS creneau_id_36,
  t0.etat_id AS etat_id_37,
  t0.opertaion_id AS opertaion_id_38,
  t0.agent_id AS agent_id_39
FROM
  point t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_physique AS numero_physique_2, t0.libelle_compteur AS libelle_compteur_3, t0.emplacement_compteur AS emplacement_compteur_4, t0.compteur_accessible AS compteur_accessible_5, t0.commentaire AS commentaire_6, t0.email AS email_7, t0.tel1 AS tel1_8, t0.tel2 AS tel2_9, t0.numero_client AS numero_client_10, t0.civilite AS civilite_11, t0.nom AS nom_12, t0.numero_rue AS numero_rue_13, t0.titre_rue AS titre_rue_14, t0.nom_rue AS nom_rue_15, t0.quartier AS quartier_16, t0.code_postal AS code_postal_17, t0.ville AS ville_18, t0.module_seul AS module_seul_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.locked AS locked_22, t0.first AS first_23, t0.selected AS selected_24, t0.search AS search_25, t0.etatcomm AS etatcomm_26, t0.cluster1 AS cluster1_27, t0.cluster2 AS cluster2_28, t0.cluster3 AS cluster3_29, t0.cluster4 AS cluster4_30, t0.cluster5 AS cluster5_31, t0.location_lat_long AS location_lat_long_32, t0.remarque AS remarque_33, t0.alerte AS alerte_34, t0.mission_id AS mission_id_35, t0.creneau_id AS creneau_id_36, t0.etat_id AS etat_id_37, t0.opertaion_id AS opertaion_id_38, t0.agent_id AS agent_id_39 FROM point t0 WHERE t0.id = 38229;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\ClusterAPIController->app_utilisateur_resa (line 1282)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Point	1
App\Entity\Mission	1
App\Entity\Etat	1
App\Entity\Operation	1
App\Entity\Agent	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Logpoint	No errors.
App\Entity\Logetat	No errors.
App\Entity\Point	No errors.
App\Entity\Mission	No errors.
App\Entity\Creneau	No errors.
App\Entity\Etat	No errors.
App\Entity\Operation	No errors.
App\Entity\Agent	No errors.
App\Entity\Cluster	The association App\Entity\Cluster#type refers to the inverse side field App\Entity\ClusterType#clusters which does not exist.
App\Entity\MailPoint	The association App\Entity\MailPoint#mail refers to the inverse side field App\Entity\Mail#mailPoints which does not exist. The association App\Entity\MailPoint#user refers to the inverse side field App\Entity\User#mailPoints which does not exist. The association App\Entity\MailPoint#mission refers to the inverse side field App\Entity\Mission#mailPoints which does not exist.
App\Entity\SmsPoint	The association App\Entity\SmsPoint#user refers to the inverse side field App\Entity\User#smsPoints which does not exist. The association App\Entity\SmsPoint#mission refers to the inverse side field App\Entity\Mission#smsPoints which does not exist. The association App\Entity\SmsPoint#sms refers to the inverse side field App\Entity\SMS#smsPoints which does not exist.
App\Entity\Action	No errors.
App\Entity\MessageType	No errors.
App\Entity\Creneauhoraire	No errors.
App\Entity\SMS	No errors.
App\Entity\Mail	No errors.
App\Entity\ClusterType	No errors.

Symfony Profiler

GET https://www.devz5.com/api/resa/38229/%7B%24creneau_id%7D

Configuration Settings

Theme

Page Width