Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

61.73 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

42.46 ms
(68.79%)

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_.id IN (?)) AND (c0_.deleted_at IS NULL)

Parameters:

[
  "1"
]

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_.id IN (?)
  )
  AND (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_.id IN ('1')) AND (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	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1002)
12	Symfony\Component\Form\Form->submit (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
15	Symfony\Component\Form\Form->handleRequest (line 414)
16	Sonata\AdminBundle\Controller\CRUDController->createAction (line 583)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

11.08 ms
(17.95%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Sonata\DoctrineORMAdminBundle\Model\ModelManager->create (line 82)
4	Sonata\AdminBundle\Admin\AbstractAdmin->create (line 409)
5	Sonata\AdminBundle\Controller\CRUDController->createAction (line 595)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

2.20 ms
(3.57%)

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\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

1.49 ms
(2.41%)

INSERT INTO poi (code, nombre, enabled, disabletranslation, descripcion_corta, descripcion_larga, direccion, telefono, horario, web, localizacion, destacada, position, point, deleted_at, ciudad_id, tipo_poi_id, ruta_id, visitavirtual_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ST_GeographyFromText(?), ?, ?, ?, ?, ?)

Parameters:

[
  "caseta_valdeviguera"
  "Caseta “Valdeviguera”"
  1
  0
  """
    Se sitúa en el Polígono 17, Parcela 10501, Valdevigas, 26160 Agoncillo (La Rioja), con\r\n
    referencia catastral 26002A017105010000EZ.
    """
  """
    Es una pequeña parcela de 51 m2 de uso\r\n
    AGRARIO situada al suroeste del Municipio de Agoncillo en la zona de Valdeviguera y muy\r\n
    cercana al Territorio municipal de Murillo del Río Leza. Está en Suelo No Urbanizable de\r\n
    categoría Valor Agrícola con Protección a Agricultura de Secano. La casilla fue construida en\r\n
    torno a los años 50 aunque entorno a los años 90 se reconstruyo la cubierta.
    """
  null
  null
  null
  null
  "{"address":null,"longitude":"-2.3446316","latitude":"42.4260467"}"
  "_2026_03_03_13_10_502026-03-03_14-10.png"
  1
  "POINT(-2.3446316 42.4260467)"
  null
  1
  13
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO poi (
  code, nombre, enabled, disabletranslation,
  descripcion_corta, descripcion_larga,
  direccion, telefono, horario, web,
  localizacion, destacada, position,
  point, deleted_at, ciudad_id, tipo_poi_id,
  ruta_id, visitavirtual_id
)
VALUES
  (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ST_GeographyFromText(?),
    ?,
    ?,
    ?,
    ?,
    ?
  )

INSERT INTO poi (code, nombre, enabled, disabletranslation, descripcion_corta, descripcion_larga, direccion, telefono, horario, web, localizacion, destacada, position, point, deleted_at, ciudad_id, tipo_poi_id, ruta_id, visitavirtual_id) VALUES ('caseta_valdeviguera', 'Caseta “Valdeviguera”', 1, 0, 'Se sitúa en el Polígono 17, Parcela 10501, Valdevigas, 26160 Agoncillo (La Rioja), con
referencia catastral 26002A017105010000EZ.', 'Es una pequeña parcela de 51 m2 de uso
AGRARIO situada al suroeste del Municipio de Agoncillo en la zona de Valdeviguera y muy
cercana al Territorio municipal de Murillo del Río Leza. Está en Suelo No Urbanizable de
categoría Valor Agrícola con Protección a Agricultura de Secano. La casilla fue construida en
torno a los años 50 aunque entorno a los años 90 se reconstruyo la cubierta.', NULL, NULL, NULL, NULL, '{\"address\":null,\"longitude\":\"-2.3446316\",\"latitude\":\"42.4260467\"}', '_2026_03_03_13_10_502026-03-03_14-10.png', 1, ST_GeographyFromText('POINT(-2.3446316 42.4260467)'), NULL, 1, 13, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	Sonata\DoctrineORMAdminBundle\Model\ModelManager->create (line 82)
7	Sonata\AdminBundle\Admin\AbstractAdmin->create (line 409)
8	Sonata\AdminBundle\Controller\CRUDController->createAction (line 595)
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 5)

1.27 ms
(2.05%)

SELECT MAX(p0_.position) AS sclr_0 FROM poi p0_ WHERE (p0_.ciudad_id = ?) AND (p0_.deleted_at IS NULL) LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(p0_.position) AS sclr_0
FROM
  poi p0_
WHERE
  (p0_.ciudad_id = ?)
  AND (p0_.deleted_at IS NULL)
LIMIT
  1

SELECT MAX(p0_.position) AS sclr_0 FROM poi p0_ WHERE (p0_.ciudad_id = 1) AND (p0_.deleted_at IS NULL) LIMIT 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Gedmo\Sortable\Mapping\Event\Adapter\ORM->getMaxPosition (line 51)
8	Gedmo\Sortable\SortableListener->getMaxPosition (line 663)
9	Gedmo\Sortable\SortableListener->prePersist (line 181)
10	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
12	Doctrine\ORM\UnitOfWork->persistNew (line 915)
13	Doctrine\ORM\UnitOfWork->doPersist (line 1816)
14	Doctrine\ORM\UnitOfWork->persist (line 1774)
15	Doctrine\ORM\EntityManager->persist (line 443)
16	Sonata\DoctrineORMAdminBundle\Model\ModelManager->create (line 81)
17	Sonata\AdminBundle\Admin\AbstractAdmin->create (line 409)
18	Sonata\AdminBundle\Controller\CRUDController->createAction (line 595)
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.03 ms
(1.67%)

UPDATE poi SET position = position + 1 WHERE (position >= 1 AND ciudad_id = ? AND id NOT IN (?)) AND (poi.deleted_at IS NULL)

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  poi
SET
  position = position + 1
WHERE
  (
    position >= 1
    AND ciudad_id = ?
    AND id NOT IN (?)
  )
  AND (poi.deleted_at IS NULL)

UPDATE poi SET position = position + 1 WHERE (position >= 1 AND ciudad_id = 1 AND id NOT IN (11)) AND (poi.deleted_at IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 38)
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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Gedmo\Sortable\Mapping\Event\Adapter\ORM->updatePositions (line 118)
8	Gedmo\Sortable\SortableListener->persistRelocations (line 595)
9	Gedmo\Sortable\SortableListener->postPersist (line 197)
10	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 63)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
12	Doctrine\ORM\UnitOfWork->executeInserts (line 1080)
13	Doctrine\ORM\UnitOfWork->commit (line 403)
14	Doctrine\ORM\EntityManager->flush (line 268)
15	Sonata\DoctrineORMAdminBundle\Model\ModelManager->create (line 82)
16	Sonata\AdminBundle\Admin\AbstractAdmin->create (line 409)
17	Sonata\AdminBundle\Controller\CRUDController->createAction (line 595)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.96 ms
(1.56%)

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.deleted_at AS deleted_at_18, t0.ciudad_id AS ciudad_id_19 FROM ruta t0 WHERE ((t0.deleted_at IS NULL))

Parameters:

[]

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.deleted_at AS deleted_at_18,
  t0.ciudad_id AS ciudad_id_19
FROM
  ruta t0
WHERE
  (
    (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.deleted_at AS deleted_at_18, t0.ciudad_id AS ciudad_id_19 FROM ruta t0 WHERE ((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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Admin\PoiAdmin->prePersist (line 282)
6	Sonata\AdminBundle\Admin\AbstractAdmin->create (line 404)
7	Sonata\AdminBundle\Controller\CRUDController->createAction (line 595)
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.78 ms
(1.27%)

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_ WHERE t0_.id IN (?)

Parameters:

[
  "13"
]

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_
WHERE
  t0_.id IN (?)

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_ WHERE t0_.id IN ('13');

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1002)
12	Symfony\Component\Form\Form->submit (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
15	Symfony\Component\Form\Form->handleRequest (line 414)
16	Sonata\AdminBundle\Controller\CRUDController->createAction (line 583)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

0.45 ms
(0.74%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Sonata\DoctrineORMAdminBundle\Model\ModelManager->create (line 82)
4	Sonata\AdminBundle\Admin\AbstractAdmin->create (line 409)
5	Sonata\AdminBundle\Controller\CRUDController->createAction (line 595)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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\Usuarios	1
App\Entity\Ciudad	1
App\Entity\TipoPoi	1
App\Entity\Poi	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.
App\Translation\PoiTranslation	No errors.

Symfony Profiler

POST https://agoncillo.mapescador.duckdns.org/es/admin/app/poi/create?tl=es&uniqid=s69a6dd857f9d0

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping