Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

7.09 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.15 ms

SELECT t0.code AS code_1, t0.name AS name_2, t0.main AS main_3, t0.full_code AS full_code_4, t0.active AS active_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9 FROM language t0 WHERE t0.main = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.full_code AS full_code_4,
  t0.active AS active_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9
FROM
  language t0
WHERE
  t0.main = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.main AS main_3, t0.full_code AS full_code_4, t0.active AS active_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9 FROM language t0 WHERE t0.main = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->__call (line 100)
6	App\Services\Entity\Core\LanguageAdministrableEntity->getMain (line 101)
7	App\EventListener\LocaleListener->__construct (line 36)
8	ContainerDlvlbpw\App_KernelDevDebugContainer->getLocaleListenerService (line 1941)
9	ContainerDlvlbpw\App_KernelDevDebugContainer::{closure:ContainerDlvlbpw\App_KernelDevDebugContainer::getEventDispatcherService():1524} (line 1524)
10	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 262)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 123)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

3.94 ms

SELECT t1.user_identifier AS user_identifier_2, t1.password AS password_3, t1.roles AS roles_4, t1.last_login_at AS last_login_at_5, t1.token AS token_6, t1.token_expires_at AS token_expires_at_7, t1.active AS active_8, t1.deleted_at AS deleted_at_9, t1.created_at AS created_at_10, t1.updated_at AS updated_at_11, t1.id AS id_12, t0.name AS name_13, t1.dtype FROM user_admin t0 INNER JOIN users t1 ON t0.id = t1.id WHERE ((t1.deleted_at IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.user_identifier AS user_identifier_2,
  t1.password AS password_3,
  t1.roles AS roles_4,
  t1.last_login_at AS last_login_at_5,
  t1.token AS token_6,
  t1.token_expires_at AS token_expires_at_7,
  t1.active AS active_8,
  t1.deleted_at AS deleted_at_9,
  t1.created_at AS created_at_10,
  t1.updated_at AS updated_at_11,
  t1.id AS id_12,
  t0.name AS name_13,
  t1.dtype
FROM
  user_admin t0
  INNER JOIN users t1 ON t0.id = t1.id
WHERE
  (
    (t1.deleted_at IS NULL)
  )

SELECT t1.user_identifier AS user_identifier_2, t1.password AS password_3, t1.roles AS roles_4, t1.last_login_at AS last_login_at_5, t1.token AS token_6, t1.token_expires_at AS token_expires_at_7, t1.active AS active_8, t1.deleted_at AS deleted_at_9, t1.created_at AS created_at_10, t1.updated_at AS updated_at_11, t1.id AS id_12, t0.name AS name_13, t1.dtype FROM user_admin t0 INNER JOIN users t1 ON t0.id = t1.id WHERE ((t1.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Security\Voter\RegisterVoter->voteOnAttribute (line 25)
6	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
7	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
8	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
9	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
11	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
12	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->isGranted (line 209)
14	App\Controller\Auth\SecurityController->login (line 24)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	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\Skeleton\UserSkeleton	3
App\Entity\Core\Language	1

Entities Mapping

Class	Mapping errors
App\Entity\Core\Language	No errors.
App\Entity\Skeleton\UserSkeleton	No errors.
App\Entity\Core\User\Admin	No errors.
App\Entity\Core\User\UserToken	No errors.

Symfony Profiler

GET https://gestionsymfony.do18.veiss.com/es/auth/login

Configuration Settings

Theme

Page Width