Symfony Profiler

Query Metrics

212 Database Queries

16 Different statements

124.85 ms Query time

0 Invalid entities

608 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

43.10 ms
(34.53%)

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.nombre AS nombre_2, r0_.enabled AS enabled_3, r0_.disabletranslation AS disabletranslation_4, r0_.color AS color_5, r0_.descripcion_corta AS descripcion_corta_6, r0_.descripcion_larga AS descripcion_larga_7, r0_.folleto AS folleto_8, r0_.folleto_url AS folleto_url_9, r0_.folletopdf AS folletopdf_10, r0_.folletopdf_url AS folletopdf_url_11, r0_.geojson AS geojson_12, r0_.destacada AS destacada_13, r0_.position AS position_14, ST_AsEWKT(r0_.linestring) AS linestring_15, r0_.distancia AS distancia_16, r0_.deleted_at AS deleted_at_17, r0_.ciudad_id AS ciudad_id_18 FROM ruta r0_ WHERE (r0_.code = ? AND r0_.enabled = true) AND (r0_.deleted_at IS NULL)

Parameters:

[
  "rutascsfburgos"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.nombre AS nombre_2,
  r0_.enabled AS enabled_3,
  r0_.disabletranslation AS disabletranslation_4,
  r0_.color AS color_5,
  r0_.descripcion_corta AS descripcion_corta_6,
  r0_.descripcion_larga AS descripcion_larga_7,
  r0_.folleto AS folleto_8,
  r0_.folleto_url AS folleto_url_9,
  r0_.folletopdf AS folletopdf_10,
  r0_.folletopdf_url AS folletopdf_url_11,
  r0_.geojson AS geojson_12,
  r0_.destacada AS destacada_13,
  r0_.position AS position_14,
  ST_AsEWKT(r0_.linestring) AS linestring_15,
  r0_.distancia AS distancia_16,
  r0_.deleted_at AS deleted_at_17,
  r0_.ciudad_id AS ciudad_id_18
FROM
  ruta r0_
WHERE
  (
    r0_.code = ?
    AND r0_.enabled = true
  )
  AND (r0_.deleted_at IS NULL)

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.nombre AS nombre_2, r0_.enabled AS enabled_3, r0_.disabletranslation AS disabletranslation_4, r0_.color AS color_5, r0_.descripcion_corta AS descripcion_corta_6, r0_.descripcion_larga AS descripcion_larga_7, r0_.folleto AS folleto_8, r0_.folleto_url AS folleto_url_9, r0_.folletopdf AS folletopdf_10, r0_.folletopdf_url AS folletopdf_url_11, r0_.geojson AS geojson_12, r0_.destacada AS destacada_13, r0_.position AS position_14, ST_AsEWKT(r0_.linestring) AS linestring_15, r0_.distancia AS distancia_16, r0_.deleted_at AS deleted_at_17, r0_.ciudad_id AS ciudad_id_18 FROM ruta r0_ WHERE (r0_.code = 'rutascsfburgos' AND r0_.enabled = true) AND (r0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->rutadetalle (line 503)
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)

17.66 ms
(14.14%)

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 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
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 3203)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1005)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1016)
17	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
18	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
19	Doctrine\ORM\PersistentCollection->initialize (line 186)
20	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
21	App\Controller\HomePageController->rutadetalle (line 516)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

13.14 ms
(10.53%)

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = ? AND p0_.locale = ? AND p0_.field = 'descripcionCorta' ORDER BY p0_.id DESC

Parameters:

[
  158
  "es"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionCorta'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 158 AND p0_.locale = 'es' AND p0_.field = 'descripcionCorta' ORDER BY p0_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->rutadetalle (line 520)
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)

12.99 ms
(10.41%)

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = ? AND p0_.locale = ? AND p0_.field = 'descripcionLarga' ORDER BY p0_.id DESC

Parameters:

[
  158
  "es"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionLarga'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 158 AND p0_.locale = 'es' AND p0_.field = 'descripcionLarga' ORDER BY p0_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->rutadetalle (line 527)
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)

8.22 ms
(6.58%)

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:

[
  2
  "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 = 2 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->getMenu (line 33)
7	App\Controller\HomePageController->rutadetalle (line 533)
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)

8.16 ms
(6.53%)

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:

[
  2
]

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
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 3203)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
16	Doctrine\ORM\AbstractQuery->execute (line 891)
17	Doctrine\ORM\AbstractQuery->getResult (line 689)
18	App\Controller\HomePageController->getMenu (line 28)
19	App\Controller\HomePageController->rutadetalle (line 533)
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)

6.45 ms
(5.16%)

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 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
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 3203)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 748)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
17	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
18	Proxies\__CG__\App\Entity\TipoPoi::Doctrine\ORM\Proxy\{closure} (line 367)
19	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
20	Proxies\__CG__\App\Entity\TipoPoi->__get (line 129)
21	App\Entity\TipoPoi->getCode (line 214)
22	Twig\Extension\CoreExtension->getAttribute (line 1909)
23	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3::block_services (line 399)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_83b84b0d6ec8b55ca6cdfaf2af8432b7->doDisplay (line 403)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3->doDisplay (line 59)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
36	App\Controller\HomePageController->rutadetalle (line 538)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 182)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
41	require_once (line 29)
42	require_once (line 5)

4.15 ms
(3.33%)

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 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\TipoPoi::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\TipoPoi->__get (line 129)
7	App\Entity\TipoPoi->getCode (line 214)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3::block_services (line 399)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_83b84b0d6ec8b55ca6cdfaf2af8432b7->doDisplay (line 403)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3->doDisplay (line 59)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\HomePageController->rutadetalle (line 538)
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 5)

3.00 ms
(2.40%)

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.direccion AS direccion_8, t0.telefono AS telefono_9, t0.horario AS horario_10, t0.web AS web_11, t0.localizacion AS localizacion_12, t0.destacada AS destacada_13, t0.position AS position_14, ST_AsEWKT(t0.point) AS point_15, t0.deleted_at AS deleted_at_16, t0.ciudad_id AS ciudad_id_17, t0.tipo_poi_id AS tipo_poi_id_18, t0.ruta_id AS ruta_id_19, t0.visitavirtual_id AS visitavirtual_id_20 FROM poi t0 INNER JOIN pois_rutas ON t0.id = pois_rutas.poi_id WHERE pois_rutas.ruta_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  7
]

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.direccion AS direccion_8,
  t0.telefono AS telefono_9,
  t0.horario AS horario_10,
  t0.web AS web_11,
  t0.localizacion AS localizacion_12,
  t0.destacada AS destacada_13,
  t0.position AS position_14,
  ST_AsEWKT(t0.point) AS point_15,
  t0.deleted_at AS deleted_at_16,
  t0.ciudad_id AS ciudad_id_17,
  t0.tipo_poi_id AS tipo_poi_id_18,
  t0.ruta_id AS ruta_id_19,
  t0.visitavirtual_id AS visitavirtual_id_20
FROM
  poi t0
  INNER JOIN pois_rutas ON t0.id = pois_rutas.poi_id
WHERE
  pois_rutas.ruta_id = ?
  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.direccion AS direccion_8, t0.telefono AS telefono_9, t0.horario AS horario_10, t0.web AS web_11, t0.localizacion AS localizacion_12, t0.destacada AS destacada_13, t0.position AS position_14, ST_AsEWKT(t0.point) AS point_15, t0.deleted_at AS deleted_at_16, t0.ciudad_id AS ciudad_id_17, t0.tipo_poi_id AS tipo_poi_id_18, t0.ruta_id AS ruta_id_19, t0.visitavirtual_id AS visitavirtual_id_20 FROM poi t0 INNER JOIN pois_rutas ON t0.id = pois_rutas.poi_id WHERE pois_rutas.ruta_id = 7 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Controller\HomePageController->rutadetalle (line 516)
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)

2.05 ms
(1.64%)

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:

[
  2
]

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Entity\Frontmenu->hasChildren (line 158)
9	App\Controller\HomePageController->getMenu (line 35)
10	App\Controller\HomePageController->rutadetalle (line 533)
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)

1.49 ms
(1.20%)

SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionCorta' ORDER BY r0_.id DESC

Parameters:

[
  7
  "es"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.locale AS locale_1,
  r0_.field AS field_2,
  r0_.content AS content_3,
  r0_.object_id AS object_id_4
FROM
  ruta_translations r0_
WHERE
  r0_.object_id = ?
  AND r0_.locale = ?
  AND r0_.field = 'descripcionCorta'
ORDER BY
  r0_.id DESC

SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = 7 AND r0_.locale = 'es' AND r0_.field = 'descripcionCorta' ORDER BY r0_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->rutadetalle (line 509)
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.91%)

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:

[
  7
]

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
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 3203)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 173)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
16	Doctrine\ORM\AbstractQuery->execute (line 891)
17	Doctrine\ORM\AbstractQuery->getResult (line 689)
18	App\Controller\HomePageController->rutadetalle (line 503)
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)

0.98 ms
(0.79%)

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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->getMenu (line 28)
7	App\Controller\HomePageController->rutadetalle (line 533)
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.92 ms
(0.73%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.ruta_archivo AS ruta_archivo_4, t0.updated AS updated_5, t0.ciudad_id AS ciudad_id_6, t0.ruta_id AS ruta_id_7, t0.poi_id AS poi_id_8, t0.calendario_id AS calendario_id_9 FROM imagen t0 WHERE t0.ruta_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.ruta_archivo AS ruta_archivo_4,
  t0.updated AS updated_5,
  t0.ciudad_id AS ciudad_id_6,
  t0.ruta_id AS ruta_id_7,
  t0.poi_id AS poi_id_8,
  t0.calendario_id AS calendario_id_9
FROM
  imagen t0
WHERE
  t0.ruta_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.ruta_archivo AS ruta_archivo_4, t0.updated AS updated_5, t0.ciudad_id AS ciudad_id_6, t0.ruta_id AS ruta_id_7, t0.poi_id AS poi_id_8, t0.calendario_id AS calendario_id_9 FROM imagen t0 WHERE t0.ruta_id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3->block_modals (line 558)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_83b84b0d6ec8b55ca6cdfaf2af8432b7->doDisplay (line 493)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3->doDisplay (line 59)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\HomePageController->rutadetalle (line 538)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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.85 ms
(0.68%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.ruta_archivo AS ruta_archivo_4, t0.updated AS updated_5, t0.ciudad_id AS ciudad_id_6, t0.ruta_id AS ruta_id_7, t0.poi_id AS poi_id_8, t0.calendario_id AS calendario_id_9 FROM recurso t0 WHERE t0.ruta_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.ruta_archivo AS ruta_archivo_4,
  t0.updated AS updated_5,
  t0.ciudad_id AS ciudad_id_6,
  t0.ruta_id AS ruta_id_7,
  t0.poi_id AS poi_id_8,
  t0.calendario_id AS calendario_id_9
FROM
  recurso t0
WHERE
  t0.ruta_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.ruta_archivo AS ruta_archivo_4, t0.updated AS updated_5, t0.ciudad_id AS ciudad_id_6, t0.ruta_id AS ruta_id_7, t0.poi_id AS poi_id_8, t0.calendario_id AS calendario_id_9 FROM recurso t0 WHERE t0.ruta_id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3::block_services (line 461)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_83b84b0d6ec8b55ca6cdfaf2af8432b7->doDisplay (line 403)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_04241f30eae7c963ddbc63e0e80dd6c3->doDisplay (line 59)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\HomePageController->rutadetalle (line 538)
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 5)

0.55 ms
(0.44%)

SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionLarga' ORDER BY r0_.id DESC

Parameters:

[
  7
  "es"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.locale AS locale_1,
  r0_.field AS field_2,
  r0_.content AS content_3,
  r0_.object_id AS object_id_4
FROM
  ruta_translations r0_
WHERE
  r0_.object_id = ?
  AND r0_.locale = ?
  AND r0_.field = 'descripcionLarga'
ORDER BY
  r0_.id DESC

SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = 7 AND r0_.locale = 'es' AND r0_.field = 'descripcionLarga' ORDER BY r0_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\HomePageController->rutadetalle (line 514)
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
App\Translation\PoiTranslation	352
App\Translation\FrontmenuTranslation	96
App\Translation\TipoPoiTranslation	73
App\Entity\Poi	43
App\Entity\Frontmenu	24
App\Entity\TipoPoi	10
App\Translation\RutaTranslation	6
App\Entity\Imagen	2
App\Entity\Ruta	1
App\Entity\Ciudad	1

Entities Mapping

Class	Mapping errors
App\Entity\Ruta	No errors.
App\Entity\Ciudad	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\VisitaVirtual	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Translation\RutaTranslation	No errors.
App\Entity\TipoPoi	No errors.
App\Entity\RutaPersonalizada	No errors.
App\Translation\PoiTranslation	No errors.
App\Entity\Frontmenu	No errors.
App\Translation\FrontmenuTranslation	No errors.
App\Translation\TipoPoiTranslation	No errors.
App\Entity\Calendario	No errors.
App\Translation\CiudadTranslation	No errors.
App\Entity\PanoramicaPositions	No errors.
App\Entity\Usuarios	No errors.
App\Translation\RutaPersonalizadaTranslation	No errors.
App\Entity\CalendarioTipos	No errors.
App\Translation\CalendarioTranslation	No errors.
App\Entity\TipoPanoramicaPositions	No errors.
App\Entity\Group	No errors.
App\Translation\CalendarioTiposTranslation	No errors.

Symfony Profiler

GET https://rutascsf.mapescador.duckdns.org/es/rutas/rutascsfburgos

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping