Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

6.57 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.83 ms
(27.85%)

SELECT t0.name AS name_1, t0.code AS code_2, t0.types AS types_3, t0.address AS address_4, t0.city AS city_5, t0.postal_code AS postal_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.website AS website_9, t0.logo AS logo_10, t0.director AS director_11, t0.slogan AS slogan_12, t0.tenant_key AS tenant_key_13, t0.due_day_at AS due_day_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.is_active AS is_active_19 FROM establishments t0 INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id WHERE user_establishments.user_id = ?

Parameters:

[
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.code AS code_2,
  t0.types AS types_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.postal_code AS postal_code_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.website AS website_9,
  t0.logo AS logo_10,
  t0.director AS director_11,
  t0.slogan AS slogan_12,
  t0.tenant_key AS tenant_key_13,
  t0.due_day_at AS due_day_at_14,
  t0.id AS id_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.deleted_at AS deleted_at_18,
  t0.is_active AS is_active_19
FROM
  establishments t0
  INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id
WHERE
  user_establishments.user_id = ?

SELECT t0.name AS name_1, t0.code AS code_2, t0.types AS types_3, t0.address AS address_4, t0.city AS city_5, t0.postal_code AS postal_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.website AS website_9, t0.logo AS logo_10, t0.director AS director_11, t0.slogan AS slogan_12, t0.tenant_key AS tenant_key_13, t0.due_day_at AS due_day_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.is_active AS is_active_19 FROM establishments t0 INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id WHERE user_establishments.user_id = '019cd0ec-7eee-7412-9ac2-b8f3d874390d';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->first (line 169)
7	Doctrine\ORM\PersistentCollection->first (line 518)
8	App\Adapters\Primary\Http\Controller\Establishment\TrackingController->getCurrentEstablishmentId (line 130)
9	App\Adapters\Primary\Http\Controller\Establishment\TrackingController->log (line 39)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

1.64 ms
(24.95%)

INSERT INTO trackings (action, entity_type, entity_id, details, old_value, new_value, ip_address, user_agent, id, created_at, updated_at, establishment_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "page_view"
  "page"
  "/establishment/students"
  "{"url":"https:\/\/ianatra.mypreprod.xyz\/establishment\/students","path":"\/establishment\/students","referrer":"https:\/\/ianatra.mypreprod.xyz\/login","title":"\u00c9l\u00e8ves - \u00c9tablissement"}"
  null
  null
  "102.17.37.153"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0"
  "019ecec7-24b2-71f4-99fe-6ebd7e6c06e5"
  "2026-06-16 04:53:38"
  "2026-06-16 04:53:38"
  "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO trackings (
  action, entity_type, entity_id, details,
  old_value, new_value, ip_address,
  user_agent, id, created_at, updated_at,
  establishment_id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO trackings (action, entity_type, entity_id, details, old_value, new_value, ip_address, user_agent, id, created_at, updated_at, establishment_id, user_id) VALUES ('page_view', 'page', '/establishment/students', '{\"url\":\"https:\\/\\/ianatra.mypreprod.xyz\\/establishment\\/students\",\"path\":\"\\/establishment\\/students\",\"referrer\":\"https:\\/\\/ianatra.mypreprod.xyz\\/login\",\"title\":\"\\u00c9l\\u00e8ves - \\u00c9tablissement\"}', NULL, NULL, '102.17.37.153', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 Edg/148.0.0.0', '019ecec7-24b2-71f4-99fe-6ebd7e6c06e5', '2026-06-16 04:53:38', '2026-06-16 04:53:38', '019c6bc6-7a9f-74a1-8839-c09403fb8f9b', '019cd0ec-7eee-7412-9ac2-b8f3d874390d');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Adapters\Secondary\Doctrine\Repository\Tracking\TrackingRepository->save (line 53)
7	App\Adapters\Primary\Http\Controller\Establishment\TrackingController->log (line 66)
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)

1.58 ms
(24.05%)

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = ?

Parameters:

[
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.gender AS gender_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.is_active AS is_active_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = '019cd0ec-7eee-7412-9ac2-b8f3d874390d';

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

1.03 ms
(15.71%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Adapters\Secondary\Doctrine\Repository\Tracking\TrackingRepository->save (line 53)
4	App\Adapters\Primary\Http\Controller\Establishment\TrackingController->log (line 66)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.49 ms
(7.44%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Adapters\Secondary\Doctrine\Repository\Tracking\TrackingRepository->save (line 53)
4	App\Adapters\Primary\Http\Controller\Establishment\TrackingController->log (line 66)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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\Adapters\Secondary\Doctrine\Entity\User	1
App\Adapters\Secondary\Doctrine\Entity\Establishment	1
App\Adapters\Secondary\Doctrine\Entity\Tracking	1

Entities Mapping

Class	Mapping errors
App\Adapters\Secondary\Doctrine\Entity\User	No errors.
App\Adapters\Secondary\Doctrine\Entity\Establishment	No errors.
App\Adapters\Secondary\Doctrine\Entity\AcademicYear	No errors.
App\Adapters\Secondary\Doctrine\Entity\Tracking	No errors.

Symfony Profiler

POST https://ianatra.mypreprod.xyz/establishment/tracking/log

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping