Symfony Profiler

Query Metrics

22 Database Queries

6 Different statements

2.57 ms Query time

4 Invalid entities

152 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.78 ms
(69.20%)

SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.deleted_at AS deleted_at_1,
  m0_.created_at AS created_at_2,
  m0_.orden AS orden_3,
  m0_.nombre AS nombre_4,
  m0_.descripcion AS descripcion_5,
  m0_.color AS color_6,
  m0_.path_ivl AS path_ivl_7,
  m0_.ods_id AS ods_id_8
FROM
  meta m0_
WHERE
  m0_.deleted_at IS NULL
  AND m0_.ods_id = ?
ORDER BY
  m0_.orden ASC

SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = 2 ORDER BY m0_.orden 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\MetaRepository->findMetasByOds (line 41)
7	App\Controller\public\MainPublicController->index (line 53)
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.22 ms
(8.61%)

SELECT e0_.id AS id_0, e0_.deleted_at AS deleted_at_1, e0_.created_at AS created_at_2, e0_.nombre AS nombre_3, e0_.slug AS slug_4, e0_.codigo_postal AS codigo_postal_5, e0_.direccion AS direccion_6, e0_.latitud AS latitud_7, e0_.longitud AS longitud_8, e0_.descripcion_min AS descripcion_min_9, e0_.descripcion AS descripcion_10, e0_.path AS path_11, e0_.codigo_ine AS codigo_ine_12, e0_.habitantes AS habitantes_13, e0_.auto_evaluar_datos AS auto_evaluar_datos_14, e0_.mostrar_parte_publica AS mostrar_parte_publica_15, e0_.path_portada_ivl AS path_portada_ivl_16, e0_.path_fondo_ivl AS path_fondo_ivl_17, e0_.path_contraportada_ivl AS path_contraportada_ivl_18, e0_.optimizado_portada_ivl AS optimizado_portada_ivl_19, e0_.optimizado_fondo_ivl AS optimizado_fondo_ivl_20, e0_.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_21, e0_.color_titulos_ivl AS color_titulos_ivl_22, e0_.color_subtitulos_ivl AS color_subtitulos_ivl_23, e0_.color_textos_ivl AS color_textos_ivl_24, e0_.color_corporativo AS color_corporativo_25, e0_.color_fondo AS color_fondo_26, e0_.comunidad_id AS comunidad_id_27, e0_.provincia_id AS provincia_id_28, e0_.poblacion_id AS poblacion_id_29 FROM entidad_local e0_ WHERE e0_.deleted_at IS NULL AND e0_.mostrar_parte_publica = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.deleted_at AS deleted_at_1,
  e0_.created_at AS created_at_2,
  e0_.nombre AS nombre_3,
  e0_.slug AS slug_4,
  e0_.codigo_postal AS codigo_postal_5,
  e0_.direccion AS direccion_6,
  e0_.latitud AS latitud_7,
  e0_.longitud AS longitud_8,
  e0_.descripcion_min AS descripcion_min_9,
  e0_.descripcion AS descripcion_10,
  e0_.path AS path_11,
  e0_.codigo_ine AS codigo_ine_12,
  e0_.habitantes AS habitantes_13,
  e0_.auto_evaluar_datos AS auto_evaluar_datos_14,
  e0_.mostrar_parte_publica AS mostrar_parte_publica_15,
  e0_.path_portada_ivl AS path_portada_ivl_16,
  e0_.path_fondo_ivl AS path_fondo_ivl_17,
  e0_.path_contraportada_ivl AS path_contraportada_ivl_18,
  e0_.optimizado_portada_ivl AS optimizado_portada_ivl_19,
  e0_.optimizado_fondo_ivl AS optimizado_fondo_ivl_20,
  e0_.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_21,
  e0_.color_titulos_ivl AS color_titulos_ivl_22,
  e0_.color_subtitulos_ivl AS color_subtitulos_ivl_23,
  e0_.color_textos_ivl AS color_textos_ivl_24,
  e0_.color_corporativo AS color_corporativo_25,
  e0_.color_fondo AS color_fondo_26,
  e0_.comunidad_id AS comunidad_id_27,
  e0_.provincia_id AS provincia_id_28,
  e0_.poblacion_id AS poblacion_id_29
FROM
  entidad_local e0_
WHERE
  e0_.deleted_at IS NULL
  AND e0_.mostrar_parte_publica = 1

SELECT e0_.id AS id_0, e0_.deleted_at AS deleted_at_1, e0_.created_at AS created_at_2, e0_.nombre AS nombre_3, e0_.slug AS slug_4, e0_.codigo_postal AS codigo_postal_5, e0_.direccion AS direccion_6, e0_.latitud AS latitud_7, e0_.longitud AS longitud_8, e0_.descripcion_min AS descripcion_min_9, e0_.descripcion AS descripcion_10, e0_.path AS path_11, e0_.codigo_ine AS codigo_ine_12, e0_.habitantes AS habitantes_13, e0_.auto_evaluar_datos AS auto_evaluar_datos_14, e0_.mostrar_parte_publica AS mostrar_parte_publica_15, e0_.path_portada_ivl AS path_portada_ivl_16, e0_.path_fondo_ivl AS path_fondo_ivl_17, e0_.path_contraportada_ivl AS path_contraportada_ivl_18, e0_.optimizado_portada_ivl AS optimizado_portada_ivl_19, e0_.optimizado_fondo_ivl AS optimizado_fondo_ivl_20, e0_.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_21, e0_.color_titulos_ivl AS color_titulos_ivl_22, e0_.color_subtitulos_ivl AS color_subtitulos_ivl_23, e0_.color_textos_ivl AS color_textos_ivl_24, e0_.color_corporativo AS color_corporativo_25, e0_.color_fondo AS color_fondo_26, e0_.comunidad_id AS comunidad_id_27, e0_.provincia_id AS provincia_id_28, e0_.poblacion_id AS poblacion_id_29 FROM entidad_local e0_ WHERE e0_.deleted_at IS NULL AND e0_.mostrar_parte_publica = 1;

#	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\EntidadLocalRepository->findEntidadesLocalesPublicasByNombre (line 173)
7	App\Controller\public\MainPublicController->index (line 47)
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.21 ms
(8.37%)

SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.host AS host_2,
  t0.puerto AS puerto_3,
  t0.seguridad AS seguridad_4,
  t0.email AS email_5,
  t0.password AS password_6
FROM
  smtp t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp t0 WHERE t0.id = 1;

#	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	App\Service\EmailService->__construct (line 34)
7	ContainerNA3ahg0\getEmailServiceService->do (line 30)
8	ContainerNA3ahg0\App_KernelDevDebugContainer::load (line 588)
9	ContainerNA3ahg0\getAppCustomAuthenticatorService->do (line 35)
10	ContainerNA3ahg0\App_KernelDevDebugContainer::load (line 588)
11	ContainerNA3ahg0\getSecurity_Firewall_Map_Context_MainService->do (line 32)
12	ContainerNA3ahg0\App_KernelDevDebugContainer::load (line 588)
13	Symfony\Component\DependencyInjection\Container->getService (line 398)
14	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 40)
15	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallContext (line 69)
16	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallConfig (line 49)
17	Symfony\Bundle\SecurityBundle\EventListener\FirewallListener->configureLogoutUrlGenerator (line 45)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.13 ms
(4.99%)

SELECT g0_.id AS id_0, g0_.texto AS texto_1, g0_.path AS path_2, g0_.url AS url_3, g0_.orden AS orden_4 FROM galeria g0_ ORDER BY g0_.orden ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.texto AS texto_1,
  g0_.path AS path_2,
  g0_.url AS url_3,
  g0_.orden AS orden_4
FROM
  galeria g0_
ORDER BY
  g0_.orden ASC

SELECT g0_.id AS id_0, g0_.texto AS texto_1, g0_.path AS path_2, g0_.url AS url_3, g0_.orden AS orden_4 FROM galeria g0_ ORDER BY g0_.orden 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\GaleriaRepository->findTodos (line 24)
7	App\Controller\public\MainPublicController->index (line 46)
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.11 ms
(4.44%)

SELECT o0_.id AS id_0, o0_.deleted_at AS deleted_at_1, o0_.created_at AS created_at_2, o0_.orden AS orden_3, o0_.nombre AS nombre_4, o0_.descripcion AS descripcion_5, o0_.color AS color_6, o0_.path_ivl AS path_ivl_7 FROM ods o0_ WHERE o0_.deleted_at IS NULL ORDER BY o0_.orden ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.deleted_at AS deleted_at_1,
  o0_.created_at AS created_at_2,
  o0_.orden AS orden_3,
  o0_.nombre AS nombre_4,
  o0_.descripcion AS descripcion_5,
  o0_.color AS color_6,
  o0_.path_ivl AS path_ivl_7
FROM
  ods o0_
WHERE
  o0_.deleted_at IS NULL
ORDER BY
  o0_.orden ASC

SELECT o0_.id AS id_0, o0_.deleted_at AS deleted_at_1, o0_.created_at AS created_at_2, o0_.orden AS orden_3, o0_.nombre AS nombre_4, o0_.descripcion AS descripcion_5, o0_.color AS color_6, o0_.path_ivl AS path_ivl_7 FROM ods o0_ WHERE o0_.deleted_at IS NULL ORDER BY o0_.orden 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\OdsRepository->findTodos (line 38)
7	App\Controller\public\MainPublicController->index (line 48)
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.11 ms
(4.40%)

SELECT f0_.id AS id_0, f0_.created_at AS created_at_1, f0_.deleted_at AS deleted_at_2, f0_.orden AS orden_3, f0_.pregunta AS pregunta_4, f0_.respuesta AS respuesta_5, f0_.categoria_faq_id AS categoria_faq_id_6 FROM faq f0_ LEFT JOIN categoria_faq c1_ ON f0_.categoria_faq_id = c1_.id WHERE f0_.deleted_at IS NULL ORDER BY c1_.orden ASC, f0_.orden ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.created_at AS created_at_1,
  f0_.deleted_at AS deleted_at_2,
  f0_.orden AS orden_3,
  f0_.pregunta AS pregunta_4,
  f0_.respuesta AS respuesta_5,
  f0_.categoria_faq_id AS categoria_faq_id_6
FROM
  faq f0_
  LEFT JOIN categoria_faq c1_ ON f0_.categoria_faq_id = c1_.id
WHERE
  f0_.deleted_at IS NULL
ORDER BY
  c1_.orden ASC,
  f0_.orden ASC

SELECT f0_.id AS id_0, f0_.created_at AS created_at_1, f0_.deleted_at AS deleted_at_2, f0_.orden AS orden_3, f0_.pregunta AS pregunta_4, f0_.respuesta AS respuesta_5, f0_.categoria_faq_id AS categoria_faq_id_6 FROM faq f0_ LEFT JOIN categoria_faq c1_ ON f0_.categoria_faq_id = c1_.id WHERE f0_.deleted_at IS NULL ORDER BY c1_.orden ASC, f0_.orden 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\FaqRepository->findPublicos (line 51)
7	App\Controller\public\MainPublicController->index (line 56)
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\Meta	112
App\Entity\Ods	17
App\Entity\Faq	15
App\Entity\Galeria	2
App\Entity\Smtp	1
App\Entity\EntidadLocal	1
App\Entity\Comunidad	1
App\Entity\Provincia	1
App\Entity\Poblacion	1
App\Entity\CategoriaFaq	1

Entities Mapping

Class	Mapping errors
App\Entity\Smtp	No errors.
App\Entity\Galeria	No errors.
App\Entity\EntidadLocal	No errors.
App\Entity\Comunidad	No errors.
App\Entity\Provincia	The association App\Entity\Provincia#comunidad refers to the inverse side field App\Entity\Comunidad#provincias which does not exist.
App\Entity\Poblacion	The association App\Entity\Poblacion#provincia refers to the inverse side field App\Entity\Provincia#poblaciones which does not exist.
App\Entity\Usuario	The association App\Entity\Usuario#comunidad refers to the inverse side field App\Entity\Comunidad#usuarios which does not exist. The association App\Entity\Usuario#provincia refers to the inverse side field App\Entity\Provincia#usuarios which does not exist. The association App\Entity\Usuario#poblacion refers to the inverse side field App\Entity\Poblacion#usuarios which does not exist.
App\Entity\Cluster	No errors.
App\Entity\Anio	No errors.
App\Entity\Ivl	No errors.
App\Entity\Ods	No errors.
App\Entity\Meta	No errors.
App\Entity\Faq	The association App\Entity\Faq#categoriaFaq refers to the inverse side field App\Entity\CategoriaFaq#faqs which does not exist.
App\Entity\CategoriaFaq	No errors.

Symfony Profiler

GET https://prefemp.winecta.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping