Symfony Profiler

Query Metrics

30 Database Queries

4 Different statements

22.92 ms Query time

0 Invalid entities

48 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.82 ms
(64.67%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apellido1 AS apellido1_5, u0_.apellido2 AS apellido2_6, u0_.tel1 AS tel1_7, u0_.tel2 AS tel2_8, u0_.is_activo AS is_activo_9, u0_.old_id AS old_id_10, u0_.new_password AS new_password_11 FROM user u0_ WHERE u0_.nombre LIKE ? OR u0_.apellido1 LIKE ? OR u0_.apellido2 LIKE ? OR u0_.email LIKE ? OR u0_.tel1 LIKE ? ORDER BY u0_.apellido1 ASC, u0_.apellido2 ASC, u0_.nombre ASC LIMIT 200

Parameters:

[
  "%grace%"
  "%grace%"
  "%grace%"
  "%grace%"
  "%grace%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.nombre AS nombre_4,
  u0_.apellido1 AS apellido1_5,
  u0_.apellido2 AS apellido2_6,
  u0_.tel1 AS tel1_7,
  u0_.tel2 AS tel2_8,
  u0_.is_activo AS is_activo_9,
  u0_.old_id AS old_id_10,
  u0_.new_password AS new_password_11
FROM
  user u0_
WHERE
  u0_.nombre LIKE ?
  OR u0_.apellido1 LIKE ?
  OR u0_.apellido2 LIKE ?
  OR u0_.email LIKE ?
  OR u0_.tel1 LIKE ?
ORDER BY
  u0_.apellido1 ASC,
  u0_.apellido2 ASC,
  u0_.nombre ASC
LIMIT
  200

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apellido1 AS apellido1_5, u0_.apellido2 AS apellido2_6, u0_.tel1 AS tel1_7, u0_.tel2 AS tel2_8, u0_.is_activo AS is_activo_9, u0_.old_id AS old_id_10, u0_.new_password AS new_password_11 FROM user u0_ WHERE u0_.nombre LIKE '%grace%' OR u0_.apellido1 LIKE '%grace%' OR u0_.apellido2 LIKE '%grace%' OR u0_.email LIKE '%grace%' OR u0_.tel1 LIKE '%grace%' ORDER BY u0_.apellido1 ASC, u0_.apellido2 ASC, u0_.nombre ASC LIMIT 200;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\UserRepository->searchByNameOrLastName (line 51)
7	App\Controller\admin\UserController->index (line 44)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

4.69 ms
(20.48%)

SELECT t0.id AS id_1, t0.num_lic AS num_lic_2, t0.fecha_renovacion AS fecha_renovacion_3, t0.is_activo AS is_activo_4, t0.is_principal AS is_principal_5, t0.user_id AS user_id_6, t0.profesion_id AS profesion_id_7 FROM user_profesion t0 WHERE t0.user_id = ?

Parameters:

[
  4395
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.num_lic AS num_lic_2,
  t0.fecha_renovacion AS fecha_renovacion_3,
  t0.is_activo AS is_activo_4,
  t0.is_principal AS is_principal_5,
  t0.user_id AS user_id_6,
  t0.profesion_id AS profesion_id_7
FROM
  user_profesion t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.num_lic AS num_lic_2, t0.fecha_renovacion AS fecha_renovacion_3, t0.is_activo AS is_activo_4, t0.is_principal AS is_principal_5, t0.user_id AS user_id_6, t0.profesion_id AS profesion_id_7 FROM user_profesion t0 WHERE t0.user_id = 4395;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_4e274363af4a6df2fccec3a9df452e62::block_body (line 250)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_6844e1adcd18873f72a9aded1b28d48c->doDisplay (line 117)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_4e274363af4a6df2fccec3a9df452e62->doDisplay (line 56)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\admin\UserController->index (line 48)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

2.45 ms
(10.70%)

SELECT t0.id AS id_1, t0.profesion AS profesion_2, t0.siglas AS siglas_3, t0.codigo_profesion AS codigo_profesion_4, t0.horas_requeridas_total AS horas_requeridas_total_5, t0.horas_requeridas_presencial AS horas_requeridas_presencial_6, t0.is_default AS is_default_7, t0.is_featured AS is_featured_8, t0.slug AS slug_9 FROM profesion t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.profesion AS profesion_2,
  t0.siglas AS siglas_3,
  t0.codigo_profesion AS codigo_profesion_4,
  t0.horas_requeridas_total AS horas_requeridas_total_5,
  t0.horas_requeridas_presencial AS horas_requeridas_presencial_6,
  t0.is_default AS is_default_7,
  t0.is_featured AS is_featured_8,
  t0.slug AS slug_9
FROM
  profesion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.profesion AS profesion_2, t0.siglas AS siglas_3, t0.codigo_profesion AS codigo_profesion_4, t0.horas_requeridas_total AS horas_requeridas_total_5, t0.horas_requeridas_presencial AS horas_requeridas_presencial_6, t0.is_default AS is_default_7, t0.is_featured AS is_featured_8, t0.slug AS slug_9 FROM profesion t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Profesion::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Profesion->__get (line 153)
7	App\Entity\Profesion->getSiglas (line 81)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_4e274363af4a6df2fccec3a9df452e62::{closure} (line 255)
10	Twig\Extension\CoreExtension->map (line 2014)
11	__TwigTemplate_4e274363af4a6df2fccec3a9df452e62::block_body (line 253)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_6844e1adcd18873f72a9aded1b28d48c->doDisplay (line 117)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_4e274363af4a6df2fccec3a9df452e62->doDisplay (line 56)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
24	App\Controller\admin\UserController->index (line 48)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.95 ms
(4.16%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apellido1 AS apellido1_6, t0.apellido2 AS apellido2_7, t0.tel1 AS tel1_8, t0.tel2 AS tel2_9, t0.is_activo AS is_activo_10, t0.old_id AS old_id_11, t0.new_password AS new_password_12 FROM user t0 WHERE t0.id = ?

Parameters:

[
  12154
]

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.nombre AS nombre_5,
  t0.apellido1 AS apellido1_6,
  t0.apellido2 AS apellido2_7,
  t0.tel1 AS tel1_8,
  t0.tel2 AS tel2_9,
  t0.is_activo AS is_activo_10,
  t0.old_id AS old_id_11,
  t0.new_password AS new_password_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apellido1 AS apellido1_6, t0.apellido2 AS apellido2_7, t0.tel1 AS tel1_8, t0.tel2 AS tel2_9, t0.is_activo AS is_activo_10, t0.old_id AS old_id_11, t0.new_password AS new_password_12 FROM user t0 WHERE t0.id = 12154;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 74)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 45)
14	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 64)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
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

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\UserProfesion	19
App\Entity\User	18
App\Entity\Profesion	11

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserProfesion	No errors.
App\Entity\Matricula	No errors.
App\Entity\Cart	No errors.
App\Entity\Pago	No errors.
App\Entity\CompraMisc	No errors.
App\Entity\Profesion	No errors.
App\Entity\Certificado	No errors.
App\Entity\Junta	No errors.

Symfony Profiler

GET https://previadmin.computechapps.com/user/?search=grace

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping