Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

11.95 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.13 ms
(34.56%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.contacto AS contacto_3, t0.rut AS rut_4, t0.dv AS dv_5 FROM ps_gen_empresa t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.contacto AS contacto_3,
  t0.rut AS rut_4,
  t0.dv AS dv_5
FROM
  ps_gen_empresa t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.contacto AS contacto_3, t0.rut AS rut_4, t0.dv AS dv_5 FROM ps_gen_empresa t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 148)
5	App\Controller\RegistrationUserController->userSing (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

3.89 ms
(32.56%)

SELECT t0.id AS id_1, t0.sucursal AS sucursal_2, t0.region AS region_3, t0.pais AS pais_4, t0.canal_venta AS canal_venta_5, t0.estado AS estado_6, t0.direccion AS direccion_7, t0.zona AS zona_8 FROM ps_gen_sucursal t0 WHERE t0.estado = ? ORDER BY t0.sucursal ASC

Parameters:

[
  "A"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sucursal AS sucursal_2,
  t0.region AS region_3,
  t0.pais AS pais_4,
  t0.canal_venta AS canal_venta_5,
  t0.estado AS estado_6,
  t0.direccion AS direccion_7,
  t0.zona AS zona_8
FROM
  ps_gen_sucursal t0
WHERE
  t0.estado = ?
ORDER BY
  t0.sucursal ASC

SELECT t0.id AS id_1, t0.sucursal AS sucursal_2, t0.region AS region_3, t0.pais AS pais_4, t0.canal_venta AS canal_venta_5, t0.estado AS estado_6, t0.direccion AS direccion_7, t0.zona AS zona_8 FROM ps_gen_sucursal t0 WHERE t0.estado = 'A' ORDER BY t0.sucursal ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 94)
4	App\Form\UserRegistration->App\Form\{closure} (line 220)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 30)
7	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 289)
8	Symfony\Component\Form\Form->setData (line 412)
9	Symfony\Component\Form\Form->initialize (line 176)
10	Symfony\Component\Form\FormBuilder->getForm (line 28)
11	Symfony\Component\Form\FormFactory->create (line 344)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 161)
13	App\Controller\RegistrationUserController->userSing (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

2.47 ms
(20.65%)

SELECT u0_.email AS email_0 FROM user u0_ WHERE u0_.roles LIKE ?

Parameters:

[
  "%ROLE_PDT_ADMIN%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.email AS email_0
FROM
  user u0_
WHERE
  u0_.roles LIKE ?

SELECT u0_.email AS email_0 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_PDT_ADMIN%';

#	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 64)
7	App\Repository\UserRepository->findEmailByRolePepsico (line 166)
8	App\Controller\RegistrationUserController->userSing (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.46 ms
(12.24%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.tipo AS tipo_3, t0.descripcion AS descripcion_4 FROM ps_rol t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.tipo AS tipo_3,
  t0.descripcion AS descripcion_4
FROM
  ps_rol t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.tipo AS tipo_3, t0.descripcion AS descripcion_4 FROM ps_rol t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 66)
5	App\Form\UserRegistration->buildForm (line 102)
6	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
7	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
8	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
9	Symfony\Component\Form\FormFactory->createBuilder (line 28)
10	Symfony\Component\Form\FormFactory->create (line 344)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 161)
12	App\Controller\RegistrationUserController->userSing (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	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.

Entities Mapping

Class	Mapping errors
App\Entity\PsGenEmpresa	No errors.
App\Entity\PsEppEntrega	No errors.
App\Entity\PsRol	No errors.
App\Entity\PsPdtFirmante	No errors.
App\Entity\User	The association App\Entity\User#psPdtControlEnCalientes refers to the owning side field App\Entity\PsPdtControlEnCaliente#id_usuario_control_final which does not exist.
App\Entity\PsGenSucursal	The association App\Entity\PsGenSucursal#impartir_cursos refers to the owning side field App\Entity\PsIrlImpartirCurso#sucursal_id which does not exist.
App\Entity\PsEppUsuarioSucursal	No errors.
App\Entity\PsOdcObservacion	The association App\Entity\PsOdcObservacion#id_usuario refers to the inverse side field App\Entity\User#psOdcObservacion which does not exist. If association App\Entity\PsOdcObservacion#id_trabajador is many-to-one, then the inversed side App\Entity\PsTrabajador#psOdcObservacion has to be one-to-many.
App\Entity\PsIrlImpartirCurso	No errors.
App\Entity\PsIrlTrabajador	No errors.

Symfony Profiler

GET https://pdtdev.devsti.cl/registropublico

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping