Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

8.49 ms Query time

1 Invalid entities

Queries

Group similar statements

default connection

#▲

Time

Info

0.32 ms

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.descripcion AS descripcion_4, t0.deleted_at AS deleted_at_5, t0.longitud AS longitud_6, t0.latitud AS latitud_7, t0.map_place AS map_place_8, t0.video AS video_9, t0.id_wp AS id_wp_10, t0.nombre_ingles AS nombre_ingles_11, t0.descripcion_ingles AS descripcion_ingles_12, t0.imagen_optimizada AS imagen_optimizada_13 FROM escenario t0 WHERE t0.id = ?

Parameters:

[
  "462"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.imagen AS imagen_3,
  t0.descripcion AS descripcion_4,
  t0.deleted_at AS deleted_at_5,
  t0.longitud AS longitud_6,
  t0.latitud AS latitud_7,
  t0.map_place AS map_place_8,
  t0.video AS video_9,
  t0.id_wp AS id_wp_10,
  t0.nombre_ingles AS nombre_ingles_11,
  t0.descripcion_ingles AS descripcion_ingles_12,
  t0.imagen_optimizada AS imagen_optimizada_13
FROM
  escenario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.descripcion AS descripcion_4, t0.deleted_at AS deleted_at_5, t0.longitud AS longitud_6, t0.latitud AS latitud_7, t0.map_place AS map_place_8, t0.video AS video_9, t0.id_wp AS id_wp_10, t0.nombre_ingles AS nombre_ingles_11, t0.descripcion_ingles AS descripcion_ingles_12, t0.imagen_optimizada AS imagen_optimizada_13 FROM escenario t0 WHERE t0.id = '462';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

2.09 ms

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.deleted_at AS deleted_at_4, t0.imagen_optimizada AS imagen_optimizada_5, t0.escenario_id AS escenario_id_6 FROM foto_escenario t0 WHERE t0.escenario_id = ?

Parameters:

[
  462
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.imagen AS imagen_3,
  t0.deleted_at AS deleted_at_4,
  t0.imagen_optimizada AS imagen_optimizada_5,
  t0.escenario_id AS escenario_id_6
FROM
  foto_escenario t0
WHERE
  t0.escenario_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.deleted_at AS deleted_at_4, t0.imagen_optimizada AS imagen_optimizada_5, t0.escenario_id AS escenario_id_6 FROM foto_escenario t0 WHERE t0.escenario_id = 462;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 139)
9	__TwigTemplate_0522d926366a702a04a1f2388798b611->block_body (line 446)
10	Twig\Template->yieldBlock (line 676)
11	__TwigTemplate_43bd0c156fbaa13855f0eed9d893ecd6->doDisplay (line 402)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_0522d926366a702a04a1f2388798b611->doDisplay (line 402)
14	Twig\Template->yield (line 358)
15	Twig\Template->display (line 373)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 333)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 514)
21	App\Controller\public\PublicController->escenario (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)

6.09 ms

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.link_entradas AS link_entradas_3, t0.enrollment_link AS enrollment_link_4, t0.imagen AS imagen_5, t0.copyright_foto AS copyright_foto_6, t0.fecha AS fecha_7, t0.costo AS costo_8, t0.descripcion AS descripcion_9, t0.fecha_inicio AS fecha_inicio_10, t0.fecha_fin AS fecha_fin_11, t0.facultad AS facultad_12, t0.materiales AS materiales_13, t0.calendario AS calendario_14, t0.sede AS sede_15, t0.numero_horas AS numero_horas_16, t0.plazas AS plazas_17, t0.precio_inicial AS precio_inicial_18, t0.precio_final AS precio_final_19, t0.condiciones_matricula AS condiciones_matricula_20, t0.deleted_at AS deleted_at_21, t0.slug AS slug_22, t0.id_wp AS id_wp_23, t0.id_t3 AS id_t3_24, t0.titulo_ingles AS titulo_ingles_25, t0.descripcion_ingles AS descripcion_ingles_26, t0.imagen_optimizada AS imagen_optimizada_27, t0.publico AS publico_28, t0.condiciones_matricula_ingles AS condiciones_matricula_ingles_29, t0.genero_id AS genero_id_30, t0.escenario_id AS escenario_id_31, t0.tipo_evento_id AS tipo_evento_id_32, t33.id AS id_34, t33.nombre AS nombre_35, t33.pdf AS pdf_36, t33.descripcion AS descripcion_37, t33.deleted_at AS deleted_at_38, t33.nombre_ingles AS nombre_ingles_39, t33.descripcion_ingles AS descripcion_ingles_40, t33.evento_id AS evento_id_41 FROM evento t0 LEFT JOIN programa t33 ON t33.evento_id = t0.id WHERE t0.escenario_id = ?

Parameters:

[
  462
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.link_entradas AS link_entradas_3,
  t0.enrollment_link AS enrollment_link_4,
  t0.imagen AS imagen_5,
  t0.copyright_foto AS copyright_foto_6,
  t0.fecha AS fecha_7,
  t0.costo AS costo_8,
  t0.descripcion AS descripcion_9,
  t0.fecha_inicio AS fecha_inicio_10,
  t0.fecha_fin AS fecha_fin_11,
  t0.facultad AS facultad_12,
  t0.materiales AS materiales_13,
  t0.calendario AS calendario_14,
  t0.sede AS sede_15,
  t0.numero_horas AS numero_horas_16,
  t0.plazas AS plazas_17,
  t0.precio_inicial AS precio_inicial_18,
  t0.precio_final AS precio_final_19,
  t0.condiciones_matricula AS condiciones_matricula_20,
  t0.deleted_at AS deleted_at_21,
  t0.slug AS slug_22,
  t0.id_wp AS id_wp_23,
  t0.id_t3 AS id_t3_24,
  t0.titulo_ingles AS titulo_ingles_25,
  t0.descripcion_ingles AS descripcion_ingles_26,
  t0.imagen_optimizada AS imagen_optimizada_27,
  t0.publico AS publico_28,
  t0.condiciones_matricula_ingles AS condiciones_matricula_ingles_29,
  t0.genero_id AS genero_id_30,
  t0.escenario_id AS escenario_id_31,
  t0.tipo_evento_id AS tipo_evento_id_32,
  t33.id AS id_34,
  t33.nombre AS nombre_35,
  t33.pdf AS pdf_36,
  t33.descripcion AS descripcion_37,
  t33.deleted_at AS deleted_at_38,
  t33.nombre_ingles AS nombre_ingles_39,
  t33.descripcion_ingles AS descripcion_ingles_40,
  t33.evento_id AS evento_id_41
FROM
  evento t0
  LEFT JOIN programa t33 ON t33.evento_id = t0.id
WHERE
  t0.escenario_id = ?

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.link_entradas AS link_entradas_3, t0.enrollment_link AS enrollment_link_4, t0.imagen AS imagen_5, t0.copyright_foto AS copyright_foto_6, t0.fecha AS fecha_7, t0.costo AS costo_8, t0.descripcion AS descripcion_9, t0.fecha_inicio AS fecha_inicio_10, t0.fecha_fin AS fecha_fin_11, t0.facultad AS facultad_12, t0.materiales AS materiales_13, t0.calendario AS calendario_14, t0.sede AS sede_15, t0.numero_horas AS numero_horas_16, t0.plazas AS plazas_17, t0.precio_inicial AS precio_inicial_18, t0.precio_final AS precio_final_19, t0.condiciones_matricula AS condiciones_matricula_20, t0.deleted_at AS deleted_at_21, t0.slug AS slug_22, t0.id_wp AS id_wp_23, t0.id_t3 AS id_t3_24, t0.titulo_ingles AS titulo_ingles_25, t0.descripcion_ingles AS descripcion_ingles_26, t0.imagen_optimizada AS imagen_optimizada_27, t0.publico AS publico_28, t0.condiciones_matricula_ingles AS condiciones_matricula_ingles_29, t0.genero_id AS genero_id_30, t0.escenario_id AS escenario_id_31, t0.tipo_evento_id AS tipo_evento_id_32, t33.id AS id_34, t33.nombre AS nombre_35, t33.pdf AS pdf_36, t33.descripcion AS descripcion_37, t33.deleted_at AS deleted_at_38, t33.nombre_ingles AS nombre_ingles_39, t33.descripcion_ingles AS descripcion_ingles_40, t33.evento_id AS evento_id_41 FROM evento t0 LEFT JOIN programa t33 ON t33.evento_id = t0.id WHERE t0.escenario_id = 462;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1929)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1870)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3309)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 244)
8	__TwigTemplate_0522d926366a702a04a1f2388798b611->block_body (line 446)
9	Twig\Template->yieldBlock (line 676)
10	__TwigTemplate_43bd0c156fbaa13855f0eed9d893ecd6->doDisplay (line 402)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_0522d926366a702a04a1f2388798b611->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 333)
17	Twig\Environment->render (line 243)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 514)
20	App\Controller\public\PublicController->escenario (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
old_wp	doctrine.dbal.old_wp_connection
old_t3	doctrine.dbal.old_t3_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\Escenario	No errors.
App\Entity\Evento	No errors.
App\Entity\FotoEscenario	No errors.
App\Entity\Genero	No errors.
App\Entity\TipoEvento	No errors.
App\Entity\Programa	No errors.
App\Entity\CondicionesEspeciales	No errors.
App\Entity\ProfesorEvento	No errors.
App\Entity\Precio	No errors.
App\Entity\TipoPatrocinioEventoPatrocinador	No errors.
App\Entity\Retransmision	No errors.
App\Entity\ObraPrograma	No errors.
App\Entity\ArtistaObraPrograma	The association App\Entity\ArtistaObraPrograma#artistas refers to the owning side field App\Entity\Artista#artistaObraPrograma which does not exist.

Symfony Profiler

GET https://festival.winecta.com/es/escenario/462

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping