Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

81.26 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

78.27 ms
(96.33%)

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.code = ? AND t0.enabled = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "parque_las_fuentes"
  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.code = ?
  AND 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.code = 'parque_las_fuentes' AND 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->loaddetalleAction (line 110)
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 5)

1.20 ms
(1.48%)

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:

[
  18
]

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 = 18;

#	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\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->loaddetalleAction (line 110)
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 5)

1.07 ms
(1.31%)

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.code = ? AND t0.enabled = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "parque_las_fuentes"
  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.code = ?
  AND 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.code = 'parque_las_fuentes' AND 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->loaddetalleAction (line 111)
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 5)

0.71 ms
(0.88%)

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.descripcion_corta AS descripcion_corta_6, t0.descripcion_larga AS descripcion_larga_7, t0.destacada AS destacada_8, t0.localizacion AS localizacion_9, t0.position AS position_10, ST_AsEWKT(t0.point) AS point_11, t0.deleted_at AS deleted_at_12 FROM ciudad t0 WHERE t0.code = ? AND t0.enabled = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "parque_las_fuentes"
  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.descripcion_corta AS descripcion_corta_6,
  t0.descripcion_larga AS descripcion_larga_7,
  t0.destacada AS destacada_8,
  t0.localizacion AS localizacion_9,
  t0.position AS position_10,
  ST_AsEWKT(t0.point) AS point_11,
  t0.deleted_at AS deleted_at_12
FROM
  ciudad t0
WHERE
  t0.code = ?
  AND 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.descripcion_corta AS descripcion_corta_6, t0.descripcion_larga AS descripcion_larga_7, t0.destacada AS destacada_8, t0.localizacion AS localizacion_9, t0.position AS position_10, ST_AsEWKT(t0.point) AS point_11, t0.deleted_at AS deleted_at_12 FROM ciudad t0 WHERE t0.code = 'parque_las_fuentes' AND 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->loaddetalleAction (line 112)
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 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\PoiTranslation	6
App\Entity\Poi	1
App\Entity\Ciudad	1
App\Entity\TipoPoi	1

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\Entity\Calendario	No errors.
App\Translation\CiudadTranslation	No errors.
App\Translation\TipoPoiTranslation	No errors.
App\Translation\RutaTranslation	No errors.
App\Entity\PanoramicaPositions	No errors.
App\Entity\Usuarios	No errors.
App\Translation\RutaPersonalizadaTranslation	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping