Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.35 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.08 ms
(46.14%)

SELECT j0_.id AS id_0, j0_.status AS status_1, j1_.id AS id_2, p2_.profesion AS profesion_3, p2_.id AS id_4 FROM junta_status j0_ INNER JOIN junta j1_ ON j0_.id = j1_.junta_status_id INNER JOIN profesion p2_ ON j1_.profesion_id = p2_.id WHERE j0_.id IN (1, 2, 3) ORDER BY j0_.id ASC, p2_.profesion ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.status AS status_1,
  j1_.id AS id_2,
  p2_.profesion AS profesion_3,
  p2_.id AS id_4
FROM
  junta_status j0_
  INNER JOIN junta j1_ ON j0_.id = j1_.junta_status_id
  INNER JOIN profesion p2_ ON j1_.profesion_id = p2_.id
WHERE
  j0_.id IN (1, 2, 3)
ORDER BY
  j0_.id ASC,
  p2_.profesion ASC

SELECT j0_.id AS id_0, j0_.status AS status_1, j1_.id AS id_2, p2_.profesion AS profesion_3, p2_.id AS id_4 FROM junta_status j0_ INNER JOIN junta j1_ ON j0_.id = j1_.junta_status_id INNER JOIN profesion p2_ ON j1_.profesion_id = p2_.id WHERE j0_.id IN (1, 2, 3) ORDER BY j0_.id ASC, p2_.profesion ASC;

#	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\JuntaStatusRepository->findJuntasByStatusRange (line 35)
7	App\Controller\admin\DashboardController->index (line 24)
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)

0.85 ms
(36.08%)

SELECT m0_.id AS id_0, m0_.status AS status_1, m0_.color AS color_2, u1_.id AS id_3, u1_.email AS email_4 FROM matricula_status m0_ INNER JOIN matricula m2_ ON m0_.id = m2_.matricula_status_id INNER JOIN user u1_ ON m2_.estudiante_id = u1_.id WHERE m0_.id BETWEEN ? AND ? ORDER BY m0_.orden ASC, u1_.email ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.status AS status_1,
  m0_.color AS color_2,
  u1_.id AS id_3,
  u1_.email AS email_4
FROM
  matricula_status m0_
  INNER JOIN matricula m2_ ON m0_.id = m2_.matricula_status_id
  INNER JOIN user u1_ ON m2_.estudiante_id = u1_.id
WHERE
  m0_.id BETWEEN ?
  AND ?
ORDER BY
  m0_.orden ASC,
  u1_.email ASC

SELECT m0_.id AS id_0, m0_.status AS status_1, m0_.color AS color_2, u1_.id AS id_3, u1_.email AS email_4 FROM matricula_status m0_ INNER JOIN matricula m2_ ON m0_.id = m2_.matricula_status_id INNER JOIN user u1_ ON m2_.estudiante_id = u1_.id WHERE m0_.id BETWEEN 2 AND 20 ORDER BY m0_.orden ASC, u1_.email ASC;

#	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\MatriculaStatusRepository->findEstudiantesByStatusRange (line 38)
7	App\Controller\admin\DashboardController->index (line 23)
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)

0.42 ms
(17.78%)

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\Bridge\Twig\AppVariable->getUser (line 92)
14	Twig\Extension\CoreExtension->getAttribute (line 1913)
15	__TwigTemplate_e6b5158bf81fc5b66290bce293ba1789::doDisplay (line 74)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_6844e1adcd18873f72a9aded1b28d48c->doDisplay (line 101)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_ca3552c7dc3ab84df5e03325eb9f3a22->doDisplay (line 55)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\admin\DashboardController->index (line 28)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	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\User	1

Entities Mapping

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

Symfony Profiler

GET https://previadmin.computechapps.com/admin/dashboard

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping