Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.00 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

organisation connection

Time▼

Count

Info

0.31 ms
(30.71%)

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.full_name AS full_name_5, t0.email AS email_6, t0.password AS password_7, t0.token AS token_8, t0.locked AS locked_9, t0.last_login AS last_login_10, t0.roles AS roles_11, t0.uuid AS uuid_12 FROM user t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.full_name AS full_name_5,
  t0.email AS email_6,
  t0.password AS password_7,
  t0.token AS token_8,
  t0.locked AS locked_9,
  t0.last_login AS last_login_10,
  t0.roles AS roles_11,
  t0.uuid AS uuid_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.full_name AS full_name_5, t0.email AS email_6, t0.password AS password_7, t0.token AS token_8, t0.locked AS locked_9, t0.last_login AS last_login_10, t0.roles AS roles_11, t0.uuid AS uuid_12 FROM user t0 WHERE t0.id = 3;

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

commun connection

Time▼

Count

Info

0.36 ms
(36.18%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.telephone AS telephone_4, t0.fax AS fax_5, t0.email AS email_6, t0.yonomi_org_id AS yonomi_org_id_7, t0.yonomi_site_id AS yonomi_site_id_8, t0.locked AS locked_9, t0.structure_etat AS structure_etat_10, t0.nature AS nature_11, t0.adresse AS adresse_12, t0.adresse_comp AS adresse_comp_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.canton AS canton_16, t0.arrondissement AS arrondissement_17, t0.departement AS departement_18, t0.pays AS pays_19, t0.deleted_at AS deleted_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.uuid AS uuid_23 FROM allsoft_multitenant_organisation t0 WHERE t0.reference = ? LIMIT 1

Parameters:

[
  "admin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.raison_sociale AS raison_sociale_3,
  t0.telephone AS telephone_4,
  t0.fax AS fax_5,
  t0.email AS email_6,
  t0.yonomi_org_id AS yonomi_org_id_7,
  t0.yonomi_site_id AS yonomi_site_id_8,
  t0.locked AS locked_9,
  t0.structure_etat AS structure_etat_10,
  t0.nature AS nature_11,
  t0.adresse AS adresse_12,
  t0.adresse_comp AS adresse_comp_13,
  t0.code_postal AS code_postal_14,
  t0.ville AS ville_15,
  t0.canton AS canton_16,
  t0.arrondissement AS arrondissement_17,
  t0.departement AS departement_18,
  t0.pays AS pays_19,
  t0.deleted_at AS deleted_at_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.uuid AS uuid_23
FROM
  allsoft_multitenant_organisation t0
WHERE
  t0.reference = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.telephone AS telephone_4, t0.fax AS fax_5, t0.email AS email_6, t0.yonomi_org_id AS yonomi_org_id_7, t0.yonomi_site_id AS yonomi_site_id_8, t0.locked AS locked_9, t0.structure_etat AS structure_etat_10, t0.nature AS nature_11, t0.adresse AS adresse_12, t0.adresse_comp AS adresse_comp_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.canton AS canton_16, t0.arrondissement AS arrondissement_17, t0.departement AS departement_18, t0.pays AS pays_19, t0.deleted_at AS deleted_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.uuid AS uuid_23 FROM allsoft_multitenant_organisation t0 WHERE t0.reference = 'admin' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
6	Allsoftware\MultitenantBundle\Repository\OrganisationRepository->findFromCurrentCname (line 38)
7	Allsoftware\MultitenantBundle\Service\OrganisationService->getCurrentOrganisation (line 28)
8	App\Controller\BaseController->__construct (line 29)
9	ContainerXV3J4MH\getOrganisationControllerService->do (line 28)
10	ContainerXV3J4MH\App_KernelDevDebugContainer::load (line 1018)
11	Symfony\Component\DependencyInjection\Container->make (line 221)
12	Symfony\Component\DependencyInjection\Container::get (line 203)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.33 ms
(33.11%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.telephone AS telephone_4, t0.fax AS fax_5, t0.email AS email_6, t0.yonomi_org_id AS yonomi_org_id_7, t0.yonomi_site_id AS yonomi_site_id_8, t0.locked AS locked_9, t0.structure_etat AS structure_etat_10, t0.nature AS nature_11, t0.adresse AS adresse_12, t0.adresse_comp AS adresse_comp_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.canton AS canton_16, t0.arrondissement AS arrondissement_17, t0.departement AS departement_18, t0.pays AS pays_19, t0.deleted_at AS deleted_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.uuid AS uuid_23 FROM allsoft_multitenant_organisation t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  b"\x01ž gý{ã—Â¿\x1E\x00\en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.raison_sociale AS raison_sociale_3,
  t0.telephone AS telephone_4,
  t0.fax AS fax_5,
  t0.email AS email_6,
  t0.yonomi_org_id AS yonomi_org_id_7,
  t0.yonomi_site_id AS yonomi_site_id_8,
  t0.locked AS locked_9,
  t0.structure_etat AS structure_etat_10,
  t0.nature AS nature_11,
  t0.adresse AS adresse_12,
  t0.adresse_comp AS adresse_comp_13,
  t0.code_postal AS code_postal_14,
  t0.ville AS ville_15,
  t0.canton AS canton_16,
  t0.arrondissement AS arrondissement_17,
  t0.departement AS departement_18,
  t0.pays AS pays_19,
  t0.deleted_at AS deleted_at_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.uuid AS uuid_23
FROM
  allsoft_multitenant_organisation t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.telephone AS telephone_4, t0.fax AS fax_5, t0.email AS email_6, t0.yonomi_org_id AS yonomi_org_id_7, t0.yonomi_site_id AS yonomi_site_id_8, t0.locked AS locked_9, t0.structure_etat AS structure_etat_10, t0.nature AS nature_11, t0.adresse AS adresse_12, t0.adresse_comp AS adresse_comp_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.canton AS canton_16, t0.arrondissement AS arrondissement_17, t0.departement AS departement_18, t0.pays AS pays_19, t0.deleted_at AS deleted_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.uuid AS uuid_23 FROM allsoft_multitenant_organisation t0 WHERE t0.uuid = 0x019E208167FD7BE397C2BF1E8F001B6E LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
9	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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)

Database Connections

Name	Service
organisation	doctrine.dbal.organisation_connection
commun	doctrine.dbal.commun_connection

Entity Managers

Name	Service
organisation	doctrine.orm.organisation_entity_manager
commun	doctrine.orm.commun_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

organisation entity manager

Class	Amount of managed objects
App\Entity\User	1

commun entity manager

Class	Amount of managed objects
Allsoftware\MultitenantBundle\Entity\Organisation	2

Entities Mapping

organisation entity manager

Class	Mapping errors
App\Entity\User	No errors.

commun entity manager

Class	Mapping errors
Allsoftware\MultitenantBundle\Entity\Organisation	No errors.

Symfony Profiler

GET https://admin.loic.allsoftware.work/organisation/019e2081-67fd-7be3-97c2-bf1e8f001b6e

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

organisation connection

commun connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

organisation entity manager

commun entity manager

Entities Mapping

organisation entity manager

commun entity manager