Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.host AS host_2,
  t0.puerto AS puerto_3,
  t0.seguridad AS seguridad_4,
  t0.email AS email_5,
  t0.password AS password_6
FROM
  smtp t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_at AS created_at_5,
  t0.nombre AS nombre_6,
  t0.apellidos AS apellidos_7,
  t0.direccion AS direccion_8,
  t0.email AS email_9,
  t0.codigo2_fa AS codigo2_fa_10,
  t0.fecha_aceptacion_terminos AS fecha_aceptacion_terminos_11,
  t0.reset_password_token AS reset_password_token_12,
  t0.reset_password_expires_at AS reset_password_expires_at_13,
  t0.estado2_fa AS estado2_fa_14,
  t0.comunidad_id AS comunidad_id_15,
  t0.provincia_id AS provincia_id_16,
  t0.poblacion_id AS poblacion_id_17
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.nombre AS nombre_6, t0.apellidos AS apellidos_7, t0.direccion AS direccion_8, t0.email AS email_9, t0.codigo2_fa AS codigo2_fa_10, t0.fecha_aceptacion_terminos AS fecha_aceptacion_terminos_11, t0.reset_password_token AS reset_password_token_12, t0.reset_password_expires_at AS reset_password_expires_at_13, t0.estado2_fa AS estado2_fa_14, t0.comunidad_id AS comunidad_id_15, t0.provincia_id AS provincia_id_16, t0.poblacion_id AS poblacion_id_17 FROM usuario t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.role AS role_3
FROM
  role t0
  INNER JOIN usuario_role ON t0.id = usuario_role.role_id
WHERE
  usuario_role.usuario_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.role AS role_3 FROM role t0 INNER JOIN usuario_role ON t0.id = usuario_role.role_id WHERE usuario_role.usuario_id = 5;

SELECT
  r0_.id AS id_0,
  r0_.deleted_at AS deleted_at_1,
  r0_.created_at AS created_at_2,
  r0_.valor_tras_formula AS valor_tras_formula_3,
  r0_.valor_real_alcanzado AS valor_real_alcanzado_4,
  r0_.valor_objetivo AS valor_objetivo_5,
  r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6,
  r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7,
  r0_.valor_homogenizado AS valor_homogenizado_8,
  r0_.semaforizacion AS semaforizacion_9,
  r0_.informacion_adicional AS informacion_adicional_10,
  r0_.observaciones AS observaciones_11,
  r0_.observaciones_validador AS observaciones_validador_12,
  r0_.texto_ivl AS texto_ivl_13,
  r0_.mostrar_ivl AS mostrar_ivl_14,
  r0_.fecha_validado AS fecha_validado_15,
  r0_.estado AS estado_16,
  r0_.anio AS anio_17,
  r0_.path AS path_18,
  r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19,
  r0_.entidad_local_id AS entidad_local_id_20,
  r0_.indicador_id AS indicador_id_21,
  r0_.usuario_id AS usuario_id_22
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  LEFT JOIN meta m2_ ON i1_.meta_id = m2_.id
  LEFT JOIN ods o3_ ON m2_.ods_id = o3_.id
WHERE
  r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND r0_.deleted_at IS NULL
  AND i1_.deleted_at IS NULL
ORDER BY
  o3_.orden ASC,
  m2_.orden ASC,
  i1_.orden ASC

SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id LEFT JOIN meta m2_ ON i1_.meta_id = m2_.id LEFT JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL ORDER BY o3_.orden ASC, m2_.orden ASC, i1_.orden ASC;

SELECT
  i0_.id AS id_0,
  i0_.deleted_at AS deleted_at_1,
  i0_.created_at AS created_at_2,
  i0_.orden AS orden_3,
  i0_.nombre AS nombre_4,
  i0_.territorios AS territorios_5,
  i0_.tendencia_deseada AS tendencia_deseada_6,
  i0_.valor_objetivo AS valor_objetivo_7,
  i0_.justificacion_valor_objetivo AS justificacion_valor_objetivo_8,
  i0_.umbral_minimo_teorico AS umbral_minimo_teorico_9,
  i0_.umbral_maximo_teorico AS umbral_maximo_teorico_10,
  i0_.metodo_obtencion_umbral_teorico AS metodo_obtencion_umbral_teorico_11,
  i0_.metodo_calculo AS metodo_calculo_12,
  i0_.fuentes AS fuentes_13,
  i0_.datos_historicos AS datos_historicos_14,
  i0_.indicador_repetido AS indicador_repetido_15,
  i0_.referencias AS referencias_16,
  i0_.automatizable AS automatizable_17,
  i0_.descripcion AS descripcion_18,
  i0_.set_entity_id AS set_entity_id_19,
  i0_.metodo_obtencion_id AS metodo_obtencion_id_20,
  i0_.periodicidad_publicacion_id AS periodicidad_publicacion_id_21,
  i0_.frecuencia_actualizacion_id AS frecuencia_actualizacion_id_22,
  i0_.unidad_medida_id AS unidad_medida_id_23,
  i0_.tipo_indicador_id AS tipo_indicador_id_24,
  i0_.fuente_valor_objetivo_id AS fuente_valor_objetivo_id_25,
  i0_.objetivo_uae_id AS objetivo_uae_id_26,
  i0_.calculo_id AS calculo_id_27,
  i0_.sub_fuente_valor_objetivo_id AS sub_fuente_valor_objetivo_id_28,
  i0_.meta_id AS meta_id_29
FROM
  indicador i0_
WHERE
  i0_.deleted_at IS NULL
ORDER BY
  i0_.orden ASC

SELECT i0_.id AS id_0, i0_.deleted_at AS deleted_at_1, i0_.created_at AS created_at_2, i0_.orden AS orden_3, i0_.nombre AS nombre_4, i0_.territorios AS territorios_5, i0_.tendencia_deseada AS tendencia_deseada_6, i0_.valor_objetivo AS valor_objetivo_7, i0_.justificacion_valor_objetivo AS justificacion_valor_objetivo_8, i0_.umbral_minimo_teorico AS umbral_minimo_teorico_9, i0_.umbral_maximo_teorico AS umbral_maximo_teorico_10, i0_.metodo_obtencion_umbral_teorico AS metodo_obtencion_umbral_teorico_11, i0_.metodo_calculo AS metodo_calculo_12, i0_.fuentes AS fuentes_13, i0_.datos_historicos AS datos_historicos_14, i0_.indicador_repetido AS indicador_repetido_15, i0_.referencias AS referencias_16, i0_.automatizable AS automatizable_17, i0_.descripcion AS descripcion_18, i0_.set_entity_id AS set_entity_id_19, i0_.metodo_obtencion_id AS metodo_obtencion_id_20, i0_.periodicidad_publicacion_id AS periodicidad_publicacion_id_21, i0_.frecuencia_actualizacion_id AS frecuencia_actualizacion_id_22, i0_.unidad_medida_id AS unidad_medida_id_23, i0_.tipo_indicador_id AS tipo_indicador_id_24, i0_.fuente_valor_objetivo_id AS fuente_valor_objetivo_id_25, i0_.objetivo_uae_id AS objetivo_uae_id_26, i0_.calculo_id AS calculo_id_27, i0_.sub_fuente_valor_objetivo_id AS sub_fuente_valor_objetivo_id_28, i0_.meta_id AS meta_id_29 FROM indicador i0_ WHERE i0_.deleted_at IS NULL ORDER BY i0_.orden ASC;

SELECT
  count(DISTINCT r0_.id) AS sclr_0
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  INNER JOIN meta m2_ ON i1_.meta_id = m2_.id
  INNER JOIN ods o3_ ON m2_.ods_id = o3_.id
WHERE
  r0_.deleted_at IS NULL
  AND i1_.deleted_at IS NULL
  AND r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND i1_.set_entity_id = ?

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL AND r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND i1_.set_entity_id = 2;

SELECT
  DISTINCT r0_.id AS id_0,
  m1_.orden AS orden_1,
  o2_.orden AS orden_2,
  i3_.orden AS orden_3
FROM
  resultado r0_
  INNER JOIN indicador i3_ ON r0_.indicador_id = i3_.id
  INNER JOIN meta m1_ ON i3_.meta_id = m1_.id
  INNER JOIN ods o2_ ON m1_.ods_id = o2_.id
WHERE
  r0_.deleted_at IS NULL
  AND i3_.deleted_at IS NULL
  AND r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND i3_.set_entity_id = ?
ORDER BY
  m1_.orden ASC,
  o2_.orden ASC,
  i3_.orden ASC
LIMIT
  15

SELECT DISTINCT r0_.id AS id_0, m1_.orden AS orden_1, o2_.orden AS orden_2, i3_.orden AS orden_3 FROM resultado r0_ INNER JOIN indicador i3_ ON r0_.indicador_id = i3_.id INNER JOIN meta m1_ ON i3_.meta_id = m1_.id INNER JOIN ods o2_ ON m1_.ods_id = o2_.id WHERE r0_.deleted_at IS NULL AND i3_.deleted_at IS NULL AND r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND i3_.set_entity_id = 2 ORDER BY m1_.orden ASC, o2_.orden ASC, i3_.orden ASC LIMIT 15;

SELECT
  r0_.id AS id_0,
  r0_.deleted_at AS deleted_at_1,
  r0_.created_at AS created_at_2,
  r0_.valor_tras_formula AS valor_tras_formula_3,
  r0_.valor_real_alcanzado AS valor_real_alcanzado_4,
  r0_.valor_objetivo AS valor_objetivo_5,
  r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6,
  r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7,
  r0_.valor_homogenizado AS valor_homogenizado_8,
  r0_.semaforizacion AS semaforizacion_9,
  r0_.informacion_adicional AS informacion_adicional_10,
  r0_.observaciones AS observaciones_11,
  r0_.observaciones_validador AS observaciones_validador_12,
  r0_.texto_ivl AS texto_ivl_13,
  r0_.mostrar_ivl AS mostrar_ivl_14,
  r0_.fecha_validado AS fecha_validado_15,
  r0_.estado AS estado_16,
  r0_.anio AS anio_17,
  r0_.path AS path_18,
  r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19,
  r0_.entidad_local_id AS entidad_local_id_20,
  r0_.indicador_id AS indicador_id_21,
  r0_.usuario_id AS usuario_id_22
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  INNER JOIN meta m2_ ON i1_.meta_id = m2_.id
  INNER JOIN ods o3_ ON m2_.ods_id = o3_.id
WHERE
  r0_.deleted_at IS NULL
  AND i1_.deleted_at IS NULL
  AND r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND i1_.set_entity_id = ?
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  m2_.orden ASC,
  o3_.orden ASC,
  i1_.orden ASC

SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL AND r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND i1_.set_entity_id = 2 AND r0_.id IN (5909, 5910, 5911, 5912, 5913, 5914, 5915, 5916, 5917, 6677, 5919, 5920, 5921, 6688, 5923) ORDER BY m2_.orden ASC, o3_.orden ASC, i1_.orden ASC;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.color AS color_6,
  t0.path_ivl AS path_ivl_7
FROM
  ods t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.color AS color_6, t0.path_ivl AS path_ivl_7 FROM ods t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.color AS color_6,
  t0.path_ivl AS path_ivl_7
FROM
  ods t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.color AS color_6, t0.path_ivl AS path_ivl_7 FROM ods t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.color AS color_6,
  t0.path_ivl AS path_ivl_7
FROM
  ods t0
WHERE
  t0.id = ?