Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

21.36 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

14.33 ms
(67.11%)

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.pdf AS pdf_2, p0_.descripcion AS descripcion_3, p0_.deleted_at AS deleted_at_4, p0_.nombre_ingles AS nombre_ingles_5, p0_.descripcion_ingles AS descripcion_ingles_6, p0_.evento_id AS evento_id_7 FROM programa p0_ WHERE p0_.deleted_at IS NULL ORDER BY p0_.nombre DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.pdf AS pdf_2,
  p0_.descripcion AS descripcion_3,
  p0_.deleted_at AS deleted_at_4,
  p0_.nombre_ingles AS nombre_ingles_5,
  p0_.descripcion_ingles AS descripcion_ingles_6,
  p0_.evento_id AS evento_id_7
FROM
  programa p0_
WHERE
  p0_.deleted_at IS NULL
ORDER BY
  p0_.nombre DESC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.pdf AS pdf_2, p0_.descripcion AS descripcion_3, p0_.deleted_at AS deleted_at_4, p0_.nombre_ingles AS nombre_ingles_5, p0_.descripcion_ingles AS descripcion_ingles_6, p0_.evento_id AS evento_id_7 FROM programa p0_ WHERE p0_.deleted_at IS NULL ORDER BY p0_.nombre DESC;

#	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 51)
7	App\Repository\ProgramaRepository->findProgramas (line 34)
8	App\Controller\ProgramaController->index (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)

3.00 ms
(14.03%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE ?

Parameters:

[
  "%2024 Le Concert des Nations%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  programa p0_
  LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id
WHERE
  p0_.deleted_at IS NULL
  AND p0_.nombre LIKE ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE '%2024 Le Concert des Nations%';

#	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 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container2Xxzuox\PaginatorProxy9cc2a8f->paginate (line 28)
16	App\Controller\ProgramaController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

2.06 ms
(9.65%)

SELECT DISTINCT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE ? ORDER BY p0_.nombre DESC LIMIT 20

Parameters:

[
  "%2024 Le Concert des Nations%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  programa p0_
  LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id
WHERE
  p0_.deleted_at IS NULL
  AND p0_.nombre LIKE ?
ORDER BY
  p0_.nombre DESC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE '%2024 Le Concert des Nations%' ORDER BY p0_.nombre DESC LIMIT 20;

#	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 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container2Xxzuox\PaginatorProxy9cc2a8f->paginate (line 28)
16	App\Controller\ProgramaController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.55 ms
(2.57%)

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.pdf AS pdf_2, p0_.descripcion AS descripcion_3, p0_.deleted_at AS deleted_at_4, p0_.nombre_ingles AS nombre_ingles_5, p0_.descripcion_ingles AS descripcion_ingles_6, p0_.evento_id AS evento_id_7 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE ? AND p0_.id IN (?) ORDER BY p0_.nombre DESC

Parameters:

[
  "%2024 Le Concert des Nations%"
  7982
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.pdf AS pdf_2,
  p0_.descripcion AS descripcion_3,
  p0_.deleted_at AS deleted_at_4,
  p0_.nombre_ingles AS nombre_ingles_5,
  p0_.descripcion_ingles AS descripcion_ingles_6,
  p0_.evento_id AS evento_id_7
FROM
  programa p0_
  LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id
WHERE
  p0_.deleted_at IS NULL
  AND p0_.nombre LIKE ?
  AND p0_.id IN (?)
ORDER BY
  p0_.nombre DESC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.pdf AS pdf_2, p0_.descripcion AS descripcion_3, p0_.deleted_at AS deleted_at_4, p0_.nombre_ingles AS nombre_ingles_5, p0_.descripcion_ingles AS descripcion_ingles_6, p0_.evento_id AS evento_id_7 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE '%2024 Le Concert des Nations%' AND p0_.id IN (7982) ORDER BY p0_.nombre DESC;

#	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 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container2Xxzuox\PaginatorProxy9cc2a8f->paginate (line 28)
16	App\Controller\ProgramaController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.45 ms
(2.11%)

SELECT t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.email AS email_8, t0.nombre AS nombre_9, t0.rol FROM `usuario` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN editor t2 ON t0.id = t2.id LEFT JOIN cliente t3 ON t0.id = t3.id WHERE t0.id = ?

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_4,
  t0.deleted_at AS deleted_at_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.email AS email_8,
  t0.nombre AS nombre_9,
  t0.rol
FROM
  `usuario` t0
  LEFT JOIN admin t1 ON t0.id = t1.id
  LEFT JOIN editor t2 ON t0.id = t2.id
  LEFT JOIN cliente t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.email AS email_8, t0.nombre AS nombre_9, t0.rol FROM `usuario` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN editor t2 ON t0.id = t2.id LEFT JOIN cliente t3 ON t0.id = t3.id WHERE t0.id = 24;

#	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 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.43 ms
(1.99%)

SELECT e0_.fecha AS fecha_0 FROM programa p1_ LEFT JOIN evento e0_ ON p1_.evento_id = e0_.id WHERE p1_.deleted_at IS NULL AND e0_.fecha IS NOT NULL ORDER BY e0_.fecha DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.fecha AS fecha_0
FROM
  programa p1_
  LEFT JOIN evento e0_ ON p1_.evento_id = e0_.id
WHERE
  p1_.deleted_at IS NULL
  AND e0_.fecha IS NOT NULL
ORDER BY
  e0_.fecha DESC

SELECT e0_.fecha AS fecha_0 FROM programa p1_ LEFT JOIN evento e0_ ON p1_.evento_id = e0_.id WHERE p1_.deleted_at IS NULL AND e0_.fecha IS NOT NULL ORDER BY e0_.fecha DESC;

#	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 67)
7	App\Repository\ProgramaRepository->findAñosDisponibles (line 35)
8	App\Controller\ProgramaController->index (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)

0.34 ms
(1.61%)

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.id = ?

Parameters:

[
  18514
]

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.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.id = 18514;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Evento::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Evento->__get (line 207)
8	App\Entity\Evento->getTitulo (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 287)
10	__TwigTemplate_b76a632cc375f98068d707bf85916f56->block_body (line 446)
11	Twig\Template->yieldBlock (line 1168)
12	__TwigTemplate_681a32644b177ebc1e117882f2653509->doDisplay (line 402)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_b76a632cc375f98068d707bf85916f56->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
22	App\Controller\ProgramaController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.20 ms
(0.93%)

SELECT c0_.id AS id_0, c0_.clave_tiny AS clave_tiny_1 FROM configuracion c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.clave_tiny AS clave_tiny_1
FROM
  configuracion c0_

SELECT c0_.id AS id_0, c0_.clave_tiny AS clave_tiny_1 FROM configuracion c0_;

#	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 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 28)
7	App\Repository\ConfiguracionRepository->findConfiguracion (line 563)
8	App\Controller\AjaxController->tiny (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 1281)
16	__TwigTemplate_681a32644b177ebc1e117882f2653509->block_javascripts (line 446)
17	Twig\Template->yieldBlock (line 76)
18	__TwigTemplate_681a32644b177ebc1e117882f2653509->doDisplay (line 402)
19	Twig\Template->yield (line 53)
20	__TwigTemplate_b76a632cc375f98068d707bf85916f56->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 243)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
28	App\Controller\ProgramaController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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\Usuario	No errors.
App\Entity\Admin	No errors.
App\Entity\Editor	No errors.
App\Entity\Cliente	No errors.
App\Entity\Programa	No errors.
App\Entity\Evento	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.
App\Entity\Configuracion	No errors.
App\Entity\RetransmisionCliente	No errors.
App\Entity\CondicionesEspeciales	No errors.
App\Entity\ProfesorEvento	No errors.
App\Entity\Genero	No errors.
App\Entity\Precio	No errors.
App\Entity\Escenario	No errors.
App\Entity\TipoEvento	No errors.
App\Entity\TipoPatrocinioEventoPatrocinador	No errors.
App\Entity\Retransmision	No errors.
App\Entity\Obra	No errors.
App\Entity\Artista	No errors.

Symfony Profiler

GET https://festival.winecta.com/admin/programa/?a%C3%B1o=&search=2024%20Le%20Concert%20des%20Nations

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping