Symfony Profiler

Query Metrics

10 Database Queries

6 Different statements

4.50 ms Query time

1 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.22 ms
(27.20%)

SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?

Parameters:

[
  "maintenance_mode"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.clef AS clef_1,
  t0.valeur AS valeur_2
FROM
  app_config t0
WHERE
  t0.clef = ?

SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = 'maintenance_mode';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 19)
6	App\Service\AppConfigService->get (line 56)
7	App\EventSubscriber\MaintenanceSubscriber->onKernelRequest (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.87 ms
(19.37%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.enseigne_id AS enseigne_id_3, t0.description AS description_4, t0.position AS position_5, t0.created_at AS created_at_6 FROM hr_unit_type t0 WHERE t0.id = ?

Parameters:

[
  "0cbedaa1-2cd4-43a7-9e36-d28018cc4b7a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.enseigne_id AS enseigne_id_3,
  t0.description AS description_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6
FROM
  hr_unit_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.enseigne_id AS enseigne_id_3, t0.description AS description_4, t0.position AS position_5, t0.created_at AS created_at_6 FROM hr_unit_type t0 WHERE t0.id = '0cbedaa1-2cd4-43a7-9e36-d28018cc4b7a';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():364} (line 472)
5	Proxies\__CG__\App\Entity\HR\UnitType::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():470}:471} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\HR\UnitType->__get (line 46)
8	App\Entity\HR\UnitType->getName (line 853)
9	App\Controller\GestionEnseigne\HR\OrganisationController->buildTree (line 140)
10	App\Controller\GestionEnseigne\HR\OrganisationController->unitsPage (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.75 ms
(16.70%)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.position AS position_3, h0_.path AS path_4, h0_.level AS level_5, h0_.children_count AS children_count_6, h0_.created_at AS created_at_7, h0_.manager_uuid AS manager_uuid_8, h0_.enseigne_id AS enseigne_id_9, h0_.type_entity_id AS type_entity_id_10, h0_.parent_id AS parent_id_11 FROM hr_organizational_unit h0_ WHERE h0_.enseigne_id = ? ORDER BY h0_.path ASC

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.position AS position_3,
  h0_.path AS path_4,
  h0_.level AS level_5,
  h0_.children_count AS children_count_6,
  h0_.created_at AS created_at_7,
  h0_.manager_uuid AS manager_uuid_8,
  h0_.enseigne_id AS enseigne_id_9,
  h0_.type_entity_id AS type_entity_id_10,
  h0_.parent_id AS parent_id_11
FROM
  hr_organizational_unit h0_
WHERE
  h0_.enseigne_id = ?
ORDER BY
  h0_.path ASC

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.position AS position_3, h0_.path AS path_4, h0_.level AS level_5, h0_.children_count AS children_count_6, h0_.created_at AS created_at_7, h0_.manager_uuid AS manager_uuid_8, h0_.enseigne_id AS enseigne_id_9, h0_.type_entity_id AS type_entity_id_10, h0_.parent_id AS parent_id_11 FROM hr_organizational_unit h0_ WHERE h0_.enseigne_id = 46 ORDER BY h0_.path ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 31)
7	App\Repository\HR\OrganizationalUnitRepository->findByEnseigne (line 138)
8	App\Controller\GestionEnseigne\HR\OrganisationController->unitsPage (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.63 ms
(13.94%)

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = ?

Parameters:

[
  "5744ad07-6692-4bf5-aabf-613bece4c3e8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.email AS email_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.telephone AS telephone_5,
  t0.ifu AS ifu_6,
  t0.photo AS photo_7,
  t0.roles AS roles_8,
  t0.position_updated_at AS position_updated_at_9,
  t0.type_compte AS type_compte_10,
  t0.created_at AS created_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.bpay_account AS bpay_account_13,
  t0.business_pay_account AS business_pay_account_14,
  t0.care_concept_account AS care_concept_account_15,
  t0.cashline_account AS cashline_account_16,
  t0.current_lat AS current_lat_17,
  t0.current_lon AS current_lon_18,
  t19.id AS id_20,
  t19.numero_carte AS numero_carte_21,
  t19.points_actuels AS points_actuels_22,
  t19.points_totaux AS points_totaux_23,
  t19.created_at AS created_at_24,
  t19.user_uuid AS user_uuid_25
FROM
  users t0
  LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = '5744ad07-6692-4bf5-aabf-613bece4c3e8';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.53 ms
(11.83%)

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = ? LIMIT 1

Parameters:

[
  "f_singbo@n2a.online"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.email AS email_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.telephone AS telephone_5,
  t0.ifu AS ifu_6,
  t0.photo AS photo_7,
  t0.roles AS roles_8,
  t0.position_updated_at AS position_updated_at_9,
  t0.type_compte AS type_compte_10,
  t0.created_at AS created_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.bpay_account AS bpay_account_13,
  t0.business_pay_account AS business_pay_account_14,
  t0.care_concept_account AS care_concept_account_15,
  t0.cashline_account AS cashline_account_16,
  t0.current_lat AS current_lat_17,
  t0.current_lon AS current_lon_18,
  t19.id AS id_20,
  t19.numero_carte AS numero_carte_21,
  t19.points_actuels AS points_actuels_22,
  t19.points_totaux AS points_totaux_23,
  t19.created_at AS created_at_24,
  t19.user_uuid AS user_uuid_25
FROM
  users t0
  LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = 'f_singbo@n2a.online' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 91)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.49 ms
(10.96%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11 FROM enseignes t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "YLWE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.libelle AS libelle_4,
  t0.main_db_host AS main_db_host_5,
  t0.main_db_name AS main_db_name_6,
  t0.main_db_user AS main_db_user_7,
  t0.main_db_pass AS main_db_pass_8,
  t0.base_url AS base_url_9,
  t0.api_key AS api_key_10,
  t0.dgi_token AS dgi_token_11
FROM
  enseignes t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11 FROM enseignes t0 WHERE t0.code = 'YLWE' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 364)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 275)
5	Doctrine\ORM\EntityRepository->__call (line 129)
6	App\Controller\GestionEnseigne\HR\OrganisationController->unitsPage (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\HR\OrganizationalUnit	9
App\Entity\HR\UnitType	4
App\Entity\AppConfig	2
App\Entity\Users	1
App\Entity\Enseigne	1

Entities Mapping

Class	Mapping errors
App\Entity\AppConfig	No errors.
App\Entity\Users	No errors.
App\Entity\FidelityCard	No errors.
App\Entity\Reward	No errors.
App\Entity\HR\UserOrganizationalUnit	No errors.
App\Entity\Enseigne	No errors.
App\Entity\PointDeVente	No errors.
App\Entity\RewardType	No errors.
App\Entity\RedemptionType	No errors.
App\Entity\HR\OrganizationalUnit	No errors.
App\Entity\HR\UnitType	The field App\Entity\HR\UnitType#units is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HR\OrganizationalUnit#typeEntity does not contain the required 'inversedBy="units"' attribute.

Symfony Profiler

GET https://careconcept-n2a.myn2a.online/organisation/units-page/YLWE

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping