Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.08 ms Query time

0 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.67 ms
(62.52%)

SELECT t0.id AS id_1, t0.ajuste_horas AS ajuste_horas_2, t0.ajuste_precio AS ajuste_precio_3, t0.capacidad AS capacidad_4, t0.fecha AS fecha_5, t0.precio_especial AS precio_especial_6, t0.slug AS slug_7, t0.aprobacion_id AS aprobacion_id_8, t0.actividad_status_id AS actividad_status_id_9, t0.codigo_id AS codigo_id_10, t0.actividad_class_id AS actividad_class_id_11 FROM actividad t0 WHERE t0.actividad_status_id = ? ORDER BY t0.fecha DESC LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ajuste_horas AS ajuste_horas_2,
  t0.ajuste_precio AS ajuste_precio_3,
  t0.capacidad AS capacidad_4,
  t0.fecha AS fecha_5,
  t0.precio_especial AS precio_especial_6,
  t0.slug AS slug_7,
  t0.aprobacion_id AS aprobacion_id_8,
  t0.actividad_status_id AS actividad_status_id_9,
  t0.codigo_id AS codigo_id_10,
  t0.actividad_class_id AS actividad_class_id_11
FROM
  actividad t0
WHERE
  t0.actividad_status_id = ?
ORDER BY
  t0.fecha DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.ajuste_horas AS ajuste_horas_2, t0.ajuste_precio AS ajuste_precio_3, t0.capacidad AS capacidad_4, t0.fecha AS fecha_5, t0.precio_especial AS precio_especial_6, t0.slug AS slug_7, t0.aprobacion_id AS aprobacion_id_8, t0.actividad_status_id AS actividad_status_id_9, t0.codigo_id AS codigo_id_10, t0.actividad_class_id AS actividad_class_id_11 FROM actividad t0 WHERE t0.actividad_status_id = 1 ORDER BY t0.fecha DESC LIMIT 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\front\HomeController->index (line 40)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.40 ms
(37.48%)

SELECT p0_.id AS id_0, p0_.profesion AS profesion_1, p0_.siglas AS siglas_2, p0_.codigo_profesion AS codigo_profesion_3, p0_.horas_requeridas_total AS horas_requeridas_total_4, p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5, p0_.is_default AS is_default_6, p0_.is_featured AS is_featured_7, p0_.slug AS slug_8 FROM profesion p0_ WHERE p0_.is_featured = ? ORDER BY p0_.profesion ASC LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.profesion AS profesion_1,
  p0_.siglas AS siglas_2,
  p0_.codigo_profesion AS codigo_profesion_3,
  p0_.horas_requeridas_total AS horas_requeridas_total_4,
  p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5,
  p0_.is_default AS is_default_6,
  p0_.is_featured AS is_featured_7,
  p0_.slug AS slug_8
FROM
  profesion p0_
WHERE
  p0_.is_featured = ?
ORDER BY
  p0_.profesion ASC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.profesion AS profesion_1, p0_.siglas AS siglas_2, p0_.codigo_profesion AS codigo_profesion_3, p0_.horas_requeridas_total AS horas_requeridas_total_4, p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5, p0_.is_default AS is_default_6, p0_.is_featured AS is_featured_7, p0_.slug AS slug_8 FROM profesion p0_ WHERE p0_.is_featured = 1 ORDER BY p0_.profesion ASC LIMIT 6;

#	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\ProfesionRepository->findFeatured (line 30)
7	App\Controller\front\HomeController->index (line 41)
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)

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\Profesion	6
App\Entity\Actividad	2
App\Entity\Aprobacion	2
App\Entity\Codigo	2
App\Entity\ActividadStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\Actividad	No errors.
App\Entity\Aprobacion	No errors.
App\Entity\ActividadStatus	No errors.
App\Entity\Codigo	No errors.
App\Entity\ActividadClass	No errors.
App\Entity\Seccion	No errors.
App\Entity\Matricula	No errors.
App\Entity\Profesion	No errors.
App\Entity\UserProfesion	No errors.
App\Entity\Junta	No errors.
App\Entity\AprobacionName	No errors.
App\Entity\AprobacionStatus	No errors.
App\Entity\AprobacionClass	No errors.
App\Entity\User	No errors.
App\Entity\CartItem	No errors.
App\Entity\MatriculaStatus	No errors.
App\Entity\Certificado	No errors.
App\Entity\JuntaStatus	No errors.
App\Entity\Cart	No errors.
App\Entity\Pago	No errors.
App\Entity\CompraMisc	No errors.
App\Entity\CartItemStatus	No errors.
App\Entity\CartItemClass	No errors.
App\Entity\Misc	No errors.
App\Entity\CartStatus	No errors.
App\Entity\PaymentMethod	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

HEAD https://previadmin.computechapps.com/

Configuration Settings

Theme

Page Width