Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

45.26 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

41.51 ms
(91.71%)

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)

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)

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

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 204)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 232)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Sonata\AdminBundle\Controller\CRUDController->createAction (line 645)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

1.90 ms
(4.21%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cif AS cif_3, t0.email AS email_4, t0.password AS password_5, t0.plainpassword AS plainpassword_6, t0.salt AS salt_7, t0.roles AS roles_8, t0.username AS username_9, t0.fullname AS fullname_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.active AS active_13, t0.enabled AS enabled_14, t0."freeze" AS freeze_15, t0.last_login AS last_login_16, t0.owner AS owner_17, t0.confirmation_token AS confirmation_token_18, t0.password_requested_at AS password_requested_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.is_verified AS is_verified_22, t0.gid AS gid_23 FROM usuarios t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.cif AS cif_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.plainpassword AS plainpassword_6,
  t0.salt AS salt_7,
  t0.roles AS roles_8,
  t0.username AS username_9,
  t0.fullname AS fullname_10,
  t0.firstname AS firstname_11,
  t0.lastname AS lastname_12,
  t0.active AS active_13,
  t0.enabled AS enabled_14,
  t0."freeze" AS freeze_15,
  t0.last_login AS last_login_16,
  t0.owner AS owner_17,
  t0.confirmation_token AS confirmation_token_18,
  t0.password_requested_at AS password_requested_at_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.is_verified AS is_verified_22,
  t0.gid AS gid_23
FROM
  usuarios t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cif AS cif_3, t0.email AS email_4, t0.password AS password_5, t0.plainpassword AS plainpassword_6, t0.salt AS salt_7, t0.roles AS roles_8, t0.username AS username_9, t0.fullname AS fullname_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.active AS active_13, t0.enabled AS enabled_14, t0."freeze" AS freeze_15, t0.last_login AS last_login_16, t0.owner AS owner_17, t0.confirmation_token AS confirmation_token_18, t0.password_requested_at AS password_requested_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.is_verified AS is_verified_22, t0.gid AS gid_23 FROM usuarios t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

1.04 ms
(2.29%)

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_.deleted_at IS NULL)

Parameters:

[]

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_.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_.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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 204)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 232)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Sonata\AdminBundle\Controller\CRUDController->createAction (line 645)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.81 ms
(1.80%)

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_

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_

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

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 204)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 232)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Sonata\AdminBundle\Controller\CRUDController->createAction (line 645)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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\Entity\TipoPoi	14
App\Entity\Usuarios	1
App\Entity\Ciudad	1

Entities Mapping

Class	Mapping errors
App\Entity\Usuarios	No errors.
App\Entity\Group	No errors.
App\Entity\RutaPersonalizada	No errors.
App\Entity\Poi	No errors.
App\Entity\Ciudad	No errors.
App\Entity\TipoPoi	No errors.
App\Entity\Ruta	No errors.
App\Entity\Imagen	No errors.
App\Entity\Panoramica	No errors.
App\Entity\Video	No errors.
App\Entity\Recurso	No errors.
App\Entity\Qrcode	No errors.
App\Entity\VisitaVirtual	No errors.
App\Entity\Calendario	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Translation\CiudadTranslation	No errors.
App\Translation\TipoPoiTranslation	No errors.

Symfony Profiler

GET https://agoncillo.mapescador.duckdns.org/es/admin/app/poi/create?tl=es

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping