Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

10.69 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.43 ms
(41.41%)

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 155)
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)

2.02 ms
(18.90%)

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, t0.id_planta_id AS id_planta_id_9 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,
  t0.id_planta_id AS id_planta_id_9
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, t0.id_planta_id AS id_planta_id_9 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 95)
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 168)
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)

1.91 ms
(17.91%)

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

Parameters:

[
  "%ROLE_PDT_ADMIN%"
  "A"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT u0_.email AS email_0 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_PDT_ADMIN%' AND u0_.estado = 'A';

#	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 69)
7	App\Repository\UserRepository->findEmailByRolePepsico (line 173)
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.18 ms
(11.02%)

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 67)
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 168)
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)

1.15 ms
(10.76%)

SELECT p0_.id AS id_0, p0_.planta AS planta_1, p0_.codigo AS codigo_2, p0_.estado AS estado_3, p0_.id_pais_id AS id_pais_id_4 FROM ps_gen_planta p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.planta AS planta_1,
  p0_.codigo AS codigo_2,
  p0_.estado AS estado_3,
  p0_.id_pais_id AS id_pais_id_4
FROM
  ps_gen_planta p0_

SELECT p0_.id AS id_0, p0_.planta AS planta_1, p0_.codigo AS codigo_2, p0_.estado AS estado_3, p0_.id_pais_id AS id_pais_id_4 FROM ps_gen_planta p0_;

#	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 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 179)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 190)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 468)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 285)
21	App\Controller\RegistrationUserController->userSing (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\PsGenPlanta	No errors.
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.
App\Entity\PsGenPais	No errors.
App\Entity\PsPdtAntecedentes	The mappings App\Entity\PsPdtAntecedentes#psPdtAntecedentesPorTipoTrabajo and App\Entity\PsPdtAntecedentesPorTipoTrabajo#psPdtAntecedentes are inconsistent with each other. The association App\Entity\PsPdtAntecedentes#sucursal refers to the inverse side field App\Entity\PsGenSucursal#psPdtAntecedentes which does not exist. The association App\Entity\PsPdtAntecedentes#calidad refers to the inverse side field App\Entity\User#psPdtAntecedentes which does not exist. The association App\Entity\PsPdtAntecedentes#coordinador_area refers to the inverse side field App\Entity\User#psPdtAntecedentes which does not exist.
App\Entity\PsIrlGenCanal	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