Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.33 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

1.65 ms

SELECT t0.id AS id_1, t0.role AS role_2, t0.fName AS fName_3, t0.lName AS lName_4, t0.email AS email_5, t0.createdAt AS createdAt_6, t0.password AS password_7, t0.is_enabled AS is_enabled_8, t0.last_login AS last_login_9, t0.token AS token_10, t0.sex AS sex_11, t0.profile_id AS profile_id_12, t13.id AS id_14, t13.code AS code_15, t13.description AS description_16, t0.photo_id AS photo_id_17 FROM Users t0 LEFT JOIN Profiles t13 ON t0.profile_id = t13.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.fName AS fName_3,
  t0.lName AS lName_4,
  t0.email AS email_5,
  t0.createdAt AS createdAt_6,
  t0.password AS password_7,
  t0.is_enabled AS is_enabled_8,
  t0.last_login AS last_login_9,
  t0.token AS token_10,
  t0.sex AS sex_11,
  t0.profile_id AS profile_id_12,
  t13.id AS id_14,
  t13.code AS code_15,
  t13.description AS description_16,
  t0.photo_id AS photo_id_17
FROM
  Users t0
  LEFT JOIN Profiles t13 ON t0.profile_id = t13.id

SELECT t0.id AS id_1, t0.role AS role_2, t0.fName AS fName_3, t0.lName AS lName_4, t0.email AS email_5, t0.createdAt AS createdAt_6, t0.password AS password_7, t0.is_enabled AS is_enabled_8, t0.last_login AS last_login_9, t0.token AS token_10, t0.sex AS sex_11, t0.profile_id AS profile_id_12, t13.id AS id_14, t13.code AS code_15, t13.description AS description_16, t0.photo_id AS photo_id_17 FROM Users t0 LEFT JOIN Profiles t13 ON t0.profile_id = t13.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 57)
6	App\Controller\WaitingHomeController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.15 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM Roles t0 INNER JOIN profiles_roles ON t0.id = profiles_roles.roles_id WHERE profiles_roles.profiles_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4
FROM
  Roles t0
  INNER JOIN profiles_roles ON t0.id = profiles_roles.roles_id
WHERE
  profiles_roles.profiles_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM Roles t0 INNER JOIN profiles_roles ON t0.id = profiles_roles.roles_id WHERE profiles_roles.profiles_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2587)
5	Doctrine\ORM\UnitOfWork->createEntity (line 264)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 434)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 912)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
11	Doctrine\ORM\EntityRepository->findBy (line 72)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
13	Doctrine\ORM\EntityRepository->findAll (line 57)
14	App\Controller\WaitingHomeController->index (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)

0.53 ms

SELECT t0.item AS item_1, t0.value AS value_2, t0.locale AS locale_3, t0.translations AS translations_4, t0.data_type AS data_type_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by_id AS created_by_id_9, t0.files_id AS files_id_10 FROM static_data_store t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.item AS item_1,
  t0.value AS value_2,
  t0.locale AS locale_3,
  t0.translations AS translations_4,
  t0.data_type AS data_type_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by_id AS created_by_id_9,
  t0.files_id AS files_id_10
FROM
  static_data_store t0

SELECT t0.item AS item_1, t0.value AS value_2, t0.locale AS locale_3, t0.translations AS translations_4, t0.data_type AS data_type_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by_id AS created_by_id_9, t0.files_id AS files_id_10 FROM static_data_store t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 81)
6	SDataEBundle\Service\AppStaticDataStore->load (line 56)
7	SDataEBundle\Service\AppStaticDataStore->getTranslatedData (line 25)
8	SDataEBundle\Contract\StaticData->getTranslatedData (line 57)
9	SDataEBundle\Twig\SDataEVariable->getGlobals (line 365)
10	Twig\ExtensionSet->getGlobals (line 908)
11	Twig\Environment->getGlobals (line 398)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
20	App\Controller\WaitingHomeController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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

0 Hits

0 Misses

0 Puts

Entities Mapping

Class	Mapping errors
App\Entity\Users	No errors.
App\Entity\Profiles	No errors.
App\Entity\File\File	No errors.
App\Entity\File\Picture	No errors.
App\Entity\Roles	No errors.
SDataEBundle\Entity\StaticDataStore	No errors.
App\Entity\File\Biblios	No errors.

Symfony Profiler

GET https://wadagnitalata.olasoft.net/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping