Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

4.62 ms Query time

1 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.55 ms
(33.54%)

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.status AS status_5, c0_.is_active AS is_active_6, s1_.id AS id_7, s1_.name AS name_8, s1_.start_date AS start_date_9, s1_.end_date AS end_date_10, c0_.season_id AS season_id_11, c0_.enseigne_id AS enseigne_id_12, c0_.owner_unit_id AS owner_unit_id_13, s1_.enseigne_id AS enseigne_id_14 FROM campaign c0_ LEFT JOIN season s1_ ON c0_.season_id = s1_.id LEFT JOIN campaign_unit_assignment c2_ ON c0_.id = c2_.campaign_id LEFT JOIN hr_organizational_unit h3_ ON c2_.organizational_unit_id = h3_.id LEFT JOIN hr_user_unit h4_ ON h3_.id = h4_.unit_id LEFT JOIN users u5_ ON h4_.user_uuid = u5_.uuid WHERE c0_.enseigne_id = ? AND u5_.uuid = ? ORDER BY c0_.id DESC

Parameters:

[
  46
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.start_date AS start_date_3,
  c0_.end_date AS end_date_4,
  c0_.status AS status_5,
  c0_.is_active AS is_active_6,
  s1_.id AS id_7,
  s1_.name AS name_8,
  s1_.start_date AS start_date_9,
  s1_.end_date AS end_date_10,
  c0_.season_id AS season_id_11,
  c0_.enseigne_id AS enseigne_id_12,
  c0_.owner_unit_id AS owner_unit_id_13,
  s1_.enseigne_id AS enseigne_id_14
FROM
  campaign c0_
  LEFT JOIN season s1_ ON c0_.season_id = s1_.id
  LEFT JOIN campaign_unit_assignment c2_ ON c0_.id = c2_.campaign_id
  LEFT JOIN hr_organizational_unit h3_ ON c2_.organizational_unit_id = h3_.id
  LEFT JOIN hr_user_unit h4_ ON h3_.id = h4_.unit_id
  LEFT JOIN users u5_ ON h4_.user_uuid = u5_.uuid
WHERE
  c0_.enseigne_id = ?
  AND u5_.uuid = ?
ORDER BY
  c0_.id DESC

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.status AS status_5, c0_.is_active AS is_active_6, s1_.id AS id_7, s1_.name AS name_8, s1_.start_date AS start_date_9, s1_.end_date AS end_date_10, c0_.season_id AS season_id_11, c0_.enseigne_id AS enseigne_id_12, c0_.owner_unit_id AS owner_unit_id_13, s1_.enseigne_id AS enseigne_id_14 FROM campaign c0_ LEFT JOIN season s1_ ON c0_.season_id = s1_.id LEFT JOIN campaign_unit_assignment c2_ ON c0_.id = c2_.campaign_id LEFT JOIN hr_organizational_unit h3_ ON c2_.organizational_unit_id = h3_.id LEFT JOIN hr_user_unit h4_ ON h3_.id = h4_.unit_id LEFT JOIN users u5_ ON h4_.user_uuid = u5_.uuid WHERE c0_.enseigne_id = 46 AND u5_.uuid = '759d4938-4a3a-4c94-b244-28d1bf506b0f' ORDER BY c0_.id DESC;

#	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 328)
7	App\Controller\Marketing\CampaignController->myCampaigns (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.25 ms
(27.05%)

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.68 ms
(14.65%)

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:

[
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
]

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 = '759d4938-4a3a-4c94-b244-28d1bf506b0f';

#	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.65 ms
(14.07%)

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:

[
  "gbenagnonagbannon@gmail.com"
]

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 = 'gbenagnonagbannon@gmail.com' 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.69%)

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 303)
6	App\Controller\Marketing\CampaignController->myCampaigns (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\AppConfig	2
App\Entity\Users	1
App\Entity\Enseigne	1
App\Entity\Marketing\Campaign	1
App\Entity\Marketing\Season	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\Marketing\Campaign	The field App\Entity\Marketing\Campaign#campaignQuestionnaires is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Marketing\CampaignQuestionnaire#campaign does not contain the required 'inversedBy="campaignQuestionnaires"' attribute.
App\Entity\Marketing\Season	No errors.
App\Entity\Marketing\CampaignUnitAssignment	No errors.
App\Entity\HR\OrganizationalUnit	No errors.
App\Entity\Marketing\CampaignQuestionnaire	No errors.

Symfony Profiler

GET https://careconcept-n2a.myn2a.online/CRM/marketing/my-campaigns

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping