Symfony Profiler

Query Metrics

15 Database Queries

6 Different statements

154.24 ms Query time

0 Invalid entities

32 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

105.50 ms
(68.40%)

SELECT DISTINCT b0_.id AS id_0, b0_.amount AS amount_1 FROM billet b0_ INNER JOIN ticket_visibility t1_ ON (t1_.billet_id = b0_.id AND t1_.is_visible = 1 AND t1_.role IN (?, ?)) WHERE b0_.created_at >= ? AND b0_.created_at <= ?

Parameters:

[
  "ROLE_MAIRE"
  "ROLE_USER"
  "2026-07-06 00:00:00"
  "2026-07-06 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.amount AS amount_1
FROM
  billet b0_
  INNER JOIN ticket_visibility t1_ ON (
    t1_.billet_id = b0_.id
    AND t1_.is_visible = 1
    AND t1_.role IN (?, ?)
  )
WHERE
  b0_.created_at >= ?
  AND b0_.created_at <= ?

SELECT DISTINCT b0_.id AS id_0, b0_.amount AS amount_1 FROM billet b0_ INNER JOIN ticket_visibility t1_ ON (t1_.billet_id = b0_.id AND t1_.is_visible = 1 AND t1_.role IN ('ROLE_MAIRE', 'ROLE_USER')) WHERE b0_.created_at >= '2026-07-06 00:00:00' AND b0_.created_at <= '2026-07-06 23:59:59';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Service\TicketService->getTicket (line 187)
7	App\Controller\TicketController->find (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

36.46 ms
(23.64%)

SELECT DISTINCT b0_.id AS id_0, b0_.reference AS reference_1, b0_.created_at AS created_at_2, b0_.validity AS validity_3, b0_.vehicle_type AS vehicle_type_4, b0_.amount AS amount_5, b0_.identifier_mode AS identifier_mode_6, b0_.created_by_id AS created_by_id_7, b0_.motor_id AS motor_id_8, b0_.person_id AS person_id_9, b0_.terminal_id AS terminal_id_10, b0_.parking_id AS parking_id_11, b0_.voiture_id AS voiture_id_12 FROM billet b0_ INNER JOIN ticket_visibility t1_ ON (t1_.billet_id = b0_.id AND t1_.is_visible = 1 AND t1_.role IN (?, ?)) WHERE b0_.created_at >= ? AND b0_.created_at <= ? ORDER BY b0_.created_at DESC LIMIT 10

Parameters:

[
  "ROLE_MAIRE"
  "ROLE_USER"
  "2026-07-06 00:00:00"
  "2026-07-06 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.reference AS reference_1,
  b0_.created_at AS created_at_2,
  b0_.validity AS validity_3,
  b0_.vehicle_type AS vehicle_type_4,
  b0_.amount AS amount_5,
  b0_.identifier_mode AS identifier_mode_6,
  b0_.created_by_id AS created_by_id_7,
  b0_.motor_id AS motor_id_8,
  b0_.person_id AS person_id_9,
  b0_.terminal_id AS terminal_id_10,
  b0_.parking_id AS parking_id_11,
  b0_.voiture_id AS voiture_id_12
FROM
  billet b0_
  INNER JOIN ticket_visibility t1_ ON (
    t1_.billet_id = b0_.id
    AND t1_.is_visible = 1
    AND t1_.role IN (?, ?)
  )
WHERE
  b0_.created_at >= ?
  AND b0_.created_at <= ?
ORDER BY
  b0_.created_at DESC
LIMIT
  10

SELECT DISTINCT b0_.id AS id_0, b0_.reference AS reference_1, b0_.created_at AS created_at_2, b0_.validity AS validity_3, b0_.vehicle_type AS vehicle_type_4, b0_.amount AS amount_5, b0_.identifier_mode AS identifier_mode_6, b0_.created_by_id AS created_by_id_7, b0_.motor_id AS motor_id_8, b0_.person_id AS person_id_9, b0_.terminal_id AS terminal_id_10, b0_.parking_id AS parking_id_11, b0_.voiture_id AS voiture_id_12 FROM billet b0_ INNER JOIN ticket_visibility t1_ ON (t1_.billet_id = b0_.id AND t1_.is_visible = 1 AND t1_.role IN ('ROLE_MAIRE', 'ROLE_USER')) WHERE b0_.created_at >= '2026-07-06 00:00:00' AND b0_.created_at <= '2026-07-06 23:59:59' ORDER BY b0_.created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\TicketService->getTicket (line 206)
7	App\Controller\TicketController->find (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

8.86 ms
(5.74%)

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = ?

Parameters:

[
  5235
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 5235;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Motor::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Motor->__get (line 153)
7	App\Entity\Motor->getChasis (line 71)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 115)
11	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 228)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Serializer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->normalize (line 170)
18	Symfony\Component\Serializer\Serializer->normalize (line 170)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
22	App\Controller\TicketController->find (line 35)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.60 ms
(1.04%)

SELECT t0.id AS id_1, t0.firs_name AS firs_name_2, t0.last_name AS last_name_3, t0.location AS location_4, t0.phone_number AS phone_number_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.details_status AS details_status_8 FROM driver t0 WHERE t0.id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firs_name AS firs_name_2,
  t0.last_name AS last_name_3,
  t0.location AS location_4,
  t0.phone_number AS phone_number_5,
  t0.created_at AS created_at_6,
  t0.status AS status_7,
  t0.details_status AS details_status_8
FROM
  driver t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firs_name AS firs_name_2, t0.last_name AS last_name_3, t0.location AS location_4, t0.phone_number AS phone_number_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.details_status AS details_status_8 FROM driver t0 WHERE t0.id = 28;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Driver::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Driver->__get (line 153)
7	App\Entity\Driver->getFirsName (line 62)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 115)
11	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 228)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Serializer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->normalize (line 170)
18	Symfony\Component\Serializer\Serializer->normalize (line 170)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
22	App\Controller\TicketController->find (line 35)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.09 ms
(0.70%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = ? LIMIT 1

Parameters:

[
  "mairie@"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = 'mairie@' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.72 ms
(0.47%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 19;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\User->__get (line 153)
7	App\Entity\User->getFirstName (line 155)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 115)
11	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 228)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Serializer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->normalize (line 170)
18	Symfony\Component\Serializer\Serializer->normalize (line 170)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 153)
22	App\Controller\TicketController->find (line 35)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Billet	10
App\Entity\Motor	10
App\Entity\User	6
App\Entity\MotorMarque	3
App\Entity\City	1
App\Entity\Driver	1
App\Entity\Terminal	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\City	No errors.
App\Entity\Parking	No errors.
App\Entity\FonctionHistory	No errors.
App\Entity\Terminal	No errors.
App\Entity\Motor	No errors.
App\Entity\MotorMarque	No errors.
App\Entity\Billet	No errors.
App\Entity\TicketVisibility	No errors.
App\Entity\Driver	No errors.
App\Entity\Voiture	No errors.

Symfony Profiler

POST https://kms-rdc.net/api/ticket/find

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping