Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

21.02 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

14.33 ms
(68.21%)

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.26%)

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.81%)

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.61%)

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.15%)

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
(2.03%)

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.20 ms
(0.94%)

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.

Symfony Profiler

GET https://festival.winecta.com/ajax/tiny/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping