Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

299.10 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

296.11 ms
(99.00%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nombre AS nombre_2, c0_.enabled AS enabled_3, c0_.disabletranslation AS disabletranslation_4, c0_.descripcion_corta AS descripcion_corta_5, c0_.descripcion_larga AS descripcion_larga_6, c0_.destacada AS destacada_7, c0_.localizacion AS localizacion_8, c0_.position AS position_9, ST_AsEWKT(c0_.point) AS point_10, c0_.deleted_at AS deleted_at_11 FROM ciudad c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.nombre AS nombre_2,
  c0_.enabled AS enabled_3,
  c0_.disabletranslation AS disabletranslation_4,
  c0_.descripcion_corta AS descripcion_corta_5,
  c0_.descripcion_larga AS descripcion_larga_6,
  c0_.destacada AS destacada_7,
  c0_.localizacion AS localizacion_8,
  c0_.position AS position_9,
  ST_AsEWKT(c0_.point) AS point_10,
  c0_.deleted_at AS deleted_at_11
FROM
  ciudad c0_
WHERE
  (c0_.deleted_at IS NULL)
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nombre AS nombre_2, c0_.enabled AS enabled_3, c0_.disabletranslation AS disabletranslation_4, c0_.descripcion_corta AS descripcion_corta_5, c0_.descripcion_larga AS descripcion_larga_6, c0_.destacada AS destacada_7, c0_.localizacion AS localizacion_8, c0_.position AS position_9, ST_AsEWKT(c0_.point) AS point_10, c0_.deleted_at AS deleted_at_11 FROM ciudad c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.position 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\Controller\HomePageController->homepage (line 91)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.14 ms
(0.38%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.asunto AS asunto_3, c0_.disabletranslation AS disabletranslation_4, c0_.fecha_inicio AS fecha_inicio_5, c0_.destacada AS destacada_6, c0_.fecha_fin AS fecha_fin_7, c0_.cuerpo AS cuerpo_8, c0_.direccion AS direccion_9, c0_.telefono AS telefono_10, c0_.web AS web_11, c0_.localizacion AS localizacion_12, c0_.ciudad_id AS ciudad_id_13, c0_.tipo AS tipo_14 FROM calendario c0_ WHERE c0_.fecha_inicio > CURRENT_TIMESTAMP

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.enabled AS enabled_2,
  c0_.asunto AS asunto_3,
  c0_.disabletranslation AS disabletranslation_4,
  c0_.fecha_inicio AS fecha_inicio_5,
  c0_.destacada AS destacada_6,
  c0_.fecha_fin AS fecha_fin_7,
  c0_.cuerpo AS cuerpo_8,
  c0_.direccion AS direccion_9,
  c0_.telefono AS telefono_10,
  c0_.web AS web_11,
  c0_.localizacion AS localizacion_12,
  c0_.ciudad_id AS ciudad_id_13,
  c0_.tipo AS tipo_14
FROM
  calendario c0_
WHERE
  c0_.fecha_inicio > CURRENT_TIMESTAMP

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.asunto AS asunto_3, c0_.disabletranslation AS disabletranslation_4, c0_.fecha_inicio AS fecha_inicio_5, c0_.destacada AS destacada_6, c0_.fecha_fin AS fecha_fin_7, c0_.cuerpo AS cuerpo_8, c0_.direccion AS direccion_9, c0_.telefono AS telefono_10, c0_.web AS web_11, c0_.localizacion AS localizacion_12, c0_.ciudad_id AS ciudad_id_13, c0_.tipo AS tipo_14 FROM calendario c0_ WHERE c0_.fecha_inicio > CURRENT_TIMESTAMP;

#	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\Controller\HomePageController->getEventos (line 49)
7	App\Controller\HomePageController->homepage (line 104)
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)

1.04 ms
(0.35%)

SELECT f0_.id AS id_0, f0_.nombre AS nombre_1, f0_.enabled AS enabled_2, f0_.disabletranslation AS disabletranslation_3, f0_.url AS url_4, f0_.nolocal AS nolocal_5, f0_.auth AS auth_6, f0_.position AS position_7, f0_.deleted_at AS deleted_at_8, f0_.parent_id AS parent_id_9 FROM front_menu f0_ WHERE f0_.parent_id IS NULL AND f0_.enabled = true ORDER BY f0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nombre AS nombre_1,
  f0_.enabled AS enabled_2,
  f0_.disabletranslation AS disabletranslation_3,
  f0_.url AS url_4,
  f0_.nolocal AS nolocal_5,
  f0_.auth AS auth_6,
  f0_.position AS position_7,
  f0_.deleted_at AS deleted_at_8,
  f0_.parent_id AS parent_id_9
FROM
  front_menu f0_
WHERE
  f0_.parent_id IS NULL
  AND f0_.enabled = true
ORDER BY
  f0_.position ASC

SELECT f0_.id AS id_0, f0_.nombre AS nombre_1, f0_.enabled AS enabled_2, f0_.disabletranslation AS disabletranslation_3, f0_.url AS url_4, f0_.nolocal AS nolocal_5, f0_.auth AS auth_6, f0_.position AS position_7, f0_.deleted_at AS deleted_at_8, f0_.parent_id AS parent_id_9 FROM front_menu f0_ WHERE f0_.parent_id IS NULL AND f0_.enabled = true ORDER BY f0_.position 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\Controller\HomePageController->getMenu (line 28)
7	App\Controller\HomePageController->homepage (line 114)
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.82 ms
(0.27%)

SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.enabled AS enabled_2, t0_.disabletranslation AS disabletranslation_3, t0_.nombre AS nombre_4, t0_.descripcion AS descripcion_5, t0_.ruta_archivo AS ruta_archivo_6, t0_.position AS position_7 FROM tipo_poi t0_ ORDER BY t0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.code AS code_1,
  t0_.enabled AS enabled_2,
  t0_.disabletranslation AS disabletranslation_3,
  t0_.nombre AS nombre_4,
  t0_.descripcion AS descripcion_5,
  t0_.ruta_archivo AS ruta_archivo_6,
  t0_.position AS position_7
FROM
  tipo_poi t0_
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.enabled AS enabled_2, t0_.disabletranslation AS disabletranslation_3, t0_.nombre AS nombre_4, t0_.descripcion AS descripcion_5, t0_.ruta_archivo AS ruta_archivo_6, t0_.position AS position_7 FROM tipo_poi t0_ ORDER BY t0_.id 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\Controller\HomePageController->homepage (line 106)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	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

Entities Mapping

Class	Mapping errors
App\Entity\Ciudad	No errors.
App\Entity\Calendario	No errors.
App\Entity\CalendarioTipos	No errors.
App\Entity\TipoPoi	No errors.
App\Entity\Frontmenu	No errors.
App\Entity\Imagen	No errors.
App\Entity\Panoramica	No errors.
App\Entity\Video	No errors.
App\Entity\Recurso	No errors.
App\Entity\Poi	No errors.
App\Entity\Qrcode	No errors.
App\Entity\Ruta	No errors.
App\Entity\VisitaVirtual	No errors.
App\Entity\RutaPersonalizada	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Translation\CiudadTranslation	No errors.
App\Translation\CalendarioTranslation	No errors.
App\Translation\CalendarioTiposTranslation	No errors.
App\Translation\TipoPoiTranslation	No errors.
App\Translation\FrontmenuTranslation	No errors.

Symfony Profiler

GET https://agoncillo.mapescador.duckdns.org/es/cookie_consent_alt?locale=es

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping