Symfony Profiler

Query Metrics

14 Database Queries

5 Different statements

6.86 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.88 ms
(27.41%)

SELECT f0_.id AS id_0, f0_.locale AS locale_1, f0_.field AS field_2, f0_.content AS content_3, f0_.object_id AS object_id_4 FROM frontmenu_translations f0_ WHERE f0_.object_id = ? AND f0_.locale = ? AND f0_.field = 'nombre' ORDER BY f0_.id DESC

Parameters:

[
  1
  "es"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.locale AS locale_1,
  f0_.field AS field_2,
  f0_.content AS content_3,
  f0_.object_id AS object_id_4
FROM
  frontmenu_translations f0_
WHERE
  f0_.object_id = ?
  AND f0_.locale = ?
  AND f0_.field = 'nombre'
ORDER BY
  f0_.id DESC

SELECT f0_.id AS id_0, f0_.locale AS locale_1, f0_.field AS field_2, f0_.content AS content_3, f0_.object_id AS object_id_4 FROM frontmenu_translations f0_ WHERE f0_.object_id = 1 AND f0_.locale = 'es' AND f0_.field = 'nombre' ORDER BY f0_.id DESC;

#	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 33)
7	App\Controller\HomePageController->eventodetalle (line 484)
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.40 ms
(20.46%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.accesible AS accesible_3, c0_.asunto AS asunto_4, c0_.disabletranslation AS disabletranslation_5, c0_.fecha_inicio AS fecha_inicio_6, c0_.destacada AS destacada_7, c0_.fecha_fin AS fecha_fin_8, c0_.cuerpo AS cuerpo_9, c0_.direccion AS direccion_10, c0_.telefono AS telefono_11, c0_.web AS web_12, c0_.localizacion AS localizacion_13, c0_.ciudad_id AS ciudad_id_14, c0_.tipo AS tipo_15 FROM calendario c0_ WHERE c0_.code = ?

Parameters:

[
  "{{ asset("
]

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_.accesible AS accesible_3,
  c0_.asunto AS asunto_4,
  c0_.disabletranslation AS disabletranslation_5,
  c0_.fecha_inicio AS fecha_inicio_6,
  c0_.destacada AS destacada_7,
  c0_.fecha_fin AS fecha_fin_8,
  c0_.cuerpo AS cuerpo_9,
  c0_.direccion AS direccion_10,
  c0_.telefono AS telefono_11,
  c0_.web AS web_12,
  c0_.localizacion AS localizacion_13,
  c0_.ciudad_id AS ciudad_id_14,
  c0_.tipo AS tipo_15
FROM
  calendario c0_
WHERE
  c0_.code = ?

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.accesible AS accesible_3, c0_.asunto AS asunto_4, c0_.disabletranslation AS disabletranslation_5, c0_.fecha_inicio AS fecha_inicio_6, c0_.destacada AS destacada_7, c0_.fecha_fin AS fecha_fin_8, c0_.cuerpo AS cuerpo_9, c0_.direccion AS direccion_10, c0_.telefono AS telefono_11, c0_.web AS web_12, c0_.localizacion AS localizacion_13, c0_.ciudad_id AS ciudad_id_14, c0_.tipo AS tipo_15 FROM calendario c0_ WHERE c0_.code = '{{ asset(';

#	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->eventodetalle (line 467)
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.32 ms
(19.20%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  frontmenu_translations t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 525)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
16	Doctrine\ORM\AbstractQuery->execute (line 886)
17	Doctrine\ORM\AbstractQuery->getResult (line 688)
18	App\Controller\HomePageController->getMenu (line 28)
19	App\Controller\HomePageController->eventodetalle (line 484)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.23 ms
(17.97%)

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->eventodetalle (line 484)
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.03 ms
(14.96%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.url AS url_5, t0.nolocal AS nolocal_6, t0.auth AS auth_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM front_menu t0 WHERE t0.parent_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.enabled AS enabled_3,
  t0.disabletranslation AS disabletranslation_4,
  t0.url AS url_5,
  t0.nolocal AS nolocal_6,
  t0.auth AS auth_7,
  t0.position AS position_8,
  t0.deleted_at AS deleted_at_9,
  t0.parent_id AS parent_id_10
FROM
  front_menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.url AS url_5, t0.nolocal AS nolocal_6, t0.auth AS auth_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM front_menu t0 WHERE t0.parent_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Frontmenu->hasChildren (line 160)
9	App\Controller\HomePageController->getMenu (line 35)
10	App\Controller\HomePageController->eventodetalle (line 484)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	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\Translation\FrontmenuTranslation	12
App\Entity\Frontmenu	4

Entities Mapping

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

Symfony Profiler

GET https://www.rutasdeagoncillo.es/es/evento/%7B%7B%20asset%28

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping