Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.50 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.29 ms
(58.59%)

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.value AS value_3, t0.html AS html_4 FROM config t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.value AS value_3,
  t0.html AS html_4
FROM
  config t0

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.value AS value_3, t0.html AS html_4 FROM config t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\ConfigService->__construct (line 20)
6	ContainerI86sGFs\App_KernelDevDebugContainer->getConfigServiceService (line 1391)
7	ContainerI86sGFs\getAuthControllerService::do (line 26)
8	ContainerI86sGFs\App_KernelDevDebugContainer::load (line 617)
9	Symfony\Component\DependencyInjection\Container->make (line 220)
10	Symfony\Component\DependencyInjection\Container::get (line 202)
11	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
12	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
15	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.14 ms
(27.81%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7, t0.is_verified AS is_verified_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.connected_at AS connected_at_12, t0.token AS token_13, t0.function AS function_14, t0.password_updated_at AS password_updated_at_15, t0.password_reset_token AS password_reset_token_16, t0.password_reset_exipired_at AS password_reset_exipired_at_17, t0.affaire_role AS affaire_role_18, t0.invitation_sent AS invitation_sent_19, t0.optin_email AS optin_email_20, t0.test AS test_21, t0.idsound_active AS idsound_active_22, t0.primary_admin AS primary_admin_23, t0.no_mails AS no_mails_24, t0.last_accesscode_id AS last_accesscode_id_25, t0.updated_by_id AS updated_by_id_26, t0.created_by_id AS created_by_id_27, t0.current_affaire_id AS current_affaire_id_28, t0.avatar_id AS avatar_id_29 FROM user t0 WHERE t0.email IS NULL LIMIT 1

Parameters:

[]

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.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone AS phone_7,
  t0.is_verified AS is_verified_8,
  t0.active AS active_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.connected_at AS connected_at_12,
  t0.token AS token_13,
  t0.function AS function_14,
  t0.password_updated_at AS password_updated_at_15,
  t0.password_reset_token AS password_reset_token_16,
  t0.password_reset_exipired_at AS password_reset_exipired_at_17,
  t0.affaire_role AS affaire_role_18,
  t0.invitation_sent AS invitation_sent_19,
  t0.optin_email AS optin_email_20,
  t0.test AS test_21,
  t0.idsound_active AS idsound_active_22,
  t0.primary_admin AS primary_admin_23,
  t0.no_mails AS no_mails_24,
  t0.last_accesscode_id AS last_accesscode_id_25,
  t0.updated_by_id AS updated_by_id_26,
  t0.created_by_id AS created_by_id_27,
  t0.current_affaire_id AS current_affaire_id_28,
  t0.avatar_id AS avatar_id_29
FROM
  user t0
WHERE
  t0.email IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7, t0.is_verified AS is_verified_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.connected_at AS connected_at_12, t0.token AS token_13, t0.function AS function_14, t0.password_updated_at AS password_updated_at_15, t0.password_reset_token AS password_reset_token_16, t0.password_reset_exipired_at AS password_reset_exipired_at_17, t0.affaire_role AS affaire_role_18, t0.invitation_sent AS invitation_sent_19, t0.optin_email AS optin_email_20, t0.test AS test_21, t0.idsound_active AS idsound_active_22, t0.primary_admin AS primary_admin_23, t0.no_mails AS no_mails_24, t0.last_accesscode_id AS last_accesscode_id_25, t0.updated_by_id AS updated_by_id_26, t0.created_by_id AS created_by_id_27, t0.current_affaire_id AS current_affaire_id_28, t0.avatar_id AS avatar_id_29 FROM user t0 WHERE t0.email IS NULL 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	App\Controller\AuthController->getUserSession (line 57)
5	App\Controller\AuthController->logincode (line 88)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.07 ms
(13.60%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.active AS active_3, t0.highlight AS highlight_4 FROM access_code t0 WHERE t0.code IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.active AS active_3,
  t0.highlight AS highlight_4
FROM
  access_code t0
WHERE
  t0.code IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.active AS active_3, t0.highlight AS highlight_4 FROM access_code t0 WHERE t0.code IS NULL 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	App\Controller\AuthController->getAccessCodeSession (line 62)
5	App\Controller\AuthController->logincode (line 89)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (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\Config	17

Entities Mapping

Class	Mapping errors
App\Entity\Config	No errors.
App\Entity\User	No errors.
App\Entity\AccessCode	No errors.
App\Entity\Reseau\Affaire	No errors.
App\Entity\Media	No errors.
App\Entity\UserHasAffaire	No errors.
App\Entity\Dossier\Dossier	No errors.
App\Entity\Reseau\Groupe	No errors.
App\Entity\NewPasswordRequest	No errors.
App\Entity\Dossier\SeenMessage	No errors.
App\Entity\Reseau\Territoire	No errors.
App\Entity\Newsletter\Article	No errors.
App\Entity\Dossier\DossierUpload	No errors.
App\Entity\Catalogue\CarModel	No errors.
App\Entity\IdSound\Sound	No errors.
App\Entity\IdSound\Character	No errors.

Symfony Profiler

GET https://dev-business-axs-vu.renault-davf.com/logincode

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping