Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 54
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Emails
• Serializer
• Blocks 0
• Configuration

Query Metrics

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
]

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;

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)

[
  "1"
]

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

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"
]

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

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

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 MAX(p0_.position) AS sclr_0 FROM poi p0_ WHERE (p0_.ciudad_id = ?) AND (p0_.deleted_at IS NULL) LIMIT 1

[
  1
]

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;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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(?), ?, ?, ?, ?, ?)

[
  "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
]

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

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

[
  1
  11
]

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

"COMMIT"

[]

"COMMIT"

"COMMIT";