Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

27.92 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

26.66 ms
(95.47%)

SELECT g0_.id AS id_0, g0_.latitude AS latitude_1, g0_.longitude AS longitude_2, g0_.vitesse AS vitesse_3, g0_.altitude AS altitude_4, g0_.date_donnees AS date_donnees_5, g0_.date_create AS date_create_6, g0_.etat_roule AS etat_roule_7, g0_.nombre_satelite AS nombre_satelite_8, g0_.tension_batterie AS tension_batterie_9, g0_.balise_gps_id AS balise_gps_id_10 FROM gps_donnee g0_ LEFT JOIN gps_balise g1_ ON g0_.balise_gps_id = g1_.id WHERE (g0_.date_donnees BETWEEN ? AND ?) AND g1_.num_imei = ? ORDER BY g0_.date_donnees ASC

Parameters:

[
  "2026-01-10 00:00:00"
  "2026-01-10 23:59:59"
  "2147483647"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.latitude AS latitude_1,
  g0_.longitude AS longitude_2,
  g0_.vitesse AS vitesse_3,
  g0_.altitude AS altitude_4,
  g0_.date_donnees AS date_donnees_5,
  g0_.date_create AS date_create_6,
  g0_.etat_roule AS etat_roule_7,
  g0_.nombre_satelite AS nombre_satelite_8,
  g0_.tension_batterie AS tension_batterie_9,
  g0_.balise_gps_id AS balise_gps_id_10
FROM
  gps_donnee g0_
  LEFT JOIN gps_balise g1_ ON g0_.balise_gps_id = g1_.id
WHERE
  (
    g0_.date_donnees BETWEEN ?
    AND ?
  )
  AND g1_.num_imei = ?
ORDER BY
  g0_.date_donnees ASC

SELECT g0_.id AS id_0, g0_.latitude AS latitude_1, g0_.longitude AS longitude_2, g0_.vitesse AS vitesse_3, g0_.altitude AS altitude_4, g0_.date_donnees AS date_donnees_5, g0_.date_create AS date_create_6, g0_.etat_roule AS etat_roule_7, g0_.nombre_satelite AS nombre_satelite_8, g0_.tension_batterie AS tension_batterie_9, g0_.balise_gps_id AS balise_gps_id_10 FROM gps_donnee g0_ LEFT JOIN gps_balise g1_ ON g0_.balise_gps_id = g1_.id WHERE (g0_.date_donnees BETWEEN '2026-01-10 00:00:00' AND '2026-01-10 23:59:59') AND g1_.num_imei = '2147483647' ORDER BY g0_.date_donnees ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 52)
7	App\Repository\Gps\DonneeGPSRepository->findGroupedTrajetsByImeiAndDate (line 143)
8	App\Controller\Gps\DonneeGPSController->getGpsByDate (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.64 ms
(2.31%)

SELECT g0_.id AS id_0, g0_.num_imei AS num_imei_1, g0_.immat AS immat_2 FROM gps_balise g0_ WHERE g0_.num_imei = ?

Parameters:

[
  "2147483647"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.num_imei AS num_imei_1,
  g0_.immat AS immat_2
FROM
  gps_balise g0_
WHERE
  g0_.num_imei = ?

SELECT g0_.id AS id_0, g0_.num_imei AS num_imei_1, g0_.immat AS immat_2 FROM gps_balise g0_ WHERE g0_.num_imei = '2147483647';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 40)
7	App\Repository\Gps\BaliseGPSRepository->getByIMEI (line 133)
8	App\Controller\Gps\DonneeGPSController->getGpsByDate (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.33 ms
(1.17%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_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.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.taux_horaire AS taux_horaire_5,
  t0.roles AS roles_6,
  t0.password AS password_7
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 347)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 138)
15	App\Controller\Gps\DonneeGPSController->getGpsByDate (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.29 ms
(1.05%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 INNER JOIN gps_balise_user ON t0.id = gps_balise_user.user_id WHERE gps_balise_user.balise_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.taux_horaire AS taux_horaire_5,
  t0.roles AS roles_6,
  t0.password AS password_7
FROM
  `user` t0
  INNER JOIN gps_balise_user ON t0.id = gps_balise_user.user_id
WHERE
  gps_balise_user.balise_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 INNER JOIN gps_balise_user ON t0.id = gps_balise_user.user_id WHERE gps_balise_user.balise_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 68)
7	Doctrine\Common\Collections\AbstractLazyCollection->contains (line 361)
8	Doctrine\ORM\PersistentCollection->contains (line 139)
9	App\Controller\Gps\DonneeGPSController->getGpsByDate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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\Gps\BaliseGPS	No errors.
App\Entity\User	No errors.
App\Entity\Gps\Pointage	No errors.
App\Entity\Gps\Absence	No errors.
App\Entity\Gps\DonneeGPS	No errors.

Symfony Profiler

GET https://coupinade.fr/gps/points/imei/2026-01-10?imei=2147483647

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping