Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

25.53 ms Query time

3 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

22.30 ms
(87.34%)

SELECT
    u.id,
    u.email,
    u.company_id,

    MAX(u.first_name)   AS first_name,
    MAX(u.last_name)    AS last_name,
    MAX(u.reset_token)  AS reset_token,
    MAX(u.civility)     AS civility,
    MAX(u.telephone)    AS telephone,
    MAX(u.created_at)   AS created_at,
    MAX(u.is_active)    AS is_active,
    MAX(u.roles)        AS roles,
    MAX(co.name)        AS company_name,
    CONCAT(MAX(u.first_name), ' ', MAX(u.last_name)) AS full_name,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT('role_id', r.id, 'role_name', r.name) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS roles_json,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT(
              'action_id', a.id,
              'action_name', a.name,
              'page_id', pa.id
            ) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS actions_json,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT(
              'page_id',   pa.id,
              'page_name', pa.name,
              'module_id', m.id
            ) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS pages_json,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT(
              'module_id',   m.id,
              'module_name', m.name
            ) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS modules_json

FROM user u
LEFT JOIN company     co ON co.id = u.company_id
LEFT JOIN user_roles  ur ON ur.user_id = u.id
LEFT JOIN roles       r  ON r.id = ur.roles_id
LEFT JOIN permission  p  ON p.role_id = r.id
LEFT JOIN action      a  ON a.id = p.action_id
LEFT JOIN pages       pa ON pa.id = p.page_id
LEFT JOIN modules     m  ON m.id = p.module_id
WHERE
    u.id = :id
GROUP BY
    u.id

Parameters:

[
  "id" => 3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u.id,
  u.email,
  u.company_id,
  MAX(u.first_name) AS first_name,
  MAX(u.last_name) AS last_name,
  MAX(u.reset_token) AS reset_token,
  MAX(u.civility) AS civility,
  MAX(u.telephone) AS telephone,
  MAX(u.created_at) AS created_at,
  MAX(u.is_active) AS is_active,
  MAX(u.roles) AS roles,
  MAX(co.name) AS company_name,
  CONCAT(
    MAX(u.first_name),
    ' ',
    MAX(u.last_name)
  ) AS full_name,
  COALESCE(
    CONCAT(
      '[',
      GROUP_CONCAT(
        DISTINCT CAST(
          JSON_OBJECT(
            'role_id', r.id, 'role_name', r.name
          ) AS CHAR
        )
      ),
      ']'
    ),
    '[]'
  ) AS roles_json,
  COALESCE(
    CONCAT(
      '[',
      GROUP_CONCAT(
        DISTINCT CAST(
          JSON_OBJECT(
            'action_id', a.id, 'action_name',
            a.name, 'page_id', pa.id
          ) AS CHAR
        )
      ),
      ']'
    ),
    '[]'
  ) AS actions_json,
  COALESCE(
    CONCAT(
      '[',
      GROUP_CONCAT(
        DISTINCT CAST(
          JSON_OBJECT(
            'page_id', pa.id, 'page_name', pa.name,
            'module_id', m.id
          ) AS CHAR
        )
      ),
      ']'
    ),
    '[]'
  ) AS pages_json,
  COALESCE(
    CONCAT(
      '[',
      GROUP_CONCAT(
        DISTINCT CAST(
          JSON_OBJECT(
            'module_id', m.id, 'module_name',
            m.name
          ) AS CHAR
        )
      ),
      ']'
    ),
    '[]'
  ) AS modules_json
FROM
  user u
  LEFT JOIN company co ON co.id = u.company_id
  LEFT JOIN user_roles ur ON ur.user_id = u.id
  LEFT JOIN roles r ON r.id = ur.roles_id
  LEFT JOIN permission p ON p.role_id = r.id
  LEFT JOIN action a ON a.id = p.action_id
  LEFT JOIN pages pa ON pa.id = p.page_id
  LEFT JOIN modules m ON m.id = p.module_id
WHERE
  u.id = :id
GROUP BY
  u.id

SELECT
    u.id,
    u.email,
    u.company_id,

    MAX(u.first_name)   AS first_name,
    MAX(u.last_name)    AS last_name,
    MAX(u.reset_token)  AS reset_token,
    MAX(u.civility)     AS civility,
    MAX(u.telephone)    AS telephone,
    MAX(u.created_at)   AS created_at,
    MAX(u.is_active)    AS is_active,
    MAX(u.roles)        AS roles,
    MAX(co.name)        AS company_name,
    CONCAT(MAX(u.first_name), ' ', MAX(u.last_name)) AS full_name,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT('role_id', r.id, 'role_name', r.name) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS roles_json,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT(
              'action_id', a.id,
              'action_name', a.name,
              'page_id', pa.id
            ) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS actions_json,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT(
              'page_id',   pa.id,
              'page_name', pa.name,
              'module_id', m.id
            ) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS pages_json,

    COALESCE(
      CONCAT(
        '[',
        GROUP_CONCAT(
          DISTINCT CAST(
            JSON_OBJECT(
              'module_id',   m.id,
              'module_name', m.name
            ) AS CHAR
          )
        ),
        ']'
      ),
      '[]'
    ) AS modules_json

FROM user u
LEFT JOIN company     co ON co.id = u.company_id
LEFT JOIN user_roles  ur ON ur.user_id = u.id
LEFT JOIN roles       r  ON r.id = ur.roles_id
LEFT JOIN permission  p  ON p.role_id = r.id
LEFT JOIN action      a  ON a.id = p.action_id
LEFT JOIN pages       pa ON pa.id = p.page_id
LEFT JOIN modules     m  ON m.id = p.module_id
WHERE
    u.id = 3
GROUP BY
    u.id;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 224)
2	App\Repository\UserRepository->getUserWithPermissions (line 236)
3	App\Security\LoginFormAuthenticator->onAuthenticationSuccess (line 64)
4	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 85)
5	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 235)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 154)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 185)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

2.73 ms
(10.71%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "root@root.ma"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.reset_token AS reset_token_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.civility AS civility_11,
  t0.telephone AS telephone_12,
  t0.company_id AS company_id_13,
  t14.id AS id_15,
  t14.email AS email_16,
  t14.date_of_birth AS date_of_birth_17,
  t14.created_at AS created_at_18,
  t14.salary AS salary_19,
  t14.last_name AS last_name_20,
  t14.first_name AS first_name_21,
  t14.civility AS civility_22,
  t14.telephone AS telephone_23,
  t14.department_id AS department_id_24,
  t14.fonction_id AS fonction_id_25,
  t14.user_id AS user_id_26
FROM
  user t0
  LEFT JOIN employee t14 ON t14.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.reset_token AS reset_token_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civility AS civility_11, t0.telephone AS telephone_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.date_of_birth AS date_of_birth_17, t14.created_at AS created_at_18, t14.salary AS salary_19, t14.last_name AS last_name_20, t14.first_name AS first_name_21, t14.civility AS civility_22, t14.telephone AS telephone_23, t14.department_id AS department_id_24, t14.fonction_id AS fonction_id_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN employee t14 ON t14.user_id = t0.id WHERE t0.email = 'root@root.ma' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 54)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 87)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 154)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 185)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.50 ms
(1.95%)

SET SESSION group_concat_max_len = 1000000

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  SESSION group_concat_max_len = 1000000

SET SESSION group_concat_max_len = 1000000;

#	File/Call
1	App\Repository\UserRepository->getUserWithPermissions (line 139)
2	App\Security\LoginFormAuthenticator->onAuthenticationSuccess (line 64)
3	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 85)
4	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 235)
5	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 221)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
8	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 127)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 154)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 185)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
interfacage	doctrine.dbal.interfacage_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\User	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Employee	No errors.
App\Entity\Department	No errors.
App\Entity\Fonction	No errors.
App\Entity\Client	The association App\Entity\Client#machineLocations refers to the owning side field App\Entity\MachineLocation#client which does not exist.
App\Entity\Devis	No errors.
App\Entity\Contrat	The association App\Entity\Contrat#compteFacturations refers to the owning side field App\Entity\CompteFacturation#contrat which does not exist.
App\Entity\Tickets	No errors.
App\Entity\Roles	No errors.
App\Entity\Affectation	No errors.
App\Entity\DemandePieces	No errors.
App\Entity\PieceDemandeStatus	No errors.
App\Entity\AffectationSequances	No errors.
App\Entity\DemandeConsommables	No errors.
App\Entity\ConsommableDemandeStatus	No errors.
App\Entity\TicketsComments	No errors.
App\Entity\Livraison	If association App\Entity\Livraison#devis is one-to-one, then the inversed side App\Entity\Devis#livraison has to be one-to-one as well.

Symfony Profiler

POST https://demosymph.omnipilote.ma/fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping