Symfony Profiler

Query Metrics

38 Database Queries

6 Different statements

51.35 ms Query time

0 Invalid entities

266 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

29.78 ms
(58.00%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nombre AS nombre_3, t0.enabled AS enabled_4, t0.accesible AS accesible_5, t0.disabletranslation AS disabletranslation_6, t0.descripcion_corta AS descripcion_corta_7, t0.descripcion_larga AS descripcion_larga_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.horario AS horario_11, t0.web AS web_12, t0.localizacion AS localizacion_13, t0.destacada AS destacada_14, t0.position AS position_15, ST_AsEWKT(t0.point) AS point_16, t0.deleted_at AS deleted_at_17, t0.ciudad_id AS ciudad_id_18, t0.tipo_poi_id AS tipo_poi_id_19, t0.ruta_id AS ruta_id_20, t0.visitavirtual_id AS visitavirtual_id_21 FROM poi t0 WHERE t0.enabled = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nombre AS nombre_3,
  t0.enabled AS enabled_4,
  t0.accesible AS accesible_5,
  t0.disabletranslation AS disabletranslation_6,
  t0.descripcion_corta AS descripcion_corta_7,
  t0.descripcion_larga AS descripcion_larga_8,
  t0.direccion AS direccion_9,
  t0.telefono AS telefono_10,
  t0.horario AS horario_11,
  t0.web AS web_12,
  t0.localizacion AS localizacion_13,
  t0.destacada AS destacada_14,
  t0.position AS position_15,
  ST_AsEWKT(t0.point) AS point_16,
  t0.deleted_at AS deleted_at_17,
  t0.ciudad_id AS ciudad_id_18,
  t0.tipo_poi_id AS tipo_poi_id_19,
  t0.ruta_id AS ruta_id_20,
  t0.visitavirtual_id AS visitavirtual_id_21
FROM
  poi t0
WHERE
  t0.enabled = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.nombre AS nombre_3, t0.enabled AS enabled_4, t0.accesible AS accesible_5, t0.disabletranslation AS disabletranslation_6, t0.descripcion_corta AS descripcion_corta_7, t0.descripcion_larga AS descripcion_larga_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.horario AS horario_11, t0.web AS web_12, t0.localizacion AS localizacion_13, t0.destacada AS destacada_14, t0.position AS position_15, ST_AsEWKT(t0.point) AS point_16, t0.deleted_at AS deleted_at_17, t0.ciudad_id AS ciudad_id_18, t0.tipo_poi_id AS tipo_poi_id_19, t0.ruta_id AS ruta_id_20, t0.visitavirtual_id AS visitavirtual_id_21 FROM poi t0 WHERE t0.enabled = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\MapController->loadAction (line 48)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 10)

11.69 ms
(22.77%)

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 poi_translations t0 WHERE t0.object_id = ?

Parameters:

[
  158
]

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
  poi_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 poi_translations t0 WHERE t0.object_id = 158;

#	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 2733)
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 3214)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
16	Doctrine\ORM\EntityRepository->findBy (line 110)
17	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
18	App\Controller\MapController->loadAction (line 48)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 10)

2.62 ms
(5.10%)

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 ruta_translations t0 WHERE t0.object_id = ?

Parameters:

[
  3
]

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
  ruta_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 ruta_translations t0 WHERE t0.object_id = 3;

#	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 2733)
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 3214)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
16	Doctrine\ORM\EntityRepository->findBy (line 110)
17	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
18	App\Controller\MapController->loadAction (line 49)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 10)

2.59 ms
(5.05%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.ruta_archivo AS ruta_archivo_7, t0.position AS position_8 FROM tipo_poi t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.enabled AS enabled_3,
  t0.disabletranslation AS disabletranslation_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.ruta_archivo AS ruta_archivo_7,
  t0.position AS position_8
FROM
  tipo_poi t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.ruta_archivo AS ruta_archivo_7, t0.position AS position_8 FROM tipo_poi t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\TipoPoi::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\TipoPoi->__get (line 129)
7	App\Entity\TipoPoi->getWebPath (line 178)
8	App\Controller\MapController->loadAction (line 65)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 10)

2.56 ms
(4.99%)

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 tipo_poi_translations t0 WHERE t0.object_id = ?

Parameters:

[
  4
]

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
  tipo_poi_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 tipo_poi_translations t0 WHERE t0.object_id = 4;

#	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 2733)
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 3214)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
17	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
18	Proxies\__CG__\App\Entity\TipoPoi::Doctrine\ORM\Proxy\{closure} (line 373)
19	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
20	Proxies\__CG__\App\Entity\TipoPoi->__get (line 129)
21	App\Entity\TipoPoi->getWebPath (line 178)
22	App\Controller\MapController->loadAction (line 65)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 10)

2.10 ms
(4.10%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nombre AS nombre_3, t0.enabled AS enabled_4, t0.disabletranslation AS disabletranslation_5, t0.color AS color_6, t0.descripcion_corta AS descripcion_corta_7, t0.descripcion_larga AS descripcion_larga_8, t0.folleto AS folleto_9, t0.folleto_url AS folleto_url_10, t0.folletopdf AS folletopdf_11, t0.folletopdf_url AS folletopdf_url_12, t0.geojson AS geojson_13, t0.destacada AS destacada_14, t0.position AS position_15, ST_AsEWKT(t0.linestring) AS linestring_16, t0.distancia AS distancia_17, t0.tiempo AS tiempo_18, t0.dificultad AS dificultad_19, t0.deleted_at AS deleted_at_20, t0.ciudad_id AS ciudad_id_21 FROM ruta t0 WHERE t0.enabled = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nombre AS nombre_3,
  t0.enabled AS enabled_4,
  t0.disabletranslation AS disabletranslation_5,
  t0.color AS color_6,
  t0.descripcion_corta AS descripcion_corta_7,
  t0.descripcion_larga AS descripcion_larga_8,
  t0.folleto AS folleto_9,
  t0.folleto_url AS folleto_url_10,
  t0.folletopdf AS folletopdf_11,
  t0.folletopdf_url AS folletopdf_url_12,
  t0.geojson AS geojson_13,
  t0.destacada AS destacada_14,
  t0.position AS position_15,
  ST_AsEWKT(t0.linestring) AS linestring_16,
  t0.distancia AS distancia_17,
  t0.tiempo AS tiempo_18,
  t0.dificultad AS dificultad_19,
  t0.deleted_at AS deleted_at_20,
  t0.ciudad_id AS ciudad_id_21
FROM
  ruta t0
WHERE
  t0.enabled = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.nombre AS nombre_3, t0.enabled AS enabled_4, t0.disabletranslation AS disabletranslation_5, t0.color AS color_6, t0.descripcion_corta AS descripcion_corta_7, t0.descripcion_larga AS descripcion_larga_8, t0.folleto AS folleto_9, t0.folleto_url AS folleto_url_10, t0.folletopdf AS folletopdf_11, t0.folletopdf_url AS folletopdf_url_12, t0.geojson AS geojson_13, t0.destacada AS destacada_14, t0.position AS position_15, ST_AsEWKT(t0.linestring) AS linestring_16, t0.distancia AS distancia_17, t0.tiempo AS tiempo_18, t0.dificultad AS dificultad_19, t0.deleted_at AS deleted_at_20, t0.ciudad_id AS ciudad_id_21 FROM ruta t0 WHERE t0.enabled = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\MapController->loadAction (line 49)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 10)

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\PoiTranslation	170
App\Translation\TipoPoiTranslation	45
App\Entity\Poi	21
App\Translation\RutaTranslation	18
App\Entity\TipoPoi	6
App\Entity\Ciudad	3
App\Entity\Ruta	3

Entities Mapping

Class	Mapping errors
App\Entity\Poi	No errors.
App\Entity\Ciudad	No errors.
App\Entity\TipoPoi	No errors.
App\Entity\Ruta	No errors.
App\Entity\VisitaVirtual	No errors.
App\Entity\RutaPersonalizada	No errors.
App\Entity\Imagen	No errors.
App\Entity\ArModel	No errors.
App\Entity\Panoramica	No errors.
App\Entity\Video	No errors.
App\Entity\Recurso	No errors.
App\Entity\Qrcode	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Translation\PoiTranslation	No errors.
App\Translation\RutaTranslation	No errors.
App\Translation\TipoPoiTranslation	No errors.

Symfony Profiler

GET https://rutascsf.mapescador.duckdns.org/es/loadmap

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping